Data Reporting

MPJO-722-01: Data Reporting

Course Outline

Note: this outline is subject to change; if it does, students will be notified.

• Jan. 8 – Course Introduction; Intro to Data; Excel Skills
• Jan. 15 – Unstructured data; Text Visualization; Basic visualizations
• Jan. 22 – Excel formulas, Basic charting, Election results data
• Jan. 29 - More Excel formulas; Summarizing with Excel
• Feb. 5 – Database Skills – Importing and querying; Campaign Finance data; Critique due
• Feb. 12 – Database Skills – Summarizing Data; More Campaign Finance data
• Feb. 19 – SQL Joins; Congressional voting data
• Feb. 26 – SQL Wrap-up; Cleaning dirty data
• Feb. 28 - Mapping; Fusion Tables (moved from March 5)
• March 8 - Homework from Feb. 28 due
• March 12 – Spring Break - NO CLASS, but Midterm due by March 15!
• March 19 - Working with PDFs; Military data
• March 26 - Census Data; Writing with Data
• April 2 - Easter Break - NO CLASS
• April 9 - Basic Web Visualization Tools; Structured Web Data; IRS Data; 2nd Critique due
• April 16 - How the Internet Works; Version Control (GUEST SPEAKER)
• April 23 - Odds and Ends
• April 30 - Study Days - NO CLASS
• May 7 - Story Memo Presentations; Wrap-up