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

This document has 16 pages. Any blank pages are indicated. Cambridge IGCSE™(9–1) DC (PQ) 222479 © UCLES 2021 [Turn over * 0 1 0 1 6 0 3 7 7 2 * INFORMATION AND COMMUNICATION TECHNOLOGY 0983/11 Paper 1 Theory October/November 2021 2 hours 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 100. ● 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.

2 0983/11/O/N/21 © UCLES 2021 1 A computer consists of both hardware and software. (a) Define the term hardware. … … [1] (b) Give two examples of internal hardware devices. 1 … 2 … [2] (c) Define the term software. … … [1] (d) There are two types of software: system and applications. Give two examples of applications software. 1 … … 2 … … [2] 2 Circle two jobs where there has been a decrease in employment as a direct result of the introduction of computers. Bus drivers Car production Delivery drivers Fishermen workers for retail stores Payroll workers Programmers Teachers Website designers [2]

3 0983/11/O/N/21 © UCLES 2021 [Turn over 3 Describe two advantages of using a tablet computer rather than a laptop computer. 1 … … 2 … … [2] 4 Tick (3) whether the following advantages of analysing a system refer to looking at existing paperwork, observation or questionnaires. Looking at existing paperwork (3) Observation (3) Questionnaire (3) This method gives the systems analyst an overall view of the system Individuals can remain anonymous This method allows information to be collected that cannot be obtained from any other method This method gives the quickest analysis of the data [4]

4 0983/11/O/N/21 © UCLES 2021 5 Tawara Tours has created a new online booking system to allow customers to book holidays. The system was written using modules. (a) Describe how the new system could be tested prior to it becoming operational. … … … … … … … … … … … … [6]

5 0983/11/O/N/21 © UCLES 2021 [Turn over (b) Tawara Tours used to book holidays using a manual booking system. This used a pen and paper to make the bookings. Discuss the advantages and disadvantages of using online booking systems rather than a manual booking system. … … … … … … … … … … … … … … … … [8]

6 0983/11/O/N/21 © UCLES 2021 6 As a student you often use a computer screen. This could be a screen on a desktop computer, a laptop computer or even a smartphone. Evaluate your use of computer screens, in terms of health risks, and explain any strategies you use to minimise these health risks. … … … … … … … … … … … … [6] 7 Bluetooth is a method of communication to connect devices together. Describe how a smartphone can use Bluetooth to connect to another device. … … … … … … … … [4]

7 0983/11/O/N/21 © UCLES 2021 [Turn over 8 An organisation uses the internet and an intranet. (a) Explain how the purpose of the internet differs from the purpose of an intranet. … … … … … … … … [4] Employees in the organisation are allowed to access the intranet using their smartphones. The employees are required to secure their smartphones using either facial recognition, passwords or voice recognition. (b) Tick (3) whether the following statements refer to facial recognition, password or voice recognition. Facial recognition (3) Password (3) Voice recognition (3) This method cannot access the smartphone unintentionally The accuracy of this method can be affected by noise This method requires the use of the smartphone’s camera This method could be compromised by shoulder surfing [4]

8 0983/11/O/N/21 © UCLES 2021 9 Robots are used to spray paint cars in a car production company. (a) Describe two other jobs that robots can perform in car production. … … … … [2] (b) When the spray paint can is empty it needs to be refilled. There is a sensor in the can which measures the amount of paint. Describe the use of the sensor and microprocessor in this application. … … … … … … … … … … … … [6]

9 0983/11/O/N/21 © UCLES 2021 [Turn over (c) Discuss the advantages and disadvantages of the introduction of robots rather than employing humans to spray paint the cars. … … … … … … … … … … … … [6] 10 (a) Explain the differences between a VLOOKUP function and a LOOKUP function. … … … … … … [3]

10 0983/11/O/N/21 © UCLES 2021 (b) A spreadsheet contains a list of staff and the rooms they work in at a school. A 1 2 3 4 5 B C D E Room Department Name Julieta Diaz 30 History 28 29 26 31 49 Chemistry Ernesto Fernandez Aaron Garcia David James Adriene Martinez Salvador Calbo Languages ICT Mathematics Biology 31 =VLOOKUP(D2,A2:C7,3) 6 7 (i) Explain, in detail, what the formula in cell E2 does. … … … … … … [3] (ii) When certain room numbers are typed into cell D2 unexpected results appear in cell E2. Suggest improvements that could be made to ensure the correct result is displayed. … … … … [2]

11 0983/11/O/N/21 © UCLES 2021 [Turn over A teacher in the school has created a spreadsheet to display whether a student has good timekeeping when arriving at lessons. He has produced a formula but thinks it could be improved. The formula is: =IF(B4>=A$18,B$18,IF(B4>=A$17,B$17,IF(B4>=A$16,B$16,IF(B4>=A$15,B$15,IF(B4>=A$14,B$14,""))))) A 1 2 3 4 5 B C =IF(B4>=A$18,B$18,IF(B4>=A$17,B$17,IF(B4>=A$16,B$16,IF(B4>=A$15,B$15,IF(B4>=A$14,B$14,""))))) Half term Lates 1 Name of Student 2 3 4 17 1 12 20 18 0 6 7 8 9 10 11 12 13 14 15 16 17 18 19 5 6 0 1 5 15 25 Excellent Very Good Good Poor Very Poor (c) Write down the value that should appear in cell C4. … [1] (d) The teacher has improved the formula and has typed in =VLOOKUP(B4,A$14:B$18,2) Explain the advantages of using this formula compared to the original one. … … … … … … … … … … [4]

12 0983/11/O/N/21 © UCLES 2021 11 Many young people play online games. One problem with online gaming is that it is easy to give out personal details accidentally. Some users create weak passwords which could lead to their personal details being accessed. (a) Name two pieces of personal data that could be accessed. 1 … … 2 … … [2] (b) Write down three rules that should be applied when setting a strong password. … … … … … … [3] (c) Describe safety measures that should be taken by gamers to ensure their data is safe other than using strong passwords. … … … … … … … … … … … … [6]

13 0983/11/O/N/21 © UCLES 2021 [Turn over 12 The use of social networking is a part of modern living. (a) Define the term social networking. … … … … [2] (b) Describe the benefits of using social networking. … … … … … … … … … … … … [6]

14 0983/11/O/N/21 © UCLES 2021 13 A student is working on a project on the World Games. He has produced some information but has decided to produce a second layout including a table. The original layout and the new layout are shown. 2021 World Games This will be the 11th World Games, a major international multi-sport event, for sports, or disciplines within a sport, that were not contested in the Olympic Games. Dates: Thu, 15 Jul 2021 – Sun, 25 Jul 2021 Location: Legion Field, Birmingham, Alabama, United States Host city: Birmingham, Alabama, United States Opening ceremony: July 15 Closing ceremony: July 25 Main venue: The New Birmingham Stadium The original layout 2021 World Games This will be the 11th World Games, a major international multi-sport event, for sports, or disciplines within a sport, that were not contested in the Olympic Games. Dates Thu, 15 Jul 2021 – Sun, 25 Jul 2021 Location Legion Field, Birmingham, Alabama, United States Host city Birmingham, Alabama, United States Opening ceremony July 15 Closing ceremony July 25 Main venue The New Birmingham Stadium The new layout (a) Explain, step by step, how the table was created, without the text being entered by hand. … … … … … … … … [4]

15 0983/11/O/N/21 © UCLES 2021 (b) The student checks the text he has written using a spell checker. Explain how a spell checker works. … … … … [2] (c) Explain why the suggestions made by the spell checker do not always give the correct response. … … … … [2]

16 0983/11/O/N/21 © UCLES 2021 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 the Cambridge Assessment Group. Cambridge Assessment is the brand name of the University of Cambridge Local Examinations Syndicate (UCLES), which itself is a department of the University of Cambridge.

This document consists of 10 printed pages. © UCLES 2021 [Turn over Cambridge IGCSE™ (9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/11 Paper 1 Theory October/November 2021 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 2021 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 2021 © UCLES 2021 Page 2 of 10 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 2021 © UCLES 2021 Page 3 of 10 Question Answer Marks 1(a) The physical components of the computer 1 1(b) Two from: Processor Motherboard Video/graphic card Sound card 2 1(c) One from: Programs for controlling the operation of a computer Programs for processing of electronic data Program/data/applications 1 1(d) Two from for example: Word processing Spreadsheet Database Presentation 2 Question Answer Marks 2 Car production workers Payroll workers 2 Question Answer Marks 3 Two from: Tends to be a faster to load up the operating system They are more lightweight so can be carried anywhere//More portable Don’t generate as much heat Lower power consumption therefore batteries last longer 2

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2021 © UCLES 2021 Page 4 of 10 Question Answer Marks 4 Looking at existing paperwork Observation Questionnaire This method gives the systems analyst an overall view of the system  Individuals can remain anonymous  This method allows information to be collected that cannot be obtained from any other method  This method gives the quickest analysis of the data  4 Question Answer Marks 5(a) Six from: Each module is tested separately Modules are tested by the programmers Modules/system are tested with live data Errors and problems are noted Improvements are made to the module The module/system is retested Modules are combined and tested together System is tested as a whole System is tested to meet the user’s requirements 6

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2021 © UCLES 2021 Page 5 of 10 Question Answer Marks 5(b) Eight from: Advantages Prevents double booking The customer can see immediately when the holiday has been booked Bookings can be made 24/7 No need to travel to the booking office/queue up so saves time Can be booked from any location Saves cost of travelling to the booking office Tickets are usually sent online and therefore paperless//Saves printing and postal costs Usually cheaper as lower/fewer overheads Customers can more easily see the tours that are available Disadvantages Setting up is expensive//maintenance is expensive Internet access is needed to run the booking system therefore the cost may be increased More reliant on server/network Booking mistakes can be more easily made Mistakes are more difficult to rectify due to the speed of booking If the system crashes during the booking the booking may not be made To gain full marks there must be at least one advantage and one disadvantage 8 Question Answer Marks 6 Problem: Award a mark for each problem identified I avoid back and neck problems I avoid eye strain I avoid getting headaches I avoid epilepsy Strategies: Max four from: Make sure the top of the screen is at eye level Make sure that I adjust the tilting screen correctly Take regular breaks Do neck/back exercises Make sure I use blue lens spectacles Use a screen filter Use a matt/anti-glare screen Turn the screen away from the window Use a computer screen for a short time/take regular breaks Have my eyes tested regularly Improve the lighting in the room Sitting further away from the screen Keeping the screen clean Position the screen to reduce glare Use a non-flickering screen/LED/LCD Turn the brightness down on the screen 6

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2021 © UCLES 2021 Page 6 of 10 Question Answer Marks 7 Four from: Smartphone sends data to its Bluetooth connector Data is converted to radio waves The smartphone automatically detects nearby devices The smartphone pairs to the other device if in range The smartphone randomly chooses one of 79 possible channels If the channel is in use, it randomly chooses another The connection changes channels, every few seconds Sends the radio wave to the other device 4 Question Answer Marks 8(a) Four from: Internet is used to share and distribute information outside the organisation whereas the intranet within an organisation Internet is used to send and receive emails and messages outside the organisation whereas intranet sends and receives messages within an organisation The intranet meets the needs of the organisation whereas internet aims to meet the needs of everybody The internet facilitates collaboration with others whereas the intranet is only used to collaborate with other members within an organisation The internet is used to browse the World Wide Web 4 8(b) Facial recognition Password Voice Recognition This method cannot access the smartphone unintentionally  The accuracy of this method can be affected by noise  This method requires the use of the smartphone’s camera  This method could be compromised by shoulder surfing  4

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2021 © UCLES 2021 Page 7 of 10 Question Answer Marks 9(a) Two from, for example: Fit windscreens Fit the wheels Welding body panels Move cars from one place to another Fit engines 2 9(b) Six from: The depth of the paint is read by the sensor The depth of paint is sent from the sensor to the ADC/microprocessor The digital data from the ADC is read by the microprocessor The microprocessor compares this data to the minimum depth of the paint/preset value If the data is less than the minimum depth/preset value, the microprocessor sends a signal to the actuator If the data is more than the minimum depth/preset value microprocessor does nothing Process is continuous 6 9(c) Six from: Advantages They can work in areas where it would be harmful for humans They can work 24/7 Cheaper in the long run Higher productivity The finish is more consistent Disadvantages Expensive to purchase Skills can be lost Expensive to maintain/reprogram Expensive to start up//train staff to operate the robots To gain full marks there must be at least one advantage and one disadvantage 6

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2021 © UCLES 2021 Page 8 of 10 Question Answer Marks 10(a) Three from: LOOKUP allows for horizontal and vertical searching whereas VLOOKUP allows for vertical searching LOOKUP does not require an index value/only works on the second row/column whereas VLOOKUP requires an index value LOOKUP usually only works when the data is sorted VLOOKUP only returns data to the right of the searched column VLOOKUP user can select either an approximate or exact match to the lookup value 3 10(b)(i) Three from: The formula looks up the value in D2… …In the (range) A2 to A7 And returns the corresponding value In the 3rd column/Column C 3 10(b)(ii) Add FALSE/0 to the end of the formula – 1 mark Sort the range into ascending order of column A – 1 mark 2 10(c) Poor 1 10(d) Four from: Quicker to type in the formula Fewer mistakes when typing in the formula Easier to spot mistakes Easier to expand the range Takes up less storage space Easier to remember when retyping 4 Question Answer Marks 11(a) Two from for example: Email address Real names DOB Home address Contact phone number Membership card number Location data Internet Protocol (IP) address Picture of yourself Gender 2

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2021 © UCLES 2021 Page 9 of 10 Question Answer Marks 11(b) Two from: Password should not relate to personal details Should be a long password Not previously used password Should not include repeating/obvious patterns//predictable words Password should be strong 3 11(c) Six from: Use anti-spyware/up to date antivirus software Play the games with the firewall operational Play only with authorised versions of games which you have purchased from the correct sources and for which you have a licence Download/buy files and new software from reputable sources Do not forget to delete your account details when you are not playing again Keep the game software up to date. When disposing of your gaming device ensure all of your personal information has been deleted. Choose a username that does not reveal any personal information Be aware of criminals buying or selling ‘property’ that exists inside a computer game, in the real world 6 Question Answer Marks 12(a) Two from: Dedicated website/app/platforms It interacts with other users Can be used to find people with similar interests 2 12(b) Six from: Communicating with friends and colleagues all over the world Promotes collaboration and teamwork Instant communication Easy to find other people with common interests Allows the exchange of content or documents Allows people to share best practice/knowledge/skills It can help in community projects Gives up to date information Can give more confidence to some people who may be shy//develop social skills As it is seen by a lot of people helps advertising Easier for online buying and selling//market products Can be used more easily for analytics and market research It can promote talent quickly, musicians Make/socialise with new friends 6

0983/11 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED October/November 2021 © UCLES 2021 Page 10 of 10 Question Answer Marks 13(a) Four from: Load the document Highlight the text Click Insert then Table Select Convert text to table Click on 2 columns Click separate by : Click ok 4 13(b) Two from: Compares each typed word… …with its dictionary/database Uses algorithms to check the spelling 2 13(c) Two from: Real names are not recognised Badly spelt words will not be recognised Incorrect grammar may not be recognised It will not find words that sound the same but have been used incorrectly Some words may be spelt incorrectly but form another word They do not learn from their mistakes unless added to the dictionary They may use the wrong dictionary 2