Category Archives: Uncategorized

Week 8 – Tues., March 12 and Thurs., March 14

In Class: -Data Journalism “Picks of the Week” NICAR2019 Tip Sheet –Inverted Pyramid of Data Journalism –Intro to Data Cleaning for Journalism Students –In-Class Exercise: Data Cleaning with Excel –Basic Excel Formulas for Cleaning –Top 10 ways to clean your … Continue reading

Posted in Uncategorized | Leave a comment

Basic Excel Formulas for Cleaning

Function Description Formula Get data or apply function to data from a different sheet =Sheet1!A1 Apply function to a column (shift-select cells, function must be in top cell) Control-d AVERAGE Calculates the average =AVERAGE(A2:A10) MEDIAN Finds the value (number) in … Continue reading

Posted in Uncategorized | Leave a comment

Welcome to Data Journalism

DATA JOURNALISM – Spring 2019 Department of Journalism, Rowan University Tuesday and Thursday 11:00 a.m. – 12:15 p.m. CRN 23936 JRN 02363 1 301 High Street Room 215 Instructor: Mark Berkey-Gerard COURSE DESCRIPTION: This course is an introduction to the … Continue reading

Posted in Uncategorized | Leave a comment

Intro to some out-of-the-box visualization tools

First, some Google products: Google Sheets Google Trends Google Data Gif Maker Google Charts Google My Maps And others: Storyline JS Flourish Infogr.am Plot.ly Tableau Public

Posted in Uncategorized | Leave a comment

Enterprise Story Structure

Here is how you should structure and format your Enterprise Story…

Posted in Uncategorized | Leave a comment

Hard News vs. Enterprise Story Assignments

–Rowan Safety Group Enterprise Story assignment

Posted in Uncategorized | Leave a comment

Four Common Suggestions for Rewrite

Posted in Uncategorized | Leave a comment