FORMATIONS |
Fiche détaillée d'un cours
BUSINESS PERFORMANCE MONITORING USING MICROSOFT EXCEL | |||
2018-2019 | FrIESEG School of Management
(
IÉSEG
)
| ||
Code Cours : | 1819-IÉSEG-M1S2-OPS-MA-FI66UE | OPERATIONS MANAGEMENT |
Niveau | Année de formation | Période | Langue d'enseignement |
---|---|---|---|
Master | 1 | S2 | FrEnglish |
Professeur(s) responsable(s) | Y.TÜTÜNCÜ |
---|---|
Intervenant(s) | Yazgi TÜTÜNCÜ |
- Ce cours apparaît dans les formations suivantes :
- IÉSEG > IESEG Degree - Programme Grande École > Semester 2 > 2,00 ECTS
Pré requis
It is essential that students have a background on Research Methodology.
Objectifs du cours
At the end of the course, the student should be able to :
- prepare essential materials for preparing the final dissertation thesis.
- improve some skills and tools for analyzing data appear in various fields of management.
- realise the concept of decision making in an uncertain environment.
- understand the importance of describing data and summarizing descriptive relationships.
- define the descriptive Measures of central tendency and variability in data.
- use the general principles for analyzing data such as sampling, unbiasedness, estimation with confidence intervals and Tests of Hypothesis using MS Excel.
Contenu du cours
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 d'enseignement
Organisation du cours
Type | Nombre d'heures | Remarques | |
---|---|---|---|
Independent work | |||
Research | 4,00 | ||
Independent study | |||
Group Project | 10,00 | ||
Estimated personal workload | 35,00 | ||
Face to face | |||
Interactive class | 16,00 | ||
Charge de travail globale de l'étudiant | 65,00 |
Méthodes pédagogiques
- Case study
- Interactive class
- Project work
- Research
- Tutorial
Évaluation
Students will learn how to use Excel in their dissertations and daily basis assesment will be done accordingly.
They will prepare a project and they will be assess by a final exam.
Type de Contrôle | Durée | Nombre | Pondération |
---|---|---|---|
Final Exam | |||
Written exam | 2,00 | 1 | 40,00 |
Continuous assessment | |||
Participation | 4,00 | 4 | 20,00 |
Others | |||
Group Project | 34,00 | 1 | 40,00 |
TOTAL | 100,00 |
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
* Informations non contractuelles et pouvant être soumises à modification