Consumer Finance Assignments (subject to change)
- Consumer Finance Assignments
- Google Classroom
- Text Book Site
- Text Book on Google Books
- Stock Market Game
- Yahoo Finance
- Syllabus
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.
- The chart must have appropriate titles, labels, and formatting.
- Video for this chart
- 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:
- TOTAL INCOME: all income sources added together using Auto Sum this is using the Sigma (Σ).
- TOTAL EXPENSES: all expenses added together using Auto Sum.
- MONTHLY SURPLUS: TOTAL INCOME-TOTAL EXPENSES
- ENDING BALANCE: BEGINNING BALANCE+MONTHLY SURPLUS
- % OF BUDGET: ACTUAL / BUDGET and change formatting to %.
- Video for functions 1
- Video for functions 2
- Video for final functions and formatting
- 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.
Sep 11-14
Notes: Unit 1 Financial Decisions
- Objective: Understand how decisions affect financial planning
- Notes
- Video day 1
- Video Day 2
- Video Day 3 Expenses for Budget
- Video Day 4 Expenses for Budget
- Complete handouts (Print if absent)
- Goal sheet
- Net Worth
- Income and Expenses
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:
- 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
- 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
- Objective: Increase understanding of the concepts of banking, the economy, investments, and financial markets
- Spend about $5000 on one stock.
- It must be one of the companies included in the DJIA. To find one of these:
- Go to https://www.marketwatch.com/
- Click on Dow
- Scroll down and you will see components on the left side.
- Video Explanation
- Go toGo to https://www.marketwatch.com/games/lowry-cf-2023-2024/ to purchase the stock.
- Complete the form in Google Classroom.
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
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- Spend about $5000 on one stock.
- Go to https://www.marketwatch.com/games/lowry-cf-2023-2024/ to purchase the stock.
- Send me an email explaining why you made the investment. respinola@hcsdnv.com.
- I invested in ________________ because ___________________.
- You must include one reason based on information from the stock quote.
- Use the subject "Stock 1".
- Video Explanation
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
- What is a good investment
- Take notes
- Day one video
- Day two Video
Aug 23
IN CLASS: Go over stock quotes
- What is a good investment
- Take notes
- Day one video
- Day two Video
Aug 22
Assignment: Market Levels
- Complete in Google Classroom
Complete registration for all required sites
Aug 21
Course requirements/expectations
- Syllabus: parents can sign ther verfication or email me at respinola@hcsdnv.com.
Student Syllabus Verification
- Complete in Google Classroom
Register for Market Watch
- Objective: Increase understanding of the concepts of banking, the economy, investments, and financial markets
- Go to https://www.marketwatch.com/games/lowry-cf-2023-2024/
- Click Join Game.
- Sign up with Google.
- Click the game link again: https://www.marketwatch.com/games/lowry-cf-2023-2024/
- use the PW lowrycf2023!
Join Quizlet
- https://quizlet.com/join/NDcrvMe24?i=1ucocb&x=1rqt
- Use your real name for your Quizlet account so you can receive credit.