Guiding+Activities+4

= Guiding Question: How are we are going to keep track of our savings and spending? (Alison) =

**Title**: Creating a Budget

**Prior Experience**: Prior to this lesson students would have looked through catalogs to get an idea of what they want to purchase for the school playground, they would have seen a presentation from an outside representative giving students ideas on how to raise money and get the community involved, and had a brainstorming session of how they could raise money.

**Synopsis** (Short 2-3 sentence overview of activity) After watching a Brain Pop video about a budget, students will be shown some of the basic aspects of a Microsoft Excel Spreadsheet. The students will then have the chance to create a budget to keep track of their earnings and spending throughout the project. The students will not use formulas but perform the math of adding and subtracting money on their own.

-Students will create a budget keeping track of earnings and spending for the playground resources. -Students will use math skills to add and subtract money. -Students will manage the budget throughout the entirety of the project to help guide them in making further decisions.
 * Objective(s) **

-Create a budget for your savings and spending at home.
 * Extension Activities **

**Resources** -Computers/Laptops -Brain Pop Video - Budgets -Microsoft Excel Spreadsheet

1. Show students Brain Pop Video entitled Budgets. 2. Demonstrate how to open and save a Microsoft Excel Spreadsheet with students in PBL groups. 3. Demonstrate how to do the following things in Excel: (NO FORMULAS - students need to do their own adding/subtracting) 4. Tell students they are going to work in their groups to use the things they have already brainstormed (fundraisers/ways to earn money and resources to purchase for the playground) to set up a budget in Excel that they will use for the continuation of the project. 5. Inform them to add and subtract their earnings as needed and keep totals on their budgets. 6. Emphasize what the video said about spending less (or same amount) than what you take in. 7. Facilitate students questions as they work and emphasize the following points: -What if you don't make as much money as you plan? What resource will you cut out? Will you continue your fundraiser longer? Will you do a different fundraiser? -What if you spend less than what you make? What will you do with the extra money? Will you buy more or donate it somewhere else? -How often will you make purchases? Will you purchase items as you earn the money? Will you wait until you have a large sum to purchase?
 * Procedure of Activity **
 * insert headings and subheadings
 * adjust length of columns/rows
 * type within the cells