Checking date: 09/07/2020


Course: 2020/2021

Development of IT applications for business
(13782)
Bachelor in Finance and Accounting (Study Plan 2018) (Plan: 399 - Estudio: 201)


Coordinating teacher: MEDINA DOMINGUEZ, FUENSANTA

Department assigned to the subject: Computer Science and Engineering Department

Type: Electives
ECTS Credits: 6.0 ECTS

Course:
Semester:




Requirements (Subjects that are assumed to be known)
Information Skills IT Management
Objective The objective of this course is to teach the student, in a practical way, the data and programming structures for the development of macros and applications developed with Visual Basic for Applicatons (VBA), a programming language that is de facto incorporated into the Microsoft Office suite to automate and extend the capabilities of the programs that make up this suite. Competencies 1. Know the proprietary software and free software alternatives that exist in the market to perform accounting and financial data analysis. 2. Learn to analyze macros and applications developed with Visual Basic for Applications. 3. Learn to design macros and applications developed with Visual Basic for Applications. 4. Learn to build macros and applications developed with Visual Basic for Applications. 5. Learn to use macros and applications developed with Visual Basic for Applications. 6. Learn programming syntax and paradigm of the R language Competences: 1. Identify alternatives of proprietary and free software on the market for analysis of accounting and financial data. 2. Learn how to use advanced features that allow to carry out accounting or financial analysis using Microsoft Excel. 3. Learn to create and use PivotTables in Microsoft Excel for data analysis. 4. Learn to design, build and use macros and applications developed with Visual Basic for Applications.
Description of contents: programme
1. Analysis and application design techniques. 2. Macro construction, recording and automatic generation with Microsoft Excel. 3. Basic Concepts of Programming. 4. Development and debugging environment of Visual Basic for Applications (VBA) 5. Data structure 6. Programming structures 7. Creation of own functions. 8. Creation of forms. 9. Creating menus. 10. Introduction to Language R.
Learning activities and methodology
The subject will be taught in practical classes through which students will learn the data and programming structures for the development of macros and applications developed with Visual Basic for Applicatons (VBA). The 6 ECTS credits of this course are distributed with the following workload for the student: 1. Lectures: 1 ECTS 2. Practicals: 2 ECTS 3. Continuous assessment: 1 ECTS 4. Individual student work 2 ECTS
Assessment System
  • % end-of-term-examination 0
  • % of continuous assessment (assigments, laboratory, practicals...) 100

Basic Bibliography
  • John Walkenbach. Excel VBA Programming for dummies. John Wiley & Sons. 2015
  • Michael Alexander. Excel Macros for dummies. John Wiley & sons. 2015
  • Walkenbach, John. Excel 2010 Bible. Wiley. 2010

The course syllabus may change due academic events or other reasons.