Data-scraping web pages, PDFs and Google Finance

Skill:

Level:

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

    Links and data sets used in this workshopDownload

    More training on Investigative:

    Converting criminal justice coverage to social justice coverage

    A conversation around how social justice storytelling can help humanize even the most tragic of stories and how we can ensure our reporting serves both our communities and our readership goals.

    Skill:

    Level:

    • Covering retail and inflation

    Learn how to use tools like Google Shopping, Keepa and CamelCamelCamel to track prices. Also: How to use the Consumer Price Index, use inflation calculators and other tools for tracking prices and fraudulent online sellers/reviewers.

    Skill:

    Level:

    • Data visualization: InfoGram 201

    Students will use datasets to build more advanced maps and single chart graphics.

    Skill:

    Level:

    • Don’t count words. Make your words count.

    Writing concise, to the point stories isn’t about cutting until you’re under the limit. It’s about writing the story with the right words and nothing more. We’ll talk about finding the one thing that will drive your story, how a zero draft can start you in the right place, the magic of reading aloud and the secret sauce of short yet authoritative writing (that one, as they say, may shock you).

    Skill:

    Level: