The outcome of data entry is to have reliable, organized data that can be used by decision makers.

The success of data entry depends upon:

1)The accuracy of the inputted data entered

2)The quality of the source data

1. Validate the source data

Ensure that source data is accurate and complete

2. Use descriptive names when naming rows and columns

Important for the user to understand the data

3. Consistency in entering data in rows and columns

Data must be useable

1.Validate the source data

Q: If there are errors in the source data, do you think the inputted data will be useful or reliable?

Example: Contract price on the contract is not correct. Therefore data that was inputted

2. Use descriptive names when naming rows or columns
3. Consistency in entering data in rows and columns

4. Use formulas to recalculate data and ensure accuracy of manually calculated source data
5. Mark the source data once it has been entered

• Important to avoid entering the same data twice

6. Automate when possible

• If a formula repeats itself, you can use the drag function to automate the calculation

1. Use formulas to recalculate data and ensure accuracy of manually calculated source data
2. Mark the source data once it has been entered
3. Automate when possible

7. If you’re unsure if the data is accurate or correct, highlight the cell for further review
8. Use shortcuts

• Keep practicing and you will become more efficient

9. Avoid rushing

• Rushing data entry tasks will lead to more errors