K5 Computer Lab Lesson Plans

iWork Numbers - Shopping Budget with Chart

Students Create a Shopping Budget that Calculates Total Expenses and Money Left Over

Students utilize the following spreadsheet skills:


1) Format a chart title and merge cells.

2) Enter and format data and numbers.

3) Use formulas to sum total expenses and subtract total expenses from spending allowance.

4) Create and format a bar chart.







Students begin with $100.00 budget and enter 6 items to purchase for new pet. Students enter costs for each item, limiting their total to less than $100.00.

Students use the Sum function to automatically calculate the total expenses. Students enter a formula to automatically subtract the $100.00 spending allowance from the total expenses.

Students use the data to create a column chart. Students format the data with increased font sizes, bold text, dollar signs and chart colors.





Finished iWork Numbers Shopping Budget Example:

iworks numbers shopping budget



Calculating the Total Expenses

To calculate the Total Expenses, click and drag to select all of the expenses. Next, click the function button and click Sum. This adds all of the expenses together and puts the total directly underneath.

sum calculation



Formula for Calculating Money Left Over

Click in the cell under the expenses and enter the equal sign. Enter the formula B4-B12. This subtracts the value in cell B4 from the value in B12. Click the green check mark to complete the calculation.

iworks shopping budget calculation



Creating the Shopping Budget Chart

Select the data as shown below. Click the Chart button and click the column chart selection.

iworks numbers create chart


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