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
1 (2020-08-01 to 2020-10-25)
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 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.
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
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 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 (41 students enrolled)
Assignments valid until
12 months after course has ended
Course enrolment period
2020-05-18 to 2020-09-01
Assessment methods
Date will be announced later - Reports and productions
Date | Time | Room | Title | Description | Organizer |
---|---|---|---|---|---|
2020-09-03 | 09:45 - 13:45 | Business Data Modelling | bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/63537045921?pwd=YS9sazlWN3l3cTBMR2c5bU5GUTFGQT09 Meeting ID: 635 3704 5921 Passcode: BM Join by SIP 63537045921@109.105.112.236 63537045921@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 635 3704 5921 Passcode: 401614 | Björk Kaj-Mikael | |
2020-09-10 | 08:30 - 12:00 | Business Data Modelling | bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/64156750280?pwd=RDVZdnc3eG84bnBHZEY5THpxdm9UUT09 Meeting ID: 641 5675 0280 Passcode: BM Join by SIP 64156750280@109.105.112.236 64156750280@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 641 5675 0280 Passcode: 950744 | Björk Kaj-Mikael | |
2020-09-17 | 08:30 - 12:30 | Business Data Modelling | bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/66497385056?pwd=K240SVBUbHduVjdWbkQvYlJrT2RYdz09 Meeting ID: 664 9738 5056 Passcode: BM Join by SIP 66497385056@109.105.112.236 66497385056@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 664 9738 5056 Passcode: 054992 | Björk Kaj-Mikael | |
2020-09-24 | 12:00 - 16:00 | Business Data Modelling | bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/61993851603?pwd=ZmJlZmd2SXZWUHJGckpRMVZEZ3UwUT09 Meeting ID: 619 9385 1603 Passcode: BM Join by SIP 61993851603@109.105.112.236 61993851603@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 619 9385 1603 Passcode: 702563 | Björk Kaj-Mikael | |
2020-10-01 | 12:00 - 16:00 | Business Data Modelling | bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/68659014196?pwd=aWVMenpjTWNmSUV5Znk5ZlNOam9odz09 Meeting ID: 686 5901 4196 Passcode: BM Join by SIP 68659014196@109.105.112.236 68659014196@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 686 5901 4196 Passcode: 860654 | Björk Kaj-Mikael | |
2020-10-08 | 12:00 - 16:00 | Business Data Modelling | bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/67306605657?pwd=RHFUS1EzUFZRSks1OUwzR2FTR1ZRUT09 Meeting ID: 673 0660 5657 Passcode: BM Join by SIP 67306605657@109.105.112.236 67306605657@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 673 0660 5657 Passcode: 976291 | Björk Kaj-Mikael | |
2020-10-13 | 08:30 - 12:30 | Business Data Modelling | bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/61531246025?pwd=SlZtSHNsODNWNkkyMUhXTWRzOHQyQT09 Meeting ID: 615 3124 6025 Passcode: BM Join by SIP 61531246025@109.105.112.236 61531246025@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 615 3124 6025 Passcode: 816190 | Björk Kaj-Mikael | |
2020-10-21 | 12:00 - 16:00 | Business Data Modelling | bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/65334409431?pwd=c0FiWFFIYWRZdFRRVkZEbmw5YnNNZz09 Meeting ID: 653 3440 9431 Passcode: BM Join by SIP 65334409431@109.105.112.236 65334409431@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 653 3440 9431 Passcode: 076838 | Björk Kaj-Mikael |