TP – Students Create and Format a Clothes Shopping Budget with a Chart by using Microsoft Excel
Students use a shopping list to purchase clothing to donate to needy children on a shopping trip. Students have a gift card allowance of $200.00 to spend. Students purchase as much as they can for one girl and one boy without going over the $200.00 budget.
Students enter their chosen clothing items and costs in a spreadsheet. Students use the sum function to calculate total expenses from a column of values (clothing expenses).
Students use a simple formula to calculate money left over (allowance – total clothing expenses).
MR. SILLMAN instructions:
Sample View:
If you think you are finished, please share with a classmate.
How did Excel help you with the math?
Now that you have seen this, what else could you create in Excel?
What could you use this program for?
What skills/functions do you still feel you need to practice?
IF YOU ARE DONE, you may go to code.org
Rubric:
Please use references below for any assistance needed