Excel在水文学教学中的应用

The Case Application of Excel in Hydrology Teaching

水文学是给排水科学与工程专业的专业基础课。针对水文学课程教学特点,充分利用Excel计算和绘图功能,进行水文学课程教学研究与探索。本研究以皮尔逊Ⅲ型曲线为例,培养学生利用Excel进行计算,在绘制海森概率格纸的基础上进行理论频率曲线的绘制。

Hydrology is an important basic course of water supply and drainage science and engineering.According to the characteristics of hydrology,taking the advantage of Excel on its calculation and drawing function,to develop the teaching research in hydrology.In this study,taking Pearson-Ⅲ curve as an example,training the students to calculate using Excel,based on drawing Hessen probability grid paper,to draw the theoretical frequency curve.