Kursen ingår i dessa läroplaner och studiehelheter

Kursens undervisningsperiod

2 (2020-10-26 till 2020-12-31)

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

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 (41 studenter anmälda)

Delprestation i kraft till

12 månader efter kursens slutdatum

Kursanmälningstid

2020-10-12 till 2020-10-25

Examinationsformer

Datum meddelas senare - Rapporter och produktioner

Rumsbokningar
Datum Tid Rum Titel Beskrivning Organisatör
2020-10-29 12:15 - 16:15 Analysing Operational Data bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/66615123375?pwd=cTlBL1BNWEFxWXBMYlZKU3NmY1FoUT09   Meeting ID: 666 1512 3375 Passcode: AOD   Join by SIP 66615123375@109.105.112.236 66615123375@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 666 1512 3375 Passcode: 098541   Björk Kaj-Mikael
2020-11-03 12:30 - 16:30 Analysing Operational Data bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/64344051431?pwd=bS9RUGk4Ui8zUkJHcnBMRmtFdzRvUT09   Meeting ID: 643 4405 1431 Passcode: AOD   Join by SIP 64344051431@109.105.112.236 64344051431@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 643 4405 1431 Passcode: 101919   Björk Kaj-Mikael
2020-11-10 12:00 - 16:00 Analysing Operational Data bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/69067185977?pwd=UW5UNlZMV0xlNlZpYTh4blIxZURWdz09   Meeting ID: 690 6718 5977 Passcode: AOP   Join by SIP 69067185977@109.105.112.236 69067185977@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 690 6718 5977 Passcode: 265262   Björk Kaj-Mikael
2020-11-17 12:00 - 16:00 Analysing Operational Data bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/64982681285?pwd=SFl6cnR3N01yVFlZeS9YRS9mWjhPZz09   Meeting ID: 649 8268 1285 Passcode: AOP   Join by SIP 64982681285@109.105.112.236 64982681285@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 649 8268 1285 Passcode: 838734   Björk Kaj-Mikael
2020-11-26 08:30 - 12:00 Analysing Operational Data bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/61326691813?pwd=ZUNrZDZMcm1oWlo3Ym8xS2ZKc2RFdz09   Meeting ID: 613 2669 1813 Passcode: AOP   Join by SIP 61326691813@109.105.112.236 61326691813@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 613 2669 1813 Passcode: 788766   Björk Kaj-Mikael
2020-12-01 08:30 - 12:30 Analysing Operational Data bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/65266389579?pwd=K24wZTZCS0pKYnJ6eWNwQ2l4T3hXQT09   Meeting ID: 652 6638 9579 Passcode: AOP   Join by SIP 65266389579@109.105.112.236 65266389579@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 652 6638 9579 Passcode: 054260   Björk Kaj-Mikael
2020-12-10 12:30 - 16:30 Analysing Operational Data bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/69558764277?pwd=NFdLa2NiRVZwMndTUzlhZW42QndRZz09   Meeting ID: 695 5876 4277 Passcode: AOP   Join by SIP 69558764277@109.105.112.236 69558764277@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 695 5876 4277 Passcode: 736712   Björk Kaj-Mikael
2020-12-15 08:30 - 12:30 Analysing Operational Data bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/64845035590?pwd=NlJBNG81NEtZR08wcGJaVXF2UWdXdz09   Meeting ID: 648 4503 5590 Passcode: AOP   Join by SIP 64845035590@109.105.112.236 64845035590@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 648 4503 5590 Passcode: 712569   Björk Kaj-Mikael

Kurs och studieplanssökning