Spreadsheet calculation for financial management
| Structure Type: | Course |
|---|
| Code: | KD07CHMA212 |
|---|
| Type: | Elective |
|---|
| Level: | Bachelor |
|---|
| Credits: | 3.0 points |
|---|
| Responsible Teacher: | Laine, Päivö |
|---|
| Teacher Team: | Heikkilä, Tarja |
|---|
| Language of Instruction: | Finnish |
|---|
Learning Outcomes
Students will be able to plan, implement and utilise various calculation models. They will be able to present the results graphically. Students will also be able to make summaries of the information in tables, filter information and utilise 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
- Using Excel software for invoicing, payroll, taxation, credits, budgets, investments, etc.
- Excel functions, Pivot charts, databases, Goal Seek
Recommended or Required Reading
- Lammi, O. Excel 2010.
- material provided by the teacher: Heikkilä, T. Taulukkolaskenta, Excel-harjoituksia 2011.
Mode of Delivery / Planned Learning Activities and Teaching Methods
- computer-based lessons and guided practice
- independent work
Assessment Criteria
Will be announced at the beginning of the course.
Assessment Methods
Assessment is based on a computer exam and Excel exercises: computer exam 60 %, excercises and participation in lectures 40 %. Both parts must be successfully completed to receive a grade for the course. If attendance remains below 50 %, the student will not be assessed.
Further Information
The course accrues 2 R&D credits
Back