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
    RAT ATTACK! Population growth
    This module contains exercises focused on the use and interpretation of density independent and density dependent population growth models. Students build logistic and exponential growth models in...

    Keywords: modelingecologyExcelintroductory biologygraphingQuantitative reasoningdata visualizationinterdisciplinaryexponential growthlogistic growthdata managementInterpreting Graphspopulation modelingNIQBC2. Data and GraphsC4. mathematical modelsnonlinear models

    614

    views

    772

    downloads

    0

    comments

    0

    adaptations

    6-025-WhalesAndKrill-ModelingScenario
    Students will use Excel to observe qualitative behavior in a simulation of a predator-prey model, with blue whales and krill as the predator and prey populations, respectively.

    Keywords: krillwhalepredatpr-prey

    327

    views

    1165

    downloads

    0

    comments

    0

    adaptations

    Protein Analysis
    This Excel workbook allows the analysis of sample or imported protein sequences. The model can analyze protein sequences up to 500 amino acids long.

    Keywords: Protein sequencehydrophobicity/hydrophilicity

    61

    views

    33

    downloads

    0

    comments

    0

    adaptations

    1-031-CoolIt-ModelingScenario
    We offer data on the temperature of water in a beaker in a room of constant temperature and in a room of nonconstant temperature. Students consider both empirical and analytic modeling...

    Keywords: SpanishNewton's Law of Coolingcooling

    254

    views

    432

    downloads

    0

    comments

    0

    adaptations

    1-015-Torricelli-ModelingScenario
    We help students develop a model (Torricelli's Law) for the height of a falling column of water with a small hole in the container at the bottom of the column of water through which water exits the...

    Keywords: dataSpanishtankcolumn of waterapertureTorricelli's LawConservation of EnergytSolverwater flowExcel Solver

    389

    views

    924

    downloads

    0

    comments

    0

    adaptations

    2011-Kurt_Kreith-The Mathematics of Global Change
    The authors discuss broad issues and then focus on specifics like exponential growth, logistic growth, and the logistic equation with delay.

    Keywords: exponential growthlogistic growth

    137

    views

    46

    downloads

    0

    comments

    0

    adaptations

    1-089-SpreadOfDisease-ModelingScenario
    In this project I want to use the algebra based concept “difference quotient” to solve differential equations models with the help of Excel. That means even students with only a College Algebra...

    Keywords: SIR modelProportionderivativedifference quotientSleeping Beautycontagious disease

    247

    views

    122

    downloads

    0

    comments

    0

    adaptations

    Comparing Primary and Secondary Forest in a Preserve in Plano Texas: A Forest Ecology Course-based Undergraduate Research Experience (CURE) for Non-Majors and Lower-Level Majors
    An activity that can be conducted as an online or field exercise in which students develop and test their hypotheses about how forest stand characteristics differ between two forest types.

    Keywords: forest ecologyecologycourse-based undergraduate research experienceUsing Excel

    1987

    views

    587

    downloads

    4

    comments

    0

    adaptations

    Cleaning Biodiversity Data: Excel
    Access and clean an open source polar bear dataset using Excel.

    Keywords: data in the classroombiodiversity informaticsData cleaning

    2668

    views

    948

    downloads

    0

    comments

    1

    adaptations

    Processes that Regulate Patterns of Species and Genetic Diversity - Intro Environmental Science
    This activity was adapted for use in an intro non-majors Environmental Science course, with an emphasis on collaborative data collection.

    Keywords: data analysisGenetic Driftquantitative skillsspecies diversityIsland biogeographygamificationgenetic diversityecological driftcolonizationcollaborative data collection

    1397

    views

    1546

    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

    1151

    views

    234

    downloads

    0

    comments

    0

    adaptations

    Circle Train Math Modeling Task
    This math modeling task is appropriate for high school Precalculus students. The students use their knowledge of transformations of trigonometric functions to create models for horizontal and...

    Keywords: mathematical modelTrigonometric Functionsparametric equationstransformations of functions

    1025

    views

    345

    downloads

    0

    comments

    0

    adaptations

    Decoding, Critiquing, and Creating a Graph from the Ground Up
    Students decipher a published graph with little supplemental information and are given more details in pieces before producing a new graph that displays the data more effectively and is easier to...

    Keywords: EvolutionExcelgraphingBar GraphsbiomimicryScientific ProcessStatistics and MathMicrosoft Excel

    1956

    views

    507

    downloads

    0

    comments

    0

    adaptations

    Spreadsheet Data Analysis Terms and Shortened Tutorial 4
    Introductory students are asked to learn terms for descriptive statistics and complete a matching exercise. Tutorial 4 was shorted to just the full calculations of t values.

    Keywords: Scientific ProcessStatistics and MathScientific Methodology

    1282

    views

    604

    downloads

    0

    comments

    0

    adaptations

    Using HHMI Tutorials to Prepare Students for Investigating Authentic Datasets in Biology
    HHMI tutorial modules were modified and condensed to bring all students up to the same skill level, and students took a pre-assessment to demonstrate adequate preparation for class.

    Keywords: Scientific ProcessStatistics and MathScientific Methodology

    1493

    views

    627

    downloads

    0

    comments

    0

    adaptations

    Calculating and Comparing Biodiversity Materials Across Sites Using NEON Herbaceous Vegetation Data - a Tutorial
    These materials are intended for use at the undergraduate level. They employ R and Excel software.
    5903

    views

    167

    downloads

    0

    comments

    0

    adaptations

    1-038-Ebola-ModelingScenario
    Students will use data published by the World Health Organization to model the 2014 outbreak of the Ebola virus in West Africa. We begin with a simple exponential growth model and move through the...

    Keywords: population dynamicsdata analysisexponential growthEbolalogisticepidemic

    1137

    views

    4033

    downloads

    0

    comments

    0

    adaptations

    1-160-HeartDeathRate-ModelingScenario
    Students simulate experience from a given data set which represents the heart death rate during the period 2000 - 2010 using several approaches to include exponential decay, difference equation,...

    Keywords: dataheart death rate

    233

    views

    291

    downloads

    0

    comments

    0

    adaptations

    2020-TeachingModule-ModelingFallingColumnOfWater
    We discuss how to model a falling column of water empirically and analytically from first principles in physics laws.

    Keywords: modulecolumn of waterTorricelli's LawTorricelliTeaching Module

    179

    views

    487

    downloads

    1

    comments

    0

    adaptations

    Diseasebots HEXBUG Lab
    This module explores the effects of host density on contact rates and transmission of pathogens using a hands-on experiment with HEXBUG robots.
    756

    views

    188

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search