Chicago Crime!

Data Analysis: Student Guide

Chicago Crime

The Mission

 

You and your partner have been assigned a very important goal. You want to help your entire class reveal information about crime in Chicago. As a group you have all agreed on a question, a question no one really knows the answer to. However as a class you will uncover the answer. You may or may not like the answer but you will learn more about your city. You and your partner must also investigate another question that you and your partner come up with.

As you answer these questions you must focus on the two neighborhoods you and your partner have. Remember you have been assigned a neighborhood and you will pick a second neighborhood. This way we can really get a glimpse of every corner of Chicago. You will need to collect and analyze data to arrive at your answers. Once you have your answers you can begin creating your 2 infographics to share out what you learned.

Supplies

 

Item Description:

Specific Instructions:

Flash Drive

Save work for this project here.

Spreadsheets

Use spreadsheets to track data that you need to answer your questions

Community profile sheets

Worksheets to help you explore a neighborhood

 

Your Job

 

To complete your infographic carefully carry out these tasks and highlight off what you have completed:

 

  1. Complete Words to Know Definition and a sentence.

  2. Complete the Chicago Crime Question Worksheet

  3. Complete the Community Profile Worksheet

  4. Complete the Working the Community Data Worksheet

  5. Complete the Chicago Crime CLEARMAP Worksheet

  6. Complete the Working the CRIME Data Worksheet

  7. Complete Infographics to the Rescue

  8. Participate in Infographics Gallery Walk

  9. Quiz Study Guide

  10. Complete Lessons Learned

  11. Upload your Infographic to your digital portfolio along with your spreadsheet to serve as evidence for your infographic. This will go in the section called Data Analysis

  12. Turn in the entire Data Analysis packet

  13. Add your Lessons Learned answers to your portfolio Data Analysis section too

  14. Quiz

  15. Complete Data Analysis Worksheet

Words to Know

 

spreadsheet

infographic

sort

database

function

chart       data analysis

Chicago Crime Definitions & Sentence Worksheet

Name:

Instructions: Define the words and write a sentence. Due 12 – 3

Words to Know

spreadsheet

infographic

sort

database

function

chart       data analysis

Spreadsheet (Definition) -a computer program in which figures arranged in the rows and columns of a grid can be manipulated and used in calculations.

Sentence: In computer class, we had to create a spreadsheet using all of the information given to us.

Infographic (Definition) -a visual image such as a chart or diagram used to represent information or data.

Sentence: In the meeting, they showed us an infographic based on the violence rates.

Sort (Definition) -the arrangement of data in a prescribed sequence.

Sentence: We had to sort the information alphabetically.

Database (Definition) -a structured set of data held in a computer, esp. one that is accessible in various ways.

Sentence: Some hackers may try to hack into the database to get more information.

Function (Definition) -an activity or purpose natural to or intended for a person or thing.

Sentence: I had to teach my mom how to use the callback function on the new phone.

Chart (Definition) -a sheet of information in the form of a table, graph, or diagram.

Sentence: In class we had to look at the chart and pull some important information from it.

Data Analysis (Definition) -Analysis of data is a process of inspecting, cleaning, transforming, and modeling data with the goal of discovering useful information, suggesting conclusions, and supporting decision making.

Sentence: The boy worked with the data analysis while others tried to work with other things.

Name:

Date:

Period:

Things to keep in mind

Directions: Here is a short summary check list of important issues to use with the collection and analysis of your evidence per each neighborhood. Due 2

 

  1. When working with data to analyze results and draw conclusions, it is essential that the data with which you are working is ‘clean’. This means that it is consistent, accurate and complete.

  2. The person working with the data should be alert to any anomalies, either within the numerical data itself or the demographic information attached to it. Making sure that data is clean before starting to work with it will help prevent misinterpretations, or having to go through the process again if problems further down the track are discovered.

  3. Always check data for inconsistent results. If something in the data is not what is expected, it needs to be investigated. It may just be a small problem, but on the other hand could be indicative of widespread problems within the assessment or the data gathering itself.

Chicago Crime Questions Worksheet

 

Name:

Instructions: Complete this worksheet. Due December 4th

http://www.newgeography.com/content/003456-why-are-there-so-many-murders-chicago

Write down the class question on Chicago Crime here: What is the underlying cause of crime in Chicago?

Answer:

Write down your partners question about Chicago Crime here:

Write down the name of your 2 Chicago communities here:

#1  East garfield

#2  Armor square

Write down the zip codes for your Community #1 here: 60612  60624

Write down the zip codes for your Community #2 here:  60616

 

Community Profile Worksheet

 

Instructions: Your goal is to complete an investigative profile on the two communities you have been assigned. This should be part of your investigation that helps you answer your questions by understanding about the neighborhoods you are responsible for.  Investigate at least 10 facts about each of your two assigned communities by pulling data from the following source: http://factfinder2.census.gov/faces/nav/jsf/pages/index.xhtml  Due 12 – 5 – 23

 

You must organize your information in a Excel spreadsheet.

 

VERY IMPORTANT: Your neighborhood may be made up of many different zip codes!!! So if one fact I want to look up about my neighborhood is population, I will need to find the population for all zip codes in my community in order to get that answer. That means you’ll probably need more than 10 pieces of data to get your 10 facts, because its all broken up into zip codes.

 

This is an example of how you might keep track of your information.

 

Neighborhood Community #1: HappyTown

Neighborhood Community #2: Armour Square

       Zip codes: 60612 60624

Zip codes: 60616

       Population: 33,472  38,105

Population: 48,433

Male Population: 16,038  17,668

Male population: 23,520

   

After you are done entering your community data into your spreadsheet, begin working with it to make some sense of it all. You can benefit from using functions to uncover new information or to help you answer your questions.

 

Save (two or three places) your spreadhsheet to a safe location and create a backup at all times!

 

Complete the next sheet titled: Working the Data

 

Chicago Crime CLEARMAP Worksheet

 

Instructions:You need to collect 4 months worth of data for your 2 neighborhoods and get it into a spreadsheet. You can collect data from the CLEARMAP database.  The database is available at http://gis.chicagopolice.org/  Due 12 – 10

 

Limitations:

  • You can only get data 4 months at a time.

  • You cannot get all  4 months years data at once. So you will need to pull data a little bit at a time.

  • Data cannot be downloaded but you can copy and paste from a table.

 

Get started! At http://gis.chicagopolice.org/ go to Crime Incidents in the top left corner. Next go to step 2 and click on Community to search by community. From the dropdown field choose your community and press GO.  (Make sure you have your pop up blocker turned off, ask your teacher for help)

 

Once you see the following you are almost ready to collect data.

 

Use the area below the map to change the dates. Remember you want 4 months worth of data

Top right corner will allow you to view data in a table. This can help you by allowing you to copy and paste data into a spreadsheet.



Depending on your questions you may want to leave out/include certain crimes.

 

Decide how to organize your data in your spreadsheet so you can answer your ?s.

Working the CRIME Data Worksheet

 

Instructions:

 

At this point you should have 1 week worth of crime data about your 2 communities. In this project you need to make use of all spreadsheet features listed below at least once. Pick and choose features that you used, especially if you didnt use them in the Working the Community Data Worksheet. Due 12 – 10\11

Sort data -> how did you use it and what did you uncover

count ->  how did you use it and what did you uncover

countif ->   how did you use it and what did you uncover

avg ->   how did you use it and what did you uncover

and ->    how did you use it and what did you uncover

or ->  how did you use it and what did you uncover

a pie chart and a line/bar chart -> how did you use it and what did you uncover, attach a copy of your charts

 

INFOGRAPHICS TO THE RESCUE

Instructions:

It is time to use what you have learned and organized so far to create an infographic. Here you can get creative but the goal is the following: communicate the answer to your 2 questions using a visual filled with facts in an clear and creative manner using an infographic. Due 12 – 12

 

Below are a few links of sites you can use for creating your infographic along with your rubric.

http://www.easel.ly/

http://infogr.am/

http://piktochart.com

 

Category

4

3

2

1

Topic

The topic of the infographic is

specific in nature and is intended to

inform or convince the viewer.

The topic of the infographic may be

a bit too broad to allow the viewer to

understand the main points.(2.5pts)

The topic of the infographic may be

a bit too broad to allow the viewer to

understand the main points.(2.5pts)

The topic of the infographic is

hard to ascertain and needs to be

made more specific.

Graphics – Relevance

All graphics are

related to the topic

and make it easier to understand.

All graphics are

related to the topic

and most make it

easier to understand.

All graphics relate to the topic.

Graphics do not relate to the topic.

Content – Accuracy

At least 4 accurate

facts are displayed on

the infographic.

3 accurate facts are

displayed on the

infographic.

2 accurate facts are

displayed on the

infographic.

Less than 2 accurate

facts are displayed on

the infographic.

Attractiveness

The infographic is

exceptionally

attractive in terms of design, layout, and neatness.

The infographic is

attractive in terms of design, layout and neatness.

The infographic is

acceptably attractive though it may be a bit messy

The infographic is

distractingly messy or very poorly designed. It is not attractive.

Mechanics

Capitalization and

punctuation are

correct throughout the infographic.

There is 1 error in

capitalization or

punctuation.

There are 2 errors in capitalization or

punctuation.

There are more than 2 errors in capitalization

or punctuation.

Grammar

There are no

grammatical mistakes on the infographic.

There is 1

grammatical mistake on the infographic.

There are 2

grammatical mistakes on the infographic.

There are more than 2 grammatical mistakes on the infographic.

Lessons Learned

Instructions: Answer the questions. Due 12 – 13

 

Were you and your partner successful  in this project? Why or why not? 3-4 sentences

Describe what you learned from this project: 3-4 sentences

How can you use what you learned in another class or in life? 2-3 sentences

Sometimes working to answer a question leads to more questions. What new questions might you have after finding the answers to your questions?

What did you use spreadsheets for? 2-3 sentences

What did you use infographics for? 2-3 sentences

What is data analysis? 2-3 sentences

What was difficult? 2-3 sentences

What was easy?2-3 sentences

 

Student Name: _____________________________

Stay On Track

 

Place this page in your folder or journal. The purpose of the document is to help you “Stay on Track” with the tasks. You can add components to the table if you need to. Submit this sheet when you have completed all work. Due 12 – 1-14

 

 

Completion

Completion Date:

Teacher Sign-off

Comments:

Complete the Chicago Crime Question Worksheet

  • Yes

  • No

     

Complete the Community Profile Worksheet

  • Yes

  • No

     

Complete the Working the Community Data Worksheet

  • Yes

  • No

     

Complete the Chicago Crime CLEARMAP Worksheet

  • Yes

  • No

     

Complete the Working the CRIME Data Worksheet

  • Yes

  • No

     

Complete Infographics to the Rescue

  • Yes

  • No

     

Participate in the Infographic Gallery Walk

  • Yes

  • No

     

Upload Project work to Portfolio

  • Yes

  • No

     
Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s