Effective Utilization of Spreadsheet ComputationLaajuus (5 cr)

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

Learning to learn
Assesses and develops their competence and learning methods in different learning environments.
Is able to acquire, critically assess and appropriately apply the national and international knowledge base and practices of their field.

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.
You recognize the strengths and development areas of your competence and learning methods.

Operating in a workplace
Utilises the opportunities offered by technology and digitalisation in their work.
Understands the complexity of changing working life and their own resilience in changing working life situations.

Business competence
The students know the central theories related to this specialisation option. The students possess at least an advanced beginner’s skills in the practical tasks of the specialisation option.

Content

This course topics are the useful features and functions of spreadsheets:
- using formattings
- checking formulas and efficiently managing references between tables
- time-saving features: Define print areas, work with large tables, and use functions that speed up calculations
- analyses: PivotTables and Charts and PowerPivot Tool,
- problem-solving: Goal seeking and scenarios
- efficiency: macros

Qualifications

Basics of Spreadheets computation: functions, charts, cell references.

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. You develop and evaluate your own competence.

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. You develop and evaluate your own competence.

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. You develop and evaluate your own expertise.

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. You develop and evaluate your own expertise.

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. You develop and evaluate your own expertise.