Find a
Resource
Select grade level(s) Select resource type(s) Select collection(s) Select standard(s) Skip navigation Digital Library for Earth System Education
Digital Library for Earth System Education
Search tips
U.S. Historical Climate Network: Excel Activity (title provided or enhanced by cataloger)
In this activity, students import mean temperature data from the U.S. Historical Climatic Network (USHCN) into a spreadsheet program and use it to prepare graphs and calculate statistical measures and trends. It can be used in a course with climate change content or as an introduction to basic statistics. A tutorial on using Excel for basic statistics and an answer document are provided.
Intended for grade levels:
  • High (9-12)
  • College (13-14)
  • College (15-16)
Type of resource:
  • For the classroom:
    • Classroom activity
    • Computer activity
    • Assessment / Evaluation
    • Guide for instructor
Subject:
  • Atmospheric science
  • Climatology
  • Educational theory and practice
  • Mathematics
Technical requirements:
Requires Microsoft Excel
Tutorial requires Adobe Acrobat reader
Cost / Copyright:
No cost
We encourage the reuse and dissemination of the material on this site for educational, noncommercial purposes as long as attribution is retained. To this end the material on this site is offered under a Creative Commons license Attribution-NonCommercial-ShareAlike 1.0.
DLESE Catalog ID: DLESE-000-000-010-250
Resource contact / Creator / Publisher:
Author: Dr Robert Mackay
Physics Department
Clark Cllege

Publisher: Science Education Resource Center (SERC)
http://serc.carleton.edu/