Study Guide

Objectives (course unit)

Students acquire a thorough understanding of office programs in Microsoft Word, PowerPoint, and Excel. Excel is used to learn, in addition to conventional usage, how to convert numbers from a human-understood form to a computer-understood form and vice versa, as well as logical reasoning.

Content (course unit)

- Producing a Word document
- Producing a PowerPoint presentation
- Excel tasks: table presentation, cell coordinates, calculation, references (relative, mixed, absolute), functions, diagrams
- Conversion of numbers between 2, 10 and 16 systems, IF, AND and OR functions, 1=TRUE, 0=FALSE,
application, e.g., in subnet masks and data network configurations.

Assessment criteria, satisfactory (1-2) (course unit)

Grade 1:
Students have verified their skills in both Word, PowerPoint and Excel by receiving an approved assessment for all three office programs.
The total score is 50 - 59 % of the maximum.

Grade 2:
Students have verified their skills in both Word, PowerPoint and Excel by receiving an approved assessment for all three office programs.
The total score is 60 - 69 % of the maximum.

Assessment criteria, good (3-4) (course unit)

Grade 3:
Students have verified their skills in both Word, PowerPoint and Excel by receiving an approved assessment for all three office programs.
The total score is 70 - 79 % of the maximum.

Grade 4:
Students have verified their skills in both Word, PowerPoint and Excel by receiving an approved assessment for all three office programs.
The total score is 80 - 89 % of the maximum.

Assessment criteria, excellent (5) (course unit)

Grade 5:
Students have verified their skills in both Word, PowerPoint and Excel by receiving an approved assessment for all three office programs.
The total score is 90 - 100 % of the maximum.

Assessment criteria, pass/fail (course unit)

Fail
The student will fail the course if any of the following criteria is met:
-Word skills are less than half the required level.
or
-PowerPoint skills are less than half the required level
or
-Excel skills are less than half the required level.

Location and time

Summer implementation, in network.

Exam schedules

No final exam

Assessment scale

0-5

Teaching methods

A nonstop self-study course between the start and ending dates of the course.
Includes necessary learning materials, independent exercises and instructional videos, as well as assignments to be uploaded to the assignment folders.
The materials and assignments can be found in TUNI Moodle learning platform: https://moodle.tuni.fi.

Learning materials

All on Moodle platform.

Student workload

80 h of students's work.

Completion alternatives

N/A

Practical training and working life cooperation

N/A

International connections

N/A