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

In this study unit the focus lies on the following
competencies:

Technological Competencies

Fact-based Decision Making Competency

Learning and Career-oriented 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

Upon completion of this study unit:

You have knowledge about functions as IF, nested
IF,
VLOOKUP and HLOOKUP. (Knowledge)

You have knowledge in using Advanced Graphing and
Charting and Filtering and basic data base
functions. (Skills)

You strive to understand the structure of
different kinds of data and how to use statistical
tools. (Approach)

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

Mohammadi Nafiseh

Examiner

Fabricius Susanna

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