Come together- Joining data

23 Sep 2015

Slides and walkthroughs

• Structure of Data
• Tutorial on Getting started with the Github desktop app
• Bristol Herald Courier lesson
• Joining data walkthrough

Download useful free stuff

• Plain text editor for Mac - Sublime Text
• Plain text editor for PC - Notepad++ v6.8.3
• A better browser. Install Chrome. - Chrome Browser

Sign up for useful free stuff

• Investigative Reporters and Editors | Subscribe to NICAR-L
• GitHub Student Developer Pack - GitHub Education

Assignments for Sept. 30

Read: Data Hygene

Read: Fewer students, professors at Connecticut state and community colleges | TrendCT

Homework 1

Create a data memo for your beat

Write me draft paper that describes the kinds of data that exists on the beat you want to focus on:

• That you know exist
• That you hope to find
• Or that you will collect yourself

Regarding the data you're envisioning, answer

• Why this data source is interesting and what you’re curious about.
• Where this data exists, or where you expect to find it
• Anticipated problems in collecting or analyzing it

Upload it to your Github repo or email it to me.

This is just brainstorming and you don't have to commit to what you come up with for the homework for your midterm or final project.

This will hopefully set you on the path toward thinking of data as soon as possible. I will give feedback and help you refine researching possibilities.

Homework 2

Join two spreadhseets using Google Fusion Tables

1. Find the number of liquor stores by town. You'll have to make a pivot table based on this data Licensed Package Store Liquor Retailers
2. Merge it with the town population data -2010 Population By Town
3. Download and then upload the joined CSV to your GitHub repo. Email me the link to the CSV file in your repo.

Assignments due before 2 p.m. on Sept. 30.