ICT Skills Follow-up Course

Structure Type: Course
Code: LTYA106
Type: Compulsory
Level: Bachelor
Credits: 3.0 points
Responsible Teacher: Palomäki, Hannu
Teacher Team: Erkkilä, Marja ; Palomäki, Hannu ; Sippola, Leo
Language of Instruction: Finnish

Course Implementations, Planned Year of Study and Semester

Curriculum  Semester  Credits  Start of Semester  End of Semester
LITAKO-2015   1 spring   3.0   2016-01-01   2016-07-31  
PK-2015   1 spring   3.0   2017-01-01   2017-07-31  
LITAKO-2016   1 spring   3.0   2017-01-01   2017-07-31  
PK-2016   1 spring   3.0   2018-01-01   2018-07-31  

Learning Outcomes

Students are able to plan, implement and utilise various calculation models. They are able to present the results graphically. Students are also able to make summaries of the information in tables, filter information and utilise other special features in the Excel software. Students can carry out internet poll and use the results in spreadsheet

Student's Workload

Total work load of the course: 82 h
- of which scheduled studies: 30 h
- of which autonomous studies: 52 h

Prerequisites / Recommended Optional Courses

Information and Communication Technology

Contents

Creating and editing spreadheets with Excel
- Writing formulae and using functions
- Processing/sorting information in a spreadsheet
- Filtering, summarising, linking
- Using Pivot tables
- Creating and editing graphs and charts
- Printing
- Goal Seek
- Creating an internet questionaire
- Special features in the Excel

Recommended or Required Reading

Will be announced at the beginning of the cource

Mode of Delivery / Planned Learning Activities and Teaching Methods

- computer-based lessons and guided practice
- independent work

Assessment Criteria

Excellent 5
The student will do the job of the course requirements perfectly. The student is able to plan independently, implement and utilise a variety of various calculation models. The student is able to present the results using excellent charts and is also able to make summaries of the information in tables, filter information and utilise very well other special features in the Excel software. Student can independently carry out internet poll and use the results in spreadsheet

Good 4-3
The student will do the job of the course requirements well. The student is able to plan, implement and utilise well a variety of various calculation models. The student is able to present the results using good charts and is also able to make summaries of the information in tables, filter information and utilise other special features in the Excel software. Student can carry out internet poll and use the results in spreadsheet

Satisfactory 2-1
The student will do the job of the course requirements successfully. The student is able to plan, implement and utilise calculation models satisfactrorily. The student is able to present the results using charts and is also able to make summaries of the information in tables, filter information and utilise some other special features in the Excel software. Student can carry out internet poll and bring the results to spreadsheet.

Assessment Methods

Computer exam 70%, excercises 30 %

Back