Professional ICT skills (0cr)

Objective

You canuse ICT applications in your studies and future work tasks individually and in teamwork.identify the policies, challenges and possibilities of the information society and the digital working environment.identify ICT systems in your field of study and understand the role of information and information systems in organizationsidentify the importance of information security and know how to improve information securityprotect personal information and devices and understand the health and environment effects of technologyassess and select the most suitable method and solve problems related to your personal use of technology understanding your development needs

Content

What and how ICT applications are used in studies and work? What are information society and digital working environment and how do they function? What are the possibilities and challenges in applications of information and communication technology? What is information security and how to act securely in studies and work?

Course material

Opettajan ilmoittama materiaali.

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 create a formulas in Word applications
feature? How to column the text and creating and formatting
tables, and how to use tabs? How are you using, creating and formatting
styles? How do you create a document based on the template documentation?
How do you create and format a table of contents and table of references?
How you divide your document into sections?
Excel: How to create a table, and you format it, as well as the contents of
a cell? How do you use functions, and create formulas? How do you
make the relative and absolute cell reference, and how to use them effectively
in the spreadsheet? How do you add the workbook with charts, a
combination of charts and how to format them? How do you work with
(move, copy, delete, rename, hide, protect, formatting) tables in the
workbook? How do you sort and filter large tables? How do you use the
lookup-, if-, sum.if-, count.if-, and count.a - functions, as well as you do
multi-launching drop lists? How to use conditional formatting in order to
clarify the readability of the table?
PowerPoint: How do you do to display the slide show, you take advantage
of themes and format them? How to take advantage of a variety
of slide design templates? How do you add animations, videos, and audio
to your presentation? How do you make a non-stop, as well as the
general public held presentations?
How to embed and link to information about the Office-from one program
to another?

Independent track:
Word: How do you make a character and paragraph formatting? How do
you make page settings? How do you add and format the pictures,
WordArt, and SmartArt objects? How to create a formulas in Word applications
feature? How to column the text and creating and formatting
tables, and how to use tabs? How are you using, creating and formatting
styles? How do you create a document based on the template documentation?
How do you create and format a table of contents and table of references?
How you divide your document into sections?
Excel: How to create a table, and you format it, as well as the contents of
a cell? How do you use functions, and create formulas? How do you
make the relative and absolute cell reference, and how to use them effectively
in the spreadsheet? How do you add the workbook with charts, a
combination of charts and how to format them? How do you work with
(move, copy, delete, rename, hide, protect, formatting) tables in the
workbook? How do you sort and filter large tables? How do you use the
lookup-, if-, sum.if-, count.if-, and count.a - functions, as well as you do
multi-launching drop lists? How to use conditional formatting in order to
clarify the readability of the table?
PowerPoint: How do you do to display the slide show, you take advantage
of themes and format them? How to take advantage of a variety
of slide design templates? How do you add animations, videos, and audio
to your presentation? How do you make a non-stop, as well as the
general public held presentations?
How to embed and link to information about the Office-from one program
to another?

Blended track:
Word: How do you make a character and paragraph formatting? How do
you make page settings? How do you add and format the pictures,
WordArt, and SmartArt objects? How to create a formulas in Word applications
feature? How to column the text and creating and formatting
tables, and how to use tabs? How are you using, creating and formatting
styles? How do you create a document based on the template documentation?
How do you create and format a table of contents and table of references?
How you divide your document into sections?
Excel: How to create a table, and you format it, as well as the contents of
a cell? How do you use functions, and create formulas? How do you
make the relative and absolute cell reference, and how to use them effectively
in the spreadsheet? How do you add the workbook with charts, a
combination of charts and how to format them? How do you work with
(move, copy, delete, rename, hide, protect, formatting) tables in the
workbook? How do you sort and filter large tables? How do you use the
lookup-, if-, sum.if-, count.if-, and count.a - functions, as well as you do
multi-launching drop lists? How to use conditional formatting in order to
clarify the readability of the table?
PowerPoint: How do you do to display the slide show, you take advantage
of themes and format them? How to take advantage of a variety
of slide design templates? How do you add animations, videos, and audio
to your presentation? How do you make a non-stop, as well as the
general public held presentations?
How to embed and link to information about the Office-from one program
to another?

Timing of exams and assignments

5.2.2018, 23.4.2018, 24.9.2018, 3.12.2018

Evaluation scale

1-5

Assessment criteria, good (3)

Students can a. use professional ICT vocabulary systematically b. look for information in the key information sources of the field. c. identify interrelated ICT tasks e. use the key methods, software and techniques of the information and communication technology.

Assessment criteria, good (3-4)

3 e. Students can use the key models, methods, software and techniques
of the professional field

Qualifications

No prerequisites