Investigative reporting certificate BETA

This will be the blurb for the Investigative reporting certificate.
-
Foundations of data journalism – Scraping
Data scraping web pages with Google sheets, scraping PDFs with Tabula and PDFtoExcel. Build graphics with Flourish Studio. We’ll also explore how to scrape data from a photograph using Excel.
-
Business tools and investigating companies
Learn how to scrape real-time and historical stock data from Google Finance into a Google Sheet and track it. It’s useful for anyone covering a specific industry or company.
-
Reporting with Pinpoint
Learn how to probe through millions of documents, including audio, video, PDFs and more, to find patterns or that proverbial needle in a haystack. You’ll see case studies of how Gannett journalists have used this software to break big investigative stories.
-
Using specialized search engines to find sources, data and fact-checks
Execute deeper, more precise, more sophisticated web searches by harnessing specialized search engines. Diversity your stories, angles, sources and readers.
-
Backgrounding a business
How to search for proxies and tools for covering business, non-profits and the economy overall.
-
Secure communications with sources and tipsters
Tips and traps: Tools such as Signal app, Freedome and VPNs to keep you, your data and your sources safe.
-
CSV Match and other fuzzy-matching tools
Finds matches between two files rather than within one.