Unit 6: Personal Finance
In this unit students will learn the basics of Microsoft Excel by exploring elements of personal finance. This unit is built for exploration and class discussion - I encourage you to let your students guide you and explore what they're interested in. There are five major lessons: Building Basic Budgets, Purchasing a Vehicle (getting a loan), Credit Cards, Saving for Retirement, and Buying a Home.
Prerequisite Units: all basic excel functions that has been taught in units 4 and 5
Materials needed: Computer (Microsoft Excel and/or Google Sheets)
Approximately 18 Days needed
Prerequisite Units: all basic excel functions that has been taught in units 4 and 5
Materials needed: Computer (Microsoft Excel and/or Google Sheets)
Approximately 18 Days needed
6.1: Building Basic Budgets
Lesson Resources
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Lesson 6.1 Guided Notes (Word) |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
Lesson 6.1 Complete (XSL) |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
Things to consider when building an Excel File (PPT) |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Problem Set 6.1 (Word) |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Problem Set 6.1 Solutions (Word) |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
Problem Set 6.1 Completed Excel File |
Lesson 6.1 Video |
|
6.2: Purchasing a Vehicle (taking out a loan)
Lesson Resources
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Lesson 6.2 Guided Notes (Word) |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
Lesson 6.2 Complete (XLS) |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Problem Set 6.2 (Word) |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
Problem Set 6.2 Completed Excel File |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Problem Set 6.2 Solutions (Word) |
Lesson 6.2 Video |
|
6.3: Credit Cards
Lesson Resources
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Lesson 6.3 Guided Notes (Word) |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
Lesson 6.3 Complete (XLS) |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Problem Set 6.3 (Word) |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Problem Set 6.3 Solutions (Word) |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
Problem Set 6.3 Completed Excel File |
Lesson 6.3 Video |
|
6.4: How does Retirement work?
Lesson Resources
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Lesson 6.4 Guided Notes (Word) |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
Lesson 6.4 Complete (XLS) |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Problem Set 6.4 Solutions (Word) |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Problem Set 6.4 (Word) |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
Problem Set 6.4 Complete Excel File |
Lesson 6.4 Video |
|
Planning for Retirement Activity (after lesson 6.4)
This activity typically takes me 2 full class periods.
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Planning For Retirement Activity |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
Completed Excel File |
6.5: Mortgages (Home Loans)
Lesson Resources
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Lesson 6.5 Guided Notes (Word) |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
Lesson 6.5 Complete (XLS) |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Problem Set 6.5 (Word) |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
Problem Set 6.5 Completed Excel File |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Problem Set 6.5 Solutions (Word) |
Activities and Extra Resources
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
Zillow Activity |
Lesson 6.5 Video |
|