by Sabrina McAllister and Chris Pugh


CFU 0507.7.2 Prepare a chart to compare how volcanoes, earthquakes, faulting, and plate movements affect the earth's surface features.

GLE 0506.5.1 Make, record, display and interpret data and graphs that include whole numbers, decimals, and fractions.

ISTE NETS 1. Creativity and Innovation C. use models and simulations to explore complex systems and issues.


In this lesson, the students will work in partners. One partner will be the researcher. The other will be the recorder. The Researcher will open Google Earth. The recorder will open

The Researcher will...
  1. Open Google Earth.
  2. Click in "Fly To" box and type "Mount St. Helens". Click the magnifying glass to zoom to the mountain.
  3. Look in the lower left corner of the window for the LAYERS section.
  4. Click on the triangle beside the GALLERY layer to expand it.
  5. Click in the checkbox to add EARTHQUAKES icons to the Google Earth.
  6. Click on the 5 different Earthquake symbols and help the recorder to accurately record the date, time, and magnitude into each cell of the spreadsheet.

The Recorder will...
  1. Open and click SPREADSHEET to create a blank a table to put earthquake date and time information.
  2. Click and drag the divider between the A and B labels to stretch the width of the column.
  3. Click on the label for Column B.
  4. Click on the FORMAT menu from the top and choose CELLS.
  5. Click on Number and change Decimal places to 1.
  6. Click in Cell A3 and type "Date/Time".
  7. Click in Cell B3 and type "Magnitude".
  8. Click in Cell B1 and type Earthquake Data.
  9. Starting in A4 type the date and time for the earthquake shared by the researcher. In B4, type the magnitude for the earthquake.
  10. Repeat for each of the other earthquake data icons that the researcher shares. Put each in its own row.
  11. When all are recorded, highlight cells A3 down to A8 and over to column B.
  12. Click on the DATA menu in the top menu bar and choose SORT.
  13. In the sort window, change the 1st "Sort by" drop-down menu from "Magnitude" to "Date/Time". Click OK.
  14. Highlight Cell B3 down to B8.
  15. Click on the chart button. Walk through the wizard to create an easy to read graph.
    1. Choose a graph.
    2. Decide which is more helpful, "Data Series in Rows" or "Data Series in Columns".
    3. Skip the step 3.
    4. In the Chart Elements, add a title and subtitle.
    5. Click "FINISH".
  16. Type their name and the researcher's name in the 2 different cells in Row 1.
  17. Click FILE and PRINT. Print 2 copies, one for each partner.

To tie the earthquake data with plate tectonics, TTW add the Volcanoes layer and finally a Tectonic Plates overlay downloaded from to allow the students to make observations about the relationship between earthquakes, volcanoes, and tectonic plates.