Jump to this Activity »
From Isotopes to Temperature: Working With A Temperature Equation
http://serc.carleton.edu/sp/ssac_home/general/examples/14332.html

Dorien McGee, University of South Florida, Washington Center for Improving Undergraduate Education

In this activity, students will use oxygen isotope values of two species of modern coral to reconstruct ambient water temperature over a four-year period. They use Microsoft Excel, or similar application, 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 whether isotope records can be considered to be good proxies for records of past temperatures.

Activity takes about two lab periods or can be done as a homework assignment. Computer with Excel software is required.

Discuss this Resource»
Learn more about Teaching Climate Literacy and Energy Awareness»

Climate Literacy
About Teaching Climate Literacy

mate is regulated by complex interactions among components of the Earth system
About Teaching Principle C
Other materials addressing Cli
Climate change is a significant and persistent change in an area’s average climate conditions or their extremes. Seasonal variations and multi-year cycles (for example, the El Niño Southern Oscillation) that produce warm, cool, wet, or dry periods across different regions are a natural part of climate variability. They do not represent climate change.
About Teaching Principle 4
Other materials addressing 4c
Scientific observations indicate that global climate has changed in the past, is changing now, and will change in the future. The magnitude and direction of this change is not the same at all locations on Earth.
About Teaching Principle 4
Other materials addressing 4d
Observations, experiments, and theory are used to construct and refine computer models that represent the climate system and make predictions about its future behavior. Results from these models lead to better understanding of the linkages between the atmosphere-ocean system and climate conditions and inspire more observations and experiments. Over time, this iterative process will result in more reliable projections of future climate conditions.
About Teaching Principle 5
Other materials addressing 5c

Excellence in Environmental Education Guidelines

1. Questioning, Analysis and Interpretation Skills:G) Drawing conclusions and developing explanations
Other materials addressing:
G) Drawing conclusions and developing explanations.
1. Questioning, Analysis and Interpretation Skills:B) Designing investigations
Other materials addressing:
B) Designing investigations.
1. Questioning, Analysis and Interpretation Skills:E) Organizing information
Other materials addressing:
E) Organizing information.
1. Questioning, Analysis and Interpretation Skills:F) Working with models and simulations
Other materials addressing:
F) Working with models and simulations.
2. Knowledge of Environmental Processes and Systems:2.1 The Earth as a Physical System:A) Processes that shape the Earth
Other materials addressing:
A) Processes that shape the Earth.

Benchmarks for Science Literacy
Learn more about the Benchmarks

Scientific investigations usually involve the collection of relevant data, the use of logical reasoning, and the application of imagination in devising hypotheses and explanations to make sense of the collected data.
Explore the map of concepts related to this benchmark
The earth's climates have changed in the past, are currently changing, and are expected to change in the future, primarily due to changes in the amount of light reaching places on the earth and the composition of the atmosphere. The burning of fossil fuels in the last century has increased the amount of greenhouse gases in the atmosphere, which has contributed to Earth's warming.
Explore the map of concepts related to this benchmark

Notes From Our Reviewers The CLEAN collection is hand-picked and rigorously reviewed for scientific accuracy and classroom effectiveness. Read what our review team had to say about this resource below or learn more about how CLEAN reviews teaching materials
Teaching Tips | Science | Pedagogy | Technical Details

Teaching Tips

  • Forming groups of students (especially pairing students of different level of experiences in Excel) will enhance the effectiveness of the activity.
  • Strong guidance of students is required in order to ensure they don't simply follow the instructions but understand the relevance in terms of paleoclimatology.
  • Include a final discussion on the relevance of what students learned on their understanding of global temperatures.

About the Science

  • The dataset and conversion equation used in this module were contrived though are based on actual datasets and conversion equations used for corals.
  • The spreadsheet is based on the PDB standard and the equation given in the presentation uses SMOW standard. Instructors need to clarify the difference between the standards.
  • Comments from expert scientist: The resource is very sound, and despite being fairly fundamental in paleoclimatology it often can confuse students. However, here it is clearly presented and explained, with relevant background and application information.

About the Pedagogy

  • This activity is designed to improve students' quantitative skills.
  • Activity relies heavily on Excel use, and students need to very comfortable with formulas in Excel to follow the activity.
  • Modeling aspect of this activity may be engaging for some students.

Technical Details/Ease of Use

  • Instructor version is available by request to the author (a link is provided).
  • PowerPoint and associated files are available for download from the activity sheet.
  • Even though these PowerPoint slides are very dense, they are given as a .ppt file and could be broken up and modified easily.

Jump to this Activity »



Have you used these materials with your students? Do you have insights to share with other educators about their use? Please share with the community by adding a comment below.

Please use this space only for discussion about teaching with these particular materials.
For more general discussion about teaching climate literacy please use our general discussion boards.
To report a problem or direct a comment to the CLEAN project team please use our feedback form (or the feedback link at the bottom of every page).
Off-topic posts will be deleted.

Join the Discussion


Log in to reply