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

    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

    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

    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

    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

    2069

    views

    2642

    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

    9457

    views

    13905

    downloads

    0

    comments

    2

    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

    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

    2585

    views

    945

    downloads

    0

    comments

    0

    adaptations

    Exploring the population dynamics of wintering bald eagles through long-term data
    Exploring long-term population data through graphical and statistical means Practice module included in Teaching Issues and Experiments in Ecology (TIEE) Volume 7

    Keywords: Resources @ ESA - TIEEcase studypopulation ecologyendangered speciesconservation biologymigration ecology

    1635

    views

    736

    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

    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

    149

    views

    145

    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

    The Effect of Climate Change on Butterfly Phenology - Intro Environmental Science
    In this module, students practice interpreting the relationship between variables before exploring changes in butterfly phenology through the use of natural history collections data.

    Keywords: ExcelResources @ ESA - TIEEgraphingquantitative literacyclimate changefmnphenologynatural history collectionsDIGbutterflyinterspecific interactions

    1990

    views

    1061

    downloads

    0

    comments

    0

    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

    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

    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

    Graphing Techniques for Introductory Microbiology
    This module will introduce the introductory microbiology students to graphing skills to visualize and interpret the data to investigate the effect of environmental factor (temperature) on bacterial...

    Keywords: data analysisgraphinggraph interpretationdata interpretationmicrobiologySTEM educationtemperaturegroup workBEDENet FMNbacterial growth

    328

    views

    70

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search