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
    Malaise Trap Project: Involving Undergraduate Students in Network Science
    A multi-week project for upper division undergraduate students to participate in network-level science, while simultaneously learning classic entomology skills of specimen collection and...

    Keywords: entomologynetwork science4DEE Framework

    7

    views

    0

    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

    4

    views

    0

    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

    3

    views

    0

    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

    5

    views

    0

    downloads

    0

    comments

    0

    adaptations

    Pharmacokinetics
    This Excel module explores how drugs are processed and absorbed in the human body.

    Keywords: drug metabolismpharmacokinetics

    14

    views

    5

    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

    12

    views

    2

    downloads

    0

    comments

    0

    adaptations

    Mark-Recapture
    A common method used to estimate the population size of a species is the Mark-Recapture method.

    Keywords: mark-recapture analysispopulation estimation

    12

    views

    2

    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

    25

    views

    3

    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

    27

    views

    8

    downloads

    0

    comments

    0

    adaptations

    Island Biogeography
    This Excel workbook demonstrates the principles of the MacArthur-Wilson theory of Island Biogeography. It allows the user to define the mainland species pool, area of the island, and distance of...

    Keywords: Logarithmsspecies richnessIsland biogeographyExponential FunctionsMacArthur-Wilson Theorypower functions

    25

    views

    4

    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

    27

    views

    4

    downloads

    0

    comments

    0

    adaptations

    Dynamic Programming
    In bioinformatics, dynamic programming is mainly used to align nucleotide and amino acid sequences, and to predict RNA and protein folding from primary sequence data.

    Keywords: RNAamino acid sequenceSequence alignmentdynamic programmingprotein folding

    13

    views

    1

    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

    12

    views

    1

    downloads

    0

    comments

    0

    adaptations

    Deme 2.0
    This workbook simulates the population genetics of a single gene with two alleles. It can simultaneously model up to three local populations, which may differ in their selection coefficients.

    Keywords: population geneticsGenetic DriftNatural Selection

    17

    views

    3

    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

    23

    views

    4

    downloads

    0

    comments

    0

    adaptations

    Database Construction and Sampling
    Creating your own database is an excellent way for students to learn the trials and tribulations of data collection and management. Construction of three simple databases using a spreadsheet is...

    Keywords: databasesdata managementdata collectiondata ethicsdata integrity

    26

    views

    4

    downloads

    0

    comments

    0

    adaptations

    COVID-19 Model
    This Excel worksheet implements an SEAIHRD model for Covid-19 (Susceptible, Exposed, Asymptomatic infective, symptomatic Infective, Hospitalized infective, Recovered, Deceased).

    Keywords: infectious diseaseCOVID19

    23

    views

    4

    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

    22

    views

    2

    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

    36

    views

    10

    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

    27

    views

    4

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search