Cutting Edge > Environmental Geology > Teaching Activities > Flood Recurrence Intervals

Flood Recurrence Intervals

Norlene Emerson, University of Wisconsin-Richland
Author Profile

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

This page first made public: May 19, 2012


This lab activity has students use stream discharge data obtained from the USGS Water Resources Division web site in order to calculate recurrence intervals for a local stream. Using the recurrence data generated, the students then make recommendations to the residents of a local town as to what they might do to reduce their loss from the effects of frequent flooding in their community.



This activity has been developed for an introductory-level Environmental Geology course that has both a lecture and lab component. Most of the students who take the course are non-majors and are at the freshman or sophomore level.

Skills and concepts that students must have mastered

Students should have some basic knowlege of streams and floods. Prior experience with using excel to make graphs is helpful but not manditory.

How the activity is situated in the course

This lab is given to students after they have been introduced to the topics of streams and floods in the lecture portion of the course.


Content/concepts goals for this activity

Following completion of this activity, students should be able to:

Higher order thinking skills goals for this activity

interpret a flood frequency chart, extrapolate a trendline in order to make predictions concerning larger future floods

Other skills goals for this activity

Students should have prior experience using Excel software to make spreadsheets, create charts, and enter formulas.

Description and Teaching Materials

In this lab, students calculate recurrence intervals for various flood records on a portion of the Kickapoo River in southwest Wisconsin based on historical data obtained from a gaging station on the Kickapoo River maintained by the USGS. The historical data is accessed from the USGS Water Resources Division. Students create Excel tables to calculate discharge ranks, recurrence intervals, and annual exceedence probablilities. The students use the data they generate in order to create a recurrence interval graph and to map the extent of a flood event.

Student Handout (Microsoft Word 85kB Jun11 13)
Map of Gays Mills (Microsoft Word 229kB May19 12)

Teaching Notes and Tips

This lab activity as presented can be completed during a two hour lab period. Students will need access to the internet and Excel.


Students will each turn in their Excel data tables, their flood frequency graph, a map of the Kickapoo River valley near Gays Mills, WI, and their answers to questions on the activity sheet.

See more Teaching Activities »

« A River Runs Through It: an exploration in land use and water resource management       Flood Frequency Analysis »