The course takes place in period

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

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

Essays, reports, productions and portfolio

Assessment requirements

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

Teacher

Björk Kaj-Mikael

Examiner

Björk Kaj-Mikael

Group size

No limit (41 students enrolled)

Assignments valid until

12 months after course has ended

Course enrolment period

2020-10-12 to 2020-10-25

Assessment methods

Date will be announced later - Reports and productions

Room reservations
Date Time Room Title Description Organizer
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

Course and curriculum search