Loading…
#VVOJ17 has ended

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Zaal 6 – Datacrunchers [clear filter]
Saturday, November 4
 

10:00am CET

DATATRACK – Cleaning data with Excel
- ENGLISH SPOKEN -

Sometimes data is dirty, full of errors omissions and oddities. In this session you will learn what Excel can do to tidy things up. As well as cleaning you will also learn about some of the handy formulas which can help you find even more useful facts and patterns in large datasets.

IMPORTANT: For this session you'll need to bring your own laptop, with Excel 365 or Excel 2016 installed. Please note that online versions of Excel, older versions of Excel, Google spreadsheets, or Open Office won't suffice.

LET OP: Bij deze training is Engels de voertaal en je zult je eigen laptop mee moeten nemen, met daarop Excel 365 of Excel 2016 geïnstalleerd. Oudere versies van Excel, Google Spreadsheets of Open Office zijn onvoldoende.

Speakers
avatar for Crina Boros

Crina Boros

Investigative Reporter | Data Journalism Visiting Lecturer
A data-driven watchdog reporter based in London, I've also been training data journalism across the map. An IRE member and offspring of the Centre for Investigative Journalism (CIJ), I've published with Reuters, the BBC, ICIJ, openDemocracy, Greenpeace Unearthed, Euobserver, The Black... Read More →
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)


Saturday November 4, 2017 10:00am - 11:10am CET
De L'Empereur, zaal 6 – Datacrunchers Stationsstraat 2, 6221 BP Maastricht

11:30am CET

DATATRACK – Connect the dots... with statistics!
ENGLISH SPOKEN

Statistical tests are windows into relationships: does your race influence your circumstances? Does your income influence your performance? We'll take a hands-on look at what Linear Regression can tell us. You need to be very familiar with Excel. Similarly, you will be new to statistics.

IMPORTANT: For this session you'll need to bring your own laptop, with Excel installed. PC's need Excel 2010 or newer. Apple laptops need Excel 365 or Excel 2016 - older versions will not do. Please note that online versions of Excel, Google spreadsheets, or Open Office won't suffice.

Speakers
avatar for Crina Boros

Crina Boros

Investigative Reporter | Data Journalism Visiting Lecturer
A data-driven watchdog reporter based in London, I've also been training data journalism across the map. An IRE member and offspring of the Centre for Investigative Journalism (CIJ), I've published with Reuters, the BBC, ICIJ, openDemocracy, Greenpeace Unearthed, Euobserver, The Black... Read More →


Saturday November 4, 2017 11:30am - 12:40pm CET
De L'Empereur, zaal 6 – Datacrunchers Stationsstraat 2, 6221 BP Maastricht

2:10pm CET

DATATRACK – Data opschonen met Open Refine
- ENGLISH SPOKEN -

Excel can only take you so far. The free, open source cleaning tool OpenRefine can do even more to tidy up data quickly, and easily. It's well worth going to this session to help you get started, and to see the amazing things OpenRefine can do.

IMPORTANT: Please install and RUN OpenRefine (from openrefine.org) before this session. You may find it requires you to update your browser, or dependent programs like Java, and we won't have time to do this in the session itself.


Speakers
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)


Saturday November 4, 2017 2:10pm - 3:20pm CET
De L'Empereur, zaal 6 – Datacrunchers Stationsstraat 2, 6221 BP Maastricht