From Isotopes to Temperature: Working With A Temperature Equation
This material was originally developed by Spreadsheets Across the Curriculum as part of its collaboration with the SERC Pedagogic Service.
Summary
In this Spreadsheets Across the Curriculum PowerPoint module, students will use oxygen isotope values of two species of modern coral to reconstruct ambient water temperature over a four-year period. Students are provided a dataset including the oxygen isotope values of the two coral species, as well as temperature and oxygen isotope values of the surrounding water. Students use Microsoft Excel to create a spreadsheet of temperature values calculated from the isotope values of the corals by means of an algebraic equation. Students then use correlation and regression techniques to determine which coral's isotopes serve as a better proxy for water temperature. A post-assessment of module skills, concepts, and applications, is included at the end of the presentation conclusion of the module.
Learning Goals
Context for Use
Description and Teaching Materials
SSAC2006.QE445.DKM1.1 - Dataset (Excel 25kB Dec8 06)
This module is a downloadable PowerPoint file with an embedded Excel spreadsheet dataset that students will use to start their calculations. If used with lecture, classroom computer access will be required. Computers must be loaded with both MS PowerPoint and Excel. Laboratory materials and external materials are not required. If used outside lecture, students will need access to the module file as well as a computer loaded with PowerPoint and Excel.
End of module assignments may be printed and submitted to the instructor for assessment. Alternatively, and depending on logistics and available resources, it may be more appropriate for the students to submit the assessment materials electronically. Internet access is required only in the downloading of the module and electronic submission of the assessment.
This PowerPoint file is the student version of the module. An instructor version is available by request. The instructor version includes the completed spreadsheet. Send your request to Len Vacher (vacher@usf.edu) by filling out and submitting the Instructor Module Request Form.
Teaching Notes and Tips
The dataset and conversion equation used in this module were contrived, though are based on actual datasets and conversion equations used for corals.