Applying Quantitative Reasoning to Biodiversity
This series of 6 Excel-based projects lead students through a variety of analysis and modeling exercises exploring the mathematics of biodiversity. They serve to provide students with an application of various basic math techniques they would study in a college-math course as well as an opportunity to develop skills using Excel for data analysis and modeling.
Primary learning objectives include: calculating probabilities and proportions; plotting data and fitting linear and exponential models; learning how to create species accumulation curves; testing simple hypotheses of ecological structure that underlie observed biodiversity trends.
Students should develop a deeper understanding of biodiversity and the structure of ecosystems as seen in species distributions.It advances student literacy around sustainability issues and develops skills in data analysis and the utilization of mathematical models
Context for Use
Description and Teaching Materials
All projects should be reviewed and modified as necessary prior to use.
Project #1 (Excel 2007 (.xlsx) 15kB Jan7 15)
Project #2 (Excel 2007 (.xlsx) 38kB Jan7 15)
Project #3 (Excel 2007 (.xlsx) 36kB Jan7 15)
Project #4 Directions (Microsoft Word 2007 (.docx) 16kB Jan7 15)
Project #5 (Excel 2007 (.xlsx) 72kB Jan7 15)
Project #6 (Excel 2007 (.xlsx) 1.1MB Jan7 15)