27220025 - Systèmes d'information : programmation de macros appliquée au contrôle et à la finance

Crédits ECTS 3
Volume horaire total 21
Volume horaire CM 21

Responsables

Objectifs

The course addresses basic programming notions in order to design and implement a small application in the domain of management control and/or finance.

TARGETED KNOWLEDGE
Thorough knowledge of Excel

TARGETED SKILLS
Being able to program macros with Excel

Contenu

1. Introduction to programming and to the programming language used in the course
1.1 declaration of variables, variable assignment and expressions
1.2 Control structures : conditional logic and loops

2. Application to the programming language VBA for Excel
2.1 The object notions and VBA Excel Objects programming
2.2 Evenemential programming
2.3 Dashboards and userforms

3. Case study to be designed and implemented using the presented concepts

Bibliographie

BOOKS USED AS REFERENCE:
Programmation et algorithmique en VBA pour Excel, A. Brygoo, Maryse Pelletier, Michèle Soria, Séverine Dubuisson

Contrôles des connaissances

Final Exam
An oral presentation of the main functionnalities implemented (1/3)

Continuing Examination
In class examination
Nature of student work and proportion weight: case study (2/3)

Informations complémentaires

PRE-REQUISITE
basic skills of the main features of a spreadsheet software
basic notions of computer programming