Slides, Tools and other Resources from the School of Data Journalism 2014

May 23, 2014 in Uncategorized

The School of Data Journalism is a joint initiative of the European Journalism Centre, the Open Knowledge Foundation, and the International Journalism Festival of Perugia. The third edition consisted of four days of workshops and panels, covering everything from crime investigations to data journalism using spreadsheets, social media data, data visualisation and mapping for journalism.

In this post you will find all the links shared during this training event, the video replays of the panel sessions and workshops, links to the slides of the panelists and instructors. If you have links shared during the sessions that we missed, post them in the comments section and we will update the list.

Video recordings and notes

Panel discussions

Workshops

Pictures

You can find some pictures here. Please do feel free to share your pictures with us!

Slides, tutorials, articles

Article on the “Year in data journalism” panel discussion (Martin Belam, Amp3d)
Article on “Year in data journalism” panel discussion (Alastair Reid, Journalism.co.uk)
Slides, data and cheat sheet from “From idea to story: planning the data journalism story” (Steve Doig)
Article “From idea to story: planning the data journalism story” (Alastair Reid, Journalism.co.uk)
Hands on tutorial on planning data journalism story (School of Data)
Slides and data from the session “Using Excel for Journalism” (Steve Doig)
Hands on tutorial on using Excel for Journalism (School of Data)
Slides, data and other resources from session “Investigating crime and corruption” (Giannina Segnini)
Detailed article summarising the session “Investigating crime and corruption”
Slides on interactive storytelling (Mariana Santos)
Sides on aerial mapping (Cindy Regalado)
Hands on tutorial on how to fly a kite, collect aerial data and put it together with mapknitter
Notes, examples and cheat sheet on building maps for journalists (Annabel Church)
Notes, cheat sheet and tools for web-scraping for journalists (Annabel Church)

Tools and other resources

Microsoft Excel or any other spreadsheet tool like Calc, Google Spreadsheets
http://www.storyboardthat.com/ – tool for creating storyboards
http://www.dafont.com/ – collection of fonts and icons for your animations and graphics
http://thenounproject.com/ – collection of free icons that can be used for animations and graphics Google Fusion Tables
http://infogr.am/ – great resource for creating beautiful out of the box infographics
http://topsy.com/, http://www.sysomos.com/ -tools for searching Twitter data
http://cartodb.com/ – mapping tool
http://datawrapper.de/ – beautiful tool to create simple graphs and maps oline
Google fusion table maps – allows you to easily create maps and helps you geocode your data
http://colorbrewer2.org/ – tool for selecting colours
Leaflet – desktop tool for mapping
QGIS – open source desktop tool for mapping
Storymap – allows you to create interactive maps and timelines
Timelinejs – – allows you to create interactive maps and timelines
import.io – tool for web-scraping
Scraper: a chrome extension to easily scrape data
Other data scraping tools: Kimono, morph.io, Scraperwiki
Table Capture for Chrome or Clipboard2Table for Firefox – browser extensions for scraping
http://mapknitter.org/ – map to stich together aerial photos
Security in a Box – a comprehensive resource for journalist on how to stay safe online
Me and My Shadow – an online tool allowing you to see the traces you leave behind when using technology and internet
Tools for investigating maritime database – a comprehensive list can be found here
http://ushahidi.com/ Open Source UGC mapping tool
http://twitcident.com/ a tool for mapping breaking news situations.
Source, an index of news developer source code, code walkthroughs and project breakdowns from journalist-coders
Open Refine (for data cleaning)
Gephi (for graph visualisations)
Hashtagify (visualisation of Twitter hashtags related to a particular #tag)
Investigative Dashboard (methodologies, resources, and links for journalists to track money, shareholders, and company ownership across international borders)
Tabula (open-source application that allows users to upload PDFs and extract the data in them in CSV format)
DataSift (platform that allows users to filter insights from social media and news sources, mentioned in panel on covering emergencies)
Storyful (service that mines social media to discover content relevant for news organisations and verifies it)
GeoFeedia (tool that enables location-based search for social media content)
Spokeo (organises information about people from public sources and make it available for search)
The Tor project (free software that helps defend against network surveillance and censorship)
Follow the Money: A Digital Guide for Tracking Corruption (a handbook for investigative journalists that shows methods, tips and tricks for for tracking companies across borders)