Beginner

Protected: Scrape-a-palooza and Google Flourish

There is no excerpt because this is a protected post.

Skill:

Level:

  • Protected: Google Finance scraping and other tools for business beats

    There is no excerpt because this is a protected post.

    Skill:

    Level:

  • Protected: Data-scraping websites, PDFs and Flourish

    There is no excerpt because this is a protected post.

    Skill:

    Level:

  • Environment tools, Part III

    me new tools, such as the Environmental Justice Atlas that documents cases around the world of environmental infractions. We’ll also look at Protected Planet, which tracks conservation measures, and the Wildlife Dashboard.

    Skill:

    Level:

  • Empower your research with Lexis/Nexis

    How to conduct basic research for news stories.

    Skill:

    Level:

  • Tools for investigating non-profit organizations

    A look at tools for tracking non-profit finances, what their CEOs earn and much more. We also spend some time looking at Form 990s of charities and give you a chance to pull some on organizations in your area.

    Skill:

    Level:

  • Protected: Business reporters and editors: Tools for covering companies and industries

    There is no excerpt because this is a protected post.

    Skill:

    Level:

  • Data-scraping web pages, PDFs and Google Finance

    How to extract data from the web and PDFs and flow them into a spreadsheet. You’ll also learn how to scrape real-time and historical stock data into Google Sheets to track specific companies or industries. Code: data

    Skill:

    Level:

  • Master classes for business reporters and editors, Part II

    We will cover Charity Watch, SEC filings, Form 990s on Guidestar, etc. Google Dataset Search, Google Scholar, including ways to analyze case-law. We will learn to scrape Google Finance to isolate stock data and historical stock data. And will finish by learning how to scrape data from business sites and visualize it using Flourish. Code: business

    Skill:

    Level:

  • Master classes for business reporters and editors, Part I

    We cover Charity Watch, SEC filings, Form 990s on Guidestar, etc. Google Dataset Search, Google Scholar, including ways to analyze case-law. We will learn to scrape Google Finance to isolate stock data and historical stock data. And will finish by learning how to scrape data from business sites and visualize it using Flourish. Code: business

    Skill:

    Level:

  • 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.

    Skill:

    Level:

  • 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.

    Skill:

    Level:

  • Basic databases in Google Flourish and other tools

    A few easy tools to help you show your work: Google Flourish, Airtable and Tableizer.

    Skill:

    Level:

  • Advanced fact-checking for reporters

    Fact-checking images, video and verifying facts.

    Skill:

    Level:

  • The best data on education

    What education data sets out there, and what stories can they help us tell?

    Skill:

    Level:

  • Investigative/data skills series: Data visualization using Infogram

    Data visualization for everyone using InfoGram, an easy but powerful tool available to journalists across Gannett.

    Skill:

    Level:

  • Basic Databases in Google Flourish and other tools

    A few easy tools to help you show your work: Google Flourish, Airtable and Tableizer.

    Skill:

    Level:

  • Investigative/data skills series: Data visualization using DataWrapper

    In part I of our two-part series, “Data visualization for everyone,” we explore DataWrapper — an easy but powerful tool available to journalists across Gannett.

    Skill:

    Level:

  • Google Public Data Explorer

    The Google Public Data Explorer is linked to reliable datasets that can help you build charts in minutes.

    Skill:

    Level:

  • Data scraping with Google Sheets and Tabula

    In this training video and hands-on exercises, you’ll learn how to scrape data tables out of web pages.

    Skill:

    Level:

  • Scraping online databases with Google Sheets

    An accessible way for anyone to quickly capture data that would otherwise require hundreds of hours at the keyboard to query.

    Skill:

    Level:

  • How to pry public records from a reluctant agency

    Government databases are public records, yet most agencies treat records requests for data as something exotic and fraught with challenges. Anticipate the objections and defeat them for the win.

    Skill:

    Level:

  • Unlocking the power of Excel pivot tables

    Slice and dice data to to organize your reporting, find patterns and reveal better stories.

    Skill:

    Level:

  • Data visualization introduction

    Visualizations can help make a complex story simpler. Play with simple data visualization tools, learn how to automatically import data into a map, and explore the elegant templates of Flourish.

    Skill:

    Level:

  • Introduction to using data in your reporting

    An overview of the key data analysis tools and techniques used to produce investigative stories, with examples of stories that were made possible with these tools.

    Skill:

    Level:

  • Backgrounding like a boss: Reporting on people and companies with free tools

    Even great reporters can get tricked by fake names or sketchy backgrounds. We’ll walk through some websites and strategies you can use to create a routine and spot potential red flags before you get burned.

    Skill:

    Level:

  • Advanced Search: Power tools for search, research and analysis

    See what users in your area are searching and discover story ideas on Google Trends. Explore Backlight, an AI tool for parsing massive amounts of documents.

    Skill:

    Level:

  • Verification tools

    Bad information is dangerous, especially in uncertain times. Learn how to verify images and video, investigate social media posts, and identify misinformation with open-source intelligence tools.

    Skill:

    Level:

  • Building a public records mindset

    A discussion on developing a documents state of mind — the key to doing solid watchdog work on a beat.

    Skill:

    Level:

  • Small newsrooms, big ambitions

    Just because your newsroom is small doesn’t mean your goals need to be.

    Skill:

    Level:

  • 9 Tips for Covering Election Misinformation

    Here are concrete, simple steps journalists can take to fight misinformation, avoid confusion and add context.

    Skill:

    Level: