Tag Archives: Data Capture

10 rules for Clean data

We spend lot of time in data cleaning. But there is no simple definition of exactly what clean data means. Therefore, I created a simple 10 item checklist. If all 10 items are correct, data is clean. Simple and easy to use.

10 rules for Clean data

Remember, here we are talking about input data – not output (reports).

  1. Each column must have a heading
  2. No blank headings
  3. No duplicate headings
  4. No formulas in headings
  5. No merged cells
  6. Each column must have ONE meaning
  7. Each column must have ONE type of data
  8. No subtotals or grand totals
  9. Formatting should not be used instead of data
  10. Data must grow vertically, not horizontally
Watch this video to learn more.
This is the Hindi version.

Convert clean data to a Table

If you are using Excel, as soon as data is cleaned, convert it into a Table. Why? Here are the benefits of using Excel Tables – 13 articles.

Using Word Forms

Although Word is most commonly used for creating documents, it can also be used for capturing data like a form. Word Forms do not require any programming knowledge. These are easy to create and will work across ALL versions of Word.

image

The Need for Word Forms

This is very useful for conducting quick surveys or quizzes where you want to control the responses. Of course, there are more sophisticated methods and tools available for bother these scenarios, Word is familiar to everyone and almost guaranteed to be available on every desktop. Hence it is a compelling option even today (2017).

Continue reading Using Word Forms

SharePoint – Part 7 : Capturing data from multiple people without using Excel

Capturing data from multiple people without using Excel:

This is a single most useful feature of SharePoint. No programming. Just create a list and get started. Much better than using Excel. Start using it NOW!

SharePoint 2013 update: Datasheet view is now called Quick Edit. It does NOT require Access to be loaded and it works on all browsers.