06350036 - Management information systems

Credit hour 1
Total number of hours 16
Number of hours for tutorials 16

Goals

This is an introductory class to VBA. It relies mainly on examples. It aims to introduce a useful and widely used programming language.
Students are supposed to become familiar with Excel/VBA and be able to use it in a professional context. In addition to learning specific elements of the language, the students will also gain knowledge of general programming principles and some fundamental algorithmic structures.
Familiarity with the programming language VBA is an essential prerequisite for working in many industry sectors today. The techniques learned in this class can form the foundation for the implementation of models encountered in the other classes of the programme.

TARGETED KNOWLEDGE
  • Use theoretical knowledge in the daily business operations as a manager
  • Develop and deploy an action plan for/of a specific area (marketing, finance…) in order to succeed in an international environment
  • Work and communicate with a multicultural team
  • Assess and adapt the performance of the company/the organization/a tool in an international environment

TARGETED SKILLS
  • How to use VBA in practive
  • How to implement simple models
  • How to automate reports

Content

Part I : Introduction to coding with VBA
I.1. Why you should learn who to code
I.2. Using the Macro Recorder

Part II : Into coding
II.1. The buiding blocks of coding
II.2. The coding toolbox

Part III : Deep into coding
III.1. Automating reports
III.2. Getting data from the web
III.3. Workbook events

Part IV : Bonus material
IV.1. Introduction to code snippets managers
IV.2. Using text editor
IV.3. Introduction to regular expressions

Bibliography

BOOKS USED AS REFERENCE:
  • SHERPHERD, R. (2007). Excel VBA Macro Programming. 2nd ed. McGraw-Hill.
  • WEBB J. & SAUNDERS, S. (2006) Programming Excel with VBA & .NET. O'Reilly.
  • WALKENBACH, J. (2013). Excel 2013 power programming with VBA. John Wiley & Sons.

ADDITIONAL READINGS:
  • JACKSON, M. & STAUNTON, M.(2006). Advanced modelling in finance using Excel and VBA. John Wiley & Sons.

EMBLEMATIC BOOKS OR RESEARCH PAPERS REGARDING THE SUBJECT OF THE COURSE
  • JACKSON, M. & STAUNTON, M.(2006). Advanced modelling in finance using Excel and VBA. John Wiley & Sons.
  • SHERPHERD, R. (2007). Excel VBA Macro Programming. 2nd ed. McGraw-Hill.
  • WEBB J. & SAUNDERS, S. (2006) Programming Excel with VBA & .NET. O'Reilly.
  • WALKENBACH, J. (2013). Excel 2013 power programming with VBA. John Wiley & Sons.

Tests

Final Exam
MCQ exam

Additional Information

TEACHING METHODS
Students will directly practice in order to gain technical knowledge

TECHNOLOGY ENHANCED LEARNING:
Coding on VBA

PRE-REQUISITE
No pre-requisite
Basic knowledge and practice of Microsoft Excel is a plus.

Last updated: March 28, 2017