menu

Vermont Cooperative Fish and Wildlife Research Unit Spreadsheet and R Project

Spreadsheet Exercises in Conservation Biology and Landscape Ecology Chapters

Each Chapter contains a .pdf with the text, a completed example spreadsheet (.xlsx), a spreadsheet shell (.xlsx). Some Chapters also include a .pdf with answers to questions in the chapter. Some chapters require macros in Excel. Click here to learn more about macros.

Chapter 0: Spreadsheet Tips and Tricks
Chapter 1: Mathematical Functions and Graphs
Chapter 2: Spreadsheet Functions and Macros (macros)
Chapter 3: Statistical Distributions (macros)
Chapter 4: Central Limit Theorem (macros)
Chapter 5: Hypothesis Testing: Alpha, Beta, and Power (macros)
Chapter 6: Sampling Species Richness (macros)
Chapter 7: Geometric and Exponential Population Growth
Chapter 8: Logistic Population Models
Chapter 9: Island Biogeography
Chapter 10: Life Tables, Survivorship Curves, and Population Growth
Chapter 11: Age-Structured Matrix Models
Chapter 12: Stage Structured Matrix Models
Chapter 13: Reproductive Value: Matrix Approach
Chapter 14: Reproductive Value: Life Table Approach
Chapter 15: Sensitivity and Elasticity Analysis
Chapter 16: Meta-population Dynamics (Macros)
Chapter 17: Source Sink Dynamics
Chapter 18: Population Estimation with Mark-Recapture Techniques
Chapter 19: Range Expansion
Chapter 20: Adaptation: Persistence in a Changing Environment (Macros)
Chapter 21: Hardy-Weinberg Equilibrium (Macros)
Chapter 22: Gene Flow and Population Structure
Chapter 23: Genetic Diversity (Macros)
Chapter 24: Inbreeding, Outbreeding, and Random Mating
Chapter 25: Genetic Drift (Macros)
Chapter 26: Effective Population Size
Chapter 27: Demographic Stochasticity (Macros)
Chapter 28: Population Viability Analysis
Chapter 29: Harvest Models
Chapter 30: Quantifying Landscape Patterns
Chapter 31: Edge Effects and Ecological Traps
Chapter 32: Triage: Prioritizing Species and Habitats
Chapter 33: Reserve Design
Chapter 34: VBA Landscape Programming (Macros)
Chapter 35: Neutral Landscape Theory and Connectivity (Macros)
Chapter 36: Random Walks (Macros)

Any Questions/Suggestions? Please contact tdonovan@uvm.edu.

Page Last Updated: June 26, 2020

Skip to toolbar