K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators 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

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 iPads - iWork

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
  • Learn PowerPoint
    in One Minute
  • Learn PowerPoint in One Minute
  • Copy and Paste
    Practice
  • Copy and Paste Practice
  • M&M
    Chart
  • Excel Pie Chart
  • NewsPaper
    Template
  • Newspaper Template