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

* 4 4 2 6 6 2 5 0 0 6 * This document consists of 15 printed pages and 1 blank page. DC (CW/FD) 133777/3 © UCLES 2017 [Turn over Cambridge International Examinations Cambridge International Advanced Subsidiary and Advanced Level APPLIED INFORMATION AND COMMUNICATION TECHNOLOGY 9713/12 Paper 1 May/June 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/12/M/J/17 © UCLES 2017 Scenario 1 Questions 1, 2, 3, 4, 5, 6 and 7 The University School of Jakarta has 350 students. The Principal of the school wants to introduce procedures whereby all her teachers will use computers to store records about their students and write reports. These reports are to be uploaded to the school’s website so that parents can log in securely and view their child’s report. When a teacher uploads their teaching group’s reports they need to send a message to the Principal. Students are assessed using teacher produced tests but answer on the computer screen. They sit at the computer and type in their responses. The teachers download the students’ answers at the end of the assessment and mark them as usual. The results will be stored in a computer file. One of the provisions of data protection legislation is that data should be kept secure. Ferdian, an ICT student, thinks that as each student has a student number consisting of three digits, it would be useful to disguise this in some way. The ICT rooms which will be used for the assessments all need to have air conditioning systems.

3 9713/12/M/J/17 © UCLES 2017 [Turn over 1 A medium will need to be chosen to store the student files. Tick the four most accurate statements given below. 3 A hard disk provides direct access. A CD ROM stores several Gigabytes of data. A Blu-ray disk stores less data than a DVD. A magnetic tape has quicker data access than a hard disk. A magnetic tape is a suitable medium for storing backups of server data. A CD RW cannot be overwritten. Blu-ray disks are not used to store data. A pen drive can store more data than a CD. Flash memory cards are used in mobile (cell) phones. Solid state drives are more prone to failure than magnetic media. [4] 2 Tick the four most accurate statements given below about databases. 3 Data files are often converted to a common text format in order that they can be exported to another software package. Validation is to check that data is reasonable. Verification is to check that data is correct. A range check is a verification check. Comparing two versions of the same input data is a type of verification. Charts are never exported from a database into another software package. OR and NOT are mathematical operators. It is only possible to sort data on one criterion. “Several to several” is a type of relationship. In order to create a relational database you have to identify a key field. [4]

4 9713/12/M/J/17 © UCLES 2017 3 Apart from databases, describe, including their uses, four different types of software which will be needed by a teacher using the new procedures. Each use must be different. 1 … … … 2 … … … 3 … … … 4 … … …[4]

5 9713/12/M/J/17 © UCLES 2017 [Turn over 4 Discuss the advantages and disadvantages of carrying out student tests using computers compared with using pen and paper. … … … … … … … … … … … … … …[6]

6 9713/12/M/J/17 © UCLES 2017 5 For Ferdian’s first attempt at disguising the Student number he has developed a spreadsheet. This is shown below. The Student number is stored as a text string. D E F G H I J K 1 Student number Disguised Student number 2 456 4 5 6 654 3 In G2, H2 and I2, he has used different functions to extract parts of the Student number string. In K2 he has put these parts back together in reverse order. (a) Write down the formula he has used in cell G2. = …[2] (b) Write down the formula he has used in cell H2. = …[3] (c) Write down the formula he has used in cell I2. = …[2] (d) Write down the formula he has used in cell K2. = …[3]

7 9713/12/M/J/17 © UCLES 2017 [Turn over 6 Explain the rights of an individual as set out in data protection legislation. … … … … … … … … … … …[5] 7 The diagram shows a simple air conditioning system. Valve A B C (a) Identify the components labelled: A … B … C …[3]

8 9713/12/M/J/17 © UCLES 2017 (b) There is a pressure sensor situated just before the refrigerant enters the valve. Describe how the microprocessor controls the valve. … … … … … … … …[3]

9 9713/12/M/J/17 © UCLES 2017 [Turn over Scenario 2 Question 8, 9 and 10 KL Newspapers owns the Malaysian Daily Moon. It uses the latest technology to print the magazine. It uses computerised plate making and typesetting techniques. Typesetting involves the editor using a computer to set the layout of a page. The printing plant is on the same site as the editor’s office. KL employs a number of journalists to write articles. These journalists tend to work away from the editorial office gathering information to write their stories. Often they stay in hotels to be near to events as they happen. When they have completed their stories they send them to the editor for editing.

10 9713/12/M/J/17 © UCLES 2017 8 (a) Describe how journalists would use ICT when creating and sending their stories to the editor. … … … … … … … … … … … … … …[6] (b) Describe how the editor would prepare the journalist’s story ready for printing, including any typesetting techniques used. … … … … … … … … … … … … … …[6]

11 9713/12/M/J/17 © UCLES 2017 [Turn over 9 Describe the drawbacks to the journalists of working away from the editorial office. … … … … … … … … … …[4] 10 Describe how a plate is produced before it is used in the printing process. … … … … … …[2]

12 9713/12/M/J/17 © UCLES 2017 Scenario 3 Questions 11, 12 and 13 Ramon is the manager of the payroll section of a large company. The company has many departments. He has decided that the current payroll system is out of date and has employed Joanne, a systems analyst, to investigate the current system and develop a new one. Ramon wants the system, as well as outputting payslips, to produce reports. Ramon and Joanne will be using time management software to monitor the progress of this project. After the system has been tested Joanne will need to produce an evaluation of it. One way of evaluating the system is to observe workers using the new system.

13 9713/12/M/J/17 © UCLES 2017 [Turn over 11 Discuss, giving examples of exception and financial reports, the reasons why Ramon would want different types of reports. … … … … … … … … … … … … … … … … … … … …[8]

14 9713/12/M/J/17 © UCLES 2017 12 (a) Describe the different ways Joanne could carry out her observation of the new system. … … … … …[2] (b) Discuss the advantages and disadvantages of using observation to evaluate a system. … … … … … … … … … … … …[5]

15 9713/12/M/J/17 © UCLES 2017 13 Using the stages of the systems life cycle as examples, describe how Gantt charts could be used to represent the progress of this project. … … … … … … … … … … … … … … … … … … … …[8]

16 9713/12/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 7 printed pages. © UCLES 2017 [Turn over Cambridge International Examinations Cambridge International Advanced Subsidiary and Advanced Level APPLIED INFORMATION & COMMUNICATION TECHNOLOGY 9713/12 Paper 1 Written A May/June 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 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.

9713/12 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 2 of 7 Question Answer Marks 1 A hard disk provides direct access. 3 A CD ROM stores several Gigabytes of data. A Blu-ray disk stores less data than a DVD. A magnetic tape has quicker data access than a hard disk. A magnetic tape is a suitable medium for storing backups of server data. 3 A CD R/W cannot be overwritten. Blu-ray disks are not used to store data. A pen drive can store more data than a CD. 3 Flash memory cards are used in mobile (cell) phones. 3 Solid state drives are more prone to failure than magnetic media. 4 Question Answer Marks 2 Data files are often converted to a common text format in order that they can be exported to another software package. 3 Validation is to check that data is reasonable. 3 Verification is to check that data is correct. A range check is a verification check. Comparing two versions of the same input data is a type of verification. 3 Charts are never exported from a database into another software package. OR and NOT are mathematical operators. It is only possible to sort data on one criterion. “Several to several” is a type of relationship. In order to create a relational database you have to identify a key field. 3 4

9713/12 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 3 of 7 Question Answer Marks 3 Four from: Spreadsheet/graphing software to store data to plot student progress charts Spreadsheet to store data and use conditional formatting to show student progress/targets Web browser to check the reports have loaded satisfactorily Word processing software to type up reports Email software to inform the Principal that the reports have been uploaded IM software to inform the Principal that the reports have been uploaded. 4 Question Answer Marks 4 Six from: Student answers are neater (using computers) so easier for teacher to read and mark Will take longer to carry out the test as students cannot type as fast as they can write Can include videos and sound to illustrate questions which will make the test more interesting for the students If the network crashes there will be a delay in the testing Students will find the test more interesting so less likely to skip school No need to worry about students forgetting writing equipment. 1 mark available for a reasoned conclusion. 6 Question Answer Marks 5(a) LEFT(E2,1) LEFT() 1 mark E2,1 1 mark 2 5(b) MID(E2,2,1) MID() 1 mark E2,2 1 mark ,1 1 mark 3 5(c) RIGHT(E2,1) RIGHT() 1 mark E2,1 1 mark 2 5(d) CONCATENATE (I2, H2, G2) CONCATENATE() 1 mark I2, H2 1 mark ,G2 1 mark 3

9713/12 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 4 of 7 Question Answer Marks 6 Five from: A right to object to processing that is likely to cause or is causing damage or distress A right to prevent processing for direct marketing A right to object to decisions being taken by automated means A right in certain circumstances to have inaccurate personal data rectified, blocked, erased or destroyed A right to claim compensation for damages caused by a breach of the legislation A right of access to a copy of the information comprised in their personal data An individual is entitled to be informed about – Whether a company is processing data about the individual The personal data which a company holds about them The purposes for which the data are being or are to be processed The companies/recipients or classes of companies/recipients to whom they are or may be disclosed To have communicated to them in an intelligible form – The personal data being held about the individual The source of the data If it is being used to evaluate matters relating to them such as, for example, performance at work, creditworthiness, reliability or conduct. 5 Question Answer Marks 7(a) A Evaporating unit 1 mark B Compressor 1 mark C Condensing unit 1 mark 3 7(b) Three from: If pressure of refrigerant is above preset value Microprocessor opens valve wider« «to increase the flow of refrigerant If pressure of refrigerant is below preset value Microprocessor makes valve opening narrower« «to reduce the flow of refrigerant. 3

9713/12 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 5 of 7 Question Answer Marks 8(a) Six from: Journalist types up/edits their story using word-processing software/DTP Journalist types up/edits their story using laptop/tablet computer Takes photographs using a digital camera/phone/tablet computer Import images from digital camera/phone Edit images using image editing software Connect laptop/tablet computer to internet using mobile phone/WIFI hotspot/dongle Email story to editor’s office Email photos separately using phone/laptop/tablet computer. 6 8(b) Six from: Edit/format the journalist’s story to remove mistakes Crop the images to remove unwanted material Resize the image to fill the layout Choose margin sizes Produce the layout/template of the magazine page Kerning – the process of adjusting the space between individual letters in words Adjusting the leading – the space between lines on a page Adjust the size/type of font in the bodytext Adjust the size/type of font in the headings/headlines Change the font type so it is easy to read Adjust the font size so it is small enough for stories to fit on a page Adjust the font size so it is large enough to read. 6 Question Answer Marks 9 Four from: Have less contact with colleagues More difficult to discuss ideas with colleagues Cannot see the editor daily« «so have less chance to impress editor to improve job prospects More difficult to attend meetings to keep up to speed with newspaper developments. 4 Question Answer Marks 10 Two from: Ultraviolet light is allowed to pass through the film negatives« «to expose the printing plate When the plates are exposed to light, a chemical reaction occurs This allows the light-sensitive coating on the aluminium to develop the image. 2

9713/12 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 6 of 7 Question Answer Marks 11 Eight from: He would need exception reports to: Make sure that somebody was not being paid too much Tell him if the system was working properly or not Let him know if the system was accepting duplicate data He would need to have financial reports so that: He could see trends in pay across the company He could compare pay across departments in the company He could see the pay structure within departments He could see how much the company was spending on paying the workers/tax authorities Examples Exception reports An employee earning an unusually large amount of money An employee who has been on an emergency tax code for a long period of time Two employees having the same national insurance number Financial reports Information about all employees of the company Information about employees in a given department Information about the salaries of all employees Total salaries of all employees National insurance contributions for all employees The total amount of national insurance contributions paid to the tax authorities The income tax that each employee has paid The total amount of income tax paid to the tax authorities The amount of money paid to each bank that employees have an account with All the earnings and deductions of employees The earnings and deductions of each employee by department A summary of all the totals of the earnings/deductions of each department. Must have reasons to gain more than 6 marks. 8 Question Answer Marks 12(a) Two from: Could observe users performing set tasks« «and record their progress using video recording Get a user to perform a task and measure the time it takes them to carry out the task. 2

9713/12 Cambridge International AS/A Level – Mark Scheme PUBLISHED May/June 2017 © UCLES 2017 Page 7 of 7 Question Answer Marks 12(b) Five from: Observation gives you an overall view of the whole system Observer can see how separate tasks overlap Can see how workers interact Can see if the methods being used are efficient Does not give you an opportunity to find out what users think of the new system Some people who know they are being observed change the way they work 1 mark is available for a reasoned conclusion. 5 Question Answer Marks 13 Eight from: You would have a time axis horizontally A list of stages of the project/systems life cycle vertically Some activities would be in sequence horizontally Some activities would be in parallel vertically Examples of sequential activities would be Analysis, followed by Design followed by Development, Testing, Implementation then Evaluation One mark for any two individual examples of parallel activities within different stages of the systems life cycle (one from each of Analysis, Design, Development, Testing, Implementation, Evaluation e.g. Analysis –interviews, questionnaires, examining documents, observation). One mark for any two individual examples of sequential activities from different stages of the systems life cycle (e.g. Designing the required data structures and creating the data structures). 8