Advanced Use of Excel in Technical ApplicationsLaajuus (5 cr)

Objective

You know how to use spreadsheets in depth and you can apply your skills both in your studies and in working life in the field of technology and transport.

Engineering practice:
You have ability to identify, formulate and solve complex engineering problems, by being able to select and having the practical skills to apply relevant established analytical, computational and experimental techniques and methods

Content

Advanced us of Excel and mixed use of spreadsheets and word processing.
- using strings
- using large information material
- using logical, set and search functions
- creating forms and macros
- using analytical tools in engineering
- basic use of pivot tables and charts

Qualifications

ICT Skills or corresponding studies at university

Assessment criteria, approved/failed

To achieve approved performance, you must demonstrate that you have mastered the advanced use of spreadsheets. Competence is demonstrated by approved weekly assignments in the areas described in the course content.