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).
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.
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 Spreadsheet Rubric for Grading Assignments:
For PC's and Microsoft Office