Plotting Florida River Data Using Excel

Kim Hannula

Fort Lewis College

This activity has been reviewed by 2 review processes (view details)

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.
This activity has benefited from input from faculty educators beyond the author through a review and suggestion process. This review took place as a part of a faculty professional development workshop where groups of faculty reviewed each others' activities and offered feedback and ideas for improvements. To learn more about the process On the Cutting Edge uses for activity review, see http://serc.carleton.edu/NAGTWorkshops/review.html.

Initial Publication Date: April 30, 2008 | Reviewed: October 22, 2012 (see revision history: 2 events)

Summary

This exercise is used to prepare students to analyze data they will collect during their group project. It familiarizes students with previously collected data, and builds skills graphing and interpreting data.

Water Quality/Chemistry , Surface Water | College Introductory

Expand for more detail and links to related resources

Share your modifications and improvements to this activity through the Community Contribution Tool »

Context

Audience

Introductory earth systems science course (see course profile), introductory environmental geology course.

Skills and concepts that students must have mastered

- Graphing data by hand.
- Using networked campus computers.

How the activity is situated in the course

This exercise comes in the middle of a series of exercises that prepare students to collect and interpret water quality data. Before this exercise, students have looked at maps of the Florida River basin, and have plotted monthly discharge data for two sites by hand. After this exercise, students will collect their own data from one of the sites, and will compare it to the data that was previously collected.

See an overview of this project and find descriptions for each of the activities on the Florida River overview page.

Goals

Content/concepts goals for this activity

- Graphing using MS Excel

Higher order thinking skills goals for this activity

- Analysis of data based on graphs
- Formulation of hypotheses

Other skills goals for this activity

Description of the activity/assignment

Students graph existing water quality data using MS Excel, and use the graphs to discuss the changes in discharge, sediment load, and dissolved load along the length of the river and over time. This exercise prepares students to analyze and discuss their own data later in the semester.