Business mathematics and ExcelLaajuus (5 cr)
Code: KH00BS84
Credits
5 op
Objective
The student can apply the methods of business mathematics to evaluate the financial problems in decision making using Excel.
Content
Percentages and index numbers
• Simple interest and applications such as short term loans
• Compound interest and discounting
-excel spreadsheet
Enrollment
30.05.2024 - 15.09.2024
Timing
02.09.2024 - 18.12.2024
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
Seats
0 - 50
Degree programmes
- Degree Programme in Business Logistics
Teachers
- COS Opettaja
- Virpi Raivonen
Groups
-
PLILOS24APLILOS24A
-
PLILOS24BPLILOS24B
Objective
The student can apply the methods of business mathematics to evaluate the financial problems in decision making using Excel.
Content
Percentages and index numbers
• Simple interest and applications such as short term loans
• Compound interest and discounting
-excel spreadsheet
Materials
Kurssisivuston materiaali ja tehtävät
Tukimateriaalia:
Sekä normi- että E-kirjana
1)Saaranen, P. (2016). Liike-elämän matematiikka (11., uudistettu painos.). Helsinki: Edita.
2)Cleaves, C., Hobbs, M. & Noble, J. (2012). Business math (9th ed., brief ed.). Upper Saddle River: Prentice Hall.
3) Optimi : matematiikkaa talouselämän ammattilaisille / Leila Karjalainen.
4) Business math for dummies / by Mary Jane Sterling. (E-kirjana)
Nettisivustot:
Opetus-TV
Matikkamatskut
Mordelius Academy
Eduhousen Excelin kursseja kertaamiseen
Teaching methods
Learning by doing
Opiskelijan olemassa oleva osaamisen ja tiedon tunnistaminen etukäteiskysymysten/käsitteiden määrittämisen kautta.
Uuden osaamisen tuottaminen ja soveltaminen aiempaa osaamista syventäen,
Exam schedules
Koe viikolla 50. Koe on yksi arvioitavista osasuorituksista, eikä sen painoarvo ole yli 50 %. Koetta ei voi uusia.
International connections
Yhteistoiminnallinen oppiminen
3- 4 hengen tiimeissä ideoidaan, haetaan ja jaetaan tietoa, opitaan yhdessä. Edellyttää kaikkien aktiivista osallistumista, pyritään hyviin oppimistuloksiin tiimin tuella, toisia tukien.
Käänteinen oppiminen/Flipped learning
Ennen kontaktikertaa tutustutaan aiheeseen. Mitä jo tiedetään, mitä tietoa tarvitaan lisää? Tunnilla käydään syntyneitä kysymyksiä lävitse ja syvennetään aihetta esimerkkien avulla.
Completion alternatives
Kurssilla ei ole valinnaista suorittustapaa
Student workload
Opiskelijan arvioitu ajankäyttö
"Aloitustestiin valmistautuminen
Kurssitoteutukseen tutustuminen" 6
"Tuntien aiheeseen tutustuminen,
käsitteiden selvittäminen" 32
Tunnit 51
Tuntitehtävien tekeminen 15
Tuntitestiin harjoittelu 18
Kokeeseen kertaus 12
Yhteensä 134
Content scheduling
Vko 36 kurssialoitus ja lähtötasotesti
vkot 37 - 49 Teoriatunnit, Excel tunnit ja työpajatunnit
vko 50 Summatiivinen koe
Further information
Tuntien alussa varattu aikaa synytyneille kysymyksille. Tämän lisäksi ITS-alustalla on keskustelufoorumi, jossa voi esittää ja vastata kysymyksiin. Sähköposti ei ole tämän kurssin viestinnän väline.
Evaluation scale
H-5
Assessment methods and criteria
Arviointi perustuu tuntitesteihin, tuntiaktiivisuuteen(viikkotehtävät) sekä loppukokeeseen.
Mikään arvioitavista osasuorituksista ei painoarvoltaan ole >= 50 %, joten mitään niistä ei voi erikseen uusia.
Maksimipisteiden päälle saa läsnäolopisteitä ryhmätunneille osallistumisesta:
Läsnäoloa Extrapisteet
6 - 7 ...........3 pistettä
5 .......... 2 pistettä
4 .............. 1 pistettä
Enrollment
01.08.2023 - 04.09.2023
Timing
31.08.2023 - 23.12.2023
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
Degree programmes
- Degree Programme in Business Logistics
Teachers
- Hoda Al Bermanei
- Marjo Kumpula
Groups
-
PLILOS23APLILOS23A
Objective
The student can apply the methods of business mathematics to evaluate the financial problems in decision making using Excel.
Content
Percentages and index numbers
• Simple interest and applications such as short term loans
• Compound interest and discounting
-excel spreadsheet
Evaluation scale
H-5
Enrollment
30.07.2023 - 04.09.2023
Timing
29.08.2023 - 24.12.2023
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
Degree programmes
- Degree Programme in Business Logistics
Teachers
- Hoda Al Bermanei
- Marjo Kumpula
Groups
-
PLILOS23BPLILOS23B
Objective
The student can apply the methods of business mathematics to evaluate the financial problems in decision making using Excel.
Content
Percentages and index numbers
• Simple interest and applications such as short term loans
• Compound interest and discounting
-excel spreadsheet
Evaluation scale
H-5
Enrollment
02.12.2022 - 19.01.2023
Timing
01.01.2023 - 25.05.2023
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
Teachers
- Hoda Al Bermanei
- Marjo Kumpula
Groups
-
PMYYFS22Finacial Services
Objective
The student can apply the methods of business mathematics to evaluate the financial problems in decision making using Excel.
Content
Percentages and index numbers
• Simple interest and applications such as short term loans
• Compound interest and discounting
-excel spreadsheet
Evaluation scale
H-5
Enrollment
02.07.2022 - 07.09.2022
Timing
01.08.2022 - 31.12.2022
Number of ECTS credits allocated
5 op
Virtual portion
1 op
Mode of delivery
80 % Contact teaching, 20 % Distance learning
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
Seats
0 - 35
Teachers
- Virpi Raivonen
Groups
-
PLILOS22APLILOS22A
Objective
The student can apply the methods of business mathematics to evaluate the financial problems in decision making using Excel.
Content
Percentages and index numbers
• Simple interest and applications such as short term loans
• Compound interest and discounting
-excel spreadsheet
Evaluation scale
H-5
Enrollment
02.07.2022 - 07.09.2022
Timing
01.08.2022 - 31.12.2022
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
Teachers
- Virpi Raivonen
Groups
-
PLILOS22BPLILOS22B
Objective
The student can apply the methods of business mathematics to evaluate the financial problems in decision making using Excel.
Content
Percentages and index numbers
• Simple interest and applications such as short term loans
• Compound interest and discounting
-excel spreadsheet
Evaluation scale
H-5
Enrollment
01.12.2021 - 17.01.2022
Timing
10.01.2022 - 31.05.2022
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Campus
Lemminkäisenkatu
Teaching languages
- Finnish
Teachers
- Pinja Palm
Groups
-
PMMWES21
Objective
The student can apply the methods of business mathematics to evaluate the financial problems in decision making using Excel.
Content
Percentages and index numbers
• Simple interest and applications such as short term loans
• Compound interest and discounting
-excel spreadsheet
Evaluation scale
H-5
Enrollment
02.12.2021 - 10.01.2022
Timing
03.01.2022 - 28.05.2022
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
Teachers
- Virpi Raivonen
Groups
-
PMYYFS21
Objective
The student can apply the methods of business mathematics to evaluate the financial problems in decision making using Excel.
Content
Percentages and index numbers
• Simple interest and applications such as short term loans
• Compound interest and discounting
-excel spreadsheet
Evaluation scale
H-5
Enrollment
02.12.2021 - 22.01.2022
Timing
01.01.2022 - 29.05.2022
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
Teachers
- Virpi Raivonen
Groups
-
MLILOK22
Objective
The student can apply the methods of business mathematics to evaluate the financial problems in decision making using Excel.
Content
Percentages and index numbers
• Simple interest and applications such as short term loans
• Compound interest and discounting
-excel spreadsheet
Evaluation scale
H-5