K5 Computer Lab Lesson Plans

iWork Numbers - Expense Chart

Students Create a Simple Expense Spreadsheet and Column Chart

Students learn the following skills:

1) Students enter all data into the spreadsheet.
2) Students use the sum function to calculate the total expenses.
3) Students format all data to a larger font size and format the numbers with dollar signs.

4) Students select all data and create a basic bar chart.

5) Students merge the table cells to format the title (Jonathan's Shopping Expenses) across the table.




Students enter 5 items and limit their total expenditures to $100.00 or less.


Students enter numerical values for each item and then use the SUM function to automatically calculate the total.


Students can revise their costs and let the spreadsheet formula automatically re-calculate the total until it is less than or equal to $100.00.




Finished Expense Spreadsheet and Chart Example:

iworks numbers expense chart



Use the Sum Function to Calculate Total Expenses


sum function



Format the Numbers with Dollar Signs


expense chart format dollars



Merge Cells to Format Title


merge cells to format title



Choose a Color Fill for the Chart Bars


expense chart color fill


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