Availabilities:
| Location | Domestic | International |
|---|---|---|
| Lismore | Session 1 | Session 1 |
Unit aim
Introduces students to the application of computational and numerical methods for simulation, optimisation, linear and non-linear equations, matrices, linear systems, eigenvalues and eigenvectors. Develops skills in applying numerical methods for solving civil engineering problems, utilising software such as Microsoft Excel and Visual Basic for Applications programming.
Unit content
The Use of Excel and Visual Basic for Applications (VBA) for Computational and Numerical Methods.
Theory and Practice of Simulations, including Monte Carlo Simulations.
Computing Solutions of Non-linear and Linear Equations.
Introduction to Mathematical Programming and Optimisation.
Programming with Visual Basic for Applications.
Matrices, including Inverses, and Solving Linear Systems.
Eigenvalues and Eigenvectors.
Learning outcomes
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 and Visual Basic for Applications, and other software, to implement computational and 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, mathematical programming and optimisation | Knowledge of a discipline | ||||||
| 3 | demonstrate an understanding of matrices, linear systems and eigenvalues and eigenvectors | Knowledge of a discipline | ||||||
| 4 | demonstrate proficiency in the basic application of simulations, such as Monte Carlo simulations | Knowledge of a discipline | ||||||
| 5 | formulate and numerically solve defined problems in civil engineering applications. | Creativity | Knowledge of a discipline | |||||
Prescribed texts
Session 1
- Larsen, RW, 2017, Engineering with Excel, 5th edn, Pearson, Upper Saddle River, New Jersey.
Teaching and assessment
Lismore
| Teaching method |
| Lecture on-site 2 hours (12 weeks) |
| Tutorial on-site 2 hours (12 weeks) |
| Assessment | |
| Excel Assignment | 25% |
| Excel Assignment | 25% |
| Exam: closed book | 50% |
Fee information
Domestic
Commonwealth Supported courses
For information regarding Student Contribution Amounts please visit the Student Contribution Amounts.
Commencing 2019 Commonwealth Supported only. Student contribution band: 2
Fee paying courses
For POSTGRADUATE or UNDERGRADUATE full fee paying courses please check Domestic Postgraduate Fees OR Domestic Undergraduate Fees
International
Please check the international course and fee list to determine the relevant fees.