Intermediate

Protected: Scrape-a-palooza and Google Flourish

There is no excerpt because this is a protected post.

Skill:

Level:

    • Protected: Advanced sports coverage using Google Earth Pro

    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:

    • Business tools, Part IV: Covering inflation and consumer prices

    Learn how to use inflation calculation tools and track prices on Amazon, eBay and other digital platforms. Tools include the Bureau of Labor Statistics, Keepa.com, Google Shopping, FormDs.com and several other resources. We’ll also look at tools for spotting fake online sellers and fake reviews on online sales sites. 

    Skill:

    Level:

    • Protected: High school and college sports coverage tools, Part I

    There is no excerpt because this is a protected post.

    Skill:

    Level:

    • Protected: Tools for covering inflation and consumer prices

    There is no excerpt because this is a protected post.

    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:

    • Protected: Google Earth tools for your newsroom

    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:

    • Identifying discrimination through data

    Jayme Fraser of the I-Team and Robbie Gutierrez of the DOT will show how to pick out patterns hiding in data sets.

    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:

    • Diversity and the newsroom: Tips for expanding coverage and supporting reporters of color

    The Columbus Dispatch’s Erica Thompson explores a few big stories and offers tips on advocating for diverse coverage and better support of reporters of color.

    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:

    • Protected: Reporting tools for sophisticated shopping season retail coverage

    There is no excerpt because this is a protected post.

    Skill:

    Level:

    • Mapping tools that reveal inequalities in our communities

    This will use Census data and two new network tools: Diversity Dashboard and Pass the Mic, to see where stories land and how to cultivate follow ups with sources.

    Skill:

    Level:

    • Conducting a source audit and building a diverse source database

    You likely know the racial and ethnic makeup of your newsroom, but what about your sources? Let’s talk about why diverse sourcing is important, how to find out how well your sources represent your community and ideas on creating and retaining those sources.

    Skill:

    Level:

    • Backgrounding a business

    How to search for proxies and tools for covering business, non-profits and the economy overall.

    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:

    • What do you mean, it’s “statistically significant?”

    Advanced math for journalists.

    Skill:

    Level:

    • The best data about inequality

    What are the best datasets out there and what stories can they tell?

    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:

    • Finding diverse expert sources

    This session will show you how to use expert databases to find vetted sources, what to look for with “faux experts” and how to follow experts when they publish.

    Skill:

    Level:

    • Fact-Checking IV: Fact-Checking Videos

    Was the video doctored? How can we see when and where a video was first published? We’ll explore how with Watch Frame-by-Frame and Amnesty International’s YouTube Dataviewer.

    Skill:

    Level:

    • Fact-Checking III: Put Your Photo Fact-Checking Skills to the Test

    We’ll give you three photos to fact-check with context shared (for real) on social media about each photo. Your job is to reverse image search each photo to see if the context is accurate or if the photo has been misrepresented.

    Skill:

    Level:

    • Fact-Checking II: Fact-Checking Photos

    How can we see when and where a photo was first published? We’ll explore how with Google Image Search, TinEye and FotoForensics.

    Skill:

    Level:

    • Intro to mapchecking.com

    Do you need to estimate a crowd size at a large outdoor event such as a protest, parade, concert or other ticketless event? Then MapChecking.com is the tool for you.

    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:

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

    • How editors and managers can help keep reporters and photographers safe during protests

    Guidance for managers, starting with planning before a charged event, to communicating and adapting as conditions change to after-action debriefs.

    Skill:

    Level:

    • Earning trust in your election coverage

    Learn how to defend your coverage, explain it, and demonstrate to your audience why you’re a credible source.

    Skill:

    Level:

    • 9 remote interviewing tips for journalists

    From the technical to the legal, how to make sure you’re covered when you can’t meet a source face-to-face.

    Skill:

    Level:

    • Advanced backgrounding of people and companies

    From Investigative Reporters and Editors, here’s how to build a deep well of background to inform your reporting and writing.

    Skill:

    Level:

    • Reporting on farm bankruptcies in your own backyard

    Using a database created by Sky Chadde, the Gannett Agriculture Data Fellow at the Midwest Center for Investigative Reporting, you’ll be able to localize the impact of these bankruptcies and identify trends in your community.

    Skill:

    Level:

    • #DoJournalismWithImpact (for digital editors)

    Got a major project planned? Why not use Architect, the new external article template from GateHouse Media? Program developer Tyson Bird touches on how this tool can be used most effectively and shows examples of the template in action.

    Skill:

    Level:

    • Google: Geo and mapping

    Maggie Farley, a former Los Angeles Times foreign correspondent who now works with Google News Initiative, covers Geo and Mapping.

    Skill:

    Level:

    • Exploring Google Trends

    Maggie Farley, a former Los Angeles Times foreign correspondent, is now working with Google News Initiative to help journalism thrive in the digital age. This video covers Google Trends.

    Skill:

    Level:

    • Identifying and supporting trauma among fellow journalists

    A newsroom-wide briefing and discussion on trauma and journalism, introducing best practices in coverage and the basics of self-care and collegial support.

    Skill:

    Level:

    • 50 tools for writing well with Roy Peter Clark

    Organized into four sections, “Nuts and Bolts,” “Special Effects,” “Blueprints for Stories,” and “Useful Habits,” this series is infused with more than 200 examples from journalism and literature.

    Skill:

    Level: