QUESTION: 

What happens to the volumes and surface area of three-dimensional shapes as their dimensions change?

 

OBJECTIVE:

     The student will use a spreadsheet to compute the volumes of different geometric shapes.

 

OBJECTIVES:

Using the geometry volume and surface area formulas, the student will design a spreadsheet listing the geometric shapes (rows) and the different dimensions (columns).

 

The student will translate geometric formulas into the language of the spreadsheet.

The student will input values for the radius, width, height, base, sides, and altitude to compute the volumes and surface areas of different geometric shapes.

The student will explore what happens to the volume when the dimensions are altered.

EVALUATION:

A. Each student will make 2 copies of each of the following  spreadsheets and hand in one set to Mr. Pryor (Keyboarding) and one set to Mrs. Webster (Algebra/Geometry I).

1. Spreadsheet with formulas shown
2. Spreadsheet showing volumes and surface areas for the given shapes
3. Spreadsheet with dimensions doubled
4. Spreadsheet with dimensions divided by two
5. Spreadsheet dimensions tripled
6. Spreadsheet with dimensions of all shapes for assigned volume 

 B. Students will also complete the following and give it to Mrs. Webster

"What's Happening to the Volume?" Worksheet

Extra Credit:

Make scale drawings of your shapes with the computer

Make models of your shapes for your assigned volume

Go to next page

Go to Project Homepage

Go to the CD-ROM Table of Contents

© 1998 Elmwood Jr/Sr High School