K5 Computer Lab Lesson Plans

iPad iWork Numbers - Clothes Expense Chart

Students Create an Expense Chart with the Numbers App for iPads

Students use the included "Clothes Shopping Price List" to buy several clothing items and record the costs.

Students use the iPad Numbers app to create a simple spreadsheet and chart using the data from their purchases and expenses.

This expense chart builds on the basic first chart here, and adds the requirement to use the SUM formula to calculate the total costs (expenses) of the clothing items. It also adds the requirement to format all the numbers with $ dollar signs.

Grades 3+

 

 

 

1) Students create a new blank chart in the iWork Numbers app.

2) Students enter a their title in cell A1 and merge it into cell B1

3) Students enter their clothing choices in column A, and the prices in column B.

4) Students use the "SUM" formula to automatically calculate their total costs.

5) Students format the prices with $ dollar signs.

6) Students create a column chart using their data.

 

 

 

iPad Numbers Clothes Shopping Expenses Finished Example:

iPad Numbers Clothes Expense Chart

 

 

Download: clothes-shopping-price-list.pdf

Students choose choose 7 or more items from this list for their spreadsheet.

Clothes Shopping Price List

 

 

How to Create the Expense Chart in Numbers for iPad - Time = 2:18

Learn how to create a spreadsheet and expense chart.

iPad Numbers Expense Chart Video

 

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