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 - 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.

Grades 4+

 

 

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

 

Download: school-supplies-budget-finished-example.xlsx

 

 

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

 

 

School Supplies Prices List Example

Make this school supplies price list available for students to view.

School Supplies Price List

 

 

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 School Supplies Budget

 

Excel Spreadsheet Rubric for Grading Assignments:

 

Spreadsheet Rubric

 

Popular for iPads - iWork

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
    Chart
  • Excel Pie Chart
  • NewsPaper
    Template
  • Newspaper Template