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.
HEALTH and SAFETY
Any use of a resource that includes a practical activity must include a risk assessment. Please note that collections may contain ARCHIVE resources, which were developed at a much earlier date. Since that time there have been significant changes in the rules and guidance affecting laboratory practical work. Further information is provided in our Health and Safety guidance.