This course will be in two parts: a 1.5-hour online lecture on how to make a spreadsheet usable for other people held on the 4th of October at 10:00 in Zoom and the practical workshop on cleaning your messy data with OpenRefine software will be a video lecture you can follow in your own time. Additionally, we will hold 2 Q&A sessions in Zoom, where you can talk about any problems you encountered with the OpenRefine software.

This course will cover how to name your files and variables, version control, compile a data dictionary, and what to do with empty cells. In the second part of this lecture, OpenRefine software is introduced. With this, you can easily clean up the messy data. For the more practical aspect of using the OpenRefine software, we will share a video that will teach the basics. You can watch it anytime and do the lessons yourself. On two days (7.10 and 10.10), there will be a 1h slot (10:00-11:00) on Zoom, when you can come and ask any question you have regarding tables and OpenRefine software.