Overview

When entering data by hand, errors are common and it is important to find and identify them before attempting to analyse data. This activity uses the One variable Summarise Dialog to check for errors, and then employs double-entry to identify and correct errors using the Compare Columns and Filter Dialogs. Finally it shows users how to create a report of the corrections.

First watch the video. 

 

Video script prepared by Rachel Kirk-Gushowaty, and Roger Stern.  Video constructed and voiced by Beryl Waswa.

  • 0:00 Introduction to R-Instat 
  • 0:06 Intoduction to Checking and Correcting Data 
  • 1:04 One Variable Summarise Check 
  • 2:14 Insert Column/Rows 
  • 2:29 Select Columns 
  • 3:17 Check by Comparing Columns 
  •  4:07 Add a Comment to Report Corrections 
  • 5:00 Reflections
(6 minutes)

Then use the practice document to follow the steps yourself. 

Data Entry 2 - Checking and Correcting Data