Study Guide

Learning outcomes

The student is able to
- utilise essential office applications in their studies
- utilise cloud services as part of team work
- function in an online learning environment

Implementation and methods of teaching

This course is arranged only online as eLearning using Moodle and Zoom tools. Exercises and eLearning tasks are published in course Moodle.

First enrol to the course in Peppi, after teacher confirms your participation you will automatically be inserted into course Moodle.

Timing and attendance

According to TimeEdit timetable. Attending online lectures is optional.

Learning material and recommended literature

Office 2016 series (or newer). e-Learning materials given during the course.

Exam retakes

Two retake exams.

Learning environment

Moodle eLearning platform.

Student time use and work load

5 ECTS credits are approximately 135 hours of work.

Contents

Word processing standard layout of documents, styles, LAB report writing guidelines.

Basic usage of MS Word.

Create professional looking presentations with MS PowerPoint, set timings and other presentation settings. Presenter tools while giving a presentation.

Creating spreadsheets with MS Excel. Autosum and other basic functions (SUM, AVERAGE, COUNT, MIN, MAX), copy formula to other rows/columns/worksheets, absolute cell reference, create time series, conditional formatting, create and edit charts, conditional calculation functions (IF, COUNTIF, SUMIF), date and time functions, lookup functions, sort and filter data, Pivot tables and charts.

Additional information for students: previous knowledge etc.

Not needed.

Assessment criteria

Weekly exercises, assignments and Excel exam.

Assessment scale

1-5

Failed (0)

Failed. Student failes to submit exercises on time or failes too many of them.

Assessment criteria: level 1 (assessment scale 1–5)

Knowledge

Student can name and recall course content information. Student is aware of how to work with basic application exercises.

Assessment criteria: level 3 (assessment scale 1–5)

Analysis skills

Student can see and analyze relationships of topics. Student knows how to implement exercises skillfully and apply skills in business related situations.

Assessment criteria: level 5 (assessment scale 1–5)

Evaluation skills

Student can make well-founded judgements on topics and support them. Student has mastery skills in implementing exercises. Student can estimate and choose how to apply skills for business life needs.