Data journalism analysis

DATA HOMEWORK #1: Work on Microsoft Excel ONLY

1. Download the LA COUNTY SCHOOL SUSPENSIONS datasheet from the Week 6 Module. (Included below)
2. Sort the data in the first sheet by TOTAL SUSPENSIONS, descending order, to place the school district with the highest number of suspensions at the top
3. Insert a new worksheet and copy all the data over to the 2nd. Now insert a new column in the new sheet and use Excel to calculate the per capita rate of suspensions. Sort that new sheet to place the district with the highest rate of suspensions at the top.
4. That number is going to be just a fraction, so, in a new column multiply the rate by a larger number of students to get a more useful number (Hint: Try 100 and then 1000. Which creates a more useful number?)
5. Go back to the data and look at the reasons for the suspensions. In the district that had the most per capita suspensions, what looks like the problem? (Use your analytical skills for this part!) Write a note with your hypothesis in a blank cell next to the most troubled school district (the one with the highest rate) on your second worksheet.