Consumer Finance Assignments (subject to change)

Sep 22

Quiz: Financial Planning

  • Objective: Understand how decisions affect financial planning
  • Use Notes
  • Complete in Google Classroom

Sep 21

Complete Budget and Charts

  • Objective: Develop a household budget
  • Together we will insert a chart that tracks your ending balances for each month.
  • Add another chart which plots the Actual Expenses for one of the months.
    • Add appropriate labels, you must have labels for the expenses, titles and formatting to change the chart from default settings
  • SUBMIT

Sep 14

Budgeting

  • Objective: Develop a household budget
  • Go over average expenditures, take notes to develop personal budget. Scroll down for video of notes
  • 2021 Average Household Expenses
  • 2019 Average Household Expenses
  • 2018 Average Household Expenses
  • 2016 Average Household Expenses
  • Reference Article: 09-13-20 Average Household Budget
  • Average Car Insurance Rates by Age and Gender
  • In Google Classroom open the budget file and begin creating your budget.
  • Only complete three months.
  • Input the budgeted items using the numbers we came up with in class.
  • You must use the income categories from your notes and/or the example budget below.
  • For the expense categories, follow the example. But if we covered an expense in class, it must be included.
    • Gas and oil, auto maintenance, renters insurance, subscriptions, medicine, savings, personal care, pets
  • Vary the actual numbers from the budget amounts.
  • For school related costs, go to the site of the college you think you will attend.
  • The beginning balance is what you think you will have in the bank when you graduate from high school.
  • The ending balance for one month is the beginning balance for the following month. This will be a formula.
  • The whole budget is linked together using formulas. So if your income is changed in September, it changes the ending balance for November.
  • FORMULAS:
  • Once you input all of the formulas for the first month you can then copy and paste them and the budget amounts to the next two months.
  • Vary the numbers for each month. This means your budget and actual amounts for food should not be the same for each month.
  • When all of the formulas are input, format the text and cells to change the appearance; make it look good.
  • Insert a chart that tracks your ending balances for each month.
    • The chart must have appropriate titles, labels, and formatting.

example budget

Sep 11-14

Notes: Unit 1 Financial Decisions

Sep 7

Find a possible career

  • Objective: Preparing to apply for a job (e.g., complete personal aptitude and interest inventories, performing a job search, developing a résumé, preparing for an interview).
  • Go to https://www.123test.com/career-test/
  • Others (not required) https://www.truity.com/test/holland-code-career-test and https://www.bls.gov/ooh/occupation-finder.htm
  • Video Explanation
  • Complete the questionnaire. Use as much detail as possible.
  • Select one of the career fields you are interested in.
  • Use the Snipping Tool to capture the information and paste it into the body of an email. This will look something like:
    career
  • Send an email to yourself with the information you have copied.
  • CC me on the email.
  • The subject should be, Career Aptitude Test Results.
  • Answer the following, does this match with something you would want to do? Why? Why not?

Sep 6

Video: What is a Stock Market Index by Wall Street Survivor

  • Objective: Increase understanding of the concepts of banking, the economy, investments, and financial markets
  • Complete in Google Classroom

Invest in another company

  • Objective: Increase understanding of the concepts of banking, the economy, investments, and financial markets
  • Video explanation
  • Find a certain sector of the economy and invest in a the company.
  • Go to https://www.marketwatch.com/ click on Dow and then sectors.
  • Select one of the industries to find companies that are in it.
  • Choose one of the companies to invest in.
  • Spend between $5000-$10,000.
  • http://www.marketwatch.com/game/
  • Copy and paste the following into your email. Answer each following the colon.
    • Sector/Industry Definition:
    • Company:
    • Sector/Industry:
    • Reason:
  • Send the email to respinola@hcsdnv.com.
  • Use the subject "Sector".
  • For the reason, you must specifically mention one item from the stock quote as a reason for making the purchase and why it makes it a good investment. Check grammar and spelling.

Sep 5

DUE: Article: CVS, Walmart and Walgreens ordered to pay $650.6 million to Ohio counties in opioid case

Video: How the Stock Market Works

  • Objective: Increase understanding of the concepts of banking, the economy, investments, and financial markets
  • Complete in Google Classroom

Make second purchase in Market Watch

Aug 31

Article: CVS, Walmart and Walgreens ordered to pay $650.6 million to Ohio counties in opioid case

  • Objective: Increase understanding of the concepts of the economy, banking, investments, and financial markets
  • See directions in Google classroom

DUE: Math Worksheet Page 34

Aug 30

Complete first stock purchase and send email

Math Worksheet Page 34

  • Objective: Divide Decimals by Decimals

    • Aug 29

    Quiz: Stock Quotes

    Make first purchase in Market Watch

    Objective: Increase understanding of the concepts of banking, the economy, investments, and financial markets

    Aug 28

    DUE: Stock Quotes Research

    Assignment: What is Stock Video

    • Objective: Increase understanding of the concepts of banking, the economy, investments, and financial markets
    • Complete in Google Classroom
    • To turn on captioning. In Chrome click the 3 dots in the upper right, click settings, click Accessibility on the left, turn on Live Captioning.
    • https://youtu.be/7EUbrFLef7M?si=JBB0ej5lpRUozw87

    Aug 25

    Stock Quotes Research

    • Objective: Increase understanding of the concepts of the economy, banking, investments, and financial markets
    • Researching companies by industry, sector or trending stock.
    • Look up the quotes for five companies and record the information in the sheet in Google Classroom.
    • Video Explanation

    Pretest

    • Take the pretest in Google Classroom.
    • Must be done at school.
    • Do not look up answers.

    Aug 24

    IN CLASS: Go over stock quotes

    Aug 23

    IN CLASS: Go over stock quotes

    Aug 22

    Assignment: Market Levels

    Complete registration for all required sites

    Aug 21

    Course requirements/expectations

    Student Syllabus Verification

    Join Google Classroom

    Register for Market Watch

    Join Quizlet

    Join https://moneysmartcbi.fdic.gov/