Skip to main content

Information technology (5 cr)

Code: LL00CP45-3008

General information


Enrollment

20.08.2018 - 07.09.2018

Timing

03.09.2018 - 31.12.2018

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

Seats

12 - 50

Degree programmes

  • Degree Programme in Logistics

Teachers

  • Marika Höglund

Teacher in charge

Marika Höglund

Groups

  • LOKT18SP

Objective

You know how to use the information technologies and networks of your university.
You are able to apply information technologies in processes related to supply chains.
You know how to use word processing, spreadsheet, and presentation graphics software for the purposes of your business 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 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?

Location and time

Word: How do you make a character and paragraph formatting? How do you make page settings? How do you add and format the pictures,
WordArt, and SmartArt objects? How to column the text and creating and formatting tables, and how to use tabs? How are you using, creating and formatting styles? How do you create a document based on the template documentation? How do you create and format a table of contents and table of references? How you divide your document into sections?

Excel: How to create a table, and you format it, as well as the contents of a cell? How do you use functions, and create formulas? How do you
make the relative and absolute cell reference, and how to use them effectively in the spreadsheet? How do you add the workbook with charts, a
combination of charts and how to format them? How do you work with (move, copy, delete, rename, hide, protect, formatting) tables in the
workbook? How do you sort and filter large tables? How do you use the lookup-, if-, sum.if-, count.if-, and count.a - functions, as well as you do
multi-launching drop lists? How to use conditional formatting in order to clarify the readability of the table?

PowerPoint: How do you do to display the slide show, you take advantage of themes and format them? How to take advantage of a variety
of slide design templates? How do you make a non-stop, as well as the general public held presentations?
How to embed and link to information about the Office-from one program to another?

Teaching methods

Scheduled track:
Word: How do you make a character and paragraph formatting? How do you make page settings? How do you add and format the pictures,
WordArt, and SmartArt objects? How to column the text and creating and formatting tables, and how to use tabs? How are you using, creating and formatting styles? How do you create a document based on the template documentation? How do you create and format a table of contents and table of references? How you divide your document into sections?

Excel: How to create a table, and you format it, as well as the contents of
a cell? How do you use functions, and create formulas? How do you make the relative and absolute cell reference, and how to use them effectively
in the spreadsheet? How do you add the workbook with charts, a combination of charts and how to format them? How do you work with
(move, copy, delete, rename, hide, protect, formatting) tables in the workbook? How do you sort and filter large tables? How do you use the
lookup-, if-, sum.if-, count.if-, and count.a - functions, as well as you do multi-launching drop lists? How to use conditional formatting in order to
clarify the readability of the table?

PowerPoint: How do you do to display the slide show, you take advantage of themes and format them? How to take advantage of a variety of slide design templates? How do you make a non-stop, as well as the general public held presentations? How to embed and link to information about the Office-from one program
to another?

Independent track:
Word: How do you make a character and paragraph formatting? How do you make page settings? How do you add and format the pictures,
WordArt, and SmartArt objects? How to column the text and creating and formatting tables, and how to use tabs? How are you using, creating and formatting styles? How do you create a document based on the template documentation? How do you create and format a table of contents and table of references? How you divide your document into sections?

Excel: How to create a table, and you format it, as well as the contents of a cell? How do you use functions, and create formulas? How do you
make the relative and absolute cell reference, and how to use them effectively in the spreadsheet? How do you add the workbook with charts, a
combination of charts and how to format them? How do you work with (move, copy, delete, rename, hide, protect, formatting) tables in the
workbook? How do you sort and filter large tables? How do you use the lookup-, if-, sum.if-, count.if-, and count.a - functions, as well as you do
multi-launching drop lists? How to use conditional formatting in order to clarify the readability of the table?

PowerPoint: How do you do to display the slide show, you take advantage of themes and format them? How to take advantage of a variety
of slide design templates? How do you make a non-stop, as well as the general public held presentations?
How to embed and link to information about the Office-from one program to another?

Blended track:
Word: How do you make a character and paragraph formatting? How do you make page settings? How do you add and format the pictures,
WordArt, and SmartArt objects? How to column the text and creating and formatting tables, and how to use tabs? How are you using, creating and formatting styles? How do you create a document based on the template documentation? How do you create and format a table of contents and table of references? How you divide your document into sections?

Excel: How to create a table, and you format it, as well as the contents of a cell? How do you use functions, and create formulas? How do you
make the relative and absolute cell reference, and how to use them effectively in the spreadsheet? How do you add the workbook with charts, a
combination of charts and how to format them? How do you work with (move, copy, delete, rename, hide, protect, formatting) tables in the
workbook? How do you sort and filter large tables? How do you use the lookup-, if-, sum.if-, count.if-, and count.a - functions, as well as you do
multi-launching drop lists? How to use conditional formatting in order to clarify the readability of the table?

PowerPoint: How do you do to display the slide show, you take advantage of themes and format them? How to take advantage of a variety
of slide design templates? How do you make a non-stop, as well as the general public held presentations?
How to embed and link to information about the Office-from one program to another?

Completion alternatives

Word: How do you make a character and paragraph formatting? How do you make page settings? How do you add and format the pictures,
WordArt, and SmartArt objects? How to column the text and creating and formatting tables, and how to use tabs? How are you using, creating and formatting styles? How do you create a document based on the template documentation? How do you create and format a table of contents and table of references? How you divide your document into sections?

Excel: How to create a table, and you format it, as well as the contents of a cell? How do you use functions, and create formulas? How do you
make the relative and absolute cell reference, and how to use them effectively in the spreadsheet? How do you add the workbook with charts, a
combination of charts and how to format them? How do you work with (move, copy, delete, rename, hide, protect, formatting) tables in the
workbook? How do you sort and filter large tables? How do you use the lookup-, if-, sum.if-, count.if-, and count.a - functions, as well as you do
multi-launching drop lists? How to use conditional formatting in order to clarify the readability of the table?

PowerPoint: How do you do to display the slide show, you take advantage of themes and format them? How to take advantage of a variety
of slide design templates? How do you make a non-stop, as well as the general public held presentations?
How to embed and link to information about the Office-from one program to another?

Evaluation scale

1-5

Assessment criteria, good (3-4)

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