Directions: This assignment is worth 10 points. This bonus will require each student to find shapes in their every day life. The student will then measure the dimensions of the objects and use a spreadsheet to calculate the perimeter and area of each object. When the assignment is complete. Save the assignment on your disk as: Bonus Assignment 5 and turn it in.
Question 1: Find five objects that are rectangular prism in your house (remember that a square is also a rectangle). Measure the length, width and height of all of these shapes in cm. Then, create a spreadsheet that meets the following requirements.
1) In cell A1, write the word object centered and in bold. Then list the name of the object in column A below the word object.
2) In cell B1, write the word length centered and in bold. Then, list the length of each object in column B.
3) In cell C1, write the word width centered and in bold. Then, list the width of each object in column C.
4) In cell D1, write the word height centered and in bold.
5) In cell E1, write the word Volume centered and in bold.
6) In cell E2, use the equation V=lwh to write a formula to find the perimeter of the object in column A. Then, copy and paste this formula into the correct cells in column E.
Question 2: Find five objects that are a cylinder in your house. Measure the diameter of all of these shapes in cm. Then, create a spreadsheet that meets the following requirements.
1) In cell A10, write the word object centered and in bold. Then list the name of the object in column A below the word object.
2) In cell B10, write the word Diameter centered and in bold. Then, list the length of each object in column B.
3) In cell C10, write the word Radius centered and in bold. Then, then create a formula to find the radius from the diameters in column B in column C.
4) In cell D10, write the word Volume centered and in bold.
5) In cell D11, use the equation V = pr2h to write a formula to find the area of the object in column A. Then, copy and paste this formula into the correct cells in column D.
Finally, save the spreadsheet to your disk and turn it in.