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

    Climate Change Module (Project EDDIE) for Introductory Statistics
    Students practice and deepen their understanding of bivariate numerical data analysis (correlation, linear regression, etc.) through working with data related to climate change. Adapted from a...

    Keywords: statistics

    888

    views

    649

    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

    3009

    views

    3954

    downloads

    0

    comments

    1

    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

    935

    views

    1216

    downloads

    0

    comments

    0

    adaptations

    Biostatistical Tools
    This Excel collection of workbooks has tools for: 1. Linear regression through the origin 2. Linear regression not through the origin 3. Polynomial fit 4. A simple chi-square analysis to test...

    Keywords: linear regressionchi-square analysisHardy-Weinberg equilibriumpolynomial regression

    118

    views

    59

    downloads

    0

    comments

    0

    adaptations

    Continuous Growth Models
    This Excel worksheet compares user-input growth data with predictions under linear, exponential, and logistic models of growth. Introduces concepts of statistical analysis that can be additionally...

    Keywords: exponential growthlogistic growthcurve fittinglinear growthgrowth models

    95

    views

    32

    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

    1708

    downloads

    0

    comments

    0

    adaptations

    Biological Cellular Automata Laboratory (BioCA Lab)
    This Excel module includes both linear cellular automata and 2D cellular automata. The original 3 rules for survival, death, and birth are implemented in this module, but users with some Excel...

    Keywords: cellular automata

    182

    views

    80

    downloads

    0

    comments

    0

    adaptations

    The Importance of Street Trees and Urban Avifauna: A lesson exploring the relationship between urban forest and foraging birds
    This module examines the relationship between street trees, urban avifauna, and socioeconomic gradients in the highly urbanized county of Los Angeles, California. Using edited data from a published...

    Keywords: conservationBiodiversityurbanizationGeneralized linear modelsavifaunaurban forestsocioeconomicsstreet treesnegative binomial regression

    1026

    views

    709

    downloads

    0

    comments

    0

    adaptations

    The Influence of Exotic Plant Invasion on Pollinator Abundance
    This lesson introduces two global change factors, natural habitat loss and exotic plant invasion, and analyzes how these stressors impact the biodiversity and abundance of pollinator species....

    Keywords: statisticsinvasion biologyecologyRStudioBiodiversityInvasive SpeciesPearson correlation coefficientgeneral linear modelsinvasive plantspollinatorsPopulation abundance

    949

    views

    540

    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

    Michaelis-Menten Enzyme Kinetics
    In this simulation, equations used in enzyme kinetics (Michaelis-Menten, Eadie-Hofstee, Dixon, and Lineweaver-Burk) are modeled under various conditions.

    Keywords: Michaelis-Mentenenzymesenzyme kinetics

    1610

    views

    364

    downloads

    0

    comments

    0

    adaptations

    A Potential Novel Ecosystem Service: Seagrass Meadows Reduce Disease in Nearby Corals
    In this lesson, students will receive an introduction to Poisson Generalized Linear Mixed Models in R utilizing data on coral diseases. In their code, students will assess if seagrass status has an...

    Keywords: environmental scienceseagrassecosystemcoral reefsEcosystem Services

    612

    views

    619

    downloads

    0

    comments

    0

    adaptations

    Climate-Induced Shifts in California Butterflies
    A module in which students generate and test hypotheses about butterfly species’ response to climate change in the Central Valley and Sierra Nevada Mountains of northern California using publicly...

    Keywords: linear regressionScatter Plotsclimate changephenologyhypothesis formulationmountainsCaliforniapublic dataCODAP

    1220

    views

    290

    downloads

    0

    comments

    0

    adaptations

    Aquatic Macroinvertebrates and Urbanization: Exploring urbanization’s effect on leaf litter decomposition in six streams of Puerto Rico using R
    Urbanization effects stream ecosystems by introducing pollutants to the streams.. This has detrimental effects on the life of the streams such as the aquatic macroinvertebrates who are in charge of...

    Keywords: aquatic macroinvertebratesStream ecologyurbanizationsurban runoff

    991

    views

    642

    downloads

    0

    comments

    0

    adaptations

    Biodiversity Conservation in Agriculture
    Biodiversity is decreasing rapidly each year and agriculture is a large contributor. In order to minimize biodiversity loss, we must study how local and landscape management in agriculture impact...

    Keywords: conservationagricultureBiodiversitybiodiversity conservationagricultural conservation

    554

    views

    506

    downloads

    0

    comments

    0

    adaptations

    Investigating Determinants of Richness in Ephemeral and Permanent Wetlands Using Linear Models in Shiny
    This resource seeks to provide a quantitative platform by which students can be taught about interactive effects using the TIEE module created by Little (2018). Key to the adaptation is the use of...

    Keywords: aquatic macroinvertebrateslinear regressionhypothesis testingshinywetlands

    1675

    views

    1285

    downloads

    0

    comments

    0

    adaptations

    Balancing Chemical Equations Using Matrix Algebra
    This Excel workbook introduces using matrix algebra to balance chemical reactions. The workbook allows the user to set up their own matrices for chemical reactions involving 2-7 elements.

    Keywords: chemical reactionsInverse matrix methodmatrix algebra

    176

    views

    38

    downloads

    0

    comments

    0

    adaptations

    Developmental Allometry: Scaling in Growth
    This Excel workbook illustrates a number of allometric equations in animal growth. The workbook also calculates an allometric equation with graphical output for data entered by the user.

    Keywords: allometrybrain developmentSkeletal Systemmetabolic rate

    95

    views

    49

    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

    2098

    views

    351

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search