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 and graphing in Excel.
Following suggestions are by CLEAN reviewers:
- Educator has to be careful to not allow students to draw too broad of conclusions from one station. For example, a given station may indicate a cooling trend even though the globe as a whole is warming.
- Students unfamiliar with Excel should complete an introductory Excel activity (see resources listed in activity) before working through this activity.
- Students should be able to work through this activity at home or in a computer lab with no supervision.
ACTIVITY DESCRIPTION AND TEACHING MATERIALS
Explore >> US Historical Climate: Excel Statistical
TEACHING NOTES / CONTEXT FOR USE
CLEAN reviewers comments about this resource:
Activity and Starting Point page by R.M. MacKay. Clark College, Physics and Meteorology.
Assessment is at the discretion of the educator and how this video is applied.