Skip to content
ISBN: 0878931562
ISBN13: 9780878931569

Spreadsheet Exercises in Ecology and Evolution

ISBN: 0878931562
ISBN13: 9780878931569
Formats

Conditions

Formats

Conditions

See all 1 editions

Book Overview

The exercises in this unique book allow students to use spreadsheet programs such as Microsoftr Excel to create working population models. The book contains basic spreadsheet exercises that explicate the concepts of statistical distributions, hypothesis testing and power, sampling techniques, and Leslie matrices. It contains exercises for modeling such crucial factors as population growth, life histories, reproductive success, demographic stochasticity, Hardy-Weinberg equilibrium, metapopulation dynamics, predator-prey interactions (Lotka-Volterra models), and many others. Building models using these exercises gives students "hands-on" information about what parameters are important in each model, how different parameters relate to each other, and how changing the parameters affects outcomes. The "mystery" of the mathematics dissolves as the spreadsheets produce tangible graphic results. Each exercise grew from hands-on use in the authors' classrooms. Each begins with a list of objectives, background information that includes standard mathematical formulae, and annotated step-by-step instructions for using this information to create a working model. Students then examine how changing the parameters affects model outcomes and, through a set of guided questions, are challenged to develop their models further. In the process, they become proficient with many of the functions available on spreadsheet programs and learn to write and use complex but useful macros. Spreadsheet Exercises in Ecology and Evolution can be used independently as the basis of a course in quantitative ecology and its applications or as an invaluable supplement to undergraduate textbooks in ecology, population biology, evolution, and population genetics.
Format:
Paperback
Language:
English
ISBN:
0878931562
ISBN13:
9780878931569
Release Date:
December 2001
Publisher:
Oxford University Press, Incorporated
Length:
556 Pages
Biological SciencesBiologyBiology & Life SciencesComputersComputers & TechnologyEcologyEducation & ReferenceEvolutionScienceScience & MathScience & ScientistsScience & TechnologyScience for Kids

Customer Reviews

1 customer rating | 1 review
Write a Review

Program a model from scratch

Originally conceived as a single book, these two volumes have been tailored to suit ecology/evolution or conservation biology/landscape ecology curricula. They help students develop expertise in building models using spreadsheet programs such as Microsoft® Excel. Why should students build their own spreadsheet models from scratch, when so many specific, prewritten models are widely available? Because when you program a model from scratch, you learn all aspects of modeling: what parameters are important, how the parameters relate to each other, and how changes in the model affect outcomes. In other words, you not only learn about models, you also learn about modeling. The mystery of modeling dissolves when students actively create and develop their own programs in a spreadsheet environment.Each spreadsheet exercise provides a list of objectives, background material, and annotated step-by-step instructions (Windows and Macintosh) for creating a model on a given topic. Students then examine how various parameters affect model outcomes and, through a set of guided questions, are challenged to develop their model further. In the process, they become proficient with many of the functions available on most spreadsheet programs and learn to write and develop their own macros.Spreadsheet Exercises in Ecology and Evolution and Spreadsheet Exercises in Conservation Biology and Landscape Ecology can be used independently as the basis of a laboratory course, or can supplement a variety of texts. The target audience is undergraduate and beginning graduate students.

0