Educational guide

IDENTIFYING DATA

2017_18

Subject

APPLIED PROGRAMMING TO ACTUARIAL AND FINANCIAL PROBLEMS

Code

00515015

Study programme

MASTER UNIV.CC.ACTUARIALES Y FINANC. (MUCAF)

Descriptors

Credit.

Type

Year

Period

Compulsory

Second

First

Language

Prerequisites

Department

DIREC.Y ECONOMIA DE LA EMPRESA

Coordinador

CAÑO ALEGRE , CARLOS

E-mail

ccana@unileon.es
elopg@unileon.es
mcmenc@unileon.es

Lecturers

CAÑO ALEGRE , CARLOS

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
	A16953
Type B	Code	Competences Transversal
	B5191
	B5192
	B5193
	B5194
Type C	Code	Competences Nuclear
	C4

Learning aims

	Competences
	A16953	B5191 B5192 B5193 B5194	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

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