Checking date: 07/05/2020

Course: 2019/2020

Actuarial valuation tools
Study: Master in Actuarial and Financial Sciences (224)


Department assigned to the subject: Department of Business Administration

Type: Compulsory
ECTS Credits: 6.0 ECTS


Competences and skills that will be acquired and learning results.
Learning objectives The student will be able to program and use the main analytics and actuarial calculation languages and tools Learning outcomes a) Understanding an object-oriented programming language environment b) Master the development of actuarial calculation using functions and subroutines c) Design and end-to-end programming of actuarial calculus tools. d) Understanding the data base engine language SQL e) Understanding the basis of Python programming language as a platform to support various software tools. Learning skills a) Analysis and synthesis b) Problem solving approach c) Work team player. d) Critical reasoning e) Written and verbal communication
Description of contents: programme
I. VBA a. Programming environment b. Variables and types. Matrices and arrays. Conditional and loops. c. Functions and Subroutines. d. Design of user forms and interfaces. e. Pseudo-code, use cases and design of applications. f. Advances topics II. SQL a. Programming environment b. Main types of query. III. Intro to Python. a. Programming environment b. Examples of efficient use of Python
Learning activities and methodology
TEACHING METHODOLOGY I. THEORETICAL CONTENTS a. Classroom interactive work. b. Web based materials and handouts c. Tutorial work. d. Recommended international bibliography. e. Office hours and email interaction. II. PRACTICE a. Examples and exercises and previous exams classroom solving. b. Daily students┬┐ involvement and presentations. c. Computer work. d. Debates and bringing up different standpoints on topics. Critical thinking.
Assessment System
Basic Bibliography
  • John Walkenbach. Excel 2010. Programación con VBA. Anaya Multimedia.

The course syllabus and the academic weekly planning may change due academic events or other reasons.