Cambridge IGCSE Information and Communication Technology (9-1) 0983 — 2023 Oct/Nov Paper 1 · Variant 1

Cambridge IGCSE™(9-1) 0983/11 October/November 2023 1 hour 30 minutes INFORMATION AND COMMUNICATION TECHNOLOGY Paper 1 Theory You must answer on the question paper. No additional materials are needed. INSTRUCTIONS • Answer all questions. • Use a black or dark blue pen. • Write your name, centre number and candidate number in the boxes at the top of the page. • Write your answer to each question in the space provided. • Do not use an erasable pen or correction fluid. • Do not write on any bar codes. • You may use an HB pencil for any diagrams, graphs or rough working. INFORMATION • The total mark for this paper is 80. • The number of marks for each question or part question is shown in brackets [ ]. • No marks will be awarded for using brand names of software packages or hardware. This document has 16 pages. Any blank pages are indicated. [Turn over 11_0983_11_2023_1.1 © UCLES 2023 *2230966214*

A newsagent has created a database with fields to store details of each newspaper and magazine he sells. Part of the database is shown. 1 Publisher Frequency Selling_price Name_of_publication Product_number Trinity Press Daily $1.50 Wireless Times 1001 H W Brown Daily $1.50 The Daily Press 1015 Trinity Press Monthly $2.00 OME 1034 Tick (✓) the field name that would be the most appropriate primary key for the database. (a) Product_number A Name_of_publication B Selling_price C Frequency D Publisher E [1] 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. (b) … … [1] 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. (c) … … … … … … … … [4] 11_0983_11_2023_1.1 © UCLES 2023 2

From the data shown in the part of the database, identify the most appropriate data type for the: (d) Selling_price (i) … [1] Name_of_publication (ii) … [1] State the most appropriate word or phrase to complete each sentence. 2 The type of data output from a sensor is (a) … [1] The type of data read by a microprocessor is (b) … [1] The item of hardware that converts data from a sensor so a microprocessor can read it is (c) … [1] The type of sensor that is used in a refrigerator is (d) … [1] [Turn over 11_0983_11_2023_1.1 © UCLES 2023 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. 3 Discuss the advantages and disadvantages of using a tablet computer rather than a smartphone for this project. (a) … … … … … … … … … … … … [6] Identify two devices that could be used by the students to enter data. (b) 1 … 2 … [2] 11_0983_11_2023_1.1 © UCLES 2023 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. 4 … … … … … … … … … … … … [6] A bridge and a router are examples of networking devices. 5 Explain the differences between a bridge and a router. (a) … … … … [2] [Turn over 11_0983_11_2023_1.1 © UCLES 2023 5

IP addresses are used in computer networks. Explain what is meant by an IP address. (b) … … … … … … … … [4] Explain the purpose of a routing table. (c) … … … … [2] A cricket club secretary saves a list of players as a PDF file. 6 Describe two disadvantages of saving the list of players as a PDF file. (a) … … … … [2] 11_0983_11_2023_1.1 © UCLES 2023 6

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. (b) 1 … 2 … [2] Describe the features that could be used to make the ePublication attractive to a younger audience. (c) … … … … … … … … … … … … [6] [Turn over 11_0983_11_2023_1.1 © UCLES 2023 7

An employee in a company has used QWERTY123 as his login password for some time. 7 Give three reasons why this is not advisable. (a) 1 … … 2 … … 3 … … [3] Complete the sentences using the most appropriate data protection method from the list. Your answers must be different in each case. (b) 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 (i) … [1] A fingerprint is an example of (ii) … [1] A method of guaranteeing a website is authentic is (iii) … [1] A hardware device that filters the information coming through the Internet connection into a LAN is (iv) … [1] 11_0983_11_2023_1.1 © UCLES 2023 8

An employee in the company uses his company password for other accounts. Explain why this is not a good idea. (c) … … [1] Microprocessor-controlled devices are used in the home. Describe, with examples, how using these devices can affect the health and fitness of their users. 8 … … … … … … … … … … … … [6] [Turn over 11_0983_11_2023_1.1 © UCLES 2023 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. 9 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. (a) SSD (i) … … … … [2] HDD (ii) … … … … [2] The laptop computer also contains internal memory. Give two examples of internal memory. (b) 1 … 2 … [2] 11_0983_11_2023_1.1 © UCLES 2023 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. 10 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. (a) … … … … … … … … [4] 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. (b) 1 … 2 … [2] [Turn over 11_0983_11_2023_1.1 © UCLES 2023 11

Many Automatic Teller Machines (ATM) allow customers to print out mini statements of their bank accounts. Describe the inputs and processing involved in printing out a mini statement. 11 … … … … … … … … … … … … [6] 11_0983_11_2023_1.1 © UCLES 2023 12

BLANK PAGE PLEASE TURN OVER. [Turn over 11_0983_11_2023_1.1 © UCLES 2023 13

A student has produced some work for a school project. A page of the work is shown. 12 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. Fig. 12.1 The student has placed a column break in his document. Explain the purpose of setting a column break. (a) … … … … [2] 11_0983_11_2023_1.1 © UCLES 2023 14

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. (b) … … … … [2] 11_0983_11_2023_1.1 © UCLES 2023 15

BLANK PAGE Permission to reproduce items where third-party owned material protected by copyright is included has been sought and cleared where possible. Every reasonable effort has been made by the publisher (UCLES) to trace copyright holders, but if any items requiring clearance have unwittingly been included, the publisher will be pleased to make amends at the earliest possible opportunity. To avoid the issue of disclosure of answer-related information to candidates, all copyright acknowledgements are reproduced online in the Cambridge Assessment International Education Copyright Acknowledgements Booklet. This is produced for each series of examinations and is freely available to download at www.cambridgeinternational.org after the live examination series. Cambridge Assessment International Education is part of Cambridge Assessment. Cambridge Assessment is the brand name of the University of Cambridge Local Examinations Syndicate (UCLES), which is a department of the University of Cambridge. 11_0983_11_2023_1.1 © UCLES 2023 16

This document consists of 8 printed pages. © UCLES 2023 [Turn over Cambridge IGCSE™ (9–1) INFORMATION & COMMUNICATION TECHNOLOGY 0983/11 Paper 1 Theory October/November 2023 MARK SCHEME Maximum Mark: 100 Published This mark scheme is published as an aid to teachers and candidates, to indicate the requirements of the examination. It shows the basis on which Examiners were instructed to award marks. It does not indicate the details of the discussions that took place at an Examiners’ meeting before marking began, which would have considered the acceptability of alternative answers. Mark schemes should be read in conjunction with the question paper and the Principal Examiner Report for Teachers. Cambridge International will not enter into discussions about these mark schemes. Cambridge International is publishing the mark schemes for the October/November 2023 series for most Cambridge IGCSE, Cambridge International A and AS Level components, and some Cambridge O Level components.

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2023 © UCLES 2023 Page 2 of 8 Generic Marking Principles These general marking principles must be applied by all examiners when marking candidate answers. They should be applied alongside the specific content of the mark scheme or generic level descriptors for a question. Each question paper and mark scheme will also comply with these marking principles. GENERIC MARKING PRINCIPLE 1: Marks must be awarded in line with: • the specific content of the mark scheme or the generic level descriptors for the question • the specific skills defined in the mark scheme or in the generic level descriptors for the question • the standard of response required by a candidate as exemplified by the standardisation scripts. GENERIC MARKING PRINCIPLE 2: Marks awarded are always whole marks (not half marks, or other fractions). GENERIC MARKING PRINCIPLE 3: Marks must be awarded positively: • marks are awarded for correct/valid answers, as defined in the mark scheme. However, credit is given for valid answers which go beyond the scope of the syllabus and mark scheme, referring to your Team Leader as appropriate • marks are awarded when candidates clearly demonstrate what they know and can do • marks are not deducted for errors • marks are not deducted for omissions • answers should only be judged on the quality of spelling, punctuation and grammar when these features are specifically assessed by the question as indicated by the mark scheme. The meaning, however, should be unambiguous. GENERIC MARKING PRINCIPLE 4: Rules must be applied consistently, e.g. in situations where candidates have not followed instructions or in the application of generic level descriptors. GENERIC MARKING PRINCIPLE 5: Marks should be awarded using the full range of marks defined in the mark scheme for the question (however; the use of the full mark range may be limited according to the quality of the candidate responses seen). GENERIC MARKING PRINCIPLE 6: Marks awarded are based solely on the requirements as defined in the mark scheme. Marks should not be awarded with grade thresholds or grade descriptors in mind.

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2023 © UCLES 2023 Page 3 of 8 Question Answer Marks 1(a) Product_number 1 1(b) Not every publication has a bar code 1 1(c) Four from: Uses data integrity which means no discrepancies in the data Less memory used in the computer Data is not unnecessarily duplicated Queries can be created using many tables//Complex queries can be created Reports can be created using many tables//Complex reports can be created Only have to input the data once into a relational database therefore it saves time 4 1(d)(i) One from: Numeric: currency 1 1(d)(ii) Text/string/alphanumeric 1 Question Answer Marks 2(a) Analogue 1 2(b) Digital 1 2(c) Analogue to digital convertor/ADC 1 2(d) Temperature (sensor) 1 Question Answer Marks 3(a) Six from: Advantages Easier to connect devices onto a tablet Larger screen to see the findings Larger onscreen keyboard to enter the data Better software suited to the task Disadvantages Smartphones are more portable and can be carried in a pocket Students are more likely to have smartphones with them If cameras are to be used then it is easier to use a camera with a smartphone To gain full marks the discussion must both advantages and disadvantages 6 3(b) Two from: Keyboard Camera Touch screen Microphone Sensor 2

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2023 © UCLES 2023 Page 4 of 8 Question Answer Marks 4 Six from: Similarity Both readers are in direct contact with the card Both readers can cause wear and tear on the cards Both are input devices Difference Chip and PIN readers the user needs to know the PIN The chip and PIN reader is susceptible to shoulder surfing Chip and PIN reader prompts the user to enter a PIN It is more secure as a PIN is needed In the magnetic stripe reader the card can be used by anyone as no PIN is needed The transaction is faster using a magnetic stripe reader Less data entry errors using a magnetic stripe reader as no manual input To gain full marks the comparison must have both similarities and differences 6 Question Answer Marks 5(a) Two from: A bridge connects two LANs that use the same protocol A bridge creates a single LAN from separate parts A router allows data packets to be sent to LAN/WAN A router connects a LAN to a WAN 2 5(b) Four from: Internet Protocol address Unique identifier IP addresses must be different for each device on a network All devices connected to the internet use IP addresses Determines the electronic location of the device 4 5(c) Two from: Used to determine where data packets will be directed Stores route information Stores IP addresses 2

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2023 © UCLES 2023 Page 5 of 8 Question Answer Marks 6(a) Two from: Mark the first two answers only More difficult to edit the PDF PDF sometimes render incorrectly Need PDF editor software to edit//Need PDF viewer 2 6(b) Two from: Audio Interactivity Ability to change to different languages Ability to change text flow left-to-right and right-to-left Text to speech Accessibility Video Animation Turning pages automatically 2 6(c) Six from: To interest/attract the younger audience the ePublication should use: Bright colours Animations Videos Sounds//sound effects Cartoons There should be more pictures than text The wording should be simple//Short sentences could be used Large text fonts so that it is easier to read Use of white space to break up the text and make it easier to read Games/activities for content can be used If a list of points is given with no reasons then max 5 marks 6 Question Answer Marks 7(a) Three from: Password is not strong It is easy to guess The letters and numbers are in sequence on the keyboard Easy to shoulder surf It should be changed regularly to secure his login 3 7(b)(i) Encryption 1 7(b)(ii) Biometrics 1 7(b)(iii) Digital certificate 1 7(b)(iv) Firewall 1

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2023 © UCLES 2023 Page 6 of 8 Question Answer Marks 7(c) One from: If someone finds the password for one of the systems/accounts other systems/accounts are compromised If someone finds the password for one of the systems/accounts then he has gained the company password 1 Question Answer Marks 8 Six from: This question is a cause and effect question Reduces the amount of time it takes to complete a task… (1st) …therefore gives the user more leisure time/time to do other things (2nd) The user does not need to be present when the device is working…(1st) …therefore gives the user more/less exercise (2nd) Allows the user to use interactive games devices…(1st) …therefore helps improves their fitness (2nd) When the device does all the work…(1st) …it makes the user lazy (2nd) Users are not doing as much manual work…(1st) ...this can cause [a valid named health issue] (2nd) Using computers/gaming machines/devices for long periods…(1st) ...this can cause [a valid named health issue] (2nd) If the candidate does not give two named devices with effects then max five marks 6 Question Answer Marks 9(a)(i) This is a use and reason question To store the operating system/games One from: Faster loading of the operating system/games The game/OS runs faster 2 9(a)(ii) This is a use and reason question To store the apps/software/data/files/movies One from: Can store more files Can store larger files 2

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2023 © UCLES 2023 Page 7 of 8 Question Answer Marks 9(b) RAM ROM 2 Question Answer Marks 10(a) Four from: Similarities Both are used to check that data has been entered correctly Both ensure that the data has been transferred correctly Both are used to check the data against the original data Differences In visual verification the user compares the data Data is compared with the original data source In double data entry the computer compares the data In double data entry the data is compared with the previously entered data In double data entry data is entered twice by the user(s) In order to gain full marks the comparison must both similarities and differences 4 10(b) Two from: Format (check) Length (check) Range (check) Type/character (check) 2

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2023 © UCLES 2023 Page 8 of 8 Question Answer Marks 11 Six from: Inputs Insert card System reads the details on the card Select the language you would like to use Enter PIN Select print (mini statement) option Select Account Select ‘confirm’ Processing Checks the card is correct/valid Checks the account number is correct Check the PIN is correct If incorrect three times then card is retained Checks the correct account selected Sends a signal to/communicates with the bank Bank computer creates the statement Details of the amount in the account are sent to ATM Details are sent to the printer To gain full marks the description must have at least two answers for inputs and at least two answers for processing 6 Question Answer Marks 12(a) Two from: Places a hard break in the location selected Could remove widows/orphans 2 12(b) One from: The word does not appear in the dictionary The word is written in Latin and the dictionary is in English. One from: Add the word to the dictionary Set the dictionary to allow scientific names/Latin Set (the dictionary) to ignore the word 2