Plotting Florida River Data Using Excel

Kim Hannula
Fort Lewis College
Author Profile


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.

Used this activity? Share your experiences and modifications



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.


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.

Determining whether students have met the goals

- Evaluate printed plots: have students succeeded in plotting the data?
- Compare answers to data: are the answers reasonable, given the plots?

More information about assessment tools and techniques.

Teaching materials and tips

Other Materials