Exploring Marine Primary Productivity with Descriptive Statistics and Graphing in Excel
Author(s): Marina McLeod1, Jennifer Olson1, Wendy Houston1
Everett Community College
1332 total view(s), 1331 download(s)
Summary:
In this activity, students use real water chemistry data and descriptive statistics in Excel to examine primary productivity in an urban estuary of the Salish Sea. They will consider how actual data do or do not support expected annual trends.
Contents:
- Biology Background Info.docx(DOCX | 1 MB)
- Biology Background Info.pdf(PDF | 344 KB)
- Graph Choice and Construction Table Angra Gardner 2016.pdf(PDF | 126 KB)
- Statistics Background Info.docx(DOCX | 153 KB)
- Statistics Background Info.pdf(PDF | 244 KB)
- Student Instructions.pdf(PDF | 219 KB)
- Student Spreadsheet with Instructions.xlsx(XLSX | 1020 KB)
- Teacher Spreadsheet.xlsx(XLSX | 6 MB)
- Temp-Chloro-Graph.jpg(JPG | 61 KB)
- License terms
Supporting Docs
- Biology Background Info.docx(DOCX | 1 MB)
- Biology Background Info.pdf(PDF | 344 KB)
- Graph Choice and Construction Table Angra Gardner 2016.pdf(PDF | 126 KB)
- Statistics Background Info.docx(DOCX | 153 KB)
- Statistics Background Info.pdf(PDF | 244 KB)
- Student Instructions.pdf(PDF | 219 KB)
- Student Spreadsheet with Instructions.xlsx(XLSX | 1020 KB)
- Teacher Spreadsheet.xlsx(XLSX | 6 MB)
- Temp-Chloro-Graph.jpg(JPG | 61 KB)