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

    547

    views

    746

    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

    1322

    views

    1314

    downloads

    0

    comments

    1

    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

    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

    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

    1936

    views

    1611

    downloads

    0

    comments

    3

    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

    1056

    views

    144

    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

    925

    views

    1655

    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

    1285

    views

    647

    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

    640

    views

    624

    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

    638

    views

    879

    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

    1373

    views

    1559

    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

    1294

    views

    802

    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

    1992

    views

    1251

    downloads

    0

    comments

    1

    adaptations

    QB@CC Poster for NABT 2020
    This is a poster presentation at the 2020 NABT Annual PD Conference. This poster describes the goals of QB@CC project, progress in the first year and an update on the upcoming events.

    Keywords: quant bioQuantitative reasoningcommunity collegesquantitative biologyquantitative skillsincubatorsqbccBiology and Math CollaborationOERsNABT 2020NSF grantRCN UBE grantQB learning modules

    1275

    views

    653

    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

    4249

    views

    1643

    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

    3874

    downloads

    0

    comments

    1

    adaptations