Tag Archives: Google Forms

How to: plan a journalism project that needs data entry

Panorama source: FOI sent to 144 councils

This Panorama investigation involved entering data from 144 FOI responses

Data-driven reporting regularly involves some form of data entry — some of the stories I’ve been involved with, for example, have included entering information from Freedom of Information (FOI) requests, compiling data from documents such as companies’ accounts, or working with partners to collect information from a range of sources.

But you’ll rarely hear the challenges of managing these projects discussed in resources on data journalism.

Last week I delivered a session on exactly those challenges to a factchecking team in Albania, so I thought it might be useful to share the tips from that session here.

They include some steps to take to reduce the likelihood of problems arising, while also helping to ensure a data entry project takes as little time as possible. Continue reading

Creating dynamic visualisations using Google Forms and Google Gadgets

If you need to gather data on the ground – or want to crowdsource data through an online form – this is how you can visualise the results as they come in using 3 Google Docs tools. They are:

  • Google Forms
  • Google Docs spreadsheet
  • Google Gadgets

And here’s the process: Continue reading