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
    ESS: Evolutionary Stable Strategies Game Theory Module
    This Excel workbook illustrates a number of ESS examples. Each example allows the user to manipulate the initial population for each strategy and the fitness payoffs and costs for each strategy.

    Keywords: population geneticsfitnessgame theorySequence alignmentevolutionary stable strategies

    73

    views

    20

    downloads

    0

    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

    131

    views

    27

    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

    4124

    views

    1564

    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

    1192

    views

    816

    downloads

    0

    comments

    0

    adaptations

    Simple Heat Maps with Morpheus
    Learn how to load an Excel file of raw data into Morpheus and change between relative and global scales.

    Keywords: Excelbioinformaticsgenomicsyoutubemorpheusheat maps

    1303

    views

    268

    downloads

    0

    comments

    0

    adaptations

    Unwrapping Enzyme Kinetics
    Enzyme rates and kinetics are key components used by biochemists to understand how enzymes function. However, students often find it difficult to understand how these experiments are performed and...

    Keywords: kineticsstructure-functionenzymescatalysis

    2659

    views

    727

    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

    145

    views

    75

    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

    331

    views

    330

    downloads

    0

    comments

    0

    adaptations

    World Population Density
    World population density 1950-2050

    Keywords: dataResources @ BioQUEST - Numbers Count

    1710

    views

    248

    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

    1706

    views

    543

    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

    1953

    views

    677

    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

    1087

    views

    616

    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

    2645

    views

    1191

    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

    1289

    views

    1579

    downloads

    0

    comments

    0

    adaptations

    Two-Species Model
    These two Excel worksheets simulate the population growth of two interacting species. In isolation, each species grows logistically, but interaction effects between species may limit or enhance...

    Keywords: population growthcompetition modelsLotka-Volterra

    126

    views

    43

    downloads

    0

    comments

    0

    adaptations

    Serial Dilutions
    In this Excel workbook, users will enter the original cell concentration and the desired dilution factor (10, 100, and 1000). The program will then calculate the new cell concentration.

    Keywords: concentrationScientific Notationorders of magnitudeserial dilutions

    83

    views

    40

    downloads

    0

    comments

    0

    adaptations

    Phylogeography Simulator
    This Excel workbook simulates the phylogeography of an asexually reproducing species.

    Keywords: Phylogeographymutation ratesAsexual reproductionspecies dispersal

    70

    views

    9

    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

    89

    views

    32

    downloads

    0

    comments

    0

    adaptations

    Continuous Growth Models
    This Excel worksheet compares user-input growth data with predictions under linear, exponential, and logistic models of growth. Introduces concepts of statistical analysis that can be additionally...

    Keywords: exponential growthlogistic growthcurve fittinglinear growthgrowth models

    65

    views

    26

    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

    83

    views

    13

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search