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
    Glycolysis Can Be Fun: Rediscovering Glycolysis as a Problem-Solving Introduction to Metabolism
    A thorough understanding of glycolysis forms a foundation for students to analyze subsequent topics in metabolism, a core competency recognized by multiple national societies for biology and...

    Keywords: Problem based learningPOGILenzymesGlycolysisMetabolismFermentationchemical reactionsCard sorting activityCofactors

    798

    views

    59

    downloads

    0

    comments

    0

    adaptations

    Malaise Trap Project: Involving Undergraduate Students in Network Science
    A multi-week project for upper division undergraduate students to participate in network-level science, while simultaneously learning classic entomology skills of specimen collection and...

    Keywords: entomologynetwork science4DEE Framework

    101

    views

    99

    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

    72

    views

    28

    downloads

    0

    comments

    0

    adaptations

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

    Keywords: Phylogeographymutation ratesAsexual reproductionspecies dispersal

    62

    views

    9

    downloads

    0

    comments

    0

    adaptations

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

    Keywords: drug metabolismpharmacokinetics

    53

    views

    29

    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

    50

    views

    24

    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

    76

    views

    23

    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

    80

    views

    50

    downloads

    0

    comments

    0

    adaptations

    javaFOODWEB
    More than 100 food web matrices (multiple predators/prey Excel worksheets) are included with the javaFOODWEB tool.

    Keywords: niche spacesCommunity Ecologyfood webspredator-prey interactionsMatricestrophic chain

    76

    views

    30

    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

    66

    views

    6

    downloads

    0

    comments

    0

    adaptations

    GeoPhyl
    This Excel workbook allows students to explore evolution over space and time using published data on the invasive plant Tamarix (salt cedar).

    Keywords: Invasive SpeciesTamarixsalt cedarpermutation testrandom geographic distribution

    72

    views

    36

    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

    61

    views

    30

    downloads

    0

    comments

    0

    adaptations

    ESS: Evolutionary Stable Strategies Game Theory Module
    This Excel workbook illustrates a number of ESS examples. Each example allows the user to manipulate the initial population for each strategy and the fitness payoffs and costs for each strategy.

    Keywords: population geneticsfitnessgame theorySequence alignmentevolutionary stable strategies

    54

    views

    18

    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

    59

    views

    36

    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

    68

    views

    40

    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

    66

    views

    36

    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

    96

    views

    52

    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

    69

    views

    13

    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

    44

    views

    19

    downloads

    0

    comments

    0

    adaptations

    Buffer Preparation
    This Excel workbook calculates the necessary components to create a buffer solution using the Henderson-Hasselbalch equation.

    Keywords: buffer solutionacidbase

    69

    views

    11

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search