A common challenge in ensuring data quality is difficulties people face when using spreadsheets. When data is properly managed, it is much easier to answer fundamental questions and conduct analysis. Correctly managed data also ensures you aren’t making decisions based on faulty evidence. Knowing how to structure and organise data in a spreadsheet is fundamental to ensuring consistency in your data.
In this module we look at how to effectively structure a spreadsheet for raw data collection. We will cover:
- Spreadsheet layouts
- Column titles
- Header rows and the freeze function
- Data types
At the end of this module you can try out what you’ve learnt on a spreadsheet.