Catchy Candy Wrappers
Similar Prisms
Similar solids have the same shape and their corresponding linear measures are proportional. The number of times you increase or decrease the linear dimensions of a solid is called the scale factor. You can use this table to investigate the volume and surface area of similar solids. Study the patterns you observe in this table. How can you use this information to develop your own spreadsheet in excel?
Use an excel spreadsheet to record the information that is appropriate for the container your team has chosen and enter your data. Explore how the excel program uses the formula you put into it to make the calculations for you.
Prism A |
Scale Factor B |
Length C |
Width C |
Height D |
Surface Area E |
Volume F |
A |
||||||
B |
||||||
C |
||||||
D |
The spreadsheet will evaluate the formula: 2*C3*DC + 2*C3*E3 + 2*D3+E3 = surface area
The spreadsheet will evaluate the formule: C5*D5*E5 = volume
Square the scale factor to determine the surface area.
The cube of the scale factor gives you the relationship to the volume.