Checking date: 10/05/2018


Course: 2018/2019

Development of IT applications for business
(13782)
Study: Bachelor in Finance and Accounting (201)


Coordinating teacher: MEDINA DOMINGUEZ, FUENSANTA

Department assigned to the subject: Department of Computer Science and Engineering

Type: Electives
ECTS Credits: 6.0 ECTS

Course:
Semester:




Students are expected to have completed
Information Skills IT Management
Competences and skills that will be acquired and learning results. Further information on this link
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 40
  • % of continuous assessment (assigments, laboratory, practicals...) 60
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 and the academic weekly planning may change due academic events or other reasons.