Basics of Mathematics and ExcelLaajuus (3 cr)

Learning objectives

After completing the course, the student will be able to

• pose good skills and hands-on expertise in basic business mathematics tools
• know the principles of how to use excel spreadsheet
• understand and produce basic business mathematical formulas such as percentages, yields, etc.
• effectively perform and express in the standard way the basic financial and statistical functions
• understand special accounting terminology and the key figures of the hotel, restaurant and tourism industry and can put them into practical use

Contents

This course will involve the following activities

• Doing exercises involving the basic mathematical functions
• Working with and understanding Excel spreadsheets
• Applying the basic mathematical and financial functions to spreadsheets
• Working with standard business calculations and reports such as percentages, yields and the income statement
• Getting an overview through practical exercises as to how these things all interrelate

Lähtötaso ja sidonnaisuudet muihin opintojaksoihin

Basic level of English comprehension

Implementation methods, demonstration and Work&Study

Strong focus on the mathematical skills needed by managers, as well as the mathematical and technical skills needed to implement them effectively.
Focus on how to become competent user of Excel.

Assessing one’s own learning is a compulsory part of the course.

Assessment criteria - grade 1

When the implementation type of the course is CONTACT, ONLINE or BLENDED it is required that the student is present during those teaching hours that are marked in the study schedule. If you are absent more than 25 %, your grade will be lowered by one. If you are absent more than 50 %, the course is failed.

The student had as passing understanding of the mathematical and technical skills needed for managers and can to some degree understand and produce the relevant information, but with a fair number of errors.

Assessment criteria - grade 3

The student had as good understanding of the mathematical and technical skills needed for managers and can understand and produce the relevant information effectively, although with some errors.

Assessment criteria - grade 5

The student has an excellent understanding of the mathematical and technical skills needed for managers and can effectively understand and produce the relevant information with few or no errors.

Learning materials

Materials provided by teacher.