5th Grade Skittles Spreadsheet
Ms. Bradlee, a fifth grade teacher at Chamberlayne Elementary, wanted a way for her students to keep track of their behavior incentive program. She uses a currency of Skittles to reward good behavior, with each color worth a different amount of money. So her students needed to keep a weekly total of their earnings and also the sum throughout the year. I created a template for them to use that you can download by clicking here. But the important part of this lesson is to guide the students through the steps of creating the various formulas. It’s a great way to make math practical and interesting. For each type of Skittle the students had to multiply by the cash value and then add them up. You can see a sample by clicking the picture to make it larger. Notice the complicated formula at the top. The students did that themselves! Now they have a quick way to keep track of their earnings.