BUSINESS PERFORMANCE MONITORING USING MICROSOFT EXCEL

Code Cours
2324-IÉSEG-M1S2-OPS-MA-FI66UE
Langue d'enseignement
English
Matières
OPERATIONS MANAGEMENT
Ce cours apparaît dans les formation(s) suivante(s)
Responsable(s)
Y.TÜTÜNCÜ
Intervenant(s)
Yazgi TÜTÜNCÜ
Niveau
Master
Année de formation
Période

Présentation

Prérequis
It is essential that students have a background on Research Methodology.
Objectifs
At the end of the course, the student should be able to :

- prepare essential materials for Business Performance analysis using Excel.(AOL-3A) (AOL-1C).
- improve some skills and tools for analyzing data appear in various fields of management.(AOL-5B)
- realise the concept of decision making in an uncertain environment.(AOL-6B)
- understand the importance of describing data and summarizing descriptive relationships.
- define the descriptive Measures of central tendency and variability in data.(AOL-3A)
- use the general principles for analyzing data such as sampling, unbiasedness, estimation with confidence intervals and Tests of Hypothesis using MS Excel.(AOL-3A)
Présentation
1. Concept of decision making in an uncertain business environment. Importance of data-driven business performance analysis.
2. Business Analytics and Data Visualization using Excel.
3 .General principles for analyzing data: Pivot tables and hypothesis testing using Excel.
4. General principles for analyzing data: Estimation with confidence intervals and Tests of Hypothesis using Excel..
5. Simple Linear Regression and Multiple Regression and model building using Excel.
6. Categorical Data analysis using Excel and interpretting results.

Modalités

Organisation
Type Amount of time Comment
Présentiel
Cours interactif 16,00
Autoformation
Recherche 4,00
Travail personnel
Group Project 10,00
Charge de travail personnel indicative 35,00
Overall student workload 65,00
Évaluation
Students will learn how to use Excel in their dissertations and daily basis assesment will be done accordingly.
They will prepare a team project and they will be assess by a final exam.
Control type Duration Amount Weighting
Contrôle continu
Participation 4,00 4 20,00
Examen (final)
Examen écrit 2,00 1 40,00
Autres
Projet Collectif 34,00 1 40,00
TOTAL 100,00

Ressources

Bibliographie
“Statistics for Business and Economics” by P. Newbold, W.L. Carlson, B. Thorne, Prentice Hal -

Lecture notes and MS excel user guide

Ressources Internet