Cambridge A Level Applied Information and Communication Technology 9713 — 2016 May/June Paper 1 · Variant 2

This document consists of 17 printed pages and 3 blank pages. DC (SG/FD) 126927 © UCLES 2016 [Turn over Cambridge International Examinations Cambridge International Advanced Subsidiary and Advanced Level * 6 2 4 1 0 6 7 5 4 5 * APPLIED INFORMATION AND COMMUNICATION TECHNOLOGY 9713/12 Paper 1 May/June 2016 1 hour 15 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 blue or black pen. Do not use staples, paper clips, glue or correction fluid. You may use an HB pencil for any diagrams, graphs or rough working. DO NOT WRITE IN ANY BARCODES. Answer all questions. The number of marks is given in brackets [ ] at the end of each question or part question. The businesses described in this paper are entirely fictitious.

2 9713/12/M/J/16 © UCLES 2016 Scenario 1 Questions 1 and 2 Mytoy is a manufacturing company that specialises in making toys for young children. Mytoy has a number of sales personnel who take orders for toys from shops which they visit. Each sales person uses a laptop computer which is loaded with word processing software. When a sales person takes an order from a shop, a large amount of sensitive information such as details of the shop’s bank account is collected. The sales personnel have social and ethical responsibilities when collecting this information. Mytoy have decided to expand its business by selling direct to the public. Members of the public will be able to telephone their orders to Mytoy’s large call centre. Customers will have the option to leave a telephone message stating their requirements. Mytoy may ring back or send an email message if that would be more appropriate.

3 9713/12/M/J/16 © UCLES 2016 [Turn over 1 (a) Describe each of the following portable devices which a sales person could use and for each one give a different use to which it could be put. Mobile phone: … … … … … … DVD player: … … … … … … Satellite navigation system: … … … … … … [6]

4 9713/12/M/J/16 © UCLES 2016 (b) Describe three social or ethical implications that the sales personnel should be aware of when collecting information from the shops. 1 … … … … … … 2 … … … … … … 3 … … … … … … [6]

5 9713/12/M/J/16 © UCLES 2016 [Turn over (c) Apart from a word processor, give three other types of application software which you would expect to be loaded onto each laptop, describing two uses of each. Each use must be different. 1 … … … … … … 2 … … … … … … 3 … … … … … … [6]

6 9713/12/M/J/16 © UCLES 2016 2 (a) The call centre system for dealing with customer calls uses third party control with CTI software on its telephony server. Describe this system and how it would deal with customer calls. … … … … … … … … … … … … … … [6] (b) (i) Explain why a customer needs to take care before opening an email. … … … … … … … [3]

7 9713/12/M/J/16 © UCLES 2016 [Turn over (ii) Describe how the customer may be able to tell if there is a potential problem with the email. … … … … … … … [3]

8 9713/12/M/J/16 © UCLES 2016 Scenario 2 Question 3 Townbank is a community bank. For many years, the bank has been very successful, but it has recently been losing customers to banks that offer online banking. Townbank decide to employ Hardeep, a systems analyst, to oversee the introduction of a new system to their business.

9 9713/12/M/J/16 © UCLES 2016 [Turn over 3 (a) Hardeep uses the following methods of data collection to research the present situation. Describe a benefit and a drawback of each method for finding out information in this scenario. (i) Observation: Benefit: … … … Drawback: … … … [2] (ii) Questionnaires: Benefit: … … … Drawback: … … … [2] (iii) Interviews: Benefit: … … … Drawback: … … … [2]

10 9713/12/M/J/16 © UCLES 2016 (b) Hardeep produces the following system flowchart to describe one of the processes. Cheque Deduct amount from customer account Add amount to recipient account Store transaction on customer file Statement Describe the uses of the different symbols and explain the process that is represented. … … … … … … … … … … … … … … [6]

11 9713/12/M/J/16 © UCLES 2016 [Turn over (c) Describe how the introduction of online banking: (i) could affect the working patterns of the bank staff. … … … … … … … [3] (ii) could inconvenience customers. … … … … … … … [3]

12 9713/12/M/J/16 © UCLES 2016 Scenario 3 Questions 4 and 5 Webuild is a building company which specialises in building blocks of apartments for people to live in. Each apartment has a computer-controlled central heating system installed. Workers are paid weekly. Webuild’s financial department uses a batch processing system to produce the payroll each week. Webuild keeps stocks of various building materials in its warehouse. It is Cenko’s job to ensure that Webuild do not run out of materials. To help her in this task she uses a database. The database contains a number of files, one of which is the ITEM file and another is the SUPPLIER file. The NumberInStock of any item varies from 50 to 500. The Price of any item varies from $20 to $1000. The MinimumStock of any item varies from 20 to 100.

13 9713/12/M/J/16 © UCLES 2016 [Turn over 4 (a) Explain how the temperature in an apartment is controlled by the computer-controlled central heating system. … … … … … … … … … … … … … … [6] (b) (i) Explain why the finance department use a set of sequential files rather than random access files to produce the payroll. … … … … … … … … … [4]

14 9713/12/M/J/16 © UCLES 2016 (ii) Describe two problems that may arise because of the use of sequential access files. 1 … … … 2 … … … [2] 5 The ITEM file contains the following fields: Field Name Data Type Example data ItemName Boiler NumberInStock 236 Price $499.95 ItemLocation 06:71:03 MinimumStock 100 The SUPPLIER file contains the following fields: Field Name Data Type SupplierName SupplierAddress SupplierEmail DiscountOnPrice OrderPlaced (a) Complete both tables with the most appropriate data types for each field. For each numeric field, specify the numeric type. [5]

15 9713/12/M/J/16 © UCLES 2016 [Turn over (b) In order for the database to work as a relational database at least one more field needs to be added. Describe this field and explain why this is necessary. … … … … … … … … … [4] (c) State and describe appropriate validation checks that would be carried out on the ITEM file data as it is entered. You can describe different validation checks for the same field. … … … … … … … … … … … … [5]

16 9713/12/M/J/16 © UCLES 2016 Scenario 4 Question 6 The government department responsible for education in a particular country is called Edmin. A group of college teachers has been commissioned by Edmin to produce a detailed report on the teaching of ICT in colleges. The secretary of the group has been asked to type the first draft of the report. The report is to be circulated electronically to members of the group.

17 9713/12/M/J/16 © UCLES 2016 6 Explain how the secretary can allow other members of the group to add comments to the first draft of the report while maintaining control over the final content. … … … … … … … … … … … … … … [6]

18 9713/12/M/J/16 © UCLES 2016 BLANK PAGE

19 9713/12/M/J/16 © UCLES 2016 BLANK PAGE

20 9713/12/M/J/16 © UCLES 2016 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 the registered trademark of Cambridge International Examinations. This document consists of 8 printed pages. © UCLES 2016 [Turn over Cambridge International Examinations Cambridge International Advanced Subsidiary and Advanced Level APPLIED INFORMATION & COMMUNICATION TECHNOLOGY 9713/12 Paper 1 Written A May/June 2016 MARK SCHEME Maximum Mark: 80 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 2016 series for most Cambridge IGCSE®, Cambridge International A and AS Level components and some Cambridge O Level components.

Page 2 Mark Scheme Syllabus Paper Cambridge International AS/A Level – May/June 2016 9713 12 © Cambridge International Examinations 2016 1 (a) [6] Mobile phone: A phone that can make/receive calls/messages while the user is on the move To stay in contact with head office/shops/ to store his appointments/store phone numbers of shops/colleagues/to phone shop if going to be late for an appointment DVD player: A battery powered device that replays DVDs For watching videos about new products/to show videos of toys to shops/to study training videos Satellite navigation system: A system that pinpoints a user's position/finds the quickest way to a location To direct salesperson to customer shops/ to allow salesperson to miss traffic holdups so that appointments are met/to pinpoint the location of a shop 2 marks available for each (b) Three matched pairs from: [6] Two from: Salesperson should have a duty of confidence Salesperson should sign a confidentiality agreement Must keep the details of orders confidential Must not share data collected with any other person or organisation Must treat the information as confidential/it must be obvious to them that the information is given in confidence Two from: Salesperson should have a duty of fidelity Must be loyal to Mytoy… …for as long as they are employed Must not give information (about new toys/customers) to a rival company Employee is free to use skills and knowledge acquired from company after they leave them Two from: MyToy should anonymise information wherever possible MyToy should aggregate information wherever possible Limited amount of information should be collected/transmitted Two from: MyToy and its employees must abide by the Data Protection Act Any 2 examples of a DPA principle

Page 3 Mark Scheme Syllabus Paper Cambridge International AS/A Level – May/June 2016 9713 12 © Cambridge International Examinations 2016 (c) Three pairs of answers from: [6] Database Two from: Used to store customer/toy shop data Used to store customer orders Salesperson can prepare for visit with knowledge of customer details Sales/orders can be added to/edited during the course of a visit Customer details can be added to/edited during the course of the visit Charts produced showing sales per shop Spreadsheet Two from: When an order is taken the salesperson will use the spreadsheet to calculate the cost of the order Can be used to provide an invoice for the customer Can be used to show trends of customer sales Web browser Two from: Allows the salesperson to show the customer information/images that will answer questions about toys Can be used by salesperson to look up customer’s web site to prepare for visit Email software Two from: Allows salesperson to send emails to head office Can email customer/store to confirm planned visit Can email customer/store to confirm orders Presentation software Two from: To advertise new products to customers/stores To show details of all the products to customers/stores To show potential earnings to customers/stores To enable salespeople to be kept up to date with training presentations To create slideshows of products to show customers/shops To create slideshows to show sales progress to managers Time management software Two from: To organise appointments with customers/stores To help with daily and weekly planning Alerts to start of meeting with customer

Page 4 Mark Scheme Syllabus Paper Cambridge International AS/A Level – May/June 2016 9713 12 © Cambridge International Examinations 2016 2 (a) Six from: [6] Each operator has a computer to provide data about the toys Each operator has a headset to communicate with customer Each operator’s computer contains a telephony card Card allows a link to the telephony server The server directs a call to the appropriate operator Calls up matching customer records Displays the script for the operator Can record conversations/calls with customer Software enables on-screen phone control such as answer, hang up, hold, conference, re-dial Description of IVR (interactive voice response) Displays caller ids Queues calls The operator’s phone communicates directly with the server The server controls all the phones The operator’s computer does not control/is not controlled by the phone although it may be physically connected Any computer in the system can be used to control any phone Allow supervisors, for example, to intervene if the call proves too complex for the operator to handle (b) (i) Three from: [3] Emails may contain a virus, including a description of the result Email may be SPAM, which can alert the sender to the fact it is a valid email address Email might contain offensive material upsetting the customer Spyware can be attached to an email (ii) Three from: [3] Email could be from an unknown new sender Emails containing attachments Attachments could have unusual file extensions… …e.g. .exe, .bat, .com Email might contain no subject line Email address of sender is not the same as normal MyToy email address Anti-virus software may inform you If email has been sent to spam/junk folder

Page 5 Mark Scheme Syllabus Paper Cambridge International AS/A Level – May/June 2016 9713 12 © Cambridge International Examinations 2016 3 (a) (i) Observation: [2] Benefit Enables the systems analyst to see the process as a whole Drawback Explanation of the ‘Hawthorne effect’ (ii) Questionnaires: [2] Benefit Answers tend to be, on the whole, more accurate/everyone can complete the questionnaire at the same time instead of one after the other (as with interviews)/can complete it at their leisure Drawback It is very difficult to ask further questions based on the response to another question/can be anonymous and so may not be taken seriously by user (iii) Interviews: [2] Benefit Interviewer can move away from their ‘script’ and ask a more in-depth question if a particular response is given/can interpret body language Drawback Users have to be available at the time the systems analyst wants to interview them/may not have the time/can take a long time to interview all the users Interviewees might try and provide answers which they think the interviewer wants to hear (b) Six from: [6] Parallelogram shows input to the system Rectangles show individual processes Cylinder shows data that is stored on (magnetic) hard disks Final symbol represents output/printout The arrows show the direction of flow of data The processing of a customer payment (c) (i) Three from: [3] May be in danger of losing their jobs May have to be retrained Some workers may have to/may have the opportunity to go part time There may be the opportunity to job share There may be the opportunity for flexible working hours There may be the opportunity to work compressed hours Workers may need to have the ability to move from branch to branch May change job because technical jobs made available

Page 6 Mark Scheme Syllabus Paper Cambridge International AS/A Level – May/June 2016 9713 12 © Cambridge International Examinations 2016 (ii) Three from: [3] May lose the branch in their town Might be concerned that hackers might hack into account and transfer funds to own account Expense of buying a computer with a broadband internet connection Unable to make cash deposits or withdraw cash without physically going to the bank or to an ATM Reliability of internet connection cannot be guaranteed so may not be able to carry out transaction May not like it that the bank is not providing the ‘personal touch’ May mismanage accounts as it is so easy to transfer money from one account to another Security concerns about data transmitted over internet such as hacking, phishing, pharming, spyware, viruses, malware Description of phishing Description of pharming Description of viruses 4 (a) Six from: [6] Required temperature is input using remote control/touchscreen /number pad Sensor is used to monitor current temperature of the room Sensor sends reading to the computer Computer compares temperature from sensor to the pre-set value If sensor temperature is higher/lower than pre-set value computer sends a signal… …to the actuator …if lower computer/actuator switches heater on …if higher then computer/actuator switches heater off (b) (i) Four from: [4] All records will be processed when the payroll is run/no records will be missed They need to be in same order as master file Processing time will be reduced Payroll uses batch processing and sequential files are better suited to batch processing (ii) Two from: [2] Individual records may be slower to find Individual records may take longer to edit A record can only be replaced if the new record is exactly the same length as the original Records can only be updated if the data item used to replace the existing data is exactly the same length

Page 7 Mark Scheme Syllabus Paper Cambridge International AS/A Level – May/June 2016 9713 12 © Cambridge International Examinations 2016 5 (a) Field Name Data Type Example data ItemName Text Boiler NumberInStock Integer 236 Price Currency $14.95 ItemLocation Text 06:71:03 MinimumStock Integer 100 Field Name Data Type SupplierName Text SupplierAddress Text SupplierEmail Text DiscountOnPrice Integer/currency OrderPlaced Boolean/Date Five from: [5] All 5 Text only data types NumberInStock and MinimumStock set to integer Price set to Currency DiscountOnPrice set to integer/currency OrderPlaced set to Boolean/Yes or No/Date (b) Four from: [4] A field that will be common to both the ITEM table and the SUPPLIER table A field which will contain unique data Needed to act as the link field between the tables Acts as the key field in the Item/Supplier table Acts as foreign key in the Supplier/Item table (c) Five from: [5] Type check on NumberinStock: must be numeric Range check on NumberinStock: between 50 and 500 Type check on Price: must be numeric Range check on Price: between $20 and $1000 Format check on ItemLocation: Three pairs of digits separated by colons Length check on ItemLocation: must be 8 characters Range check on MinimumStock: between 20 and 100 Type check on MinimumStock: must be numeric

Page 8 Mark Scheme Syllabus Paper Cambridge International AS/A Level – May/June 2016 9713 12 © Cambridge International Examinations 2016 6 Six from: [6] A system of versions can be used Editor protects document as tracked changes/comments only Publishes it online to restricted website/sends it to members Each member of the group saves their version with a file name/number Each member must save their version with a different version name/number Each file name could have the member’s initials appended Each member uploads file after editing to restricted website/send it to secretary The secretary can then decide which corrections should be used, if any Member versions of the report can then be merged to show all suggested amendments from which the secretary can choose Tracked changes …so that the changes can be clearly seen …and either accepted or rejected The secretary will be responsible for ensuring that version numbering is maintained (and that deadlines are met) Alternatively one file is used Each member comments on the file and sends it to the next member Comments can be in a different colour for each member of the group