K5 Computer Lab Lesson Plans

Excel - Puppy Pet Adoption Budget

Students Create an Excel Puppy Pet Adoption Budget and Chart

Students have a budget of $200.00 to adopt a new puppy and a variety of related items for the puppy. Puppies need a place to sleep, bowls for food, toys, a collar and leash, and other items. Students choose all the items they think they need to get started taking care of the new puppy, but they must keep costs under $200.00.

Students create a budget using a spreadsheet showing how much they have to spend (allowance), and how much each item costs (expenses). Students use the autosum formula to calculate the total costs. Students use a simple formula to subtract total adoption expenses from the $200.00 allowance to show how much money is left over (money left over).

Grades 4+

 

 

Excel Pet Adoption Price List

Requirements:

 

1) Students must choose all the items they think are necessary to care for a new puppy.

2) Students must get as much as they can for $200.00 without going over budget.

3) Students must create a complete budget showing allowance, total expenses and money left over.

 

 

 

 

Make this price list available for students to view.

Download: excel-pet-adoption-price-list.pdf

 

Puppy Pet Adoption Price List

 

 

Excel Pet Adoption Budget Finished Example:

Students enter their pet and accessories prices into the spreadsheet. Students format the prices with dollar signs and use formulas to calculate the total costs and money left over. Students create a chart illustrating the costs.

Excel Puppy Pet Adoption

 

 

Excel Spreadsheet Rubric for Grading Assignments:

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

 

 

Spreadsheet Rubric

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