Information Technology (3 cr)

Objective

The students are able to use the it environment of the institution. He has the capacity to take advantage of the information technology studies and he knows how to use word processing, spreadsheet, and presentation graphics software training programmes of study.

Content

The students know how to use word processing and spreadsheet programs in the workplace and learning the necessary functions. He will be able to prepare a PowerPoint presentation. They are able to transfer data (embed/link) between the MS Office programs. The student section is used from within Microsoft Office programs in 2016.

Evaluation

Students can
- use professional vocabulary systematically.
- look for information in the key information sources of the field.
- identify interrelated tasks.
- use the key models, methods, software and techniques of the professional field.

Course material

Opettajan ilmoittama materiaali.
Moodlessa oleva kurssiaineisto.

Study forms and 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?

Timing of exams and assignments

Ilmoitetaan syksyllä 2018 kurssin Moodle -alustalla.
Tenttiin on mahdollista osallistua, kun kurssin opetus on päättynyt.

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