Nivå/kategori

Yrkesstudier

Undervisningsspråk

Engelska

Kurstyp

Obligatorisk

Cykel/nivå

Yrkeshögskoleexamen

Rekommenderat studieår

3

Omfattning

5 sp

Kompetensmål

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.

Läranderesultat

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.

Innehåll

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.

Förkunskaper

Module 1 or equivalent

Litteratur

To be announced later

Studieaktiviteter

  • Föreläsningar - 20 timmar
  • Praktiska övningar - 20 timmar
  • Projekt- och produktionsarbete/konstnärlig verksamhet - 95 timmar

Arbetsbelastning

  • Kursens totala antal arbetstimmar: 135 timmar
  • Varav självstyrda studieformer: 135 timmar
  • Varav schemalagda studier: 0 timmar

Undervisningsform

Närundervisning

Examinationsformer

  • Tentamina (skriftliga-, muntliga-, hem-)
  • Essä, rapporter, produktioner och portfolio

Examinationskrav

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

Lärare

Björk Kaj-Mikael

Examinator

Björk Kaj-Mikael

Kursens hemsida

https://arcada.itslearning.com/

Antal kursplatser

Ingen begränsning

Delprestation i kraft till

12 månader efter kursens slutdatum

Examinationsformer

  • Tentdatum meddelas senare - Tentamina
  • Datum meddelas senare - Rapporter och produktioner

Kurs- och studieplansökning