You are here: Home / Resources / Teaching Materials / Exploring Marine Primary Productivity with Descriptive Statistics and Graphing in Excel / Description
Resource Image

Exploring Marine Primary Productivity with Descriptive Statistics and Graphing in Excel

Author(s): Kristin Byrd

Tarrant County College

565 total view(s), 793 download(s)

0 comment(s) (Post a comment)

Download

Adapt 0
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.

Licensed under CC Attribution-ShareAlike 4.0 International according to these terms

Version 1.0 - published on 29 Jan 2023 doi:10.25334/YG8C-8W51 - cite this

Adapted from: Exploring Marine Primary Productivity with Descriptive Statistics and Graphing in Excel v 1.0

Keywords

  1. statistics
  2. ecology
  3. data
  4. Excel
  5. graphing
  6. Biochemistry
  7. Oceanography
  8. marine ecosystems
  9. marine ecology
  10. descriptive statistics
  11. long-term datasets
  12. marine
  13. Microsoft Excel
  14. marine biology
  15. plankton
  16. Outliers
  17. Marine Science
  18. qbcc
  19. Using Excel
  20. phytoplankton
  21. Create graphs
  22. Interpret graphs
  23. Concepts in Statistics
  24. large dataset
  25. explaining statistics
  26. using statistics
  27. Pacific Northwest
  28. Salish Sea
  29. primary productivity
  30. water chemistry
  31. estuary
  32. graphing in Excel
  33. formulas in Excel
  34. chlorophyll
  35. time-series plots
  36. ocean

Alignments

  1. Resource Type
  2. Audience Level
  3. Activity Length
  4. QUBES Universal Design Tagging Ontology
  5. Open Science and Education Practices Ontology
Contents:
view all files

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:

Close

Home

Search