K5 Computer Lab Lesson Plans

Excel Clothes Shopping Budget with Chart

Students Create and Format a Clothes Shopping Budget with a Chart

Students use a shopping list to purchase clothing to donate to needy children on a shopping trip.


Students have a gift card allowance of $150.00 to spend.


Students purchase as much as they can for one girl and one boy without going over the $150.00 budget.


Students enter their chosen clothing items and costs in a spreadsheet.



Students use the sum function to calculate total expenses from a column of values (clothing expenses).


Students use a simple formula to calculate money left over (allowance - total clothing expenses).


The instructions are for Microsoft Excel 2007 + version, but the data and chart can be recreated using any of the various Excel versions or even non Microsoft variants. Grades 4 and up



This lesson builds on the expense budget lessons by adding the following requirement:



Excel Shopping Budget with Chart Finished Example:

Download: clothes-shopping-budget-chart-example.xlsx


Excel Shopping Budget wtih Chart Example



Clothes Shopping Price List

Download: clothes-shopping-price-list-20.pdf

Clothes Shopping Price List



Alternate Version for Upper Elementary:

Requires Online Price Research

These are instructions for students to create the clothes shopping budget using real world pricing found online.

Download: clothes-shopping-spreadsheet-instructions-requires-price-research.docx


Excel Clothes Budget Instructions - Requires online research




Excel Spreadsheet Rubric for Grading Assignments:

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

Spreadsheet Rubric


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
  • Copy and Paste

    Copy and Paste Practice
  • Learn PowerPoint
    in One Minute

    Learn PowerPoint in One Minute
  • M & M
    Excel Chart

    Excel Pie Chart
  • Newspaper

    Newspaper Template