Skip to main content

Information technology (5 cr)

Code: LL00CP45-3007

General information


Enrollment

20.08.2018 - 07.09.2018

Timing

03.09.2018 - 14.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

  • Virpi Aalto

Teacher in charge

Virpi Aalto

Groups

  • LOKT18SM

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 create a formulas in Word applications
feature? 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 add animations, videos, and audio
to your presentation? 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 create a formulas in Word applications
feature? 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 add animations, videos, and audio
to your presentation? 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 create a formulas in Word applications
feature? 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 add animations, videos, and audio
to your presentation? 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 create a formulas in Word applications
feature? 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 add animations, videos, and audio
to your presentation? 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 create a formulas in Word applications
feature? 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 add animations, videos, and audio
to your presentation? 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