0417_s16_qp_13
A paper of Information and Communication Technology, 0417
Questions:
19
Year:
2016
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
8
A school library uses a computer system where there is a book file and a borrower file. Each student has a unique membership number and each book has a unique accession number. The accession number is the number given to a book when it is first bought by the library. When a book is borrowed, the student has their thumbprint read by a special input device. Describe the computer processing involved when a book is borrowed. Describe the computer processing involved when a book is returned. There is no need for the borrower to have their thumbprint read during this process. [Turn over 1 20
7. The systems life cycle  →  7.1. Analysis
8. Safety and security  →  8.3. Security of data
Open
10
A student exam answer sheet consists of boxes or lozenges which the student shades in to indicate their choice of answer. Apart from the details of the test and the lozenges, give two items of information, essential to the student, that are pre-printed on the answer sheet. Describe how Optical Mark Recognition is used to process the details from the form. Describe the drawbacks of using Optical Mark Recognition. [Turn over 1 20
6. ICT applications  →  6.10. Recognition systems
7. The systems life cycle  →  7.1. Analysis
Open
11
Enrique has developed a new database system for a supermarket. Below is one record from the database. He needs to test the validation checks that he has developed for the system. WeightReorder_level Price Contents Supplier_code Barcode 0.4 £2.72 Lobster Bisque EZ123 He designed a length check for the Barcode field. However, when he entered the code 5012472141308 by mistake, the system still accepted it. Describe the check he could have used to prevent this error. The Reorder_level for each item is never more than 100. He developed a validation check to make sure this is the case. However, when he entered the number 100 it was rejected. Name and describe the validation check he should use and explain why the number could have been rejected. 1 20 He also designed a length check for the Supplier_code field. However, when he entered EZQ23 by mistake, the system still accepted it. Describe how he could have prevented this error. For each field write down the most appropriate data type. For any numeric field specify the type of number. Barcode Supplier_code Contents Price Reorder_level Weight [Turn over 1 20
7. The systems life cycle  →  7.2. Design
15. Proofing  →  15.1. Software tools
Open
12
Here is a spreadsheet showing the countries which have been selected to host the Commonwealth Games. Canada England Australia New Zealand Canada Wales Australia Jamaica Scotland New Zealand Canada Australia Scotland New Zealand Canada Malaysia England Australia India Scotland Australia Canada England Australia New Zealand Wales Jamaica Scotland Malaysia India A B C D E South Africa South Africa Cells E5 to E14 contain the number of times each country has been selected to host the Commonwealth Games. Write down the formula which should go in cell E5 so that it can be replicated down to cell E14. Papua New Guinea are interested in bidding to host the 2026 Commonwealth Games. If they are successful the spreadsheet will need to be updated. Apart from those in column E, write down the cell references of those cells which will need to change. 1 20
20. Spreadsheets  →  20.1. Create a data model
Open