Introduces students to the application of computational numerical methods for simulation, optimisation, linear and non-linear equations, integration, differentiation and differential equations. Develops skills in applying numerical methods for solving civil engineering problems, utilising software such as Excel and Visual Basic programming.
- The Use of Excel and Visual Basic for Computational Numerical Methods.
- Theory and Practice of Simulations, including Monte Carlo Simulations.
- Computing Solutions of Non-linear and Linear Equations.
- Numerical Methods for Optimisation.
- Programming with Visual Basic for Applications.
- Introduction to Differential Equations.
- Numerical Integration.
- Numerical Differentiation.
Unit Learning Outcomes express learning achievement in terms of what a student should know, understand and be able to do on completion of a unit. These outcomes are aligned with the graduate attributes. The unit learning outcomes and graduate attributes are also the basis of evaluating prior learning.
Learning outcomes and graduate attributes
|On completion of this unit, students should be able to:||GA1||GA2||GA3||GA4||GA5||GA6||GA7|
|1||utilise Excel, Visual Basic and other software to implement numerical methods for solving problems||Creativity||Knowledge of a discipline|
|2||understand and implement basic numerical algorithms for computing solutions of non-linear and linear equations and optimisation||Knowledge of a discipline|
|3||demonstrate an understanding of differential equations and apply numerical methods for solving differential equations and integration||Knowledge of a discipline|
|4||demonstrate proficiency in the application of simulations, such as Monte Carlo simulations||Knowledge of a discipline|
|5||formulate and numerically solve problems in civil engineering applications.||Creativity||Knowledge of a discipline|
- Larsen, RW, 2017, Engineering with Excel, 5th edn, Pearson, Upper Saddle River, New Jersey.
Teaching and assessment
Commonwealth Supported courses
For information regarding Student Contribution Amounts please visit the Student Contribution Amounts.
Commencing 2018 Commonwealth Supported only. Student contribution band: 2
Please check the international course and fee list to determine the relevant fees.