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

This document consists of 15 printed pages and 1 blank page. DC (NH) 88704/2 © UCLES 2014 [Turn over * 6 6 7 6 4 6 8 9 1 9 * APPLIED INFORMATION AND COMMUNICATION TECHNOLOGY 9713/13 Paper 1 October/November 2014 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 a 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. Cambridge International Examinations Cambridge International Advanced Level

2 9713/13/O/N/14 © UCLES 2014 Scenario 1 Questions 1, 2, 3, 4, 5 and 6 Ali Fashions Ltd has a number of stores in Cairo. It is converting its existing computer system to make it more efficient. A systems analyst is being employed to analyse the existing system and then design the new system. Ali Fashions Ltd currently has two separate files, one for storing customer records and another for storing records of sales. The customer records are processed as a single master file at the end of the day using a transaction file which is created in the course of the day. There are three types of transaction. Examples are: • A customer cancels their account • A new customer account is created • A sale or payment is made. When customers buy goods the cost of the goods is added to their account. For example, a customer buying a shirt costing $20 would need to have that sale recorded on their account. If they already owed $40, $20 would need to be added to their account to give a balance of $60. They pay what they owe at the end of each month. The systems analyst has decided that the sales records and the customer records should be combined into a relational database system.

3 9713/13/O/N/14 © UCLES 2014 [Turn over 1 Three methods of implementing the new system would be the use of parallel running, direct changeover and pilot running. For each statement below, tick the most appropriate answer. (a) An advantage of using parallel running would be: ✓ It is the cheapest method of implementation If there is a fault with the new system the old system can still be used It is the fastest method of implementation You need two sets of workers [1] (b) An advantage of using direct changeover would be: ✓ If there is a fault with the new system the old system can still be used There is no need to train the workers The benefits of the new system are available immediately The new system does not require any documentation [1] (c) An advantage of using pilot running would be: ✓ If there is a fault with the new system not all stores in the organisation would be affected If there is a fault with the new system none of the stores in the organisation would be affected It is a quicker method of implementation than direct changeover It is a cheaper method than direct changeover [1]

4 9713/13/O/N/14 © UCLES 2014 2 Tick four reasons why technical documentation is produced. ✓ To provide the systems analyst with a detailed overview of the whole system So that user documentation does not have to be produced So that cashiers can troubleshoot simple problems To make sure the developed system matches the design So that the system can be evaluated To help when the system needs amending to eliminate errors So that programmers can fully understand the program code that has been used So that users can fully understand the system To help cashiers operate the POS terminals To refer to when the system needs further development or upgrading [4]

5 9713/13/O/N/14 © UCLES 2014 [Turn over 3 The calculations involved in updating a customer record file following a purchase will need to be tested. A test plan consisting of a table containing columns would be created. Name three of the column headings. For each one give an example or description of the possible contents of the column making reference to the data given in the scenario. Heading 1 … … Contents … … Heading 2 … … Contents … … Heading 3 … … Contents … …[6]

6 9713/13/O/N/14 © UCLES 2014 4 (a) Name three types of transaction involved in the updating of the master file at the end of the day. Using the scenario, give one example of each type of transaction. 1 … … … … 2 … … … … 3 … … … …[6] (b) Fixed magnetic hard disks are used to store the transaction and master data files. Discuss the advantages and disadvantages of using disks compared with using magnetic tape for this storage. … … … … … … … … … … … …[6]

7 9713/13/O/N/14 © UCLES 2014 [Turn over 5 (a) Describe the relational database that would need to be created to store the sales records and the customer records. … … … … … … … … … …[5] (b) Give three reasons why the systems analyst would recommend a relational database. 1 … … 2 … … 3 … …[3]

8 9713/13/O/N/14 © UCLES 2014 6 (a) When data is entered into the new database it will need to be verified. Describe two ways in which this can be done. 1 … … … … 2 … … … …[4] (b) Describe the differences between validation and verification. … … … … … …[3]

9 9713/13/O/N/14 © UCLES 2014 [Turn over Scenario 2 Questions 7, 8, 9 and 10 The WIMBA car company has automated production lines. Computer controlled robot arms are used to produce its new model. The company wishes to advertise all aspects of its business, including car insurance, as well as this new model. It is planning to advertise using multimedia presentations in shopping malls. Maria is the manager of the advertising department. She uses time management software in her job. Many workers in her department work compressed hours.

10 9713/13/O/N/14 © UCLES 2014 7 (a) For each of the following four end effectors, describe the task each would perform in car production. Camera … … Welding gun … … Vacuum cup … … Spray gun … …[4] (b) Give four reasons why companies use robots when assembling car bodies. 1 … … 2 … … 3 … … 4 … …[4]

11 9713/13/O/N/14 © UCLES 2014 [Turn over 8 (a) Describe the three types of advertising shown below. Give an example of each type, referring only to aspects of the car company used in this scenario. Business … … Example … … Product … … Example … … Service … … Example … …[6] (b) Describe, with reference to the scenario, four features which are found in a multimedia presentation which would not be found in a flyer. 1 … … 2 … … 3 … … 4 … …[4]

12 9713/13/O/N/14 © UCLES 2014 9 Maria uses software to help her carry out a number of time management tasks. Describe three of these tasks that she might wish to carry out. 1 … … 2 … … 3 … …[3] 10 (a) Describe what is meant by working compressed hours. … … … …[2] (b) Describe two drawbacks to the worker of working compressed hours. 1 … … 2 … …[2] (c) Describe two drawbacks to the company of workers working compressed hours. 1 … … 2 … …[2]

13 9713/13/O/N/14 © UCLES 2014 [Turn over Scenario 3 Question 11 ICE refrigerators Ltd is an English company which manufactures refrigerators. It provides a help line service to its customers. When customers phone the help line they are put through to a call centre. The call centre has a system which automatically processes the phone call before the operator speaks to the customer. Health and Safety issues often arise through the use of computer equipment at the call centre.

14 9713/13/O/N/14 © UCLES 2014 11 (a) Describe four measures which could be taken to minimise safety risks. 1 … … 2 … … 3 … … 4 … …[4] (b) Describe four different measures which operators could take to minimise health problems. Include in your description the health problem each measure would help to minimise. 1 … … 2 … … 3 … … 4 … …[4]

15 9713/13/O/N/14 © UCLES 2014 (c) Describe five steps involved in the processing of a customer call by the call centre’s automated system. 1 … … 2 … … 3 … … 4 … … 5 … …[5]

16 9713/13/O/N/14 © UCLES 2014 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. 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.

® IGCSE is the registered trademark of Cambridge International Examinations. CAMBRIDGE INTERNATIONAL EXAMINATIONS Cambridge International Advanced Subsidiary and Advanced Level MARK SCHEME for the October/November 2014 series 9713 APPLIED INFORMATION AND COMMUNICATION TECHNOLOGY 9713/13 Paper 1 (Written A), maximum raw mark 80 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 October/November 2014 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 – October/November 2014 9713 13 © Cambridge International Examinations 2014 1 (a) It is the cheapest method of implementation If there is a fault with the new system the old system can still be used ✓ It is the fastest method of implementation You need two sets of workers [1] (b) If there is a fault with the new system the old system can still be used There is no need to train the workers The benefits of the new system are available immediately ✓ The new system does not require any documentation [1] (c) If there is a fault with the new system not all stores in the organisation would be affected ✓ If there is a fault with the new system none of the stores in the organisation would be affected It is a quicker method of implementation than direct changeover It is a cheaper method than direct changeover [1] 2 To provide the systems analyst with a detailed overview of the whole system ✓ So that user documentation does not have to be produced So that cashiers can troubleshoot simple problems To make sure the developed system matches the design So that the system can be evaluated To help when the system needs amending to eliminate errors ✓ So that programmers can fully understand the program code that has been used ✓ So that users can fully understand the system To help cashiers operate the POS terminals To refer to when the system needs further development or upgrading ✓ [4]

Page 3 Mark Scheme Syllabus Paper Cambridge International AS/A Level – October/November 2014 9713 13 © Cambridge International Examinations 2014 3 Three matched pairs from: Test data This column would contain test data values such as 40 and 20/description of test data Expected results This column would contain the calculation 20 + 40 = 60/description of expected results Actual results This column would contain the actual results of the test, in this case 60/description of actual results Comment This column would contain whether the test worked, in this case whether 60 was produced or not/description of a comment Accept other column headings if feasible [6] 4 (a) Matched pairs Amendment [1] A customer’s address/name is changed/customer buys something +[1] Deletion [1] A customer closes their account/dies +[1] Insertion [1] A new customer opens an account +[1] (b) Six from: Magnetic disc has faster access than magnetic tape to data for reading from a file Magnetic disc has faster access than magnetic tape to data for writing to a file Fixed magnetic disc is not as portable as a magnetic tape, so not as effective for transaction file… …if this is to be prepared off line Data on a magnetic disc has direct access… …so useful if data from master file is required quickly Data on a magnetic tape requires serial access… …but as all the data on the transaction file will be used this is not an issue One mark is available for a reasoned conclusion [6]

Page 4 Mark Scheme Syllabus Paper Cambridge International AS/A Level – October/November 2014 9713 13 © Cambridge International Examinations 2014 5 (a) Five from: The relational database consists of two tables A customer records table and a sales records table The tables are linked to each other… …using a key field …for example the customer ID This field is part of other table(s) Data from one table combined with data from other table(s) when producing reports Can select different fields from each table for output SQL is used for queries and producing reports [5] (b) Three from: Data is not repeated Less storage capacity needed Easier to expand the database Data only needs to be amended once Easier to produce reports with cross-tabular data Data integrity is maintained Hackers would find it more difficult to access data than if they were separate flat files [3] 6 (a) Two matched points from: Visual verification Visually compare data on screen/printout with original/source document Decide which version is correct if differences are spotted Double data entry Two people type in data/one person types in data twice Computer compares two versions Keyboard freezes/sound made/data flagged if differences occur Decide which version is correct if differences are spotted [4] (b) Three from: Verification checks that data is copied correctly from one medium to another Verification checks that versions of data have been entered correctly Verification does not check if data is correct or reasonable Validation is used to check entered data is reasonable/acceptable [3]

Page 5 Mark Scheme Syllabus Paper Cambridge International AS/A Level – October/November 2014 9713 13 © Cambridge International Examinations 2014 7 (a) Four from: Camera – to inspect work Welding gun – to weld parts of the car body together Vacuum cup – to pick up parts of the body Spray gun- to paint the car body [4] (b) Four from: A robot arm has greater accuracy/fewer errors than a human There are lower running costs/no need to pay robots wages/lower utility costs Work/work rate is of a consistent standard The whole process can be continuous/24 hours a day 7 days a week… …without having to stop at shift changeovers It is a safer/less dangerous environment for humans/robots can work in harsh/hazardous conditions Greater productivity [4] 8 (a) Three descriptions and three examples from: Business – Advertises the whole company to make the company name familiar not just a single product or service Example – advertising the WIMBA car company as a whole Product – Advertising a specific/single product Example – The new model of car Service – Advertising of a service such as banking, insurance, education/a service the company provides (for its customers) Example – car insurance [6]

Page 6 Mark Scheme Syllabus Paper Cambridge International AS/A Level – October/November 2014 9713 13 © Cambridge International Examinations 2014 (b) Four descriptions from: Sound could be used in voiceovers/welcome from managing director Soothing background music to create a comfortable feel for customers Video of the car being manufactured/recordings of satisfied customers Animation to demonstrate insurance services/animated 3D logo of the company Hyperlinks to navigate between slides of different aspects of the company or cars/link to company’s website Navigation button to navigate between slides of different cars/different aspects of the company [4] 9 Three from: Descriptions of: Organising meeting times Arranging workloads Organising research and development projects Project management [3] 10 (a) Two from: Involves working the same number of hours as normal Over a shorter number of days Usually involves working 4½ days in a week/9 days out of 10 in a period of two weeks [2] (b) Two from: Can be very tired after working long hours Have to get up earlier/work later most days Spend less time with family on working days Less leisure time on working days [2] (c) Two from: Difficult to arrange training/meeting times/working hours to suit all workers Utilities may be more expensive as advertising department is working longer hours Work needs to be carried out over the whole week but the employee is not always there [2] 11 (a) Four from: Do not overload sockets Only allow qualified electricians to install electrical equipment Equipment should be checked regularly Cabling should be tied up/trunked Electrical equipment must be located away from water supplies Do not take drinks near electrical equipment Have several carbon dioxide fire extinguishers Benching/work desks should be sturdy enough to take the weight of heavy equipment/do not allow heavy equipment to overhang [4]

Page 7 Mark Scheme Syllabus Paper Cambridge International AS/A Level – October/November 2014 9713 13 © Cambridge International Examinations 2014 (b) Four matched pairs from: Measure Get up and walk around every so often Good quality seating that supports the back/sitting in an appropriate position Height-adjustable seating Focus on a distant object from time to time/improve the lighting in the room/have anti-glare screens Use ergonometric/ergonomic keyboards Height, position and distance from worker of screens/keyboards should be optimised Health problem Lower back pain Problems with one’s sight RSI in the fingers RSI in the wrists/carpal tunnel syndrome Eye strain/headaches Upper back/neck/shoulder pain/eyestrain/headaches [4] (c) Five from: Interactive voice response (IVR) software deals with initial request IVR provides options to customer IVR provides automated services If necessary phone call is directed to (appropriate operator) Call can be queued Caller’s number is displayed to operator Customer records, if available, displayed to operator [5]