Information techonogy tools (5 cr)
Code: LO00CP76-3002
General information
Enrollment
15.08.2019 - 30.08.2019
Timing
01.08.2019 - 31.12.2019
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 Logistics
Teachers
- Marika Höglund
Teacher in charge
Marika Höglund
Groups
-
LOKT18SP
Objective
You have the skills to apply information technology in the logistics supply chain.
You have advanced Excel skills and you are able to effectively use interactive applications .
You know how to use Excel in the calculations necessary in your field of study.
You are able to produce and process simple digital content and you understand the importance of user's rights and licences.
You are able to choose the appropriate tool to solve a problem, solve simple problems related to the use of personal technology, and determine what skills you need to improve (problem solving).
Content
How is an embedded or linked table added to a Word document or Power Point presentation from a spreadsheet program?
How are forms created in Word?
How to insert comments in a Power Point presentation?
How to use the special functions of Excel, such as financial, logical, date and time functions?
How to utilise the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilise the Pivot tables when reporting and analysing data?
How to use Pivot table summary functions and utilise automatic calculation?
How to make and edit graphical presentations such as trend curves, combination charts and Pivot charts?
How to use the aim search and solver?
What macros are featured in Excel and how to record and utilise them?
How to protect your tables and sections of tables?
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
Qualifications
Information technology or equivalent knowledge.