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 (2021-10-25 to 2021-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
20 credits completed from the subject module.
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 (42 students enrolled)
Assignments valid until
12 months after course has ended
Course enrolment period
2021-10-11 to 2021-10-24
Assessment methods
Date will be announced later - Reports and productions
Date | Time | Room | Title | Description | Organizer |
---|---|---|---|---|---|
2021-10-26 | 13:00 - 17:00 | E385 | Analysing Operational Data | Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/68059923975 Meeting ID: 680 5992 3975 Join by SIP 68059923975@109.105.112.236 68059923975@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 680 5992 3975 | Björk Kaj-Mikael |
2021-11-02 | 13:00 - 17:00 | E385 | Analysing Operational Data | Björk Kaj-Mikael | |
2021-11-09 | 13:00 - 17:00 | E385 | Analysing Operational Data | Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/66172179524 Meeting ID: 661 7217 9524 Join by SIP 66172179524@109.105.112.236 66172179524@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 661 7217 9524 | Björk Kaj-Mikael |
2021-11-16 | 13:00 - 17:00 | Analysing Operational Data | Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/66054891440 Meeting ID: 660 5489 1440 Join by SIP 66054891440@109.105.112.236 66054891440@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 660 5489 1440 | Björk Kaj-Mikael | |
2021-11-23 | 13:00 - 17:00 | Analysing Operational Data | Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/68487126588 Meeting ID: 684 8712 6588 Join by SIP 68487126588@109.105.112.236 68487126588@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 684 8712 6588 | Björk Kaj-Mikael | |
2021-11-30 | 13:00 - 17:00 | E385 | Analysing Operational Data | Björk Kaj-Mikael | |
2021-12-07 | 13:00 - 17:00 | Analysing Operational Data | Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/68114535542?from=addon Meeting ID: 681 1453 5542 Join by SIP 68114535542@109.105.112.236 68114535542@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 681 1453 5542 | Björk Kaj-Mikael |