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

    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

    550

    views

    748

    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

    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

    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?
    888

    views

    644

    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

    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, 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

    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

    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

    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

    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

    1699

    views

    512

    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

    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

    326

    views

    232

    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

    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

    668

    views

    62

    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

    1863

    views

    668

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search