LEARNING WEB FOR FINANCIAL PLANNING
| Grade Level: High School Juniors and Seniors |
|
| Designer: Aimee Pilgrim |
|
Materials Needed: |
Internet |
|
| Word | ||
| Excel | ||
| Power Point |
| Duration of Learning Web: 1 Week |
| Objectives: The student will analyze information on budgeting and making wise consumer decisions. They will design a plan for money management and understand why financial planning is important. |
|
Scaffolding Activities
|
|
| To prepare you for the lessons in this Learning Web scaffolding exercises must be completed. Work through each one, print out and turn in to me. |
| Statement of the
problem:
According to USA Today (2001), 19% of Americans between the ages of 18 and 24 declared bankruptcy in 2001. The fastest growing group of bankruptcy filers are those people who are 25 years of age or younger. (Senate Committee on Banking, Housing and Urban Affairs). Debt is out of control in America! What is the youth of today going to do about it? Does budgeting really work when buying big ticket items like a CAR or HOUSE?? |
| Activity 1. Go to website Why budget? You will print this document out first, answer completely and turn in. (analysis) |
| Activity 2. Go to website Test Your Financial Planning Knowledge. At the top right of web page select Tennessee as your state and you will choose the student version. Under subject you will choose business administration. Then you will click on personal finance 2007. Under chapter activities you will click chapter summaries. Under unit resources choose unit 1. Under chapter activities choose chapter 1. Under chapter 1: personal financial planning click practice test. Answer questions on computer then, print out and turn in. (comprehension, application) |
 |
| Activity 3. You will visit these 6 websites and read articles pertaining to vocabulary on financial planning. Then, you will write a brief paper (at least one page double spaced) using Word telling why financial planning is important. You will need to insert a header with the title Why Financial Planning is Important and put you name under the title. If you see pop ups click cancel or close the box. (comprehension, application, analysis, synthesis and evaluation) | Financial Planning for Teens A 5-STEP PROCESS |
| Inflation And Interest Rates (first 2 paragraphs under What is Inflation?) | |
| What are Opportunity Costs (A. part only) | |
| You're Spending Your Millions $1 at a Time | |
| Annuity Definition and Much More (definition and 2 paragraphs under Annuity) | |
| What is the Demand For Money (page 1 and 2) |
| Activity 4. Go to this website Vocabulary Flash. At the top right of web page select Tennessee as your state and you will choose the student version. Under subject you will choose business administration. Then you will click on personal finance 2007. Under chapter activities you will click chapter summaries. Under unit resources choose unit 1. Under chapter activities choose chapter 1. Under chapter 1: personal financial planning click e-flashcards. Using a Word document, single spaced, 12 pt font with 1 inch margins you will type the vocabulary words (20 in all) with their definitions. Number, underline and bold all vocabulary words. Title it Financial Planning Vocabulary Words. You will underline, bold and center the title at the top of the page. (comprehension) |
 |
|
Scenario
for Activity 5. You are a 25 year old male/female who works at an
architectural firm as a junior executive. You currently make
$35,000 a year. You own a condo and your mortgage payment is $800
a month. You currently do not have any debt.
|
| Activity 5. Based on the info from the above scenario you will create a budget spreadsheet on Excel. You will construct 4 columns and 22 rows. Across the top you will name your columns Category, Budget Amount, Actual Amount, and Difference. Make these 12 pt font and bold these. Under category you will put Income. Make Income 10 pt font and bold. Under Income you will put Wages/Income. Make Wages/income 10 pt font. Under Wages/ Income you will put Income Subtotal (10 pt font). Make Income Subtotal italicized. Skip 2 rows then put Expenses (10 pt font and bold). Under this you will think of all expenses you should have based on the scenario above (mortgage, utilities, grocery, shopping, entertainment, transportation, long-term savings, emergency savings, donations etc). You can add categories of expenses if you like. Under all expenses put Expense Total (10 pt font and bold). Skip a row and put Net Income (Income-Expenses) using 14 pt font and bold. Do this for the next 3 cells located horizontally. Fill in cells with amounts of expenses you think the person above would have based on the information given to you. Using your formula feature you did in your scaffolding exercises you will add all income, add all expenses in the Income Subtotal cells and Expenses cells. Then subtract total Budgeted Income Subtotal from total Budgeted Expense in the Net Income cell. Do the same for Actual Income Subtotal and Expenses and Difference. You will format the cells under Difference by subtracting Actual Amount - Budget Amount. (synthesis) |
 |
| Category | Budget Amount | Actual Amount | Difference |
| Income | |||
| wages/income | |||
| Expenses | |||
| mortgage |
| Activity 6. In groups of 4-5 you will construct a PowerPoint presentation. You will have a title page slide, 1 slide titled Income with 3-4 examples of different types of income. The second slide will be titled Expenses with 3-4 examples of expenses. The last page will be the equation for a budget: Income - Expenses= Net Income with your actual results from one member's budget page. You will present this as a group on the smart board. Be sure to include animation schemes and different layouts. Print all four slides on one sheet of paper. (comprehension, application, analysis, synthesis) |
 |
|
Activity 7.
Go to this website
http://escapefromknab.com/index.html. Go through the
entire game and you are to write down how much money you had at the
end and whether or not you could return to Earth. You are to write
this information down on the back of your PowerPoint print out. Turn this in
to me. (application, analysis, evaluation)
|
|
Any information used in creating this learning web is already
linked to the websites for the activities and games. The animations
and clip art are included in the Microsoft Front Page and Word
Software Applications. |
| Assessment: |
Content- 50 pts Format 30- pts Presentation/ Participation- 20 pts |
93-100 pts - A 85-92 pts - B 78-84 pts - C 70-77 pts - D 69-under |
