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
    Phenology Trends and Climate Change in Minnesota (Project EDDIE)
    In this module, students will practice answering a specific question about how climate change has affected flowering date in American elm trees. Students can then practice on a species of their own...
    1074

    views

    226

    downloads

    0

    comments

    1

    adaptations

    BioGrapher
    BioGrapher is an Excel front-end for the AT&T GraphViz graphical visualization and layout package (http://www.graphviz.org/).

    Keywords: network theorygraph theoryphylogenetic trees

    616

    views

    41

    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

    1429

    views

    16052

    downloads

    0

    comments

    0

    adaptations

    Operon
    This Excel workbook models lac operon function in a partial diploid E. coli. The user chooses the bacterial genotype and the sugars present in the surrounding medium: the workbook then determines...

    Keywords: Lac OperonE. coli

    82

    views

    18

    downloads

    0

    comments

    0

    adaptations

    REMNet Tutorial, Excel Part 4: Focusing on Taxonomy 4.26.19
    Video on analyzing microbiome data in Excel from the Research Experiences in Microbiomes Network

    Keywords: The Analysis of Biological DataExcelVideoMicrobiology Educationteaching with technologymicrobiomesSwirlresearch in the classroomREMNeturban microbiomes

    1209

    views

    838

    downloads

    0

    comments

    0

    adaptations

    Home sweet home for warblers: Graphing and Analysis using R
    This resource expands on the Data Nugget "Trees and bushes, Home Sweet Home for Warblers". The analyses and graphing is done in R and there are questions that ask about the management implications.

    Keywords: graphingCommunity Ecologydata interpretationR software

    894

    views

    582

    downloads

    0

    comments

    0

    adaptations

    2008-Ahmed_Mohameden-Solving initial-value second order ordinary differential equations on an Excel spreadsheet
    This paper presents a friendly method of solving initial-value second order differential equations (DEs) analytically on a MS Excel© workbook.

    Keywords: ExcelSpreadsheet

    130

    views

    52

    downloads

    0

    comments

    0

    adaptations

    Ecology of Infectious Disease: Data Mining the National Notifiable Diseases Surveillance System (NNDSS) for Ecological Patterns
    How to use publicly available infection case data to teach ecology and evolution of human infectious diseases.

    Keywords: Evolutionecologyinfectious diseasehumansjigsawsmall group workEvolutionary medicinedata explorationCDCNNDSS

    2191

    views

    1122

    downloads

    0

    comments

    0

    adaptations

    Math and Stats in the Biology Classroom with HHMI BioInteractive
    Conquer basic math and statistics used in biology while exploring classroom-ready resources. Concepts include central tendency and variation, spreadsheet skills, graphing, and data analysis with...

    Keywords: HHMI BioInteractive

    1331

    views

    411

    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

    166

    views

    78

    downloads

    0

    comments

    0

    adaptations

    javaFOODWEB
    More than 100 food web matrices (multiple predators/prey Excel worksheets) are included with the javaFOODWEB tool.

    Keywords: niche spacesCommunity Ecologyfood webspredator-prey interactionsMatricestrophic chain

    114

    views

    45

    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
    948

    views

    407

    downloads

    0

    comments

    0

    adaptations

    Integrating Community Ecology Into the Study of Parasites: Exploring the Effect of Host Behavior on Parasite Transmission Rates
    Organismal life cycles are often presented as a set of facts to memorize in undergraduate biology courses. This approach is cognitively demanding for students and fails to convey how central life...

    Keywords: statisticsspecies interactionsQuantitative reasoninggraphsCommunity EcologyParasitologyfood webs

    2700

    views

    233

    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

    2544

    downloads

    1

    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

    1260

    downloads

    0

    comments

    0

    adaptations

    Data, Distributions, and Hypotheses: Exploring Diversity and Disturbance in the Tallgrass Prairie
    Proper hypothesis generation, data handling, graphing, and communication are essential skills that undergraduate majors in biology are expected to master. However, students rarely get hands-on...

    Keywords: Quantitative reasoningRestoration EcologyScience process skillstall grass prairie ecosystem

    1404

    views

    388

    downloads

    0

    comments

    0

    adaptations

    Big Data, Graphs, and Prediction
    In this activity, students are introduced to graphing and modeling data in a step-wise fashion. Real data of covid-19 deaths over time are used to incrementally ask students to fit the data to...

    Keywords: epidemiologygraphingLogarithmsexponential growthqbcccovidChoosing modelsCreate graphsInterpret graphsConcepts in Statistics

    1286

    views

    648

    downloads

    0

    comments

    0

    adaptations

    Genetic Code
    This Excel workbook allows the user to recreate the steps in breaking the genetic code. The user enters the sequence of repetitive synthetic mRNA strands, which are translated in vitro to produce...

    Keywords: mRNAgenetic code

    97

    views

    33

    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

    232

    views

    520

    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

    1189

    views

    640

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search