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



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

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
  • Copy and Paste

    Copy and Paste Practice
  • Learn PowerPoint
    in One Minute

    Learn PowerPoint in One Minute
  • M & M
    Excel Chart

    Excel Pie Chart
  • Newspaper

    Newspaper Template