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