Cambridge IGCSE Computer Studies 0420 — 2014 May/June Paper 3 · Variant 1

This document consists of 13 printed pages and 3 blank pages. IB14 06_0420_31/4RP © UCLES 2014 [Turn over *3575864091* Cambridge International Examinations Cambridge International General Certificate of Secondary Education COMPUTER STUDIES 0420/31 Paper 3 Alternative to Coursework May/June 2014 1 hour 30 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. You may use an HB pencil for any diagrams, graphs or rough working. Do not use staples, paper clips, glue or correction fluid. DO NOT WRITE IN ANY BARCODES. There is one compulsory question on this paper. Each part must be answered in the space provided. No marks will be awarded for using brand names of software packages or hardware. You are advised to spend at least 20 minutes reading the information at the start of question 1 since this information is needed to answer all the sections in this question. All answers must refer to this information system. The number of marks is given in brackets [ ] at the end of each part question. The maximum number of marks is 60.

2 © UCLES 2014 0420/31/M/J/14 In this question you are asked to read about: • an existing manual, paper-based system for people to book by telephone a ride on a Ferris wheel at a time of their choice, • the online computer-based booking system proposed to replace it. You are given a description of both the existing system and the proposed new online booking system. Description of the existing system The Ferris wheel takes half an hour to rotate and there are 40 pods that can contain up to 8 people. People can book their ride on the Ferris wheel over the telephone, between 24 hours and 12 months in advance, or on the day at a staffed kiosk next to the Ferris wheel. Tickets booked in advance are posted or can be collected on the day from the staffed kiosk. Tickets are timed at half-hour intervals. The Ferris wheel and the telephone booking system operate from 10:00 to 22:30. People with tickets are asked to arrive at the start of their half-hour slot. The tickets are checked by staff, who then direct people to their pod when it arrives. When a telephone booking is made, the following details are always required: • date of the ride • time of the ride • number of people, maximum 8 • details of the person making the booking o name o address o telephone number • tickets to be posted or collected. The diary for the Ferris wheel is updated and payment is taken using a credit/debit card over the telephone. The tickets are posted to the person who has made the booking or put on one side for collection on the day. When a booking is made at the kiosk, the following details are required: • date of the ride • time of the ride • number of people, maximum 8. Payment is taken using a credit/debit card or cash and the tickets are handed over straight away.

3 © UCLES 2014 0420/31/M/J/14 [Turn over Description of the proposed online computer-based Ferris wheel ride booking system The proposal is to replace the existing system with an online booking system. The new system will have advance booking and self-service touch screen kiosks for booking just before a ride. Tickets are issued for 10 minute intervals. Each booking is for a specific day, time and number of people. The ticket has a unique barcode and can be printed, or the barcode sent directly to a smartphone. People can book online, via the Internet, using a computer or a smartphone for between 2 hours and 12 months in advance. The touch screen kiosks at the venue are for bookings in the next hour. People using these are offered the next available time. The barcodes are automatically read at the entry to the wheel. People due to get on the wheel are directed to the correct pod for boarding. Slightly early arrivals are sent to a waiting area. If people arrive very early, entry is refused and a time to return is advised. Late entries are refused. A systems analyst is to be employed to review the existing manual method. The systems analyst will be responsible for drawing up an action plan for the new system. This will then be designed, tested and implemented. All the necessary documentation will also be produced, together with a full evaluation of the system performance 6 months after its introduction.

4 © UCLES 2014 0420/31/M/J/14 1 (a) The systems analyst has decided to use computer software to help check the progress of this project. State what type of software the systems analyst could choose and why it would be appropriate. Software Reasons [3]

5 © UCLES 2014 0420/31/M/J/14 [Turn over (b) The systems analyst wants to find out about the existing Ferris wheel booking system from people who have previously bought tickets using the telephone booking system. (i) State one method that would be appropriate and explain why the systems analyst should choose that method. Method Explanation [3] (ii) State one method that would not be appropriate and explain why the systems analyst would not choose that method. Method Explanation [3]

6 © UCLES 2014 0420/31/M/J/14 (c) Draw a design for a screen to be used to enter the required details online when a booking is made using a smartphone. [5]

7 © UCLES 2014 0420/31/M/J/14 [Turn over (d) Draw a design for a screen to be used to enter the required details when a booking is made using a touch screen kiosk at the Ferris wheel. [5] (e) State what details are accessed when the barcode is read at entry to the Ferris wheel. [3]

8 © UCLES 2014 0420/31/M/J/14 (f) Draw a systems flowchart, with a key, to show how the online computer-based Ferris wheel booking system should work. (i) Include in your systems flowchart: • what happens when a person makes a booking for a Ferris wheel ride. [5]

9 © UCLES 2014 0420/31/M/J/14 [Turn over (ii) Show in the key: • four symbols that you have used in your flowchart • a description of the purpose of each of these symbols. Key Symbol Description [4]

10 © UCLES 2014 0420/31/M/J/14 (g) The systems analyst wants to ensure that the payment taken over the Internet is secure. Explain what steps the systems analyst needs to take. [3] (h) The systems analyst is employing a programmer to write bespoke software for the new online computer-based Ferris wheel booking system. (i) Explain, with reasons, why the systems analyst should choose bespoke software. [3] (ii) State possible drawbacks to making this choice. [2]

11 © UCLES 2014 0420/31/M/J/14 [Turn over (i) The number of people in a single booking for a Ferris wheel ride must be a positive whole number between 1 and 8 inclusive. Give three different types of test data. Using the number of people in a single booking, give one example of each of these types. Explain why you chose each one as a good example. Type 1 Example 1 Explanation Type 2 Example 2 Explanation Type 3 Example 3 Explanation [9]

12 © UCLES 2014 0420/31/M/J/14 (j) Write an algorithm, using pseudocode or a flowchart, which: • inputs the number of people in a booking • checks the number is between 1 and 8 • outputs an error message if not • allows a maximum of 3 attempts. [6]

13 © UCLES 2014 0420/31/M/J/14 (k) (i) Describe one advantage to people booking a Ferris wheel ride when using the new online computer-based booking system compared to using the telephone booking system. [2] (ii) Describe one advantage to the Ferris wheel company of introducing the new online computer-based booking system compared to the telephone booking system. [2] (l) Describe how this new booking system should be evaluated. [2]

14 © UCLES 2014 0420/31/M/J/14 BLANK PAGE

15 © UCLES 2014 0420/31/M/J/14 BLANK PAGE

16 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. © UCLES 2014 0420/31/M/J/14 BLANK PAGE

CAMBRIDGE INTERNATIONAL EXAMINATIONS International General Certificate of Secondary Education MARK SCHEME for the May/June 2014 series 0420 COMPUTER STUDIES 0420/31 Paper 3, maximum raw mark 60 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 2014 series for most IGCSE, GCE Advanced Level and Advanced Subsidiary Level components and some Ordinary Level components.

Page 2 Mark Scheme Syllabus Paper IGCSE – May/June 2014 0420 31 © Cambridge International Examinations 2014 1 (a) One mark for identifying the software, two marks for appropriate reasons Software – Project Management Software Reasons e.g. – allows progress to be tracked – allows easy production and updating of Gantt/PERT charts – allows costs to be tracked – allows sharing by email Software – Spreadsheet Reasons e.g. – allows progress to be tracked – allows easy production and updating of Gantt/PERT charts – allows costs to be tracked – allows sharing by email [3] (b) (i) Method – questionnaire Explanation any 2 points – asks standard questions – ….so results can be easily/quickly analysed – no need for analyst to be present – more efficient for large groups – more efficient for dispersed groups – can provide incentives to return questionnaire – less expensive than interviewing (must be qualified) – respondents can remain anonymous – can be completed at a convenient time [3] (ii) none of the below are suitable, the explanation must match the method and explain why the method is not suitable Method – interview Explanation any 2 points – too many people to interview – ….so very time consuming – interviewees could be geographically dispersed – difficult to consolidate a variety of answers Method – observation Explanation any 2 points – many different locations – …as people would probably use a telephone in their own home – people may not want to be visited at home – very time consuming Method – document search Explanation any 2 points – wouldn’t obtain opinions from people – would have to rely on any written feedback already given to the company – …….would probably be very positive or negative – …….as customers do not usually write about their booking procedures [3]

Page 3 Mark Scheme Syllabus Paper IGCSE – May/June 2014 0420 31 © Cambridge International Examinations 2014 (c) Content – appropriate title e.g. Ferris Wheel Ride Booking – (calendar) for selection of day – dropdown menu for times – (dropdown menu) for number of people – entry of name/ address/ telephone number – option to post/collect tickets One mark for any one of these to a maximum of 4 marks Layout – screen is well laid out e.g. heading, use of company logo etc. – screen not to cluttered or too empty – order of boxes etc. is logical – clearly a smart phone screen One mark for any one of these to a maximum of 2 marks Maximum total marks 5 [5] (d) Content – appropriate title e.g. Ferris Wheel Ride Booking – dropdown menu/select on screen for number of people – payment method etc. – One mark for any one of these to a maximum of 3 marks (–1 if any un-necessary information on screen) Layout – screen is well laid out – clearly a touch screen Maximum total marks 5 [5] (e) Details Any three from: – day – time – number of people – pod allocated [3]

Page 4 Mark Scheme Syllabus Paper IGCSE – May/June 2014 0420 31 © Cambridge International Examinations 2014 (f) (i) One mark for per process, max 2 – Display/check available booking slots/date and time – Update booking slots/date and time – Taking payment – Emailing/sending to smart phone the barcode/ticket One mark per input, max 2 – Date, time of booking, number of people, email or post – Personal details, name address, phone no, email – Credit card details One mark per data store – Ferris wheel bookings – Personal details – database (only if none of the above are given) One mark per output – available booking slots/date and time (on screen) – Ticket with barcode [5] (ii) One mark per symbol and description, must be used in systems flowchart Hard disk (file) Connector (a link to or from another part of diagram) Input/Output operation Visual Display Unit (Monitor) Terminator (Start and end of the flow diagram) Data processing operation Document output (printed hard copy) Manual input (e.g. keyboard) Communication line (e.g. telephone line) [4] (g) One mark per point – Encrypt the data – Use SSL (secure socket layer) – Use HTTPS: – Use secure cookies – Make use of passwords (and user names) – Make use of firewalls – Anti-malware allow example e.g. anti-virus – CAPTCHA – test to check whether user is human [3]

Page 5 Mark Scheme Syllabus Paper IGCSE – May/June 2014 0420 31 © Cambridge International Examinations 2014 (h) (i) up to three points from e.g. – can be tailored to the meet the requirements for Ferris Wheel ride booking – in contact with the actual programmers if there is a problem – software can develop as it is used – only contains required features [3] (ii) up to two points from e.g. – not immediately available – more expensive to develop than purchasing “off-the-shelf” software – might not be fully tested – no Internet tutorials available – no support helpline available [2] (i) One mark per type, one mark per example must be for number of people, one mark per reason must match example. The following are examples only there are many correct answers. – Normal – 3 – this checks that system can accept appropriate inputs – Erroneous/abnormal – –2 – checks that negative numbers are rejected – extreme/boundary – 1 – checks that extreme data is accepted/boundary data treated appropriately [9]

Page 6 Mark Scheme Syllabus Paper IGCSE – May/June 2014 0420 31 © Cambridge International Examinations 2014 (j) Marking points – Initialisation – Loop control – Input number of people inside loop – Check in range 1 – …..to 8 – If not in range – Output error message – Increment error count – If in range – Reset error count – Exit if 3 attempts have been made Sample algorithm error_count =0 (1) repeat input number_of_people (1) if number_of_people < 1 or number_of_people > 8 (2) then print “Number of people booked must be between 1 and 8” (1) error_count = error_count +1 (1) else error_count =0 (1) until error_count =0 or error_count =3 (1) if error_count =3 then exit (1) [6] (k) (i) One advantage to the person booking with a matching reason from e.g. – Can book at any time – Website open 24/7 unlike phone line – Can book from anywhere – Use of mobile technology [2] (ii) One advantage to the Ferris Wheel company with a matching reason from e.g. – Need less staff – No telephone booking staff required/less staff required for kiosks – Better management of bookings –10 minute timed starts rather than half hour ones [2] (l) up to two points, must refer to Ferris wheel bookings, from – consider if objectives of new system have been met – look at results from tests – discuss with company whether or not new system works – ask the people booking whether or not the new system was easy to use – compare usage before and after. [2]