Vacation! How Long and How Far? -- A Geological Circuit of National Parks in the Colorado Plateau


Judy A McIlrath
University of South Florida, Tampa
Created: 2006-11-29 14:21:09 Last Modified: January 05, 2008 18:10

This material was originally developed by Spreadsheets Across the Curriculum as part of its collaboration with the SERC Pedagogic Service.

Summary

This Spreadsheets Across the Curriculum activity is designed as a Geology of National Parks virtual field trip for a general education course in Florida. Students will calculate a time line and budget to drive a circuit starting and ending at Phoenix AZ and passing through 14 parks in or near the Colorado Plateau. Part of the activity is to figure out how many days would be required, given the amount of time to visit each park, and the speed and distance in the park-to-park drives. Each stop (park) is hyperlinked to geological information about the park.

This material is based upon work supported by the National Science Foundation under Grant Number NSF DUE-0836566. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.

Learning Goals

Slide6_JAM1.1
Slide 6 of the module.

Students will:

In the process the students will:

Context for Use

Slide8_JAM1.1
Slide 8 of the module.

This module is designed for potential use in the Geology of National Parks service course at USF. The course is offered as an online course every semester. It includes readings from Parks and Plates, weekly quizzes based on that textbook, and weekly student activities designed to align the course with the University's general education requirements. This module is intended to be one of those activities, with the specific goal of meeting the gen-ed quantitative literacy dimension.

Description and Teaching Materials

Slide10_JAM1.1
Slide 10 of the module.

The module is a PowerPoint presentation with embedded spreadsheets. Click on the link below to download a copy of the module.

Optimal results are achieved with Microsoft Office 2007 or later; the module will function in earlier versions with slight cosmetic compromises. If the embedded spreadsheets are not visible, save the PowerPoint file to disk and open it from there.

The above PowerPoint presentation file is the student version of the module. It includes a template for students to use to complete the spreadsheet(s) and answer the end-of-module questions, and then turn in for grading.

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

The module is constructed to be a stand-alone resource. It can be used as a homework assignment, lab activity, or as the basis of an interactive classroom activity. It is considered to be one of the simplest modules in the collection. It has not been implemented yet in the introductory-level Geology of National Parks course.

Assessment

There is a slide at the end of the presentation that contains end-of-module questions. The end-of-module questions can be used to examine student understanding and learning gains from the module. Pre/post test, pre/post test answer key, and answer key for end-of-module questions are at the end of the instructor version of the module.

References and Resources


Online educational information on geology of the Colorado Plateau


« Calibrating a Pipettor       Simple vs. Compound Interest -- Spreadsheeting the Difference »