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

    32

    views

    20

    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

    12

    views

    0

    downloads

    0

    comments

    0

    adaptations

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

    Keywords: Phylogeographymutation ratesAsexual reproductionspecies dispersal

    8

    views

    2

    downloads

    0

    comments

    0

    adaptations

    Operon
    This Excel workbook models lac operon function in a partial diploid E. coli. The user chooses the bacterial genotype and the sugars present in the surrounding medium: the workbook then determines...

    Keywords: Lac OperonE. coli

    16

    views

    2

    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

    17

    views

    2

    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

    40

    views

    14

    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

    32

    views

    8

    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

    30

    views

    4

    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

    24

    views

    4

    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

    24

    views

    2

    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

    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

    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

    7

    views

    0

    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

    28

    views

    3

    downloads

    0

    comments

    0

    adaptations

    Learning Spaces in undergraduate science courses ( virtual and face to face)
    Learning Spaces are zones of interaction between undergraduates & undergraduates and undergraduates & professor. The traditional learning spaces were existing pre-pandemic however post-pandemic the...

    Keywords: active learningmentoringstemassessmentfaculty developmentteachingUndergraduateWorkshop materiallearning spacescience learning spaceprofessorsmajor learning spaceminor learning space

    76

    views

    7

    downloads

    0

    comments

    0

    adaptations

    Birthday Problem and Class Phenotypic Probabilities
    An Excel workbook exploring two related applications, the Birthday Problem and Class Phenotypic Probabilities. Students enter their own phenotypes into the workbook.

    Keywords: phenotypic probabilityallelic frequency

    1076

    views

    215

    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

    1461

    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

    1539

    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

    Close

    Home

    Search