You are here: Home / Resources / Browse Resources

Open. Adaptable. Free.

Resources created by our members and partners.

The QUBES platform hosts hundreds of teaching materials, reference materials, and cloud-based software free to use and adapt using open Creative Commons licenses.

Text Search:
Applied Filters
    Pharmacokinetics
    This Excel module explores how drugs are processed and absorbed in the human body.

    Keywords: drug metabolismpharmacokinetics

    64

    views

    36

    downloads

    0

    comments

    0

    adaptations

    COVID-19 Model
    This Excel worksheet implements an SEAIHRD model for Covid-19 (Susceptible, Exposed, Asymptomatic infective, symptomatic Infective, Hospitalized infective, Recovered, Deceased).

    Keywords: infectious diseaseCOVID19

    184

    views

    26

    downloads

    0

    comments

    0

    adaptations

    3-017-StackedCoffeeFiltersFalling-ModelingScenario
    Data on free falling 2, 4, 6, and 8 stacked coffee filters is offered. Students form a model using a resistance term proportional to velocity, velocity squared, or velocity to some general power....

    Keywords: dataresistancefalling bodycoffee filterstacked

    321

    views

    260

    downloads

    0

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets

    Keywords: modelinginfectious diseaseInfectious Disease ModelingSIR modelsSIR

    4005

    views

    3323

    downloads

    0

    comments

    0

    adaptations

    Hidden Markov Model
    Hidden Markov models are a set of mathematical tools that can be used to draw inferences about genomic and evolutionary processes.

    Keywords: hidden markov models

    69

    views

    13

    downloads

    0

    comments

    0

    adaptations

    Dynamic Programming
    In bioinformatics, dynamic programming is mainly used to align nucleotide and amino acid sequences, and to predict RNA and protein folding from primary sequence data.

    Keywords: RNAamino acid sequenceSequence alignmentdynamic programmingprotein folding

    72

    views

    41

    downloads

    0

    comments

    0

    adaptations

    Deme 2.0
    This workbook simulates the population genetics of a single gene with two alleles. It can simultaneously model up to three local populations, which may differ in their selection coefficients.

    Keywords: population geneticsGenetic DriftNatural Selection

    80

    views

    62

    downloads

    0

    comments

    0

    adaptations

    Biodiversity
    Biodiversity allows the diversity of a biological population to be estimated with both the Shannon and Simpson biodiversity indices based on information theory.

    Keywords: Shannon diversity indexSimpson diversity indexBiodiversity indicesInformation theory

    92

    views

    40

    downloads

    0

    comments

    0

    adaptations

    A Beginner's Guide To Sampling Rockpools
    In this guide, we'll teach you how to sample rockpools, collect data, make visuals from data, and interpret data in order to see if any correlations exist.

    Keywords: aquatic macroinvertebratesdata collectionsrockpoolsampling

    448

    views

    532

    downloads

    0

    comments

    0

    adaptations

    RAT ATTACK! Population growth
    This module contains exercises focused on the use and interpretation of density independent and density dependent population growth models. Students build logistic and exponential growth models in...

    Keywords: modelingecologyExcelintroductory biologygraphingQuantitative reasoningdata visualizationinterdisciplinaryexponential growthlogistic growthdata managementInterpreting Graphspopulation modelingNIQBC2. Data and GraphsC4. mathematical modelsnonlinear models

    628

    views

    816

    downloads

    0

    comments

    0

    adaptations

    6-025-WhalesAndKrill-ModelingScenario
    Students will use Excel to observe qualitative behavior in a simulation of a predator-prey model, with blue whales and krill as the predator and prey populations, respectively.

    Keywords: krillwhalepredatpr-prey

    333

    views

    1168

    downloads

    0

    comments

    0

    adaptations

    Protein Analysis
    This Excel workbook allows the analysis of sample or imported protein sequences. The model can analyze protein sequences up to 500 amino acids long.

    Keywords: Protein sequencehydrophobicity/hydrophilicity

    77

    views

    45

    downloads

    0

    comments

    0

    adaptations

    1-031-CoolIt-ModelingScenario
    We offer data on the temperature of water in a beaker in a room of constant temperature and in a room of nonconstant temperature. Students consider both empirical and analytic modeling...

    Keywords: SpanishNewton's Law of Coolingcooling

    260

    views

    466

    downloads

    0

    comments

    0

    adaptations

    2011-Kurt_Kreith-The Mathematics of Global Change
    The authors discuss broad issues and then focus on specifics like exponential growth, logistic growth, and the logistic equation with delay.

    Keywords: exponential growthlogistic growth

    142

    views

    46

    downloads

    0

    comments

    0

    adaptations

    1-089-SpreadOfDisease-ModelingScenario
    In this project I want to use the algebra based concept “difference quotient” to solve differential equations models with the help of Excel. That means even students with only a College Algebra...

    Keywords: SIR modelProportionderivativedifference quotientSleeping Beautycontagious disease

    257

    views

    123

    downloads

    0

    comments

    0

    adaptations

    Comparing Primary and Secondary Forest in a Preserve in Plano Texas: A Forest Ecology Course-based Undergraduate Research Experience (CURE) for Non-Majors and Lower-Level Majors
    An activity that can be conducted as an online or field exercise in which students develop and test their hypotheses about how forest stand characteristics differ between two forest types.

    Keywords: forest ecologyecologycourse-based undergraduate research experienceUsing Excel

    2003

    views

    599

    downloads

    4

    comments

    0

    adaptations

    Cleaning Biodiversity Data: Excel
    Access and clean an open source polar bear dataset using Excel.

    Keywords: data in the classroombiodiversity informaticsData cleaning

    2695

    views

    958

    downloads

    0

    comments

    1

    adaptations

    Processes that Regulate Patterns of Species and Genetic Diversity - Intro Environmental Science
    This activity was adapted for use in an intro non-majors Environmental Science course, with an emphasis on collaborative data collection.

    Keywords: data analysisGenetic Driftquantitative skillsspecies diversityIsland biogeographygamificationgenetic diversityecological driftcolonizationcollaborative data collection

    1410

    views

    1575

    downloads

    0

    comments

    0

    adaptations

    Birthday Problem and Class Phenotypic Probabilities
    An Excel workbook exploring two related applications, the Birthday Problem and Class Phenotypic Probabilities. Students enter their own phenotypes into the workbook.

    Keywords: phenotypic probabilityallelic frequency

    1175

    views

    239

    downloads

    0

    comments

    0

    adaptations

    Circle Train Math Modeling Task
    This math modeling task is appropriate for high school Precalculus students. The students use their knowledge of transformations of trigonometric functions to create models for horizontal and...

    Keywords: mathematical modelTrigonometric Functionsparametric equationstransformations of functions

    1038

    views

    352

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search