ACADEMIC SESSION 2024-2025
Name: Subject: ICT
Year: 8 Topic: Revision
Unit 8.5: Data input: Data collection and Validation
1. Write definitions for the following keywords.
2. Why is correct data so important when creating a data model?
Ans: If the data entered into a model is incorrect, the result of processing that data will
also be incorrect.
3. Why is it important to ensure that all factors are included when you are creating a data
model?
Ans: To ensure that the model is complete and that all factors are taken into account
during processing.
4. Explain why it is important to break data down into the smallest level possible when
creating a data model.
Ans: To make processing the data easier.
5. Why is it important to remove unnecessary data from a data model?
1
Ans: Lots of additional data will make the model large and it will take longer to process.
6. A librarian has designed the following database to record details about members. Use
what you have learned about getting the data structure right to restructure the
database for the librarian by completing the data dictionary below.
Think carefully about any additional fields you may need to add to your database. Also
consider any field headings that may benefit from being broken down further.
Consider the suitability of recording member age as a data item. Member age will
change each year and will need to be updated. What data item could you replace this
with?
Use your data dictionary to answer the following questions.
(i) Identify one entity in your new database.
(Any field heading)
(ii) Did you include any new fields in your data dictionary?
(a) Identify a new field you added.
Ans: memberID
(b) Give a reason why you included this new field.
2
Ans: In case more than one member had the same name.
(iii) Did you rename any of the fields in your data dictionary? If so, explain why you
thought this was necessary.
Ans: For example: Renamed Age to DOB.
(iv) Did you break down any of the data items in the librarian’s design into smaller
data items?
(a) Give one example of where you did this.
Ans: For example: MemberName into FirstName and SecondName.
(b) Explain why you made this decision.
Ans: It makes it is easier to search the database if data is broken down into
smallest units.
7. Examine the database example below.
(i) Identify a suitable validation check for the following fields.
3
(a) Quantity-- Range check
(b) StudentNumber-- Length check
Presence check or type check could also be applied to both.
(ii) Name two additional validation checks that you can apply to data in a database.
Ans: Format check (students may mention any of the other checks listed above that
were not included in their original answer).
(iii) Why is correct data so important in a computer program?
Ans: Incorrect data leads to incorrect results of processing.
(iv) What does the term clean data mean?
Ans: Data that has been well validated.
(v) What does the term invalid data mean?
Ans: Data that does not match validation rules.
8. In the table below, record the key differences between a data model and a simulation.
9. Explain how the following form elements are used when designing a data-capture form.
4
10. What type of data could be collected using a dropdown box?
Ans: Data from a lookup list
11. Explain your answer.
Ans: The data is available for the user to select from and there is no chance of them
making an error when typing the data into the database.
12. Why are good instructions in a data-capture form so important to the user?
Ans: They help the user to understand how to complete the form correctly.
13. List the characteristics of a well-designed data-capture form.
- It should present the user with easy-to-understand labels that help them to
understand what data needs to be entered into each section of the form.
- It should include atomic field headings to ensure that all the necessary data is
collected.
- It should include easy-to-understand field headings for all the data collected.
- It should provide examples and hints to help the user to complete the form and
reduce the chance of them making mistakes.
- It should provide options for the user to select from, where possible.
- It should provide the user with correctly sized text boxes to help them to
understand how much detail they are expected to provide for each field.
14.Why do some forms include a section labelled ‘Office Use Only’?
5
Ans: This may represent an area that the user is not meant to complete or where data
is added automatically, for example using autonumber.
15. Complete the table below with a definition of each keyword listed.
16. Describe the role that each of the validation checks plays.
6
17. Choose which data type matches each of the variables listed on the left.
18. Select the correct words to complete the text.
Libraries are used in Python to provide _more_ functionality to your code. Importing a
library into your program often means you can complete tasks using _less_ code.
Programmers can create their _own_ libraries, which makes it _easier_ to complete
different tasks. A popular library is the _random_ library; this has functions that allow you
to _generate_ random numbers. It is good practice to import any libraries at the _top_ of
your code.
