Criminal justice

Select a police agency for which you can access their index of Part I offenses.

If you are having issues finding crime data, you could use the open-crime data offered by the Seattle Police Department at this link.

Create a spreadsheet with the Part I offenses for the past 10 years.

This spreadsheet should include data for the following offenses:

Homicide, rape, robbery, aggravated assault, burglary, motor vehicle theft, larceny-theft, and arson.

Develop a chart displaying the trends associated with the total crime for the city.

Develop a chart comparing the rates associated with each of the Part I offenses.

Develop a chart that displays the proportion of crime on each Part I offense.



Sample Solution