University of Vermont



Cooperative Fish and Wildlife Research Units



Vermont Cooperative Fish and Wildlife Research Unit Spreadsheet Project

Welcome to the Vermont Cooperative Fish and Wildlife Research Unit Spreadsheet Project. The Spreadsheet Project was launched in 2005 and is directed by Therese Donovan, a U.S. Geological Survey Cooperative Research Unit scientist at The University of Vermont.

The materials posted here are intended to improve student's understanding of quantitative methods for analyzing wildlife population dynamics. The Project includes spreadsheet exercises on a variety of ecological and evolutionary topics, including quantitative estimation of population parameters.

Just click on a link to get started.

  • Principles of Modeling with Spreadsheets. This new e-course features world-renowned modeler and instructor, Dr. Tony Starfield. Tony introduces modeling concepts and challenges, while Terri Donovan provides instruction on building models with spreadsheets. This project is a collaboration between the U.S. Bureau of Land Management's National Training Center, the U.S. Fish and Wildlife Service's National Conservation Training Center , and the Vermont Cooperative Fish and Wildlife Research Unit.

    Attention Department of Interior scientists and Cooperative Research Unit students---This course is offered annually for credit; contact us if you are interested.
  • Introduction to Structured Decision Making This new e-course features world-class decision analysists Dr. Mike Runge and Dr. Sarah Converse. Mike and Sarah introduce structured decision making as a formal method for solving problems in natural resource management. This project is a collaboration between the U.S. Bureau of Land Management's National Training Center, the U.S. Fish and Wildlife Service's National Conservation Training Center , and the U.S. Geological Survey.
  • Exercises in Occupancy Estimation and Modeling. The exercises are designed as a teaching tool to explore the occupancy models described in the book, "Occupancy Estimation and Modeling," by D. MacKenzie, J. D. Nichols, J. A. Royle, K. Pollock, L. L. Bailey, and J. E. Hines.

    Please cite this work as: Donovan, T. M. and J. Hines. 2007. Exercises in occupancy modeling and estimation. http://www.uvm.edu/rsenr/vtcfwru/spreadsheets/occupancy/occupancy.htm
  • Estimating and Monitoring Abundance. The exercises presented here are designed as a teaching tool to explore various methods in estimating and monitoring abundance of wild species, with an emphasis on animal species.

    Please cite this work as: Donovan, T. M. and M. Alldredge. 2007. Exercises in estimating and monitoring abundance. http://www.uvm.edu/rsenr/vtcfwru/spreadsheets/abundance/abundance.htm
  • Estimating Life History Parameters. This e-book is under construction. The e-book is a "dummies guide" to capture mark recapture data, based loosely onthe topics covered in MARK: A Gentle Introduction by Evan Cooch and Gary White. The MARK book is an outstanding guide that goes into great detail on capture-mark-recapture analysis. The spreadsheet exercises are intended to provide researchers and students with the basic foundations of these analyses.
  • Spreadsheet Exercises in Ecology and Evolution. Originally published by Sinauer Associates, Spreadsheet Exercises in Ecology and Evolution can now be downloaded for free, courtesy of Therese Donovan, Charles Welden, and Sinauer Associates. These exercises were developed to teach our own students how to put a spreadsheet model together from scratch, while at the same time learning some fundamental models and concepts in the fields of ecology and evolution.

    Please cite this work as: Donovan, T. M. and C. Welden. 2002. Spreadsheet exercises in ecology and evolution. Sinauer Associates, Inc. Sunderland, MA, USA.
  • Spreadsheet Exercises in Conservation Biology and Landscape Ecology. Originally published by Sinauer Associates, Spreadsheet Exercises in Conservation Biology and Landscape Ecology can now be downloaded for free, courtesy of Therese Donovan, Charles Welden, and Sinauer Associates. These exercises were developed to teach our own students how to put a spreadsheet model together from scratch, while at the same time learning some fundamental models and concepts in the fields of Conservation Biology.

    Please cite this work as: Donovan, T. M. and C. Welden. 2002. Spreadsheet exercises in conservation biology and landscape ecology. Sinauer Associates, Inc. Sunderland, MA, USA.

Last modified August 19 2014 11:28 AM

Contact UVM © 2014 The University of Vermont - Burlington, VT 05405 - (802) 656-3131