Search Resources

3 Results

View
Selected filters:
  • Introduction to Excel
Understanding the Air through Data Analysis
Read the Fine Print
Educational Use
Rating

Students build on their existing air quality knowledge and a description of a data set to each develop a hypothesis around how and why air pollutants vary on a daily and seasonal basis. Then they are guided by a worksheet through an Excel-based analysis of the data. This includes entering formulas to calculate statistics and creating plots of the data. As students complete each phase of the analysis, reflection questions guide their understanding of what new information the analysis reveals. At activity end, students evaluate their original hypotheses and “put all of the pieces together.” The activity includes one carbon dioxide worksheet/data set and one ozone worksheet/data set; providing students and/or instructors with a content option. The activity also serves as a good standalone introduction to using Excel.

Subject:
Atmospheric Science
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
TeachEngineering
Author:
AirWaterGas SNR Project Education and Outreach, College of Engineering, University of Colorado Boulder
Ashley Collier
Ben Graves
Daniel Knight
Drew Meyers
Eric Ambos
Eric Lee
Erik Hotaling
Hanadi Adel Salamah
Joanna Gordon
Katya Hafich
Michael Hannigan
Nicholas VanderKolk
Olivia Cecil
Victoria Danner
Date Added:
10/13/2017