Study Guide

Objective

You know how to use the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

Content

How is an embedded or linked table added to a Word document or Power Point presentation from a spreadsheet program?
How are forms created in Word?
How to insert comments in a Power Point presentation?
How to use the special functions of Excel, such as financial, logical, date and time functions? How to utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize automatic calculation?
How to make and edit graphical presentations such as trend curves, combination charts and Pivot charts?
How to use the aim search and solver?
How do you calculate the clock times? How to protect your tables and sections of tables?

Materials

Will be informed later by teacher

Teaching methods

Scheduled track:
The student proceeds according to the schedule

Blended track:
The student can take the course among an older study group

Employer connections

No.

Exam schedules

Will be informed later by teacher

International connections

No.

Student workload

Student´s work load is approximately 135 hours in average

Evaluation scale

1-5

Assessment methods and criteria

Based on exam and assigments

Qualifications

Information technology tools 1 or equivalent knowledge.