Teaching Numerical Groundwater Flow Modeling with Spreadsheets

Abstract

AbstractThe use of spreadsheets for numerical groundwater flow modeling is not a novelty; however, its potential in the classroom has not been emphasized enough. This Teachers Aid provides a step-by-step implementation of a steady-state, vertically integrated two-dimensional groundwater flow model in a confined irregular aquifer with boundary conditions of the three kinds and subject to pumping and recharge that will enhance the learning experience of students that are confronted for the first time with the numerical solution of the groundwater flow partial differential equation.