Author Archives: admin

Week 6 – Mon., Feb. 19 and Wed., Feb. 21

In Class: -Data J Picks of the Week: Death & Dysfunction: How N.J. fails the dead, betrays the living and is a national disgrace by Stephen Stirling Lyrical Shakespeare: Ranking N.J. music artists by vocabulary by Stephen Stirling –Excel Practice Quiz … Continue reading

Posted in Weekly Overview | Leave a comment

Excel Practice Quiz #1 – Spring 2018

Answer the following questions using demodataSp18 and Excel Basics Crib Sheet

Posted in Quiz | Leave a comment

Week 5 – Mon., Feb. 12 and Wed., Feb. 14

In Class: -Data J Picks of the Week (Math Where You Might Not Expect It): Fashion Business Data The Dakulator Kelly Slater’s Stunning Stats and Pipeline -Basic newsroom math and statistics -Quiz 1 and 2 review –Inverted pyramid of data … Continue reading

Posted in Weekly Overview | Leave a comment

Quiz #2 answers

Posted in Quiz | Leave a comment

How to Import Excel Spreadsheet into Google Sheets

Log in to Gmail Creat a new Google Sheet Drive >New >Google Sheet In Google Sheet… File >Import >Upload >Select file >Open >Create a new spreadsheet >Open New

Posted in How To, Resource | Leave a comment

Week 4 – Mon., Feb. 5 and Wed., Feb 7

In Class: -Quiz #2 (covering Weeks 1, 2 and 3) –Inverted pyramid of data journalism –Interviewing data –Lecture: Intro to Cleaning Data –Four Common Ways to Clean Data in Excel –Example: Interviewing and cleaning data Assignments: -Complete Quiz #1 (Take Home). Due … Continue reading

Posted in Quiz, Weekly Overview | Leave a comment

Week 3 – Mon., Jan. 29 and Wed., Jan. 31

In Class: -Data J Pick of the Week –The Most Timeless Songs of All Time (From The Pudding) –NJ Scavenger Hunt review –Intro to FOIA –Inverted pyramid of data journalism –Common Data File Types –Intro to scraping Assignments: -Read DJH – Your Right … Continue reading

Posted in Weekly Overview | Leave a comment