To install some of the software below, you will need to alter your Mac security preferences to allow apps authored by developers that are not part of Apple’s ecosystem. Open
System Preferences>Security & Privacy, select the
General tab and click the lock icon at bottom left to make changes, then allow apps downloaded from
If you have a personal Gmail address, you have a Google account. Check that you can access Google Drive with this account. Google Sheets will be our spreadsheet application for these classes.
We will also make maps with Fusion Tables, described by Google as “an experimental data visualization web application to gather, visualize, and share data tables.” To connect Fusion Tables to your Drive account, click the red
NEW button at top left, select
+ Connect more apps and then select Google Fusion Tables:
At the next dialog box, click the blue
+ Connect button at top right. Click
OK to finish and close the open window.
A powerful tool for data cleaning, once owned by Google, now open source. Download the 2.6 beta version from here. When launched, Open Refine will work in your default web browser; note that your data remains on your computer, and is not uploaded to the web.
The Public version of the software requires you to save your visualizations to the open web. However, members of Investigative Reporters and Editors can obtain a license for the Professional version, which allows you to save workbooks on your machine. In any case, I strongly recommend that J-School students join IRE as a student member: it is a leader for training in data journalism.
Some of the tools we will use are Firefox add-ons. Ensure that you have the latest version of this popular web browser. Download Firefox, or if already installed, if necessary update to the latest version following these instructions.