Excel pour les managers

Catalog of Institut Mines-Télécom Business School courses

Code

MUSF INF 1203

Level

L1

Field

Informatique

Language

Français/French

ECTS Credits

2

Class hours

4

Total student load

8

Program Manager(s)

Department

  • Technologies, Information et Management

Educational team

Introduction to the module

Le but de ce cours est d'aider les apprenants à comprendre ce qu'est un Système d'Information et à maîtriser l'outil Bureautique EXCEL. Ce cours participe activement à la compréhension et l'analyse des systèmes d'information au sein des organisations. Il permet de maitriser l'utilisation d'EXCEL en entreprises. Au terme de ce cours, les apprenants seront en mesure de :
- comprendre la notion de Systèmes d'Information
- gérer des problèmes d'entreprise avec l'outil EXCEL.
A l’issue de cet enseignement, les apprenants devront être capables de :
• modéliser, avec l’outil Excel, des problèmes décisionnels simples intervenant dans des domaines économiques variés (par exemple dans le domaine de la finance, du Marketing, de la logistique, des statistiques…)
• utiliser l’outil Excel (apprentissage des fonctions de avancée..) pour réaliser des simulations et aider à la prise de décision.

Learning objectives

  • 1.1 - Organiser les outils de l'intelligence digitale afin d'en assurer une utilisation pertinente, en tenant compte de la spécificité des contextes à traiter.
  • 1.2 - Mobiliser les outils de l'intelligence digitale pour mettre en œuvre les transformations sociétale, numérique, énergétique et/ou environnementale des organisations, en garantissant leur impact durable et responsable.

Course Learning objectives

Produire des tableaux via l'outil EXCEL pour être opérationnel en entreprise

Content : structure and schedule

4h pendant le semestre 1

Sustainable Development Goals

* ODD 4 (Éducation de qualité) : En dotant les étudiants de compétences techniques avancées en analyse de données, ce cours favorise une éducation de qualité alignée sur les exigences du marché du travail numérique.
* ODD 8 (Travail décent et croissance économique) : L'utilisation d'Excel pour modéliser des problèmes complexes permet d'améliorer l'efficacité organisationnelle et la prise de décision, soutenant ainsi la productivité et la croissance économique.

Number of SDG's addressed among the 17

1

Learning delivery

synchrone

Pedagogical methods

Différentes approches pédagogiques sont utilisées : Travaux pratiques, travaux individuels, évaluation par les pairs, études de cas.

Evaluation and grading system and catch up exams

The evaluation is made up of an exercise in the last session (summary of the acquired notions) on computer (Excel) and exercises to be handed in between each session. on the computer (Excel) and exercises to be handed in between each session.

Module Policies

Professor-Student Communication
● The professor will contact the students through their school email address (IMT-BS/TSP) and the Moodle portal. No communication via personal email addresses will take place. It is the student responsibility to regularly check their IMT-BS/TSP mailbox.
● Students can communicate with the professor by emailing him/her to his institutional address. If necessary, it is possible to meet 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 kind of 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, careless behavior (e.g. sleeping, reading a 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 declared on Moodle during these 5 minutes via a QR code provided by the teacher at each course start.
● Student 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 may leave the room during an examination unless he / she has finished and handed over all the documents.
● In the case of remote learning, the student must keep his 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 helps another student violate academic behavior standards will be penalized according to IMT-BS rules.

Textbook Required and Suggested Readings

- Polycopié donné en cours sur EXCEL et son mode d'emploi (fonctions, tableurs, graphiques, mise en forme...)

Keywords

Systéme d'information, Excel, Simulation et fonctions avancées

Prerequisites

Aucun pré-requis