Availabilities:

Location Domestic International
Lismore Session 1 Session 1

Unit Summary

Unit type

UG Coursework Unit

Credit points

12

AQF level

7

Level of learning

Intermediate

Unit aim

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 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.

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.

GA1: Intellectual rigour, GA2: Creativity, GA3: Ethical practice, GA4: Knowledge of a discipline, GA5: Lifelong learning, GA6: Communication and social skills, GA7: Cultural competence
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 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 numerical differentiation and numerical integration 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

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
    • GA2: Creativity
    • GA4: Knowledge of a discipline
  2. understand and implement basic numerical algorithms for computing solutions of non-linear and linear equations, mathematical programming and optimisation
    • GA4: Knowledge of a discipline
  3. demonstrate an understanding of numerical differentiation and numerical integration
    • GA4: Knowledge of a discipline
  4. demonstrate proficiency in the basic application of simulations, such as Monte Carlo simulations
    • GA4: Knowledge of a discipline
  5. formulate and numerically solve defined problems in civil engineering applications.
    • GA2: Creativity
    • GA4: Knowledge of a discipline

Prescribed texts

  • Prescribed text information is not currently available.
Prescribed texts may change in future study periods.