Universidad de Jaén

Menú local

Syllabus 2017-18 - 11312024 - Computer Systems Applied to Finance Analysis (Sistemas informáticos aplicados al análisis financiero)

Caption
  • Level 1: Tutorial support sessions, materials and exams in this language
  • Level 2: Tutorial support sessions, materials, exams and seminars in this language
  • Level 3: Tutorial support sessions, materials, exams, seminars and regular lectures in this language
DEGREE: Grado en Finanzas y contabilidad
FACULTY: FACULTY OF LAW AND SOCIAL SCIENCES
ACADEMIC YEAR: 2017-18
COURSE: Computer Systems Applied to Finance Analysis
SYLLABUS
1. COURSE BASIC INFORMATION
NAME: Computer Systems Applied to Finance Analysis
CODE: 11312024 ACADEMIC YEAR: 2017-18
LANGUAGE: English LEVEL: 1
ECTS CREDITS: 6.0 YEAR: 3 SEMESTER: PC
2. LECTURER BASIC INFORMATION
NAME: SÁNCHEZ SOLANA, ANTONIO MIGUEL
DEPARTMENT: U118 - INFORMÁTICA
FIELD OF STUDY: 570 - LENGUAJES Y SISTEMAS INFORMÁTICOS
OFFICE NO.: A3 - A3-128 E-MAIL: asanchez@ujaen.es P: 953-212423
WEBSITE: http://blogs.ujaen.es/asanchez/
ORCID: https://orcid.org/0000-0002-5954-3160
LANGUAGE: English LEVEL: 1
3. CONTENT DESCRIPTION

Theoretical contents in depth:

  • Module 1: Introduction.
    • Fundamentals of Information Technologies.
    • Information Systems.
    • Business Information Systems.
    • Strategies and Information Systems.
    • Information Systems and Organizational Structure: Virtual Enterprise.
    • Digital dimension in Enterprises.
  • Module 2: Management Information Systems.
    • Databases.
    • Data Warehouse.
    • Data Mart.
  • Module 3: Exploiting management systems. Applications to financial analysis
    • Business Intelligence.
    • Queries and reports.
    • OLAP (On-line Analytic Processing).
    • Data mining.
    • Decision Support Systems.
    • Data analysis: Data Science for Business
  • Module 4: Financial Management Systems in Enterprises
    • Back-office.
    • Front-office.
    • Financial management software.

Practical contents in depth:

  • Block 1: Management Systems and Tools to Support Information Analysis.
    • How to find information on the Internet
    • Database Management Systems
    • Access to the on-line database for financial analysis: SABI
  • Block 2: Analysis, Exploitation and Problem Solving Tools for Business Management.
    • Balance sheets and charts.
    • Functions for complex calculations.
    • The use of scenarios in a specific problem.
    • Simulations.
    • Optimizations.
    • Specific functions for financial analysis.
    • Databases and dynamic tables.
    • Development of social security financial statements.
    • Financial Management Software.
    • Queries and reports.
    • OLAP (On-Line Analytic Processing)
    • Big Data Analysis.

4. COURSE DESCRIPTION AND TEACHING METHODOLOGY

1. Lecture classes:

Description: presentation in the class of concepts, fundamentals, examples, etc. by using lectures and audiovisual didactic resources. To be evaluated of theoretical concepts, students will take a writing exam.

Purpose:  make easier the acquisition of knowledge and encourage the          analytical reflection about the relationships between concepts.

2.     Practical classes:

Description: students will perform practical problems to learn how to use the theoretical concepts.

Purpose: the development of practical skills.

3.     Seminars:

Description:  some activities and debates about a topic of interest will be developed to deal with some concepts in depth, improve analytical reflection and share of knowledge.

Purpose: the acquisition of knowledge and the development of practical skills

4.     Individual Homework activities:

Description:

1)     Individual activities (guided or not) proposed by the teacher to deal with some topics and skills in depth.

2)     Individual study

3)     Evaluating activities (reports, self-assessment tests, etc).

Purpose: Improve the student individual learning.

 

5.     Group homework activities:

Description: Activities (guided or not) proposed by the teacher to deal with some topics and skills in depth.

Purpose: improve the exchange of ideas among students, the identification and analysis of certain topics, and the transfer of knowledge and its critical analysis.

6. Tutorial hours:

Description: hours destined to organize the process of teaching by means of direct interaction between students and teacher.

Purpose:

1)     To guide the individual and group learning.

2)     The deal with different aspect of the subject in depth.

3)     To guide the students comprehensive education.

Students with special educational needs should contact the Student Attention Service (Servicio de Atención y Ayudas al Estudiante) in order to receive the appropriate academic support

5. ASSESSMENT METHODOLOGY

The final mark is divided by:

  • Attendance and involvement: 5% of the final mark. This mark is obtained when students are actively engaged in classes, debates and group work.
  • Theoretical concepts: 60% of the final mark. This mark is calculated taking a written test.
  • Practical skills: 30% of the final mark. This mark is obtained from teachers observations, practical exercises defense and/or practical exam.
  • Other activities: 5% of the final mark.  This mark is calculated from individual work.

Continuous evaluation: student participation in classroom and seminars. Besides, students should carry out, explain and debate suggested practical cases (both in practical and theoretical classes).

Ordinary evaluation: writing examination of theoretical contents and reports of the practical classes that should be defended by the students, otherwise, they should pass a practical exam.

Students who attend practical classes may not have to take the practical exam. In this case, the mark for the practical part will be obtained by means of continuous evaluation based on students reports about the practical problems and on the defense of these reports.

If student does not pass the practical part by means of continuous evaluation or does not attend the 80% of the practical classes, they will take a practical exam the same day as the ordinary exam.

If students want to present a voluntary exercise, it should be presented in the date indicated by the teacher and always before the end of the term.

The marks obtained in the term related to practical part, student participation and exercises presented are kept for the academic year.

To pass the subject, students must obtain a final mark of 5 over 10 and pass both the theoretical part and the practical part (with a minimum mark of 5 over 10 in each one of them).

6. BOOKLIST
MAIN BOOKLIST:
  • Fundamentals of information systems. Edition: 5th ed.. Author: Stair, Ralph M.. Publisher: Boston : Course Technology, 2010  (Library)
  • Peter Norton's introduction to computers. Edition: -. Author: Peter, 1943-. Publisher: New York]: McGraw-Tecnology EducationHill, 6006  (Library)
  • Microsoft Office 2010 plain & simple [Recurso electrónico]. Edition: -. Author: Murray, Katherine, 1961-. Publisher: Redmond, Wash. : Microsoft Press, c2010.  (Library)
  • Fundamentals of information systems security [Recurso electrónico]. Edition: -. Author: Kim, David. Publisher: Sudbury, Mass. : Jones & Bartlett Learning, c2012.  (Library)
  • The Microsoft Office specialist study guide [Recurso electrónico]. Edition: 2007 Microsoft Office system ed. Author: Cox, Joyce, 1946-. Publisher: Redmond, Wash. : Microsoft Press, c2012  (Library)
  • Microsoft Office home and student edition 2013 all-in-one for dummies [Recurso electrónico] . Edition: -. Author: Weverka, Peter. Publisher: Hoboken : Wiley, c2013  (Library)
  • Introducing geographic information systems with ArcGIS [Recurso electrónico] a workbook approach to. Edition: 3rd ed. Author: Kennedy, Michael. Publisher: Hoboken, N.J. : Wiley, c2013  (Library)
ADDITIONAL BOOKLIST:
  • Microsoft Office 2010 in depth [Recurso electrónico]. Edition: -. Author: Habraken, Joseph W., 1954-. Publisher: Indianapolis, Ind. : Que, c2011  (Library)
  • Essentials of information systems for managers [Recurso electrónico]. Edition: -. Author: Piccoli, Gabriele. Publisher: Hoboken, NJ : Wiley, 2012  (Library)