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

    76

    views

    16

    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

    68

    views

    33

    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

    89

    views

    30

    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

    102

    views

    42

    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

    96

    views

    10

    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

    93

    views

    33

    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

    81

    views

    45

    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

    77

    views

    45

    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

    90

    views

    69

    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

    82

    views

    43

    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

    119

    views

    80

    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

    199

    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

    91

    views

    17

    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

    106

    views

    58

    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

    155

    views

    76

    downloads

    0

    comments

    0

    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

    612

    views

    41

    downloads

    0

    comments

    0

    adaptations

    Science Learning Spaces in undergraduate courses ( virtual and face to face) : Impact of Technology, Resources and Active Learning Activities
    Science Learning Spaces are evolving in both face to face and virtual learning environments. Effective utilization and identification of appropriate learning spaces helps in formation of engaging...

    Keywords: resourcesstemfaculty developmentUndergraduatesciencetechnologyWorkshop materialAnalysislearning spacescience learning spacemajor learning spaceminor learning spacelearning activitiesthinking

    449

    views

    85

    downloads

    0

    comments

    0

    adaptations

    Learning Spaces in undergraduate science courses ( virtual and face to face)
    Learning Spaces are zones of interaction between undergraduates & undergraduates and undergraduates & professor. The traditional learning spaces were existing pre-pandemic however post-pandemic the...

    Keywords: active learningmentoringstemassessmentfaculty developmentteachingUndergraduateWorkshop materiallearning spacescience learning spaceprofessorsmajor learning spaceminor learning space

    145

    views

    63

    downloads

    0

    comments

    0

    adaptations

    Digital Intro: Revitalizing the “Introduction to Psychology” course through Project-based Learning
    Welcome to Digital Intro where we are transforming introductory courses into active, project-based experiences. Our projects expose students to a wide range of digital skills as they learn...

    Keywords: psychologyDigital IntroIntroduction to PsychologyIntroductory PsychologyGeneral Psychology

    202

    views

    84

    downloads

    0

    comments

    0

    adaptations

    Learning Communities as a Driver for Humanizing STEM: Cultivating Authentic Conversations about Anti-Racism in Introductory Biology Pedagogy using Duoethnography
    In this study we present a retrospective debrief of a learning community of college biology professors who were exploring how to define and implement racial equity-focused practices and content in...

    Keywords: Equitysocial justicediversity

    1646

    views

    148

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search