Spreadsheet Exercises in Ecology and Evolution [Paperback]

Therese M. Donovan (Author), Charles Welden (Author)

Book Description

ISBN-10: 0878931562 | ISBN-13: 978-0878931569 | Publication Date: December 1, 2001 | Edition: 1

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. This title can be used independently as the basis of a laboratory course, or can supplement a variety of texts. System requirements are Microsoft Excel or other spreadsheet program.

Editorial Reviews

About the Author

THERESE M. DONOVAN, University of Vermont. - CHARLES W. WELDEN, Southern Oregon University.

Product Details

• Paperback: 556 pages
• Publisher: Sinauer Associates Inc; 1 edition (December 1, 2001)
• Language: English
• ISBN-10: 0878931562
• ISBN-13: 978-0878931569
• Product Dimensions: 10.9 x 8.4 x 0.8 inches
• Shipping Weight: 2.8 pounds
• Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #905,783 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

6 of 7 people found the following review helpful:

5.0 out of 5 stars Program a model from scratch, February 12, 2002

By A Customer

This review is from: Spreadsheet Exercises in Ecology and Evolution (Paperback)

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.