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

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


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