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

    4249

    views

    1643

    downloads

    0

    comments

    0

    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

    383

    views

    139

    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

    2657

    views

    4675

    downloads

    0

    comments

    1

    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

    925

    views

    1655

    downloads

    0

    comments

    0

    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

    1566

    views

    1422

    downloads

    0

    comments

    0

    adaptations

    Cardiac Output
    This module introduces Fick's principle in the context of understanding the cardiac output. It is intended for an introductory biology audience.

    Keywords: linear regressionproportionslinear equationsOpenStaxAnimal Physiology

    1072

    views

    218

    downloads

    0

    comments

    0

    adaptations

    Translocation of Nutrients in the Phloem: Dixon's Paradox
    This module introduces the Dixon equation in the context of understanding nutrient transport through sieve tubes. It is intended for an introductory biology audience.

    Keywords: plant physiologylinear regressionlinear equations

    1282

    views

    204

    downloads

    0

    comments

    0

    adaptations

    Doubling Time of Tumors
    This module introduces the calculation of potential doubling time of tumorous cells in the context of understanding the growth of a population of the cells. It is intended for an introductory...

    Keywords: linear regressionRatiosCell StructureOpenStaxCell Growth

    1041

    views

    200

    downloads

    0

    comments

    0

    adaptations

    Amino Acid Frequency
    This module introduces expected frequencies in the context of understanding amino acid composition. It is intended for an introductory biology audience.

    Keywords: Probabilitylinear regressionamino acidsOpenStaxGenetic InformationAminoAmino Acid Freuency

    1917

    views

    555

    downloads

    0

    comments

    0

    adaptations

    Permeability of Molecules
    This module introduces Overton's Rule in the context of understanding the permeability of molecules across the cell membrane. It is intended for an introductory biology audience.

    Keywords: linear regressionPermeabilityCell StructureCell MembraneOpenStaxphospholipid membranelog-log plotsOverton's rule

    1064

    views

    213

    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

    2009

    views

    2540

    downloads

    1

    comments

    0

    adaptations

    Students examine the diversity of human cell sizes and number using scientific notation
    In this powerpoint, several of the resources from the published module 'Sizes, Scales and Specialization' are used to create a mini-module that has students examine the size and abundance of...

    Keywords: ExponentsRatiosqbccmanipulate equationsCellular and Molecular Biologyconverting unitschanging scales

    979

    views

    276

    downloads

    0

    comments

    0

    adaptations

    Antibody Binding
    This module introduces the Scatchard equation in the context of understanding antigen binding and the properties of antigens. It is intended for an introductory biology audience.

    Keywords: linear equationshyperbolic equationsCellular Processes

    1259

    views

    210

    downloads

    0

    comments

    0

    adaptations

    Why does Blood Flow Change? Investigating the Math of Blood Flow Dynamics
    This collection of activities explores the relationship between blood flow, pressure, and the factors of resistance through graphs and modeling direct and inverse variation.

    Keywords: quant biographingRatiosmathassessmentcollege algebraundergraduate educationphysiologyAnatomyhuman biologyvariationCardiovascular physiologyAnatomy & Physiologylab activityOpenStaxqbccmanipulate equationsUnderstanding fractionsChoosing modelsUnderstanding ratesEstimating answersUse elementary functionsCreate graphsInterpret graphsRates and ProportionsSolving Equations and Inequalities

    1698

    views

    1607

    downloads

    0

    comments

    0

    adaptations

    Translocation of Nutrients in the Phloem: Poiseuille's Equation
    This module introduces the Poiseuille equation in the context of understanding nutrient flow in plant cells. It is intended for an introductory biology audience.

    Keywords: plant physiologycalculushyperbolic equationsrates of change

    1171

    views

    234

    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

    2981

    views

    3870

    downloads

    0

    comments

    1

    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

    1285

    views

    647

    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

    2626

    views

    1779

    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

    1462

    views

    197

    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

    547

    views

    746

    downloads

    0

    comments

    0

    adaptations