Study Guide

Objective

The student deepens her/his Excel skills so that she/he knows how to plan, implement and use Excel spreadsheets in a versatile way.

Content

With Excel spreadsheet program
- Deepening the preparation of calculation formulas
- Deepening the preparation of diagrams
- Deepening the use of functions
- Three-dimensional calculation
- Alternative situations
- Search for a solution
- Pivot Tables
- Excel special functions

Evaluation scale

1-5

Assessment criteria, satisfactory (1)

The student can prepare calculation formulas and diagrams based on the instructions and use the assigned function.

Assessment criteria, good (3)

The student knows how to prepare calculation formulas and diagrams and knows how to choose functions suitable for the calculation task. The student knows Excel's automation methods for creating spreadsheets.

Assessment criteria, excellent (5)

The student knows how to prepare and develop spreadsheets and charts and knows how to choose the functions suitable for the calculation task. The student makes versatile use of Excel's automation in preparing spreadsheets.

Qualifications

Information and communication technology, Spreadsheet