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
    Ground Spider Survey QUBES Resource Draft (1)
    This QUBES Module aims to introduce students to standardized ecological field methods, measures of diversity, ArcGIS Online, and Excel. This is achieved through nocturnal survey of ground spiders.

    Keywords: Community EcologyspidersMicrosoft ExcelShannon diversity index

    321

    views

    366

    downloads

    0

    comments

    0

    adaptations

    GSD QUBES Resource Draft (1)
    This QUBES module is focused towards AP Environmental studies courses. It includes hypothesis testing, transect sampling, Shannon Diversity Index, and scatter plot and bar graph creation in excel.

    Keywords: Community EcologyField researchspidersMicrosoft ExcelShannon diversity index

    360

    views

    360

    downloads

    0

    comments

    0

    adaptations

    Trail Camera Field Survey Module
    This QUBES module introduces high school students to the exciting world of field surveys using trail cameras. Designed for environmental science classes, the module offers a hands-on approach to...

    Keywords: graphsspecies richnessCommunity EcologymammalsMicrosoft Exceldichotomous keycamera trapsShannon diversity indexTrail CamerasPivotTables

    86

    views

    190

    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

    Decoding, Critiquing, and Creating a Graph from the Ground Up
    Students decipher a published graph with little supplemental information and are given more details in pieces before producing a new graph that displays the data more effectively and is easier to...

    Keywords: EvolutionExcelgraphingBar GraphsbiomimicryScientific ProcessStatistics and MathMicrosoft Excel

    2017

    views

    541

    downloads

    0

    comments

    0

    adaptations

    3D FractaL-Tree
    3D FractaL-Tree allows scientists to collect data from actual specimens in the field or laboratory, insert these measurements into a spatially explicit L-system package, and then visually compare...

    Keywords: fractalsL-systems

    1274

    views

    290

    downloads

    0

    comments

    0

    adaptations

    Analysis of Amylase Activity
    This lab is an exploration of enzyme function and the effects of environmental conditions on the activity of the enzyme amylase. The lab utilizes analytical and graphing skills to assess enzyme...

    Keywords: data analysisintroductory biologyconcentrationgraphinglinear equationsBiochemistryscientific methodstandard curveenzyme functionMicrosoft ExcelInterpreting GraphsenzymesqbccCreate graphsInterpret graphsSolving Equations and Inequalitiesinterpret tablesAmylaseAlpha-amylaseEnzyme activityMaltoseDNS assayAbsorbancelab reportspectrophotometryregression linemanipulating equationsline of best fitgraphing by hand

    1452

    views

    16374

    downloads

    0

    comments

    0

    adaptations

    Quartile Tutorial
    Numbers Count Excel resource

    Keywords: ExcelNumbers Count

    1363

    views

    236

    downloads

    0

    comments

    0

    adaptations

    Confidence Intervals Tutorial
    Numbers Count Excel resource

    Keywords: ExcelNumbers Countconfidence interval

    1463

    views

    552

    downloads

    0

    comments

    0

    adaptations

    Yeast Cell Growth
    Numbers Count resource using Excel for data analysis

    Keywords: data analysisExcelNumbers Count

    1376

    views

    402

    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

    2062

    views

    2629

    downloads

    1

    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

    175

    views

    36

    downloads

    0

    comments

    0

    adaptations

    World Population Density
    World population density 1950-2050

    Keywords: dataResources @ BioQUEST - Numbers Count

    1746

    views

    260

    downloads

    0

    comments

    0

    adaptations

    Cleaning Biodiversity Data: A Botanical Example Using Excel or RStudio
    Access and clean an open source herbarium dataset using Excel or RStudio.

    Keywords: Exceldata in the classroomRStudiobiodiversity informaticsnatural history collectionsHerbariaData cleaning

    2835

    views

    1279

    downloads

    0

    comments

    0

    adaptations

    EvolSeq
    An Excel worksheet that simulates the molecular evolution of DNA sequences.

    Keywords: molecular evolutionDNA

    1388

    views

    314

    downloads

    0

    comments

    0

    adaptations

    SUMS4Bio - Video tutorials in math and stats for biology students
    Links to videos and pdf tutorials for core mathematical and statistical concepts used in biology

    Keywords: Probabilitystatisticsmathematicsvideoschi-squaredExcelBar Graphsline graphsScatter Plotsp-valuest-testsExponentsLogarithmsproportionsRatiosbinomialdata typessummary statisticsfrequency histogramsResources @ SUMS4BioPresentation

    1583

    views

    243

    downloads

    0

    comments

    0

    adaptations

    ABO Blood Group Frequencies
    An Excel workbook in which students can calculate blood type frequencies through different approaches (Hardy-Weinberg, quadratic formula, and the EM algorithm). The workbook shows the formulas...

    Keywords: Hardy-Weinbergblood type frequencies

    1567

    views

    333

    downloads

    0

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets

    Keywords: modelinginfectious diseaseInfectious Disease ModelingSIR modelsSIR

    4107

    views

    3392

    downloads

    0

    comments

    0

    adaptations

    A Beginner's Guide To Sampling Rockpools
    In this guide, we'll teach you how to sample rockpools, collect data, make visuals from data, and interpret data in order to see if any correlations exist.

    Keywords: aquatic macroinvertebratesdata collectionsrockpoolsampling

    474

    views

    578

    downloads

    0

    comments

    0

    adaptations

    Cleaning Biodiversity Data: Excel
    Access and clean an open source polar bear dataset using Excel.

    Keywords: data in the classroombiodiversity informaticsData cleaning

    2802

    views

    992

    downloads

    0

    comments

    1

    adaptations

    Close

    Home

    Search