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: Excel and Tableau
Course Materials:
Required: NICAR CoursePack
https://store.ire.org/products/nicar-courses-rob-wells-jour-405v-database-journalism
Optional:
Numbers in the Newsroom
New Precision Journalism
Data Journalism Handbook
WordPress Site:
https://wordpressua.uark.edu/datareporting/
Lesson #1: Basic Excel
NICAR Coursepack: Basics and Sorting in Excel
Open sample dataset: citybudget.xls
1. Make a copy
2. Four corners test
3. Check the math
4. Sorting
5. Percentage Change
Background and Help:
—> Tutorial Video
Information on Lynda.com tutorial videos.
http://lynda.uark.edu/
https://www.lynda.com/Excel-tutorials/Excel-2013-Essential-Training/116478-2.html
Homework:
Part 1: Tell me about yourself. Part 2. Reading questions
1) Name, hometown, journalism/work experience, hobbies, best story you’ve produced/written. Data Experience, if any. Add images / videos / links / etc. – Have fun with it!
2) Reading: Data Journalism Handbook : Front Matter and Introduction. Post one question or observation from this reading.