Kursen ingår i dessa läroplaner och studiehelheter
- Företagsekonomi 2018 (logistik) - Business insight management
- Företagsekonomi 2018 (marknadsföring) - Business insight management
- Företagsekonomi 2018 (turism) - Business insight management
- Företagsekonomi 2019 - Business insight management
- Företagsekonomi 2020 - Business insight management
- International business 2018 - Business insight management
- International business 2019 - Business insight management
- International business 2020 - Business insight management
Nivå/kategori
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
20 credits completed from the subject module.
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
Essä, rapporter, produktioner och portfolio
Examinationskrav
To pass the course the student must do the
assignments given during
the course. The assignments are giving 100 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
Antal kursplatser
Ingen begränsning
Delprestation i kraft till
12 månader efter kursens slutdatum
Examinationsformer
Datum meddelas senare - Rapporter och produktioner