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
*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.
You might also like
|Published||2010 to date|
Share this resource
This resource is part of Nuffield Free-standing Mathematics Activities