Environmental Geology > Teaching Activities > Flood Frequency Analysis

Flood Frequency Analysis

Sheila Roberts, Bowling Green State University
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 http://serc.carleton.edu/NAGTWorkshops/review.html.

This page first made public: May 16, 2012


This assignment asks students to do a flood frequency analysis to determine the size and stage of various floods and determine if the town of Crawford, OH is likely to be flooded or not. Outcomes: learn to work with quantitative data, learn to use Excel, be able to use USGS data.



This assignment is given in a 3000-level environmental geology course. A similar assignment is given as a lab in the 1000-level physical geology course.

Skills and concepts that students must have mastered

understand retrun period for floods
be able to draw graphs and write equations in Excel
be able to do simple algebra

How the activity is situated in the course

Stand alone exercise


Content/concepts goals for this activity

Understand flood frequency

Higher order thinking skills goals for this activity

obtain online data
analyze data
interpret data
understand uncertainty

Other skills goals for this activity

Description and Teaching Materials

flood frequency assignment (Acrobat (PDF) 35kB Apr30 12)

Teaching Notes and Tips

The USGS water data has some "problems" in the file, including the format used for the data of the peak stream flow. If students don't look at the graph of discharge vs time, they will get it wrong. Also, there are two years that are listed twice and two missing years.


  1. Grading
    Did students check to see if their results were reasonable
  2. Reviewing results with students in class (show them that people estimated different stages and discharges for various floods, how the flooded area on the topo map was a little different)

References and Resources

USGS topographic maps:

USGS water data:

See more Teaching Activities »