Chapter 19 - Designing Accurate Data-Entry Procedures

1. Data Entry Objectives
   • Effective and Efficient Data Entry
   • Effective Coding
   • Assuring Quality Through Validation
2. Effective Coding
   • Keeping Tract of Something
     • Simple Sequence Codes
     • Alphabetic Derivation Codes
   • Classifying Information
     • Classification Codes
     • Block Sequence Codes
   • Concealing Information
     • Cipher Codes
   • Revealing Information
     • Significant-Digit Subset Codes
     • Mnemonic Codes
   • Requesting Appropriate Action
     • Function Codesw
   • General Guidelines for Coding
     • Be concise
     • Keep codes stable
     • Make codes that are unique
     • Allow codes to be sortable
     • Avoid confusing codes
     • Keep codes uniform
     • Allow for modification of codes
     • Make codes meaningful
3. Effective and Efficient Data Capture
   • Decide what to capture
   • Let the computer do the rest
   • Avoid bottlenecks and extra steps
   • Starting with a good form
   • Choosing a data-entry method
     • Keyboards
     • OCR (Optical Character Recognition)
     • Other Methods of Data Entry
       • MICR (magnetic ink character recognition)
       • Mark-sense forms (scan sheets)
       • punch-out forms
       • bar codes
4. Assuring Data Quality through Input Validation
   • Validating Input Transactions
     • Submitting the wrong data
     • Submitting data by an unauthorized person
     • Asking the system to perform an unacceptable function
   • Validating Input Data
     • test for missing data
     • test for correct field length
     • test for class or composition
     • test for range or reasonableness
     • test for comparison with stored data
     • test for invalid values
     • setting up self-validating codes (check digits)
5. Accuracy, Codes, and the Graphical User Interface

Exercises: (due - noon Dec. 3, 1998)
e-mail to summers_wayne@ColumbusState.edu your answers to problems 1, 3 on page 756