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

    599

    views

    37

    downloads

    0

    comments

    0

    adaptations

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

    views

    219

    downloads

    0

    comments

    1

    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

    1382

    views

    15070

    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

    58

    views

    12

    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

    1184

    views

    808

    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

    850

    views

    552

    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

    120

    views

    48

    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

    2167

    views

    1104

    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

    1310

    views

    405

    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

    134

    views

    73

    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

    74

    views

    28

    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
    925

    views

    383

    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

    2624

    views

    216

    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

    1858

    views

    2433

    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

    2596

    views

    1155

    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

    1232

    views

    634

    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

    1343

    views

    386

    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

    72

    views

    25

    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

    221

    views

    506

    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

    1166

    views

    610

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search