Nitrates And Water Quality (Part 2: Analyzing & Visualizing Data)
Subject: Chemistry,Environmental Science
Time: 45-55 minutes
Level: High School
Lesson OverviewStudents will use Google Sheets/Excel to analyze public water data to to inform decision making regarding nitrate water pollution. Students will develop skills in analyzing and visualizing of data from a large public dataset.
Know Google Sheets/Excel is a computational tool that can be used to analyze data sets.
Know a few computational tools can be used to create visualizations.
Use computational tools (counting and statistical tests) to analyze large data sets.
Use computational tools to create data visualizations.
Understand that computational tools make it possible to analyze much larger, data sets (seeing patterns, trends).
Understand that computational tools allow us to represent large data sets in ways that are interactive and dynamic, and reveal patterns we might not otherwise be able to notice.
- Life Science
- [HS-LS2] Ecosystems: Interactions, Energy, and Dynamics
- Physical Science
- [HS-PS2] Motion and Stability: Forces and Interactions
- Earth and Space Sciences
- [HS-ESS2] Earth's Systems
Computational Thinking in STEM
- Data Practices
- Analyzing Data
- Visualizing Data
Computational Thinking in Science and Math
Nitrates and Water Quality (Part 2: Analyzing & Visualizing Data)