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
    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

    138

    views

    48

    downloads

    0

    comments

    0

    adaptations

    Split Decomp
    This Excel worksheet performs split decomposition on a set of four DNA sequences and their associated amino acid sequences. The user can type in the sequences or paste them in from a text file.

    Keywords: phylogenyDNA sequenceamino acid sequencesplit decomposition

    110

    views

    56

    downloads

    0

    comments

    0

    adaptations

    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

    98

    views

    46

    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

    100

    views

    53

    downloads

    0

    comments

    0

    adaptations

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

    Keywords: Phylogeographymutation ratesAsexual reproductionspecies dispersal

    76

    views

    11

    downloads

    0

    comments

    0

    adaptations

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

    Keywords: drug metabolismpharmacokinetics

    77

    views

    47

    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

    85

    views

    43

    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

    121

    views

    80

    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

    205

    views

    29

    downloads

    0

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets

    Keywords: modelinginfectious diseaseInfectious Disease ModelingSIR modelsSIR

    4071

    views

    3384

    downloads

    0

    comments

    0

    adaptations