309022 (v.1) Practical Financial Modelling 502

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 modelling using real-world models. The development process: understand, design, build, test, implement and maintain. Using Excel as a modelling tool. Design principles and 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 modelling. 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:	010199 Mathematical Sciences not elsewhere classified
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
2008	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