Educational guide
IDENTIFYING DATA							2020_21
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	MENDAÑA CUERVO , MARÍA CRISTINA				E-mail	mcmenc@unileon.es elopg@unileon.es
Lecturers	LÓPEZ GONZÁLEZ , ENRIQUE 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 FANJUL SUAREZ , JOSE LUIS Secretario DIREC.Y ECONOMIA DE LA EMPRESA ROBLES GONZALEZ , FRANCISCO JAVIER Vocal DIREC.Y ECONOMIA DE LA EMPRESA TASCON FERNANDEZ , MARIA TERESA

Competencies

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

Learning aims

	Competences
	A17659	B5467 B5468 B5469 B5470	C4

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
Practicals using information and communication technologies (ICTs) in computer rooms		30% de la nota global.
Mixed tests		55% de la nota global.
Other comments and second call

ADDENDUM

Contingency plan due to COVID-19 emergency conditions that prevents from presence based teaching

COVID-19 Teaching Guide Addendum Access Link

Sources of information

Access to Recommended Bibliography in the Catalog ULE

Basic	Walkenbach, J. , Excel 2010: programación con VBA, Anaya Multimedia, Madrid Moreno Bonilla, F., & Cano Rodríguez, M., Excel 2010: modelos económicos y financieros, Anaya Multimedia, Madrid Sengupta, C. , Financial modeling using Excel and VBA, Willey & Sons., Hoboken (New Jersey) 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