Code
MGSE MIS 4809
Niveau
M1
Discipline
Systèmes d’information
Langue
Anglais/English
Crédits ECTS
3
Heures programmées
20
Charge totale étudiant
60
Coordonnateur(s)
Département
- Technologies, Information et Management
Equipe pédagogique
Introduction au module
Building on Excel fundamentals, this course advances into sophisticated VBA techniques to enhance productivity and develop decision support tools. Students learn to create automated solutions and manage error handling in complex scenarios. The course spans two structured modules, covering a review of essential Excel functions, Intermediate VBA programming, and Advanced VBA techniques, all grounded in business analytics applications. Through regular assignments and guided online resources hosted on the Canvas platform, students develop practical, applicable skills in spreadsheet decision support and business analytics modeling.
Finalité d'apprentissage (Bloc de compétences)
- 1. S’approprier les usages avancés et spécialisés des outils de l’intelligence digitale en s’assurant de leur impact durable et responsable,2. Produire et mobiliser des savoirs hautement spécialisés, issus d’une réflexion critique, et dans un champ d’expertise,3. Communiquer stratégiquement dans des environnements globaux et multiculturels
Objectifs d'apprentissage
- 1.1 - Auditer les usages avancés et spécialisés des outils de l'intelligence digitale, afin de les mobiliser avec pertinence, en tenant compte du contexte stratégique des organisations.
Traits de compétences
By the end of this course, students will be able to:
• Apply advanced Excel functions and VBA programming techniques to construct automated business solutions.
• Design decision support tools that integrate Excel and VBA for data management and processing.
• Build logical programming structures using conditional statements, loops, and array variables to address business data processing requirements.
• Develop reusable procedures and functions that support modular, scalable spreadsheet applications.
Contenu : structure du module et agenda
Topics covered include
Advanced Excel, a review of essential Excel functions and techniques.
Intermediate VBA, addressing variables, dynamic referencing, MsgBox, InputBox, integration of Excel and VBA functions to output values, and advanced debugging techniques.
Advanced VBA Programming, covering conditional logic (If/Then and error checking), error handling with On Error GoTo, loop structures (For/Next, Do While, Do Until), array variables for efficient data handling, and the use of procedures (Call and Function).
Contribution à l'atteinte des ODD (Objets du Développement Durable)
- SDG 4 (Quality education): By mastering advanced automation tools like VBA, students acquire specialized technical skills that enhance their professional development and employability in a data-driven economy.
- SDG 8 (Decent work and economic growth): The course focuses on improving productivity and efficiency through automation, directly contributing to higher levels of economic productivity and technological upgrading in the workplace.
- SDG 9 (Industry, innovation and infrastructure): Developing custom decision-support tools fosters innovation within organizations, enabling more resilient and data-informed digital infrastructures.
Apprentissage
Asynchrone
Méthode pédagogique
This course is offered in collaboration with Virginia Polytechnic Institute and State University (Virginia Tech), USA, and is available through both synchronous and asynchronous delivery modes. Virginia Tech provides the Canvas learning platform, which hosts course videos, content notes, and homework assignment files. All course materials, assignments, and information are available on Canvas, and students must use this platform exclusively for all submissions and interactions. Login credentials will be provided before course commencement; students should check their email and spam folder to receive them.
Additional online meetings are available for students to discuss challenges and questions with the VTECH Team. Coaching sessions are provided at the beginning of the course by the Course Coordinator at IMT BS. The course is organized into modules designed to help students understand Excel and VBA from a business perspective and demands high levels of autonomy.
Système de notation et modalités de rattrapage
The overall grade for this course is a weighted average of two components:
50% – Individual homework Excel files, submitted individually for each module assignment.
50% – Individual homework Quizzes, completed alongside each respective homework submission.
Five compulsory homework and homework quiz sets are required in total. Two sets correspond to Module 1 and three sets correspond to Module 2. All submissions must be made exclusively through the Canvas platform. Submissions via Moodle or email are not accepted. VTECH evaluates all homework assignments and quizzes, with student queries addressed through forums on Canvas.
The catch-up assessment (CF2) corresponds to the best grade obtained from the submitted homework quizzes, as evaluated by VTECH.
Règlement du module
Professor and Course Team Communication
For all queries relating to course content, students must contact the VTECH team exclusively through the Canvas platform. There will be no communication via personal email addresses. For administrative or program matters, students may contact the IMT-BS Course Coordinator through their institutional school email address (IMT-BS/TSP). It is each student's responsibility to check their institutional mailbox regularly. Meetings with the IMT-BS Course Coordinator can be arranged by appointment if necessary.
Course Activity Requirements
This course requires a minimum of 10 to 15 hours of recorded course activity over the full course duration. Students must either attend the live online lectures according to US Eastern Time or view the lecture recordings available on Canvas. Students whose recorded activity falls below this threshold are required to submit a written justification to the IMT-BS Course Coordinator.
Assignments, Quizzes, and Deadlines
Students must observe all assignment and quiz submission deadlines as published on Canvas. Late assignments will not be accepted or graded. Quizzes submitted after the stated deadline are subject to negative marking. Students are responsible for managing their own time to meet all deadlines, and no extensions will be granted on these grounds.
Online Conduct
Students are expected to maintain a respectful and professional standard of conduct across all online interactions. During any live synchronous sessions, students must keep their camera on unless otherwise instructed by the course team. Disruptive or disrespectful behavior in any course forum, live session, or communication channel is not permitted and may result in disciplinary proceedings. All course activity, including forum participation, assignment submissions, and queries, must be conducted through Canvas exclusively.
Students with Accommodation Needs
If a student has a disability that prevents them from completing the described work or requires any accommodation, they should inform the program director at IMT-BS with supporting documents as soon as possible. Students are also encouraged to discuss their needs directly with the IMT-BS Course Coordinator, who will liaise with the VTECH team as appropriate.
Honor Code
IMT-BS is committed to a policy of academic honesty. Conduct that compromises this policy may result in academic and disciplinary sanctions. Students must refrain from cheating, lying, plagiarizing, and stealing. This includes producing original work and properly crediting any person whose ideas or materials, including those sourced from the internet, are paraphrased or directly quoted. Any student who violates, or assists another student in violating, academic behavior standards will be sanctioned in accordance with IMT-BS rules.
Références obligatoires et lectures suggérées
Developing Spreadsheet-Based Decision Support Systems: Using Excel and VBA for Excel. Dynamic Ideas, 2011. 2nd Edition, S. Eksioglu, M. Seref, R. Ahuja, and W. Winston. (www.dssbooks.com)
Cumulative Review Notes are available on the course website.
Mots-clés
1. VBA Programming 2. Excel Automation 3. Decision Support Systems 4. Data Modeling 5. Business Analytics
Prérequis
To succeed in this course, students should have a strong command of Excel fundamentals, including advanced formulas (VLOOKUP, IF, INDEX/MATCH), pivot tables, and basic logical reasoning.