Spreadsheets and the Hydrological Cycle
Summary
Devise and implement a spreadsheet solution for a basin hydrological cycle. In part one of this activity, assume steady-state conditions to model percentage fluxes to and from various components of the cycle. Use a spreadsheet program to calculate evapotranspiration and runoff then use results to answer questions. In part two, assume a mean annual temperature increase that results in increased evapotranspiration in the steady state reservoir model. Make a diagram and modify the spreadsheet accordingly. Compare evapotranspiration and runoff results from scenarios one and two and answer questions.
Learning Goals
- Enhance spreadsheet programming skills.
- Better understand the terrestrial part of the hydrological cycle.
- Stimulate thought about effects of climate change on hydrological cycle and water resources.
Context for Use
This activity is appropriate for upper-level undergraduate and graduate students.
Description and Teaching Materials
A spreadsheet program is required.
Teaching Notes and Tips
The solution given in the paper is not the most unique or efficient, but it only takes half an hour to set up, run, and check so it is good for a single class/lab session. The Thornthwaite equation is more sophisticated and is good for more in-depth investigation.