Information techonogy toolsLaajuus (5 cr)

Objective

You have the skills to apply information technology in the logistics supply chain.
You have advanced Excel skills and you are able to effectively use interactive applications .
You know how to use Excel in the calculations necessary in your field of study.
You are able to produce and process simple digital content and you understand the importance of user's rights and licences.
You are able to choose the appropriate tool to solve a problem, solve simple problems related to the use of personal technology, and determine what skills you need to improve (problem solving).

Content

How is an embedded or linked table added to a Word document or Power Point presentation from a spreadsheet program?
How are forms created in Word?
How to insert comments in a Power Point presentation?
How to use the special functions of Excel, such as financial, logical, date and time functions?
How to utilise the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilise the Pivot tables when reporting and analysing data?
How to use Pivot table summary functions and utilise automatic calculation?
How to make and edit graphical presentations such as trend curves, combination charts and Pivot charts?
How to use the aim search and solver?
What macros are featured in Excel and how to record and utilise them?
How to protect your tables and sections of tables?

Evaluation

e. Students can use the key models, methods, software and techniques of the professional field.

Qualifications

Information technology or equivalent knowledge.

Materials

All other courses of the degree program.