Olet täällä

Basics of Business Mathematics (excel)

Basics of Business Mathematics (excel)

Code: SOC1RB004
Extent: 4 ECTS (108 h)
Timing: Semester 1-2
Language: English
Level:  Basic studies
Type: Compulsory

Prerequisites
No

Learning outcomes
The main objective of the course is to introduce the student to business mathematics concepts and improve student’s calculation skills. Exercises made by excel spreadsheet are included in the course. In addition, the student will be introduced to special accounting terminology used in the hotel, restaurant and tourism industry.
Upon successful completion of the course, the student
• Possesses good skills and hands-on expertise in basic business mathematics tools
• Knows the principles of how to use excel spreadsheets
• Understands the key figures of the hotel, restaurant and tourism industry and can put them into practical use
• Has a broad knowledge of how to implement basic financial calculations by spreadsheet

Course contents
• Percentage calculations
• Simple interest calculations
• Compound interest calculations
• Time value of money
• Use of Excel spreadsheets
• Applications of business mathematics in the hospitality industry

Cooperation with the business community and other organizations
Applications are taken from hospitality industry.

Teaching and learning methods
It is possible to complete the course based on classroom learning or part time learning:

a) Classroom learning:
Lectures and Examination 32 h
Self-studies 75 h
The own learning assessment 1 h

b) Part Time Learning:
Lectures and Examination 12 h
Self-studies 95 h
The own learning assessment 1 h

Studies include mainly practical exercises done excel spreadsheet.

Identifying and acknowledging previously acquired skills (in Finnish AHOT)
Courses or parts of courses at other educational institutes or work experience are not accredited as such towards the HAAGA-HELIA studies directly, but the required skills and competences are demonstrated by a skills examination.

Teacher with the main responsibility for the course
Hanna Moisio, Haaga

Course materials
Gaulter.B., Buchanan.L. 2001. Modular mathematics for GCSE. Oxford University Press. Oxford
Pulkkinen.P., Holopainen.M., Keinänen.K. 2001. Business mathematics. Care & Share. Kuopio
Lecture material

Assessment
Examination 100 %

The own learning assessment assignment does not impact your grade. The
assignment is the same for all courses/modules and your answers will be used
also for course/module development. The assignment is completed online in
WinhaOpaali.

Assessment objects

• Percentage calculations
• Simple interest calculations
• Compound interest calculations
• Use of Excel spreadsheets

Assessment criteria

Grade 1
The student masters the essential aspects of business mathematics and the basic use of Excel spreadsheets with assistance. With given instructions, the student has the ability to perform basic tasks, but needs a lot of guidance.

Grade 3
The student masters the essential aspects of business mathematics and the basic use of Excel spreadsheets. With given instructions, the student will be able to perform basic tasks.

Grade 5
The student masters the essential aspects of business mathematics and the use of Excel spreadsheets independently. The student has the ability to apply the knowledge and skills learned.