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
    Linear Regression (Excel) and Cellular Respiration for Biology, Chemistry and Mathematics
    Students typically find linear regression analysis of data sets in a biology classroom challenging. These activities could be used in a Biology, Chemistry, Mathematics, or Statistics course. The...

    Keywords: statisticsmathematicsdata analysisdatalinear regressionbiologyonlinegraphinglinear equationsQuantitative reasoningassessmentcollege algebracellstatistical analysisregressionOERAlgebrachemistryModelscorrelationSimple Linear RegressionMicrosoft Excellab activityexperimentCellular ProcessesATPqbccUsing Excelmanipulate equationsCellular and Molecular BiologyConcepts in Statisticsoxidationline of best fitexplaining statisticsusing statisticsCellular RespirationPredictionsRespirationgraphing in ExcelLinear CorrelationExothermic Reactioncreate scatter plotAdenosine Triphosphate (ATP)germinating peasPre-lab activityStudent activityHybridCollecting DataR-squareRegression ModelFunctionDependent VariablesIndependent VariablesLinear EquationLinear Equation in two variablescreate graphcreate equationcreate regressioncreate plotinterpret regressioninterpret data

    4307

    views

    1686

    downloads

    0

    comments

    0

    adaptations

    Cleaning Biodiversity Data: A Botanical Example Using Excel or RStudio
    Access and clean an open source herbarium dataset using Excel or RStudio.

    Keywords: Exceldata in the classroomRStudiobiodiversity informaticsnatural history collectionsHerbariaData cleaning

    2839

    views

    1280

    downloads

    0

    comments

    0

    adaptations

    Global Temperature Change in the 21st Century: An Introduction to Global Climate Models and Graphing in Excel (Adapted for Non-Majors)
    Students link human behavior in various climate change scenarios to predicted temperature outcomes at both local (their assigned Latitude) and global (Latitudinal trends) scales. This adaptation is...

    Keywords: ExcelResources @ ESA - TIEEecology labclimate changeenvironmental scienceglobal changehuman-environmental interactionsSimple Linear Regressionhuman impactsinclusive pedagogy-FMN

    1327

    views

    1645

    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

    2042

    views

    622

    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

    2803

    views

    992

    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

    1438

    views

    1626

    downloads

    0

    comments

    0

    adaptations

    COVID-19 educational module | Department of Mathematics
    This resource is a module you can use to teach your students the basics of epidemic behavior using a model geared specifically to Covid-19. Students can address key questions using pre-designed...
    1119

    views

    442

    downloads

    0

    comments

    0

    adaptations

    Examining human impacts on tusk evolution in elephants using authentic research data
    In this activity students explore and analyze real, authentic research data paired with HHMI’s “Selection for Tuskless Elephants” video in a hands-on investigation of human impacts on elephant...
    2591

    views

    5391

    downloads

    0

    comments

    1

    adaptations

    Quantifying Bacterial Growth in the Guts and Hemolymph of Fruit Flies: Mathematical Modeling and Data Interpolation/Extrapolation
    In this activity, students will analyze raw data obtained from an experiment that explores the effect of overexpressing the Ssk protein in order to strengthen the intestinal barrier and prevent...

    Keywords: graphingexponential growthlinear modelsqbccinterpolationConcepts in Statistics and Precalculus Understanding exponential rates and linear slopesExtrapolation

    2100

    views

    352

    downloads

    0

    comments

    0

    adaptations

    Using Regression Models to Examine the Effect of Carbon Dioxide on Fluid pH
    In this activity students will use statistics and regression models to explore the effects of carbon dioxide on blood pH by measuring pH changes that occur over time as carbon dioxide reacts with...

    Keywords: BiochemistryphysiologyAnatomyGeneral BiologyChoosing modelsCreate graphsInterpret graphsConcepts in Statisticscreate modelsmake predictions

    403

    views

    149

    downloads

    0

    comments

    0

    adaptations

    Graphing and mapping patterns of air quality in Los Angeles, California through an environmental justice lens.
    Air quality is an environmental issue that impacts everyone in Los Angeles. This activity presents current popular press articles about air pollution and environmental justice and maps and graphs...
    1672

    views

    739

    downloads

    0

    comments

    0

    adaptations

    Mosquito Vector Ecology of the East Coast using NEON
    This data module examines the relationship between mosquito vector ecology and climate across the east coast of the United States. The module is designed to merge core concepts in ecology with...
    1550

    views

    3839

    downloads

    0

    comments

    0

    adaptations

    Investigating Evidence for Climate Change (Project EDDIE)
    This multi-part activity allows students to discover the relationships between CO2 and temperature and how these variables have changed over time using real-world data.

    Keywords: Excelclimate changeGlobal Temperature Changeco2ice core data

    1593

    views

    911

    downloads

    0

    comments

    1

    adaptations

    Modification of "The Effect of Climate Change on Butterfly Phenology" module by Linton et al.
    This is a modification of the Linton et al. module in TIEE Volume 13. Students use data from digitized museum records of butterfly specimens in a modification with no homework (lab/workshop format)...

    Keywords: ExcelResources @ ESA - TIEEclimate changefmnphenologynatural history collectionsDIGbutterflyinterspecific interactions

    1992

    views

    1743

    downloads

    0

    comments

    0

    adaptations

    Using Grassy Narrows in a Live Classroom with Clicker Questions and Interactive Histogram: Sampling Distributions, Probability, and Hypothesis Testing
    Students are introduced to concepts of sampling distributions, p-values, and hypothesis testing. Using both simulated and real data for methylmercury level in fish populations, students will...

    Keywords: statisticsmathematicsbiostatisticsecologybiologygraphingp-valuest-testshypothesis testingin-class activityZoologymercury biogeochemistrybiostatistics - generalfish populationqbccBiogeochemical cyclesInterpret graphsConcepts in StatisticsElementary Hypothesis TestingMethylmercurydamsBioaccumulationtraditional dietsmercurymercury poisoningnative peopleindigenous populationCanadahydroelectricexplaining statisticsusing statisticsMake probability calculations

    1396

    views

    1610

    downloads

    0

    comments

    0

    adaptations

    Assessing Socioeconomic Trends in Tree Cover and Human Health in Urban Environments
    In this exercise, students use a combination of publicly available data and tree cover data that they generate using iTree Canopy to test whether tree cover is equitably distributed within the city...

    Keywords: social justiceSimple Linear Regressionenvironmental justiceGeographic Information System (GIS)Using ExcelConnection to PlaceredliningEcosystem Servicesurban tree coverurban environments

    1440

    views

    2207

    downloads

    0

    comments

    0

    adaptations

    Phenology Trends and Climate Change in Minnesota (Project EDDIE): A focus on American elm
    In this module, students will practice answering a specific question about how climate change has affected flowering date in American elm trees.
    877

    views

    477

    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

    352

    views

    247

    downloads

    0

    comments

    0

    adaptations

    Learn Biological Sciences and Mathematics through cellular respiration, photosynthesis and primary productivity.
    Photosynthesis is a process by which plants synthesize glucose and oxygen in presence of sunlight through light dependent reactions by utilization of sunlight, water to synthesize oxygen, ATP and...

    Keywords: mathematicssimulationThe Analysis of Biological DataMetabolic Pathwaysprocess of sciencephotosynthesisqbccBiological ScienceshypothesisCellular Respirationprimary productivity

    1077

    views

    152

    downloads

    0

    comments

    0

    adaptations

    Analysis of Amylase Activity
    This lab is an exploration of enzyme function and the effects of environmental conditions on the activity of the enzyme amylase. The lab utilizes analytical and graphing skills to assess enzyme...

    Keywords: data analysisintroductory biologyconcentrationgraphinglinear equationsBiochemistryscientific methodstandard curveenzyme functionMicrosoft ExcelInterpreting GraphsenzymesqbccCreate graphsInterpret graphsSolving Equations and Inequalitiesinterpret tablesAmylaseAlpha-amylaseEnzyme activityMaltoseDNS assayAbsorbancelab reportspectrophotometryregression linemanipulating equationsline of best fitgraphing by hand

    1458

    views

    16476

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search