#CIJSummer

Investigative Journalism Summer Conference
Where new tools meet traditional craft
04 – 06 July 2019

Technical requirements

WiFi
Use Goldsmiths’ Guest WiFi. 

Google account
Is useful to have for many classes. Especially if you want to attend Google Sheets (Excel) 1-3. Please create it ahead of the conference if you do not have one.

There are lots of hands-on classes taking place at the #CIJSummer Conference 2018.

Technical requirements will be published below as they are confirmed by our trainers. Please check here regularly for any updates to the requirements regarding the classes you intend to take.

The ‘Data Concierge’ service will be available twice a day on Thu 28 and Fri 29 June for you to guide you through any installations you may need.

Please make sure you have admin rights to your laptops!
Please see the concierge schedule below:
Thu 28 June
AM During Introduction to data Journalism class – room PSH 104
PM Lunch break: 13:00 – 13:30 PSH Atrium
Fri 29 June
AM During registrations 08:30 – 09:00 PSH Atrium
PM Lunch break: 13:15 – 13:45 PSH Atrium
Introduction to Data Visualisations

Bring your own laptop

 

Creating Data Visualisations and Interactives with Flourish

You only need a laptop with an internet connection and a modern browser (eg. Chrome or Firefox)

 

Web Scraping for Journalists 1 & 2

Delegates will be using their own laptop and should have a Google drive account, download the free version of outwit hub. A GitHub account would also be useful.

NB The software is all free. However the free version of OutWit Hub only allows you to scrape 100 rows, so you may want to pay for the full version but can decide after you’ve learnt how to use it on the course.

 

SQL for Journalists 1-3

Own laptop with SQL Server Management St​udio Express (free) version, Excel 2010 or newer; Notepad (classic, retro, free one for .txt)​ required.

 

Finding Needles in Haystacks with Fuzzy Matching

Own laptop required. Install Python 3 (https://www.python.org/downloads). On Macs open the Terminal (inside Applications, then Utilities) and run: pip3 install csvmatch. On Windows, also install Cygwin (https://cygwin.com/install.html), then open Cygwin and run: pip3 install csvmatch.

Data Cleaning with Pandas

Own laptop required.  Install Python 3 (https://www.python.org/downloads).
A package manager like Home brew or anaconda
Jupyter Notebook
Pandas
Matplotlib

R 1-3

INSTALLING PACKAGES FOR R CLASSES

For the R 1-3 classes please install R and RStudio as outlined below.

Please note you will need administrator rights on your laptop to install and run R in class.

FOR WINDOWS

Install R: https://cran.ma.imperial.ac.uk/bin/windows/base/R-3.5.0-win.exe
Download the latest version of R for Windows (3.5.0 “Joy in Playing” released 2018-04-23) from this link.
Follow the installation instructions and install at the default location suggested by the package.

Install RStudio: https://download1.rstudio.org/RStudio-1.1.453.exe
Download RStudio (1.1.453 released 2018-05-16) from this link
Follow the installation instructions and install at the default location suggested by the package.

To ensure the downloads are complete and correct open RStudio.
When you have opened the package you should see the following in the bottom left pane: “R version 3.5.0 (2018-04-23) — “Joy in Playing” Copyright (C) 2018 The R Foundation for Statistical Computing”

If this is the case installation is complete.

FOR MACS

Install R: To install the correct version you need to check the version of OS X.
Do this by clicking on the Apple icon in the top left corner.
On the overview panel if the computer is running OS X 10.11 (El Capitan) or higher download the latest version of R for Mac (R 3.5.0 “Joy in Playing” released on 2018-04-24) from this link. https://cran.ma.imperial.ac.uk/bin/macosx/R-3.5.0.pkg

On the overview panel if the computer is running running an OS X package lower than “OS X 10.11” you’ll need to install a different version of R. If the computer is running “OS X 10.9” (Mavericks) download this package of R for Mac (3.3.3) from this link. https://cran.ma.imperial.ac.uk/bin/macosx/R-3.3.3.pkg

If the computer is running “OS X 10.6” (Snow Leopard) download this package of R for Mac (3.2.1) from this link. https://cran.ma.imperial.ac.uk/bin/macosx/R-3.2.1-snowleopard.pkg
Follow the installation instructions and install at the default location suggested by the package.

Install RStudio: https://download1.rstudio.org/RStudio-1.1.453.dmg
Download RStudio (1.1.453 released 2018-05-16) from this link
Follow the installation instructions and install at the default location suggested by the package.

It will also require a Mac OS X 10.6 operating system or higher. When you go to open the package, you will need to drag the new RStudio icon to Applications.

To ensure the downloads are complete and correct open RStudio.
When you have opened the package you should see the following in the bottom left pane: “R version 3.5.0 (2018-04-24) — “Joy in Playing” Copyright (C) 2018 The R Foundation for Statistical Computing”
If you have installed an earlier version of the package, such as R 3.3.3 or R 3.2.1 outlined above, the version code will appear in this window.

If this is the case installation is complete.