Cambridge IGCSE Computer Studies 0420 — 2013 May/June Paper 3 · Variant 2

This document consists of 12 printed pages. IB13 06_0420_32/3RP © UCLES 2013 [Turn over *2476332174* For Examiner's Use UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS International General Certificate of Secondary Education COMPUTER STUDIES 0420/32 Paper 3 Alternative to Coursework May/June 2013 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 a soft pencil for any diagrams, graphs or rough working. Do not use staples, paper clips, highlighters, 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. www.XtremePapers.com

2 © UCLES 2013 0420/32/M/J/13 For Examiner's Use In this question you are asked to read about: • an existing manual, paper-based system for people to book a cruise, • the web-based semi-automatic cruise booking system that is intended to be introduced as a replacement. You are given a description of both the existing and the intended new web-based computerised system. Description of the existing system People wishing to book a cruise are sent a brochure with pictures and details of the cruises available. There is a plan of each cruise ship in the brochure showing all the cabins available. Each cruise ship has several sailing dates and different types of cabin. Each cruise has a unique brochure number. A 50% deposit is required when the cruise is booked; the remainder must be paid 10 weeks before the cruise is due to start. When a person wants to book a cruise they select a cruise ship and sailing date from the brochure; then ring up the company to ask if there are cabin(s) available for the cruise chosen. The telephone booking line is open Monday to Saturday from 08:00 to 20:00 hours. A plan showing all the cabins available on the cruise ship is kept for each cruise showing the cabins that have already been booked and those still available. If the cabin(s) chosen are available then the booking is agreed; if they are unavailable then any other cabins available for that sailing are offered as an alternative. When the booking is agreed, the following details are always required: • cruise brochure number • number and types of cabins booked • names of people in the cruise group • details of person booking the cruise o name o address o telephone number o email address The following may be required: • age of each child in the cruise group under 18 The plan of the cruise ship for that cruise is updated with the cabins marked as booked and payment for the deposit is taken using a credit/debit card over the telephone. A receipt for the deposit, confirmation of the booking and details of the cruise are posted to the person who has booked the cruise. The final payment is taken 10 weeks before the cruise is due to start.

3 © UCLES 2013 0420/32/M/J/13 [Turn over For Examiner's Use Description of the proposed web-based system The intention is to replace all the paperwork by introducing a web-based cruise booking system which will contain all the information described above. It will allow people to book their cruise online, process secure debit/credit card payments; receive receipts and other paperwork via email attachments. The new cruise booking system will have a website that contains all the details that were available in the brochure. For each cruise, there will be a cruise ship cabin plan showing the cabins still available to book and the price of each cabin. There will be a search facility available so that cruises can be viewed by: • cruise ship • duration of cruise • area of cruise • price • availability of cabins In the new system, a person will use this website to choose a cruise. When the booking is confirmed and the deposit paid they will receive a receipt for the deposit, confirmation of the rental and details of the cruise via an email attachment. The final payment will be taken 10 weeks before the cruise is due to start. 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 web-based system. This will then be designed, built, tested and implemented. Technical documentation will be produced. Six months after the introduction of the new system, a full evaluation of its performance will be made.

4 © UCLES 2013 0420/32/M/J/13 For Examiner's Use 1 (a) The systems analyst has decided to use project management software to produce a Gantt chart to check the progress of this project. Give three reasons why the systems analyst decided to do this. Reason 1 Reason 2 Reason 3 [3] (b) To gather information about the existing manual system, the systems analyst decides to use a questionnaire for the people booking a cruise. Explain why the method is appropriate in this case. [2] State one other method that the systems analyst could use. [1]

5 © UCLES 2013 0420/32/M/J/13 [Turn over For Examiner's Use (c) State three items of hardware (other than computer, keyboard and screen) someone may need to book a cruise online. Justify your choice for each item. Item 1 Reason Item 2 Reason Item 3 Reason [6]

6 © UCLES 2013 0420/32/M/J/13 For Examiner's Use (d) State four features you would expect the website for cruise booking to provide. Justify why each feature is required on this website. Feature 1 Reason Feature 2 Reason Feature 3 Reason Feature 4 Reason [8]

7 © UCLES 2013 0420/32/M/J/13 [Turn over For Examiner's Use (e) Draw the following systems flowchart symbols. Process Merge Document output Hard disk (file) [4]

8 © UCLES 2013 0420/32/M/J/13 For Examiner's Use (f) Draw a systems flowchart to show how the web-based cruise booking system should work. Include: • what happens when a person makes an enquiry • what happens when a cruise is booked [8]

9 © UCLES 2013 0420/32/M/J/13 [Turn over For Examiner's Use (g) Write an algorithm, using pseudocode or a flowchart, which: • asks how many children there are under the age of 18 • requests the name of each child under 18 • prints each name • allows the name to be re-input if there is an error [7]

10 © UCLES 2013 0420/32/M/J/13 For Examiner's Use (h) The systems analyst wants to ensure that the data collected when a cruise is booked is kept secure. Explain what steps the systems analyst needs to take. [3] (i) Describe a test strategy for the new web-based cruise booking system. [4]

11 © UCLES 2013 0420/32/M/J/13 [Turn over For Examiner's Use (j) Give two sets of test data that could be used to test the booking process. Justify your choice for each set of test data. A set of test data includes all the items required to make a booking. Set 1 Reason Set 2 Reason [8]

12 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. University of 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 2013 0420/32/M/J/13 For Examiner's Use (k) State three methods that could be used to implement the new cruise booking system. Method 1 Method 2 Method 3 Choose the most suitable method from the three you gave above and explain why you have chosen this method. Method chosen Reasons for choice [6]

CAMBRIDGE INTERNATIONAL EXAMINATIONS International General Certificate of Secondary Education MARK SCHEME for the May/June 2013 series 0420 COMPUTER STUDIES 0420/32 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 2013 series for most IGCSE, GCE Advanced Level and Advanced Subsidiary Level components and some Ordinary Level components. www.XtremePapers.com

Page 2 Mark Scheme Syllabus Paper IGCSE – May/June 2013 0420 32 © Cambridge International Examinations 2013 1 (a) One mark per reason, any three of the following max 3 marks: – show all stages/tasks to be done – show the critical path/links between tasks – show key project milestones – show number of days to complete a task – show estimated time to complete project – track the actual progress made …. – …compare it to the original estimate – project management software allows for easy production/updating of Gantt charts – allows sharing of information – ensure project kept to an agreed timescale – ensure project is kept to an agreed budget [3] (b) One mark per reason, any two of the following max 3 marks: – 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 [2] any one of the following – interview – observation – document search [1]

Page 3 Mark Scheme Syllabus Paper IGCSE – May/June 2013 0420 32 © Cambridge International Examinations 2013 (c) One mark per item of hardware up to three items, one mark per reason for this case study. Max 6 marks. – laptop – to use wifi to connect to a wireless LAN/Wifi hotspot or connect to the Internet/access cruise website – printer – to print out receipt, confirmation, details of cruise, email – mouse/touch screen – for selection of cabin/cruise – tablet – alternative to a pc/ to connect to the Internet/access cruise website – mobile/smart phone – alternative to a pc/ connect to the Internet/to access cruise website – credit/debit card reader – to make payments using magnetic strip or chip and pin – router – to connect to the Internet/access cruise website – modem – to convert data for transmission over telephone (communication) lines or to connect to the Internet/access cruise website – network interface card/NIC/network adapter – to access a wired or wireless network [6] (d) One mark per feature up to four features, one mark per justification why the feature is required for this case study. Max 8 marks – Search facility – to view/find cruises according to different criteria – Login – for people who have used the site to book a cruise before – Secure credit card payment – to accept payment for deposit – Virtual tours of cruise ships – to give the idea of being on-board – Testimonials from previous customers – to give an independent review of a cruise – Interactive diagrams showing the layout of each cruise ship – to allow for easy choice of available cabins – Online forms – for completion of cruise booking – Multimedia e.g. sound, video clip etc – to provide ‘real’ information about ships and cruises [8]

Page 4 Mark Scheme Syllabus Paper IGCSE – May/June 2013 0420 32 © Cambridge International Examinations 2013 (e) One mark per correct symbol Process Merge Document Hard disk (file) [4] (f) One mark per data store, max 2 – Cruise Ship details – Cruise details – Bookings – Personal details – database (only if none of the above are given) One mark for per process, max 3 – Selection of/choosing cruise – Checking availability of cabin(s)/searching for free cabins – Booking cruise/selected cabins for a cruise – Storing details of booking/update booking file/update cabins booked – Process debit/credit card payments/payment of deposit – Email confirmation/cruise details/receipt One mark per input, max 3 – Cruise number/ID – number and type of cabins – Personal details, name address, phone no, email – Credit/debit card details – Cruise party details/names of people in cruise group, age of children under 18 One mark per output, max 3 – Diagram showing cabins booked/available (screen not paper) – Confirmation of booking/rental/personal details – Cruise details – Price of each cabin/total price for cruise – Receipt for deposit [8]

Page 5 Mark Scheme Syllabus Paper IGCSE – May/June 2013 0420 32 © Cambridge International Examinations 2013 (g) Marking points, one mark per point, max 7 Prompt for number of children under 18 Input number of children outside loop Name entry loop need correct condition Input child’s name inside a loop Print child’s name inside a loop Check for correct name Working mechanism for re-input e.g. if or repeat Sample algorithm print “How many children are there in the cruise party?” (1) input number_of_children (1) for count =1 to number_of_children print “Enter name of child” (1) repeat input name_of_child (1) print name_of_child (1) print “Is the name correct? Please enter Y or N” input correct (1) until correct =”Y” next count (1) [7] (h) One mark per point, max 3 – Encrypt the data – Use anti-virus/anti-spyware software – Vet any staff who have access to the data – Make use of firewalls – Make use of passwords – Make use of access rights – Provision of secure protocol e.g. HTTPS [3] (i) One mark per point Test data need type and valid expansion max 2 – normal test data has known outcomes – extreme/boundary test data checks validation rules – abnormal/erroneous test data should produce error messages or – mention of normal, abnormal/erroneous, and extreme/boundary data Types of testing max 2 – Black box – White box – System – Alpha – Beta – User etc. Additional testing – testing that the cruise booking system meets the requirements – volume testing [4]

Page 6 Mark Scheme Syllabus Paper IGCSE – May/June 2013 0420 32 © Cambridge International Examinations 2013 (j) Two data sets, two marks per data set, two marks for the reason for choosing the data set. Max 8 marks. Each data set must include • cruise brochure number • number of cabins • types of cabins booked • names of people in the cruise party • name of person booking the cruise • address of person booking the cruise • telephone number of person booking the cruise • email address of person booking the cruise Sample data set: Cruise number: CR12; Types and numbers of cabins: 1 DBL 1 SGL; Names of people in cruise party: Alice Tan, Ken Tan, Kylie Tan; Name of person booking cruise: Alice Tan: Address of person booking cruise: 57 Sing Ling Gardens, Singapore; ‘phone no. of person booking cruise: 7668831; Email address of person booking cruise: alicetan@hotmail.com Reason: – normal data – that will be accepted Sample data set: CR12; 1 DBL 1 SGL; (types and numbers of cabin) Alice Tan, Ken Tan; Alice Tan: 57 Sing Ling Gardens, Singapore; 7668831; alicetanhotmail.com Reason: – that will not be accepted – an error message should be given – too few people and email address not in the right form [8]

Page 7 Mark Scheme Syllabus Paper IGCSE – May/June 2013 0420 32 © Cambridge International Examinations 2013 (k) one mark per method, max 3 Methods: – Direct changeover – Parallel implementation – Phased implementation – Pilot implementation max three marks for reasons given for the best choice, these must match the method chosen (must be one of the three given) and be appropriate for this system Reasons: Direct changeover e.g. – no need to run 2 booking systems side by side – immediate benefits from new booking system – less disruptive for staff/people booking cruises – more likely to work since it should have been fully tested first Parallel implementation e.g. – good for training staff booking cruises – since both systems can be compared – if new system fails have old manual system as a back up Pilot implementation e.g. – makes sure system fully works before adopting for another ship – can revert to old manual system – ……as still in operation for booking cruises on other ships Phased implementation e.g. – part of system introduced initially for trials – if it is OK, gradually introduce other parts of the new system – if a problem occurs, can stop using it any stage – allows staff/people booking cruises to gain confidence in its operation [6]