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

    4297

    views

    1677

    downloads

    0

    comments

    0

    adaptations

    Biological Diversity in Wetlands: Applying the Scientific Method
    An introduction to the Scientific Method for Introductory Biology students using plant and animal richness and environmental data from ephemeral ponds and permanent wetlands.

    Keywords: Resources @ ESA - TIEEintroductory biologyscientific methodspecies richnessaquatic ecologyfmnDIGenvironmental variationMicrosoft Excelhabitat permanencyupper level wetland ecology

    1519

    views

    1179

    downloads

    0

    comments

    0

    adaptations

    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

    691

    views

    878

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

    views

    739

    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

    1450

    views

    16331

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

    views

    473

    downloads

    0

    comments

    0

    adaptations

    Climate Drivers of Phenology Across Scales (adapted during Project EDDIE FMN)
    This activity explores the question: how is bumblebee phenology affected by climate, and are patterns in the phenology of an organism better explained at smaller scales?
    906

    views

    661

    downloads

    0

    comments

    0

    adaptations

    MS Excel Refresher - Lizards, iguanas, and snakes! Oh my! | Data Nuggets
    This resource, a MS Excel refresher, extends the level for this Data Nugget. Students are given an Excel workbook with the data and asked to graph and calculate diversity using Excel functions...

    Keywords: Resources @ Data NuggetsspreadsheetsRestoration EcologyUsing Excelgraphing in Excelformulas in ExcelApplied ecology

    625

    views

    344

    downloads

    0

    comments

    0

    adaptations

    Fitting Exponential and Logistic Growth Models to Bacterial Cell Count Data
    In this activity, students will model a noisy set of bacterial cell count data using both exponential and logistic growth models. For each model the students will plot the data (or a linear...

    Keywords: modelingdata analysislinear regressiongraphingExponentsoptimizationcalculusInterpreting GraphsFunctionsqbccCellular and Molecular BiologyChoosing modelsUnderstanding ratesConcepts in Statisticsmeasurementsmanipulating equationscreating graphsExponential and Logarithmic Functionsinterpreting tables

    2061

    views

    2620

    downloads

    1

    comments

    0

    adaptations

    Data Management using National Ecological Observatory Network's (NEON) Small Mammal Data with Accompanying Lesson on Mark Recapture Analysis
    Students use small mammal data from the National Ecological Observatory Network to understand necessary steps of data management from data collection to data analysis by estimating small mammal...

    Keywords: data managementspreadsheetssmall mammals community dynamicsNEONCapture mark-recaptureResource TypeNational Ecological Observatory Network

    9448

    views

    13897

    downloads

    0

    comments

    2

    adaptations

    REMNet Tutorial, Excel Part 4: Focusing on Taxonomy 4.26.19
    Video on analyzing microbiome data in Excel from the Research Experiences in Microbiomes Network

    Keywords: The Analysis of Biological DataExcelVideoMicrobiology Educationteaching with technologymicrobiomesSwirlresearch in the classroomREMNeturban microbiomes

    1220

    views

    848

    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

    2835

    views

    1277

    downloads

    0

    comments

    0

    adaptations

    MathBench Population Dynamics Module Activity
    The resource accompanies the Mystery of the Missing Housefly Population Dynamics MathBench module which explores exponential and logistic growth models. Students explore the assumptions of the...
    1146

    views

    630

    downloads

    0

    comments

    0

    adaptations

    Introduction to Data Management and Metadata using NEON aquatic macroinvertebrate data
    This lesson focuses on understanding metadata, the data about the data, using aquatic macroinvertebrate abundance and species information from a variety of NEON sampling locations.

    Keywords: data managementSpreadsheetmetadata

    2583

    views

    942

    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

    2035

    views

    620

    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

    2797

    views

    991

    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

    140

    views

    143

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

    views

    440

    downloads

    0

    comments

    0

    adaptations

    The Edge Effect
    This module has students venturing outdoors to take a 50m transect and collect abundance data on plants utilizing quadrats in both edge and interior environment. Mathematically the goals of this...

    Keywords: statisticsecologydata analysisExcelintroductory biologygraphingp-valuest-testsQuantitative reasoninghypothesis testingsample sizestatistical testsinterdisciplinarystatistical analysisCommunity Ecologyspecies diversityvariationdiversity indexvinterpret dataNIQBShannon diversity indexC3. Statistical AnalysisC6. Quantitative Languageedge effect

    563

    views

    434

    downloads

    0

    comments

    0

    adaptations

    Kinetics of a Highly Conserved Enzyme - Carbonic Anhydrase
    This module contains exercises designed to introduce students to graphical representation of biological data. Students will explore the fundamental principles of enzyme kinetics including...

    Keywords: Excelintroductory biologycell biologygraphingslopeQuantitative reasoningdata visualizationquantitative biologyinterdisciplaryquantitative skillscorrelationenzyme functionInterpreting GraphsMichaelis-Mentenenzyme kineticsEnzyme activityenzyme inhibitionLinear and nonlinear analysisNIQBC2. Data and GraphsC4. mathematical modelsenzyme-substrateNIQB Interdisciplinary Quantitative Reasoningcarbonic anhydrase

    137

    views

    242

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search