Advanced EXCEL UtilizationLaajuus (5 ECTS)

Objective

On completion of the course the student will be able to use fluently and in a comprehensive way Excel program in engineering.

Content

Creating Excel functions and charts, Pivot tables, filters, sorting, subtotals, statistical analyses, goal seek and solver, macros, VBA basic

Assessment criteria, satisfactory (1)

The student is able to apply the above listed, learned knowledge and skills according to instructions.

Assessment criteria, good (3)

The student is able to apply the above listed, learned knowledge and skills independently.

Assessment criteria, excellent (5)

The student is able to give reasons for his or her choices related to the course contents in a comprehensive manner.

Assessment criteria, approved/failed

The student is able to apply the above listed, learned knowledge and skills according to instructions.