4th and 5th Grade Assignment #15

Learning goals:

*Make multiplication math formulas on spreadsheets

*Make math formulas on your own


The sixth grade class at school is selling candy to raise money for their field trip. One of the sixth graders has a younger sibling in my class where we are learning spreadsheets. Help this student organize the spreadsheet by writing math formulas.

1. Download the spread sheet by clicking here. Download it, open it then minimize it. Come back to the blog and keep reading directions.

2. Write math formulas for this spreadsheet and put in this information: Each type of candy has 24 in each box. The sixth grade ordered 6 boxes of M and Ms, Snickers and Kit Kats. They ordered 11 boxes of sour straws and 5 boxes of each kind of Hershey bar.

Write a math formula in every box in the “E” column. E4 through E9 need multiplication formulas to figure out how many candies were ordered. Cell E11 has the total of all types of candies added. Cell E12 is a projection of how much money they would make.

Here is a guide (guide click here) to help you think about how to write some of the math formulas.

You have to try to figure out how to write them on your own, today.


a.) Select the cell you want the answer to appear in.

b.) Type an equals sign.

c.) Write the formula thinking about which cells add, or multiply.

d.) Click enter.




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