Checking date: 09/05/2024


Course: 2024/2025

Actuarial valuation tools
(14241)
Master in Actuarial and Financial Science (Plan: 168 - Estudio: 224)
EPE


Coordinating teacher: USABEL RODRIGO, MIGUEL ARTURO

Department assigned to the subject: Business Administration Department

Type: Compulsory
ECTS Credits: 6.0 ECTS

Course:
Semester:




Requirements (Subjects that are assumed to be known)
Algebra Calculus
Objectives
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 may change due academic events or other reasons.