LO2 - data capture
Click here to link to the OCR text book - Read pages 42 to 51 then complete the tasks below
1. Why are telephone numbers stored as text in a database?
2. Why is some data coded for storage in a database?
3. Why are validation checks necessary when data is being entered into a database?
4. When using a paper form why is it important to collect a person's date of birth by asking them to fill in
dd/mm/yyyy rather than asking them to write their data on a blank line?
5. Why would a receptionist who is signing up a new member of a leisure centre use an online form to
collect details rather than give the member a paper form to complete?
Exam-type questions
1 For each of the following, choose whether it is better to use a paper-based form or an online form.
Give a reason for your choice.
a) A questionnaire to hand out to visitors as they enter a leisure centre. [2 marks]
b) A form to be filled in by a receptionist to add a new member to the leisure centre. [2 marks]
c) A form to be used by an estate agent to collect the details of the interior of a house to rent while
visiting the empty house. [2 marks]
d) A form to be used on a website for entering the details of houses for rent. [2 marks]
2 Why do some paper-based forms show examples of the data that has to be entered? [2 marks]
3 How can an online form be set up to make sure that the person using it enters only letters in their name?
[3 marks]
4 How can a paper-based form be set up to make sure that the person using it enters only the correct number of characters in a postcode? [2 marks]
5 How can the owner of an online form make sure that all the important data is entered into the form? [4 marks]
1. Why are telephone numbers stored as text in a database?
2. Why is some data coded for storage in a database?
3. Why are validation checks necessary when data is being entered into a database?
4. When using a paper form why is it important to collect a person's date of birth by asking them to fill in
dd/mm/yyyy rather than asking them to write their data on a blank line?
5. Why would a receptionist who is signing up a new member of a leisure centre use an online form to
collect details rather than give the member a paper form to complete?
Exam-type questions
1 For each of the following, choose whether it is better to use a paper-based form or an online form.
Give a reason for your choice.
a) A questionnaire to hand out to visitors as they enter a leisure centre. [2 marks]
b) A form to be filled in by a receptionist to add a new member to the leisure centre. [2 marks]
c) A form to be used by an estate agent to collect the details of the interior of a house to rent while
visiting the empty house. [2 marks]
d) A form to be used on a website for entering the details of houses for rent. [2 marks]
2 Why do some paper-based forms show examples of the data that has to be entered? [2 marks]
3 How can an online form be set up to make sure that the person using it enters only letters in their name?
[3 marks]
4 How can a paper-based form be set up to make sure that the person using it enters only the correct number of characters in a postcode? [2 marks]
5 How can the owner of an online form make sure that all the important data is entered into the form? [4 marks]
automated data capture
6. Explain how the data needed to control an air conditioning system is collected automatically by a
computer system.
7. Why would temperature and pH sensors be used to collect data from a leisure centre's swimming pool?
Practice these Exam-type questions
1 What is the purpose of a ‘password’? [1 mark]
2 How could a leisure centre use the data collected from the sensors in its swimming pool? [4 marks]
3 Give two reasons why RFID tags instead of bar codes are used to tag goods. [2 marks]
4 Why are QR codes useful for people who have smartphones? [3 marks]
5 What information is stored in a bar code? [2 marks]
6 Give two uses, other than tagging goods in a supermarket, for RFID tags. [2 marks]
computer system.
7. Why would temperature and pH sensors be used to collect data from a leisure centre's swimming pool?
Practice these Exam-type questions
1 What is the purpose of a ‘password’? [1 mark]
2 How could a leisure centre use the data collected from the sensors in its swimming pool? [4 marks]
3 Give two reasons why RFID tags instead of bar codes are used to tag goods. [2 marks]
4 Why are QR codes useful for people who have smartphones? [3 marks]
5 What information is stored in a bar code? [2 marks]
6 Give two uses, other than tagging goods in a supermarket, for RFID tags. [2 marks]
Coding data
Read pages 52 to 55
Practice these Exam-type questions
1 Why should the prices of using the facilities in a leisure centre not be stored as text? [1 mark]
2 Explain how a salesperson in an estate agent could make sure that the data he/she collected on a
data capture form of details of a
house for sale were accurately shown on the business website? [3 marks]
3 A leisure centre employs a large number of people who work different hours for different rates of pay.
All the details of their hours worked and pay rates have to be entered into the computer system each week
to make sure that they are paid the correct amount. How can the data be verified to make sure it is correctly
entered? [4 marks]
4 What is a check digit? [3 marks
5 For each of these examples of data, choose a suitable data type for storing it in a database:
a) 26 March 1969 [1 mark]
b) CB21 7WX [1 mark]
c) Boy or Girl [1 mark]
d) Your own name [1 mark]
e) 456 [1 mark]
6 Why would Male or Female be entered by a receptionist as M or F into a database? [1 mark]
Practice these Exam-type questions
1 Why should the prices of using the facilities in a leisure centre not be stored as text? [1 mark]
2 Explain how a salesperson in an estate agent could make sure that the data he/she collected on a
data capture form of details of a
house for sale were accurately shown on the business website? [3 marks]
3 A leisure centre employs a large number of people who work different hours for different rates of pay.
All the details of their hours worked and pay rates have to be entered into the computer system each week
to make sure that they are paid the correct amount. How can the data be verified to make sure it is correctly
entered? [4 marks]
4 What is a check digit? [3 marks
5 For each of these examples of data, choose a suitable data type for storing it in a database:
a) 26 March 1969 [1 mark]
b) CB21 7WX [1 mark]
c) Boy or Girl [1 mark]
d) Your own name [1 mark]
e) 456 [1 mark]
6 Why would Male or Female be entered by a receptionist as M or F into a database? [1 mark]