Day 4 Class

 Numbers in the Newsroom Sarah Cohen’s “Numbers in the Newsroom” is a classic in journalism numeracy. She is a Pulitzer-winning journalist at The Washington Post, a former Duke University professor and now a data journalist at The New York Times....

Day 3 Class

NY Times, College Diversity Data Project https://www.nytimes.com/interactive/2017/08/24/us/affirmative-action.html?_r=0 –Simplicity of Graphics –Consistency of Format –Focus on a telling metric: the Gap ### Review Homework Univ of Arkansas, Univ of...

Day 1 Class

Welcome to Data Journalism Lemke Digital Media Lab Course, Fall 2017 School of Journalism and Strategic Media University of Arkansas   1) Syllabus 2) WordPress Site 3) Basic Excel 4) Homework:  Profile, data background   Syllabus: Questions Software:...

Feb 7 Class

Review: Rates and Ratios Gather the FBI Uniform Crime Reporting, Data For All Arkansas Cities, All Crimes https://www.ucrdatatool.gov/Search/Crime/Local/OneYearofData.cfm Fill in the gaps of the population data using the 2014 Census Figures from this table:...

Excel Basics

Cheap Tricks with Excel Basic Excel: Worksheets http://www.excel-easy.com/basics/worksheets.html Format Cells http://www.excel-easy.com/basics/format-cells.html Basic Navigation Basics and Sorting in...

Thursday, Jan 19

Review: WordPress posting Basics and Sorting in Excel Citybudget.xls Review four corners: 1. Make a copy 2. Freeze Panes 3. Four corners test 4. Check the math Excel and the Black cross copy function 5. Sorting     >—< New: Freeze Panes...