Spreadsheet Calculation
| Structure Type: | Course |
|---|
| Code: | KD07BLMT123 |
|---|
| Type: | Elective |
|---|
| Level: | Bachelor |
|---|
| Credits: | 3.0 points |
|---|
| Responsible Teacher: | Heikkilä, Tarja |
|---|
| Language of Instruction: | Finnish |
|---|
Course Implementations, Planned Year of Study and Semester
| Curriculum | Semester | Credits | Start of Semester | End of Semester |
| LITAKO-2013 |
2 autumn |
3.0 |
2014-09-01 |
2014-12-31 |
| LITAKO-2014 |
2 autumn |
3.0 |
2015-08-01 |
2015-12-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.
Student's Workload
Total work load of the course: 80 h
- of which scheduled studies: 36 h
- of which autonomous studies: 44 h
Prerequisites / Recommended Optional Courses
Basics of business mathematics and basics of information 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
- Special features in the Excel
Recommended or Required Reading
- Lammi, O. Excel 2010 : laatua taulukoihin
Availability: https://plari.amkit.fi/vwebv/holdingsInfo?sk=fi_EN&bibId=97319
- Material provided by the teacher: Heikkilä, T. Taulukkolaskenta, Excel-harjoituksia 2012.
Mode of Delivery / Planned Learning Activities and Teaching Methods
Computer-based lessons and guided practice 36 h, independent work 44 h
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.
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.
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.
Assessment Methods
Computer exam 60 %, excercises 30 %, participation in lectures 10 %. Both exam and excercises must be successfully completed to receive a grade for the course. If attendance remains below 60 %, the student will not be assessed.
Work Placement
Work placement is not included in the course.
Back