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
- Business administration 2021 - Business insight management - advanced studies
- Business administration 2022 - Business insight management - advanced studies
- Business administration 2023 - Business insight management - advanced studies
- International business 2018 - Business insight management
- International business 2019 - Business insight management
- International business 2020 - Business insight management
- International business 2021 - Business insight management - advanced studies
- International business 2022 - Business insight management - advanced studies
- International business 2023 - Business insight management - advanced studies
The course takes place in period
2 (2023-10-23 to 2023-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
In this study unit the focus lies on the following
competencies:
Fact-based decision making competency
Innovation and development competency
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
Learning outcomes
Upon completion of this study unit:
You can use Excel in order to model operational
data, including Statistics, Workload forecasting,
Monitoring complex systems, Queuing, Optimizing,
Service level calculation and Inventory models.
(Knowledge, Skills)
You have developed a real-world mindset towards
business problems and thus, know how to contribute
to a more sustainable business environment.
(Approach)
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, hypothesis testing. The course focus
on both the excel's statistical 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.
Previous course names
No prior course
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
Broth Joacim
Examiner
Broth Joacim
Home page of the course
Group size
No limit (37 students enrolled)
Assignments valid until
12 months after course has ended
Course enrolment period
2023-10-09 to 2023-10-23
Assessment methods
Date will be announced later - Reports and productions
| Date | Time | Room | Title | Description | Organizer |
|---|---|---|---|---|---|
| 2023-10-25 | 13:00 - 16:00 | B518 | Analysing Operational Data | Analysis and assignment | Broth Joacim |
| 2023-11-02 | 12:30 - 15:30 | B518 | Analysing Operational Data | Analysis and assignment | Broth Joacim |
| 2023-11-09 | 09:00 - 12:00 | B518 | Analysing Operational Data | Analysis and assignment | Broth Joacim |
| 2023-11-13 | 16:30 - 18:00 | Z030 | Sisu session in English for IB students ONLINE | All students are to activate their study plan in the new student information system Sisu before December 2023. By activating your study plan before December you can enrol to your courses starting in January. If you do not activate your study plan before December: you cannot enrol to your courses and will therefore not be able to participate in lectures in January. More information: https://start.arcada.fi/en/news/topical/2023-10-04/arcada-is-changing-its-student-information-system-from-asta-to-sisu The session is held by Arcada's Student Affairs: sisu@arcada.fi. Link to the Teams-session: https://teams.microsoft.com/l/meetup-join/19%3ameeting_ZjdhODZlM2MtNjZiOC00YTQxLWE1N2UtZjRhODE4OTIzZTI0%40thread.v2/0?context=%7b%22Tid%22%3a%2286080f64-b23d-4f93-8c43-e65f2588b9c3%22%2c%22Oid%22%3a%2295120ab9-e6c5-4d68-b283-421bbe101856%22%7d | Ahlroth Siri Eerola Sabina |
| 2023-11-14 | 12:30 - 15:30 | D4106 | Analysing Operational Data | Work with individual assignment Questions about the individual task can be asked in the classroom or via ZOOM Join Zoom Meeting https://arcada.zoom.us/j/68184363815 | Broth Joacim |
| 2023-11-14 | 16:30 - 18:00 | Z030 | Sisusession för FE studenter ONLINE | Alla studenter måste ta i bruk sin individuella studieplan i det nya studieadministrativa systemet Sisu innan december 2023. Genom att aktivera din studieplan innan decemeber säkerställer du att du kan anmäla dig till dina kurser som inleds i januari. Om du inte tagit i bruk och aktiverat din studieplan inom december kan du inte anmäla dig till kurserna och således inte delta i undervisningen som börjar i januari. Mer information: https://start.arcada.fi/sv/nyheter/aktuellt/2023-10-03/arcada-byter-studieadministrativt-system-fran-asta-till-sisu Sessionen ordnas av Arcadas studieärenden: sisu@arcada.fi Länk till Teams-sessionen: https://teams.microsoft.com/l/meetup-join/19%3ameeting_ZjVmODNjMDMtZjhjMC00MGNjLWJjNWMtZDIyZjVjZTJiZDcw%40thread.v2/0?context=%7b%22Tid%22%3a%2286080f64-b23d-4f93-8c43-e65f2588b9c3%22%2c%22Oid%22%3a%2295120ab9-e6c5-4d68-b283-421bbe101856%22%7d | Ahlroth Siri Eerola Sabina |
| 2023-11-21 | 09:00 - 12:00 | B518 | Analysing Operational Data | Analysis and assignment | Broth Joacim |
| 2023-11-27 | 14:00 - 15:00 | Z030 | Info Session Third Year Students; Degree Thesis and Support Courses / Lärdomsprov och stödkurser | https://arcada.zoom.us/j/61725493049?from=addon | Fabricius Susanna Genberg Camilla Grönholm Hanna |
| 2023-11-30 | 09:00 - 12:00 | Analysing Operational Data | Join Zoom Meeting https://arcada.zoom.us/j/69334568864 | Broth Joacim | |
| 2023-12-08 | 13:00 - 16:00 | B518 | Analysing Operational Data | Presentation of group assignment Due to the state of the illness when some are not feeling well, we are making the presentation on a Hybrid solution. Those who want to come to room B518 (13.00-16.00) and those who feel it is safer connect via ZOOM. Join Zoom Meeting https://arcada.zoom.us/j/67520645387 | Broth Joacim |
| 2023-12-14 | 09:00 - 12:00 | Analysing Operational Data | Join Zoom Meeting https://arcada.zoom.us/j/64925450145 | Broth Joacim |