Checking date: 05/07/2021

Course: 2021/2022

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


Requirements (Subjects that are assumed to be known)
Algebra Calculus
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
Skills and learning outcomes
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
  • % end-of-term-examination 90
  • % of continuous assessment (assigments, laboratory, practicals...) 10
Calendar of Continuous assessment
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.