Skip to content | Change text size
Handbooks Courses Units Related information

CIV2207 - Computing and water systems modelling

6 points, SCA Band 2, 0.125 EFTSL

Undergraduate Faculty of Engineering

Leader(s): P Ranjith, Edoardo Daly


Clayton Second semester 2009 (Day)


This unit covers basic spreadsheet computing skills and includes particular training in: mathematical tools such as matrix operations (eg solving simultaneous equations), curve fitting and trendlines, and numerical search techniques; user defined functions; user interface elements such as dialog boxes (using elements such as labels, text boxes, drop-down list boxes, spinners, etc) and VBA programming to automate spreadsheet functions. It also covers the following topics in water engineering: estimation of design rainfall; runoff processes; streamflow data and analysis; flood frequency analysis; reservoir operation and a major assignment on hydrology using spreadsheets.


This unit aims to strengthen the computing skills of undergraduates in civil engineering and related courses, and provide experience with numerical modelling and general computer-based problem solving. Many of the required skills are developed in the context of solving problems in hydrology, geomechanics, and structural engineering. There is some emphasis on theoretical aspects of hydrology.


Class tests: 15%
Group assignment: 45%
Examination (3 hours): 40%. Students must pass both the examination and overall assessment components to pass the unit.

Contact hours

3 hours lectures, 2 hours computer laboratories/practice classes and 7hours of private study per week



[an error occurred while processing this directive]