Open Excel

Write the heading (see rubric) in A1

To create your pie chart/graph for your 1^st question:

In A3, write your first question.

In A4, write your first answer choice.

In A5, write your second answer choice.

In A6, write your third answer choice.

In B4, write the number (out of 100) of how many people chose the A4 choice.

In B5, write the number (out of 100) of how many people chose the B4 choice.

In B6, write the number (out of 100) of how many people chose the B5 choice.

Now the fun part!

Highlight only the boxes for A4, 5, 6 and B4, 5, 6…

then click on the “chart wizard”  (it’s a bar graph icon on the top)

Decide if you want a column or a pie chart.  (and then which specific one you would like)

Then click next.

Click Next.

If you choose a pie chart (then click on the “data labels” tab.. and click percentage – the % labels should appear)

Click Next

Click Finish… your chart should appear in the excel sheet.  Does the computer’s version match your rough draft version?  **Make sure the chart accurately reflects your results**

You are able now to move it around (if you know how, you can also modify the colors, patterns, etc..)

Now do the process over again for questions 2, 3, and 4

You can start down around A15 with your second question data.  **Note the # for A and B boxes will change as you add more questions. 

When you are finished entering your data and creating your charts …

CHECK SPELLING! 

Also do a PRINT PREVIEW (you may also be able to make your charts a little bigger so that they are easier to read) make sure everything fits properly on the pages before you print. 

Check the rubric to make sure everything else is all set.

Fill out self evaluation.

Print out your document – or email it to yourself so you can finish/print it at home.