The course takes place in period

1 (2021-08-01 to 2021-10-24)

Level/category

Professional studies

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

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 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

Group size

No limit (41 students enrolled)

Assignments valid until

12 months after course has ended

Course enrolment period

2021-08-09 to 2021-08-29

Assessment methods

Date will be announced later - Reports and productions

Room reservations
Date Time Room Title Description Organizer
2021-08-31 08:30 - 12:30 Business Data Modelling Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting.   Topic: Business Data Modelling Time: Aug 31, 2021 08:30 AM Kiev   Join Zoom Meeting https://arcada.zoom.us/j/68624862377?pwd=c3VoTS9hMm9JM3RMd1FwMi9NNnNSUT09   Meeting ID: 686 2486 2377 Passcode: 127481   Join by SIP 68624862377@109.105.112.236 68624862377@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 686 2486 2377 Passcode: 127481   Björk Kaj-Mikael
2021-09-07 08:30 - 12:30 E383 Business Data Modelling Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting.   Topic: Business Data Modelling Time: Sep 7, 2021 08:30 AM Kiev   Join Zoom Meeting https://arcada.zoom.us/j/62615199828?pwd=YkxhL1BsL055cEUyWitad0UyaHl2Zz09   Meeting ID: 626 1519 9828 Passcode: 279935   Join by SIP 62615199828@109.105.112.236 62615199828@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 626 1519 9828 Passcode: 279935 Björk Kaj-Mikael
2021-09-16 08:30 - 12:30 E383 Business Data Modelling Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/62586889201   Meeting ID: 625 8688 9201   Join by SIP 62586889201@109.105.112.236 62586889201@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 625 8688 9201   Björk Kaj-Mikael
2021-09-21 08:30 - 12:30 E383 Business Data Modelling Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/62959933949   Meeting ID: 629 5993 3949   Join by SIP 62959933949@109.105.112.236 62959933949@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 629 5993 3949   Björk Kaj-Mikael
2021-09-28 08:30 - 12:30 E385 Business Data Modelling Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/66262245166   Meeting ID: 662 6224 5166   Join by SIP 66262245166@109.105.112.236 66262245166@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 662 6224 5166   Björk Kaj-Mikael
2021-10-05 08:30 - 12:30 E383 Business Data Modelling Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/61851400387   Meeting ID: 618 5140 0387   Join by SIP 61851400387@109.105.112.236 61851400387@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 618 5140 0387   Björk Kaj-Mikael
2021-10-12 08:30 - 12:30 E383 Business Data Modelling Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/65889999394   Meeting ID: 658 8999 9394   Join by SIP 65889999394@109.105.112.236 65889999394@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 658 8999 9394   Björk Kaj-Mikael

Course and curriculum search