AQIQ Lesson 4

Using Excel

Ìý

Ozone Levels Graph shows Ozone rises and falls throughout the day

Ozone levels in three Colorado cities over a week.

CopyrightÌý2015ÌýHannigan Lab, College of Mechanical Engineering, University of Colorado Boulder.Ìý

Ìý

Lesson 4Ìýteaches the students the basics of data analysis and interpretation using Excel.

The corresponding video series Data Analysis for ExcelÌýis intended to supplement this lesson.Ìý

The main learning objectives are for the students to be able to:

  • Learn basic Excel commands for data analysis

  • Make graphs and charts on ExcelÌý

  • Interpret air quality data and drawÌýconclusions based on their results

This module includes:

  • Pre-Activity Reading

  • Data Analysis Activity with Excel Data Sheets

  • Excel Cheat Sheet