Information technology tools 1 (5 cr)
Code: LO00DZ72-3001
General information
Enrollment
15.08.2020 - 04.09.2020
Timing
24.08.2020 - 20.11.2020
Number of ECTS credits allocated
5 op
Virtual portion
2 op
Mode of delivery
60 % Contact teaching, 40 % Distance learning
Unit
Department of Logistics and Marine Technology
Campus
Kotka Campus
Teaching languages
- Finnish
Degree programmes
- Degree Programme in Business Logistics
Teachers
- Virpi Aalto
Teacher in charge
Virpi Aalto
Groups
-
LLKT20SPBusiness Logistics, full-time studies
Objective
You know how to use word processing, spreadsheet, and presentation graphics software for the purposes of your logistics studies.
Content
Word:
How to edit characters and paragraphs?
How to make page settings?
How to add and format pictures, and WordArt and SmartArt objects?
How to create formulas with Word features?
How to organize text into columns, create and edit tables, and use tabs?
How to use, create and edit styles?
How to create documents based on template documentation?
How to create and edit a table of contents and table of references?
How to divide your document into sections?
Excel:
How to create and format a table, and the content of a cell?
How to use functions, and create formulas?
How to make a relative and absolute cell reference, and how to use them effectively in the spreadsheet?
How to add charts and combination charts to the workbook and how to format them?
How to process (move, copy, delete, rename, hide, protect, format) tables in the workbook? How to sort and filter large tables?
How to use functions such as 'lookup', 'if', 'sum.if', 'count.if', and 'count.a' , and create multi-launching drop lists?
How to use conditional formatting in order to improve the readability of the table?
PowerPoint:
How to create an effective slide show presentation, and utilize and format themes?
How to take advantage of a variety of slide design templates?
How to add animations, videos, and audio to your presentation?
How to make a non-stop presentation and a presentation that is to be given to an audience? How to embed and link information from one Office program to another?
Teaching methods
Scheduled track:
Word: How to edit characters and paragraphs? How to make page settings? How to add and format pictures, and WordArt and SmartArt objects? How to create formulas with Word features? How to organize text into columns, create and edit tables, and use tabs? How to use, create and edit styles? How to create documents based on template documentation? How to create and edit a table of contents and table of references? How to divide your document into sections?
Excel: How to create and format a table, and the contents of a cell? How to use functions, and create formulas? How to make a relative and absolute cell reference, and how to use them effectively in the spreadsheet? How to add charts and combination charts to the workbook and how to format them? How to process (move, copy, delete, rename, hide, protect, format) tables in the workbook? How to sort and filter large tables? How to use functions such as 'lookup', 'if', 'sum.if', 'count.if', and 'count.a' , and create multi-launching drop lists? How to use conditional formatting in order to improve the readability of the table?
PowerPoint: How to create an effective slide show presentation, and utilize and format themes? How to take advantage of a variety of slide design templates? How to add animations, videos, and audio to your presentation? How to make a non-stop presentation and a presentation that is to be given to an audience?
How to embed and link information from one Office program to another?
Independent track:
Word: How to edit characters and paragraphs? How to make page settings? How to add and format pictures, and WordArt and SmartArt objects? How to create formulas with Word features? How to organize text into columns, create and edit tables, and use tabs? How to use, create and edit styles? How to create documents based on template documentation? How to create and edit a table of contents and table of references? How to divide your document into sections?
Excel: How to create and format a table, and the contents of a cell? How to use functions, and create formulas? How to make a relative and absolute cell reference, and how to use them effectively in the spreadsheet? How to add charts and combination charts to the workbook and how to format them? How to process (move, copy, delete, rename, hide, protect, format) tables in the workbook? How to sort and filter large tables? How to use functions such as 'lookup', 'if', 'sum.if', 'count.if', and 'count.a' , and create multi-launching drop lists? How to use conditional formatting in order to improve the readability of the table?
PowerPoint: How to create an effective slide show presentation, and utilize and format themes? How to take advantage of a variety of slide design templates? How to add animations, videos, and audio to your presentation? How to make a non-stop presentation and a presentation that is to be given to an audience?
How to embed and link information from one Office program to another?
Blended track:
Word: How to edit characters and paragraphs? How to make page settings? How to add and format pictures, and WordArt and SmartArt objects? How to create formulas with Word features? How to organize text into columns, create and edit tables, and use tabs? How to use, create and edit styles? How to create documents based on template documentation? How to create and edit a table of contents and table of references? How to divide your document into sections?
Excel: How to create and format a table, and the contents of a cell? How to use functions, and create formulas? How to make a relative and absolute cell reference, and how to use them effectively in the spreadsheet? How to add charts and combination charts to the workbook and how to format them? How to process (move, copy, delete, rename, hide, protect, format) tables in the workbook? How to sort and filter large tables? How to use functions such as 'lookup', 'if', 'sum.if', 'count.if', and 'count.a' , and create multi-launching drop lists? How to use conditional formatting in order to improve the readability of the table?
PowerPoint: How to create an effective slide show presentation, and utilize and format themes? How to take advantage of a variety of slide design templates? How to add animations, videos, and audio to your presentation? How to make a non-stop presentation and a presentation that is to be given to an audience?
How to embed and link information from one Office program to another?
Evaluation scale
1-5