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

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

2 9713/13/O/N/15 © UCLES 2015 Scenario 1 Questions 1, 2, 3, 4 and 5 NewProperties are a newly formed house building company that wishes to advertise in the local area. They could create and use: • Flyers to distribute to houses • Posters placed in strategic locations • A website • A multimedia presentation in a local shopping mall The company carried out a trial of allowing their house designers to work from home. After the trial it was decided that they would prefer their designers to be office-based in order to work on the design of a new house. However, a number of workers have asked the manager Bertrand if they can work part-time. Bertrand has agreed providing each worker can find another worker to job share. Bertrand uses time management software to track the progress of the building of houses at a new site. John, a foreman, is in charge of the workers at the building site. He uses a smartphone to stay in contact with Bertrand.

3 9713/13/O/N/15 © UCLES 2015 [Turn over 1 There are a number of advantages and disadvantages of using various advertising methods. For each statement below, tick the most appropriate answer. (a) Flyers: ✓ Flyers are usually produced using presentation software. You can distribute them so that they only go to the people you want to see them. They are very expensive to produce. They can hold more information than a website. [1] (b) Posters: ✓ Posters are never defaced. Posters are smaller than flyers. Posters are produced using a standard printer. Posters will not necessarily be noticed by everybody. [1] (c) Websites: ✓ A small potential customer base is covered by using a website. Paying website designers is much cheaper than producing a flyer. Websites are less interactive than posters. Websites are easier to update as you do not have to reprint the whole advertisement. [1] (d) Multimedia presentations: ✓ Uses sound and video unlike flyers. They are produced more quickly than flyers. You can cover a wider audience than a website would. It would cost less to pay a company to produce this rather than produce their own flyers. [1]

4 9713/13/O/N/15 © UCLES 2015 2 Tick the four statements which are benefits to the company of workers working in the office rather than at home. Benefit ✓ They can pay the workers lower salaries. It is easier to get all the workers together for meetings and briefings. It would be easier for managers to supervise workers. Not so much money would have to be spent on the company’s utility bills. Workers would work longer hours. Travelling expenses would have to be paid to employees to attend face to face conferences. Do not have to subsidise home workers’ equipment. Data is more secure as it does not leave the office. Workers would not have to travel so far to work. There would be fewer workers. [4]

5 9713/13/O/N/15 © UCLES 2015 [Turn over 3 (a) Describe, in detail, what is meant by part-time working. … … … …[2] (b) Describe, in detail, what is meant by job sharing. … … … …[2]

6 9713/13/O/N/15 © UCLES 2015 4 (a) Describe two different types of calendar used with time management. 1 … … 2 … …[2] (b) Two aspects of time management software are shown on the left. Five descriptions are shown on the right. By drawing five lines, connect each aspect to an appropriate description. software advises when clashes occur software helps with daily and weekly planning organising meeting times software provides a critical path method of scheduling project management software is used to keep a record of appointments Gantt charts used to represent parallel and sequential activities [5] 5 Name and describe four methods of communication that John can use when contacting Bertrand using his smartphone. 1 … … 2 … … 3 … … 4 … …[4]

7 9713/13/O/N/15 © UCLES 2015 [Turn over Scenario 2 Questions 6, 7 and 8 Grafton Mail Order Catalogue Company currently operates by receiving orders from its customers by phone. They have a large call centre for this purpose. Due to the prolonged use of computers there are a number of health and safety issues. They are going to extend the way they receive orders by having an online system. The company has a database of customer orders and personal details. Grafton has employed Oscar to supervise the development of the new system. Oscar has already ruled out using parallel running to implement the new system but is not sure which of the other methods to use. After the system is implemented Oscar will provide documentation to go with it.

8 9713/13/O/N/15 © UCLES 2015 6 (a) Identify two items of ICT hardware that an operator in the call centre would have at their desk including a description of the purpose of each. 1 … … 2 … …[2] (b) Name the two different types of call control and describe the type that would be best suited for use in the call centre. Within your description give a reason. 1 … 2 … Description … … … … … …[5] (c) Using examples, describe the difference between health risks and safety risks. … … … … … … … … … …[5]

9 9713/13/O/N/15 © UCLES 2015 [Turn over 7 (a) Other than security issues, describe four drawbacks to the customer of on-line shopping. 1 … … 2 … … 3 … … 4 … …[4] (b) Other than security issues, describe four drawbacks to the company of introducing on-line shopping. 1 … … 2 … … 3 … … 4 … …[4]

10 9713/13/O/N/15 © UCLES 2015 (c) Apart from not having to travel, describe four benefits to the customer of introducing on-line shopping. 1 … … 2 … … 3 … … 4 … …[4] 8 (a) When introducing a new computer system, phased implementation or direct changeover can be used. Describe each method and for each method, give one different advantage and disadvantage compared with parallel running. Phased implementation … … Advantage … … Disadvantage … … Direct changeover … … Advantage … … Disadvantage … …[6]

11 9713/13/O/N/15 © UCLES 2015 [Turn over (b) Describe four items of program documentation that Oscar will provide. 1 … … 2 … … 3 … … 4 … …[4]

12 9713/13/O/N/15 © UCLES 2015 Scenario 3 Questions 9 and 10 Omar is the owner of a small company which manufactures computers. He wishes to computerise the stock control of his business. He needs a system which will store records of all the computers his company makes. From time to time he will need database reports to give him information about the computers he has in stock. Examples of serial numbers for the computers are T123456, L342167, and P789456. The first letter in the serial number is the type of computer and the first digit in the serial number is the manufacturer’s number. He currently uses a spreadsheet to store serial numbers as: A B C 1 Serial Number Type Manufacturer’s number 2 3 T123456 T 1 4 L342167 L 3 5 P789456 P 7 Formulas are used in columns B and C to extract the data from the serial number. As well as the serial number, the new system will store the price of each computer. His basic model, which is the cheapest, sells for $300. The Impressor, which is the most expensive, sells for $1500. He only sells tablet computers, laptops and PCs. He has asked Louisa, a systems analyst, to analyse the current system and then design a new one.

13 9713/13/O/N/15 © UCLES 2015 [Turn over 9 (a) Write down the formula which Omar has used in cell B3. …[2] (b) Write down the formula which Omar has used in cell C3. …[3] 10 (a) Using the data given in the scenario, describe three validation rules which would be designed to check whether the data is acceptable or not. Rule 1 … … … … Rule 2 … … … … Rule 3 … … … …[6]

14 9713/13/O/N/15 © UCLES 2015 (b) Discuss the benefits and drawbacks of interviews, questionnaires and observation for collecting information about the existing system. … … … … … … … … … … … …[6] (c) Describe four features of a well-designed report. 1 … … 2 … … 3 … … 4 … …[4]

15 9713/13/O/N/15 © UCLES 2015 (d) Louisa is recommending the use of an inkjet printer for printing the reports. Give two reasons, compared to other printers, why she has done this. 1 … … 2 … …[2]

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

® 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 2015 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 2015 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 2015 9713 13 © Cambridge International Examinations 2015 1 (a) Flyers are usually produced using presentation software. You can distribute them so that they only go to the people you want to see them.
They are very expensive to produce. They can hold more information than a website. [1] (b) Posters are never defaced. Posters are smaller than flyers. Posters are produced using a standard printer. Posters will not necessarily be noticed by everybody. ✓ [1] (c) A small potential customer base is covered by using a website. Paying website designers is much cheaper than producing a flyer. Websites are less interactive than posters. Websites are easier to update as you do not have to reprint the whole advertisement. ✓ [1] (d) Uses sound and video unlike flyers. ✓ They are produced more quickly than flyers. You can cover a wider audience than a website would. It would cost less to pay a company to produce this rather than produce their own flyers. [1]

Page 3 Mark Scheme Syllabus Paper Cambridge International AS/A Level – October/November 2015 9713 13 © Cambridge International Examinations 2015 2 They can pay the workers lower salaries. It is easier to get all the workers together for meetings and briefings. ✓ [1] It would be easier for managers to supervise workers. ✓ [1] Not so much money would have to be spent on the company’s utility bills. Workers would work longer hours. Travelling expenses would have to be paid to employees to attend face to face conferences. Do not have to subsidise home workers equipment. ✓ [1] Data is more secure as it doesn’t leave the office. ✓ [1] Workers wouldn’t have to travel so far to work. There would be fewer workers. 3 (a) Two from: Working less than the normal working hours of a full time employee Working mornings or afternoons only, rather than a whole day Working fewer days, rather than a full working week [2] (b) Two from: Two people sharing a job normally done by one person Each person is paid on a part time basis though together they do a full time job One person works specific days/mornings/afternoons while other works the remainder [2] 4 (a) Public calendars keep a record of meetings and appointments of all workers so that they can all access it to arrange meetings [1] Private calendar keeps a detailed record of meetings and appointments of a worker so that only he/she can see these [1]

Page 4 Mark Scheme Syllabus Paper Cambridge International AS/A Level – October/November 2015 9713 13 © Cambridge International Examinations 2015 (b) software advises when clashes occur software helps with daily and weekly planning organises meeting times software provides a critical path method of scheduling project management software used to keep a record of appointments Gantt charts used to represent parallel and sequential activities One mark for each correctly placed line [5] 5 Four descriptions from: Send emails Send texts Phone call Instant messaging Video call [4] 6 (a) Two from: Computer to process the calls/look up customer information/to record orders Monitor to display customer/call details Headset to speak with/listen to customers Keyboard to type up details of the call/action taken [2] (b) First party call control [1] Third party call control [1] Two from: Requires a dedicated telephony server (to connect the telephone network and the computer network) Operator’s phone communicates directly with the server Operator’s phone is not directly connected to their computer The server controls all the phones The server can direct a call to the appropriate operator Any computer in the system can control any phone [2] Third party: Reason is because it is suitable for large call centres [1]

Page 5 Mark Scheme Syllabus Paper Cambridge International AS/A Level – October/November 2015 9713 13 © Cambridge International Examinations 2015 (c) Health risks arise from long term use of computers [1] Two from: Staring at a computer screen continuously can cause problems with one’s sight Typing at a keyboard continuously can cause RSI Gripping a mouse and repetitive clicking can cause carpal tunnel syndrome/RSI Sitting in the same position/with wrong posture all day can cause lower back pain Staring at a computer screen all day can cause eye strain/headaches Poor positioning of screen can cause upper back/neck/shoulder pain/eyestrain/headaches Glare from screen can cause eye strain/headaches [2 max] Safety risks can result in a sudden accident [1] Two from: Too many plugs connected to a socket/overheating of computers can be a fire hazard Bare wires can cause electrocution Trailing wires could cause an operator to trip over Heavy equipment incorrectly positioned can fall off a desk and cause injury [2 max] 7 (a) Four from: Can order goods and they do not get delivered Goods are not to the same standard as those ordered/cannot check the standard of goods before buying May be hidden costs such as delivery charges Expense of buying a computer with a broadband internet connection/must have a reliable electricity supply/basic computer skills May lose contact with their friends/less socialising as they may not go out of the house as much Disabled people may have problems navigating through screens Customers who do not have a credit/debit card will not be able to use online shopping [4] (b) Four from: Less face to face contact, so it is harder to sell other services Running costs/initial cost, such as having to pay website developers Initial costs such as buying the hardware when starting up Initial costs such as redundancy payments May need to retrain staff, which is costly/time consuming More delivery staff needed, so costs increase [4]

Page 6 Mark Scheme Syllabus Paper Cambridge International AS/A Level – October/November 2015 9713 13 © Cambridge International Examinations 2015 (c) Four from: Do not have to spend time queuing in online shopping/going around different shops Can shop at any time of day or night/at a convenient time for them Can compare products and prices at their leisure/more easily There will be a greater choice of goods Items are usually cheaper as staff costs are lower/rental/running costs are lower than shopping malls [4] 8 (a) One mark per point Phased implementation – implementing one part of the system while rest of system remains unchanged/implementing system part by part Advantage – Cheaper than parallel running as you do not employ two complete sets of workers Disadvantage – If there is a problem with the new system, only have bulk of old system to fall back on/parallel running has whole system Direct changeover – involves replacing the old system with the new system all in one go/immediately/overnight Advantage – Cheaper than parallel running as you don’t have to employ two sets of workers (if not mentioned before)/quicker method of implementation as there is no delay waiting for bugs to be fixed /benefits of the new system become apparent immediately Disadvantage – If there is a problem with the new system do not have old system to fall back on [6] (b) Four 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 [4] 9 (a) LEFT(A3,1) LEFT – 1 mark (A3,1) – 1 mark [2]

Page 7 Mark Scheme Syllabus Paper Cambridge International AS/A Level – October/November 2015 9713 13 © Cambridge International Examinations 2015 (b) MID(A3,2,1) MID – 1 mark (A3,2 – 1 mark ,1) – 1 mark [3] 10 (a) Three matched pairs from: Format check on serial number Must be one letter followed by six numbers Range check on price Must not be less than $300 and no more than $1500 Lookup check on type of computer Must be tablet, laptop or PC [6] (b) Six from: Observation Benefit –enables the systems analyst to see the process as a whole Drawback – Description of the ‘Hawthorne effect’ Interviews Benefits – Interviewer can move away from their ‘script’ and ask a more in-depth question if a particular response is given Can interpret body language Drawbacks – 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 Questionnaires Benefits – 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 Drawbacks - They may give answers which are exaggerated as they are anonymous Questions cannot be changed once they are typed up Follow up questions cannot be asked Maximum of 4 marks if only two are compared One mark is available for a reasoned conclusion [6]

Page 8 Mark Scheme Syllabus Paper Cambridge International AS/A Level – October/November 2015 9713 13 © Cambridge International Examinations 2015 (c) Four from: Easy to read font Easy to read font size Attractive to look at Based on user requirements Appropriate headers and footers Appropriate use of colour Fields spaced out so the data is clear to read [4] (d) Two from Inkjet printer produces higher quality printout than a dot matrix printer They are faster for printing documents than dot matrix printers’ (They are easier to move than dot matrix printers) Small company, so changing cartridges, which is not so necessary with laser printers and dot matrix printers, is not an issue [2] [Total:80]