FR | EN
Back
Computer Sciences : Excel/VBA

ECTS : 2

Language of instruction : French

Teaching hours : 18

Course content:

1. Introduction: algorithms and programs2. Values, types and variables3. Assignment and expression 4. Reading instruction5. Program structure:¿ Decision making6. Program structure: Loops7. Functions8. Consolidation week9. Writing own functions10. String and String methods11. List: Creation, access and traversal12. List: Operators and methods13. Character strings and lists in function14. Files

Skills to be acquired:

Introduce computational logic and programming syntax Explore various ways of writing a program solution for a given problem statement Develop the essential technological background for students' work life. 

Mandatory prerequisites

There is no prerequisite module. Basic knowledge of mathematical concepts is expected.

Assessment:

Midterm Examination : 50%Final Examination : 50%

Weighting : 0.75

Bibliography, recommended reading:

Core Sources

  1. Excel 2019 Power Programming with VBA by Michael Alexander (Author), Dick Kusleika (Author)
  2. https://support.office.com/
Supplementary and Secondary Sources 
  1. https://www.excel-easy.com/vba.html
  2. https://www.homeandlearn.org/

This document may be updated - 04/11/2026
Université Paris Dauphine - PSL - Place du Maréchal de Lattre de Tassigny - 75775 PARIS Cedex 16