IT revision

Select a numerical data type from the list below

• Boolean

• Alphanumeric

• Decimal

• Text

Select a non-numerical data type

• Boolean

• Integer

• Decimal

• Currency

Data validation is.......

• Used to check that data being entered is correct

• Used to check that data being entered is sensible and reasonable

• Used to check that data being entered is identical to the source

• Because it is needed to be used

Data verification is.......

• Used to check that data being entered is correct

• Used to check that data being entered is sensible and reasonable

• Used to check that data being entered is identical to the source

• Because it is needed to be used

A data type check checks.......

• Sets the length of the data entry.

  E.g. Mobile number has to be 11 integers in length.

• Makes sure that the data is in a specific format.

  E.g. UK postcode is in LLNN NLL format.

• Checks that the data entered is one of the required type.

  E.g. Price is in currency format.

• Provides users with a limited choice to select for data entry. Includes drop-down lists, radio buttons and tick lists. E.g. Drop-down list to select month.

A Input mask Format check checks.....

• Sets the length of the data entry.

  E.g. Mobile number has to be 11 integers in length.

• Makes sure that the data is in a specific format.

  E.g. UK postcode is in LLNN NLL format.

• Checks that the data entered is one of the required type.

  E.g. Price is in currency format.

• Provides users with a limited choice to select for data entry. Includes drop-down lists, radio buttons and tick lists. E.g. Drop-down list to select month.

A Presence check checks.....

• Sets the length of the data entry.

  E.g. Mobile number has to be 11 integers in length.

• Makes sure that the data is in a specific format.

  E.g. UK postcode is in LLNN NLL format.

• Checks that the data entered is one of the required type.

  E.g. Price is in currency format.

• Checks that the data has been entered into a specific field.

  E.g. Checks that the postcode has been entered for delivery.

Double entry is a data verification tool?

• True

• False

Double entry is....

• Proof reading

• Entering the data once so make sure no mistakes can occur

• Entering the data twice

  Data entered is checked by comparing it with another set of data to make sure they are the same. If any difference is found between two sets of data, then the user is alerted by an error message

• Is not a data verification tool

Define data

• Statistics

• Information

• Raw facts and figures before they have been processed

• Information that has been processed