ICT Tools (5cr)

Evaluation scale

H-5

Content scheduling

The starting hours of the course are in week 36 and the exam in week 50.

An extensive package of instructions and help has been prepared for the Itslearning learning environment to support your studies. Independent study is supported by themed weekly guidance meetings with the teacher.

Schedule:
• week 36: Introduction to the course, choosing the time zone and location settings, the institution's IT systems, saving and using MS Onedrive
• week 37: Basic word processing and getting to know Word MS Word
• week 38: Using styles and layouts in MS Word
• week 39: Getting to know the ready-made document template/report of the UMK in MS Word
• week 40: Word test
• week 41: Basics of spreadsheets in MS Excel
• week 42: Holiday
• week 43: Spreadsheets and cell formatting in MS Excel
• week 44: Working with spreadsheets in MS Excel
• week 45: Basics of visualization: Creating charts in MS Excel
• week 46: Using PowerPoint and the UMK template, features of a good presentation
• week 47: Working on your own PowerPoint presentation in cooperation with the Intro to Higher Education course
• Week 48: Introduction to Matlab with the Onramp course
• Week 49: Basic use of Matlab in cooperation with the Intro to Mathematical Subjects course
• Week 50: Introduction to Matlab simulations, recording of the Onramp certificate and checking the course score

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

Instructional videos and other electronic learning material linked to the learning environment.

Teaching methods

The course is based on the student's active self-study through exercises. The teacher organizes weekly meetings where the theoretical content and students' questions about the topic of the week are reviewed. Attendance and exercises earn points for the course grade. Attendance is mandatory.

Exam schedules

The test measuring Word skills week 40-41.
Retest at a separately announced time.

Pedagogic approaches and sustainable development

Learning-by-doing, supporting learning and flipped learning

Learning is based on the student's own active participation and completion.
The student is given independent assignments and material to support their performance on the studied subjects.

The skills learned in the course are basic skills needed in studies and working life, and they lead to a sustainable lifestyle by studying remote connection usage and optimization.

The evaluation is based on completed tasks and demonstration of competence in the exam.

Completion alternatives

If you already have strong information technology skills from university level, come and present the certificates from the course and talk to the teacher -> Completing the review assignments and the exam independently may be possible.

Student workload

5 credits = 135 h of student work, divided into independent tasks, meetings and final exam.
- Meetings 40 h
- Tasks related to meetings 36 h
- Review assignments and review for the exam 24 hours
- Demonstration test 2 h
- Preparing a PowerPoint presentation 6 h
- Matlab Onramp 27 h

Tasks to be evaluated
- Weekly assignments that can be used to collect points for the course grade
- Compulsory revision tasks in MS Word and Excel
- Final assignment on presentation graphics (MS PowerPoint)
- Final exam on word processing (MS Word) and spreadsheets (MS Excel)
- Matlab Onramp Cource (MathWorks)

Evaluation methods and criteria

The Word proficiency test to be taken in weeks 40-41 must score at least 20 points, and the Excel tasks completed during the course must score more than half of the points (min 25 points). Additional requirements for passing include completing the Matlab Onramp course and presenting a PowerPoint or similar presentation according to the instructions.
The course grading scale is published at the start of the course.

Failed (0)

The student has not successfully attended the lectures, completed the Word test and done mandatory weekly assignments.

Assessment criteria, satisfactory (1-2)

Half of the points in the Word test and half of the total points in the Excel exercises are required for grade 1. Other grades are determined on a linear scale.

Attendance and Word tasks points are taken into account in the evaluation. (Preliminary scoring)

Number 1 course points 50-59
Number 2 course points 60-69

Assessment criteria, good (3-4)

Number 3 course points 70-79
Number 4 course points 80-89

Assessment criteria, excellent (5)

Number 5 requires at least 90 course points.

Further information

The teacher sends the most important announcements of the course by e-mail. Contact the teacher by email (aaro.mustonen@turkuamk.fi). Information related to lessons in Itslearning. Announcements related to the course in itslearning on the Course Overview page.

AvoinAMK 3 places.