Aller à : contenu haut bas recherche

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

## Computational Tools for Actuaries

• Enseignant(s):
• Titre en français: Outils informatiques de calcul pour les Actuaires
• Cours donné en: anglais
• Crédits ECTS: 6 crédits
• Horaire: Semestre d'automne 2019-2020, 2.0h. de cours + 2.0h. d'exercices (moyenne hebdomadaire)
•  séances
• Formation concernée: Maîtrise universitaire ès Sciences en sciences actuarielles

### Objectifs

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.

### Contenus

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.

### Références

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

#### 1ère tentative

Examen:
Oral 0h20 minutes
Documentation:
Non autorisée
Calculatrice:
Non autorisée
Evaluation:

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

#### Rattrapage

Examen:
Oral 0h20 minutes
Documentation:
Non autorisée
Calculatrice:
Non autorisée
Evaluation:

20min prépa, 20min interro

[» page précédente]           [» liste des cours]

 Recherche dans HEC App.   dans tout l'UNIL   dans l'Annuaire
Internef - CH-1015 Lausanne - Suisse  -   Tél. +41 21 692 33 00  -   Fax +41 21 692 33 05