Assign. #4

ASSIGNMENT #4: DEMOGRAPHIC COMPOSITION AND CHANGE OVER TIME
DUE NOVEMBER 1st @ 11:59 uploaded to Blackboard   |   10 pts (10% of total grade)

In Weeks 8-9 we learned how to search, download, clean, and visualize data from the Census, ACS, and NYC OpenData. For this assignment you have the opportunity to do the same for data on your study neighborhood. Note: the data from this assignment may be used in your final neighborhood profile.

Please refer to the class activities from Weeks 8 and 9 as a guide.

To complete this assignment, you need to:

1) Search for demographic datasets from two time periods in the sources we reviewed in class—Census, American Community Survey, and/or NYC OpenData and save them as excel files. Be sure to:
a. Consider only demographic data for this assignment (e.g. race, age, income etc.
b. Choose comparable datasets from two different time periods to show change over                         time (10-20 years is a good timespan)
c. Start a folder to keep other datasets of interest as you may want to use them later in                      your final profile—this can save you from having to search again.

2) Clean the datasets so you are working with only the relevant data for your specific neighborhood area. Remember, it’s best practice to duplicate the excel tab so you have an ‘original’ version and one that you work from. Be careful when sorting! You may choose to combine the data from both years into one file to make visualization.

3) Visualize your data using excel in a manner of your choosing (e.g. bar graph, line graph, etc.) so it clearly shows change over time for the relevant data and is easy to interpret. Be sure to:
a. Edit titles, labels, scales etc. to convey the information fully and clearly.
b. Think about color and consider what your data would look like if printed in greyscale                      (e.g. red and dark blue will both look like black).

4) Write a brief summary (~100 words) explaining what you learned from your data.

5) Combine your summary and data visualization into a Word doc. Be sure to include:
a. Your name and neighborhood area
b. A caption under your visualization citing the source.

Please upload the Word doc AND an excel file of your cleaned data to the appropriate places on Blackboard.

 

Demographic Composition and Change Rubric

Points
7-10
  • All parts of the assignment were completed with minor or no errors/typos.
  • The data visualization is somewhat to very clear—overall able to interpret.
  • The summary somewhat to very accurately and fully explains the data.
4-6
  • All parts of the assignment were completed with minor or no errors/typos.
  • The data visualization is unclear and somewhat hard to interpret AND/OR
  • The summary doesn’t explain the data accurately or fully.
2-3
  • The assignment may be missing one or more parts and may have several errors/typos.
  • The data visualization is missing or very hard to interpret/messy AND/OR
  • The summary is missing or doesn’t explain the data accurately or fully/is confusing.
0-1 Did not do assignment, barely did assignment.

 

Attribution-NonCommercial-ShareAlike 4.0 International

This entry is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license.