Skip to main content

Effective Utilization of Spreadsheet ComputationLaajuus (5 cr)

Code: HBT20300

Credits

5 op

Teaching language

  • Finnish

Responsible person

  • Päivi Hänninen-Pihlajamäki

Objective

The object of the course
Once you have completed the course, you have the essential information on the possibilities and benefits of spreadsheet computation related to your field of studies.

Course competencies
Business competence
Profitability Competence​

The learning objectives of the course
After this course, you will know the advanced features of the spreadsheet computation and you will be able to take advantage of them in studying and working life.

Content

Spreadsheet computation: editing features, checking formulas, using printing range, references in tables and between them, functions facilitating calculation, sorting functions of large tables, macros, Pivot

Qualifications

Basics of Spreadheets computation

Assessment criteria, satisfactory (1)

Sufficient 1
You recognize the principles of effective working with a spreadsheet program and you can use the tools with instruct.

Satisfactory 2
You understand the main principles of the advanced features of the spreadsheet, and you can use your skills in different kind of situations independently.

Assessment criteria, good (3)

Good 3
You understand the possibilities of using the spreadsheet program as an effective tool. You can apply your skills in different kind of situations.

Very good 4
You master possibilities for using the spreadsheet program as an effective personal tool. You know how to apply your skills to different spreadsheet computing situations. You can justify your choices and decisions.

Assessment criteria, excellent (5)

Excellent 5
You have the critical knowledge of the spreadsheet program, and you can apply your skills in developing new innovative applications in work.
You justify your choices and decisions.