Project Business Analytics 2


Course Objective

After completion of this course, the student can
1. use Excel and Crystal Ball to perform Monte Carlo simulations;
2. build a simulation model in Excel and Crystal Ball for a practical
problem in risk management, using provided data as input;
3. analyze and assess risks and give a recommendation on the basis of
this simulation model;
4. present his/her approach and results both in a written report and in
an oral presentation.

Course Content

You will work in teams to solve a simplified business case about risk
management using a simulation model in Excel and Crystal Ball. You will
use knowledge obtained in other Business Analytics courses in the first
year, in particular the course Probability Theory, to build and analyse
your model. You will write a report and give an oral presentation on
your results and conclusions.

Teaching Methods

The course starts with a 2-hour introductory lecture. During the first
week of the course you learn to use Crystal Ball, and work on computer
assignments in the field of applied probability theory and risk
management. During the second and third week, you continue with a team
project. For both the computer assignments and the team project, 3 hours
of computer lab work is scheduled every weekday. In the final week of
the course, there are no more classes, but you have to give a final
presentation on your results that will be scheduled somewhere during
that week.

Method of Assessment

Part A: computer assignments (25% of the grade).
Part B: written report and simulation model (50% of the grade).
Part C: individual oral presentation (25% of the grade).
You must complete all parts of the course to receive a final grade.
There is no resit for this course.

Target Audience


Recommended background knowledge

Probability Theory (in particular, knowledge of all the standard
discrete and continuous probability distributions and the rules for
mean, variance and standard deviation).

General Information

Course Code X_400572
Credits 3 EC
Period P6
Course Level 100
Language of Tuition English
Faculty Faculty of Science
Course Coordinator dr. W. Kager
Examiner dr. W. Kager
Teaching Staff J.E.L. van Kasteren MSc
dr. W. Kager

Practical Information

You need to register for this course yourself

Last-minute registration is available for this course.

Teaching Methods Seminar, Lecture, Computer lab