Information technology toolsLaajuus (5 cr)
Course unit code: LL00CP49
General information
- Credits
- 5 cr
Objective
You have the skills to take advantage of the information technology in the logistics supply chain.
You know how to use Excel as a criteria in more depth and make effective use of the sharing between the applications.
You know how to use Excel as a training field in the calculation.
You will be able to produce and handle simple digital content and you understand the importance of operating rights and licences.
You know how to evaluate and choose the appropriate instrument, as well as to solve the problem you will be able to solve simple problems of understanding relating to the use of their own personal technology development needs (problem-solving).
Content
How do you add to your Word document or PowerPoint presentation embedded or linked table to a spreadsheet program?
How to create your own forms in Word?
How do you insert a PowerPoint presentation of your own reviews?
Excel:
How to use Excel to iterate over, such as financial, logical, date and time functions?
How to take advantage of the sorting and Filtering features, and calculate subtotals for the bigger tables?
How do you use and take advantage of the Pivot Tables in data reporting and analysis to?
How do you use Pivot-Tables summary functions and take advantage of automatic calculation?
How do you make and edit a variety of graphical presentations, such as trend curves, a combination of charts and Pivot to the charts?
How do you use aim search and Solver?
What are Excel macros, how to record and take advantage of them?
How to protect your tables, and parts of it?
Qualifications
Information Technology or similar knowledge.
Materials
All other courses of degree program.
Evaluation
3 e. Students can use the key models, methods, software and techniques
of the professional field