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

    31

    views

    14

    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

    22

    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

    23

    views

    2

    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

    10

    views

    0

    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

    16

    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

    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

    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

    6

    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

    25

    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

    74

    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

    1039

    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

    1456

    views

    233

    downloads

    2

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets

    Keywords: modelinginfectious diseaseInfectious Disease ModelingSIR modelsSIR

    3892

    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

    Cell Cycle and Mitosis
    This module introduces activities that allow students to walk through the cell cycle and mitotic cell division processes. As part of the activities, students learn about and apply knowledge of...

    Keywords: introductory biologyQuantitative reasoningInterdisciplinary STEMquantitative biologyinterdisciplinaryquantitative skillscell functioncell cyclemitosisCell DivisionMitotic Indexcalculating meanstumorNIQBC2. Data and GraphsC4. mathematical modelsC3. Statistical Analysisstandard errormitotic phaseinterphase

    162

    views

    120

    downloads

    0

    comments

    0

    adaptations

    Leveraging Panel Discussions to Promote Positive Representation, Develop Science Identity, and Shift Stereotypes
    The overrepresentation of cis straight white male scientists in examples used in Biology curriculum makes it difficult for students with other axes of diversity (race/ethnicity, gender, sexuality,...

    Keywords: professional developmentEquitydiversityscience identitysense of belongingCentering Student VoicesCareer Paneland InclusionPositive Representation of Diverse ScientistsFostering Community Between Students

    1201

    views

    14

    downloads

    0

    comments

    0

    adaptations

    Data-Driven Decision-Making: Antarctic Fisheries
    This is an entire module for a general education data science and ecology course. The module was originally designed as the fourth and final section of the course; the full course is openly...

    Keywords: population growthRStudiodata visualizationexponential growthlogistic growthR Markdownspatial dataocean sustainability4DEE FrameworkTraditional ecological knowledgecarrying capacityEcosystem Servicesmaximum sustainable yield

    166

    views

    86

    downloads

    0

    comments

    0

    adaptations

    A Structured Inquiry-Based Module for the Undergraduate Cell Biology Laboratory That Teaches Fundamental Concepts of Cell Differentiation
    Pedagogical research in science education has shown that students effectively learn science by doing science. As a result, there is increased interest in bringing research-like experiences into the...

    Keywords: fluorescence microscopygene expressionpolymerase chain reactionCell Structurecell culturewestern blottingdifferentiationreverse transcription

    698

    views

    22

    downloads

    0

    comments

    0

    adaptations

    Exploring Microbial Diversity: An Interactive In-Class Assignment for Biology and Microbiology Courses
    This interactive assignment engages students in a hands-on exploration of microbial diversity and the importance of microbes in ecosystems. Designed for General Biology II and Introduction to...

    Keywords: Microbiology EducationMicrobial DiversitymicrobiologyEcological Society of Americaecology educationresearch-based classroom instruction4DEE Framework

    212

    views

    102

    downloads

    0

    comments

    0

    adaptations

    The Great Petunia Carnage of 2017: A Clicker Case Study Using Petunias to Describe the Effect of Genetic Modification on the Biochemistry of Flower Color and Phenotype in Plants
    In this single class period case study, students examine the difference between genotype and phenotype by studying the mechanisms by which commercially available petunias have been bred to have...

    Keywords: case studyGenetic ModificationsBiochemistry of Flower ColorGMO regulationsGenotype-Phenotype Connections

    1927

    views

    34

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search