How To Do Data Entry with Scanners

"Can I use scanners and scanning software technology for data entry"? Yes you can, but only if it contains the best of penmanship.

As one who deals with paper surveys with open-ended questions and comments, I know what it's like to try to capture hand written text responses from those whose penmanship is a bit cryptic. Wouldn't it be nice to be able to just run these through some kind of scanner and have a computer transcribe it? Dream on!

There have been some very powerful advances in scanning software that does a pretty good job of converting printed words into editable ASCII characters. Most of us have used OCR software that comes bundled with scanners. I recently discovered the power of Adobe Acrobat to convert scanned printed material to editable ASCII characters that even automatically picks the correct font of the original. If handwritten comments are legible with the best of penmanship, Acrobat may even convert some of that, too. The quality of the text capture results are directly related to the clarity of the text on the scan. Scanning a document in pdf format creates an image, so make sure that your resolution is adequate. I would recommend scanning with no less than 300 dpi. If the quality of the original is high, the converted pdf file will look very much like the original except that the characters will now be editable and even searchable. The technology isn't perfect by any means, but it will amaze you.

Sometimes, when working with hard to read comments, it works best to use specialized software like Scantron's eListen 6.0 survey software. As their website says, "eListen 6.0 eliminates tedious manual data entry by capturing and storing handwritten responses using Scantron's Clarity OMR and Imaging scanner". This software captures the pre-defined comment section as an image which you can then let the reader try to decipher for themselves.

Another option that has worked well for us in circumstances where there are many open-ended questions is to scan the entire paper survey form using a high-speed copier like our Ricoh. We scan single or double-sided sheets and save the file in a pdf format and either burn the files to CD or post them to our ftp site.

Of course, there are many businesses, like ours, that provide manual transcription services for data entry of hand written comments to be included in your reports. That's part of the fun that I get to do from time to time.

Is NCS data form the same as Scantron data form?

Scantron Form is the most widely recognized term to describe Optical Mark Read (OMR) machine-readable forms. NCS data forms are basically the same thing. In fact, NCS was recently purchased by Scantron. Scantron and NCS is to OMR what Coke is to cola and Kleenex is to tissue. The Scantron Form is commonly used in the education establishment for testing, conference course evaluations, surveys and other data collection projects. But it need not be limited to education applications. Because OMR is still considered the most cost-effective and reliable method for getting data off of paper into meaningful reports, it remains the time-proven standard against which alternate data collection systems are compared.

NCS forms (also referred to as Scantron forms) have a unique appearance but the process of designing, printing and processing this form is still the same. It follows critical criteria for positioning, printing and scanning in order to capture the data accurately. All the steps in the process involve specialized software and hardware. Scantron provides both, but so do many other good companies. In fact, there are other sources of OMR products and services that are actually better and more affordable.

Scantron gets a good deal when their name is attached to a generic product like an OMR form. But the customer may or may not get such a good deal by the association. It's important to note that there are other options to investigate. The generic association doesn't make it the best. Biggest maybe. But not necessarily the best. Scantron/NCS produces some great scanners. We use them and sell them. But we also use a variety of other software not produced by NCS that works better in our estimation. So don't be easily influenced by the big names. Do your research. Ask around for advice from those who have had experience with many different products and services. Good things often come in smaller packages.