×
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
iPad Classroom Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple / Mac Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

Back to School Supplies
Expense Spreadsheet w/ Chart

Assignment: Students create an expense chart using a spreadsheet to show how much they have spent on school supplies. Students use the autosum formula to easily calculate the total expense costs.

Download: excel-school-supplies-expenses-finished-example.xlsx

Excel School Supplies Expenses - Finished Example

Excel School Supplies Expenses - Finished Example

Download: excel-school-supplies-price-list.pdf

School Supplies Prices List

Students choose school supplies from this list for their spreadsheet.

School Supplies Prices List

Download: school-supplies-expense-spreadsheet-with-chart-instructions.pdf

Student Instructions

Student Instructions

Excel Mini-Course in 4 Minutes:

Quickly learn the essentials you need for this lesson with these short, focused video tutorials. Watch all the videos to see how to create a budget and chart from start to finish or just watch the ones you need.

This Excel Lesson
Teaches the Following Basic Skills:

  • Creating and formatting a spreadsheet title using "merge and center"
  • Entering data in columns and rows
  • Using the simple formula "Autosum" to automatically calculate total expenses
  • Formatting numbers as currency and adding $ signs.
  • Creating a chart using the data entered.
  • Using different colors for chart bars to improve visual presentation
  • Creating, sizing, and positioning the chart to fit on a single page with the data
  • Searching, inserting, sizing, and positioning clipart or pictures
  • Using print preview and printing

Download: rubric-for-spreadsheet-with-chart.pdf

Excel Spreadsheet Rubric for Grading Assignments

Excel Spreadsheet Rubric for Grading Assignments

Excel Spreadsheets and Charts

  • Simple
    Bar Chart

    Excel Simple Bar Chart
  • Thanksgiving
    Dinner Shopping

    Thanksgiving Dinner Shopping Comparison Spreadsheet
  • Clothes
    Shopping Budget

    Excel Clothes Shopping Budget
  • Learn Excel
    in Minutes

    Learn Excel in Minutes
  • Excel Back
    to School

    Excel Back to School
  • Excel Pet
    Adoption

    Excel Pet Adoption
  • Excel
    Sports Budget

    Excel Sports Budget
  • Excel
    M & M Chart

    Excel M & M Chart
  • Excel
    Lemonade Stand

    Excel Lemonade Stand Spreadsheet and Chart