Quality Assured
Tooltip
These resources have been reviewed and selected by STEM Learning’s team of education specialists for factual accuracy and relevance to teaching STEM subjects in UK schools.

Climate Prediction

The Nuffield Foundation provides this activity which students use to create spreadsheets that model what would happen to the temperature of the Earth if there were to be a sudden change in the amount of radiation entering or leaving the planet. Students then investigate polynomial and exponential functions to find the best model. Before doing this activity students will need to have learnt how to use a spreadsheet to: *write spreadsheet formulae involving both relative and absolute cell references *draw graphs *use trendlines to find polynomial regression lines. Students will also need to know how to enter numbers in standard form into a spreadsheet. There are two versions of this activity, Climate A assumes students have access to Excel spreadsheets, whilst Climate B is an alternative paper-based activity requiring use of a graphic calculator.

Show health and safety information

Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.

Downloads

Show downloads

Close

Download all files as a .zip2.5 MB
Information on the permitted use of this resource is covered by the Category Three Content section in STEM Learning’s Terms and conditions.
Subject(s)Mathematics
Age16-19
Published2010 to 2019
Published by
Collections
Direct URLhttps://www.stem.org.uk/rxydv

Actions

Add to favourites list

Share this resource