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
- 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
The course takes place in period
1 (2022-08-01 to 2022-10-23)
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
Competencies
Within this study unit we will focus on the
following competencies:
The aim of the course is that the student knows
how to handle data and use calculation programs
like MS Excel for both basic and more challenging
operations in order to gain to more digital
competencies.
SDGs in focus:
1 NO POVERTY
4 QUALITY EDUCATION
8 DECENT WORK AND ECONOMIC GROWTH
10 REDUCED INEQUALITIES
12 RESPONSIBLE CONSUMPTION & PRODUCTION
Learning outcomes
The student should be able import and
manipulate data in Excel, and use functions as
IF, nested IF, VLOOKUP and HLOOKUP functions in
Excel. He/She should also be able to use Advanced
Graphing and Charting and Filtering and basic data
base functions. The student should also understand
the structure of different kinds of data and how
to use statistical tools in Excel.
Course contents
Introduction to several functions in Excel like
LOOKUP, IF-functions, as well as Data filtering
in Excel and knowhow in the construction of
Pivot Tables to organize data. Also using
advanced chart options will be gone through as
well as statistical
tools from Excel. A walk-
through of logical operators is done.
Prerequisites and co-requisites
20 credits completed from the subject module.
Previous course names
No previous course
Additional information
to be announced later
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 participate
and do the assignments given during the course.
There is no written exam in the course.
Minimum 50 points of 100 points is
required.
Teacher
Björk Kaj-Mikael
Examiner
Björk Kaj-Mikael
Home page of the course
Group size
No limit (40 students enrolled)
Assignments valid until
12 months after course has ended
Course enrolment period
2022-08-10 to 2022-08-25
Assessment methods
Date will be announced later - Reports and productions
Date | Time | Room | Title | Description | Organizer |
---|---|---|---|---|---|
2022-08-30 | 08:15 - 12:15 | E385 | Business Data Modelling | Björk Kaj-Mikael | |
2022-09-06 | 08:15 - 12:15 | E385 | Business Data Modelling | Björk Kaj-Mikael | |
2022-09-13 | 08:15 - 12:15 | E385 | Business Data Modelling | Björk Kaj-Mikael | |
2022-09-20 | 08:15 - 12:15 | E385 | Business Data Modelling | Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/63741281546?from=addon Meeting ID: 637 4128 1546 Join by SIP 63741281546@109.105.112.236 63741281546@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 637 4128 1546 | Björk Kaj-Mikael |
2022-09-27 | 08:15 - 12:15 | E385 | Business Data Modelling | Björk Kaj-Mikael | |
2022-10-04 | 08:15 - 12:15 | E385 | Business Data Modelling | Björk Kaj-Mikael | |
2022-10-11 | 08:15 - 12:15 | E385 | Business Data Modelling | Björk Kaj-Mikael | |
2022-10-18 | 08:15 - 12:15 | Business Data Modelling | Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/63422566498?from=addon Meeting ID: 634 2256 6498 Join by SIP 63422566498@109.105.112.236 63422566498@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 634 2256 6498 | Björk Kaj-Mikael |