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
    Exploring Marine Primary Productivity with Descriptive Statistics and Graphing in Excel
    In this activity, students use real water chemistry data and descriptive statistics in Excel to examine primary productivity in an urban estuary of the Salish Sea. They will consider how actual...

    Keywords: statisticsecologydataExcelgraphingBiochemistryOceanographymarine ecosystemsmarine ecologydescriptive statisticslong-term datasetsmarineMicrosoft Excelmarine biologyplanktonOutliersMarine ScienceqbccUsing ExcelphytoplanktonCreate graphsInterpret graphsConcepts in Statisticslarge datasetexplaining statisticsusing statisticsPacific NorthwestSalish Seaprimary productivitywater chemistryestuarygraphing in Excelformulas in Excelchlorophylltime-series plotsocean

    550

    views

    748

    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

    4267

    views

    1654

    downloads

    0

    comments

    0

    adaptations

    Exploring Marine Primary Productivity with Descriptive Statistics and Graphing in Excel
    In this activity, students use real water chemistry data and descriptive statistics in Excel to examine primary productivity in an urban estuary of the Salish Sea. They will consider how actual...

    Keywords: statisticsecologydataExcelgraphingBiochemistryOceanographymarine ecosystemsmarine ecologydescriptive statisticslong-term datasetsmarineMicrosoft Excelmarine biologyplanktonOutliersMarine ScienceqbccUsing ExcelphytoplanktonCreate graphsInterpret graphsConcepts in Statisticslarge datasetexplaining statisticsusing statisticsPacific NorthwestSalish Seaprimary productivitywater chemistryestuarygraphing in Excelformulas in Excelchlorophylltime-series plotsocean

    1324

    views

    1316

    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

    2088

    views

    347

    downloads

    0

    comments

    0

    adaptations

    REMNet Tutorial, Excel Part 6: Making Microbiome Column Charts 5.3.19
    Video on creating column charts in Excel from the Research Experiences in Microbiomes Network

    Keywords: ExcelVideoMicrobiology Educationmicrobiomesresearch in the classroomREMNeturban microbiomes

    1182

    views

    433

    downloads

    0

    comments

    0

    adaptations

    REMNet Tutorial, Excel Part 5: Making Heat Maps 4.26.19
    Video on making heat maps in Excel from the Research Experiences in Microbiomes Network

    Keywords: ExcelVideoMicrobiology EducationMicrobiome researchresearch in the classroomREMNeturban microbiome

    1080

    views

    376

    downloads

    0

    comments

    0

    adaptations

    REMNet Tutorial, Excel Part 3: Organizing Your Microbiome Data 5.3.19
    Video on organizing microbiome using Excel from the Research Experiences in Microbiomes Network

    Keywords: ExcelVideoMicrobiology Educationmicrobiomesresearch in the classroomREMNeturban microbiomes

    1270

    views

    670

    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

    1376

    views

    1563

    downloads

    0

    comments

    0

    adaptations

    Effect of the Intestinal Protein Snakeskin on the Lifespan of Fruit Flies: A Kaplan-Meier Survival Analysissource Draft (1)
    In this activity, students perform the Kaplan-Meier survival analysis on raw data obtained from an experiment that explores the effect of overexpressing the Snakeskin (Ssk) protein on the lifespan...

    Keywords: graphingBiochemistryhypothesis testingcalculus and biologyapproximating areas under curvesqbccCellular and Molecular BiologyCreate graphsInterpret graphsSolving Equations and Inequalitiesinterpret tablesConcepts in Statisticsusing statisticschi-square analysissurvival analysis

    1464

    views

    198

    downloads

    0

    comments

    0

    adaptations

    Ecology of Infectious Disease: Data Mining the National Notifiable Diseases Surveillance System (NNDSS) for Ecological Patterns
    How to use publicly available infection case data to teach ecology and evolution of human infectious diseases.

    Keywords: Evolutionecologyinfectious diseasehumansjigsawsmall group workEvolutionary medicinedata explorationCDCNNDSS

    2192

    views

    1122

    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

    2013

    views

    2544

    downloads

    1

    comments

    0

    adaptations

    REMNet Tutorial, R Part 5: Normalizing Microbiome Data in R 5.2.19
    Video on normalizing microbiome data from the Research Experiences in Microbiomes Network

    Keywords: geneticsstatisticsdata analysisgraphingRStudioVideoexperimental designR programming languagemicrobiomesstudent researchinterdisciplinary educationlimnologyeco-informaticsresearch in the classroomtidyverseWorking with datasetsREMNet

    1412

    views

    466

    downloads

    0

    comments

    0

    adaptations

    Graphing bacterial growth rates: semi-log graphs v linear graphs
    In this activity, students will explore the concept of binary fission, generation time, and bacterial growth curves, with an emphasis on the log phase. Students will use semi-log graphs and linear...

    Keywords: graphingexponential growthMicrobiology Educationmicrobiologybacteriagrowth rateUndergraduate STEM educationCommunity College Educationqbccmanipulate equationsCellular and Molecular BiologyCreate graphsInterpret graphsbinary fissionsemi-log graphlinear graphgrowth curvecreating graphsExponential and Logarithmic Functions

    2988

    views

    3927

    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

    132

    views

    127

    downloads

    0

    comments

    0

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

    views

    1089

    downloads

    0

    comments

    1

    adaptations

    Wind and Ocean Ecosystems (Project EDDIE)- adapted to provide greater autonomy for students in an upper level class
    This module adaption focuses on the interplay between winds, ocean upwelling, and marine productivity. Students are able to select and download their own data and compare results among different...
    1242

    views

    1492

    downloads

    0

    comments

    0

    adaptations

    Uninhibited Growth of Cells
    In this activity, students will explore the concept of binary fission, generation time, and bacterial growth curves, with an emphasis on the log phase. Students will use semi-log graphs and linear...

    Keywords: graphingexponential growthMicrobiology Educationmicrobiologybacteriagrowth rateUndergraduate STEM educationCommunity College Educationqbccmanipulate equationsCellular and Molecular BiologyCreate graphsInterpret graphsbinary fissionsemi-log graphlinear graphgrowth curvecreating graphsExponential and Logarithmic Functions

    920

    views

    1181

    downloads

    0

    comments

    0

    adaptations

    Distributions CURE- Exploring Species Distribution Changes and their Drivers
    This course-based undergraduate research experience (CURE) uses digitized natural history collections data to answer questions about species distributions and their drivers. This inclusive CURE can...

    Keywords: Evolutionecologyidigbiodata management#iNaturalistcourse based undergraduate research experienceshuman impactsspecies distributionscourse-based research experiences (CUREs)digitized natural history collectionsGBIFQGISBCEENETgeoreferencing

    2431

    views

    2273

    downloads

    0

    comments

    0

    adaptations

    Spatial Analysis with QGIS
    Map specimen data points using QGIS, connect them to form a polygon using the Concave Hull plugin, and calculate the range of a species to examine how it changes over time.

    Keywords: natural history collectionsspecies distributionscourse-based research experiences (CUREs)spatial analysisdigitized natural history collectionsQGIS

    1854

    views

    595

    downloads

    0

    comments

    0

    adaptations

    Grassy Narrows and Muskrat Falls Dam: Hypothesis Testing and t-Tests
    Students are introduced to concepts of hypothesis testing using elementary hypothesis tests, t-tests, and p-values as they compare a given fish population for methylmercury levels (using real and...

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

    1941

    views

    1615

    downloads

    0

    comments

    3

    adaptations

    Close

    Home

    Search