Spreadsheet calculation for the purposes of working life
| Structure Type: | Course |
|---|
| Code: | KD07BLMT122 |
|---|
| Type: | Elective |
|---|
| Level: | Bachelor |
|---|
| Credits: | 3.0 points |
|---|
| Responsible Teacher: | Laine, Päivö |
|---|
| Teacher Team: | Heikkilä, Tarja |
|---|
| Language of Instruction: | Finnish |
|---|
Learning Outcomes
Students are able to plan, implement and use various calculation models and graphically present the results. Students are also able to make summaries of the information in charts, filter information ,and use the various functions and other special features in the Excel software.
Student's Workload
- lessons and guided practice 36 h
- independent work 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 charts
- Creating and editing graphs and charts
- Printing
- Special Excel functions
Recommended or Required Reading
- Lammi, O. Excel 2010.
- teacher's material
Mode of Delivery / Planned Learning Activities and Teaching Methods
- Lectures in the computer room and guided practice
- Independent practice
Assessment Criteria
Will be announced at the beginning of the course.
Assessment Methods
Assessment is based on the computer-based exam and Excel exercises.Both parts must be passed acceptably:
- computer-based exam 60 %
- exercises and participation in classes 40 %
The course is assessed only if participation is more than 50 %.
Further Information
The course accrues 2 R&D credits.
Back