K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
iPad Classroom Tech Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple Mac Keynote Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

Excel - Back to School Supplies Expenses

Students Create an Expense Chart for School Supplies


Students create an expense chart using a spreadsheet to show how much they have spent on school supplies.


Students use autosum to calculate the total expense costs.


Students create a chart showing their expenses.


Grades 4+



Download: excel-school-supplies-price-list.pdf


Download: excel-school-supplies-expenses-finished-example.xlsx


Download: school-supplies-expense-spreadsheet-with-chart-instructions.pdf


Download: rubric-for-spreadsheet-with-chart.pdf


Student Instructions:

1) You have $60.00 dollars to spend for school supplies.

2) Try to purchase as many items on this list as you can without going over the $60.00 limit.

3) Create a spreadsheet with all your items and their prices.

4) Use a formula (SUM) to calculate the total expenses for your items.

5) Create a bar chart of your expenses.

6) Fit everything on ONE printable page.




School Supplies Prices List Example

Make this price list available for students to view.

School Supplies Price List



Excel School Supplies Expenses - 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 expenses cost. Students create a chart illustrating the expenses.

Students should use print preview to ensure that everything will fit on a single page before printing.

School Supplies Expense Chart



Student Instructions:



Excel Spreadsheet Rubric for Grading Assignments:

Spreadsheet Rubric

More Ideas
For PC's and Microsoft Office

  • Excel
    Bar Chart
  • Excel Bar Chart
  • Thanksgiving
    Copy and Paste
  • Thanksgiving Copy and Paste
  • Green Screen
    Photo Editing
  • Green Screen Photo Editing
  • Computer Lab
  • Computer Lab Rules Essentials
  • California Regions
  • California Regions Brochure
  • Amazing Animals
  • Amazing Animals
  • I Am
    Poem Generator
  • I Am Poem Generator
  • "Floater"
  • I Can Float Animation
  • Learn PowerPoint
    in One Minute
  • Learn PowerPoint in One Minute
  • Copy and Paste
  • Copy and Paste Practice
  • M & M
    Excel Chart
  • Excel Pie Chart
  • Newspaper
  • Newspaper Template