August 15, 1999



Using Fractions, Decimals, and Percents Interchangeably to Create a Circle Graph and Visual Demonstration

Creating Circle Graphs (pie charts) using Excel and a visual demonstration in Power Point. Have the class take a quick survey. Something like:

1. Which season does your birthday fall on (summer, spring, fall, or winter)?

2. How many have blue eyes, green eyes, brown eyes?

Let’s assume the first choice was selected and there are 7 kids born in the spring, 5 kids born in the summer, 9 kids born in the fall, and 3 kids born in the winter. How many total students are in the class?

|Season |Frequency |

|Spring | 7 |

|Summer | 5 |

|Fall | 9 |

|Winter | + 3 |

|Total: | 24 |

Given there are a total of 24 students, we can now determine the fraction that represents each season and percentages. Have the kids answer the questions and fill in the chart on their worksheet and solve the following problems…working between the fraction, decimal, and percent interchangeably.

|Season |Fraction |Approximate Decimal |Approximate |

| | |Value |Percentage |

|Spring |6 1 |.25 |25% |

| |24 4 | | |

|Summer |5 |.208333 |20.8% |

| |24 | | |

|Fall |10 5 |.41667 |41.7% |

| |24 12 | | |

|Winter | 3 1 |.125 |12.5% |

| |24 8 | | |

Next, since we know there are 360º in a circle we will need to divide or proportion the circle into the corresponding pie pieces.

|Season |Decimal x 360° |Approximate |

| | |Degrees of Circle |

|Spring |.25 ( 360° |90° |

|Summer |.208333 ( 360° |75° |

|Fall |.41667 ( 360° |150° |

|Winter |.125 ( 360° |45° |

Using Microsoft Excel:

| | |

| | |

|Open Microsoft Excel. Type in the data as| |

|shown at the right. | |

| | |

|Highlight all of the Data by left | |

|clicking and holding down the button from| |

|one corner of the data to the opposite | |

|corner. | |

|With all of the data highlighted click on| |

|the Chart Wizard button in the toolbars |[pic] |

|at the top. | |

| |[pic] |

| | |

|When the Chart Wizard window appears, | |

|click on the Chart Type “Pie” and choose | |

|the second graph. | |

| |[pic] |

| | |

|Continue pressing the Next > button until| |

|“Chart title” appears. Here you can add | |

|a title to the circle graph. | |

| | |

|Finally, click on the finish button. |[pic] |

| | |

| | |

| | |

| | |

| | |

| | |

| | |

| | |

|Your circle graph will appear. Right |[pic] |

|click on your circle graph and choose | |

|“Format Data Series.” | |

| |[pic] |

| | |

|Click on the “Data Labels” tab, then | |

|click on “Percentage,” and lastly click | |

|“ok.” | |

| |[pic] |

|Look at the percents, and check them | |

|against the percents you found in your | |

|table. | |

Using Microsoft Power Point:

Now the kids will create an electronic flip book comparing the decimal to the fraction to the percent, and they will include a model of the fraction. When finished, they will have a total of 6 slides.

| |[pic] |

|1) Open Microsoft Power Point. When open, | |

|click to add your title. Type in your title. | |

|Then click to add the sub title. Type your | |

|name in this blank. | |

|2) Now you’re ready for your next slide. |[pic] |

|Click on “Insert” and then drag the arrow to | |

|“New Slide,” and left click again. A new | |

|slide will be added. | |

| |[pic] |

| | |

|3) Click to add a title. Type in the title of| |

|your survey. Then click on the box to add | |

|text. Here you’ll list your survey results. | |

| |[pic] |

|4) To make the table to show your results, | |

|click on “Insert” and then click on “Table.” | |

| | |

|When the Insert Table box pops up, click on | |

|the arrow so there are 2 columns. Then change| |

|rows to 5. Lastly, press ok. | |

| |[pic] |

|5) Enter your results into the table. | |

| |[pic] |

| | |

|6) Add another slide. Add the title of your | |

|first season. Then add a 2 row by 2 column | |

|table. | |

| |[pic] |

|7) You have four squares to enter data in. In| |

|one square, add the fraction for that season,| |

|then in the next square, add the decimal, | |

|then the percents, then create a model of the| |

|fraction. | |

| |[pic] |

|8) Creating a model of the fraction is fun! | |

|One way to do it is to left click on “Auto | |

|Shapes” in the far left bottom corner of the | |

|screen then go to “Basic Shapes.” Choose a | |

|shape. | |

|9) After choosing a shape, go to the square |[pic] [pic] |

|you want to add the shape to. Left click and | |

|drag out the shape. While the shape is still | |

|highlighted, right click on the shape and | |

|choose “Copy.” Right click again and choose | |

|“Paste.” | |

| | |

|Copy and paste as many shapes as you need to | |

|equal your fractions denominator. | |

| |[pic] |

| | |

|10) When all your shapes are added, spread | |

|them out. Then double click on a shape and | |

|change the “Fill Color” to “White.” Then | |

|click on “ok.” Change all the shapes to | |

|white. | |

| |[pic] |

|11) Now that your shapes are white, you’ll | |

|need to “color in” your numerator. To do | |

|this, double click on a shape and pick a | |

|color (use the same color for each shape), | |

|then press “ok.” “Color in” the number of | |

|shapes needed to represent your numerator. | |

|12) Now you’ll need to follow steps 6-11 |[pic] |

|three more times to complete the next thee | |

|seasons. | |

|13) If you have a large number of shapes to |[pic] |

|change the color of, you can hold down the | |

|“Shift” key on your key board and left click | |

|on each shape you’d like to change the color | |

|of. When you have clicked on each shape, | |

|double click on one and then choose the color| |

|you want and press “ok.” | |

| |[pic] |

| | |

|14) When finished, click on the first slide, | |

|then click on “View” and choose “Slide Show.”| |

|Now you can click through your slide show! | |

-----------------------

=

6th GRADE Unit 3

Have

Fun!

[pic]

=

=

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download