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

    2506

    views

    1110

    downloads

    0

    comments

    0

    adaptations

    Global Temperature Change in the 21st Century: An Introduction to Global Climate Models and Graphing in Excel (Adapted for Non-Majors)
    Students link human behavior in various climate change scenarios to predicted temperature outcomes at both local (their assigned Latitude) and global (Latitudinal trends) scales. This adaptation is...

    Keywords: ExcelResources @ ESA - TIEEecology labclimate changeenvironmental scienceglobal changehuman-environmental interactionsSimple Linear Regressionhuman impactsinclusive pedagogy-FMN

    1247

    views

    1503

    downloads

    0

    comments

    0

    adaptations

    Buffer Preparation
    This Excel workbook calculates the necessary components to create a buffer solution using the Henderson-Hasselbalch equation.

    Keywords: buffer solutionacidbase

    2

    views

    0

    downloads

    0

    comments

    0

    adaptations

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

    Keywords: molecular evolutionDNA

    1210

    views

    239

    downloads

    0

    comments

    0

    adaptations

    2020-TeachingModule-ModelingNonlethalInfluenzaEpidemic
    We discuss the modeling efforts and tools for success in modeling the spread of nonlethal influenza in an English boarding school

    Keywords: moduleepidemicboarding schoolTeaching Module

    207

    views

    429

    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

    485

    views

    608

    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

    1244

    views

    1202

    downloads

    0

    comments

    1

    adaptations

    MathBench Population Dynamics Module Activity
    The resource accompanies the Mystery of the Missing Housefly Population Dynamics MathBench module which explores exponential and logistic growth models. Students explore the assumptions of the...
    1083

    views

    581

    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

    1513

    views

    217

    downloads

    0

    comments

    0

    adaptations

    REMNet Tutorial, Excel Part 2: Understanding Your Microbiome “Data Summary” Document 4.25.19
    Video on understanding microbiome data from the Research Experiences in Microbiomes Network
    898

    views

    358

    downloads

    0

    comments

    0

    adaptations

    REMNet Tutorial, Excel Part 1: Accessing Your Microbiome Data 5.3.19
    Video on accessing microbiome data from the Research Experiences in Microbiomes Network

    Keywords: data analysisREMNet

    1140

    views

    588

    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

    24

    views

    10

    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

    1419

    views

    286

    downloads

    0

    comments

    0

    adaptations

    1-062-BacteriaGrowth-ModelingScenario
    We offer students a simulation experience or data from a simulation and ask them to model the simulation using several approaches: exponential growth fit, difference equation, differential...

    Keywords: bacteriaexponentialgrowth

    216

    views

    279

    downloads

    0

    comments

    0

    adaptations

    Exploring the population dynamics of wintering bald eagles through long-term data
    Exploring long-term population data through graphical and statistical means Practice module included in Teaching Issues and Experiments in Ecology (TIEE) Volume 7

    Keywords: Resources @ ESA - TIEEcase studypopulation ecologyendangered speciesconservation biologymigration ecology

    1544

    views

    680

    downloads

    0

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets

    Keywords: modelinginfectious diseaseInfectious Disease ModelingSIR modelsSIR

    3869

    views

    3290

    downloads

    0

    comments

    0

    adaptations

    3-017-StackedCoffeeFiltersFalling-ModelingScenario
    Data on free falling 2, 4, 6, and 8 stacked coffee filters is offered. Students form a model using a resistance term proportional to velocity, velocity squared, or velocity to some general power....

    Keywords: dataresistancefalling bodycoffee filterstacked

    298

    views

    202

    downloads

    0

    comments

    0

    adaptations

    Biodiversity
    Biodiversity allows the diversity of a biological population to be estimated with both the Shannon and Simpson biodiversity indices based on information theory.

    Keywords: Shannon diversity indexSimpson diversity indexBiodiversity indicesInformation theory

    24

    views

    2

    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

    419

    views

    432

    downloads

    0

    comments

    0

    adaptations

    RAT ATTACK! Population growth
    This module contains exercises focused on the use and interpretation of density independent and density dependent population growth models. Students build logistic and exponential growth models in...

    Keywords: modelingecologyExcelintroductory biologygraphingQuantitative reasoningdata visualizationinterdisciplinaryexponential growthlogistic growthdata managementInterpreting Graphspopulation modelingNIQBC2. Data and GraphsC4. mathematical modelsnonlinear models

    593

    views

    642

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search