|
Explore Teaching Examples | Provide Feedback

Achieve New Heights: Go to the Rockies!

Judy A McIlrath
University of South Florida, Tampa

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 Denver, CO and passing through 10 parks in Colorado. 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.

Used this activity? Share your experiences and modifications

Learning Goals

Slide5_JAM1.2

Students will:

In the process the students will:

Context for Use

Slide8_JAM1.2
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

Slide16_JAM1.2

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. In general, the students considered this module to be one of the simplest modules in the collection. It is now one of the modules that is rotated into the online 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.

See more Examples »