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

    5

    views

    0

    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

    4

    views

    0

    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

    7

    views

    1

    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

    5

    views

    0

    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

    33

    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

    24

    views

    4

    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

    552

    views

    17

    downloads

    0

    comments

    0

    adaptations

    BioBayes
    The BioBayes module leads the user through several different methodologies for applying Bayesian probabilities to real life examples and problems, such as HIV and cystic fibrosis screening.

    Keywords: pedigreesbayesian statisticsHIVTwo-Way Tablespunnett squarescystic fibrosis

    293

    views

    2

    downloads

    0

    comments

    0

    adaptations

    Untitled QUBES Resource Draft (1)
    Social Justice Dialogues in STEM 2 is a resource to help facilitate conversations around various social contexts within STEM classroom.

    Keywords: EquitySTEM educationUDLjustice

    20

    views

    3

    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

    68

    views

    6

    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

    84

    views

    3

    downloads

    0

    comments

    0

    adaptations

    Birthday Problem and Class Phenotypic Probabilities
    An Excel workbook exploring two related applications, the Birthday Problem and Class Phenotypic Probabilities. Students enter their own phenotypes into the workbook.

    Keywords: phenotypic probabilityallelic frequency

    1038

    views

    215

    downloads

    0

    comments

    0

    adaptations

    3D FractaL-Tree
    3D FractaL-Tree allows scientists to collect data from actual specimens in the field or laboratory, insert these measurements into a spatially explicit L-system package, and then visually compare...

    Keywords: fractalsL-systems

    1189

    views

    248

    downloads

    0

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets

    Keywords: modelinginfectious diseaseInfectious Disease ModelingSIR modelsSIR

    3872

    views

    3290

    downloads

    0

    comments

    0

    adaptations

    ABO Blood Group Frequencies
    An Excel workbook in which students can calculate blood type frequencies through different approaches (Hardy-Weinberg, quadratic formula, and the EM algorithm). The workbook shows the formulas...

    Keywords: Hardy-Weinbergblood type frequencies

    1420

    views

    286

    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

    135

    views

    21

    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

    1503

    views

    102

    downloads

    0

    comments

    0

    adaptations

    Learn biotechnology, biophysics and business through scientific thinking and innovation
    Scientific, leadership and innovation skills are also an integral framework of the curriculum. All of them together or individually are important for enhancement of knowledge, critical thinking,...

    Keywords: educationbusinessBiotechnologybiophysicsleadershiprecombinant DNAgroup workcloninginnovationscientific thinkingplasmid

    154

    views

    83

    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

    150

    views

    100

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search