Spreadsheet (3cr)

Objective

Students are able to plan, implement and utilise various calculation models. They are able to present the results graphically. Students are also able to make summaries of the information in tables, filter information and utilise other special features in the spreadsheet software.

Content

Creating and editing spreadheets with Excel
- Writing formulas and using functions
- Processing/sorting information in a spreadsheet
- Filtering, summarising, linking
- Using Pivot tables
- Creating and editing graphs and charts
- Printing
- Goal Seek
- Special features in the Excel

Materials

Opettajan opintojakson alkaessa ilmoittama materiaali

Teaching methods

- Lähiopetus (luennot ja harjoitukset)
- Itsenäinen työskentely

Assessment criteria, satisfactory (1)

The student will do the job of the course requirements successfully. The student is able to plan, implement and utilise calculation models, but needs often help. The student is able to present the results using charts and is also able to make summaries of the information in tables, filter information and utilise some other special features in the Excel software.

Assessment criteria, good (3)

The student is able to plan, implement and utilise well a variety of various calculation models. The student is able to present the results using good charts and is also able to make summaries of the information in tables, filter information and utilise other special features in the Excel software.

Assessment criteria, excellent (5)

The student is able to plan independently, implement and utilise a variety of various calculation models. The student is able to present the results using excellent charts and is also able to make summaries of the information in tables, filter information and utilise very well other special features in the Excel software.

Qualifications

Information and communication technology