Study Guide

Objective

The student is able to use all the essential systems for studying. The student also knows how to effectively use various tools for assignments, meetings and collaborative team work.

Content

- The essential of Turku UAS study environment
- managing and chairing team meetings
- basics of editing images and videos for digital portfolios, creating and publishing different portfolios and learning diaries
- creating and managing various business documents and reports
- essential information security practices

Materials

Koch, J. & Karjalainen, O. (2016). Office 2016 & Office 365: Word, Excel, PowerPoint & Outlook. Jyväskylä: Docendo Oy.
Office 365 For Dummies. (2022)
e-book can be found in Finna.
All material that microsoft youtube channel offers

Teaching methods

Flipped learning, Groupwork, Weekly reading/video teaching material go thorough task.
Attending lecture is mandatory. If student cant attend S/he will be responsibility to get familiar subject that are covered in class. Its learning and fellow students will be resources turn to.

Exam schedules

Final exam will be held at last scheduled f-to-f class.

Student workload

130-140h student workload
16h f-to-f
100h weekly assignments and go through tasks(including prepearing final exam)
4h Finals

Content scheduling

Students will get familiar up-to-date office setting tools that will help them
-give presentation, record and share instructions and information
-Write proper reports
-gather and interpret data
-read and search info about subject matter
-Precedence similar skills as digistart course gives. You need to show digistart padge 3 weeks after course has started
-Academic work
Tools: Excel, Word, Powerpoint and youtube.
Exact information about skills that you need to know will be presented in course platform its:
Here is example of skills in Microsoft Word that you need to know how to do. Skillset differs with program.
Word:
Entering Text and Using Headings tekstin kirjoittaminen
Pasting Text into the Document tekstin liittäminen
Formatting Headings and Document otsikkotasojen muokkaus
List Markers and Numbering
Basic Formatting and Keyboard Shortcuts näppäimistön pikanäppäimet ja muotoilu
Hanging Indent and the Ruler sisennys ja riippuva sisennys
Copying and Deleting Formatting Kumoa ja uudelleenkumoa
Search and Replace etsi ja korvaa
Adding Images kuvan lisäys ja kuvan asemointi
Image Layout and Editing
Table taulukko
Desktop Version and Web Version selaimen päällä toimiva ohjelmisto ja itse ohjelma
Navigation in a Long Document and Arranging its Parts
Page Numbers sivunumerointi ja kokonaissivunumerointi
Table of Contents sisällysluettelo
Cover Page etusivu
WWW Links www-linkit
Cross References viittaus
Horizontal Page and Document Sections sivun asettelu (vaaka ja dokumentin meta-tiedot)
Header and Footer ala- ja ylätunniste
Saving a Document as a PDF-Document muuntaminen pdf-formaattiin ja muut mahdolliset formaatit
Columns Layout taulukko ja sen muokkaus
Excel:
Entering Data and Data Types
Selecting and Editing Ranges
Formatting Table
Calculations
Relative and Absolute References
Charts
Printing
Basic Calculations and Absolute Reference
Excel advance:
Sheets of Workbook
Editing Multiple Sheets at a Time
Calculations between the Sheets
Conditional Formatting
Mixed References
Functions
IF Function
Nested Functions
VLOOKUP Function
XLOOKUP Function
Editing of Large Material
Quick Fill
The Table
Calculations in a Table
Summaries in a Table
Sorting a Table
Filtering a Table
Pivot Table
Updating a Pivot Table
Formatting a Pivot Table
Subtotals and Summaries in a Pivot Table
Multiple Value Fields in a Pivot Table
Sorting a Pivot Table
Grouping a Pivot Table
Pivot Chart
Powerpoint basics:
The Structure of a PowerPoint Presentation
Text
Images
Table
Importing a Table from Excel
Creating a Chart
Importing a Chart from Excel
Printing Options
Powerpoint advance:
Recipes for a Good Presentation
SmartArt Graphics
Converting Text to SmartArt
SmartArts with Images
Make the Presentation More Interesting with a Video
Adding a YouTube Video to a Presentation
Dividing the Presentation into Sections
Performing in front of an Audience
Tools for Presenting
Advance Powerpoint too:
Editing and Designing the Appearance of the Presentation
Freehand Drawing
Drawing with Shapes
Screenshot
Importing Slides into a Presentation
Transitions and Animations
Screen Capture Video
Creating a Video Presentation
Options for saving

Further information

All communication will be in itslearning environment.
No need to communicate to teacher when you are sick.

Evaluation scale

H-5

Assessment methods and criteria

Final exam. Student attendance at lectures. Homework.
Word, Powerpoint, Excel skills are evaluated in final exam.
Final exam will be held 3.12.2024
And Final exam retake is 10.12.24
(if participants also 12.12.24)

Assessment criteria, fail (0)

Less that 48% of points in final exam OR
30% or more absence to f-to-f classes

Assessment criteria, satisfactory (1-2)

Final exam 48% points gives you 1

Assessment criteria, excellent (5)

Final exam 92% or more points in final exam.
12% or less absence.