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

    479

    views

    607

    downloads

    0

    comments

    0

    adaptations

    MS Excel Refresher - Lizards, iguanas, and snakes! Oh my! | Data Nuggets
    This resource, a MS Excel refresher, extends the level for this Data Nugget. Students are given an Excel workbook with the data and asked to graph and calculate diversity using Excel functions...

    Keywords: Resources @ Data NuggetsspreadsheetsRestoration EcologyUsing Excelgraphing in Excelformulas in ExcelApplied ecology

    557

    views

    299

    downloads

    0

    comments

    0

    adaptations

    Three Research-Based Quantitative Reasoning Modules for Introductory Organismal Biology Laboratories
    We have designed three laboratory modules for an introductory organismal biology course with an emphasis on quantitative reasoning and data analysis skills. Module 1 tests for dimorphism in...

    Keywords: allometryplantsAnatomytranspirationdimorphisminvertebrate biologyarthropodsplatyhelminths

    3528

    views

    173

    downloads

    0

    comments

    0

    adaptations

    Population Demography in Swirl
    The students will learn to generate, test, and graphically represent basic hypotheses on data distributions using large datasets.

    Keywords: ecologyPopulation statisticslife history curves

    824

    views

    441

    downloads

    0

    comments

    0

    adaptations

    Isolation and Functional Analysis of a Pancreatic Enzyme in an Introductory Student Lab
    Structure and function are correlated at all levels of biology. This topic is typically addressed early in an undergraduate class in general or molecular biology before students have gained much...

    Keywords: Protein StructureproteaseEnzymechemical bondscatalysissolubility

    3493

    views

    187

    downloads

    0

    comments

    0

    adaptations

    A Rapid Genetic Screen Using Wisconsin Fast Plants®: A Hands-On Approach to Inheritance of de novo Mutations
    Some concepts in genetics, such as genetic screens, are complex for students to visualize in a classroom and can be cumbersome to undertake in the laboratory. Typically, very large populations are...

    Keywords: mutationInheritancegermlinesomaplant lifecycle

    2200

    views

    148

    downloads

    0

    comments

    0

    adaptations

    Integrating Community Ecology Into the Study of Parasites: Exploring the Effect of Host Behavior on Parasite Transmission Rates
    Organismal life cycles are often presented as a set of facts to memorize in undergraduate biology courses. This approach is cognitively demanding for students and fails to convey how central life...

    Keywords: statisticsspecies interactionsQuantitative reasoninggraphsCommunity EcologyParasitologyfood webs

    2572

    views

    210

    downloads

    0

    comments

    0

    adaptations

    1-010-AtmosphericCO2Bifurcation-TechniqueNarrative
    Students are introduced to the concept of a bifurcation in a first-order ordinary differential equation (ODE) through a modeling scenario involving atmospheric carbon dioxide whish is taken as a...

    Keywords: carbon dioxideSurface Atmosphere Exchangebifurcationfold bifurcationsaddle node

    458

    views

    235

    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

    1277

    views

    1406

    downloads

    0

    comments

    0

    adaptations

    Home sweet home for warblers: Graphing and Analysis using R
    This resource expands on the Data Nugget "Trees and bushes, Home Sweet Home for Warblers". The analyses and graphing is done in R and there are questions that ask about the management implications.

    Keywords: graphingCommunity Ecologydata interpretationR software

    821

    views

    530

    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

    837

    views

    1115

    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

    1773

    views

    2241

    downloads

    1

    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

    3942

    views

    1393

    downloads

    0

    comments

    0

    adaptations

    Undergraduate Research and Microbiology Science Community (µRAMS) lighning talk BIOME Institute 2021
    The uRAMS (undergraduate Research and Microbiology Science community) was created by faculty and researchers at Colorado State University as part of our engagement with the 2021 BIOME Institute....

    Keywords: undergraduate researchcritical readingMicrobiology Educationundergraduate educationquantitative skillsScience Communicationdei

    1267

    views

    418

    downloads

    0

    comments

    0

    adaptations

    A 360˚ View of COVID-19
    In March 2020, institutions underwent a massive transition to distance learning as a result of the COVID-19 pandemic. With so little time to devise new materials to maximize learning in the new...

    Keywords: geneticsImmunologyBiochemistrybioinformaticsmolecular evolutionpublic healthvirusCOVID19

    3479

    views

    1671

    downloads

    0

    comments

    0

    adaptations

    Moths and Frogs and E. coli, Oh My!: Agent-based Modeling of Evolutionary Systems
    In evolution classrooms, introducing and reinforcing the idea of genetic drift and random selection can be challenging, as can be reinforcing appropriate mental models of evolution. Agent-based...

    Keywords: modelingEvolutionecologyagent-based modelingGenetic Driftenvironmental scienceNatural Selectioncompetitive coevolutionsimulation modelingevolutionary reasoning

    2922

    views

    431

    downloads

    0

    comments

    0

    adaptations

    How Do Kidneys Make Urine From Blood? Qualitative and Quantitative Approaches to Filtration, Secretion, Reabsorption, and Excretion
    The function of the kidneys is to help maintain a constant internal environment (homeostasis) by regulating the volume and chemical composition of the blood. This regulation occurs via three...

    Keywords: collecting ductexcretionglomerular filtration rate (GFR)nephron tubulereabsorptionrenal corpusclesection

    4648

    views

    600

    downloads

    0

    comments

    0

    adaptations

    Targeting Misconceptions in the Central Dogma by Examining Viral Infection
    Understanding the central dogma and how changes in gene expression can impact cell function requires integration of several topics in molecular biology. Students often do not make the necessary...

    Keywords: datatranscriptionvirustranslationprotein functionmembrane transportPredictions

    2920

    views

    451

    downloads

    0

    comments

    0

    adaptations

    A Remote-Learning Framework for Student Research Projects: Using Datasets to Teach Experimental Design, Data Analysis and Science Communication
    Remote learning often requires an alternative to hands-on, student-designed research projects. To this end, we created a package of scaffolded assignments to support introductory students through...

    Keywords: population growthphysiologyecotoxicologyphotosynthesis

    2472

    views

    361

    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

    1235

    views

    1192

    downloads

    0

    comments

    1

    adaptations

    Close

    Home

    Search