Course ObjectiveAfter 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 ContentYou 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 MethodsThe 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
Method of AssessmentPart 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.
Recommended background knowledgeProbability Theory (in particular, knowledge of all the standard
discrete and continuous probability distributions and the rules for
mean, variance and standard deviation).
|Language of Tuition||English|
|Faculty||Faculty of Science|
|Course Coordinator||dr. W. Kager|
|Examiner||dr. W. Kager|
J.E.L. van Kasteren MSc
dr. W. Kager
You need to register for this course yourself
Last-minute registration is available for this course.
|Teaching Methods||Seminar, Lecture, Computer lab|