CIV2207 - Computing and water systems modelling - 2017

6 points, SCA Band 2, 0.125 EFTSL

Undergraduate - Unit

Refer to the specific census and withdrawal dates for the semester(s) in which this unit is offered.



Organisational Unit

Department of Civil Engineering


Dr Ha Hong Bui (Clayton)

Dr Sina Alaghmand (Malaysia)

Not offered in 2017


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 trend lines, 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.


At the successful completion of this unit you will be able to:

  1. Describe fundamental mathematical formulations for solving problems in civil engineering.
  2. Apply spreadsheet computing and VBA programming tools to assist their designs in structure engineering, geomechanics and hydrology following the Australian and New Zealand standard.
  3. Formulate typed brief reports detailing how they address and solve problems that meets Australian and New Zealand standards.


Three projects: 45%

Examination (3 hours): 55%

Students are required to achieve at least 45% in the total continuous assessment component (assignments, tests, mid-semester exams, laboratory reports) and at least 45% in the final examination component and an overall mark of 50% to achieve a pass grade in the unit. Students failing to achieve this requirement will be given a maximum of 45% in the unit.

Workload requirements

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

See also Unit timetable information

Chief examiner(s)