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

    4

    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

    5

    views

    0

    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

    12

    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

    34

    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

    23

    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

    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

    1069

    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

    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

    Investigating the ecological value of migratory fishes on stream ecosystems in southern Appalachia
    Using the Ecological Society of America’s Four-Dimensional Ecology Education (4DEE) framework, students apply ecological concepts such as energy flow, nutrient cycling, migration, and climate...

    Keywords: Stream ecologynutrient cycling4DEE Frameworkfish migration

    107

    views

    235

    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

    163

    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

    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

    Learning the Landscape: An Active and Applied Lesson on Landscape Ecology for General Ecology Courses
    Landscape ecology is an important subtopic of ecology. As a field, it is inherently interdisciplinary and provides opportunities to teach not only content, but transferable ecological and...

    Keywords: landscape ecologyspatial scaleecosystem managementHabitat fragmentation

    664

    views

    30

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search