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 in one location incomplete or outdated data duplicate … 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. Federal Resources FOIA.gov National Freedom of Information Coalition Reporters Committee … Continue reading

Posted in Lecture | Leave a comment

Lecture: Intro to Scraping using Google Sheets

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 you use … Continue reading

Posted in Lecture | Leave a comment