units
CIV2207
Faculty of Engineering
This unit entry is for students who completed this unit in 2013 only. For students planning to study the unit, please refer to the unit indexes in the the current edition of the Handbook. If you have any queries contact the managing faculty for your course or area of study.
To find units available for enrolment in the current year, you must make sure you use the indexes and browse unit tool in the current edition of the Handbook.
Level | Undergraduate |
Faculty | Faculty of Engineering |
Organisational Unit | Department of Civil Engineering |
Offered | Clayton Second semester 2013 (Day) |
Coordinator(s) | Dr Ha Bui/Dr Edoardo Daly |
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.
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.
3 hours lectures, 2 hours computer laboratories/practice classes and 7hours of private study per week