Aller à : contenu haut bas recherche

EN     FR
Vous êtes ici:   UNIL > HEC Inst. > HEC App. > SYLLABUS

## Computational Tools for Actuaries

• Teacher(s):   G.Zucchinetti
• Course given in: English
• ECTS Credits: 6 credits
• Schedule: Autumn Semester 2019-2020, 2.0h. course + 2.0h exercices (weekly average)
•  sessions
• Related programme: Master of Science (MSc) in Actuarial Science

### Objectives

This course aims at providing actuaries with a set of conceptual and practical computational tools, ranging from simple formulas computed in a spreadsheet (typically Excel) to programs written in Visual Basic.

### Contents

Information systems are important tools for actuaries, as they make it possible to automatically perform complex calculations on possibly large data sets. In this context, an essential skill lies in the ability to express solutions to actuarial problems using appropriate computational tools. With this course, students have the opportunity to acquire such skills, by learning how to use a range of computational methods relevant to actuarial science. Main chapters are detailed hereafter : Abstract models • Dimensioned models • Advanced models • Basic programming • Control structures • Objects, classes, methods & interactions • Excel Object libraries & reuse • Application development. The course and the course material are in English. French-speaking students can however ask questions and be answered in French.

### References

Maksay Gabor, Pigneur Yves, Modéliser par l'exemple, Presses polytechniques et universitaires romande, 2008, http://www.ppur.org/livres/978-2-88074-792-3.html Michelle M.H. Azeref, Ravindra K. Ahuja, and Wayne L. Winston ; Developing Spreadsheet-Based Decision Support Systems Using Excel and VBA for Excel ; Dynamic Ideas, Belmont, Massachusetts 2007

### Evaluation

#### First attempt

Exam:
Oral 0h20 minutes
Documentation:
Not allowed
Calculator:
Not allowed
Evaluation:

20min. prépa, 20min. interro (+ students have the opportunity to gain 0.5 bonus point, if they hand in 10 correct exercises)

#### Retake

Exam:
Oral 0h20 minutes
Documentation:
Not allowed
Calculator:
Not allowed
Evaluation:

20min prépa, 20min interro

[» go back]           [» courses list]

 Search in HEC App   in whole UNIL   in the Directory
Internef - CH-1015 Lausanne - Suisse  -   Tél. +41 21 692 33 00  -   Fax +41 21 692 33 05