Resources

Text Search:
Applied Filters
    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.
    94

    views

    71

    downloads

    0

    comments

    0

    adaptations

    Evolution Through Natural Selection
    This Excel workbook simulates the population genetics of a single gene with two alleles, allowing the user to set the initial allele frequencies and enter parameters for a variety of different...
    92

    views

    38

    downloads

    0

    comments

    0

    adaptations

    ESS: Evolutionary Stable Strategies Game Theory Module
    This Excel workbook illustrates a number of ESS examples. Each example allows the user to manipulate the initial population for each strategy and the fitness payoffs and costs for each strategy.
    88

    views

    22

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

    views

    43

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

    views

    242

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

    views

    52

    downloads

    0

    comments

    0

    adaptations

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

    views

    35

    downloads

    0

    comments

    0

    adaptations

    Leslie/Lefkovitch Matrix Models for Age or Stage-structured Populations
    This Excel workbook uses the Leslie matrix model for population projection of age-class structured populations, and also allows Lefkovitch matrix models for stage-class structured populations.
    166

    views

    100

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

    views

    41

    downloads

    0

    comments

    0

    adaptations

    Phylogeography Simulator
    This Excel workbook simulates the phylogeography of an asexually reproducing species.
    79

    views

    11

    downloads

    0

    comments

    0

    adaptations

    Luria-Delbruck
    These two workbooks model the evolution of phage resistance in a bacterial population under two alternative hypotheses.
    1572

    views

    292

    downloads

    2

    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

    83

    views

    18

    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).
    104

    views

    44

    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

    98

    views

    33

    downloads

    0

    comments

    0

    adaptations

    In silico chromosome mapping: Idiograms
    This workbook allows the user to construct idiograms (haploid or diploid), map sequences onto them, depict chromosome structural mutations, and perform side-by-side comparative analyses of...
    197

    views

    89

    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,...
    93

    views

    31

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

    views

    45

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

    views

    318

    downloads

    0

    comments

    0

    adaptations

    SIR BuildIt
    An introduction to epidemiological models using interactive Excel worksheets
    4077

    views

    3385

    downloads

    0

    comments

    0

    adaptations