Skip to main content

Spreadsheet calculation 2 (3 cr)

Code: LT00DL21-3001

General information


Enrollment

13.11.2023 - 21.02.2024

Timing

04.03.2024 - 26.05.2024

Credits

3 op

Virtual proportion (cr)

3 op

Teaching languages

  • Finnish

Degree programmes

  • Bachelor of Business Administration, Business Management

Teachers

  • Marja Erkkilä

Student groups

  • EXLI24
    Excel as Business Support Tool
  • VVO

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