Charting Criminal Justice Data (Comprehensive Review)

Charting Criminal Justice Data (Comprehensive Review)

Charting Criminal Justice Data (Comprehensive Review)

order now

Task 1 International Incarceration rates

When saving files for submission, include your last name in the file name.

  1. Open the file named SC4 Data from the Data Files and then Save As SC4 Criminal Justice.
  2. On the International tab, use a function in cell D20 to find the average of the Individuals incarcerated data.
  3. Create a bar chart that looks like this:

Figure 4.68 Figure 4.68

  1. Move and or resize it so that it does not cover any of the data.
  2. In cell A25 write a brief note explaining why a bar (or column) chart is a better choice for this data than a pie chart.
  3. Set the Print Area so that everything prints, except for the explanation you added in cell A25.
  4. Preview the International worksheet in Print Preview and make any changes needed to print professionally on one page.

Task 2 Disenfranchisement Rate

Felony disenfranchisement is the exclusion from voting of people otherwise eligible to vote (known as disfranchisement) due to a conviction of a criminal offense, usually restricted to the more serious class of crimes: felonies. Jurisdictions vary as to whether they make such disfranchisement permanent, or restore suffrage after a person has served a sentence, or completed parole or probation.

On the Disenfranchisement rate sheet, use the Recommended Chart tool to create the following three charts. Put each chart on its own individual sheet. (Note: Not an object in a spreadsheet.)

Chart1 — Felony Disenfranchisement Rate Washington

Figure 4.69 Figure 4.69


This is called a Clustered column chart in the Recommended charts tool, but it is really a combo chart – with some data displayed as columns and some data displayed as a line.

You will need to edit the Chart Title to include your last name.

You may need to adjust the chart size to make it look like the illustration.

Put the chart on its own individual sheet — don’t leave it as an object on the spreadsheet.


Chart2 — Felony Disenfranchisement Rate Oregon

Combo chart with same format as Chart 1, but with Oregon data. Title and legend edited to Oregon. Figure 4.70

Take a look at both the Washington and Oregon charts. They are the same kind of chart, but your charts may look different because the data is a bit different.

To make them more similar – make sure that the vertical axes are the same in both charts. Format the left vertical (value) axis, so that the Maximum is 20000. Format the right vertical axis, so that the Maximum is .20.

Chart3 – Comparison – Oregon and Washington

Chart3 – Comparison – Oregon and Washington


Be sure that you have years as labels on the horizontal axis (not 1, 2, 3 . . . )

This chart is on its own separate sheet.

All worksheet tabs should have a label.

  1. When you have completed all three charts, save your work. Preview the worksheet(s) in Print Preview and make any necessary changes for professional printing.
  2. Submit the SC4 Criminal Justice workbook as directed by your instructor.