Premium
The application of spreadsheets for teaching hydrological modeling and climate change impacts on streamflow
Author(s) -
PérezSánchez Julio,
SenentAparicio Javier,
JimenoSáez Patricia
Publication year - 2022
Publication title -
computer applications in engineering education
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.478
H-Index - 29
eISSN - 1099-0542
pISSN - 1061-3773
DOI - 10.1002/cae.22541
Subject(s) - streamflow , watershed , climate change , computer science , hydrological modelling , class (philosophy) , hydrology (agriculture) , water resources , environmental science , mathematics education , psychology , climatology , drainage basin , geography , artificial intelligence , machine learning , engineering , ecology , cartography , geotechnical engineering , biology , geology
Hydrology teaching currently relies upon educators' background, requiring a change in training future professionals to manage water resources to address climate change, among other issues. In the teaching experience described in this paper, traditional lectures in a postgraduate civil engineering master's degree were replaced by the development and assessment of a lumped hydrological model implemented into an Excel spreadsheet. Although the primary activity evaluated the long‐term impacts of climate change on streamflow in a watershed, the students were required to address several specific issues such as calibration and validation processes, goodness‐of‐fit metrics, uncertainties of parameters, and sensitivity analysis. The learning experience's efficacy was assessed by conducting two surveys comparing the participants' knowledge before and after the exercise. The results revealed that 92.3% of the students considered that their hydrological skills had improved significantly following the exercise. Furthermore, the acquisition of hydrological modeling concepts was satisfactorily appreciated by all the participants, 97.6% of whom considered it useful or highly useful. Using a spreadsheet as a complementary tool in hydrology teaching increases student participation and motivation provided it is a contemporary and appealing issue, and the teacher clearly defines, monitors, and follows up on the class objectives.