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
US Historical Climate: Excel Statistical
In this intermediate Excel activity, students import US Historical Climate Network mean temperature data into Excel from a station of their choice. They are then guided through the activity on how to use Excel for statistical calculations, graphing, and linear trend estimates. The activity assumes some familiarity with Excel. On this Starting Point page, users can access information about the exercise's learning goals, context for use, teaching notes and tips, teaching materials, assessment ideas, references and topics covered.
Intended for grade levels:
  • High (9-12)
  • College (13-14)
  • College (15-16)
Type of resource:
  • For the classroom:
    • Computer activity
    • Assessment / Evaluation
    • Guide for instructor
Subject:
  • Atmospheric science
  • Climatology
  • Educational theory and practice
Technical requirements:
Microsoft Excel
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. Authors of original works submitted to SERC retain their copyright. But in volunteering the works they agree to offer it under this license allowing for reuse and redistribution with attribution. Authors are responsible for obtaining copyright permission for all materials that they distribute within their work.
DLESE Catalog ID: SERC-STARTINGPOINT-000-000-000-524
Resource contact / Creator / Publisher:
Author: Dr R. M. Mackay
Clark College, Physics and Meteorology