Homework Assignment Five

Directions:  This assignment will create a spreadsheet that calculates the volume of rectangular prisms, triangular prisms, and cylinders.  The assignment has 15 questions and is worth 15 points.

For this assignment we will use the following equations:

 

1) V = lwh  for a rectangular prism.

2) V = Bh   for a triangular prism.  (Remember that B = .5bh, or is the area of the base)

3) for a cylinder.

 

Open a new spreadsheet and create a spreadsheet that will calculate the volumes of a rectangular prism, a triangular prism, and a cylinder.  Use the spreadsheet to find the volume of each shape in worksheet 4-7 which is below. Make your spreadsheet look like the following.

 

 

Problems 1-6: Rectangular Prisms

 

1) l = 4 ft, w = 12 ft, h = 15 ft

2) l = 4.5 cm, w = 6.5 cm, h = 9cm

3) l = 50 cm, w = 35 cm, h =  48

4) l = 16 m, w = 13 m , h = 15 m

5) l = 5.8 ft, w = 8 ft, h = 6 ft

6) l = 5.8 ft, w = .275 ft, h = .05 ft

 

Problems 7-12:  Cylinders

 

7) r = 10 m, h = 8 m

8) d = 12 ft, h = 9 ft

9) d = 6 km, h = .5 km

10) r = 6 yd, h = 6.5 yd

11) r = 3.1 cm, h = 8.3 cm

12) d = 7.2 in, h = 5.25 in

 

Problems 13-15:  Triangular Prisms

 

13) B = 6 m, h = 4.7 m

14) B = 243 cm, h = 456 cm

15) B = 9.3 km, h = .023 km

 

After you have finished, save the assignment to your disk as:  Homework Assignment 5 and Turn it in.


Back to Assignment Five

Return to EMAT 6700

Back to BJ's Page