Educational guide
IDENTIFYING DATA 2023_24
Subject APPLIED PROGRAMMING TO ACTUARIAL AND FINANCIAL PROBLEMS Code 01739015
Study programme
1739 - MASTER UNIVERSITARIO CIENCIAS ACTUARIALES Y FINANCIERAS (MUCAF)
Descriptors Credit. Type Year Period
6 Compulsory Second First
Language
Castellano
Prerequisites
Department DIREC.Y ECONOMIA DE LA EMPRESA
Coordinador
CAÑO ALEGRE , CARLOS
E-mail ccana@unileon.es
mcmenc@unileon.es
Lecturers
CAÑO ALEGRE , CARLOS
MENDAÑA CUERVO , MARÍA CRISTINA
Web http://sicodinet.unileon.es
General description
Tribunales de Revisión
Tribunal titular
Cargo Departamento Profesor
Presidente DIREC.Y ECONOMIA DE LA EMPRESA GONZALEZ VELASCO , MARIA DEL CARMEN
Secretario DIREC.Y ECONOMIA DE LA EMPRESA AMOR TAPIA , BORJA
Vocal DIREC.Y ECONOMIA DE LA EMPRESA SIERRA FERNANDEZ , MARIA DEL PILAR
Tribunal suplente
Cargo Departamento Profesor
Presidente DIREC.Y ECONOMIA DE LA EMPRESA TASCON FERNANDEZ , MARIA TERESA
Secretario DIREC.Y ECONOMIA DE LA EMPRESA ROBLES GONZALEZ , FRANCISCO JAVIER
Vocal FEITO RUIZ , ISABEL

Competencies
Type A Code Competences Specific
  A17659
Type B Code Competences Transversal
  B5467
  B5468
  B5469
  B5470
Type C Code Competences Nuclear

Learning aims
Competences
A17659
B5467
B5468
B5469
B5470

Contents
Topic Sub-topic

Planning
Methodologies  ::  Tests
  Class hours Hours outside the classroom Total hours
PBL (Problem Based Learning) 10 5 15
 
Assignments 0 20 20
Personal tuition 6 0 6
Practicals using information and communication technologies (ICTs) in computer rooms 19 40 59
 
Lecture 15 20 35
 
Mixed tests 5 5 10
Practical tests 5 0 5
 
(*)The information in the planning table is for guidance only and does not take into account the heterogeneity of the students.

Methodologies
Methodologies   ::  
  Description
PBL (Problem Based Learning)
Assignments
Personal tuition
Practicals using information and communication technologies (ICTs) in computer rooms
Lecture

Personalized attention
 
Personal tuition
Description

Assessment
  Description Qualification
Assignments 75%
Practicals using information and communication technologies (ICTs) in computer rooms 10%
Mixed tests 10%
 
Other comments and second call

Sources of information
Access to Recommended Bibliography in the Catalog ULE

Basic Chazallet, S., Los Fundamentos del Lenguaje, ENI,
Sengupta, C. , Financial modeling using Excel and VBA, Willey & Sons, Hoboken (New Jersey)
Cuevas, A., Python 3: Curso Práctico, RA-MA,
Martelli, A., Ravenscroft, A., Ascher, D., Python Cookbook, O'Reilly Media,
Duigou, C., & Laugié, H. , VBA Excel 2013: Cree aplicaciones profesionales. Ejercicios y correcciones, ENI, Barcelona
Amelot, M., VBA Excel 2013: programación en Excel, macros y lenguaje VBA, ENI, Barcelona

Complementary


Recommendations


Subjects that it is recommended to have taken before
PRINCIPLES OF FINANCIAL OPERATIONS ANALYSIS / 01739023
MATHEMATICS / 01739025
MATHEMATICAL STATISTICS / 01739028