GRAPHS & TABLES (DUE DATE 11/17)

Once the data are imported into Google Sheets, you will need to analyze them. The training on how to use Google Sheets will be provided during class in a computer lab. Subsequent training will be offered by appointment. 

You will begin to analyze a particular aspect of the data that has been collected. To analyze our data, we will start by summarizing our data using descriptive statistics. You will then explore the relationships between the two variables that interest you (from your research question and hypothesis). This will be represented in tables that include raw and percentage data. Together we will learn to create tables and charts in Google Sheets that can help us display the data related to our research questions of interest. Each student will then compile these tables and charts into an OpenLab post. 

For example, you will show a Line Graph of a chosen crime ( homicide, for example) in your neighborhood, and rates for this crime at the state, and the national level for the past 10 years. You will also calculate percentage change for your picked crime comparing such percentage change in your neighborhood.

Here is how to create a line graph in Google Sheets:

Make a time series graph in google sheets

Here is how to calculate percentage change in Google Sheets: Percentage, Percent Change, Percent Increase, Percent of Total Formulas – Google Sheets Tutorial

Here is how to calculate rate per 100,000 for a chosen crime: Crime Rate = Total Crime / Population *100,000 [use population from Step 6]

Your analysis post will include: 

• reflections on your tables (How does your pivot/bivariate table help you to both answer your research question and present your research findings?)
• reflections on your line graph (How does the graph help you to answer and present your research question and findings?); 
• Reflection on crime trends in your chosen crime at the local, state and national levels. 
• Reflection how the chosen crime (homicide, for example) increased or decreased as a percentage of all violent/property crimes.
• Was your hypothesis supported? Why do you think it was/wasn’t so?

Example of Line Graph of Homicide As Related to All Violent Crime (using Newark NJ Summary Crime Data from FBI) (the chart is linked to data in Google Sheets)

Examples of Line Charts (Crime Data from FBI) (the chart is linked to data in Google Sheets). 

Example of a Line Chart Comparing State and National Homicide Rates (the chart is linked to data in Google Sheets). 

Share your analysis in the OpenLab and write a short post reflecting on the bullet points above. Offer feedback to at least two of your classmates’ reflections.  

Step Six: Download Neighborhood Profile Data from NYU Furman Center’s New York City Neighborhood Data Profiles (Due 10/30)

Go to the NYU Furman Center’s New York City Neighborhood Data Profiles website (your exact neighborhood name may not be included, so pick the one closest to it. It may also be combined with another neighborhood). After you select the neighborhood, you will be redirected to a page for the neighborhood that has descriptions for DEMOGRAPHICS, HOUSING, and NEIGHBORHOOD SERVICES AND CONDITIONS. This is your neighborhood “DATA PROFILE.” Download these data and import them to Google Sheets.

If you live outside of New York City, you may pick your town overall, as opposed to a neighborhood. Such data can be gleaned from the US Census. I have found information on my town (Bloomfield, NJ) from this site, you can see it here. 

Share your Google Sheets link in the OpenLab and write a short post reflecting on the data you accessed from this source. Are you surprised by any of data points? What are your expectations of how this is related to the overall DARE project?  Offer feedback to at least two of your classmates’ reflections.  

Here is an example of what data would look like for the neighborhood you chose (see Neighborhood Data Profile sheet):  Neighborhood Data Profile

In this step, you are asked to download crime data from your neighborhood as well as state and national data. Go to the FBI crime Data Explorer and filter data by State and download US and state data. Go to your local police data (NYPD for most of you) and choose your home precinct and download historical crime data and then import it into Google Sheets. 

Share your Google Sheets link in the OpenLab and write a short post reflecting on the data you accessed from this source. Are you surprised by any of the data points? What are your expectations of how this is related to the overall DARE project? Write about the advantages and disadvantages of official crime data. Offer feedback to at least two of your classmates’ reflections.  

Here is how to download data and import data into Google Sheets:

How to import or convert a CSV file into Google Sheets

Here is an example of what data would look like for the precinct you chose: Data for DARE Assignment

Due Date: October 18th