**Overview of Lesson: **The students will be using Microsoft Excel to organize and analyze the data they collected in Lesson Five. On a spreadsheet, the students will organize their measurements of radius, diameter, and circumference they recorded in the previous lesson. After all of the data for the circles is listed, the students will use the formula function to calculate pi for each circle. When all of the pi values have been calculated, the students will average their pi values to see if they can come close to the actual value of pi. The average will also be calculated using the formula function in Microsoft Excel.

**
**Standards:

Measurement:

(See Standards Link for Complete Standards)

Number Sense and Operations- 6.N.13

Patterns, Relations, and Algebra- 6.P.4

Measurement- 6.M.5

Data Analysis, Statistics, and Probability- 6.D.1

**
**
Technology:

(See Standards Link for Complete Standards)

Basic Operations and Concepts- 1.1, 1.3, 1.4

Social, Ethical, and Human Issues- 2.4, 2.5

Technology Productivity Tools- 3.2

Technology Productivity Tools- 4.1

Technology Problem-Solving and Decision Making Tools- 6.1

**
****Student Outcomes: **By the end of this lesson, the students will create a spreadsheet using their information from Lesson 5. The students will be able to find the value of pi, using the function tool, and dividing the circumference by the diameter. The students will also be able to take what they learned from their spreadsheet and calculate pi and area of their circles.

**
**Lesson 6 of 9

**Length of Lesson: **1 Hour

**
****Instructional Mode: **Independent Activity

**
****Multiple Intelligences: **Logical-Mathematical, Visual-Spatial, Intrapersonal

**
**Essential Questions:

How does the diameter relate to circumference?

Does the circumference increase as the diameter increases?

What is pi? Where did pi originate?

How do we use pi to then calculate the circumference and area of a circle?

**
**Materials/Resources Needed:

**
**
- Computer Lab
- Microsoft Excel (or equivalent spreadsheet program)
- Worksheet from Lesson 5

**
**Instructional Strategies/Procedure:

**
**
- The students will open a new spreadsheet in Microsoft Excel.
- In cell A1, type "Circle Number." Press
**Enter.**
- In cell B1, type "Diameter (in)." Press
**Enter.**
- In cell C1, type "Circumference (in)." Press
**Enter.**
- In cell D1, type "Pi." Press
**Enter.**
- Click on "3" on the left side of the page. The entire row should be highlighted. Set this row to size 12, bold, and centered.
- Adjust the column width so that the titles fit in the column. To do this put the cursor between "A" and "B" at the top of the page until a double arrow appears. Click and drag the arrow to the right until all of the text is visible. Column A is now the appropriate size. Do the same for columns B, C, and D.
- Type the numbers 1 through 8 in the appropriate cells under circle number. (Example - A2 should be 1, A3 should be 2, etc.)
- Using their worksheets from the "Measuring Radius, Diameter, and Circumference" lesson, students will type the values corresponding with the circle number in the cells for diameter and circumference. Be sure to enter all the values for all of the circles.
- Highlight all of the cells where you entered the data. Change the size to 12 and center the text.
- Click the cursor inside cell D2. In the formulas bar at the top of the page, type "=C2/B2". Hit "Enter." This will take the Circumference for circle one and divide it by the diameter for circle one. The resulting number will be the value for pi. This value will appear in cell D2 if entered correctly.
- Click the cursor inside cell D3. In the formulas bar at the top of the page, type "=C3/B3", hit "Enter." Continue using this formula modified slightly each time for the remaining circles.
- In cell C12, type "Average Value of Pi." Press
**Enter.**
- Move the cursor to cell D12. Click on the formula tool in the toolbar (Fx). When a new window opens, double click on the Average function from the menu. Another window will come up. You must edit this formula so that it reads "=Average(D2:D9)", Press
**Enter.**
- The average value of pi received should be somewhere close to the actual value of pi (3.14).
- Have the students type their names somewhere on the spreadsheet before printing.
- Once all of the spreadsheets are printed, discuss what the students received for their average value of pi and discuss why it may or may not be exactly the value of pi.
- Collect all of the spreadsheets for evaluation.

**
**Example Spreadsheet: