Okay class Good Morning!
and today we are going to review, Exam which for your class is going to be Exam #2
And once you log into blackboard
click on exam number 2. It should come up for you
and it is going to be called the Exam #2 the perfect pie chart
sense it is important for you to learn how to interpret data communicate findings
the following assignment will assist you in learning how to create great looking
accurate charts.
The instructions, I labeled for you 1-10 so
its not very difficult task you just
have to get it done
I'm not going to bore you with reading to you, because I know
each and every one of you can do that. But what I would like to go ahead
and jump to and showing you how to create your pie charts
Once you open
Excel. Let me see I am in 
Sheet #2, Chart #2, Sheet #2
ok I downloaded a
data table which looks like
this in excel
It isn't primarily 
a typical spreadsheet that you might download
from the Census.gov website. This is a
Housing Survey. 
The table that I used
have to deal with child abuse and neglect cases reported  
and investigated by state 2006
I looked at 1,2,3,4.. 
5 different states, Alabama, Alaska
Arizona, Arkansas
California. Clearly, I just copied the
first five states
the data that was there and it's important
for you to note that in your pie chart
you need to have a title. You need to  have a legend
which basically explains to the viewer what
the chart is about. Let's see here
I can scroll down, and you need to of course have
the source of your  information added on
that chart
so this is pretty much what it should
look like
your pie chart
the data table in Excel, that I pulled from, I simply listed the states 
on one.. in one column and listed the  numbers
I actually went with the actual numbers for this particular
pie chart 
You're going to be using percentages 
and using that's in a column, but you can see you
If you click on the chart wizard in Excel
 Those of you that have experience in making charts with excel
Feel free to move forward at your own pace
I'm gonna click on pie chart and  I
do want you guys to use the
 guys and gals cheesy exploded pie chart
and click on the sample and it gives you a
little preview of what it looks like 
Then you are going to click next
you wanna go with column. Don't worry
about series for right now
you want to show
label and percent in your legend
You want to show legend on your right  hand side that's fine
and for titles you can type in the title
of your chart. Usually you can take
this
information from your Excel
data table that you originally use and
probably
before easier for you put it as a new sheet or column number 6
and then I'll click on finish
Now as you can see here, here's your chart
its almost done.
If your in.. using Excel you know that you
ski textile and you can type in
the title up your chart as well
as selected again type in the source
of your information  and  I'll go back to it 
and that's pretty much all there is to it to
create a chart
using Excel 
At the end of the course
Go back to instructions
and you want to
once you have all your pie charts done
your going to upload them to your free account
Slideshare
Your going to send and upload the link according to the instructions
and I will give you a grade, and I think you'll be very pleased with yourselves
So I can't wait to see what everyone does
with this particular assignment
Good Luck and if you have questions feel free to
email me.
and that's how you a create the perfect pie
chart
