Skip to Main Content
Powered by QUBES

Quantitative Biology at Community Colleges

Resources

Want to find additional resources? Browse resources on QUBES!
QUBES hosts not only the resources shown here, but many more created by the broader QUBES community.
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

    563

    views

    789

    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

    1333

    views

    1331

    downloads

    0

    comments

    1

    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

    402

    views

    148

    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

    1954

    views

    1650

    downloads

    0

    comments

    3

    adaptations

    Why Cells Change Weight: Demonstrating Linear Regression Through an Osmosis Experiment
    In this activity, students will perform an experiment utilizing dialysis tubing to create cellular models to demonstrate the linear relationship between cell weight and time in varying tonicities....

    Keywords: graphingqbccCellular and Molecular BiologyInterpret graphsConcepts in Statistics

    1579

    views

    1454

    downloads

    0

    comments

    0

    adaptations

    Grassy Narrows and Muskrat Falls Dam: The Central Limit Theorem and a t-test
    Students are introduced to concepts of sampling distributions and hypothesis testing using a simulation applet, elementary hypothesis tests, t-tests, and p-values as they compare a given fish...

    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

    654

    views

    932

    downloads

    0

    comments

    0

    adaptations

    Modified Grassy Narrows and Muskrat Falls Dam: Hypothesis Testing and t-Tests
    Methylmercury contamination within fish populations is an important toxin that affect human, animal, and environmental health, serving as a carcinogen (cancer-causing agent) and endocrine-disruptor...

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

    654

    views

    661

    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

    4300

    views

    1681

    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

    1394

    views

    1610

    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

    1488

    views

    208

    downloads

    0

    comments

    0

    adaptations

    Big Data, Graphs, and Prediction
    In this activity, students are introduced to graphing and modeling data in a step-wise fashion. Real data of covid-19 deaths over time are used to incrementally ask students to fit the data to...

    Keywords: epidemiologygraphingLogarithmsexponential growthqbcccovidChoosing modelsCreate graphsInterpret graphsConcepts in Statistics

    1311

    views

    674

    downloads

    0

    comments

    0

    adaptations

    Choosing healthy data for healthy relationships: how to use 5-point summaries, box and whisker plots, and correlation to understand global health trends.
    This module utilizes a user-friendly database exploring data selection, box-and-whisker plot, and correlation analysis. It also guides students on how to make a poster of their data and conclusions.

    Keywords: Querying databasesgraphingRatiosdata typesstatistical learningcorrelationBox Plotsqbcchealth sciences education researchnutrition & food scienceUnderstanding ratesCreate graphsInterpret graphsinterpret tablesHealth ScienceConcepts in Statisticsexplaining statisticsusing statistics

    2639

    views

    1815

    downloads

    0

    comments

    0

    adaptations

    Using Linear Regression to Explore Environmental Factors Affecting Vector-borne Diseases
    In this activity students will use linear regression to analyze real data on vector-borne diseases and explore how environmental factors such as climate change or population density influence the...

    Keywords: ecologygraphingmicrobiologyqbccUnderstanding ratesCreate graphsInterpret graphsinterpret tablesConcepts in Statistics

    2686

    views

    4767

    downloads

    0

    comments

    1

    adaptations

    Evolution of Tusklessness in African Elephants
    The exploitation of African elephants in the form of ivory poaching is exacerbated by warfare. The affects of this anthropogenic evolutionary force on the African savanna elephant (Loxodonta...

    Keywords: Hardy-Weinbergchi-squaredEvolutionExponentsRatiospercentselephantsGorongosa National ParkAfricaqbccUnderstanding fractionsSolving Equations and InequalitiesConcepts in Statisticsusing statisticstusk & tusklessIvory poachingFractions and Mixed NumbersDecimals

    1811

    views

    3493

    downloads

    0

    comments

    0

    adaptations

    Using Linear Regression Adaptation: Exploring Vector-borne diseases in an online classroom
    In this adaptation students in online classrooms will use linear regression at home and in synchronous online time to analyze real data on vector-borne diseases and explore how environmental...

    Keywords: ecologygraphingmicrobiologyqbccUnderstanding ratesCreate graphsInterpret graphsinterpret tablesConcepts in Statistics

    942

    views

    1705

    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

    2065

    views

    2629

    downloads

    1

    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

    The Chi-Square Test
    This module introduces how to determine whether observation is significantly different from expectation in the context of understanding Chi-square Test. It is intended for an introductory biology...

    Keywords: ProbabilityProbability & StatisticsGenetics and EvolutionStatistical Testing

    1157

    views

    247

    downloads

    0

    comments

    0

    adaptations

    Sizes, Scales and Specialization: Adapted to add scientific notation review
    This module explores how cell size and shape varies across cell types in the human body by having students calculate relative proportions of numbers in scientific notation. The adaptation has...

    Keywords: ExponentsRatiosScientific Notationcell typeqbccmanipulate equationsCellular and Molecular Biologyconverting unitschanging scales

    1115

    views

    866

    downloads

    0

    comments

    0

    adaptations

    The Perfect Brew: An Activity Demonstrating Cell Counting and Hemocytometer Use
    In this activity, students will explore the use of a hemocytometer for counting cells, demonstrate the relationship between the grid seen in the microscope with volume of liquid in suspension and...

    Keywords: RatiosmicrobiologyqbccCellular and Molecular BiologyUnderstanding fractionsconverting unitschanging scalesmeasurements

    1307

    views

    814

    downloads

    0

    comments

    0

    adaptations