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

    68

    views

    28

    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

    67

    views

    31

    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

    74

    views

    23

    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

    64

    views

    6

    downloads

    0

    comments

    0

    adaptations

    GeoPhyl
    This Excel workbook allows students to explore evolution over space and time using published data on the invasive plant Tamarix (salt cedar).

    Keywords: Invasive SpeciesTamarixsalt cedarpermutation testrandom geographic distribution

    70

    views

    35

    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

    57

    views

    35

    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

    67

    views

    37

    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

    92

    views

    51

    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

    66

    views

    12

    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

    42

    views

    19

    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

    80

    views

    51

    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

    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

    Biodiversity
    Biodiversity allows the diversity of a biological population to be estimated with both the Shannon and Simpson biodiversity indices based on information theory.

    Keywords: Shannon diversity indexSimpson diversity indexBiodiversity indicesInformation theory

    76

    views

    40

    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

    177

    views

    72

    downloads

    0

    comments

    0

    adaptations

    Using genomic data and machine learning to predict antibiotic resistance: a tutorial paper
    Antibiotic resistance is a global public health concern. Bacteria have evolved resistance to most antibiotics, which means that for any given bacterial infection, the bacteria may be resistant to...

    Keywords: Tutorialmachine learningantibiotic-resistanceArtificial Intelligence

    181

    views

    112

    downloads

    0

    comments

    0

    adaptations

    The Impact of Climate Change on Sea Hare Respiration
    In this lesson, students interpret graphs of sea hare respiration. Then, students view and reflect on an interview with environmental scientist Dr. Richelle Tanner, who collected the data in the...

    Keywords: graph interpretationclimate changefmnBioGraphIrepresentation in STEMsea hare

    192

    views

    198

    downloads

    0

    comments

    0

    adaptations

    Defining Life: Exploring Creativity, Scientific Discovery, and Biology Core Concepts in a Disciplinary First-Year Seminar
    This unit, Defining Life, engages students in thinking like scientists, applying creativity to science, and learning biology core concepts as they explore the defining characteristics of life. This...

    Keywords: Evolutionbiologycellprocess of science

    1029

    views

    57

    downloads

    0

    comments

    0

    adaptations

    Investigating the ecological value of migratory fishes on stream ecosystems in southern Appalachia
    Using the Ecological Society of America’s Four-Dimensional Ecology Education (4DEE) framework, students apply ecological concepts such as energy flow, nutrient cycling, migration, and climate...

    Keywords: Stream ecologynutrient cycling4DEE Frameworkfish migration

    148

    views

    370

    downloads

    0

    comments

    0

    adaptations

    BioGraphI FMN Leader Guide (Template version) - Google Docs
    This document contains the leader guide for the Biologist and Graph Interpretation (BioGraphI) Project’s semester-long Faculty Mentoring Network (FMN). FMN leaders use it to organize the FMN, and...

    Keywords: professional developmentCurriculum developmenttemplateInclusive teachingleadershipDiscussionBioGraphIBioGraphI FMNfacilitation

    108

    views

    99

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search