|
Starting Point-Teaching Entry Level Geoscience > Spreadsheets Across the Curriculum > Examples > Global Climate: Estimating How Much Sea Level Changes When Continental Ice Sheets Form
Explore Teaching Examples | Provide Feedback

Global Climate: Estimating How Much Sea Level Changes When Continental Ice Sheets Form

Paul Butler
The Evergreen State College, Olympia, WA 98505
Created: 2006-07-28 16:52:12 Last Modified: February 13, 2008 11:30
Author Profile
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 activity, students estimate the drop in sea-level during glacial maxima. They begin by estimating the surface area of the world's oceans, and then use ice volume data to approximate how much sea-level dropped. Students then see how to address one of the key assumptions of the model (area of continental shelf). With this backround, students re-evaluate the key assumption and determine the sea-level rise that would occur if the remaining ice melted.

Learning Goals


Students will: In the process, the students will:

Context for Use

This module was designed for beginning undergraduates in the earth sciences or environmental studies. It can be completed in 2-3 hours.

Description and Teaching Materials


PowerPoint SSAC2006.QE697.PB1.2-student version (PowerPoint 242kB May2 07)

The module is a PowerPoint presentation with embedded spreadsheets.

If the embedded spreadsheets are not visible, save the PowerPoint file to disk and open it from there.

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

I have used this module in two environmental studies labs, and students appeared interested in the topic. Students were able to complete the "end-of-module" questions with minimal introductory explanation and some assistance while they were working.

Assessment

The student version of the module includes an end-of-module assignment that can be used for assessment. The instructor version also includes a pretest that can be coupled with the end-of-module assignment.

References and Resources

This introductory module can be used in conjunction with other earth science modules in the SSAC collection.

See more Examples »