## Availabilities:

LocationDomesticInternational
Gold Coast
Lismore
OnlineN/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

1. Introduction to Excel and mathematical programming
2. Solving mathematical programming and simulation problems
3. Visual Basic for applications (part 1)
4. Visual Basic for applications (part 2)
5. Solving equations and data manipulation
6. Numerical integration and differentiation

## 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. demonstrate proficiency in the application of simulations, such as Monte Carlo simulations.

## Prescribed Learning Resources

Prescribed Texts
• Prescribed text information is not currently available.
Prescribed Resources/Equipment
• Prescribed resources/equipment information is not currently available.
Prescribed Learning Resources may change in future Teaching Periods

## Teaching and assessment

 Teaching method Workshop 1 hour (Weekly) Tutorial 2 hours (Weekly)
 Assessment Excel Assignment 25% Excel Assignment 25% Exam: closed book 50%
 Teaching method Workshop 1 hour (Weekly) Tutorial 2 hours (Weekly)
 Assessment Excel Assignment 25% Excel Assignment 25% Exam: closed book 50%
 Teaching method Workshop 1 hour (Weekly) Tutorial 2 hours (Weekly)
 Assessment Excel Assignment 25% Excel Assignment 25% Exam: closed book 50%
Notice

Intensive offerings may or may not be scheduled in every teaching period. 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 teaching period.

## Fee information

### Domestic

Commonwealth Supported courses
For information regarding Student Contribution Amounts please visit the Student Contribution Amounts.

Fee paying courses