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

    298

    views

    244

    downloads

    0

    comments

    0

    adaptations

    World Population Density
    World population density 1950-2050

    Keywords: dataResources @ BioQUEST - Numbers Count

    1666

    views

    243

    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

    2501

    views

    1109

    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

    1244

    views

    1503

    downloads

    0

    comments

    0

    adaptations

    Exploring the evolution of caffeine biosynthesis enzymes
    Caffeine is a very common stimulant consume worldwide as tea, coffee, mate, cocoa, and chocolate. Ever wondered why plants make caffeine? Do all caffeine producing plants have the same enzymes for...

    Keywords: Bioinformatics EducationBioinformatics and Genomics

    1659

    views

    523

    downloads

    0

    comments

    0

    adaptations

    Introduction to Genome Annotation
    This exercise is an adaptation of the Annotation Lesson by Rosenwald et al. It introduces the use of bioinformatics tools to extract information from genome databases. It is a basic lesson on...

    Keywords: microbiologyGenome annotationBioinformatics EducationBioinformatics and Genomics

    1897

    views

    601

    downloads

    0

    comments

    0

    adaptations

    Biobyte 4 - The role of data science principles and practices in undergraduate biology
    This short activity was an effort to launch a community conversation around the interface of data science principles and practices and undergraduate biology education. A variety of resources,...

    Keywords: biostatisticsstatistical analysisavian malariaSummer Workshop 2018

    1027

    views

    570

    downloads

    0

    comments

    0

    adaptations

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

    Keywords: molecular evolutionDNA

    1207

    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

    205

    views

    426

    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

    484

    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

    1240

    views

    1197

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

    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

    1500

    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
    892

    views

    357

    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

    1136

    views

    587

    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

    1413

    views

    285

    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

    215

    views

    278

    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

    1536

    views

    673

    downloads

    0

    comments

    0

    adaptations

    Using Bioinformatics Activities to understand the Past and Present of SARS-CoV2
    We have designed a Bioinformatics activity that uses tools to identify the origins and mutations in the novel SARS-CoV2 strains.
    1814

    views

    1148

    downloads

    0

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets

    Keywords: modelinginfectious diseaseInfectious Disease ModelingSIR modelsSIR

    3856

    views

    3287

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search