Study Guide

Objective

Hallitset tietokoneesi (windows) peruskäytön ja tietojen hallinnan, tietoturva huomioiden. Osaat hyödyntää Xamkin oppimisympäristöjä ja työryhmäohjelmistoja opiskelussasi.
Opit tekstinkäsittelyn, taulukkolaskennan ja esitysgrafiikan peruskäytön ja osaat hyödyntää niitä tarkoituksenmukaisesti opiskelussasi ja työryhmätyöskentelyssä.
Kykenet kehittämään omia tietoteknisiä perusvalmiuksiasi tulevaisuutta ajatellen.

Content

Miten käytät tietokonettasi opiskelussa? Miten huolehdit tietoturvasta?
Miten Xamkin oppimisympäristöjä ja työryhmä- sekä viestintäsovelluksia käytetään?
Miten tekstinkäsittely-, taulukkolaskenta- ja esitysgrafiikkaohjelmistoja käytetään ja sovelletaan
tarkoituksenmukaisesti erilaisten dokumenttien tuottamiseen, käsittelyyn, säilyttämiseen ja jakeluun?

Opiskelumateriaali

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

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? How do you take advantage of Pivot actions?
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? How do you take advantage of Pivot actions?
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? How do you take advantage of Pivot actions?
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.

Objective

Hallitset tietokoneesi (windows) peruskäytön ja tietojen hallinnan, tietoturva huomioiden. Osaat hyödyntää Xamkin oppimisympäristöjä ja työryhmäohjelmistoja opiskelussasi.
Opit tekstinkäsittelyn, taulukkolaskennan ja esitysgrafiikan peruskäytön ja osaat hyödyntää niitä tarkoituksenmukaisesti opiskelussasi ja työryhmätyöskentelyssä.
Kykenet kehittämään omia tietoteknisiä perusvalmiuksiasi tulevaisuutta ajatellen.

Content

Miten käytät tietokonettasi opiskelussa? Miten huolehdit tietoturvasta?
Miten Xamkin oppimisympäristöjä ja työryhmä- sekä viestintäsovelluksia käytetään?
Miten tekstinkäsittely-, taulukkolaskenta- ja esitysgrafiikkaohjelmistoja käytetään ja sovelletaan
tarkoituksenmukaisesti erilaisten dokumenttien tuottamiseen, käsittelyyn, säilyttämiseen ja jakeluun?

Opiskelumateriaali

Learn-alustalla ilmoitettu oppimateriaali.

Yksilölliset oppimisväylät

Kurssin toteutustavat ja arviointi ilmoitetaan Learn-alustalla.

TKI ja työelämäyhteistyö

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

Objective

Hallitset tietokoneesi (windows) peruskäytön ja tietojen hallinnan, tietoturva huomioiden. Osaat hyödyntää Xamkin oppimisympäristöjä ja työryhmäohjelmistoja opiskelussasi.
Opit tekstinkäsittelyn, taulukkolaskennan ja esitysgrafiikan peruskäytön ja osaat hyödyntää niitä tarkoituksenmukaisesti opiskelussasi ja työryhmätyöskentelyssä.
Kykenet kehittämään omia tietoteknisiä perusvalmiuksiasi tulevaisuutta ajatellen.

Content

Miten käytät tietokonettasi opiskelussa? Miten huolehdit tietoturvasta?
Miten Xamkin oppimisympäristöjä ja työryhmä- sekä viestintäsovelluksia käytetään?
Miten tekstinkäsittely-, taulukkolaskenta- ja esitysgrafiikkaohjelmistoja käytetään ja sovelletaan
tarkoituksenmukaisesti erilaisten dokumenttien tuottamiseen, käsittelyyn, säilyttämiseen ja jakeluun?

Opiskelumateriaali

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

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? How do you take advantage of Pivot actions?
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? How do you take advantage of Pivot actions?
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? How do you take advantage of Pivot actions?
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.