Excel Lesson Plan - Expense Budget with Chart
Students Create a Clothing Expense Budget with a Chart
Students use a shopping list to buy some clothes and tally their expenses.
Students create a chart illustrating their clothing purchases and expenses.
Instructions: Students have $125.00 to spend on school clothes. Students use the Clothes Shopping Price List to purchase as many items as they can without going over budget. Students create their spreadsheet using the list of clothes and their prices. Students use a formula (SUM) to calculate their total clothing expenses. Students create a chart illustrating their clothing expenses.
Clothes Shopping Price List:
Clothing Expenses with Chart - Finished Example:
Students should size and position their clipart and chart so everything fits on a single printed page.
Student Instructions - Clothes Shopping Expenses
Step by Step Instructions for Excel:
Excel Spreadsheet Rubric for Grading Assignments:
Make a Chart in Excel - A Two Minute Tutorial
This video shows you how to make a chart like the one in this assignment. It shows you how to increase the font size, widen a column, merge and center the title, format numbers with the dollar sign, total a column of numbers with autosum, create the chart, and change the colors of the chart column bars.
For PC's and Microsoft Office