Code
MGSE MIS 4809
Level
M1
Field
Systèmes d’information
Language
Anglais/English
ECTS Credits
3
Class hours
20
Total student load
60
Program Manager(s)
Department
- Technologies, Information et Management
Educational team
Introduction to the module
Building on fundamental Excel skills, this course explores advanced VBA (Visual Basic for Applications) techniques to significantly enhance productivity and develop sophisticated decision support tools. Students will learn to create automated solutions, streamline data-driven processes, and implement robust error-handling mechanisms for complex business scenarios. The module aims to equip students with the technical proficiency required to transform raw data into actionable business models.
Learning objectives/Intended learning outcomes
- 1.1 - Audit advanced and specialised uses of digital intelligence tools in order to deploy them appropriately, taking into account the strategic context of organisations.
- 2.1 - Develop a critical awareness of highly specialised knowledge, some of which is at the forefront of knowledge, with a view to formulating innovative contributions to complex issues, in line with the strategic plan of organisations and with scientific
- 3.2 - Communicate effectively and appropriately for the purposes of training, knowledge transfer, skills development or innovation, in English and at least one other language, in a global and multicultural context.
Content : structure and schedule
Building on Excel fundamentals, this course delves into advanced VBA techniques to enhance productivity and develop decision support tools. Students will learn to create automated solutions and perform error-handling in complex scenarios.
Topics Covered:
Advanced Excel: A review of essential Excel functions and techniques.
Intermediate VBA:
Variables, dynamic referencing, MsgBox, InputBox.
Integrating Excel and VBA functions to output values.
Advanced debugging techniques.
Advanced VBA Programming:
Conditional logic (If/Then, error checking).
Error handling with On Error GoTo.
Working with loops (For/Next, Do While, Do Until).
Using array variables for efficient data handling.
Creating and using procedures (Call and Function).
Sustainable Development Goals
- 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.
Learning delivery
Asynchrone
Pedagogical methods
Virginia Tech provides its own learning platform (Canvas), which offers course videos, notes on the content, and files for homework assignments. Additional online meetings are available for students to discuss challenges and questions with Professor Seref and his assistants. Coaching sessions are offered at the beginning by Professor Delaunay at IMT BS. This course demands high autonomy skills
Evaluation and grading system and catch up exams
Assignments and Quizzes: Homework assignments and quizzes are spaced regularly to assess student understanding of each module.
Optional Final Exam: An optional final exam is offered online with a flexible two-hour window for completion.
Key Deadlines: Homeworks and quizzes are due periodically, with key assignments requiring individual submissions.
100% Assessment based on 05 Assignments.
Module Policies
Professor-Student Communication
● The professor will contact the students through their school email address (IMT-BS/TSP) and the Moodle portal. There will be no communication via personal email addresses. It is the student's responsibility to check their IMT-BS/TSP mailbox regularly.
● Students can communicate with the professor through the institutional email address. If necessary, it is possible to meet with the professor in his office during office hours or by appointment.
Students with accommodation needs
If a student has a disability that will prevent from completing the described work or require any accommodation, he may inform the program director (with supporting documents) as soon as possible. Also, students are encouraged to discuss it with the professor.
Class behavior
● Out of courtesy for the professor and classmates, all mobile phones, electronic games or other devices that generate sound should be turned off during class.
● Students should avoid disruptive and disrespectful behavior such as: arriving late, leaving early, and careless behavior (e.g., sleeping, reading non-course material, using vulgar language, over-speaking, eating, drinking, etc.). A warning may be given on the first infraction of these rules. Repeated violators will be penalized and may face expulsion from the class and/or other disciplinary proceedings.
● The tolerated delay is 5 minutes. Attendance will be taken via a QR code provided by the teacher at the start of each course.
● Students should arrive on time for exams and other assessments. No one will be allowed to enter the classroom once the first person has finished the exam and left the room. There is absolutely no exception to this rule. No student can continue to take an exam once the time is up. No student/s may leave the room during an examination unless they have finished and handed over all the documents.
● In the case of remote learning, the student/s must keep their camera on unless instructed otherwise by the professor.
Honor code
IMT-BS is committed to a policy of honesty in the academic community. Conduct that compromises this policy may result in academic and/or disciplinary sanctions. Students must refrain from cheating, lying, plagiarizing, and stealing. This includes completing your own original work and giving credit to any other person whose ideas and printed materials (including those from the Internet) are paraphrased or quoted directly. Any student who violates or assists another student in violating academic behavior standards will be penalized in accordance with IMT-BS rules.
Textbook Required and Suggested Readings
Recommended DSS Book: 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.
Keywords
1. VBA Programming 2. Excel Automation 3. Decision Support Systems 4. Data Modeling 5. Business Analytics
Prerequisites
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.