Sports databases: Google Flourish and AirTable

Skill:

Level:

    • Sports are built on data. We’ll work through a series of exercises to build interactive databases of sports data. This can be an effective tool at all levels of sports coverage: A searchable database of college football stats, salaries of high school football coaches in your state, sortable by conference, town, etc. Or professional sports salaries, player stats and more. Tools: https://flourish.studio/ and https://airtable.com/

    Dataset: 100 Highest-Paid Athletics 2021

    https://docs.google.com/spreadsheets/d/18NSHA9–IBuHq7qc-g2f-mSWBx3bnvieQxykp44Vles/edit#gid=0

    Source: Sportico | https://www.sportico.com/c/business/finance/
    Journalist’s Toolbox Sports Data: https://www.journaliststoolbox.org/2022/06/11/sports-data/

    More training on Reporting & Writing:

    Google Earth Studio

    Learn how to use Google Earth Studio, Google Earth Pro, Google Earth Timelapse and Earth Measure Tool with training by author and data journalism expert Mike Reilley.

    Skill:

    Level:

    • To the Point 101 — Why we’re doing it and what successful TTP looks like

    We know our younger digital readers are seeking scannable, easy-to-digest content. Here’s what it is (and isn’t), how our efforts so far are helping us reach readers with premium and metered content and some successful examples on how newsrooms are putting it to use and making it a priority.

    Skill:

    Level:

    • Google tools for journalists

    Google Fact-Check Explorer, Google Public Data Explorer, Google Trends, Google search shortcuts/advanced search), MapChecking for crowd size estimates, PhantomBuster, VisualPing for tracking website updates and other cool tools and hacks.

    Skill:

    Level:

    • Microsoft Excel 05 – What if

    The more data you have, the more questions you will have about it, and the more answers it can provide. Excel has a variety of conditional formulas that let you evaluate subsets of your data to find the stories to tell: If…Then formulas; Conditional Functions; XLOOKUP; Array Functions.

    Skill:

    Level: