K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
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
    Rules
  • Computer Lab Rules Essentials
  • California Regions
    Brochure
  • California Regions Brochure
  • Amazing Animals
    PowerPoint
  • Amazing Animals
  • I Am
    Poem Generator
  • I Am Poem Generator
  • "Floater"
    Animation
  • I Can Float Animation
  • Learn PowerPoint
    in One Minute
  • Learn PowerPoint in One Minute
  • Copy and Paste
    Practice
  • Copy and Paste Practice
  • M & M
    Excel Chart
  • Excel Pie Chart
  • Newspaper
    Template
  • Newspaper Template