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
    Cleaning Biodiversity Data: Excel
    Access and clean an open source polar bear dataset using Excel.

    Keywords: data in the classroombiodiversity informaticsData cleaning

    2581

    views

    920

    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

    1347

    views

    1415

    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: ExcelResources @ ESTEEMphenotypic probabilityallelic frequency

    1012

    views

    212

    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

    978

    views

    327

    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

    1858

    views

    492

    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

    1231

    views

    563

    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

    1448

    views

    589

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

    views

    157

    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

    1093

    views

    3962

    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

    213

    views

    260

    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

    156

    views

    412

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

    views

    163

    downloads

    0

    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: ExcelResources @ ESTEEMMichaelis-Mentenenzymesenzyme kinetics

    1511

    views

    337

    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: ExcelphageResources @ ESTEEMLuria-Delbruckresistance

    1225

    views

    231

    downloads

    2

    comments

    0

    adaptations

    Spreadsheet Data Analysis Tutorial Series
    This series of self-paced tutorials show how to analyze data using a spreadsheet program.

    Keywords: Resources @ HHMI - BioInteractiveScientific ProcessStatistics and MathScientific MethodologyHigh School

    1803

    views

    320

    downloads

    0

    comments

    6

    adaptations

    Wind and Ocean Ecosystems (Project EDDIE)
    This module introduces students to the concepts of Ekman transport, eastern boundary currents, and upwelling, while learning how to find a location on a map using latitude and longitude, how to...
    981

    views

    1009

    downloads

    0

    comments

    1

    adaptations

    Prosecutor’s Fallacy and Mammograms Case Study
    An introduction to Prosecutor’s Fallacy, and False Positives/Negatives. By Dr. Diaz Eaton, Bates College, for use in DCS 105A, and inspired by Calling Bull & Calculated Risks.

    Keywords: ProbabilityExcelcalling bullMammogramsData UnderstandingVisualizing Outcomes

    68

    views

    51

    downloads

    0

    comments

    0

    adaptations

    2010-Shaza_Hussein-Predator-Prey Modeling
    The objective of this project was to create five projections of animal populations based on a simple predator-prey model and explore the trends visible.

    Keywords: population dynamicspredator-preylogistic equationEndangered Catsdecreasing populationrabbitsfoxes

    173

    views

    38

    downloads

    0

    comments

    0

    adaptations

    1-011-Kinetics-ModelingScenario
    We make the connection between chemistry course and differential equations coursework. We do this through modeling kinetics, or rates of chemical reaction. We study zeroth, first, and second order...

    Keywords: kineticschemistryLaw of Mass Actionchemical kineticsorder of reactionchemical reaction

    371

    views

    408

    downloads

    0

    comments

    0

    adaptations

    3-060-DataToDifferentialEquation-ModelingScenario
    Students use knowledge of second-order linear differential equations in conjunction with physical intuition of spring-mass systems to estimate the damping coefficient and spring constant from data.

    Keywords: Association & Data Fittingmassspring-mass systemspring\total distancenumerical differentiation

    198

    views

    293

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search