Tipsheets & Presentations

Have a tipsheet or slides for your session at GIJC17? Email a digital copy to us here and we’ll post it. 

The resources are uploaded here according to the conference tracks: General Interest, Multimedia/Broadcast; Business & Finance; Nonprofits & New Models;  Safety & Security; Academic; and Data.

Looking for more tips and tools? Be sure to visit GIJN’s Resource Center.

General Interest Sessions

Session Name	Tipsheets	Presentations	Stories/Videos
Best Global Databases		GIJN Resource Center, by Toby McIntosh Investigative Research Links, by Margot Williams	Video: Toby McIntosh, Margot Williams, Govind Ethiraj
Beyond Google: Doing Better Searches	Searching the Deep Web, by Giannina Segnini
Bulletproofing Your Story	Publication Quality Control, by Nils Hanson		Video: Alex Papachristou, Lucy Freeman, Nils Hanson, Doreen Weisenhaus
Covering Conflict		Covering Conflict in Syria, by Mokhtar Alibrahim
Cross-Border Collaborations: Regional Projects		Regional Cross Border Collaboration, by Wahyu Dhyatmika How do we investigate #LavaJato?, by Milagros Salazar Cross Border As A Tool to Expose Kleptocrats + Presentation, by Evelyn Groenink
Digging into Development Issues	How We Did the Data-Driven Enslaved Land Investigation, by Raúl Sánchez González		Video: Maren Saebo, Raúl Sánchez González, Oluwatoyosi Ogunseye, Mark Schapiro
Digging into Extractive Industries		How We Connect Illegal Mining in Amazon with the Biggest Gold Traders in the World, by Fabiola Torres
Disaster Reporting	Covering Disasters, by Amantha Pererra
Drones, Sensors & Satellites	Tips on Drone Journalism, by Raffy Tima	Real Time AQI Monitoring Initiative by Indiaspend, by Govind Ethiraj Macroscope Media: Ending Secrecy on Earth with Light from Space, by Jeff Stein Exposing Government Deception, by Joel Konopo Drones in Marawi, by Raffy Tima	Story: English, Russian Video: Govind Ethiraj
Editing the Investigative Story	Loopholes Editors Must Avoid, by Musikilu Mojeed	Editing the Investigative Story, by Mark Schoofs
Environmental Crime & Wildlife Smuggling	Wildlife Crime Reporting, by Bryan Christy	Undercover Footage Negotiating An Illegal Timber Export with A Shipping Agent, by Estacio Valoi	Story: English Video: Fiona Macleod, Bryan Christy, John Grobler, Estacio Valoi
Essentials of Story-Based Inquiry		Using Story-Based Inquiry to Focus, Manage & Build, by Mark Lee Hunter
Exposing Criminal Justice Wrongs		Wits Justice Project, by Carolyn Raphaely
Exposing Human Trafficking and Forced Labor	Human Trafficking and Slavery: A Guide to Resource Materials, by GIJN	References & Desk Research Links + Presentation, by Tim Sandler	Story: English, Spanish
Fact-Checking: Best Practices		Fact-checking & lessons learned, by Laura Zommer
Fighting Fake News	Summary of Potential Strategies to Fight Fake News, by Session Panelists	Verification Guide by SSE Riga, by Arta Giga Kenya's Information Disaster: Borrowing from 'Best Practices'?, by Lee Mwiti Mugambi Post Truth: Fake News & The Search for Solutions, by Anya Schiffrin	Story: English
Fixers & Foreign Correspondents	Report: "Fixing” the Journalist-Fixer Relationship: A Critical Look Towards Developing Best Practices in Global Reporting, by Dr. Shayna Plaut and Peter Klein		Story: English
How Other Investigators Do It	10 Tips On Investigative Reporting's Most Powerful Move: Contacting Formers, by James Mintz	Field research at HRW - Our methodology: investigate, expose & change, by Dewa Mavhinga	Video: Vivienne Walt, Joe Davidson, Dewa Mavhinga, James Mintz
Innovations in Storytelling			Story: English Video: Reg Chua, Susanne Reber, Juliana Ruhfus, David Schraven
Internet Manhunt: Backgrounding & Tracking People Online			Story: English, German, Russian
Investigating Climate Change	Investigating Climate Change, by Amantha Pererra
Investigating Health -- Digging into Local Problems		Nigeria's Baby Farmers, by Rosemary Nwaebuni Get Me Out of Here! The Surgeon is A Robot, by Isabelle Ducret
Investigating Health -- Global Issues	Tips & Resources, by Naziha Syed Ali Investigating & Mapping Health Affairs, by Serena Tinari	Organ Trafficking, by Naziha Syed Ali
Investigating LGBTQ Issues	LGBTQ Resources, by GIJN	An Overview Using Data, by Brant Houston & Jennifer LeFleur LGBTQI + SSOGIE Source Development, by Brian Pellot Investigative Reporting: The Fundamentals, Mark Schoofs Documenting LGBTQI Hate Crimes & Discrimination, by Jabu Pereira	Story: English, Russian
Investigative Journalism in Africa	Tips for Rising Above Challenges, by Mwape Kumwenda		Story: German Video: Paula Fray, Catherine Gicheru, Mwape Kumwenda, George Lugalambi, Dapo Olorunyomi, Sam Sole
Journalists as Detectives			Story: English
Latest Investigative Tools Online			Story: Arabic
Lightning Round: Great Stories You've Never Heard Of		When Sewol Ferry Collapsed, Sungsoo Kim Rising Cases of Maternal Deaths in Nigeria, by Rosemary Nwaebuni
Mafias, Mobs and Cartels			Story: English, Russian, Arabic
Roundtable: Reporting Under Repressive Regimes		Media in Ethiopia after the 2005 Controversial Election, by Andualem Sisay Gessesse	Story: English Video: Keith Richburg, Andualem Sisay Gessesse, Emin Huseynov & Lawi Weng
State Capture in South Africa			Story: French Video: Cathy Mohlahlana, Adriaan Basson, Susan Comrie, Thanduxulo Jika, Jacques Pauw
The Art of Interviewing	The Art of Interviewing, by Mark Schoofs		Video: Ides Debruyne, Mark Schoofs, Cheryl W. Thomspon
Terrorism & Extremism	Covering Boko Haram Insurgency: Personal Experience, by Aminu Abubakar	#ISISfiles, by Axel Gordh Humlesjö	Video: Vivienne Walt, Aminu Abubakar, Mohamed Ali, Axel Gordh Humlesjö
The Future of Investigative Journalism (Roundtable)			Story: English Video: Sheila Coronel, Stephen King, Oluwatoyosi Ogunseye, Maria Teresa Ronderos, Gerard Ryle, Drew Sullivam
Tracking Looted Wealth	How to Hide Dirty Money & How to Trace It, by James Mintz	Tracking Looted Wealth, by Tom Burgis Tracking Looted Wealth, by Miranda Patrucic	Story: English, German Video: Thandeka Gqubule-Mbeki, Tom Burgis, Koami M. Elom Domegni, James Mintz, Miranda Patrucic
Using FOI/RTI Laws Around the World		Journalism Through RTI, by Shyamlal Yadav
Visual Forensics and Open Source Investigations	Open Source Investigative Tools, by Malachy Browne
What Washington is Doing In Your Country (workshop)	Public Data, by Martha Mendoza		Story: Spanish
Women and Investigative Journalism			Story: English
Workshop: Psychological Safety for Investigative Reporting			Story: English

Data Sessions

Session	Tipsheets	Presentations	Stories/Videos
Advanced Data Cleaning with Open Refine	Open Refine, by Tommy Kaas & Nils Mulvad
An Overview of Python	Cheat Sheet: Basic Python Coding for Journalists, by Tommy Kaas
Basics of Mapping		Intro to Desktop Mapping, by Jennifer LaFleur & Andrew Lehren
Basics of Web Scraping	Import.io, by Tommy Kaas & Nils Mulvad Is Web Scraping An Ethical Practice?, by Pinar Dag
Building Your Own Database		Building A Database, by Brant Houston
Collaborating on Data-Driven Stories	Tipsheet for Data-Driven Stories and Projects, by Jeff Kelly Lowenstein Collaboration Tools & Smart Use of Google, by Nils Mulvad
Connecting the Dots: Social Network Analysis	Social Network Analysis, by Brant Houston
Data Journalism in Small Newsrooms	Think Small, Big, Interactive & Collaborative, by Jeff Kelly Lowenstein How to create data journalism projects in small newsrooms with limited budget, by Pinar Dag	How to Get Your Newsroom Excited About Data, by Nana Boakye-Yiadom Essential (and Free) Data Tools Denise Malan Doing Data Journalism in Small Newsrooms, by Jeff Kelly Lowenstein	Story: English, German
Data Stories: Elections, Education, Shipping	Telling Election Stories with Data, by Izak Minnaar	Numbers in Education, by Khalid Khattak
Data Visualization with D3 & Other Tools	Data Pipeline, Case Studies & Tools, by Kavya Sukumar & Tegan Bedser
Descriptive Statistics		Descriptive Statistics in Excel + & sample data, by Jennifer LaFleur
Digital Gadgets for Tracking and Monitoring	Gadgets for Investigative Reporting, by Marcus Lindemann
Finding African Data	Finding African Data, by Nana Boakye-Yiadom
Frontiers in Data Visualization		Frontiers in Data Visualization, by Lena Groeger & Jane Pong	Story: English, Russian
Getting A Data State of Mind			Story: English
How to Mine Data for Storytelling	Methodology: Mining Data for Storytelling, by Lailah Ryklief
ICIJ Offshore Data Hackathon			Story: English, French, Spanish, Arabic
Lightning Round: Teaching Data Journalism -- Best Practices	Tips & Experience Sharing in Teaching Data Journalism, by Pinar Dag Keep it Real, Keep it Dirty, by Andrew Lehren Overview of Teaching Data Journalism, by Brant Houston Tips for Data Journalism Training, by Lailah Ryklief On A DDJ Trainer's Mental Health, by Crina Boros	Is Data the New Oil?, by Khalid Khattak Teaching Students through Their Stomachs, by Jeff Kelly Lowenstein The Most Fun Data in The World, by Denise Malan 7 Key Things, by Margot Williams Wash, Rinse, Repeat, by Jennifer LaFleur
Online Fact-Checking/Verification with Free Tools	Tools, Useful Links & Resources, by Raymond Joseph	How to Be A Digital Detective, by Raymond Joseph
Preparing Data for Mapping in Carto	Online Map Visualisations for Storytelling, by Julia Renouprez
Social Media Sleuthing: Finding & Monitoring Key Sources	Social Media Sleuthing, by Michael Salzwedel
Using Document Cloud		Investigate with Document Cloud, Doug Haddix
The Data Tool Kit	Data Tools, by Sanjit Oberai

Multimedia/Broadcast Sessions

Session	Tipsheets	Presentations	Stories/Videos
Documentaries	Investigative Documentary Business Model: 10 Tips to Make Your Way, by Jean-Philippe Ceppi		Story: Spanish
Investigative Radio		Investigative Radio, by Citra Prastuti	Story: English, Russian, French
Masterclass: Investigative Radio		Masterclass: Investigative Radio, by Sandra Bartlett & Citra Prastuti
Masterclass: Mojo Workshop	Guerilla Mojo 101, by Ivo Burum
Multimedia Investigations		Multimedia Investigations in 3 Lessons, by David Hidalgo
Virtual Reality Meets Investigative Reporting		VR exploration on media innovation in China, Qiu Jiaqiu	Story: English

Business & Finance Sessions

Session	Tipsheets	Presentations	Stories/Videos
Covering Corruption		Business of Members of Parliament, by Musab Shawabkeh Covering Corruption in Serbia, by Dino Jahic Connecting the Dots in A Political Corruption Scandal, by Boyoung Lim
How to Read Company Accounts	Understanding Financial Records, by Miranda Patrucic
Investigating the Arms Trade	Investigating International Arms Trade, by Manu Pubby	How to Expose the Secretive World of Arms Trade with Open Data, by Lawrence Marzouk & Jelena Cosic
Lotteries, Launderers, & Illicit Acts	Tipsheet for Gaming the Lottery Investigation, by Jeff Kelly Lowenstein	Illicit Financing
Seven Financial Sins		7 Deadly Financial Sins, Drew Sullivan	Story: English

Safety & Security Sessions

Session	Tipsheets	Presentations	Stories/Videos
Dealing with Online Harassment		Twitter Safety, by Nick Pickles	Story: English
Encryption (Workshop)		Tools for Encryption, by Fredrik Laurin, Serena Tinari & Axel Humlesjö
How to Protect Yourself and Your Sources	DIY Digital Security, by Chris Walker
Whistleblowing, Secure Drops, and Source Protection			Story: English

Academic Sessions

Session	Presentations	Stories/Videos
Creating Effective University Investigative Journalism Centers	University As An "Incubator" for Investigative Journalism powerpoint and the full presentation speech, by Waseda Chronicle	Story: English
Academic Papers: Social Media, Video Storytelling, Capacity Building	Raking Muck and Raising Funds – Capacity Development Strategies for the Future of Investigative Journalism in Developing Countries + Research Paper, by Jan Lublinski, Nadine Jurrat, Attila Mong Investigative Journalism in Sri Lanka: A Study on the Process and Effectiveness of Investigative Video Storytelling, by MC Rasmin, S. Raguram, M. Azad The More Things Change, the More They Stay the Same: The Impacts of Social Media and Digital Technology on Journalism Quality in South African Newsrooms, by Sarah Findlay Graph My Tender: Exploring Public Procurement Networks, by Adriana Homolova	Story: English
Investigative Journalism in Mauritius, Saudi Arabia, Tanzania	Challenges of Doing Investigative Journalism in Tanzania, by George Nsorani Mwita Challenges Confronting Investigative Journalism in Saudi Arabia, by Ali Almania Investigative journalism in the post-truth era: Views from Mauritius, by Azhagan Chenganna	Story: English
Lightning Round: Teaching Data Journalism -- Best Practices	Khalid Khattak, Pinar Dag, Jeff Kelly Lowenstein, Andy Lehren, Denise Malan, Brant Houston, Lailah Ryklief, Margot Williams, Crina Boros, Jennifer LaFluer	Story: English
Scholars, Doctors, Journalists -- Collaboration Across Fields	A Program That Turns Doctors into Muckrakers, by Robert Steiner	Story: English
Teaching Investigative Journalism -- Best Practices	Teaching Investigative Journalism, by Ying Chan Building IJ Programs: Learning from the SBI Curriculum, by Mark Lee Hunter	Story: English
Teaching Methodology in Data & Investigative Journalism	News Bot for the Newsroom: How Building Data Quality Indicators can support journalistic projects relying on real-time open data, by Laurence Dierickx A Successful Method of Teaching Top-Notch Investigative Journalism, by Parra Paulette Desormeaux Data-driven journalism: Visualizing the lie versus revealing the truth, by Milagros Salazar The Vast and the Curious: Teaching Investigative Journalism in a Diverse Dubai, by Yasmine Bahrani & Bradley Freeman	Story: English, Arabic

Nonprofits & New Models

Session	Presentations	Stories/Videos
Funding Your Investigation		Video: Reg Chua, Brigitte Alfter, Bridget Gallagher, Ernest Sungura
Measuring Story Impact	Investigative Impact: How to Define It and How to Measure It + Investigative Impact Report, by Peter Cary Stories that Matter, by Rachel Oldroyd	Story: English
Startups and Innovations		Video: Reg Chua, Justin Arenstein, Monia Ben Hamadi, Kassim Mohamed, Rachel Oldroyd
Sustainability Workshop -- Part 2: Best Practices	Omidyar Network, Nishant Lalwani	Story: English
Roundtable: Donors, Grants, & Journalists		Story: Russian

Special Events

Session	Presentations	Stories/Videos
Plenary: Investigating the New Autocrats	Venezuela, by Ewald Scharfenberg	Story: English, Russian, Arabic Video: Ferial Haffajee, Roman Anin, Patricia Evangelista, Thanduxolo Jika, David Cay Johnston, Ritu Sarin, Ewald Scharfenberg
African Muckraking Book Release		Story: English
"Don't Shoot the Messenger" - Carlos Cardoso Memorial Lecture		Story: English Video: Beatrice Mtetwa, Anton Harber
Keynote Address/Awards Night		Keynote Story: English, Russian Shining Light Award Story: English, Russian Video: Joseph Stiglitz, Sheila Coronel
Farewell & GIJC19 Announcement		Story: English Video: David Kaplan, Anton Harber