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
This material was originally developed by
Spreadsheets Across the Curriculum as part of its collaboration with the
SERC Pedagogic Service.
- This activity has been selected for inclusion in the CLEAN collection.
This activity has been extensively reviewed for inclusion in the Climate Literacy and Energy Awareness Network's collection of educational resources. For information the process and the collection, see http://cleanet.org/clean/about/selected_by_CLEAN.
This activity was selected for the On the Cutting Edge Reviewed Teaching Collection
This activity has received positive reviews in a peer review process involving five review categories. The five categories included in the process are
- Scientific Accuracy
- Alignment of Learning Goals, Activities, and Assessments
- Pedagogic Effectiveness
- Robustness (usability and dependability of all components)
- Completeness of the ActivitySheet web page
For more information about the peer review process itself, please see https://serc.carleton.edu/teachearth/activity_review.html.
- First Publication: May 28, 2007
- Reviewed: March 2, 2023 -- Reviewed by the On the Cutting Edge Activity Review Process
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.
Topics
Geoscience Grade Level
College Introductory, College Lower (13-14)
Follow the link above to find
activities from Teach the Earth on a specific topic.
Share your modifications and improvements to this activity through the Community Contribution Tool »
Learning Goals
Students will:
- Create and work with spreadsheets in Excel.
- Gain experience using estimations to solve a problem .
- Gain experience using and considering significant figures.
- Gain experience using the basic geometric formula for surface area.
- Gain experience manipulating algebraic equations.
In the process, the students will:
- Use estimates and simplifying assumptions to approximate the drop in sea level during the glacial maxima.
- Evaulate the validity of the simplifying assumptions they have used.
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.