ABCDEFGHIJK
1
GITHUB PAGE: http://simonrogers.github.io/datajournalism/
2
DateClassThemeInfoTools usedExerciseWhat will you learn this class?Reading (Please do this before each class)Critique of the weekSpeaker?Deck
3
Jan 10, 20191Introduction- Introductions: who are you and who am I?
- What is data journalism?
- Is it journalism? Read this piece: http://www.holovaty.com/writing/fundamental-change/
- Inside three of my data projects: Wikileaks, the alternative Olympic medal table and Reading the Riots
- Looking ahead: what will we cover in the course?		1) Choose a dataset from one provided. 2) Discuss the differences. 3) Visualise dataThe basics and history of data journalism and how to show differences.http://datajournalismhandbook.org/

http://www.theguardian.com/news/datablog/video/2013/apr/04/history-of-data-journalism-video

http://www.holovaty.com/writing/fundamental-change/

Extracts of Philip Meyer’s Precision Journalism: http://books.google.co.uk/books?id=uUzT0M_lPbYC&printsec=frontcover&source=gbs_ge_summary_r&cad=0#v=onepage&q&f=false
http://towcenter.org/wp-content/uploads/2014/05/Tow-Center-Data-Driven-Journalism.pdf

http://www.theguardian.com/news/datablog/2010/oct/23/wikileaks-iraq-data-journalism

http://www.theguardian.com/news/datablog/2011/dec/09/data-journalism-reading-riots

http://www.theguardian.com/news/datablog/video/2013/apr/04/data-journalism-olympics-medal-video

http://www.theguardian.com/news/datablog/2012/may/24/data-journalism-punk

http://simonrogers.net/2013/01/27/data-journalism-22-key-links/
Two data projects (each of the following weeks will see students bring a project to critique)https://docs.google.com/presentation/d/1fi2USaEEFegsR3b35HuwwUNssiyyMkgVnNMK55JK3Ls/edit?usp=sharing
4
Jan 17, 20192From story to source. What is the story here?Sources: where do you get the data? How do you find the data you need in a hurry? A look at good starting points and how to treat them. Lateral thinking, spreadsheets, the webStudents will choose three of the following news stories (to come), identify and
track down the key data and list five questions they would expect the
data to help them answer. all under strict deadlines. Take one of these datasets
http://www.google.com/fusiontables/exporttable?query=select+col0%2Ccol1%2Ccol2%2Ccol3%2Ccol4%2Ccol5%2Ccol6%2Ccol7%2Ccol8%2Ccol9%2Ccol10%2Ccol11%2Ccol12%2Ccol13%2Ccol14%2Ccol15%2Ccol16%2Ccol17%2Ccol18+from+273326 (from here: http://www.theguardian.com/news/datablog/2010/oct/23/wikileaks-iraq-data-journalism)

http://spreadsheets.google.com/pub?key=0Ak3IIavLYTovdGhfeHY5VmhGaXVOVmNiWlpPdWRfWUE&output=csv (from here: http://homicides.redeyechicago.com/date/2014/12/)

https://www.cpj.org/killed/cpj-database.xls (from here: https://www.cpj.org/killed/2014/)

First, find out where the data came from. What is the key story for each dataset? Think of five things you would like to know about the data of your own devising. Then, use pivot tables to find out the answer.
What dataset would be good to mashup with the results? What would shed more light on it?		How to find data in a hurry. The basics of using spreadsheets, including pivot tables.https://www.journalism.co.uk/news/sources-and-tools-for-data-journalism/s2/a555581/
http://simonrogers.net/2014/09/30/journalist-datastores-where-can-you-find-them-a-list/
http://www.theguardian.com/news/datablog/interactive/2013/jan/14/all-our-datasets-index
http://datadrivenjournalism.net/resources/using_excel_to_do_precision_journalism
http://www.sacbee.com/site-services/databases/
https://www.journalism.co.uk/news/how-to-build-a-pivot-table-to-find-the-story-in-data/s2/a557235/		https://docs.google.com/presentation/d/1DdoqhAiVrDnFvRvK_9f8kCGPP8HAA7DNcrT0ue2FBOo/edit?usp=sharing
5
Jan 24, 20193New ways to visualise dataNew wyas to visualise data and new free tools to help you do it.Morph; TwoToneExercise: pick a news story from this week and find a dataset to go with it. Visualize that dataset using one of the free charting options.How to make basic charts using free tools. How to use Flourish, Morph and TwoTone to make complex visuals.http://simonrogers.net/2014/03/17/how-to-make-an-animated-map-with-cartodb-and-torque/
http://www.theguardian.com/news/datablog/2013/mar/15/john-snow-cholera-map
https://www.mapbox.com/blog/mapping-millions-of-dots/
http://datadrivenjournalism.net/resources/Creating_dot_density_maps_with_Chicago_Tribunes_new_open_source_toolkit
http://docs.datawrapper.de/tutorial/
https://www.youtube.com/watch?v=kvcxyXYBbeI
https://www.youtube.com/watch?v=PNtCtvsaFgU		Debra Anderson, Datavized
6
Jan 31, 20194Data Gifs and newsroom designVisuals don't have to be complex to tell a story. This session with Data Gif expert and ProPublica designer Lena Groeger will teach you how to make a data gif.Adobe PhotoshopMake your own data gif!Presentation:

http://lenagroeger.com/datagifs/



Tutorial:

https://github.com/lenagroeger/gifs



Resources:

http://lenagroeger.com/resources/		Lena Groeger, ProPublicaPresentation:

http://lenagroeger.com/datagifs/



Tutorial:

https://github.com/lenagroeger/gifs



Resources:

http://lenagroeger.com/resources/
7
Feb 7, 20195Working with designersWorking with visual designers is a key part of a data journalist’s skill set. But what do designers look for in the information you provide?Spreadsheets, research skillsProduce data sets for an interactive guide, to a news topic announced at the beginning of classHow to work with a designer and to produce basic data for one.http://wannabehacks.co.uk/2012/07/20/why-every-journalist-should-learn-design/
http://www.niemanlab.org/2014/07/alberto-cairo-data-journalism-needs-to-up-its-own-standards/
https://www.flickr.com/photos/juggernautco/sets/72157607210036175/detail/
http://www.thefunctionalart.com/2017/09/a-single-data-point-is-often.html		Visit to Pitch Interactive
8
Feb 14, 20196Google dataSearch data is qualitative information in quantative amounts. This session will investigate what stories you can get, which tools will help and how to get started and you will meet one of Google's visual insights team to discuss how they do it.Google TrendsTake a news story from this week and find out the following details: where is the story top searched? What are the top related searches? Is there an interesting comparison to search for? Produce five ideas where Trends data can add to a story. Produce one chart and a short Textual analysisHow to analyse search datahttps://medium.com/google-news-lab/what-is-google-trends-data-and-what-does-it-mean-b48f07342ee8
https://www.nytimes.com/2016/03/02/upshot/to-know-whos-leading-in-the-voting-just-ask-google.html?_r=0
https://medium.com/@pewresearch/using-google-trends-data-for-research-here-are-6-questions-to-ask-a7097f5fb526
https://marketingland.com/google-trend-goldmine-117626
http://www.pewresearch.org/fact-tank/2017/04/27/flint-water-crisis-study-qa/		Katherine Walker, Lead designer, Google Brand Studio
9
Feb 21, 20197Humanity in data journalism and visualisation: why it mattersTypically, data journalism is often paired with traditional narrative reporting, which can focus on teasing out the empathy part of the equation. That leaves the data work feeling anonymous and impersonal. But in a world where visuals have to stand alone, that is no longer adequate. How to make a story humanhttps://www.ted.com/talks/giorgia_lupi_how_we_can_find_ourselves_in_data
M
https://www.ted.com/talks/mona_chalabi_3_ways_to_spot_a_bad_statistic https://simonrogers.net/2017/04/25/data-needs-empathy-to-make-it-real/		Anna Vital
10
Feb 28, 20199Collaborative journalismWhen can data journalists work together, and how to make it work.Rachel Glickhouse
11
Mar 7, 20198Working with designers, part 2/working sessionSpreadsheets, research skillsMatt Daniels, The Pudding
12
Mar 14, 201910Final presentations of group projects
13
14
To be confirmed