Monthly Archives: September 2016

Week 4 – Mon., Sept. 26 and Wed., Sept. 28

In Class: -Stephen Stirling, guest speaker –Interviewing data –Lecture: Intro to Cleaning Data –Example: Interviewing and cleaning data –Basic Excel Tips – Part 1  (Use Fake NJ Crime Stats spreadsheet) Assignments: –Take Home Quiz #2 due Wed., 9/28 (Worth 15 points) -Read DJH Become … Continue reading

Posted in Weekly Overview | Leave a comment

Lecture: Intro to Cleaning Data

Messy or dirty data is inaccurate, incomplete or erroneous information in a data set. Common examples include: data entry errors spelling or punctuation errors information in the wrong location multiple pieces of information one location incomplete or outdated data duplicate information … Continue reading

Posted in Lecture | Leave a comment

Activity: Interviewing and Cleaning Data

Posted in In-class Activity | Leave a comment

Basic Excel Tips – Part 1

Posted in How To | Leave a comment

Week 3 – Mon., Sept. 19 and Wed., Sept. 21

In Class: –Quiz #1 on Week 1 and 2 material -Your NJ data scavenger hunt take-aways –Smarter Google searching –Intro to FOIA –Intro to scraping Assignments: –Take Home Quiz #2 due Wed., 9/28 (Worth 15 points) -Read DJH – Five Minute … Continue reading

Posted in Weekly Overview | Leave a comment

Lecture: Intro to FOIA

The Freedom of Information Act (FOIA) is a federal law that allows for the full or partial disclosure of previously unreleased information and documents controlled by the United States government. Resources: FOIA.gov National Freedom of Information Coalition Reporters Committee for … Continue reading

Posted in Lecture | Leave a comment

Lecture: Intro to Scraping

Scraping is using a tool to capture information from online sources (web page, database, word doc, pdf, etc.) and put it into a form that you can use. There are many tools and techniques for scraping. Which one will work … Continue reading

Posted in Lecture | Leave a comment