Availabilities:
| Location | Domestic | International |
|---|---|---|
| Lismore | ||
| Online | N/A |
Unit description
Introduces students to the application of computational and numerical methods for simulation, optimisation, linear and non-linear equations, differentiation and integration. Develops skills in applying numerical methods for solving application 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.
Mathematical Programming and Optimisation.
Theory and Practice of Simulations, including Monte Carlo Simulations.
Computing Solutions of Non-linear and Linear Equations.
Programming with Visual Basic for Applications.
Numerical Differentiation.
Numerical Integration.
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.
| On completion of this unit, students should be able to: | |
|---|---|
| 1 | utilise Excel and Visual Basic for Applications to implement computational and numerical methods for solving problems |
| 2 | formulate and solve mathematical programming problems |
| 3 | implement numerical algorithms for computing solutions of problems such as non-linear and linear equations, numerical differentiation and numerical integration |
| 4 | proficiency in the application of simulations, such as Monte Carlo simulations |
| 5 | use programming in Visual Basic for Applications (VBA) within Excel |
On completion of this unit, students should be able to:
- utilise Excel and Visual Basic for Applications to implement computational and numerical methods for solving problems
- formulate and solve mathematical programming problems
- implement numerical algorithms for computing solutions of problems such as non-linear and linear equations, numerical differentiation and numerical integration
- proficiency in the application of simulations, such as Monte Carlo simulations
- use programming in Visual Basic for Applications (VBA) within Excel
Prescribed texts
- Larsen, RW, 2017, Engineering with Excel, 5, Pearson, Upper Saddle River, New Jersey. ISBN: ISBN-13: 978-0134589664 ISBN-10: 0134589661.
Teaching and assessment
| Teaching method |
| Structured online learning 2 hours (12 weeks) |
| Tutorial on-site 2 hours (12 weeks) |
| Assessment | |
| Excel Assignment | 25% |
| Excel Assignment | 25% |
| Exam: closed book | 50% |
| Teaching method |
| Structured online learning 2 hours (12 weeks) |
| Tutorial online 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.
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.