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

    75

    views

    47

    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

    202

    views

    29

    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

    332

    views

    268

    downloads

    0

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets

    Keywords: modelinginfectious diseaseInfectious Disease ModelingSIR modelsSIR

    4066

    views

    3377

    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

    76

    views

    16

    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

    84

    views

    47

    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

    90

    views

    69

    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

    99

    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

    455

    views

    534

    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

    645

    views

    834

    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

    337

    views

    1169

    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

    90

    views

    48

    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

    264

    views

    468

    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

    145

    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

    269

    views

    127

    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

    2011

    views

    606

    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

    2726

    views

    973

    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

    1419

    views

    1592

    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

    1188

    views

    241

    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

    1048

    views

    366

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search