K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
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.

 

 

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

 

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
    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
    Excel Chart
  • Excel Pie Chart
  • Newspaper
    Template
  • Newspaper Template