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

    312

    views

    345

    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

    350

    views

    342

    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

    73

    views

    158

    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

    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

    1998

    views

    535

    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

    1261

    views

    281

    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

    1426

    views

    15974

    downloads

    0

    comments

    0

    adaptations

    Quartile Tutorial
    Numbers Count Excel resource

    Keywords: ExcelNumbers Count

    1352

    views

    234

    downloads

    0

    comments

    0

    adaptations

    Confidence Intervals Tutorial
    Numbers Count Excel resource

    Keywords: ExcelNumbers Countconfidence interval

    1456

    views

    549

    downloads

    0

    comments

    0

    adaptations

    Yeast Cell Growth
    Numbers Count resource using Excel for data analysis

    Keywords: data analysisExcelNumbers Count

    1359

    views

    392

    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

    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

    158

    views

    31

    downloads

    0

    comments

    0

    adaptations

    World Population Density
    World population density 1950-2050

    Keywords: dataResources @ BioQUEST - Numbers Count

    1737

    views

    257

    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

    2807

    views

    1259

    downloads

    0

    comments

    0

    adaptations

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

    Keywords: molecular evolutionDNA

    1365

    views

    307

    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

    1572

    views

    241

    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

    1546

    views

    318

    downloads

    0

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets

    Keywords: modelinginfectious diseaseInfectious Disease ModelingSIR modelsSIR

    4075

    views

    3385

    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

    462

    views

    548

    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

    2768

    views

    981

    downloads

    0

    comments

    1

    adaptations

    Close

    Home

    Search