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

    2553

    views

    901

    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

    1324

    views

    1366

    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

    997

    views

    203

    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

    958

    views

    326

    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

    1838

    views

    485

    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

    1224

    views

    553

    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

    1439

    views

    580

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

    views

    155

    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

    1085

    views

    3961

    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

    208

    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

    152

    views

    410

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

    views

    161

    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

    1492

    views

    328

    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

    1211

    views

    226

    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

    1759

    views

    313

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

    views

    1000

    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

    47

    views

    32

    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

    167

    views

    37

    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

    357

    views

    392

    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

    159

    views

    293

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search