Computer Sciences : Excel/VBA
Enseignant responsable :
- MD SHAIKH
Description du contenu de l'enseignement :
1. Introduction: algorithms and programs 2. Values, types and variables 3. Assignment and expression 4. Reading instruction 5. Program structure:¿ Decision making 6. Program structure: Loops 7. Functions 8. Consolidation week 9. Writing own functions 10. String and String methods 11. List: Creation, access and traversal 12. List: Operators and methods 13. Character strings and lists in function 14. Files
Pré-requis obligatoires :
There is no prerequisite module. Basic knowledge of mathematical concepts is expected.
Coefficient : 0.75Compétence à 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.
Mode de contrôle des connaissances :
Midterm Examination : 50% Final Examination : 50%
Bibliographie, lectures recommandées
Core Sources
- Excel 2019 Power Programming with VBA by Michael Alexander (Author), Dick Kusleika (Author)
- support.office.com
Supplementary and Secondary Sources