Lesson Planet
Search educational resources
  • Sign In Try It Free
  • AI Teacher Tools
    • Discover Resources Search reviewed educational resources by keyword, subject, grade, type, and more
    • Curriculum Manager (My Content) Manage saved and uploaded resources and folders To Access the Curriculum Manager Sign In or Join Now
    • Browse Resource Directory Browse educational resources by subject and topic
    • Curriculum Calendar Explore curriculum resources by date
    • Lesson Planning Articles Timely and inspiring teaching ideas that you can apply in your classroom
    • Our Story
    • Frequently Asked Questions
    • Testimonials
    • Contact Us
  • Pricing
  • School Access
    • Your school or district can sign up for Lesson Planet — with no cost to teachers
      Learn More
  • Sign In
  • Try It Free
Understanding the Air through Data Analysis ActivityUnderstanding the Air through Data Analysis Activity
Publisher
Teach Engineering
Resource Details
Curator Rating
Educator Rating
Not yet Rated
Grade
9th - 12th
Subjects
Science
4 more...
Resource Type
Activities & Projects
Audience
For Teacher Use
Duration
1 hr 30 mins
Instructional Strategy
Hands-on Activity
Year
2013
Usage Permissions
Fine Print: Educational Use
Activity

Understanding the Air through Data Analysis

Curated and Reviewed by Lesson Planet
This Understanding the Air through Data Analysis activity also includes:
  • Pre-Activity Reading (.pdf)
  • Pre-Activity Worksheet (.pdf)
  • Pre-Activity Worksheet – Answer Key (.pdf)
  • CO2 Activity Worksheet (.pdf)
  • CO2 Activity Worksheet – Answer Key (.pdf)
  • Seasonal Variation in Carbon Dioxide (.xlsx)
  • Seasonal Variation in Carbon Dioxide – Answer Key (.xlsx)
  • O3 Activity Worksheet (.pdf)
  • O3 Activity Worksheet – Answer Key (.pdf)
  • Seasonal Variation in Ozone (.xlsx)
  • Seasonal Variation in Ozone – Answer Key (.xlsx)
  • Excel Reference Sheet (.pdf)
  • Connecting the the Big Picture Handout (.pdf)
  • Connecting to the Big Picture handout – Answer Key (.pdf)
  • Vocabulary List (.pdf)
  • Vocabulary list – Answer Key (.pdf)
  • Pre–Activity Reading (.docx)
  • Pre–Activity Worksheet (.docx)
  • CO2 Activity Worksheet (.docx)
  • CO2 Activity Worksheet – Answer Key (.docx)
  • O3 Activity Worksheet (.docx)
  • O3 Activity Worksheet – Answer Key (.docx)
  • Excel Reference Sheet (.docx)
  • Connecting to the Big Picture Handout (.docx)
  • Connecting to the Big Picture handout – Answer Key (.docx)
  • Vocabulary List (.docx)
  • Vocabulary list – Answer Key (.docx)
  • Vocabulary
  • Vocabulary
  • Join to access all included materials

Is there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their hypotheses and reflect on conclusions reached from their analysis. 

36 Views 31 Downloads
CCSS: Designed

Concepts

air, air pollution, correlation, correlation coefficient, data analysis, graphing, standard deviation, statistics, plotting points, carbon dioxide, technology resources

Instructional Ideas

  • Conduct a short mini-lesson on the differences between causation and correlation

Classroom Considerations

  • Pupils should be familiar with basic statistics such as calculating measures of center and measures of variability
  • The classes' familiarity with Excel will greatly affect the time it takes to complete the activity
  • The fifth in a six-part series

Pros

  • The resource has an Excel reference sheet as a resource for pupils that are not that familiar with Excel
  • Documents come as docx files to enable easy editing

Cons

  • None

Common Core

HSS-ID.A.2 HSS-ID.B.6.a HSS-ID.B.6.c HSS-ID.C.9

View 68,484 other resources for 9th - 12th Grade Science

© 1999-2026 Learning Explorer, Inc.
Teacher Lesson Plans, Worksheets and Resources

Sign up for the Lesson Planet Monthly Newsletter

Open Educational Resources (OER)

  • Health
  • Language Arts
  • Languages
  • Math
  • Physical Education
  • Science
  • Social Studies
  • Special Education
  • Visual and Performing Arts
View All Lesson Plans

Discover Resources

  • Our Review Process
  • How it Works
  • How to Search
  • Create a Collection

Manage Curriculum

  • Edit a Collection
  • Assign to Students
  • Manage My Content
Contact Us Site Map Privacy Policy Terms of Use