Kursens undervisningsperiod

2 (2022-10-24 till 2022-12-31)

Nivå/kategori

Yrkesstudier

Undervisningsspråk

Engelska

Kurstyp

Obligatorisk

Cykel/nivå

Yrkeshögskoleexamen

Rekommenderat studieår

3

Omfattning

5 sp

Kompetensmål

Competencies
Within this study unit we will focus on the
following competencies:
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 in
order to find sustainable solutions through
digital transformation.

SDGs in focus:
1 NO POVERTY
4 QUALITY EDUCATION
5 GENDER EQUALITY
8 DECENT WORK AND ECONOMIC GROWTH
9 INDUSTRY, INNOVATION AND INFRASTRUCTURE
10 REDUCED INEQUALITIES
12 RESPONSIBLE CONSUMPTION & PRODUCTION

Läranderesultat

The student gets 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.and thus, contribute to a more
sustainable business environment.

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.

Kursen ersätter följande kurser

No prior course

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

Antal kursplatser

Ingen begränsning (39 studenter anmälda)

Delprestation i kraft till

12 månader efter kursens slutdatum

Kursanmälningstid

2022-10-10 till 2022-10-20

Examinationsformer

Datum meddelas senare - Rapporter och produktioner

Rumsbokningar
Datum Tid Rum Titel Beskrivning Organisatör
2022-10-27 12:15 - 16:15 E385 Analysing Operational Data Björk Kaj-Mikael
2022-11-03 12:15 - 16:15 F365 Analysing Operational Data Björk Kaj-Mikael
2022-11-10 12:15 - 16:15 E385 Analysing Operational Data Björk Kaj-Mikael
2022-11-15 12:30 - 16:30 F365 Analysing Operational Data Björk Kaj-Mikael
2022-11-24 12:15 - 16:15 F365 Analysing Operational Data Björk Kaj-Mikael
2022-12-01 12:15 - 16:15 F365 Analysing Operational Data Björk Kaj-Mikael
2022-12-15 12:15 - 16:15 E385 Analysing Operational Data Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/62742893195?from=addon Meeting ID: 627 4289 3195 Join by SIP 62742893195@109.105.112.236 62742893195@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 627 4289 3195 Björk Kaj-Mikael

Kurs och studieplanssökning