Excel Spreadsheet Calculation in Business
| Structure Type: | Course |
|---|
| Code: | KD19CNTT012 |
|---|
| Type: | Free choise |
|---|
| Level: | Bachelor |
|---|
| Credits: | 2.0 points |
|---|
| Responsible Teacher: | Mäkiniemi, Osmo |
|---|
| Teacher Team: | Mäkiniemi, Osmo |
|---|
| Language of Instruction: | English |
|---|
Course Implementations, Planned Year of Study and Semester
| Curriculum | Semester | Credits | Start of Semester | End of Semester |
| INBUS2-2015 |
4 autumn |
2.0 |
2018-08-01 |
2018-12-31 |
| INBUS2-2016 |
4 autumn |
2.0 |
2019-08-01 |
2019-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 and utilise other special features in the Excel software.
Student's Workload
- lectures and guided practice 24 h
- independent work 30 h
Prerequisites / Recommended Optional Courses
Basics of mathematics and ICT skills
Contents
- Creating and editing spreadheets with Excel
- Writing formulas and using functions
- Processing/sorting information in a spreadsheet
- Using Pivot tables
- Creating and editing graphs and charts
- Goal Seek
- Basic macros
- Special features in the Excel
Recommended or Required Reading
- material provided by the teacher
- Internet material
Mode of Delivery / Planned Learning Activities and Teaching Methods
- computer-based lessons and guided practice
- independent work
Assessment Criteria
Excellent (5)
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 (3)
The student is able to plan, implement and utilise a variety of Excel tasks. The student is able to present the results using charts and is also able to make summaries of the information in tables and utilise other special features in the Excel software.
Satisfactory (1)
The student is able to implement and utilise calculation models with some help. The student is able to present the results using basic charts and is also able to make summaries of the information in tables and utilise some other essential features in the Excel software. In this work the student needs some help.
Assessment Methods
- exam 70%
- active participation in teaching, exercises and continuous assessment 30 %
Back