A few years ago at a training at the University of Cincinnati, a participant asked me about sizing social media images. Her problem: How can the social media desk properly size an image to fit in a Facebook header, Twitter feed and Instagram in just a few minutes.
Google MyMaps is the perfect tool for mapping small datasets for dayturn stories and projects. Have a dataset of pothole repairs in your city? Map it. Tracking crime in certain neighborhoods? Load a spreadsheet from your police department into MyMaps. There are thousands of stories to be found in datasets on your city, county, state and federal data portals.
With the school year underway, let’s explore how to implement Journalist’s Toolbox into a classroom rather than focus on a single tool this month. College professors and high school journalism teachers have used the site for more than 25 years, mainly for research purposes.
Google purchased the Flourish graphics tool five years ago, and it has evolved into an excellent tool for creating animated charts, maps and other interactives using only a spreadsheet. The tool includes a paid account for developers to code and add watermarks, but the free version of Flourish meets most newsrooms’ needs.
There are many good smartphone video editing apps on the market, but for my work, the VN video editing app for iPhone and Android gets the job done better than any other tool based on ease of use and powerful controls.
If you need to visualize U.S. Census data, unemployment statistics or other datasets quick and with no spreadsheets or coding, give the Google Public Data Explorer a try. The Data Explorer is linked into several official databases, including the census, Bureau of Labor Statistics, Eurostat, the Inter-American Development Bank, World Trade Organization and the International Monetary Fund.
There are many ways to visualize data from the U.S. Census. Next month, we’ll explore chart-making software to visualize demographic data. But this month we’ll explore how to visualize physical change with Google Earth Engine Timelapse. Earth Engine is a project organized by Google, Carnegie Mellon, the US Geological Survey and NASA.
April 12th, 2021 • Featured, Quill Blog, Toolbox, Quill Archives
SPJ Journalist’s Toolbox Tool of the Month: Scraping a .PDF
I loathe .PDFs of public records with the power of a thousand suns. They’re a tease. They’re full of data tables but useless to most data journalists in the .PDF format. And government officials love to share them with us because they know a .PDF
Government websites love to bury data in tables on web pages. Why? It satisfies legal requirements for making document public under sunshine laws, but it renders the data useless. You can’t sort or filter the data to look for trends, do math calculations to find rates and averages, and other things journalists need to find stories.
Reporters hate transcribing notes and they often ask me during newsroom training what tools work best. They want speed and accuracy with the transcriptions, and they want it free (or very cheap). I’ve listed many tools on the Toolbox’s Transcription Tools page, but here are my three favorites for speed, use and cost: Otter.ai:
Editor’s note: This is the first of what will be monthly posts about how to use digital and data tools on Journalist’s Toolbox. Check back each month for new tools, tips and tricks. Google launched its Dataset Search tool in November 2018 to help researchers locate data that is freely available for use.
Victor Hernandez preaches the gospel of newsroom productivity, whether he’s working with his reporters in the Crosscut newsroom in Seattle or training journalists at conferences around the country. Hernandez’s philosophy is simple: Think trends and not tools when finding digital resources that can make you more productive.