K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators 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

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 iPads - iWork

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