Fiche détaillée d'un cours


 


Voir la fiche établissement

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 
Master1S2FrEnglish
Professeur(s) responsable(s)Y.TÜTÜNCÜ
Intervenant(s)Yazgi TÜTÜNCÜ


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

TypeNombre d'heuresRemarques
Independent work
Research4,00  
Independent study
Group Project10,00  
Estimated personal workload35,00  
Face to face
Interactive class16,00  
Charge de travail globale de l'étudiant65,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ôleDuréeNombrePondération
Final Exam
Written exam2,00140,00
Continuous assessment
Participation4,00420,00
Others
Group Project34,00140,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
 
 
Vidéo : Un campus à vivre
Notre chaîne Youtube