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

    4299

    views

    1680

    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

    562

    views

    787

    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

    1332

    views

    1331

    downloads

    0

    comments

    1

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

    views

    1125

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

    views

    1517

    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

    662

    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

    1486

    views

    205

    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

    2062

    views

    2629

    downloads

    1

    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

    1193

    views

    438

    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

    1092

    views

    379

    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

    1283

    views

    675

    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

    145

    views

    144

    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

    2098

    views

    351

    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

    2457

    views

    2331

    downloads

    0

    comments

    0

    adaptations

    Cellular Respiration and pH: blocking the electron transport chain and its effects on the proton gradient, pH, and ATP production
    This module contains exercises designed to help students describe the stages of cellular respiration and quantify the energy molecules produced. Students will predict the region of higher proton...

    Keywords: introductory biologyQuantitative reasoningquantitative biologyinterdisciplarycell functionInterpreting GraphsATPpHCellular RespirationEnergy transformationsElectron flowNIQBC2. Data and GraphsC4. mathematical modelsC1. Numeracyproton gradientelectron transportelectron transport blockersFADH2chemiosmosisATP synthaseNADHproton concentration

    1712

    views

    520

    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

    1883

    views

    605

    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

    348

    views

    242

    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

    1393

    views

    1602

    downloads

    0

    comments

    0

    adaptations

    Evaluation of DEIJ in Lectures of Junior Year Science Undergraduate Course
    Diversity, equity, inclusion, and social justice, DEIJ, is important for both students and faculty as they improve learning outcomes and elicit professional competency respectively. DEIJ...

    Keywords: stempedagogyArticleUndergraduateOpen Sourcescienceevaluationneurobiologythe role of active learning in retention and engagementFacultyAnalysismethod#DEI-J-ADEIJinterdisplinaryjunorlearning spacesadditional support learning systemenhancement

    686

    views

    66

    downloads

    0

    comments

    0

    adaptations

    Applying phylogenetic tree building in MEGA X to forensic applications for identifying unknown specimens
    This exercise is designed to guide a learner through the construction of phylogenetic trees as a means of addressing research questions in forensic science such as the identification of previously...

    Keywords: taxonomyBioinformatics and GenomicsDNA Barcodinginvertebrate phylogeneticsforensic entomology

    1870

    views

    675

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search