Availabilities:

2020 unit offering information will be available in September 2019

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

Prescribed texts

Session 1

  • Larsen, RW, 2017, Engineering with Excel, 5th edn, Pearson, Upper Saddle River, New Jersey.
Prescribed texts may change in future study periods.

Teaching and assessment

Lismore

Teaching method
Lecture on-site 2 hours (12 weeks)
Tutorial on-site 2 hours (12 weeks)
Assessment
Excel Assignment25%
Excel Assignment25%
Exam: closed book50%
Notice

Intensive offerings may or may not be scheduled in every session. Please refer to the timetable for further details.

Southern Cross University employs different teaching methods within units to provide students with the flexibility to choose the mode of learning that best suits them. SCU academics strive to use the latest approaches and, as a result, the learning modes and materials may change. The most current information regarding a unit will be provided to enrolled students at the beginning of the study session.

Fee information

Domestic

Commonwealth Supported courses
For information regarding Student Contribution Amounts please visit the Student Contribution Amounts.
Commencing 2020 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.

+