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

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


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