Skip to Main Content
Powered by QUBES

ESTEEM

Resources

Want to find additional resources? Browse resources on QUBES!
QUBES hosts not only the resources shown here, but many more created by the broader QUBES community.
Text Search:
Applied Filters
    Serial Dilutions
    In this Excel workbook, users will enter the original cell concentration and the desired dilution factor (10, 100, and 1000). The program will then calculate the new cell concentration.

    Keywords: concentrationScientific Notationorders of magnitudeserial dilutions

    114

    views

    51

    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

    1587

    views

    303

    downloads

    2

    comments

    0

    adaptations

    Island Biogeography
    This Excel workbook demonstrates the principles of the MacArthur-Wilson theory of Island Biogeography. It allows the user to define the mainland species pool, area of the island, and distance of...

    Keywords: Logarithmsspecies richnessIsland biogeographyExponential FunctionsMacArthur-Wilson Theorypower functions

    111

    views

    17

    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

    95

    views

    32

    downloads

    0

    comments

    0

    adaptations

    Mark-Recapture
    A common method used to estimate the population size of a species is the Mark-Recapture method.

    Keywords: mark-recapture analysispopulation estimation

    81

    views

    38

    downloads

    0

    comments

    0

    adaptations

    DeFinetti 1.0
    This Excel workbook simulates evolution of a single gene with three alleles. The user assigns fitness values to each of the six possible genotypes, then enters starting allele frequencies for each...

    Keywords: population geneticsallelesevolutionary fitness

    93

    views

    43

    downloads

    0

    comments

    0

    adaptations

    ABO Blood Group Frequencies
    An Excel workbook in which students can calculate blood type frequencies through different approaches (Hardy-Weinberg, quadratic formula, and the EM algorithm). The workbook shows the formulas...

    Keywords: Hardy-Weinbergblood type frequencies

    1570

    views

    333

    downloads

    0

    comments

    0

    adaptations

    Evolution Through Natural Selection
    This Excel workbook simulates the population genetics of a single gene with two alleles, allowing the user to set the initial allele frequencies and enter parameters for a variety of different...

    Keywords: population geneticsNatural Selection

    105

    views

    44

    downloads

    0

    comments

    0

    adaptations

    3D FractaL-Tree
    3D FractaL-Tree allows scientists to collect data from actual specimens in the field or laboratory, insert these measurements into a spatially explicit L-system package, and then visually compare...

    Keywords: fractalsL-systems

    1274

    views

    290

    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

    109

    views

    61

    downloads

    0

    comments

    0

    adaptations

    Database Construction and Sampling
    Creating your own database is an excellent way for students to learn the trials and tribulations of data collection and management. Construction of three simple databases using a spreadsheet is...

    Keywords: databasesdata managementdata collectiondata ethicsdata integrity

    134

    views

    92

    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

    182

    views

    116

    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

    180

    views

    80

    downloads

    0

    comments

    0

    adaptations

    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

    149

    views

    59

    downloads

    0

    comments

    0

    adaptations

    Phylogeography Simulator
    This Excel workbook simulates the phylogeography of an asexually reproducing species.

    Keywords: Phylogeographymutation ratesAsexual reproductionspecies dispersal

    86

    views

    13

    downloads

    0

    comments

    0

    adaptations

    Genetic Code
    This Excel workbook allows the user to recreate the steps in breaking the genetic code. The user enters the sequence of repetitive synthetic mRNA strands, which are translated in vitro to produce...

    Keywords: mRNAgenetic code

    109

    views

    34

    downloads

    0

    comments

    0

    adaptations

    EvolSeq
    An Excel worksheet that simulates the molecular evolution of DNA sequences.

    Keywords: molecular evolutionDNA

    1388

    views

    314

    downloads

    0

    comments

    0

    adaptations

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

    Keywords: drug metabolismpharmacokinetics

    90

    views

    55

    downloads

    0

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets

    Keywords: modelinginfectious diseaseInfectious Disease ModelingSIR modelsSIR

    4107

    views

    3392

    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

    82

    views

    16

    downloads

    0

    comments

    0

    adaptations