Excel - School Supplies Budget
Students Create a Budget Showing Allowance, Expenses, Money Left Over
Each student has $65.00 dollars to spend for school supplies. Students will keep some supplies for their own use and donate some to students in other classes. Students should purchase as much as they can up to the $65.00 limit without going over.
Students create a budget using a spreadsheet to show how much they have to spend (allowance) , and how much each item costs (expenses). Students use autosum to calculate the total costs. Students create a simple formula to subract total expenses from the $65.00 allowance to show how much money is left over (money left over). Students create a chart showing their expenses.
School Supplies Prices List Example
Make this school supplies price list available for students to view.
Excel School Supplies Budget - Finished Example
Students enter their school supply choices and their prices in the spreadsheet. Students format the prices with dollar signs and use formulas to calculate the total costs and money left over. Students create a chart illustrating the epenses.
Students should use print preview to ensure that everything will fit on a single page before printing.
Excel Spreadsheet Rubric for Grading Assignments:
For PC's and Microsoft Office