Skip to main content

Information technology tools 1Laajuus (5 cr)

Code: LO00DZ72

Credits

5 op

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?

Enrollment

24.08.2024 - 08.09.2024

Timing

02.09.2024 - 30.11.2024

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

Logistiikka ja merenkulku

Campus

Ecampus

Teaching languages
  • Finnish
Seats

20 - 45

Degree programmes
  • Open University
Teachers
  • Marika Höglund
Teacher in charge

Marika Höglund

Groups
  • AVKTLL24SPOV
    Avoin AMK, eKampus, Tradenomi (AMK) logistiikka, polku, verkko, 2024 syksy

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?

Opiskelumateriaali

The material indicated by the teacher.
Course material in Learn.

Yksilölliset oppimisväylät

The student proceeds according to the schedule.

TKI ja työelämäyhteistyö

No

Tentit ja muut määräajat

To be announced later on the Learn platform of the course.

Kansainvälinen yhteistyö

No.

Opiskelijan työmäärä

Student´s work load is approximately 135 hours in average

Evaluation scale

1-5

Assessment methods and criteria

Assessment criteria level 3: entry-level know-how and skills
Students are able to:
a. You can use professional vocabulary systematically.
b. You can manage the appropriate methods of information search.
c. You can idnetify intterrelated tasks.
e. You can apply the key models, methods, software and techniques of the professional field.

Enrollment

14.08.2024 - 08.09.2024

Timing

01.08.2024 - 31.12.2024

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

Department of Logistics and Marine Technology

Campus

Kotka Campus

Teaching languages
  • Finnish
Seats

10 - 45

Degree programmes
  • Degree Programme in Logistics
Teachers
  • Marika Höglund
Teacher in charge

Marika Höglund

Groups
  • LOKT24SP
    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?

Opiskelumateriaali

The material indicated by the teacher.
Course material in Learn.

Yksilölliset oppimisväylät

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?

TKI ja työelämäyhteistyö

There is no STUDY and working life cooperation during the course.

Tentit ja muut määräajat

To be announced later on the Learn platform of the course.

Evaluation scale

1-5

Assessment methods and criteria

Assessment criteria level 3: entry-level know-how and skills
Students are able to:
a. You can use professional vocabulary systematically.
b. You can manage the appropriate methods of information search.
c. You can idnetify intterrelated tasks.
e. You can apply the key models, methods, software and techniques of the professional field.

Enrollment

14.08.2024 - 08.09.2024

Timing

02.09.2024 - 31.10.2024

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

Department of Logistics and Marine Technology

Campus

Ecampus

Teaching languages
  • Finnish
Degree programmes
  • Degree Programme in Logistics
Teachers
  • Anssi Salmi
Teacher in charge

Anssi Salmi

Groups
  • LLKT24SV
    Business Logistics, online 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?

Opiskelumateriaali

Will be informed later by teacher

Yksilölliset oppimisväylät

Scheduled track:
The student proceeds according to the schedule

Blended track:
The student can take the course among an older study group

TKI ja työelämäyhteistyö

No

Tentit ja muut määräajat

Will be informed later by teacher

Kansainvälinen yhteistyö

No

Opiskelijan työmäärä

Student´s work load is approximately 135 hours in average

Evaluation scale

1-5

Assessment methods and criteria

Based on assigments

Enrollment

21.08.2023 - 01.09.2023

Timing

04.09.2023 - 10.12.2023

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

Department of Logistics and Marine Technology

Campus

Kotka Campus

Teaching languages
  • Finnish
Degree programmes
  • Degree Programme in Logistics
Teachers
  • Anssi Salmi
Teacher in charge

Anssi Salmi

Groups
  • LOKT23SP
    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?

Opiskelumateriaali

Will be informed later by teacher.

Yksilölliset oppimisväylät

The student proceeds according to the schedule

Blended track:
The student can take the course among an older study group

TKI ja työelämäyhteistyö

No

Tentit ja muut määräajat

Will be informed later by teacher.

Kansainvälinen yhteistyö

No

Opiskelijan työmäärä

Student´s work load is approximately 135 hours in average

Evaluation scale

1-5

Assessment methods and criteria

Based on exam and/or assigments

Enrollment

21.08.2023 - 01.09.2023

Timing

01.09.2023 - 17.12.2023

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

Department of Logistics and Marine Technology

Campus

Kotka Campus

Teaching languages
  • Finnish
Degree programmes
  • Degree Programme in Logistics
Teachers
  • Anssi Salmi
Teacher in charge

Anssi Salmi

Groups
  • LOKT23SM
    Logistics, part-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?

Opiskelumateriaali

Will be informed later by teacher.

Yksilölliset oppimisväylät

Scheduled track:
The student proceeds according to the schedule

Blended track:
The student can take the course among an older study group

TKI ja työelämäyhteistyö

No

Tentit ja muut määräajat

Will be informed later by teacher.

Kansainvälinen yhteistyö

No

Opiskelijan työmäärä

Student´s work load is approximately 135 hours in average

Evaluation scale

1-5

Assessment methods and criteria

Based on exam and/or assigments

Enrollment

21.08.2023 - 01.09.2023

Timing

01.08.2023 - 31.12.2023

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

Department of Logistics and Marine Technology

Campus

Kotka Campus

Teaching languages
  • Finnish
Seats

10 - 60

Degree programmes
  • Degree Programme in Logistics
Teachers
  • Marika Höglund
Teacher in charge

Marika Höglund

Groups
  • LLKT23SV
    Business Logistics, online 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?

Opiskelumateriaali

The material indicated by the teacher.
Course material in Learn.

Yksilölliset oppimisväylät

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?

TKI ja työelämäyhteistyö

There is no STUDY and working life cooperation during the course.

Tentit ja muut määräajat

To be announced later on the Learn platform of the course.

Evaluation scale

1-5

Assessment methods and criteria

Assessment criteria level 3: entry-level know-how and skills
Students are able to:
a. You can use professional vocabulary systematically.
b. You can manage the appropriate methods of information search.
c. You can idnetify intterrelated tasks.
e. You can apply the key models, methods, software and techniques of the professional field.

Enrollment

22.08.2022 - 28.08.2022

Timing

02.09.2022 - 09.12.2022

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

Department of Logistics and Marine Technology

Campus

Kotka Campus

Teaching languages
  • Finnish
Degree programmes
  • Degree Programme in Logistics
Teachers
  • Anssi Salmi
Teacher in charge

Anssi Salmi

Groups
  • LOKT22SM
    Logistics, part-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?

Opiskelumateriaali

Will be informed later by teacher.

Yksilölliset oppimisväylät

Scheduled track:
The student proceeds according to the schedule

Blended track:
The student can take the course among an older study group

TKI ja työelämäyhteistyö

No.

Tentit ja muut määräajat

Will be informed later by teacher.

Kansainvälinen yhteistyö

No.

Opiskelijan työmäärä

Student´s work load is approximately 135 hours in average.

Evaluation scale

1-5

Assessment methods and criteria

Based on exam and assigments.

Enrollment

22.08.2022 - 28.08.2022

Timing

29.08.2022 - 16.12.2022

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

Department of Logistics and Marine Technology

Campus

Kotka Campus

Teaching languages
  • Finnish
Degree programmes
  • Degree Programme in Logistics
Teachers
  • Katja Helve
Teacher in charge

Marika Höglund

Groups
  • LOKT22SP
    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?

Opiskelumateriaali

Learn-alustalla ilmoitettu oppimateriaali.

Yksilölliset oppimisväylät

Kurssin toteutustavat ja arviointi ilmoitetaan Learn-alustalla.

TKI ja työelämäyhteistyö

Opintojaksoon ei sisälly TKI- ja työelämäyhteistyötä.

Enrollment

22.08.2022 - 28.08.2022

Timing

01.08.2022 - 31.12.2022

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

Department of Logistics and Marine Technology

Campus

Ecampus

Teaching languages
  • Finnish
Degree programmes
  • Degree Programme in Logistics
Teachers
  • Marika Höglund
Teacher in charge

Marika Höglund

Groups
  • LLKT22SV
    Business Logistics, online 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?

Opiskelumateriaali

The material indicated by the teacher.
Course material in Learn.

Yksilölliset oppimisväylät

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?

TKI ja työelämäyhteistyö

There is no STUDY and working life cooperation during the course.

Tentit ja muut määräajat

To be announced later on the Learn platform of the course.

Evaluation scale

1-5

Assessment methods and criteria

Assessment criteria level 3: entry-level know-how and skills
Students are able to:
a. You can use professional vocabulary systematically.
b. You can manage the appropriate methods of information search.
c. You can idnetify intterrelated tasks.
e. You can apply the key models, methods, software and techniques of the professional field.