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
    Two-Species Model
    These two Excel worksheets simulate the population growth of two interacting species. In isolation, each species grows logistically, but interaction effects between species may limit or enhance...

    Keywords: population growthcompetition modelsLotka-Volterra

    4

    views

    0

    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

    5

    views

    0

    downloads

    0

    comments

    0

    adaptations

    Pharmacokinetics
    This Excel module explores how drugs are processed and absorbed in the human body.

    Keywords: drug metabolismpharmacokinetics

    14

    views

    5

    downloads

    0

    comments

    0

    adaptations

    Linkage Analysis
    This Excel workbook simulates a linkage analysis problem with up to four alleles. Based on the offspring produced by a multihybrid testcross, the user builds a model of the gene order,...

    Keywords: recombinationlinkage analysis

    25

    views

    3

    downloads

    0

    comments

    0

    adaptations

    Leslie/Lefkovitch Matrix Models for Age or Stage-structured Populations
    This Excel workbook uses the Leslie matrix model for population projection of age-class structured populations, and also allows Lefkovitch matrix models for stage-class structured populations.

    Keywords: survivalpopulation ecologyfecundityLeslie matrixeigenvalueseigenvectorsLefkovitch matrixage-class structured populationsstage-class structured populationsreproductive value

    34

    views

    14

    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

    13

    views

    0

    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

    17

    views

    3

    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

    23

    views

    4

    downloads

    0

    comments

    0

    adaptations

    Continuous Growth Models
    This Excel worksheet compares user-input growth data with predictions under linear, exponential, and logistic models of growth. Introduces concepts of statistical analysis that can be additionally...

    Keywords: exponential growthlogistic growthcurve fittinglinear growthgrowth models

    6

    views

    0

    downloads

    0

    comments

    0

    adaptations

    Biological Cellular Automata Laboratory (BioCA Lab)
    This Excel module includes both linear cellular automata and 2D cellular automata. The original 3 rules for survival, death, and birth are implemented in this module, but users with some Excel...

    Keywords: cellular automata

    27

    views

    4

    downloads

    0

    comments

    0

    adaptations

    Luria-Delbruck
    These two workbooks model the evolution of phage resistance in a bacterial population under two alternative hypotheses.

    Keywords: phageLuria-Delbruckresistance

    1459

    views

    233

    downloads

    2

    comments

    0

    adaptations

    Michaelis-Menten Enzyme Kinetics
    In this simulation, equations used in enzyme kinetics (Michaelis-Menten, Eadie-Hofstee, Dixon, and Lineweaver-Burk) are modeled under various conditions.

    Keywords: Michaelis-Mentenenzymesenzyme kinetics

    1535

    views

    339

    downloads

    0

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets

    Keywords: modelinginfectious diseaseInfectious Disease ModelingSIR modelsSIR

    3894

    views

    3291

    downloads

    0

    comments

    0

    adaptations

    Defining Life: Exploring Creativity, Scientific Discovery, and Biology Core Concepts in a Disciplinary First-Year Seminar
    This unit, Defining Life, engages students in thinking like scientists, applying creativity to science, and learning biology core concepts as they explore the defining characteristics of life. This...

    Keywords: Evolutionbiologycellprocess of science

    858

    views

    18

    downloads

    0

    comments

    0

    adaptations

    3-052-OptimalProjectileFiring-ModelingScenario
    We offer the opportunity to model a projectile's trajectory in several cases, all without resistance.

    Keywords: projectile motionprojectilelaunch anglemaximum range

    129

    views

    39

    downloads

    0

    comments

    0

    adaptations

    A Structured Inquiry-Based Module for the Undergraduate Cell Biology Laboratory That Teaches Fundamental Concepts of Cell Differentiation
    Pedagogical research in science education has shown that students effectively learn science by doing science. As a result, there is increased interest in bringing research-like experiences into the...

    Keywords: fluorescence microscopygene expressionpolymerase chain reactionCell Structurecell culturewestern blottingdifferentiationreverse transcription

    699

    views

    22

    downloads

    0

    comments

    0

    adaptations

    Morphological identification of mosquitoes through microscopic observation
    Scientific research is integrated into various stages of student learning, but hands-on involvement in the research process typically begins at the university level. This module aims to engage high...

    Keywords: modulebiologyproject based learningmosquitoScientific researchMicroscope usedigital accessibility

    238

    views

    151

    downloads

    0

    comments

    0

    adaptations

    1-144-HeatCool-ModelingScenario
    We offer an opportunity to build a mathematical model using Newton's Law of Cooling for a closed plastic baggie of liquid inside a liquid container.

    Keywords: temperatureNewton's Law of Coolingcooling

    120

    views

    43

    downloads

    0

    comments

    0

    adaptations

    Navigating Bacterial Changes in Aging Organisms: Graphs, Patterns, and Models
    Aging is an incredibly important area of research, and recent biological advances implicate the intestines in aging pathologies. Given that the gut harbors an immense amount of an organism’s...

    Keywords: statisticsgraphingmathematics for life sciencesmathexponential growthPrecalculus

    133

    views

    46

    downloads

    0

    comments

    0

    adaptations

    1-131-CaffeineElimination-ModelingScenario
    We model the concentration of caffeine eliminated from the human body at a rate proportional to the concentration. This is a ``first-order reaction'' in the language of pharmacokinetics -- the...

    Keywords: caffeineeliminationpharmacokineticsdrug

    175

    views

    47

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search