Complete each of the sections in the order below.
Open the attached Excel Spreadsheet to record the following: Save in your "My Documents" After completing all sections upload to your "One Note Notebook"
Open the attached Excel Spreadsheet to record the following: Save in your "My Documents" After completing all sections upload to your "One Note Notebook"
1. Earning - Access the Earning Tab on the Fin Lit Excel workbook to record the following:
Earning Section I Can Statements
1. Compare the salary for no degree/associate's degree/bachelor's/masters degrees
2. Decode my salary to determine NetPay
2. Decode my salary to determine NetPay
1. Starting Salaries
a. Enter your chosen career in cell A2
b. What is the beginning salary of your chosen career? Record the salary in B2
2. How to Earn and Learn
a. Record the degree that is needed to obtain your chosen degree in your Excel worksheet in cell A4.
b. Record the salary that can be reasonably expected with the degree needed for your career in cell B4.
b. Record the Degree level if you were to return to school in cell A6
c. Record the salary if you would advance one step past your necessary degree in cell B6.
3. How to Decode Your Paycheck
a. Key in your yearly salary in cell A11
b. Key in your weekly salary in cell B11 by entering the formula "=A6/52"
4. How to Balance School & Work
a. Compute your career earnings by keying in "=B4*40"in cell B23.
b. Compare your career earnings with an advanced degree by keying in "=B6*40 in cell A23
5. Be Your Own Boss
a. Review the individual sections
b. Complete the "Be your own Boss Challenge"
c. Take a screen shot of the end results. Pasting on the worksheet on the earnings tab.
a. Enter your chosen career in cell A2
b. What is the beginning salary of your chosen career? Record the salary in B2
2. How to Earn and Learn
a. Record the degree that is needed to obtain your chosen degree in your Excel worksheet in cell A4.
b. Record the salary that can be reasonably expected with the degree needed for your career in cell B4.
b. Record the Degree level if you were to return to school in cell A6
c. Record the salary if you would advance one step past your necessary degree in cell B6.
3. How to Decode Your Paycheck
a. Key in your yearly salary in cell A11
b. Key in your weekly salary in cell B11 by entering the formula "=A6/52"
4. How to Balance School & Work
a. Compute your career earnings by keying in "=B4*40"in cell B23.
b. Compare your career earnings with an advanced degree by keying in "=B6*40 in cell A23
5. Be Your Own Boss
a. Review the individual sections
b. Complete the "Be your own Boss Challenge"
c. Take a screen shot of the end results. Pasting on the worksheet on the earnings tab.
2. Saving - Access the Savings tab on the Fin Lit Excel workbook to record the following:
Saving Section
I Can Statements
1. Understand the importance of a Save/Spend Plan
2. Use a Savings Calculator
3. Use the Power of 72 calculator to understand how long it will take to double my investments.
2. Use a Savings Calculator
3. Use the Power of 72 calculator to understand how long it will take to double my investments.
1. Savings Tricks
a. Key in the 5 Savings Tricks listed in this section in cells B2 - B7
2. 5 Step Save/Spend Plan
a. Key in the 5 steps in the Save/Spend Plan in cells B10 - B14
3. After reviewing the "About Savings Accounts" section, use the Compounding Calculator.
a. Print Screen after completing. Paste in cell A19.
b. Use the Savings Calculator. Print screen after completing. Paste in Cell A29
4. "How to Earn Money by Saving Money" - After reviewing the in section complete the following:
a. "The Truth about Millionaires" activity. Print Screen and Paste in cell A33
b. Complete the "Millionaire Calculator" activity. Print Screen and Paste in cell A46.
c. Complete the "Power of 72 Calculator" activity. Print screen and paste in cell A 55.
a. Key in the 5 Savings Tricks listed in this section in cells B2 - B7
2. 5 Step Save/Spend Plan
a. Key in the 5 steps in the Save/Spend Plan in cells B10 - B14
3. After reviewing the "About Savings Accounts" section, use the Compounding Calculator.
a. Print Screen after completing. Paste in cell A19.
b. Use the Savings Calculator. Print screen after completing. Paste in Cell A29
4. "How to Earn Money by Saving Money" - After reviewing the in section complete the following:
a. "The Truth about Millionaires" activity. Print Screen and Paste in cell A33
b. Complete the "Millionaire Calculator" activity. Print Screen and Paste in cell A46.
c. Complete the "Power of 72 Calculator" activity. Print screen and paste in cell A 55.
3. Spending - Access the Spending Tab on the Fin Lit Excel workbook to record the following:
Spending Section
I Can Statements
1. Develope the understanding of Wants and Needs in relationship to shopping and impulse buying.
2. Understand tactics that can be used to shop smarter.
3. Gain skills in writing a check.
4. Determine what kind of spender I am.
2. Understand tactics that can be used to shop smarter.
3. Gain skills in writing a check.
4. Determine what kind of spender I am.
1. Buy it or Not
a. List 3 items that you wish to purchase in cells B2, D2 & F2
b. Answer the questions in cells A4 - A12 for each item.
2. Shop Smart
a. List 5 ways to shop smarter in cells B18 - B22
3. How to Write a Check.
a. Complete the activity.
b. Print Screen and paste in cell A26
4. Take the Spending Challenge
a. Take the Spending Challenge
b. Print Screen and paste in cell A41
5. What Kind of Spender are You?
a. Complete the activity.
b. Print Screen and paste in cell A51
a. List 3 items that you wish to purchase in cells B2, D2 & F2
b. Answer the questions in cells A4 - A12 for each item.
2. Shop Smart
a. List 5 ways to shop smarter in cells B18 - B22
3. How to Write a Check.
a. Complete the activity.
b. Print Screen and paste in cell A26
4. Take the Spending Challenge
a. Take the Spending Challenge
b. Print Screen and paste in cell A41
5. What Kind of Spender are You?
a. Complete the activity.
b. Print Screen and paste in cell A51
4. Owing - Access the Owing Tab on the Fin Lit Excel workbook to record the following:
Owing Section
I Can Statements
1. Understand the advantages and disadvantages of using Credit Cards.
2. Determine the cost of credit when using a Credit Card.
3. Determine the length of time it will take to pay off debt/credit card debt.
2. Determine the cost of credit when using a Credit Card.
3. Determine the length of time it will take to pay off debt/credit card debt.
1. Credit Cards
a. List the 4 advantages of using credit cards in cells B3 - B6
b. List the 3 disadvantages of using credit cards in cells B9 - B11.
2. Credit Card Facts - Define the terms listed in cells A15 - A20
3. "I Paid How Much?"
a. Complete the "I Paid How Much?" Activity
b. Print Screen and paste in cell A24
4. The Debt Calculator
a. Complete the "Debt Calculator" activity
b. Print Screen and paste in cell A34
5. Credit Card IQ
a. Complete the Credit Card IQ activity
b. Print Screen and paste in cell A48.
a. List the 4 advantages of using credit cards in cells B3 - B6
b. List the 3 disadvantages of using credit cards in cells B9 - B11.
2. Credit Card Facts - Define the terms listed in cells A15 - A20
3. "I Paid How Much?"
a. Complete the "I Paid How Much?" Activity
b. Print Screen and paste in cell A24
4. The Debt Calculator
a. Complete the "Debt Calculator" activity
b. Print Screen and paste in cell A34
5. Credit Card IQ
a. Complete the Credit Card IQ activity
b. Print Screen and paste in cell A48.
5. Tracking Expenses - Access the Tracking Tab on the Fin Lit Excel workbook to record the following:
Tracking Expenses Section
I Can Statements
1. Create a sample budget.
2. Track Checking Accout with register.
3. Understand the importance of a Credit History.
2. Track Checking Accout with register.
3. Understand the importance of a Credit History.
1. Tracking
a. After reviewing the introduction complete the "Determining Your Budget" activity.
b. Print screen and paste into cell A4
2. Track your Checking Account
a. Complete the "Writing a Check" Activity.
b. Print Screen and paste into cell A18
c. Complete the "Balance Your Checking Account" Activity
d. Print Screen and Paste into cell A2
3. Credit History
a. Key in the 3 most common mistakes in monitoring your credit history in cells B35 - B37
a. After reviewing the introduction complete the "Determining Your Budget" activity.
b. Print screen and paste into cell A4
2. Track your Checking Account
a. Complete the "Writing a Check" Activity.
b. Print Screen and paste into cell A18
c. Complete the "Balance Your Checking Account" Activity
d. Print Screen and Paste into cell A2
3. Credit History
a. Key in the 3 most common mistakes in monitoring your credit history in cells B35 - B37
6. Giving - Access the Giving Tab on the Fin Lit Excel workbook to record the following:
Giving Section
I Can Statements
1. Understand the ways that a young teen can give back to the community.
7. Investing - Access the Investing Tab on the Fin Lit Excel workbook to record the following:
Investing Section
I Can Statements
1. Understand the factors when investing.
2. Understand the Types of investments.
3. Understand the relationship of Risk vs. Rewards in investing
2. Understand the Types of investments.
3. Understand the relationship of Risk vs. Rewards in investing
1. What is a Stock Market
a. Define stocks in cell A2
b. Explain how the Stock Market Works in cell A5
2. Ways to Invest
a. What 3 factors must be considered when investing? List them in cells B7 - B9
b. List the 6 types of investments and the benefits of each in cells B11 - B16.
3. Rewards vs. Risk
a. List in the order of the investments as to their higher risk investing in cells A20 - A23
1. Stocks, Bonds & Mutual Funds
2. Collectables
3. Cash, Bank Savings Accounts, Bank Certificate of Deposit, Bank Money Market Accounts, Savings and Protection
a. Define stocks in cell A2
b. Explain how the Stock Market Works in cell A5
2. Ways to Invest
a. What 3 factors must be considered when investing? List them in cells B7 - B9
b. List the 6 types of investments and the benefits of each in cells B11 - B16.
3. Rewards vs. Risk
a. List in the order of the investments as to their higher risk investing in cells A20 - A23
1. Stocks, Bonds & Mutual Funds
2. Collectables
3. Cash, Bank Savings Accounts, Bank Certificate of Deposit, Bank Money Market Accounts, Savings and Protection
8. Safeguarding - Access the Safeguarding Tab on the Fin Lit Excel workbook to record the following:
Safeguarding Section
I Can Statements
1. Understand the importance of protecting the 5 areas against loss.
2. Complete the Life Span Calculator
2. Complete the Life Span Calculator
1. Losses
List the 5 areas that is advisable to protect against losses and the implications of not protecting against the losses in cells A2 - A6.
2. Life Span Calculator
a. Complete the Life Span Calculator activity.
b. Print Screen and paste in cells A9
List the 5 areas that is advisable to protect against losses and the implications of not protecting against the losses in cells A2 - A6.
2. Life Span Calculator
a. Complete the Life Span Calculator activity.
b. Print Screen and paste in cells A9