Study Guide

Objective

To provide students with the skill to use different digital tools needed in their field of business. The students will demonstrate competency by completing individual projects.

Learning Objectives (LOs):
The student has the ability to analyze and visually present big data with different software

Content

Content of the study unit
Analyzing and visually presenting big data in Excel with advanced functions, PivotTables, and Business intelligence tools in Excel (Power Query and Power Pivot) and charts.
Analyzing and visually presenting big data with Microsoft Power BI.

The student will look through the LinkedIn Learning video material assigned by the tutor and make notes based on the videos. Practical tasks, that are based on video material are done and presented as a screen recording.

Practical tasks are divided into the following parts: A) Advanced Excel functions, B) PivotTables and graphs in Excel, C) Excel Business Intelligence, and D) Power BI

Location and time

Spring 2025

See Peppi and Moodle for detailed time plan.

Materials

Material on Moodle and material on LinkedIn Learning (students will get license to LinkedIn Learning)

Teaching methods

The student will look through the LinkedIn Learning video material assigned by the instructor and make notes based on the videos. Practical tasks, that are based on video material are done and presented as a screen recording.

There will be on site classes in computer lab with possibility to join online.

Student workload

4 cr x 27 hours = 108 hours

Contact hours: 22 hours
Self study: 86 hours (approx 6 hours per week in 14 weeks)

Evaluation scale

H-5

Assessment criteria, satisfactory (1)

Assessment criteria
Sufficient (1) and Satisfactory (2)
The student hands in a presentation video where practical tasks are presented. At least 60% (grade 1) / 70% (grade 2) of the practical tasks are done according to instructions.

Assessment criteria, good (3)

Good (3)
The student hands in a good presentation video where practical tasks are presented.
At least 75% of the practical tasks are done according to instructions. The student has looked through all video material assigned by the instructor and handed in notes based on the videos.

Very good (4)
The student hands in a very good presentation video where practical tasks are presented.
Most of the practical tasks are very well done according to instructions. The student has looked through all video material assigned by the instructor and handed in well-structured notes based on the videos.

Assessment criteria, excellent (5)

Excellent (5)
The student hands in an excellent presentation video where practical tasks are presented.
All practical tasks are done with excellence according to instructions. The student has looked through all video material assigned by the instructor and handed in well-structured notes based on the videos.

Assessment criteria, approved/failed

Evaluation:
Fail:0
Numerical for PASS from 1 to 5

Assessment criteria, fail (0)

0 for FAIL: No participation in the contact lessons, no participation in the online lessons, no presentation tasks, no returned tasks.

Assessment criteria, satisfactory (1-2)

Sufficient (1) and Satisfactory (2)
The student hands in a presentation video where practical tasks are presented. At least 60% (grade 1) / 70% (grade 2) of the practical tasks are done according to instructions.

Assessment criteria, good (3-4)

Assessment criteria – good (3)
The student hands in a good presentation video where practical tasks are presented.
At least 75% of the practical tasks are done according to instructions. The student has looked through all video material assigned by the tutor and handed in notes based on the videos.

Assessment criteria – very good (4)
The student hands in a very good presentation video where practical tasks are presented.
Most of the practical tasks are very well done according to instructions. The student has looked through all video material assigned by the tutor and handed in well-structured notes based on the videos.
Hand-in must be done within two weeks after deadline.

Assessment criteria, excellent (5)

Assessment criteria – excellent (5)
The student hands in an excellent presentation video where practical tasks are presented.
All practical tasks are done with excellence according to instructions. The student has looked through all video material assigned by the tutor and handed in well-structured notes based on the videos.
Hand-in must be done before deadline.

Qualifications

No prior knowledge requirements