Study Guide

Objective

The student is able to create documents with office applications backup and restore documents select when to use word processing, spreadsheet calculations in MS Excels, handling long spreadsheets in MS Excel, use of PowerPoint and AMK model, getting to know the Matlab program, basic use of the Matlab software in cooperation with the Intro to Mathematical Subjects course and Matlab simulations.

Content

• Presentation of the course, educational institution's IT systems, saving and using MS Onedrive
• Basic text processing and document standard MS Word
• More demanding word processing and familiarization with ready-made document templates in MS Word, Publication-level writing in MS Word
• Basics of spreadsheet calculations in MS Excel
• Spreadsheet MS Excel: multi-format calculation
• Handling long spreadsheets in MS Excel
• Use of PowerPoint and AMK model, features of a good presentation
• Working on your own presentation in collaboration with the Intro to higher education course
• Getting to know the Matlab program
• Basic use of the Matlab software in cooperation with the Intro to Mathematical Subjects course
• Matlab simulations
• Matlab advanced features
• Review lessons and final exam in the auditorium

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
Eduhouse

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
Digistart badge is mandatory to return(itslearning) after 2w from start of the course.
If student fails to return badge before due date student will be removed from the course(fail).

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.
Digistart badge is mandatory to return(itslearning) after 2w from start of the course.
If student fails to return badge before due date student will be removed from the course(fail).

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.