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

• The year in data journalism around the world: developments and trends
• Data journalism for small newsrooms
• Data, fact-finding and breaking news
• Data journalism in Italy and the Mediterranean area: from niche to mainstream

Workshops

• From idea to story: planning the data journalism story
• Data journalism tools: maps
• Interactive storytelling
• Investigating crime and corruption
• Get your own data through aerial photography
• Web scraping for non programmers
• Privacy and Digital Security

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)

Organisations and initiatives

• http://www.vox.com/
• http://ampp3d.mirror.co.uk/
• http://fivethirtyeight.com/
• www.nytimes.com/upshot/
• http://www.theguardian.com/news/datablog
• http://www.datajournalism.it/

Data journalism projects

• NSA Files Decoded by The Guardian
• What your activity tracker sees and does not see by the NYT
• Giant Slalom Newsgraphic, NYT
• Gay rights in the US, state by state, The Guardian
• http://11septiembre1973.latercera.com/en/
• How many people are speaking English on rush hour trains out of Charing Cross, Amp3d
• Watch Wayne Rooney’s earnings add up in real-time, Amp3d
• Star Health, Code4Kenya
• New York Times Electoral Explorer, 2008
• New York Times President Map, 2012
• Guardian Election map and swingometer, 2010
• Mappa elettorale di YouTrend – Elezioni politiche, 2013
• Mappa elettorale di YouTrend – Primarie PD, 2013