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

This document consists of 13 printed pages and 3 blank pages. DC (FD) 110076 © UCLES 2015 [Turn over Cambridge International Examinations Cambridge International Advanced Subsidiary and Advanced Level * 3 9 1 1 8 0 5 8 6 4 * APPLIED INFORMATION AND COMMUNICATION TECHNOLOGY 9713/12 Paper 1 May/June 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 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 of each question or part question. The businesses described in this paper are entirely fictitious.

2 9713/12/M/J/15 © UCLES 2015 Scenario 1 Questions 1, 2, 3, 4 and 5 XYA is a company in a developing country that buys and sells steel. They employ a number of sales staff to phone potential customers in order to sell their steel. They are seeking to save costs and have asked a number of their sales staff to work from home. Temperatures are fairly low in the winter so sales staff tend to have central heating systems in their homes. Regular staff meetings are planned to take place using phone conferencing which the manager Ibrahim will organise.

3 9713/12/M/J/15 © UCLES 2015 [Turn over 1 Tick the four statements which are benefits to the company of workers working from home. Benefit  Workers will not have to work as hard as if they were in an office 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 There would be no distractions for workers preventing them from working Lower costs as company can rent smaller offices The workforce would probably be happier so there would be improved motivation to work and increased productivity It would be easier to sell steel The cost to the company of the phone calls would be cheaper as home phone charges are lower More staff would be retained so money would not have to be spent on training new staff [4] 2 Tick the four statements which are benefits to the company of using staff to make phone sales rather than advertising on a website. Benefit  You can reach a larger audience by phone than by using a website Running a website is cheaper than paying telephone operators They can be sure all targeted customers are reached as not everybody will see the website Phone calls always result in a successful sale They can contact customers whose internet speed is so slow they may not be able to use the website They will know accurately how many sales they have made You cannot get immediate feedback from your potential customers Customers would never buy steel using a website Websites can have video and photographs It is more personal so it might be easier to persuade customers to purchase steel [4]

4 9713/12/M/J/15 © UCLES 2015 3 Describe how a microprocessor makes use of the data from a temperature sensor to control a central heating system. … … … … … …[3] 4 Each sales person would need a PC and a monitor. They will need additional hardware and software to allow them to work from home. (a) Name, and describe the use of, three additional items of hardware. Each use must be different. 1 … … 2 … … 3 … …[3] (b) Name, and describe the use of, three items of software. Each use must be different. 1 … … 2 … … 3 … …[3]

5 9713/12/M/J/15 © UCLES 2015 [Turn over 5 Ibrahim is considering introducing video conferencing to replace phone conferencing. Describe the advantages and disadvantages of doing this. … … … … … … … …[4]

6 9713/12/M/J/15 © UCLES 2015 Scenario 2 Questions 6 and 7 A geography teacher wants to use computers to help students improve their learning and help with her lesson preparation. Computers will be used by other teachers in their teaching.

7 9713/12/M/J/15 © UCLES 2015 [Turn over 6 Describe the use of each of the following types of software that the geography teacher would use to prepare materials for her lessons. Each use must be different. Spreadsheet … … Web browser … … DTP … … Image editing … …[4] 7 Discuss the benefits and drawbacks to teachers and students of using computers in lessons to aid teaching and learning. … … … … … … … … … … … …[6]

8 9713/12/M/J/15 © UCLES 2015 Scenario 3 Questions 8, 9, 10, 11 and 12 RockICT has decided to combine its staff records. It currently has separate computerised personal and payroll details of all its staff. The payroll system runs using all the data on a weekly basis. Workers are paid according to how many hours they work in a week. On the new system human resources staff will need to be able to access records quickly. Joanne, a systems analyst, has collected a large amount of information about the existing system. The information will be analysed before the system is designed. RockICT requires its workers to have a duty of fidelity. It also has to follow government data protection rules when storing data about its workers. RockICT has hired Arty, an art and design company to produce CD covers for the albums its musicians produce.

9 9713/12/M/J/15 © UCLES 2015 [Turn over 8 (a) Give three items of information, not related to their pay, that will need to be stored on the master file about each member of RockICT staff. 1 … … 2 … … 3 … …[3] (b) Label the components of the following systems flowchart to show how the master file is updated. … … … … … … … … Old master file [4]

10 9713/12/M/J/15 © UCLES 2015 9 (a) Describe in detail two ways that Joanne will use a data flow diagram to identify suitable hardware for the new system. 1 … … … … 2 … … … …[4] (b) Describe how Joanne will identify the user and system requirements for the new system. … … … … … … … …[4]

11 9713/12/M/J/15 © UCLES 2015 [Turn over 10 (a) Describe what is meant by the indexed sequential method of storing data. Give reasons why it would be suitable in this scenario. Indicate which storage medium would be most appropriate to use. … … … … … … … … … … … …[6] (b) Joanne will need to design the file structure of the new system. Describe six steps involved in designing the file structure, without referring to the indexed sequential method of storing data. 1 … … 2 … … 3 … … 4 … … 5 … … 6 … …[6]

12 9713/12/M/J/15 © UCLES 2015 11 (a) Explain what is meant by duty of fidelity. … … … …[2] (b) Describe four rules which would be included in data protection legislation. 1 … … 2 … … 3 … … 4 … …[4] (c) Apart from following data protection rules and having a duty of fidelity, explain the responsibilities of the company and its workers with regard to the privacy of payroll data. … … … … … … … …[4]

13 9713/12/M/J/15 © UCLES 2015 12 Arty use graphics software to change images that have been imported into the software. (a) Name and describe two input devices which are used to import images for use in the CD covers. 1 … … 2 … …[4] (b) Name and describe four features of the graphics software used when changing the images. 1 … … 2 … … 3 … … 4 … …[4] (c) Describe two sources of images which would accompany the software when bought. 1 … … 2 … …[2] (d) The printing of the CD covers is now computer controlled. Describe two effects this had on the workers who used to be involved in the printing process. 1 … … 2 … …[2]

14 9713/12/M/J/15 © UCLES 2015 BLANK PAGE

15 9713/12/M/J/15 © UCLES 2015 BLANK PAGE

16 9713/12/M/J/15 © UCLES 2015 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. CAMBRIDGE INTERNATIONAL EXAMINATIONS Cambridge International Advanced Subsidiary and Advanced Level MARK SCHEME for the May/June 2015 series 9713 APPLIED INFORMATION AND COMMUNICATION TECHNOLOGY 9713/12 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 May/June 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 – May/June 2015 9713 12 © Cambridge International Examinations 2015 1 [4] Workers will not have to work as hard as if they were in an office 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
There would be no distractions for workers preventing them from working Lower costs as company can rent smaller offices
The workforce would probably be happier so there would be improved motivation to work and increased productivity
It would be easier to sell steel The cost to the company of the phone calls would be cheaper as home phone charges are lower More staff would be retained so money wouldn’t have to be spent on training new staff
2 [4] You can reach a larger audience by phone than by using a website Running a website is cheaper than paying telephone operators They can be sure all targeted customers are reached as not everybody will see the website
Phone calls always result in a successful sale They can contact customers whose internet speed is so slow they may not be able to use the website
They will know accurately how many sales they have made
You cannot get immediate feedback from your potential customers Customers would never buy steel using a website Websites can have video and photographs It is more personal so it might be easier to persuade customers to purchase steel

Page 3 Mark Scheme Syllabus Paper Cambridge International AS/A Level – May/June 2015 9713 12 © Cambridge International Examinations 2015 3 Three from: [3] Compares temperature from sensor to the pre-set value If sensor temperature is higher/lower than pre-set value microprocessor sends a signal… …to the actuator If lower, microprocessor/actuator switches heater on If higher, then microprocessor/actuator switches heater off 4 (a) Three from: [3] A router/modem to connect to the internet A fax machine to fax phone orders to main office A landline phone to communicate with manager/main office/customers A mobile phone in case landline phone is damaged A printer to print orders to be faxed Headset/touch phone to phone conference with the main office Microphone/speakers/headset to communicate with customers (b) Three from: [3] Word processor to type up orders Database software to edit customer details CTI software to communicate with customers Time management software to record hours of work E-mail software to send messages to colleagues 5 Four from: [4] Advantages You can see the facial expressions/body language of other participants You can see/amend/share documents that you want to discuss with each other Easier to identify whose turn it is/who wants to contribute next Once equipment is bought less expensive to run/set up/organise than a phone conference Disadvantages More expensive to buy hardware/software If there are problems with internet connection, conference may be interrupted More equipment needed so greater chance of problems Max three for all advantages/disadvantages 6 Four from: [4] Spreadsheet – prepare population statistics Web browser – look up resources for worksheets/students to use DTP – produce worksheets Image editing software to edit maps

Page 4 Mark Scheme Syllabus Paper Cambridge International AS/A Level – May/June 2015 9713 12 © Cambridge International Examinations 2015 7 Six from: [6] Benefits ICT make lessons more interesting/entertaining ICT make lessons more varied Internet allows students to investigate ideas Internet allows students to carry out research Neatness of students work makes it easier for teacher to mark ICT provides a more interactive learning environment Teachers can spend less time with students with special needs because of ICT resources/ ICT resources can help students with special needs Teachers have more varied teaching aids/can make use of multimedia in lessons Teachers can use/produce computer based tests/can use ICT to assess students’ performance/students can assess own performance Teachers can use spreadsheets/databases to record test scores/produce graphs of progress Easier to compare class/students’ performance/track progress Tests can be computer-marked saving teachers’ time Easier to monitor student activities using monitoring software Drawbacks Takes a lot of time to prepare ICT materials Can be difficult to ensure all students are on task if no monitoring software is available More resources are available so students might make inefficient use of these More difficult to co-ordinate activities Plagiarism can cause teachers’ problems Must have at least one of each to gain full marks 8 (a) Three from: [3] Name Contact details i.e. phone/address Holiday entitlement Job title Employee number/ID number/payroll number/works number Social security/national insurance number Department worked in Date employed Date of birth

Page 5 Mark Scheme Syllabus Paper Cambridge International AS/A Level – May/June 2015 9713 12 © Cambridge International Examinations 2015 (b) [1] [1] [1] [1] 9 (a) Two sets of statements from: [4] Look at the terminators and flow arrows in the DFD which show the volume of input data… …which leads to decisions on appropriate input devices Look at the terminators and flow arrows out of the system which indicate the quantity/ format of the output/required output… …which leads to decisions on appropriate output devices Look at the processes involved (in storing and analysing results)… …the processing requirements will be known … …which will give an idea about the size and speed of the processor required Look at the stores in the DFD which will show how much data needs to be stored… … the storage requirements will be known ….which is needed to identify the size and number of storage devices (b) Four from: [4] Using collected information/results of observation to see exactly what job each worker is doing Joanne will have interviewed payroll workers/manager to find their requirements Will use the DFD to come to a conclusion about the user/system requirements From user requirements she will produce a requirements specification… …list of the features of the system that is required Identify general requirements such as what the user wants the overall system to do Identify specific requirements Example of specific requirements Results of examining documents will help identify required hardware/software Results of observation will help identify required hardware/software Old master file Update process Reports New master file Transaction file

Page 6 Mark Scheme Syllabus Paper Cambridge International AS/A Level – May/June 2015 9713 12 © Cambridge International Examinations 2015 10 (a) Five from: [5] Table of indexes is stored The index will allow for direct access… …needed when accessing individual worker records quickly The records will be held sequentially to allow for serial access… …used to process all records one after the other Suitable because payroll will process all records one after the other Magnetic/hard disk would be most suitable [1] (b) Six from: [6] Type of database is chosen (flat file/relational) If it is going to be a relational database, number of tables is decided upon A key field to identify each record is chosen Relationships are designed/Entity Relationship Diagrams are designed Appropriate field names are chosen… …relating to data content of field and unique name Field data type is selected such as text, number, Boolean, appropriate to field contents Field lengths are chosen so that space/memory is not wasted, but leaves room for expansion Validation rules are designed Validation rules are chosen appropriate to field contents Validation error message(s) designed Field descriptions are included which adequately inform about field contents 11 (a) Two from: [2] Employee must be loyal to their employer…. …for as long as they are employed by the company Must not tell rival companies about their work Employee is free to use skills and knowledge acquired from company after they leave them (b) Four from, data must be: [4] Kept secure Fairly and lawfully processed Processed for limited purposes Adequate, relevant and not excessive Accurate and up to date Not kept longer than necessary Processed in accordance with the individual’s rights Not transferred to countries outside that country unless it has adequate protection for the individual interests of the individual or another person

Page 7 Mark Scheme Syllabus Paper Cambridge International AS/A Level – May/June 2015 9713 12 © Cambridge International Examinations 2015 (c) Four from: [4] Payroll workers must not share any payroll data with anybody/outside the organisation/other employees. Payroll workers should sign a confidentiality agreement/have a duty of confidence Information about an individual should not be passed to another organisation without permission of the individual Information should be anonymised where possible Information should be aggregated where possible 12 (a) Two matched pairs from: [4] Scanner Used to import hard copy images/photographs Digital camera Used to download photographs stored on the camera (b) Four from: [4] Cropping – removing a portion of the image Rotating – turning the image through an angle Flipping – getting a mirror image Filling – filling a shape with colour Drawing of lines and shapes Adding text in a variety of fonts (c) Two from: [2] Clip art library/gallery Photograph library/gallery Libraries of pre-prepared designs (d) Two from: [2] Increase in unemployment of print workers Re-training of print workers Change in working practices of print workers Print workers‘ skills will no longer be required