Data Journalism & Visualization
“In God we trust; all others must bring data.” This technical course merges statistics, coding, and design to uncover stories hidden in spreadsheets. Students will learn to scrape data from the web, clean messy datasets, analyze trends using Excel or SQL, and present their findings through interactive charts and maps (using tools like Tableau or Flourish) that make complex information accessible.
§ 01 By the end you can
- Master the workflow of Data Journalism: Scrape, Clean, Analyze, Visualize
- Use advanced Excel functions (Pivot Tables, VLOOKUP) and basic SQL for analysis
- Visualize data effectively: Choosing the right chart for the right data
- Create interactive maps and dashboards using Tableau, Flourish, or Datawrapper
- Fact-check statistical claims to avoid "lying with statistics"
§ 02 Sixteen sessions
The whole semester.
- 01Introduction to Data Journalism: Finding the Story
- 02Finding Data: Public Records & Open Data Portals
- 03Data Cleaning I: OpenRefine Basics
- 04Data Cleaning II: Formatting & Normalization
- 05Analysis I: Excel Pivot Tables
- 06Analysis II: Outliers & Trends
- 07Introduction to Scraping (No-Code tools)
- 08 · MidtermMidterm Examination
- 09Visualization Theory: Color & Cognitive Load
- 10Creating Static Charts (Bar, Line, Scatter)
- 11Interactive Visualization: Flourish
- 12Mapping: GIS Basics for Journalists
- 13Infographics: Combining Text & Visuals
- 14Scrollytelling: Narrative Data Stories
- 15Ethics: Privacy & Misrepresentation
- 16Final Project: The Data-Driven Investigative Story
Midterm around session 8. Final project briefed at session 8 or 9 and developed in stages until the juries.
§ 03 Final project
Final Project: The Data-Driven Investigative Story
Recommended reading
- The Functional Art by Alberto Cairo
- Data Journalism Handbook by Jonathan Gray
- Facts are Sacred by Simon Rogers
- Storytelling with Data by Cole Nussbaumer Knaflic
- Visualize This by Nathan Yau
More in Journalism
| Artificial Intelligence (AI) in Journalism | Algorithms are the new assignment editors. This course explores the integration of AI into the newsroom, from "Automated Journalism" (robot reporters writing sports/finance recaps) to machine learning for investigative data crunching. |
| Broadcast Journalism | "30 seconds to air." This high-pressure course simulates a working TV newsroom. Students will learn to write for the ear (simple, conversational scripts), shoot news sequences (B-Roll and SOTs), and edit fast-paced packages. |
| Creator Economy & Independent Journalism | Journalism is unbundling from institutions. This course is a business accelerator for the independent journalist. |
| Digital Journalism & Online Media | The newspaper is dead; long live the feed. This course explores the transformation of news from static print to dynamic digital interactivity. |
| Disinformation and Media Literacy | In an era of "Alternative Facts" and Deepfakes, this critical thinking course equips students with the tools to verify truth. |
| Drone Journalism & Aerial Storytelling | The view from above changes the story on the ground. This course certifies students in the ethical and technical use of Unmanned Aerial Vehicles (UAVs) for news gathering. |