restiphone.blogg.se - Calculate pi in excel

The average value of pi that they received should also be analyzed. Collect all of the spreadsheets for evaluation.Īssessment: The spreadsheets can be collected and analyzed for assessing the students' knowledge with Microsoft Excel.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.Have the students type their names somewhere on the spreadsheet before printing.The average value of pi received should be somewhere close to the actual value of pi (3.14).You must edit this formula so that it reads "=Average(D2:D9)", Press Enter. When a new window opens, double click on the Average function from the menu.

Click on the formula tool in the toolbar (Fx).

In cell C12, type "Average Value of Pi." Press Enter.

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. This value will appear in cell D2 if entered correctly. The resulting number will be the value for pi. Hit "Enter." This will take the Circumference for circle one and divide it by the diameter for circle one. In the formulas bar at the top of the page, type "=C2/B2". Change the size to 12 and center the text.

Highlight all of the cells where you entered the data.

Be sure to enter all the values for all of the circles.

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.

(Example - A2 should be 1, A3 should be 2, etc.)

Type the numbers 1 through 8 in the appropriate cells under circle number.

Click and drag the arrow to the right until all of the text is visible. To do this put the cursor between "A" and "B" at the top of the page until a double arrow appears.

Adjust the column width so that the titles fit in the column.

Set this row to size 12, bold, and centered.

Click on "3" on the left side of the page.

In cell C1, type "Circumference (in)." Press Enter.

In cell B1, type "Diameter (in)." Press Enter.

In cell A1, type "Circle Number." Press Enter.

The students will open a new spreadsheet in Microsoft Excel.

Microsoft Excel (or equivalent spreadsheet program).

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

How does the diameter relate to circumference?ĭoes the circumference increase as the diameter increases? Multiple Intelligences: Logical-Mathematical, Visual-Spatial, Intrapersonal The students will also be able to take what they learned from their spreadsheet and calculate pi and area of their circles. The students will be able to find the value of pi, using the function tool, and dividing the circumference by the diameter. Student Outcomes: By the end of this lesson, the students will create a spreadsheet using their information from Lesson 5. Technology Problem-Solving and Decision Making Tools- 6.1 Social, Ethical, and Human Issues- 2.4, 2.5 (See Standards Link for Complete Standards)ĭata Analysis, Statistics, and Probability- 6.D.1īasic Operations and Concepts- 1.1, 1.3, 1.4 The average will also be calculated using the formula function in Microsoft Excel. 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. After all of the data for the circles is listed, the students will use the formula function to calculate pi for each circle. On a spreadsheet, the students will organize their measurements of radius, diameter, and circumference they recorded in the previous lesson. Overview of Lesson: The students will be using Microsoft Excel to organize and analyze the data they collected in Lesson Five.