Friday, 16 December 2022

Google Sheet tryout

Mr. Kwok will go to Hawaii for a vacation this Christmas. He has no money and must charge his entire trip on hi credit card. Calculate what is the total payable by the end of January 2023 if his trip costs $8888.88. Interest rate is compounded daily

 

Date

Charges

Interest Rate

Interest Charges

Total

January 1, 2023

$8888.88

2.75%

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

January 31, 2023

 

 

 

 

 

Answer: $20610.27

December 16, 2022

 Financial Literacy Test on Wednesday. Multicultural luncheon on Friday. Bring food, paper/plastoc plates and forks



30 TAPS, 25 x 0.50 = 12.50                     4 e-transfers x 0.25 = 1.00

5 cheques x 3.50 = 17.50                       2 ATM x 2 = 4.00

1 Bank withdraw x 5.50 = 5.50               Not enough fund by the end of Nov, $25

 

25 + 12.50 + 17.50 + 5.50 + 1.00 + 4.00 = $65.50


 

Part D: Credit Cards, Debit Cards and Compound Interest


- add the Interest Charge column to make it easier

 

Most credit cards charge 20% for outstanding balance (purchases that have not been paid back).  The interest will be accumulated daily.

 

Assuming the chart below is the Google Sheet, write down the formula needed to calculate the interest accumulated on November 10.

 

E

F

G

H

I

15

Date

Charges 

Interest rate

Interest Charges

Total

16

November 5, 2022

$876.54

23.99%

 

Question 15 formula

17

November 6, 2022

Question 16 formula

23.99%

 

Question 17 formula

18

November 7, 2022

 

23.99%

 

 

19

November 8, 2022

 

23.99%

 

 

20

November 9, 2022

 

23.99%

 

 

21

November 10, 2022

 

23.99%

 

 

 

Formula for Question 15 (1)

 

Formula for Question 16 (1) Should be the same number as I16

 

Formula for Question 17 (1)

 

 

Use your Google Sheet and determine the total on November 30, 2022 (5)

answer: $234868.57

 

 

 

Give three reasons why you should get a debit card when you are 15 (3)




Thursday, 15 December 2022

December 15, 2022

 7C

- try to complete the Financial Literacy pre-test. I will go through some of the questions tomorrow (esp the Google Sheet questions)

- Financial literacy test is on Wednesday Dec 21

- ask parents what multicultural food item you can bring for Dec 23

USC link

https://financialaid.usc.edu/undergraduates/prospective/how-much-wil-my-education-cost.html

Online dictionary. Very useful to find synonyms

https://www.merriam-webster.com/


Geography and French test tomorrow


Marijuana

-      Heinz bought a lot of tomatoes from southwestern Ontario farms

-      Largest buyer for the past 20 years

-      Tomatoes and other crops are grown in greenhouses during the winter (warm, climate controlled environment)

-      Heinz was then taken over by Warren Buffet – not buying Canadian tomatoes – but buy tomatoes from Ohio

-      No one want the greenhouses and tomatoes from Ontario

-      Marijuana companies then bought all the greenhouses in the area and started growing cannabis

-      They can then grow weed all year round






Wednesday, 14 December 2022

December 14, 2022

-      https://www.durhamregion.com/news-story/8623616-kids-get-high-after-eating-thc-gummy-bears-pot-cookies-at-oshawa-elementary-school/

- - ask your parents what you should bring to school for the Dec 23 multicultural luncheon


 Tell parents to save up NOW since post secondary education is really expensive

-       University degree (cost min $128000), College diploma (cost min $45000)

Try to find the following information from this website:

https://www.collegecalc.org/colleges/massachusetts/harvard-university/

https://finance.duke.edu/bursar/TuitionFees/tuition

https://internationaloffice.berkeley.edu/students/current/expenses



Formal letter ideas and organization (point form, your achievements in three areas: academic, extra curricular and volunteer work. The school needs to see improvement)

Academic (subject related)

Extra curricular (in and outside school)

Volunteer work and experience

What you like, and explain why you like that subject

Chinese/Farsi/Korean school, piano lessons, art, swimming

Tutoring high school students once a week

Something specific, IMPROVEMENT since last year

I enjoy playing piano since it relaxes me and put me into a better mood

Can food drive to help the least fortunate. This way, people can get decent meals during the holidays

Doing better in drama. Learn to use my voice/tone /expressions to do monologues in front of the class

Learning how to play basketball with my team every week helps me to realize teamwork and communication are really important

During group activities, I work well with everyone and encourage them to participate

I have improved in writing as my teacher teaches me how to start a sentence without using “I”

I can use better vocabulary to compose

During the game, I encourage and cheer up all my friends so they can do their best

At lunch time, I have been helping a student with a BROKEN LEG to get back to the classroom and I carry his heavy backpack

I can focus better and do better when I have to study for tests

When I have time, I will go out for walks instead of staying home and watching YouTube. This is a healthier leisure activity

In church, I have been helping the seniors to get to their seats every Sunday

Tuesday, 13 December 2022

7B, December 13, 2022

 Complete search for York University and George Brown College expenses.

The George Brown one you MUST pick a program first before determining the tuition. For example, Kwok picks Business - finance (B133) and the tuition is $4730 per semester or 4730 x 2 = $9478 per year


Try to find the following information from the York University website:

https://futurestudents.yorku.ca/tuition

 

York University 

 

Domestic students (Can. Citizens or landed immigrants)

International Students

 

Tuition for the program of your choice

 

 

 

Textbooks and supplies (get the average)

 

 

 

Residence, 8 months

 

 

 

 

Meal Plans (get the average)

 

 

 

Or if you choose to live off campus

 

 

 

Personal expenses (average for on campus and off campus)

 

 

 

Health and dental care

 

 

 

Total (each year)

 

 

 

 

 

Now, it is your turn to find out information from George Brown College.

https://www.georgebrown.ca/apply/tuition-fees-and-costs

 

There are two semesters in a school year (Sept to April). 

The third semester is optional for the students who wish to get their diploma sooner(May to Jun)

 

George Brown College

 

Domestic students (Can. Citizens or landed immigrants)

International Students

 

What program do you want to take

 

 

 

Tuition for that program of your choice

 

 

 

Materials, Textbooks and supplies (average)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total (per year)