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
    Yeast Cell Growth
    Numbers Count resource using Excel for data analysis

    Keywords: data analysisExcelNumbers Count

    1359

    views

    392

    downloads

    0

    comments

    0

    adaptations

    Balancing Chemical Equations Using Matrix Algebra
    This Excel workbook introduces using matrix algebra to balance chemical reactions. The workbook allows the user to set up their own matrices for chemical reactions involving 2-7 elements.

    Keywords: chemical reactionsInverse matrix methodmatrix algebra

    158

    views

    31

    downloads

    0

    comments

    0

    adaptations

    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

    4249

    views

    1643

    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

    2807

    views

    1259

    downloads

    0

    comments

    0

    adaptations

    SUMS4Bio - Video tutorials in math and stats for biology students
    Links to videos and pdf tutorials for core mathematical and statistical concepts used in biology

    Keywords: Probabilitystatisticsmathematicsvideoschi-squaredExcelBar Graphsline graphsScatter Plotsp-valuest-testsExponentsLogarithmsproportionsRatiosbinomialdata typessummary statisticsfrequency histogramsResources @ SUMS4BioPresentation

    1572

    views

    241

    downloads

    0

    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

    2768

    views

    981

    downloads

    0

    comments

    1

    adaptations

    Trail Camera Field Survey Module
    This QUBES module introduces high school students to the exciting world of field surveys using trail cameras. Designed for environmental science classes, the module offers a hands-on approach to...

    Keywords: graphsspecies richnessCommunity EcologymammalsMicrosoft Exceldichotomous keycamera trapsShannon diversity indexTrail CamerasPivotTables

    73

    views

    158

    downloads

    0

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets

    Keywords: modelinginfectious diseaseInfectious Disease ModelingSIR modelsSIR

    4075

    views

    3385

    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

    1051

    views

    367

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

    views

    437

    downloads

    0

    comments

    0

    adaptations

    Quartile Tutorial
    Numbers Count Excel resource

    Keywords: ExcelNumbers Count

    1352

    views

    234

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

    views

    5358

    downloads

    0

    comments

    1

    adaptations

    Circle Train Problem TCM 2018_Hernandez.pdf - Google Drive
    In this math modeling lesson, students build mathematical models for the horizontal and vertical position of a train moving along a circular track. The math topics includes transformations of...

    Keywords: mathematical modelTrigonometryPrecalculusdata collectionLoggerProtransformation of functionsparametric equations

    1129

    views

    201

    downloads

    0

    comments

    0

    adaptations

    Confidence Intervals Tutorial
    Numbers Count Excel resource

    Keywords: ExcelNumbers Countconfidence interval

    1456

    views

    549

    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

    2084

    views

    344

    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

    383

    views

    139

    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

    1373

    views

    1559

    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

    317

    views

    229

    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

    1426

    views

    15975

    downloads

    0

    comments

    0

    adaptations

    Ground Spider Survey QUBES Resource Draft (1)
    This QUBES Module aims to introduce students to standardized ecological field methods, measures of diversity, ArcGIS Online, and Excel. This is achieved through nocturnal survey of ground spiders.

    Keywords: Community EcologyspidersMicrosoft ExcelShannon diversity index

    312

    views

    345

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search