Oxford Air Temperature

This project includes:

1. A short guide to Microsoft Excel, incorporating activities to explore.

2. Exploring climate data using Microsoft Excel.

+
Summary

This project includes:

1. A short guide to Microsoft Excel, incorporating activities to explore.

2. Exploring climate data using Microsoft Excel.

+
Strands

Number and Measures, Algebra and Graphs

+
Prior knowledge

Appreciation of moving averages and basic spreadsheet knowledge.

+
Relevance to Core Maths qualifications

•AQA

•C&G

•Eduqas

•Pearson / Edexcel

•OCR

+
Suggested approaches

Suitable for: students to work in pairs to develop Excel spreadsheet skills.

+
Resources/documentation

In addition to these teacher guidance notes there are:

  • a brief guide to using Microsoft Excel, for students
  • ’Oxford air temperature’ worksheet with embedded website (http://www.geog.ox.ac.uk/research/climate/rms/meanair.html) and 7 activities;
  • ‘Oxford air temperature data’ spreadsheet with graphs plotted and moving averages highlighted

+
Relevant digital technologies

Access to Excel spreadsheet required.

+
Possible extensions

There is plenty of scope to use these Excel skills with other large data sets, including working with large pre-release data sets.

+
Acknowledgement

Developed by Greg Bason at Abingdon and Witney College.