K5 Computer Lab Lesson Plans

Excel Chart - School Sports Equipment Expenses

Create an Excel Chart Showing Sports Equipment Expenses

Instructions: Students shop for sports equipment for their school. Students should spend as much as they can without going over $200.

 

Students create a spreadsheet using items chosen from the Sports Equipment Price List. Students format the numbers with dollar signs (currency). Students use a simple formula (SUM) to calculate the total cost and create a chart illustrating their expenses. Students may add clipart or related images.

Grades 3+

 

 

 

Download: excel-sports-equipment-expenses-chart-finished-example.xlsx

 

Download: excel-sports-equipment-price-list.pdf

 

 

Download: student-instructions-sports-equipment-expense-spreadsheet.pdf

 

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

 

 

Sports Equipment Expenses Chart - Finished Example:

 

 

Sports Equipment Price List Example:

Fantasy Sports Equipment Price List

 

 

Student Instructions:

 

 

Excel Spreadsheet Rubric for Grading Assignments:

Spreadsheet Rubric

 

 

Make a Chart in Excel - A Two Minute Tutorial

This video shows you how to make a chart like the one in this assignment. It shows you how to increase the font size, widen a column, merge and center the title, format numbers with the dollar sign, total a column of numbers with autosum, create the chart, and change the colors of the chart column bars.

This video is available in HD.

 

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