FR | EN
Retour
Computer Sciences : Excel/VBA

ECTS : 2

Langue du cours : Français

Volume horaire : 18

Description du contenu de l'enseignement :

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

Compétences à acquérir :

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. 

Pré-requis obligatoires

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

Mode de contrôle des connaissances :

Midterm Examination : 50%Final Examination : 50%

Coefficient : 0.75

Bibliographie, lectures recommandées :

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/

Document susceptible de mise à jour - 04/11/2026
Université Paris Dauphine - PSL - Place du Maréchal de Lattre de Tassigny - 75775 PARIS Cedex 16