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.

 

 

Instructions:

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

 

Popular:
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
  • Copy and Paste
    Practice

    Copy and Paste Practice
  • Learn PowerPoint
    in One Minute

    Learn PowerPoint in One Minute
  • M & M
    Excel Chart

    Excel Pie Chart
  • Newspaper
    Template

    Newspaper Template