Spreadsheet exercises in ecology and evolution
Author(s)
Bibliographic Information
Spreadsheet exercises in ecology and evolution
Sinauer Associates, c2002
- : pbk
Available at 9 libraries
  Aomori
  Iwate
  Miyagi
  Akita
  Yamagata
  Fukushima
  Ibaraki
  Tochigi
  Gunma
  Saitama
  Chiba
  Tokyo
  Kanagawa
  Niigata
  Toyama
  Ishikawa
  Fukui
  Yamanashi
  Nagano
  Gifu
  Shizuoka
  Aichi
  Mie
  Shiga
  Kyoto
  Osaka
  Hyogo
  Nara
  Wakayama
  Tottori
  Shimane
  Okayama
  Hiroshima
  Yamaguchi
  Tokushima
  Kagawa
  Ehime
  Kochi
  Fukuoka
  Saga
  Nagasaki
  Kumamoto
  Oita
  Miyazaki
  Kagoshima
  Okinawa
  Korea
  China
  Thailand
  United Kingdom
  Germany
  Switzerland
  France
  Belgium
  Netherlands
  Sweden
  Norway
  United States of America
Note
Includes bibliographical references
Description and Table of Contents
Description
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.
Table of Contents
PART I: SPREADSHEETS AND STATISTICS - Mathematical Functions and Graphs - Spreadsheet Functions and Macros - Statistical Distributions - Hypothesis Testing: Alpha, Beta, and Power - PART II: ECOLOGY - Geometric and Exponential Population Models - Logistic Population Growth - Interspecific Competition - Predator-Prey Dynamics (Lotka-Volterra) - Island Biogeography - Life Tables and Survivorship Curves - Reproductive Value: Matrix Approach - Reproductive Value: Life Table Approach - Demographic Stochasticity - Key Factor Analysis - Age-Structured Matrix Models (Leslie) - Stage-Structured Matrix Models - Sensitivity and Elasticity Analysis - Metapopulation Dynamics - Source-Sink Dynamics - Niche Breadth and Resource Partitioning - Population Estimation - Survival Analysis - Habitat Selection - Optimal Foraging Models - Range Expansion - Succession - PART III: EVOLUTION - Hardy-Weinberg - Multi-Locus Hardy-Weinberg - Measures of Genetic Diversity - Natural Selection and Fitness - Adaptation - Gene Flow and Population Structure - Life History Evolution - Heritability - Quantitative Genetics - Sexual Selection - Evolutionarily Stable Strategies - Parental Care and Mating Systems - Inbreeding and Outbreeding - Genetic Drift - Effective Population Size
by "Nielsen BookData"