Cambridge A Level Information Technology (from 2017) 9626 — 2017 May/June Paper 1 · Variant 3

This document consists of 14 printed pages and 2 blank pages. DC (LK) 133330/4 © UCLES 2017 [Turn over Cambridge International Examinations Cambridge International Advanced Subsidiary and Advanced Level * 0 0 5 3 1 1 9 3 9 8 * INFORMATION TECHNOLOGY 9626/13 Paper 1 Theory May/June 2017 1 hour 45 minutes Candidates answer on the Question Paper. No Additional Materials are required. READ THESE INSTRUCTIONS FIRST Write your Centre number, candidate number and name on all the work you hand in. Write in dark blue or black pen. You may use an HB pencil for any diagrams, graphs or rough working. Do not use staples, paper clips, glue or correction fluid. DO NOT WRITE IN ANY BARCODES. Answer all questions. At the end of the examination, fasten all your work securely together. The number of marks is given in brackets [ ] at the end of each question or part question. Any businesses described in this paper are entirely fictitious.

2 9626/13/M/J/17 © UCLES 2017 1 Tick the four true statements referring to the use of data types when creating a database. 3 Boolean is a data type representing either of two states. Text fields cannot contain numbers. Numeric fields cannot contain text. Integer is a numeric data type used for storing decimal numbers. Date is a data type which can be used for storing images. The real number data type is used for fields containing whole numbers only. The numeric data type can be subdivided into different types of number. The alphanumeric data type can contain punctuation marks. The text data type is the easiest type of data to validate. Currency must be stored as text. [4] 2 Tick the four true statements relating to the use of normalisation when organising the attributes and tables of a relational database. 3 A table that has not got a unique key can still be in first normal form. Normalisation does not attempt to eliminate storing the same data in more than one table. Normalisation involves breaking down a table into less redundant, smaller tables. A table is in first normal form if it contains no repeating groups. A table is in second normal form if it is in first normal form and, additionally, does not have a composite primary key. A table in first normal form must use all the relationships, one-to-one, one-to-many and many-to-one. A database is in third normal form if it is in second normal form and each table has no non-key attributes that depend upon other non-key attributes. A third normal form table can still have non-key attributes dependent on other non-key attributes. Third normal form tables can still have non-key fields that do not depend on the primary key. Every table in a relational database must have a foreign key. [4]

3 9626/13/M/J/17 © UCLES 2017 [Turn over 3 A CD-ROM encyclopaedia is considered to be a static information source whereas a website encyclopaedia is considered to be a dynamic information source. Explain the differences between static and dynamic information sources. … … … … … … … … … … … … … …[6]

4 9626/13/M/J/17 © UCLES 2017 4 Sheila has just become manager of the ticketing department in an airport. She uses computers to accept payments and check passengers’ passports. (a) Evaluate the input devices which Sheila might use, including their specific use in this system. … … … … … … … … … … … … … … … … … … … …[8]

5 9626/13/M/J/17 © UCLES 2017 [Turn over (b) Sheila stores all the records of her transactions and lists of passengers from each flight on a hard disk. She is considering replacing her hard disk drive with a solid state drive (SSD). Evaluate the use of a hard disk drive compared with an SSD. … … … … … … … … … … … … … … … … … … … …[8]

6 9626/13/M/J/17 © UCLES 2017 5 Below is an extract from a spreadsheet showing the wages paid in one week to a group of workers. Any hours worked over 40 count as overtime. Overtime is paid at 1.5 times the normal rate. A B C D E F G H 1 2 Worker’s name Job type Hours worked this week Hours overtime worked Rate per hour paid Overtime earned this week Wage paid this week 3 4 Johan Braun Labourer 45 5 $13.00 $97.50 $617.50 5 Lisa Moran Skilled 40 $18.00 $720.00 6 Chi Li Labourer 40 $13.00 $520.00 7 Susan Armstrong Labourer 46 6 $13.00 $117.00 $637.00 8 Luqman Hisham Labourer 39 $13.00 $507.00 9 Kanda Demir Semi-skilled 40 $15.50 $620.00 10 Paul Strong Labourer 43 3 $13.00 $58.50 $578.50 11 Shoba Purushothaman Semi-skilled 48 8 $15.50 $186.00 $806.00 12 Kulap Kaya Semi-skilled 40 $15.50 $620.00 13 Tony Fernandes Skilled 40 $18.00 $720.00 14 Halim Saad Semi-skilled 51 11 $15.50 $255.75 $875.75 15 16 Workers working overtime 5 17 (a) Write down the formula which should be used in cell C16 in order to display the number of workers who worked overtime. = … …[4] You can use the space below for any working you need.

7 9626/13/M/J/17 © UCLES 2017 [Turn over (b) Write down the formula which should be used in cell D4 in order to display the number of Hours overtime worked for Johan Braun. The formula should be in a form that can be easily replicated and should leave the cell blank if no overtime has been worked. = … …[5] You can use the space below for any working you need. (c) Write down the formula which should be used in cell F4 in order to display the amount of money earned for working overtime for Johan Braun. The formula should be in a form that can be easily replicated and should leave the cell blank if no overtime has been worked. = … …[5] You can use the space below for any working you need.

8 9626/13/M/J/17 © UCLES 2017 6 In a recent BBC news bulletin it was reported: The BBC has obtained exclusive figures from the financial ombudsman that show there have been nearly 100 complaints about “vishing” in the past three months. Describe what is meant by: (i) phishing. … … … … … … …[3] (ii) vishing. … … … … … … …[3]

9 9626/13/M/J/17 © UCLES 2017 [Turn over 7 Many people use computers to access services provided by the internet. (a) Explain what is meant by the internet. … … … …[2] (b) Describe six of the services that are provided by the internet. 1. … … … 2. … … … 3. … … … 4. … … … 5. … … … 6. … … …[6]

10 9626/13/M/J/17 © UCLES 2017 8 A recording company has produced a video of one of its famous singers. The video has been given to John to edit so that it will have a fully professional look. The soundtrack has been sent separately to the video file. Describe how John would use the following features of video editing software. Trimming … … … … … Adding sound … … … … … Adding captions … … … … …[6]

11 9626/13/M/J/17 © UCLES 2017 [Turn over 9 Bruce works from home but is able to access company data using a virtual private network (VPN). Describe the benefits and drawbacks for Bruce of using a VPN. Benefits … … … … … … … … Drawbacks … … … … … … … …[6]

12 9626/13/M/J/17 © UCLES 2017 10 A school marks all its exams out of 100. It has recently introduced a system of positive marking for students in years 12 and 13 whereby students will be awarded 10 marks for just sitting the exam and then, as normal, will be awarded further marks for correct answers. After the papers have been marked, the school secretary will enter the marks into a student database together with the year the student is in and their date of birth, which must be entered in the form dd/mm/yyyy. It is acceptable for data to be omitted for certain students. Apart from type check or length check, describe four different validation checks which should be carried out on the data to help prevent mistakes occurring. 1. … … … … … 2. … … … … … 3. … … … … … 4. … … … … …[8]

13 9626/13/M/J/17 © UCLES 2017 [Turn over 11 A manager of a small business wants to update her computer system. When considering which software to use, she has to choose between custom written software and off-the-shelf software. Describe what is meant by these two types of software. (a) Custom written: … … … … … … …[3] (b) Off-the-shelf: … … … … … … …[3]

14 9626/13/M/J/17 © UCLES 2017 12 Below is part of a spreadsheet Deirdre has created to show her company’s profits. A B C D E F G 1 DIY Inc. 2 3 2012 2013 2014 2015 2016 4 5 1st quarter $135,000 $146,000 $158,000 $162,000 $154,000 6 2nd quarter $142,000 $149,000 $161,000 $167,000 $157,000 7 3rd quarter $138,000 $150,000 $159,000 $163,000 $151,000 8 4th quarter $129,000 $141,000 $146,000 $148,000 $147,000 9 10 Total profits $544,000 $586,000 $624,000 $640,000 $609,000 11 Describe, giving reasons, the most appropriate type of graph or chart for displaying: (i) the company’s profits, throughout 2016 showing comparisons of each quarter. … … … … … … … …[3] (ii) the company’s profits, showing the trend for all four quarters in each year from 2012 to 2016. … … … … … … … …[3]

15 9626/13/M/J/17 © UCLES 2017 BLANK PAGE

16 9626/13/M/J/17 © UCLES 2017 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 International Examinations Copyright Acknowledgements Booklet. This is produced for each series of examinations and is freely available to download at www.cie.org.uk after the live examination series. Cambridge International Examinations is part of the Cambridge Assessment Group. Cambridge Assessment is the brand name of University of Cambridge Local Examinations Syndicate (UCLES), which is itself a department of the University of Cambridge. BLANK PAGE

® IGCSE is a registered trademark. This document consists of 9 printed pages. © UCLES 2017 [Turn over Cambridge International Examinations Cambridge International Advanced Subsidiary and Advanced Level INFORMATION TECHNOLOGY 9626/13 Paper 1 Theory May/June 2017 MARK SCHEME Maximum Mark: 90 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 will not enter into discussions about these mark schemes. Cambridge is publishing the mark schemes for the May/June 2017 series for most Cambridge IGCSE®, Cambridge International A and AS Level and Cambridge Pre-U components, and some Cambridge O Level components.

9626/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 2 of 9 Question Answer Marks 1 Boolean is a data type representing one of two states. 3 Text fields cannot contain numbers. Numeric fields cannot contain text. 3 Integer is a numeric data type used for storing decimal numbers. Date is a data type which can be used for storing images. The real number data type is used for fields containing whole numbers only. The numeric data type can be sub divided into different types of number. 3 The alphanumeric data type can contain punctuation marks. 3 The text data type is the easiest type of data to validate. Currency must be stored as text. 4 Question Answer Marks 2 A table that has not got a unique key can still be in first normal form. Normalisation does not attempt to eliminate storing the same data in more than one table. Normalisation involves breaking down a table into less redundant, smaller tables. 3 There are no duplicate records in first normal form. 3 A table is in second normal form if it is in first normal form and, additionally, does not have a composite primary key. 3 A table in first normal form must use all the relationships, one to one, one to many and many to one. A database is in third normal form if it is in second normal form and each table has no non-key attributes that depend upon other non-key attributes. 3 Third Normal Form tables can still have non-key attributes depending on other non-key attributes. Third Normal Form tables can still have fields that do not depend on the primary key. Every table in a relational database must have a foreign key. 4

9626/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 3 of 9 Question Answer Marks 3 Six from: Static information sources are carefully checked for accuracy« «as once the data are used it is difficult to change There is a limited amount of information in a static information source« «as soon as it is created it is difficult to have information added to it A dynamic data source can have information updated quite quickly The data in a dynamic data source is usually up to date/static data tends to go out of date quickly There can be many contributors to a dynamic data source such as a web site« «so the information can be inaccurate. 6

9626/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 4 of 9 Question Answer Marks 4(a) This question to be marked as levels of response: Level 3 (7–8 marks) Candidates will explain both the advantages and disadvantages of different input devices using relevant and appropriate examples. The information will be relevant, clear, organised and presented in a structured and coherent format. There may be a reasoned conclusion/opinion. Specialist terms will be used correctly and appropriately. Level 2 (4–6 marks) Candidates will explain the advantages and disadvantages of input devices although development of some of the points will be limited to advantages or disadvantages, examples used will be for the most part relevant. For the most part, the information will be relevant and presented in a structured and coherent format. There may be a conclusion/opinion. Specialist terms will be used appropriately and for the most part correctly. Level 1 (1–3 marks) Candidates will only give advantages/disadvantages of input devices, examples, if used, may lack relevance. Answers may be in the form of a list. There will be little or no use of specialist terms. Level 0 (0 marks) Response with no valid content. Answers may include: The use of a keyboard to type in the amounts of money to be paid and recording details of the customers The advantage of keyboards is that experienced users can enter details more quickly than other methods Difficulty of entering amounts other than selecting numbers using a mouse Disadvantage is that data is slow to enter compared with DDE Touch screen could be used to enter amounts or customer details Quicker to enter data than using a mouse May cause screen to be stained and make viewing difficult RFID reader can be used to enter details from passport Quicker than manually entering data Readers are expensive to buy initially Uses chip reader to read credit/debit cards More reliable than reading magnetic stripe Quicker than typing in details from the card Contactless card readers speed up transactions as no PIN is required. 8

9626/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 5 of 9 Question Answer Marks 4(b) Evaluation based on: Advantages Hard disks tend to have higher storage capacities than SSDs Hard disk drives still cost less per gigabyte than SSDs HDDs last longer than SSDs « «the NAND flash used in SSDs can only be used for a finite number of writes The choice and availability of SSDs is still limited Disadvantages Hard Disk Drives are more susceptible to shock and damage« « as they consist of various moving parts SSDs have faster data transfer rate SSDs have quicker boot ups« «can have almost instantaneous data access« «HDDs data access speed is dependent on how close the data is to the read/write heads« «while all parts of the SSD can be accessed at once SSDs use significantly less power at peak load than hard drives« «SSD's energy efficiency can deliver longer battery life in laptops With no moving parts SSDs run at near silent operation« «unlike whirring hard disk drives. 8 Question Answer Marks 5(a) COUNTIF(C4:C14,">40") COUNTIF() 1 mark C4:C14, 1 mark >40 1 mark ,“” 1 mark 4 5(b) =IF(C4>40,C4-40,"") =IF() 1 mark C4 1 mark >40 1 mark ,C4-40 1 mark ,“” 1 mark 5 5(c) =IF(C4>40,D4*E4*1.5,"") =IF() 1 mark C4>40 1 mark ,D4*E4 1 mark *1.5 1 mark ,”” 1 mark 5

9626/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 6 of 9 Question Answer Marks 6(i) Phishing Three from: Involves using email to persuade people to divulge their personal information The email may include a website URL, inviting the receiver to go to the site« «looks just like the actual bank’s website but is a fake website The email may ask customer to reply with their bank details The email usually contains something that demands the target's immediate attention Examples include "We confirm that you have signed up to our service. You will be charged $2 a day unless you cancel your order on this URL: «” The website then asks them to enter their personal/financial information. 3 6(ii) Vishing Three from: Victim receives a phone call to persuade him to divulge his personal information Claims to be a representative of the bank and says« «that there has been some fraudulent activity on the customer’s account Often involves having the customer phone the bank Fraudster’s computer redirects phone call to own phone Gives customer their bank details to get their confidence Gets customer to log on to bank’s site and enter their details to transfer money to their new account which has been set up This account is actually the fraudster’s own bank account. 3

9626/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 7 of 9 Question Answer Marks 7(a) Two from: It is the global system of interconnected computer networks It uses the Internet protocol suite (TCP/IP) to link devices It is a network of networks linked by an array of electronic, wireless, and optical networking technologies. 2 7(b) Six from: Electronic Mail – email is a message that may contain text, files, images, or other attachments sent through a network to a specified individual or group of individuals World Wide Web – The World Wide Web is a system of Internet servers that support specially formatted HTML documents Video Conferencing Services – to conduct a conference between two or more participants at different sites by using computer networks to transmit audio and video data VoIP- Voice over Internet Protocol – the delivery of voice communications and multimedia sessions over Internet Protocol (IP) networks Instant messaging – to communicate via messages in real time over the internet Video streaming – video is sent to the viewer in real time File transfer – transmitting files over a computer network like the internet. 6

9626/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 8 of 9 Question Answer Marks 8 Two marks each from: Trimming – On the Timeline he would position the cursor over the in/start or out/end point When the trim handles appear drag the handle to trim the clip« «action the trim Adding sound – In the software he would open the video and audio files that he wants to merge Then drag the added files to the corresponding tracks on the timeline board The video file would be placed on the video track and the audio file on the audio track Adding captions – Once he has chosen the style he wants, right-click it and select where he wants to place it He would select start of the video track/add to the end of the video track/add to the title track Then double-click the title frame in the preview window and type or paste the text. 6 Question Answer Marks 9 Six from: Benefits Offer a much higher level of secure communication when compared to other remote methods of communication Every file coming into a computer or going out from a computer is encrypted« « meaning no unwanted user will be able to open the files Can be used to work automatically as part of logging on Drawbacks The company may not permit him to use other third party software on his computer in order to safeguard the integrity of their VPN connection The use of mobile devices to initiate access to the virtual private network can cause security issues« «if Bruce’s local wireless network is not secure Packet loss will be higher with the VPN and cause data to be lost and need to be retransmitted« «increasing the time taken to receive documents The connection depends on the ISP and so performance can be variable Will need to install extra anti- malware tools to ensure his PC is clean in order to comply with VPN suppliers’ requirements. Must have at least two of each to gain full marks. 6

9626/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 9 of 9 Question Answer Marks 10 Four matched pairs from: Range check for the exam mark No mark should be less than 10 or greater than 100 Lookup check for year Years should match 12 or 13 Format check for date of birth All dates of birth must be two digits followed by a slash followed by two digits followed by a slash followed by four digits Consistency check on year with date of birth The date of birth can be checked to see that the year the student is in corresponds to that. 8 Question Answer Marks 11(a) Three from: Software that is specially developed for a specific company/business It is made to accommodate that customer's particular preferences and needs Written by programmers to solve specific problems Owned by the business that commissions it. 3 11(b) Three from: Software that is ready-made and already exists It is available to all businesses and companies It is owned by the company that created it Has to be adapted to fit the business that has purchased it. 3 Question Answer Marks 12(i) Bar/column chart 1 mark The height of the bars represent the monetary value and the x axis is the category axis (the quarters) 1 mark Viewers can see comparisons by distinguishing the relative heights/lengths of the bars 1 mark 3 12(ii) Line chart 1 mark Points are plotted, monetary value against year and these are joined together by straight lines 1 mark Useful for emphasising the trend over time since they allow a viewer to trace it by working backwards or interpolating 1 mark 3