Tuesday, November 4, 2014

Creating Pie Charts


Pie charts are used when we have a finite number of the population that we are wanting to examine (IE, a fixed amount of pie). Consequently, a variation in one variable directly affects the other variables. If you eat a portion of the pie, you can't get any more without making a while new pie. Get it?

Today we will be looking at cell phone usage, specifically, which cell phones students use. First, we'll need to take a poll of our sample set. In this case, it will be our class. For the purposes of this exercise, we'll use this set of hypothetical polling data from a class of 23 students. If you have real polling data, use that instead.

Android 10
iPhone 7
Windows 3
Other 3

Now, to create a pie chart, we'll have to use Google Sheets. Follow the following steps:
  1. First, open your Google Drive and create a new Google Sheets file. Rename the file Cell Phone, and place the file in your charts folder. 
  2. Next, enter the phone type in the first column (A). In column B, enter the number of phones.
  3. Now, click on A1 and then click on B4 while holding down the shift key.
  4. With the data selected, click on the Insert menu and click on charts and select Pie Chart.
  5. Select customize and change the chart title to  Cell Phone Market Share.
  6. To save the chart as a .png file, click on the small down arrow in the upper right hand corner and click Save Image. Save the chart to a local Downloads folder and then upload it to your Google Drive.
  7. Congratulations! You're done!
Make sure your work is turned in by the end of class. If you have time, try changing the colors by clicking on each section. You can also change the chart to a bar chart by selecting a different type. Try it!

Your classwork will be graded on the following rubric.

Accuracy of the data. 0-4
Proper chart labeling 0-4
Proper spelling 0-2

Total 10 points

No comments:

Post a Comment