#CIJSummer

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

Technical requirements 2019

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 an account ahead of the conference if you do not have one.

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

The ‘Data Lab’ service will be available twice a day on Thu 4 and Fri 5 July for you to guide you through any installations you may need.

Please make sure you have admin rights to your laptops! Most classes will not work if you are using tablets/mobile devices. Laptops are the safest option.


Data escape room

Please bring your laptop. You must have admin rights for it.

Before the class:

  • Having Excel/Googlesheets/R will all come in handy.
  • People who want to use OpenRefine will also get something useful out of that, but the game is designed to be played with standard spreadsheet software.

 

Excel

The class will take place at a computer lab with desktops provided. You do not need to bring a laptop for this class.

If you do want to use your own laptop, please ensure you have MS Excel 2010 or newer installed.

 

Flourish

Please bring your own laptop. It must be connected to the internet.
Flourish is a completely browser-based tool.

Before the class:
– sign up for a free Flourish account (via https://app.flourish.studio/register), so the class can get started right away.

 

Google Sheets

No own laptops needed. The class will take place at a computer lab with desktops provided

Before the class:


Graph Database

Please bring your laptop. You must have admin rights for it.

Before the class:
– install Neo4j https://neo4j.com/download/

The software is free but you will be asked to fill in your details before you can download the software. Please be aware that Neo4j needs at least Java 7 to run. If you get an error, you may need to update this.

 

R

Please bring your own laptop. You must have admin rights for it.

Before the class:

  • Install the following software. Please see guidance documents below.

Windows:

R: https://cran.ma.imperial.ac.uk/bin/windows/base/R-3.6.0-win.exe

RStudio: https://download1.rstudio.org/desktop/windows/RStudio-1.2.1335.exe

Mac:

R: https://cran.ma.imperial.ac.uk/bin/macosx/R-3.6.0.pkg

RStudio: https://download1.rstudio.org/desktop/macos/RStudio-1.2.1335.dmg


Scraping

Please bring your laptop. It must be connected to the internet.

Before the class:

  • Make sure you have a Google Drive account.
  • Sign up for a free IFTTT.com account – this will speed things up at the class.


SQL

Please bring your own laptop. You must have admin rights. Mobile devices/ tablets will not work for this class.

Before the class:
– download the DB Browser – https://sqlitebrowser.org/. This should be free of charge and unlimited.
– install Excel and a notepad. These can be express versions, as you will not be using them for analysis, but are necessary to work with SQL.