ACTUARIAL PROGRAMMING

About this Course

  • 13 students enrolled
  • 3 instructors

Course Description

This course introduces the fundamental of using the spreadsheet tools (Microsoft Excel) and programming (Visual Basic Application) specifically to solve actuarial problems. It emphasizes the importance of understanding the root of the problems and solving problems in a structured manner by using Microsoft Excel and VBA. The actuarial problems mentioned include the problems and calculation in Actuarial Mathematics, Financial Mathematics, Statistics and others.

Course Learning Outcomes

1 ) Display the practical skills in tasks related to the actuarial related software.
2 ) Apply programming knowledge by solving actuarial problems
3 ) Analyse data related to actuarial problems

Course Details

STATUS : Open
DURATION : FLEXIBLE
EFFORT : 4 hours per week
MODE : 100% Online
COURSE LEVEL : Intermediate
LANGUAGE : English
CLUSTER : Science & Technology ( ST )

Join this course

 Syllabus

And / Or Syntax
If Syntax
Iferror Syntax
Vlookup

Formulation
How to create amortization schedule

Formulation
How to create commutation function for life table

Declaration variables
Link with Excel
Properties of Object

Properties of Command Button

If ... Then ... Else
Select Case

Par Bond
Premium / Discount Bond
Callable / Putable Bond

For ... Next
Do ... Loop

Formulation
How to create bond amortization schedule

Formulation
How to create commutation function for life table

Formulation
How to calculate area under the graph

Declaration
Dynamic Array
Multi Dimensional Array

Properties of UDF
Declaration of variables

Properties of User Interface
Declaration of variables (.text, .caption)
Calculation for reserve, changes in inputs that will affect the reserves and can relate with Value At Risk

Our Instructor

ARWIN IDHAM BIN MOHAMAD

 Course Instructor
UiTM Shah Alam

MUHAMMAD HAZRANI BIN ABDUL HALIM

 Course Instructor
UiTM Shah Alam

SARAH NADIRAH BINTI MOHD JOHARI

 Course Instructor
UiTM Shah Alam

 Frequently Asked Questions

A1 : Actuarial Programming is a combination of Actuarial Science and Programming Language subject.