CCJ 340 Crime Analysis     

CCJ 340 Crime Analysis                     Module 3A                                    10/2017

 

INSTRUCTIONS

 

This week you are going to create presentation quality graphs (also known as charts). The assignment requires that you spend time learning the various commands in Excel that allow you to create and modify graphs. More specifically, you will be creating ten charts to mirror samples I provide on the forthcoming pages. These charts are described below along with the name of the Excel file you should use for the data analysis. At the end of the assignment you will create two of your own charts using datasets I have provided in the course.

 

Please note that graphs I present on the subsequent pages may have been done using a different dataset than you are provided. This means that you cannot copy the numbers or titles I present in my charts: you must run the analyses yourself using the data files provided in the module. These files change from term-to-term so make sure that you only use the files currently available in the module. Using older datasets from prior classes will result in a score of “0”.

 

When you are done creating your graphs you will need to copy them into the MS PowerPoint template available in the module. The template is labeled “HW_3A_Your Last Name Here” and you should add your name where indicated.

 

Make sure that you copy-and-paste your charts as “Picture files” as described in the videos. You should enlarge the graphs in PowerPoint template so they fill the available space, but DO NOT delete the target graph in the upper right corner. Please also make sure that you present the graphs in the order you see below: this order is mirrored in the PowerPoint template. If you are missing a graph just leave that slide blank.

 

This assignment needs to be electronically submitted to D2L’s Assignment dropbox by the date listed in the syllabus.  Go to D2L, Assignments, and select the Module 3A folder to upload your final completed PowerPoint file.

 

GRADING

 

The first ten graphs will be evaluated using the rubric shown below. To receive full credit your analyses have to be accurate and you must make good design choices for the chart following the recommendations provided in the module. Each chart also has design elements that are required to be eligible for full credit.

 

PRESENTATION Missing Some effort but graph has major problems Missing 2+ major elements Major element missing or flawed (chart title, legend, wrong type of graph), or two minor problems Minor element missing/flawed  (e.g., no Y-axis label, axis font sizes are different, aspect ratio is off) Exact match of sample graph or improved graph
0 6 7 8 9 10
ANALYSES Missing Major problem(s) but demonstrated some effort Minor problems No obvious problems
0 6 8 10


Section 1         (file: GRAPH Homicide Victims….)

 

In this section you will be using the SHR homicide data on victims to produce graphs that tell us something about these incidents.

 

Graph #1:  Pie Chart depicting the location or region of the offenses for your assigned year. Remember that your numbers may be different because I used a sample of the data. Full credit requires that you use the same color options as shown below (i.e., South = green, Northeast = red, etc.).

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Graph #2:  Bar Chart depicting the weapon used by homicide offenders. Please note that you will need to regroup weapons to match the chart below. Also, make sure that you isolate your data to the Region specified in the chart below. Finally, to earn full credit you must provide a note at the bottom of your chart detailing how the weapons were grouped for firearms and “other”.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Graph #3:  Column Chart depicting the race of victims and offenders involved in homicides. Note that you should exclude records where race was not reported (i.e., missing data). Make sure that you isolate your data to the Region specified in the chart below. Full credit requires the additional of a note on cases excluded and data labels as shown in the chart below.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


 

Graph #4:  Column Chart depicting the victim-offender relationship for murder suspects based on suspects’ gender. Note that the “Unknown” relationship category is excluded from the graph. Make sure that you isolate your data to the Region specified in the chart below. To earn full credit you must manipulate the chart legend to mirror the image below.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Section 2         (file: Graph Oregon DOC Offenders 2010_V..)

 

In this section you will be using the data obtained from the Oregon Department of Corrections (DOC). The dataset contains all of the inmates who were in DOC prisons as of 01/01/2010. A small number of cases have been removed at random to create different versions of the data. Please use this file to create the following graphs.

 

 

Graph #5:  Bar Chart depicting inmates’ age at admission to the DOC on the current charge (i.e., use Date_Admit and DOB). Full credit will only be given for charts that group the ages as shown below.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Graph #6:  Column Chart depicting the distribution of Oregon correctional inmates by gender and most serious crime. Note, in this case the percentages across all columns adds to 100% reflecting the total prison population as of Jan 1st, 2010. To earn full credit you must use different colors to identify gender and add a note (text box) reporting the total number of men and women incarcerated.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Graph #7:  Bar Chart – Originating County for inmates at the Oregon DOC in 2010. You should select just the 10 counties with the highest counts and note the remaining numbers in a text box. To earn full credit you should eliminate the grid lines and plot area border as done with the sample chart.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Section 4         (file: Graph Time Series_V…)

 

In this final section you will be using a file that contains criminal justice data aggregated by time, in this case by year. This type of data is ideally suited for time series graphs. Please produce graphs like those depicted below.

 

Graph #8:  Time Series line graph depicting the UCR Offense rates (per 100,000) by year from 1960 to 2016 [Worksheet: UCR Index Crimes]. The offense you are provided will be different than the chart below. Full credit requires the identification of the highest and lowest years and rates.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Graph #9: Time Series line graph depicting the number of men and women incarcerated. For your data you will be assigned a single state (as opposed to the sample chart below). Full credit requires that you accurately incorporate percent change into your chart. [Worksheet: Prisoners]

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Graph #10: Time Series line graph comparing two types of fatal transportation accident rates (per 100,000).  Your data will compare two different modes of transport rather than cars versus motorcycles in the sample below. To earn full credit you should add fills/color to the chart and plot areas as demonstrated in the sample chart. [Worksheet: Transport Deaths]

 

 

 

 

 

 

 

 

 

Use the remaining data from any of the Excel files given to you in this module to create two final graphs (i.e., something other than the ones above). Try to find data that are “graph worthy” in that your graph helps to see a pattern or relationship that might not be easily identifiable if it was presented in a table. When you are done, copy and paste the graphs to your PowerPoint file. These graphs will be evaluated using the following rubric:

 

 

 

 

Graph #11:  Your choice

 

 

 

Graph #12:  Your choice

 

 

 

 

 

 

PRESENTATION Missing Some effort but graph has major problems Missing 2+ major elements Major element missing or flawed (chart title, legend, wrong type of graph), or two minor problems Minor element missing or flawed  (e.g., no Y-axis label, axis font sizes are different, aspect ratio is off) Professional quality graph
0 6 7 8 9 10
DATA SELECTION & ANALYSES Missing Major concerns with accuracy of analyses – data are not worth graphing, easier to put in text or table Minor problems with analyses – data selected are simplistic (one variable only) or overly complicated (too many categories) No obvious problems with analyses – data selected are “worthy” – graph allows you see pattern might have missed in table
0 6 7 8 9 10

 

 

The post CCJ 340 Crime Analysis      appeared first on Classic Essay Blog.



Comments

Post a Comment

Popular posts from this blog

Chapter 10

Image
Read chapter 10, which is found on page 336 of the book that is attached. Once you have read chapter 10, write a one page summary on the chapter. After that, answer the two questions below on the next page. Do not include the questions on the final document. Just put the corresponding question number with the answer. 1. Political risk is the likelihood that the foreign investment of a business will be constrained by a host government’s policies. In dealing with this risk, companies conduct both macro and micro political risk analyses. Specific consideration is given to changing host-government policies, expropriation, and operational profitability risk. 2. Effective alliance management includes careful selection of partners, defining the tasks and scope of the alliance, addressing cross-cultural differences, and responding to host-government requirements. This page intentionally left blank International Management Culture, Strategy, and Behavior Eighth Edition Fred Luthans Universit
Read more

Java uses a braces (‘{‘ and ‘}’) to start and end all compound statements

Image
Requirements in the description This is a “take home” exam. It is open book, open notes, open Internet, but you may not discuss any part of the exam with any person other than the instructor. It is, if you consider the number and difficulty of the questions, not difficult. There are items that need to be drawn in this exam. These drawings may be the slowest part of the test for those who have no or limited experience with the drawing tools available on virtually all personal computers, but such applications provide adequate tools for doing this digitally. At most, once you have a drawing or graph completed you will only need to do some copy-and-paste work. Word itself has good drawing tools and thus does not require copying a pasting. PowerPoint excellent ones and even Excel’s drawing tools can prove adequate. On a Windows PC with Microsoft Office Paint can be used. Comparable tools are available in the Apple and Linux environments. A last resort is pencil-and-paper, photographing and
Read more

Policymaking and Technology

Image
Choose one (1) of the following discussion prompts; Prompt 1: Healthcare systems are huge, complex, and constantly changing as they respond to economic, technological, social, and historical factors. The availability of technology has a profound effect on the health care costs and the availability of medical care. Local, state and national policy makers have an impact on these systems. Explain what you would do to encourage and increase technological advances and availability and try to decrease costs for all the stakeholders involved. Support your responses with academic resources. Prompt 2: We have learned that new technology is the number one reason for escalating health care costs in America. Do you think that quality would be adversely impacted if the growth in medical technology were to be constrained in the United States for one year? If these costs could be reduced, and more people could gain access, do you think that this would be a reasonable trade-off? Would you pay a higher
Read more