4th and 5th Gr. Assigment #16

Learning Goals:

*Review the 4 basic steps to writing spreadsheet math formulas.

*Learn how to put division into spreadsheet math formulas.

Directions:

1. Read this to understand the story first.

Ms. Dolores’ class was learning estimating. Ms. Dolores bought many bags of M & Ms and put them in  a jar. The class used different ways to estimate how many were there. When they were done, Ms. Dolores challenged the class. “Figure out how many bags of M & Ms I bought and I will let you eat all of them!” One student had Mr. Litt’s class and said, I know how we can figure this out with a spreadsheet!”

Download the spreadsheet by clicking here.

2. Put the umbers of M & Ms the class counted into the spreadsheet. There were 157 reds, 162 greens, 225 blues, 165 browns, and 226 yellows.

3. Put math formulas into cell D11 and D13 that will tell us how many bags Ms. Dolores bought. Read the guide carefully, it brings you through how to solve this problem step by step.

Guide click here.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s