Biochemistry

Balancing Chemical Equations Using Matrix Algebra. This Excel workbook introduces using matrix algebra to balance chemical reactions.

Buffer Preparation. This workbook calculates the necessary components to create a buffer solution.

**Bioinformatics**

Protein Analysis. This workbook allows the analysis of sample or imported protein sequences.

Biometrics

BioBayes.This Excel workbook and documentation lead the user through several different methodologies for applying Bayesian probabilities to real life examples and problems.

Biostatistical Tools.A collection of workbooks for linear regression, polynomial fit, and chi-square analysis to test whether a data set is in Hardy-Weinberg Equilibrium.

Database Construction and Sampling. The construction of three simple databases using a spreadsheet is described here and basic summary statistics are provided for each.

Fractal Fern Generator. This Excel workbook creates graphical images of a certain type of fractals that can be constructed by linear transformations.

PopTools. This downloadable Windows program allows the construction, analysis, and simulation of complex models in a simple spreadsheet format.

Botany

Three-D FractaL-Tree. This module allows scientists to collect data from specimens, insert the measurements into a spatially explicit L-system package, and visually compare to the computer generated 3D image with such specimens. The module consists of an Excel workbook and a Java applet.

Developmental Biology

Biological Cellular Automata Laboratory (BioCA Lab). This Excel workbook includes linear cellular automata and 2D cellular automata. Users can choose from a set of popular rules or define their own.

Developmental Allometry: Scaling in Growth. This Excel workbook illustrates a number of allometric equations in animal growth.

**Ecology**

Biodiversity. This Excel workbook allows the diversity of a biological population to be estimated with both the Shannon and Simpson biodiversity indices.

Continuous Growth Models. This worksheet compares user-input growth data with predictions under linear, exponential, and logistic models of growth.

Island Biogeography. This Excel workbook demonstrates the principles of the MacArthur-Wilson theory of Island Biogeography.

Java Food Web. This Java applet is accompanied by 100 Excel worsheets that provide food web matrices for analysis by the applet.

Leslie Matrix for Age-structured Populations. This Excel workbook uses the Leslie Matrix Model for population projection of age-class or stage-class structured populations.

Two-Species Model. This worksheet simulates the population growth of two interacting species.

Epidemiology

SIR Model. This worksheet implements an SIR (Susceptible/ Infected/ Resistant) model of epidemiology for vector-borne diseases.

Evolution

DeFinetti 1.0. This workbook simulates evolution of a single gene with three alleles.

ESS: Evolutionary Stable Strategies Game Theory Module.This workbook illustrates a number of ESS examples.

Luria-Delbrück. These two workbooks model the evolution of phage resistance in a bacterial population under two alternative hypotheses.

Genetics

ABO Blood Group Frequencies. The purpose of this workbook is to compare several methods for calculating allele frequencies for ABO blood groups.

Birthday Problem & Class Phenotypic Probabilities. This Excel workbook as two related applications, the Birthday Problem and Class Phenotypic Probabilities.

Deme 2.0. This worksheet simulates the population genetics of a single gene with two alleles.

Linkage Analysis. This workbook simulates a linkage analysis problem with up to four alleles.

ORF Finder. This workbook performs six-frame translation on a short user-input nucleotide sequence and highlights the position of stop codons.

Operon.This workbook modelslacoperon function in a partial diploidE. coli.

**Phylogenetics**

EvolSeq. This worksheet simulates the molecular evolution of DNA sequences.

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

Split Decomp. This worksheet performs split decomposition on a set of four DNA sequences and their associated amino acid sequences.

**Sequence Alignment**

Multiple Alignment. These two worksheets implement a dynamic programming algorithm for simultaneous alignment of multiple sequences.

Pairwise Alignment. These two worksheets implement a dynamic programming algorithm for pairwise sequence alignment.

The Biological ESTEEM project is part of the BioQUEST Curriculum Consortium at

http://www.bioquest.org/esteem