| Area: |
Department of Mathematics and Statistics |
| Credits: |
25.0 |
| Contact Hours: |
3.0 |
| |
| ** The tuition pattern below provides details of the types of classes and their duration. This is to be used as a guide only. For more precise information please check your unit outline. ** |
| |
| Lecture: |
1 x 1 Hours Weekly |
| Practical: |
1 x 2 Hours Weekly |
| |
| Syllabus: |
Introduction to financial modeling, using real world models. The development process - understand, design, build, test, implement and maintain excel as a modelling tool. Design principles & the user interface. Workshop - design (benefit projection modelling). The analytical process (using workers compensation insurance as an example). Workshop - analysis (workers compensation insurance modelling). Completion - testing, security and maintenance. Introduction to modelling using VBA, and advanced VBA techniques. Working with data in excel. Stochastic asset/liability modeling. Workshop - stochastic (stochastic asset/liability modelling). |
| |
| ** To ensure that the most up-to-date information about unit references, texts and outcomes appears, they will be provided in your unit outline prior to commencement. ** |
| |
| Field of Education: | 081101 Banking and Finance |
| Funding Cluster: | 02 - Accounting, Administration, Economics, Commerce |
| SOLT (Online) Definitions*: | Informational
*Extent to which this unit or thesis utilises online information |
| Result Type: | Grade/Mark |
Availability |
| Year |
Location |
Period |
Internal |
Partially Online Internal |
Area External |
Central External |
Fully Online |
| 2005 |
Bentley Campus |
Semester 2 |
Y |
|
|
|
|
Area
External |
refers to external course/units run by the School or Department or offered by research. |
Central
External | refers to external and online course/units run through the Curtin Bentley-based Distance Education Area |
Partially
Online
Internal | refers to some (a portion of) learning provided by interacting with or downloading pre-packaged material from the Internet but with regular and ongoing participation with a face-to-face component retained. Excludes partially online internal course/units run through the Curtin Bentley-based Distance Education Area which remain Central External |
Fully
Online | refers to the main (larger portion of) mode of learning provided via Internet interaction (including the downloading of pre-packaged material on the Internet). Excludes online course/units run through the Curtin Bentley-based Distance Education Area which remain Central External |
|
