The course is included in these curricula and study modules
- Business administration 2018 (logistics) - Business insight management
- Business administration 2018 (marketing) - Business insight management
- Business administration 2018 (tourism) - Business insight management
- Business administration 2019 - Business insight management
- Business administration 2020 - Business insight management
- International business 2018 - Business insight management
- International business 2019 - Business insight management
- International business 2020 - Business insight management
The course takes place in period
2 (2020-10-26 to 2020-12-31)
Level/category
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
Home page of the course
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
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 |