Exploring Marine Primary Productivity with Descriptive Statistics and Graphing in Excel
Author(s): Kristin Byrd
Tarrant County College
506 total view(s), 668 download(s)
Biology Background Info.docx(DOCX | 1 MB)
Marine Productitivy adaptation -- Weekly instructions Byrd 2023.docx(DOCX | 27 KB)
Biology Background Info.pdf(PDF | 344 KB)
Marine Productivity adaptation -- Weekly instructions Byrd 2023.pdf(PDF | 147 KB)
Graph Choice and Construction Table Angra Gardner 2016.pdf(PDF | 126 KB)
Marine Productivity Harmful Algal Blooms Quiz Adaptation Byrd 2023.docx(DOCX | 15 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)
- Harmful Algal Blooms (HAB) - YouTube
- https://nhmu.utah.edu/sites/default/files/attachments/HO 2 - I2 Strategy.pdf
- License terms
Description
This activity uses data provided by the Ocean Research College Academy*. Water chemistry and weather data — including parameters such as wind speed, water temperature, dissolved oxygen, and chlorophyll — are provided over a year-long period (2019) so that students can investigate seasonal patterns in primary productivity. Data were logged every 15 minutes using a conductivity, temperature, depth (CTD) sensor resulting in a robust dataset with over 14,000 observations.
Documents included in this module:
- Biology background information
- Statistics background information
- Student spreadsheet with data and activity instructions
- Printable student instructions (same instructions given in spreadsheet)
- Teacher spreadsheet with instructor notes and possible student answers
- Graph Choice and Constructions resource (Angra & Gardner 2016)
Primary outcomes:
- Overlapping: Statistics and Biology
- Create and analyze time-series plots
- Identify independent and dependent variables
- Use Excel to organize, visualize, and analyze data
- Efficiently use iterated formulas in Excel
- Identify outliers, understanding that there is no concrete cutoff for what makes an observation an outlier
- Statistics outcomes
- Calculate and interpret descriptive statistics: mean, median, standard deviation, quartiles
- Determine which descriptive statistics are useful/meaningful in context
- Discuss possible confounding variables
- Biology outcomes
- Understand the key drivers of primary productivity: light and nutrients
- Identify potential predictors and markers of primary productivity: wind, turbidity, temperature, dissolved oxygen, chlorophyll
- Interpret annual trends in primary productivity and recognize complexity of real environmental data
*The Ocean Research College Academy (ORCA) is a full-time Running Start program offered through Everett Community College. Learn more about ORCA online, and read about the data provided in this module in the "Biology Background Info" document.
This material is based upon work supported by the National Science Foundation under Grant No. 1919613. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.
Cite this work
Researchers should cite this work as follows:
- Byrd, K. (2023). Exploring Marine Primary Productivity with Descriptive Statistics and Graphing in Excel. QB@CC Fall 2022 FMN- Statistics and Biology: A Correlation Made in Heaven, QUBES Educational Resources. doi:10.25334/YG8C-8W51