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

    views

    362

    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

    1520

    views

    223

    downloads

    0

    comments

    0

    adaptations

    1-137-SheepGraze-ModelingScenario
    In this activity, students will apply graphical analysis (such as phase lines) to determine the long-term predictions of a differential equation model for pasture grass using two different formulas...

    Keywords: herbivoreplantphase linesbifurcationoverexploitationsheepgraze

    194

    views

    218

    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

    2527

    views

    1115

    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

    1253

    views

    1505

    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

    30

    views

    6

    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

    210

    views

    432

    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

    1152

    views

    589

    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

    305

    views

    279

    downloads

    0

    comments

    0

    adaptations

    Split Decomp
    This Excel worksheet performs split decomposition on a set of four DNA sequences and their associated amino acid sequences. The user can type in the sequences or paste them in from a text file.

    Keywords: phylogenyDNA sequenceamino acid sequencesplit decomposition

    14

    views

    4

    downloads

    0

    comments

    0

    adaptations

    Developmental Allometry: Scaling in Growth
    This Excel workbook illustrates a number of allometric equations in animal growth. The workbook also calculates an allometric equation with graphical output for data entered by the user.

    Keywords: allometrybrain developmentSkeletal Systemmetabolic rate

    15

    views

    1

    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

    19

    views

    3

    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

    1549

    views

    685

    downloads

    0

    comments

    0

    adaptations

    A Simple Method for Predicting a Molecule's Biological Properties From Its Polarity
    The distinction between very polar and less polar substances is a foundation of biochemistry, cell biology, and physiology; it surfaces in multiple concept inventories and elaborations of...

    Keywords: Diffusionsolubilitycovalent bondshydrophilichydrophobicpartition coefficientplasma membranepolarity

    1795

    views

    471

    downloads

    0

    comments

    0

    adaptations

    Linkage Analysis
    This Excel workbook simulates a linkage analysis problem with up to four alleles. Based on the offspring produced by a multihybrid testcross, the user builds a model of the gene order,...

    Keywords: recombinationlinkage analysis

    31

    views

    5

    downloads

    0

    comments

    0

    adaptations

    DeFinetti 1.0
    This Excel workbook simulates evolution of a single gene with three alleles. The user assigns fitness values to each of the six possible genotypes, then enters starting allele frequencies for each...

    Keywords: population geneticsallelesevolutionary fitness

    26

    views

    4

    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

    41

    views

    15

    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

    12

    views

    2

    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

    25

    views

    3

    downloads

    0

    comments

    0

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

    views

    585

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search