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

    116

    views

    59

    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

    110

    views

    48

    downloads

    0

    comments

    0

    adaptations

    Protein Analysis
    This Excel workbook allows the analysis of sample or imported protein sequences. The model can analyze protein sequences up to 500 amino acids long.

    Keywords: Protein sequencehydrophobicity/hydrophilicity

    103

    views

    59

    downloads

    0

    comments

    0

    adaptations

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

    Keywords: Phylogeographymutation ratesAsexual reproductionspecies dispersal

    79

    views

    11

    downloads

    0

    comments

    0

    adaptations

    Pharmacokinetics
    This Excel module explores how drugs are processed and absorbed in the human body.

    Keywords: drug metabolismpharmacokinetics

    78

    views

    47

    downloads

    0

    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

    82

    views

    18

    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

    74

    views

    35

    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

    93

    views

    31

    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.

    Keywords: survivalpopulation ecologyfecundityLeslie matrixeigenvalueseigenvectorsLefkovitch matrixage-class structured populationsstage-class structured populationsreproductive value

    166

    views

    100

    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

    115

    views

    45

    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

    104

    views

    14

    downloads

    0

    comments

    0

    adaptations

    Hidden Markov Model
    Hidden Markov models are a set of mathematical tools that can be used to draw inferences about genomic and evolutionary processes.

    Keywords: hidden markov models

    79

    views

    16

    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

    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

    97

    views

    33

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

    Keywords: population geneticsNatural Selection

    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.

    Keywords: population geneticsfitnessgame theorySequence alignmentevolutionary stable strategies

    88

    views

    22

    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

    87

    views

    48

    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

    82

    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

    94

    views

    71

    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

    88

    views

    43

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search