Skip to content

Data and testing

Cambridge National IT revision notes, key terms and practice questions.

In short

Data is raw facts and figures with no context, such as 12, 15 and 9. Information is data that has been processed so it has meaning, such as 'the average temperature this week was 12 °C'.

For GCSE students in Years 10 and 11, on the OCR Cambridge National IT course.

Data and information

  • Data is raw facts and figures with no context, such as 12, 15 and 9. Information is data that has been processed so it has meaning, such as 'the average temperature this week was 12 °C'.
  • Common data types: text, number (integer or real), currency, date/time and Boolean (yes/no).

Collecting data

  • Primary data is collected first-hand for a purpose, using questionnaires, surveys, interviews, observations or sensors. It is relevant and up to date, but takes time and money to collect.
  • Secondary data was collected by someone else, such as websites, books, published statistics or existing databases. It is quick and cheap to get, but may be out of date, biased or not exactly what you need.

Storing and checking data

  • Data can be stored in spreadsheets, flat-file databases (one table), relational databases (linked tables) or files such as CSV files.
  • Validation checks that data is sensible: range, type, length, presence and format checks, and lookup checks (against a list of allowed values). It can't check that the data is actually correct.
  • Verification checks that data was entered or copied correctly: double entry (typing it twice) and visual checks (proofreading against the original).

Testing

  • A test plan lists each test, the test data, the expected result and the actual result. Test data should be normal, extreme (at the edges of the valid range) and erroneous (should be rejected).
  • Testing checks that a product works and meets the user requirements. In user acceptance testing, real users try the product to check it meets their needs.

Key terms

Data
Raw facts and figures with no context.
Information
Data that has been processed so that it has meaning.
Primary data
Data collected first-hand for a specific purpose.
Secondary data
Data that has already been collected by someone else.
Validation
Checking that data is sensible and allowed.
Verification
Checking that data has been entered or copied correctly.
Test plan
A list of tests with the test data, the expected results and the actual results.
Extreme data
Test data at the edges of the valid range.

Quick questions on Data and testing

What is the difference between data and information?
Information is data that has been processed and given meaning: 12 is data; '12 °C is the average temperature' is information.
Which of these is primary data?
Answers from a questionnaire you wrote: You collected it yourself, for your purpose.
What is one advantage of secondary data?
It is quick and cheap to get: Someone else has already collected it.
What does validation check?
That data is sensible and allowed: A valid date of birth can still be the wrong one.
What is double entry?
Typing data twice to check that both copies match: It is a type of verification.
Which validation check stops a field from being left empty?
Presence check: It checks that something has been entered.
What is a lookup check?
Checking data against a list of allowed values: For example, a drop-down list of sizes.
What does a test plan include?
The test data, expected results and actual results: It shows exactly what was tested.

Data and testing: questions and answers

Valid ages are 16 to 65. Which of these is extreme test data?
65 is at the edge of the valid range.
What is user acceptance testing?
Real users trying the product to check it meets their needs. It checks the product is fit for its users.
Why can't validation guarantee that data is correct?
Sensible data can still be wrong, such as a mistyped but valid date. Verification helps to catch these mistakes.

Practise Data and testing: 12 questions

Download these notes as a PDF

Previous topic: Human computer interface (HCI) in everyday lifeNext topic: Cyber-security and legislation

More in IT in the digital world (exam)

LycoLearn is still loading…

This can take a little longer on a busy school or home network. If nothing happens, try refreshing the page.

LycoLearn didn’t load properly

Part of it didn’t arrive. Try refreshing the page in a minute, or open LycoLearn in another browser.