Level/category

Professional studies

Teaching language

English

Type of course

Compulsory

Cycle/level of course

First

Recommended year of study

3

Total number of ECTS

5 cr

Competency aims

The student should be able to make models based on data. He/She should be able to interpret data and make forecasts, service level requirements and use the data to optimize and forecast processes.

Learning outcomes

The student get to know how to use Excel in order to model operational data. This includes Statistics, Workload forecasting, Monitoring complex systems, Queuing, Optimizing, Service level calculation and Inventory models. Also the methods are illustrated with some real-world business problems.

Course contents

Analyzing Operational Data with Excel shows you how to solve business problems on an operational level, using many of the Excel?s functions. These functions are, among others, goal seek, solver, sensitivity analysis. The course focus on both the excel functions and business problems that are solved with them. We will also go through how to deal with variable uncertainty. Using excel to solve queuing, optimization problems, service level problems and inventory problems.

Prerequisites and co-requisites

Module 1 or equivalent

Recommended or required reading

To be announced later

Study activities

  • Lectures - 20 hours
  • Practical exercises - 20 hours
  • Project- and production work/artistic activities - 95 hours

Workload

  • Total workload of the course: 135 hours
  • Of which autonomous studies: 135 hours
  • Of which scheduled studies: 0 hours

Mode of Delivery

Participation in tuition

Assessment methods

  • Exams (written-, oral-, home-)
  • Essays, reports, productions and portfolio

Assessment requirements

To pass the course the student must pass the written exam and do the assignments given during the course. The written exam is giving 75 points of 100 points in the course Minimum 50 points of the total 100 points is required to pass

Teacher

Björk Kaj-Mikael

Examiner

Björk Kaj-Mikael

Home page of the course

https://arcada.itslearning.com/

Group size

No limit

Assignments valid until

12 months after course has ended

Assessment methods

  • Date of examination will be announced later - Exams
  • Date will be announced later - Reports and productions

Course and curricula search