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

 

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

    Copy and Paste Practice
  • Learn PowerPoint
    in One Minute

    Learn PowerPoint in One Minute
  • M & M
    Excel Chart

    Excel Pie Chart
  • Newspaper
    Template

    Newspaper Template