1) Introductions

 

2) Syllabus

–Questions

       –Software: Excel and Tableau

         –Course Materials:

          NICAR CoursePack

         Numbers in the Newsroom

         New Precision Journalism

         Data Journalism Handbook

3) Tour of class blog

 

 

 

4) Email via Blackboard. Blog Registration

 

 

 

5) Basics and Sorting in Excel : NICAR Coursepack

 

 

 

     —Open sample dataset: citybudget.xls

 

 

 

 

1. Make a copy

 

 

 

2. Four corners test

 

 

 

3. Check the math

 

 

 

4. Sorting

 

 

 

5. Percentage Change

 

 

 

—> 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:

 

 

 

Post 300 words on the Blackboard or WordPress by 11:59 p.m. Wednesday:

 

 

1) Tell us about yourself:

 

     Name, hometown, journalism/work experience, hobbies, best story you’ve produced/written