Cambridge A Level Applied Information and Communication Technology 9713 — 2017 Oct/Nov Paper 1 · Variant 3

This document consists of 15 printed pages and 1 blank page. DC (ST) 134079/2 © UCLES 2017 [Turn over Cambridge International Examinations Cambridge International Advanced Subsidiary and Advanced Level * 3 9 9 3 5 4 4 0 1 0 * APPLIED INFORMATION AND COMMUNICATION TECHNOLOGY 9713/13 Paper 1 October/November 2017 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 dark 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/13/O/N/17 © UCLES 2017 Scenario 1 Questions 1, 2 and 3 WIMBA manufactures cars. It makes its own paint in a separate department so that the cars can be painted before they come off the production line. Robot arms are used to carry out many of the manufacturing processes. In order that they perform at maximum efficiency, the temperature must not rise above or fall below 17 °C. A Programmable Logic Controller (PLC) using a Proportional Integral Derivative (PID) algorithm keeps the temperature at 17 °C.

3 9713/13/O/N/17 © UCLES 2017 [Turn over 1 Tick the four most accurate statements about the use of end effectors when attached to robot arms. 3 Cameras are used to inspect/check work. Sanders are used to produce a shiny finish. Grippers are used to pick up parts. Riveters are used to place and tighten nuts. Screwdrivers are used to place/screw in and tighten screws. Polishers are used to prepare the car body for painting. Spanners are used to paint the car body. Vacuum cups are used to pick up parts. Sprayers are used to weld parts of the car body together. All end effectors have to be changed by a human. [4] 2 Tick the four most accurate statements about the use of PLCs and PIDs. 3 A PID algorithm is a type of computer/microprocessor used for a single purpose. A PLC has analogue and digital inputs. A PLC is not used in processes which are continuous. There is rarely any input to a PLC from the user once it has been programmed. The PLC causes the PID algorithm to make proportional changes to the temperature. A PLC is used in this process as the pre-set value is constant. A PLC is a type of computer used for many different purposes. The PID algorithm calculates the difference between the input value and the pre-set value. The PID algorithm causes the PLC to switch the heating element on for long periods of time. The PLC does not make use of any sensors. [4]

4 9713/13/O/N/17 © UCLES 2017 3 Using examples from the scenario, describe what is meant by: batch process control; … … … … … …[2] continuous process control; … … … … … …[2] discrete process control. … … … … … …[2]

5 9713/13/O/N/17 © UCLES 2017 [Turn over Scenario 2 Questions 4, 5, 6, 7 and 8 Louisa is the chief car salesperson with GoodCars Sales in Christchurch. Part of her job is to go on training courses which usually take place in Wellington, some distance away. This involves her being out of the salesroom quite often. She keeps a spreadsheet of training courses she attends and the cost of each session. While she is out of the salesroom, Louisa uses email to remain in contact with her sales people. Paul, Louisa’s deputy, has suggested that Louisa could set up a phone conference to stay in touch with her colleagues instead. Most of GoodCars’ customers live locally. The company is in competition with a number of other local car sales companies. At the moment it advertises its cars using locally distributed flyers. It is considering using slide show presentations situated in a local shopping mall. The directors of GoodCars are considering having a website which customers could use to buy cars, which may cause some sales people to be made unemployed.

6 9713/13/O/N/17 © UCLES 2017 4 Below is part of the spreadsheet that Louisa keeps about her training courses. A B C D E F G 1 2 Course Code Course title Course cost per day 3 A Automotive Studies $250 4 B Customer Care $325 5 C Financial Competence $225 6 7 Date of course Duration (days) Course Code Cost 8 12-01-17 2 B $650 9 25-01-17 1 C $225 10 08-02-17 3 A $750 11 15-03-17 2 C $450 12 18-04-17 3 B $975 13 28-04-17 2 A $500 (a) Write down the formula which should go in cell D8 which involves the use of the VLOOKUP function. = … …[5] (b) Give three reasons why Louisa only wants to type in the course code in column C rather than the full title. 1 … … … 2 … … … 3 … … …[3]

7 9713/13/O/N/17 © UCLES 2017 [Turn over 5 (a) Describe how Louisa would set up a phone conference. … … … … … … … … … …[4]

8 9713/13/O/N/17 © UCLES 2017 (b) Discuss the advantages and disadvantages to sales people of using email compared to a phone conference. … … … … … … … … … … … … … … … … … … … …[8]

9 9713/13/O/N/17 © UCLES 2017 [Turn over 6 (a) There are three types of advertising: Service, Product and Business. Identify and describe the type that GoodCars use, explaining why. … … … … … … …[3] (b) Compare and contrast the use of flyers with the use of a slide show. … … … … … … … … … …[4]

10 9713/13/O/N/17 © UCLES 2017 7 (a) Apart from having a good visual appearance, describe the features of a website designed specifically for buying cars online. … … … … … … … … … … … …[6] (b) To prevent unemployment of sales people, describe the two working patterns they will need to adopt. 1 … … … 2 … … …[2]

11 9713/13/O/N/17 © UCLES 2017 [Turn over 8 Discuss the advantages and disadvantages to customers of buying cars online. … … … … … … … … … … … … … … … … … … … …[8]

12 9713/13/O/N/17 © UCLES 2017 Scenario 3 Questions 9, 10 and 11 Shanghai Garments (SG) operates a phone shopping system whereby customers phone in orders and have the garments delivered to their homes. Each customer has an account and pays at the end of the month what they owe on their account. During the course of a normal day, a transaction file (order file) is created which has the garments ordered and some details of the customer as well as the amount of the transaction. This file contains the absolute minimum of information. There is a master file which contains all the customer details including how much money they owe. The master file (customer file) is updated at the end of each day. There is a separate file which contains the details of each garment in stock. SG have decided that they want to update the current system of record keeping. They have employed Ho, a systems analyst, to organise the creation of this new system.

13 9713/13/O/N/17 © UCLES 2017 [Turn over 9 (a) Apart from the value of the transaction, identify two items which would be in the transaction file. … …[2] (b) Describe the computer processing involved in the daily updating of the master file. … … … … … … … … … … … … … … …[6]

14 9713/13/O/N/17 © UCLES 2017 10 (a) Ho has decided that the existing files should be combined into a relational database system. Describe how he would do this. … … … … … … … … … … … …[5] (b) Explain why a relational database would be better than two separate flat files. … … … … … … … … …[4]

15 9713/13/O/N/17 © UCLES 2017 11 When Ho has implemented the new system he will provide technical documentation. For each of the following types of technical documentation, describe three items which would be present in each. Systems: 1 … … … 2 … … … 3 … … … Program: 1 … … … 2 … … … 3 … … …[6]

16 9713/13/O/N/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 7 printed pages. © UCLES 2017 [Turn over Cambridge Assessment International Education Cambridge International Advanced Subsidiary and Advanced Level APPLIED INFORMATION AND COMMUNICATION TECHNOLOGY 9713/13 Paper 1 Written A October/November 2017 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 International will not enter into discussions about these mark schemes. Cambridge International is publishing the mark schemes for the October/November 2017 series for most Cambridge IGCSE®, Cambridge International A and AS Level components and some Cambridge O Level components.

9713/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED October/November 2017 © UCLES 2017 Page 2 of 7 Question Answer Marks 1 Cameras are used to inspect/check work. 9 Sanders are used to produce a shiny finish. Grippers are used to pick up parts. 9 Riveters are used to place and tighten nuts. Screwdrivers are used to place/screw in and tighten screws. 9 Polishers are used to prepare the car body for painting. Sanders are used to paint the car body. Vacuum cups are used to pick up parts. 9 Sprayers are used to weld parts of the car body together. All end effectors have to be changed by a human. 4 Question Answer Marks 2 An algorithm is a type of computer/microprocessor used for a single process. A PLC has analogue and digital inputs. 9 A PLC is not used in processes which are continuous. There is rarely any input to a PLC from the user once it has been programmed. 9 The PLC causes the PID algorithm to make proportional changes to the temperature. A PLC is used in this process as the pre-set value is constant. 9 A PLC is a type of computer used for many different purposes. The PID algorithm calculates the difference between the input value and the pre-set value. 9 The PID algorithm causes the PLC to switch the heating element on for long periods of time. The PLC does not make use of any sensors. 4

9713/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED October/November 2017 © UCLES 2017 Page 3 of 7 Question Answer Marks 3 Batch process control: Used in paint making process 1 One from: Amounts of raw materials are combined together Mixed for a certain length of time. Amount of each ingredient is controlled by computer Length of time for each stage controlled by computer Used to produce relatively small amounts of a product per year 1 Continuous process control: Used in keeping temperature at 17°C 1 One from: Like a never ending process necessary to maintain a constant temperature 1 Discrete process control: Used in putting wheels/doors/windows on/spray painting 1 One from: Like an on/off or stop/start process The computer control involved in putting components together/painting car is discrete A car is fitted/painted, the next carton comes along, the robot carries out exactly the same task In between cars the robot pauses/stops. 1 Question Answer Marks 4(a) =B8*VLOOKUP(C8,$E$3:$G$5,3,FALSE) B8* 1 mark VLOOKUP (C8, 1 mark $E$3:$G$5, 1 mark 3, FALSE 1 mark Correct order in VLOOKUP and brackets. 1 mark 5 4(b) Three from: It reduces the time taken to type in the data It reduces the risk of typing errors It makes it easier to validate It reduces the storage space taken up by the spreadsheet. 3

9713/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED October/November 2017 © UCLES 2017 Page 4 of 7 Question Answer Marks 5(a) Four from: Louisa tells sales people the time and date of the conference Louisa books the phone conference with the phone company for that date Louisa is given two PINs by the phone company A personal PIN, the participants’ PIN Louisa contacts sales people and tells them the participant PIN Just before the conference Louisa dials the phone number Louisa keys in her special PIN Sales people phone the same number Sales people join the conference by typing in the participant PIN. 4 5(b) Eight from: With email you are never quite sure if email has been received With phone conference you can be more confident that your message is going to the right person With phone conference feedback is more immediate/it can take longer before you receive feedback from the person you sent the email to With an email you can see/amend/share documents that you want to discuss with each other With a phone conference it is easier to clear up misunderstandings It is more difficult to hear everyone’s point of view in a phone conference With emails you are more likely receive replies which are identical without the respondents realising until too late With email you can target confidential material at specific individuals With an email you have more time to reflect on your answers With a phone conference it is more personal Easier to keep an email, can be kept as evidence/audit trail. One mark is available for a reasoned conclusion. Must have at least two advantages and two disadvantages to gain full marks. 8 Question Answer Marks 6(a) Product advertising Advertising of a specific product/advertising individual items They are advertising individual cars. 3

9713/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED October/November 2017 © UCLES 2017 Page 5 of 7 Question Answer Marks 6(b) Four from: Slide show has range of multimedia – sound, video/ animation unlike flyers Slide show has other features e.g. slide transition effects, special text effects, image transition unlike flyers Slideshow is on while mall is open/the user cannot switch it off/flyers can be thrown away Flyers can target your audience better than a slide show Both are limited to the local area but that is where all their customers are. Must have comparison and contrast to gain four marks. 4 Question Answer Marks 7(a) Six from: An easy-to-remember domain name A secure method of accepting payments Descriptions/pricing/photos of cars Usernames and passwords to make the system secure Customers are able to contact shop directly via e-mail Allows customers to see their order and maintain their own accounts Allows customers to track the progress of their order Searches and advanced searches can be carried out easily Customers can move easily to the checkout/navigate from category to category easily Wish lists which enable users to store the cars they might want to buy in the future ‘People who bought A also bought B’ recommendations Customers can design their own cars using interactive features/cost their customised car. 6 7(b) Part-time working sales people working fewer hours 1 mark Job sharing two sales people doing one job at different times. 1 mark 2

9713/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED October/November 2017 © UCLES 2017 Page 6 of 7 Question Answer Marks 8 Eight from: Disadvantages: Security concerns about data transmitted over internet such as hacking, phishing, pharming, spyware, viruses, malware (must have two) Description of phishing Description of pharming Description of viruses Can order a car and it does not get delivered/takes time to get car delivered Car is not to the same standard as that ordered Disabled people may have problems navigating through screens Cannot check the standard of car before buying May be hidden costs such as delivery charges Expense of buying a computer with a broadband internet connection Cannot take car for a test drive Advantages: Can shop at a convenient time for them/24/7 Customers can spend time comparing cars and prices without being rushed Do not have to spend time queuing/going around different showrooms Do not have to spend time travelling to showroom Physically disabled people do not have to leave house to visit showroom Can look at wide range of showrooms all around the country/world Customers do not have to spend money travelling to showroom Customer might lack confidence talking to a salesman There will be a greater choice of cars. One mark is available for a reasoned conclusion. Must have at least two advantages and two disadvantages to gain full marks. 8 Question Answer Marks 9(a) Customer id 1 mark Stock id 1 mark 2 9(b) Six from: Transaction file is sorted into same order as master file Sorted on customer id First record in the transaction file is read First record in the old master file is read These two records are compared If records do not match computer writes master file record to new master file If records match computer calculates the new amount owed Using the current amount from master file Using amount of transaction from transaction file Processed record is written to new master file Process is repeated until end of old master file. 6

9713/13 Cambridge International AS/A Level – Mark Scheme PUBLISHED October/November 2017 © UCLES 2017 Page 7 of 7 Question Answer Marks 10(a) Five from: The number of tables is decided upon, in this case three Relationship diagrams are designed Fields with unique data are identified« ...customer id and stock id The key field/s is/are chosen The types of relationships between the tables decided upon« ...one to many, many to one« «in this case one to many from customer file to order (transaction) file «one to many from stock file to order (transaction) file Relationships are created/tables are linked« «using key field. 5 10(b) Four from: Data is not repeated Less storage capacity needed (If data was duplicated) hackers would have easier access to data Easier to expand the database Data only needs to be amended once Easier to produce reports with cross-tabular data rather than separate files Data integrity is maintained. 4 Question Answer Marks 11 Systems – Three from: A detailed overview of the whole system What is expected of the system/purpose of the system Data Flow Diagrams/systems flowcharts The results of systems analysis Test plan and test results Overall design decisions« «the choice of hardware and software «file, input and output structures Systems flowcharts Program – Three from: Description of the software/purpose of the software Reasons for choosing those pieces of existing software that were used instead of the programmer having to write code Input and output data formats Program flowcharts/algorithms Program listing – a complete copy of the code used« «with annotation explaining what each module of code does Notes that will help any future programmer to make modifications to the system What the software does and its features. 6