0417_w23_qp_11
A paper of Information and Communication Technology, 0417
Questions:
12
Year:
2023
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
A newsagent has created a database with fields to store details of each newspaper and magazine he sells. Part of the database is shown. Publisher Frequency Selling_price Name_of_publication Product_number Trinity Press Daily $1.50 Wireless Times H W Brown Daily $1.50 The Daily Press Trinity Press Monthly $2.00 OME Tick (✓) the field name that would be the most appropriate primary key for the database. Product_number A Name_of_publication B Selling_price C Frequency D Publisher E The newsagent has added a field called Bar_code to store the bar code number of the product. Explain why a presence check is not a suitable validation check for the Bar_code field. The newsagent could use a relational database rather than a flat file database. Describe the advantages of using a relational database rather than a flat file database. 1 13 From the data shown in the part of the database, identify the most appropriate data type for the: Selling_price Name_of_publication
18. Databases  →  18.1. Create a database structure
7. The systems life cycle  →  7.2. Design
Open
3
A group of students are carrying out a study of the quality of river water for a project. They can either use a tablet computer or a smartphone to monitor and record their findings. Discuss the advantages and disadvantages of using a tablet computer rather than a smartphone for this project. Identify two devices that could be used by the students to enter data. 1 13
1. Types and components of computer systems  →  1.4. Types of computer
7. The systems life cycle  →  7.1. Analysis
6. ICT applications  →  6.3. Computer controlled systems
Open
4
A headteacher is considering setting up a card system for students to buy food in the school canteen. The headteacher is trying to decide whether to install a system that uses magnetic stripe card readers or one that uses chip and PIN card readers. Compare the use of magnetic stripe card readers with the use of chip and PIN card readers. Your answer must include similarities and differences.
6. ICT applications  →  6.9. Computers in the retail industry
6. ICT applications  →  6.6. Banking applications
8. Safety and security  →  8.3. Security of data
Open
6
A cricket club secretary saves a list of players as a PDF file. Describe two disadvantages of saving the list of players as a PDF file. 1 13 The cricket club has a junior team for 6−8-year-old players. The secretary has produced an ePublication to attract new members to the junior team. State two features of an ePublication that could not appear on a paper poster. Describe the features that could be used to make the ePublication attractive to a younger audience. [Turn over 1 13
10. Communication  →  10.2. Effective use of the internet
7. The systems life cycle  →  7.1. Analysis
6. ICT applications  →  6.1. Communication
Open
7
An employee in a company has used QWERTY123 as his login password for some time. Give three reasons why this is not advisable. Complete the sentences using the most appropriate data protection method from the list. Your answers must be different in each case. A dongle A digital certificate Biometrics Anti-spyware User ID Two-factor authentication A firewall Encryption A method which scrambles the data so that it cannot be understood is A fingerprint is an example of A method of guaranteeing a website is authentic is A hardware device that filters the information coming through the Internet connection into a LAN is 1 13 An employee in the company uses his company password for other accounts. Explain why this is not a good idea.
8. Safety and security  →  8.3. Security of data
Open
9
Rowena’s laptop computer contains a small capacity Solid State Drive (SSD) of 32Gb and a large capacity Hard Disk Drive (HDD) of 1024Gb. State, giving a reason for your choice, a use for the SSD and a use for the HDD in the laptop computer. Your answers must be different in each case. SSD HDD The laptop computer also contains internal memory. Give two examples of internal memory. 1 13
1. Types and components of computer systems  →  1.2. The main components of computer systems
3. Storage devices and media  →  3.1. Storage devices
1. Types and components of computer systems  →  1.1. Hardware and software
Open
10
A teacher has set up a database for a class library. The data about the books in the class library will be entered by the teacher. The data can be verified by double data entry or visual verification. Compare double data entry with visual verification. Your answer must include similarities and differences. When data is entered into a date field it is validated. An example of the data that could be entered is 01/04/2023 State two validation checks that could be used on this data. [Turn over 1 13
15. Proofing  →  15.2. Proofing techniques
Open
12
A student has produced some work for a school project. A page of the work is shown. The Problem A Study of the English Wallaby Wild wallabies (Macropus rufogriseus) con nue to be reported across the whole of England. Despite the harsh winter condi ons, these animals have flourished in recent years. Many people have contacted the police with reported sigh ngs in gardens, quiet country lanes and even alongside busy motorways. The original colony, thought to be the source of the English wallaby, was first reported in Derbyshire in England. These animals were believed to have been released in the 1940s from a private zoo. It is more likely that other private zoos and escapees from wallaby farms are to blame. The Zoological Society of London keeps up-to-date records of private collec ons of wallabies in England, and to date there are over 100 such collec ons. Many people ask why it ma!ers if these animals have escaped, as they are not dangerous. The problem is that the introduc on of invasive, non- na ve species can have substan al impacts on na ve species, and wallabies are no excep on. The student has placed a column break in his document. Explain the purpose of setting a column break. 1 13 After running a spell check and proofreading his document the student notices that one word is still showing an error. Explain why this word has caused an error and how the student could ensure that the error does not reappear when this word is used in future. 1 13
15. Proofing  →  15.2. Proofing techniques
10. Communication  →  10.2. Effective use of the internet
Open