K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
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 Lesson Plan - Expense Budget with Chart

Students Create a Clothing Expense Budget with a Chart

Students use a shopping list to buy some clothes and tally their expenses.

Students create a chart illustrating their clothing purchases and expenses.


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


Download: excel-clothing-expenses-with-chart-finished-example.xlsx


Download: student-instructions-clothes-shopping-expenses.docx


Download: step-by-step-excel-clothes-expenses-with-chart-instructions.docx


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



Instructions: Students have $125.00 to spend on school clothes. Students use the Clothes Shopping Price List to purchase as many items as they can without going over budget. Students create their spreadsheet using the list of clothes and their prices. Students use a formula (SUM) to calculate their total clothing expenses. Students create a chart illustrating their clothing expenses.


Clothes Shopping Price List:

Clothes Shopping Price List for Students



Clothing Expenses with Chart - Finished Example:

Students should size and position their clipart and chart so everything fits on a single printed page.

. Excel Expense Budget with Chart Lesson



Student Instructions - Clothes Shopping Expenses

Student Instructions - Clothes Shopping Expenses



Step by Step Instructions for Excel:

Excel Clothes Shopping Expenses Instructions



Excel Spreadsheet Rubric for Grading Assignments:


Spreadsheet Rubric



Make a Chart in Excel - A Two Minute Tutorial

This video shows you how to make a chart like the one in this assignment. It shows you how to increase the font size, widen a column, merge and center the title, format numbers with the dollar sign, total a column of numbers with autosum, create the chart, and change the colors of the chart column bars.




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
  • 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
  • Learn PowerPoint
    in One Minute
  • Learn PowerPoint in One Minute
  • Copy and Paste
  • Copy and Paste Practice
  • M & M
    Excel Chart
  • Excel Pie Chart
  • Newspaper
  • Newspaper Template