Data Entry & Organisation

The data are now entered into a computer, or downloaded from field data collection devices. Good data entry proceeds smoothly and quickly and results in accurate data sets ready for analysis. This requires careful planning and explicit attention to checking and quality. Data entry has often been a bottleneck in research and a cause for delay, which lowers the quality and utility of the results.

At the data entry planning stage we mentioned that part of the planning involved deciding which software to use. We find though that many researchers use Excel as a matter of course and often skip the planning stage completely. In many cases Excel is perfectly adequate but planning and preparing your worksheets in advance will help you to avoid errors and consequently raises the quality of your data. To encourage planning we once again refer you to our Excel booklet on using it "with discipline" along with our data management for METs guide.

If you find you are reaching the limits of Excel, you may consider using a database package. Our booklet on the Role of a Database Package for Research Projects is designed to help you with this decision.


CS-Pro Video Demonstrations

On the Planning Data Entry page there is a link to a series of video demonstrations showing how to create a data entry system using CS-Pro. Here we include further video demonstrations illustrating the use of these systems for data entry and checking. These are available in formats suitable for desktop screens and for smaller laptop screens. Some are also available with the narative in French.

How to do data entry in CS-Pro for small screen
CS-Pro Files for small screen
Backing up the system for small screen en français pour petit écran
Using Zip Files for small screen
Double-data Entry (Compare Data Tool) for small screen en français pour petit écran
Concatenate Data Files for small screen en français pour petit écran


Last updated: 1 May, 2012