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

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

https://arcada.itslearning.com/

Group size

No limit

Assignments valid until

12 months after course has ended

Assessment methods

Date will be announced later - Reports and productions

Course and curricula search