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

    4133

    views

    1569

    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

    2054

    views

    333

    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

    1438

    views

    188

    downloads

    0

    comments

    0

    adaptations

    Learn Biological Sciences and Mathematics through cellular respiration, photosynthesis and primary productivity.
    Photosynthesis is a process by which plants synthesize glucose and oxygen in presence of sunlight through light dependent reactions by utilization of sunlight, water to synthesize oxygen, ATP and...

    Keywords: mathematicssimulationThe Analysis of Biological DataMetabolic Pathwaysprocess of sciencephotosynthesisqbccBiological ScienceshypothesisCellular Respirationprimary productivity

    992

    views

    118

    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

    1910

    views

    2464

    downloads

    1

    comments

    0

    adaptations

    Body Size Constraints in Xylem Feeding Insects: Allometric Relationships
    This module introduces body size constraints of xylem-feeding insects in the context of understanding allometric relationships. It is intended for an introductory biology audience.

    Keywords: allometryRatiosexponential equationslogarithmic equationsGenetics and Evolution

    1002

    views

    188

    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

    2605

    views

    1755

    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

    1264

    views

    634

    downloads

    0

    comments

    0

    adaptations

    Water Movement through a Membrane: The Van't Hoff Equation
    This module introduces the van't Hoff equation in the context of understanding the metabolic activity of the epithelial cells lining the stomach. It is intended for an introductory biology audience.

    Keywords: AlgebraInequalitiesCellular Processes

    1035

    views

    192

    downloads

    0

    comments

    0

    adaptations

    Coordinating Photosynthetic Activity: Circadian Rhythms
    This module introduces circadian rhythms in the context of understanding the ability of organisms to measure time. It is intended for an introductory biology audience.

    Keywords: plant physiologyTrigonometrysine waves

    1039

    views

    195

    downloads

    0

    comments

    0

    adaptations

    Cell Aggregation and Sphere Packing
    This module introduces the calculation of packing density in the context of understanding cell aggregation and arrangement. It is intended for an introductory biology audience.

    Keywords: RatiosGeometryInequalitiesCell StructureCell GrowthCell AggregationSphere Packing

    1031

    views

    208

    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

    1676

    views

    1583

    downloads

    0

    comments

    0

    adaptations

    Impact of Introduction of American Bullfrogs on Species Diversity
    This module explores the introduction of the American bullfrog on their ecosystem. Using species diversity calculations and data collection techniques, students explore how the bullfrog affected...

    Keywords: ecologyconservationspecies richnessBiodiversityspecies diversitydiversity indicessamplingspecies evenness

    640

    views

    158

    downloads

    1

    comments

    0

    adaptations

    QB@CC: An interdisciplinary network model for developing and disseminating OER to support pedagogical change
    Presentation given at the Northeast OER Summer 2022 We describe the interdisciplinary network that has been developing and sharing quantitative skills-based OER in biological sciences. The...

    Keywords: Resources @ BioQUESTqbccNortheast OER Summit

    758

    views

    165

    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

    1078

    views

    830

    downloads

    0

    comments

    0

    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

    1756

    views

    3441

    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

    901

    views

    1612

    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

    2636

    views

    4622

    downloads

    0

    comments

    1

    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

    526

    views

    708

    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

    1292

    views

    1275

    downloads

    0

    comments

    1

    adaptations