|
Starting Point-Teaching Entry Level Geoscience > Mathematical and Statistical Models > Mathematical and Statistical Models Examples > Sea Floor Spreading I
Explore Teaching Examples | Provide Feedback

Sea Floor Spreading I

Activity and Starting Point page by R.M. MacKay. Clark College, Physics and Meteorology.
This material is replicated on a number of sites as part of the SERC Pedagogic Service Project

Summary

In this introductory Excel tutorial, students use Excel to explore the geodynamics Model equation for ocean depth around a sea-floor spreading center (see David T Sandwell or Turcotte and Schubert, 2002). The activity is primarily an introductory tutorial on Excel for students with no prior Excel experience. The use of the equation relating ocean floor depth to sea floor spreading rate and distance from spreading center provides a geoscience context. Activity II (see teaching notes and tips below) is a follow-up activity that has students use Excel to graphically compare the model predictions to observations from several North Atlantic cross-sections.

Brief overview of Ocean Depth/Sea Floor Spreading Model

Learning Goals

Students are carefully guided through using Excel to:

Context for Use

Introductory course in Earth Science in which you want students to gain familiarity with Excel and for which sea floor spreading is an appropriate course topic.

Teaching Materials

We provide the following resources with this module:

Teaching Notes and Tips

This activity will take students about two hours to complete. Students should be able to work through this activity at home or in a computer lab will no supervision. Students more familiar with Excel can work through this activity more quickly.

In a follow-up activity (Sea Floor Spreading II), students compare actual data from Topex satellite measurements to the model predictions of how sea floor spreading rates influence ocean topography. North Atlantic cross-sections at 30° N, 40° N , and 50° N latitude are provided as is information on how to retrieve Topex elevation data from any location globally.

Assessment

Grading the completed activity sheet provided can be used as an assessment of student understanding. The future success of students on other Excel related activities is also another useful assessment tool.

A link to an Excel Answers Document is provided above with several sheets representing different levels of completion for this activity. This can help instructors:

Below we show sample images from this Excel Answer Document.

Figure 1. Predicted (modeled) ocean topography for three different spreading rates, U.

Figure 2. Predicted ocean topography for C=0.11, 0.10, and 0.15 (Exp 1,2, and 3) corresponding to base values of mantle density and temperature of:
3.3 g/cc and 1580 K Exp 1 (control)
4.3 g/cc and 1580 K Exp 2 (30% increase in mantle density)
3.3 g/cc and 2050 K Exp 3 (30% increase in mantle temperature)

{See Brief overview of Ocean Depth/Sea Floor Spreading Model for a description of the model equation, c, and how it relates to mantle temperature and density.}


References and Resources

DLESE Community Review Submit Review Button

Subject

Geoscience:Geology, Oceanography

Resource Type

Activities:Lab Activity

Grade Level

College Lower (13-14):Introductory Level

Ready for Use

Ready to Use

Earth System Topics

Oceans, Solid Earth

Topics

Time/Earth History, Ocean, Solid Earth, Earth surface

See more Mathematical and Statistical Models Examples »