Good data organisation is the foundation of any research project and many researchers have data in spreadsheets at some point during the research process.
We organise data in spreadsheets in the way that we as humans want to work with the data, but computers require that data be organised in particular ways. In order to use the tools that make computation more efficient, such as programming languages like R or Python, or to conduct statistical analyses in SPSS, R or using Stata, we need to structure our data the way that the computers need the data.
In this workshop you will learn:
- good data entry practices: formatting data tables in spreadsheets
- how to avoid common formatting mistakes
- approaches for handling dates in spreadsheets
- basic quality control and data manipulation in spreadsheets
- exporting data from spreadsheets.
In this lesson however, you will not learn about data analysis with spreadsheets. This course is very focused on good data management practice to make your life easier at the point of analysis. If you would like to learn more about the functionality of Excel please visit the Computing Service information on the courses they run on Excel.
This session will use materials from the Data Carpentry Data Organisation in Spreadsheets lesson Copyright (c) Data Carpentry) CC BY 4.0 Licence.
Date(s) - 09/03/2020
10:00 am - 12:30 pm
Main Campus (Library L1 Training Room)
Event Speaker/Organiser: Alison Nightingale Course Code: RP00534 Topic: Research data management Digital Capability: All UKPSF: All RDF: Target Audience: All
Download ical file iCal