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
    REMNet Tutorial, Excel Part 1: Accessing Your Microbiome Data 5.3.19
    Video on accessing microbiome data from the Research Experiences in Microbiomes Network

    Keywords: data analysisREMNet

    1163

    views

    605

    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

    51

    views

    18

    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

    48

    views

    7

    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

    61

    views

    25

    downloads

    0

    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

    48

    views

    6

    downloads

    0

    comments

    0

    adaptations

    Developmental Allometry: Scaling in Growth
    This Excel workbook illustrates a number of allometric equations in animal growth. The workbook also calculates an allometric equation with graphical output for data entered by the user.

    Keywords: allometrybrain developmentSkeletal Systemmetabolic rate

    41

    views

    19

    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

    44

    views

    23

    downloads

    0

    comments

    0

    adaptations

    Biostatistical Tools
    This Excel collection of workbooks has tools for: 1. Linear regression through the origin 2. Linear regression not through the origin 3. Polynomial fit 4. A simple chi-square analysis to test...

    Keywords: linear regressionchi-square analysisHardy-Weinberg equilibriumpolynomial regression

    62

    views

    39

    downloads

    0

    comments

    0

    adaptations

    1-062-BacteriaGrowth-ModelingScenario
    We offer students a simulation experience or data from a simulation and ask them to model the simulation using several approaches: exponential growth fit, difference equation, differential...

    Keywords: bacteriaexponentialgrowth

    223

    views

    296

    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

    1452

    views

    297

    downloads

    0

    comments

    0

    adaptations

    Exploring the population dynamics of wintering bald eagles through long-term data
    Exploring long-term population data through graphical and statistical means Practice module included in Teaching Issues and Experiments in Ecology (TIEE) Volume 7

    Keywords: Resources @ ESA - TIEEcase studypopulation ecologyendangered speciesconservation biologymigration ecology

    1584

    views

    700

    downloads

    0

    comments

    0

    adaptations

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

    Keywords: drug metabolismpharmacokinetics

    40

    views

    10

    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

    37

    views

    5

    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

    309

    views

    247

    downloads

    0

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets

    Keywords: modelinginfectious diseaseInfectious Disease ModelingSIR modelsSIR

    3976

    views

    3319

    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

    30

    views

    7

    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

    39

    views

    23

    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

    50

    views

    33

    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

    57

    views

    24

    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

    436

    views

    466

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search