Skip to main content

Information technology tools 2Laajuus (5 cr)

Code: LO00EB49

Credits

5 op

Objective

You know how to use the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

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 utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize 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?
How do you calculate the clock times? How to protect your tables and sections of tables?

Qualifications

Information technology tools 1 or equivalent knowledge.

Enrollment

04.11.2024 - 17.11.2024

Timing

01.01.2025 - 30.04.2025

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
Seats

20 - 40

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

Marika Höglund

Groups
  • LLKT24SV
    Business Logistics, online studies

Objective

You know how to use the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

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 utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize 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?
How do you calculate the clock times? How to protect your tables and sections of tables?

Opiskelumateriaali

The teacher as reported by the material.

Yksilölliset oppimisväylät

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?

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.

Qualifications

Information technology tools 1 or equivalent knowledge.

Enrollment

04.11.2024 - 17.11.2024

Timing

01.01.2025 - 30.04.2025

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

20 - 40

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 the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

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 utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize 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?
How do you calculate the clock times? How to protect your tables and sections of tables?

Opiskelumateriaali

The teacher as reported by the material.

Yksilölliset oppimisväylät

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?

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.

Qualifications

Information technology tools 1 or equivalent knowledge.

Enrollment

04.11.2024 - 17.11.2024

Timing

01.01.2025 - 31.05.2025

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 - 40

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 the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

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 utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize 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?
How do you calculate the clock times? How to protect your tables and sections of tables?

Opiskelumateriaali

The teacher as reported by the material.

Yksilölliset oppimisväylät

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?

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.

Qualifications

Information technology tools 1 or equivalent knowledge.

Enrollment

06.11.2023 - 17.11.2023

Timing

01.01.2024 - 30.04.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 - 60

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

Anssi Salmi

Groups
  • LOKT23SP
    Logistics, full-time studies

Objective

You know how to use the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

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 utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize 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?
How do you calculate the clock times? How to protect your tables and sections of tables?

Opiskelumateriaali

The teacher as reported by the material.

Yksilölliset oppimisväylät

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?

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.

Qualifications

Information technology tools 1 or equivalent knowledge.

Enrollment

06.11.2023 - 17.11.2023

Timing

01.01.2024 - 30.04.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
Seats

0 - 50

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 the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

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 utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize 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?
How do you calculate the clock times? How to protect your tables and sections of tables?

Opiskelumateriaali

The teacher as reported by the material.

Yksilölliset oppimisväylät

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?

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.

Qualifications

Information technology tools 1 or equivalent knowledge.

Enrollment

06.11.2023 - 17.11.2023

Timing

01.01.2024 - 30.04.2024

Number of ECTS credits allocated

5 op

Virtual portion

4 op

Mode of delivery

20 % Contact teaching, 80 % Distance learning

Unit

Department of Logistics and Marine Technology

Campus
  • Kotka Campus
  • Ecampus
Teaching languages
  • Finnish
Seats

20 - 60

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 the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

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 utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize 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?
How do you calculate the clock times? How to protect your tables and sections of tables?

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

Qualifications

Information technology tools 1 or equivalent knowledge.

Enrollment

07.11.2022 - 18.11.2022

Timing

10.01.2023 - 07.05.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
  • LOKT22SM
    Logistics, part-time studies

Objective

You know how to use the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

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 utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize 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?
How do you calculate the clock times? How to protect your tables and sections of tables?

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

Qualifications

Information technology tools 1 or equivalent knowledge.

Enrollment

07.11.2022 - 18.11.2022

Timing

01.01.2023 - 01.05.2023

Number of ECTS credits allocated

5 op

Virtual portion

4 op

Mode of delivery

20 % Contact teaching, 80 % 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 the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

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 utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize 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?
How do you calculate the clock times? How to protect your tables and sections of tables?

Opiskelumateriaali

The teacher as reported by the material.

Yksilölliset oppimisväylät

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?

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.

Qualifications

Information technology tools 1 or equivalent knowledge.

Enrollment

07.11.2022 - 18.11.2022

Timing

01.01.2023 - 01.05.2023

Number of ECTS credits allocated

5 op

Virtual portion

3 op

Mode of delivery

40 % Contact teaching, 60 % 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
  • LOKT22SP
    Logistics, full-time studies

Objective

You know how to use the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

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 utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize 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?
How do you calculate the clock times? How to protect your tables and sections of tables?

Opiskelumateriaali

The teacher as reported by the material.

Yksilölliset oppimisväylät

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?

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.

Qualifications

Information technology tools 1 or equivalent knowledge.

Enrollment

08.11.2021 - 21.11.2021

Timing

03.01.2022 - 21.04.2022

Number of ECTS credits allocated

5 op

Virtual portion

3 op

Mode of delivery

40 % Contact teaching, 60 % 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

Virpi Aalto

Groups
  • LOKT21SM
    Logistics, part-time studies

Objective

You know how to use the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

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 utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize 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?
How do you calculate the clock times? How to protect your tables and sections of tables?

Opiskelumateriaali

Ornanet-materiaalit, opettajan materiaali

TKI ja työelämäyhteistyö

Ilmoitetaan myöhemmin.

Further information

Avaimen Moodleen saa lähiopetustunnilla.

Evaluation scale

1-5

Qualifications

Information technology tools 1 or equivalent knowledge.

Enrollment

08.11.2021 - 21.11.2021

Timing

01.01.2022 - 01.05.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
  • Marika Höglund
Teacher in charge

Marika Höglund

Groups
  • LOKT21SP
    Logistics, full-time studies

Objective

You know how to use the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

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 utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize 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?
How do you calculate the clock times? How to protect your tables and sections of tables?

Opiskelumateriaali

The teacher as reported by the material.

Yksilölliset oppimisväylät

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?

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.

Qualifications

Information technology tools 1 or equivalent knowledge.

Enrollment

08.11.2021 - 21.11.2021

Timing

01.01.2022 - 01.05.2022

Number of ECTS credits allocated

5 op

Virtual portion

4 op

Mode of delivery

20 % Contact teaching, 80 % 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
  • LLKT21SV
    Business Logistics, online studies

Objective

You know how to use the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

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 utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize 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?
How do you calculate the clock times? How to protect your tables and sections of tables?

Opiskelumateriaali

The teacher as reported by the material.

Yksilölliset oppimisväylät

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?

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.

Qualifications

Information technology tools 1 or equivalent knowledge.