Monthly Archives: February 2018

Week 7 – Mon., Feb. 26 and Wed., Feb. 28

In Class: -Data Journalism Pick of the Week – Day In the Life Data (Flowing Data) Most Common Use of Time, By Age and Sex Counting the Hours The American Workday, By Occupation Day in the Life of Americans –Excel … Continue reading

Posted in Weekly Overview | Leave a comment

Pivot Table Practice Exercise

Posted in How To, In-class Activity | Leave a comment

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

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

How to Import Excel Spreadsheet into Google Sheets

To import an Excel spreadsheet into Google sheets Download Excel spreadsheet (i.e. demodataSp18.xls) Save to desktop or somewhere else on your computer. Log in to Google account (via Gmail) Click on Drive icon Drive >New >Google Sheet In Google Sheet… … Continue reading

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