Aller à : contenu haut bas recherche
 
 
EN     FR
Vous êtes ici:   UNIL > HEC Inst. > HEC App. > SYLLABUS
 
 

Computational Tools for Actuaries

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

[warning] This course syllabus is currently edited by the professor in charge. Please come back in a few days. --- For your information only, here is the old syllabus :

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


Internef - CH-1015 Lausanne - Suisse  -   Tél. +41 21 692 33 00  -   Fax +41 21 692 33 05
Swiss University