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

This document consists of 11 printed pages and 1 blank page. IB14 06_0420_32/4RP © UCLES 2014 [Turn over *1929645252* Cambridge International Examinations Cambridge International General Certificate of Secondary Education COMPUTER STUDIES 0420/32 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/32/M/J/14 In this question you are asked to read about: • an existing manual, paper-based system for people to book a tour of a famous author’s house, • the Internet-based booking system proposed to replace it. You are given a description of both the existing system and the proposed new Internet-based booking system. Description of the existing system Timed tickets for tours of a famous author’s house are issued, for a maximum of 10 people at 15 minute intervals from 10:30 to 15:00. Tickets for tours must be booked at least 1 week and up to 3 months in advance. Tickets are booked over the telephone and posted to the person making the booking. When a person wants to book a tour, they ring up the company to ask if the time and date is available. The telephone line is available Monday to Saturday from 10:00 to 15:00 hours. A diary is kept for the house showing the dates and times that have already been allocated and those still available. If there are spaces for the number of people, the booking is agreed. If not, similar times and dates are offered as alternatives. When a telephone booking is made, the following details are always required: • date of the tour • time of the tour • number of people, maximum 10 • details of the person making the booking o name o address o telephone number. The diary for the House tours 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.

3 © UCLES 2014 0420/32/M/J/14 [Turn over Description of the proposed Internet-based booking system for tours of a famous author’s house The proposal is to replace the existing system with an Internet-based booking system. This will include a touch screen terminal, installed in the car park, to allow bookings for house tours right up to the last minute. Tickets are still issued for 15 minute intervals. Each booking is for a specific day, time and number of people. Each ticket has a unique barcode and is emailed to the person who has made the booking. This ticket can be printed. The barcode can be sent directly to a smartphone as well. People can book online, via the Internet, using a computer or a smartphone for between 1 day and 12 months in advance. The touch screen terminal in the car park is for bookings that day. People using this terminal are offered the next available tour time. When a booking is made at the touch screen terminal, only the following detail is required: • number of people, maximum 10. Payment is taken using a credit/debit card or cash and the ticket is printed straight away. 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 Internet-based booking 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/32/M/J/14 1 (a) The systems analyst has decided to use project management software to produce a Gantt chart. The Gantt chart will be used 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) The systems analyst wants to find out about the existing tour booking system. (i) The systems analyst has decided to observe the staff taking telephone bookings. Explain why the systems analyst chose this method. [3] (ii) The systems analyst has decided to send a questionnaire to people who have made telephone bookings. Explain why the systems analyst chose this method. [3]

5 © UCLES 2014 0420/32/M/J/14 [Turn over (c) Draw a screen design for entering the required details when booking a tour in advance using a computer. [8] (d) Extra information will be needed for the Internet-based booking system, in addition to that required by the existing telephone booking system. Why is this information needed? Information Why it is needed [3]

6 © UCLES 2014 0420/32/M/J/14 (e) Draw a systems flowchart, with a key, to show how the Internet-based booking system for tours of a famous author’s house should work. (i) Include in your systems flowchart: • what happens when a person makes a booking. [5]

7 © UCLES 2014 0420/32/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]

8 © UCLES 2014 0420/32/M/J/14 (f) The systems analyst wants to ensure that the payments taken over the Internet are secure. Explain what steps the systems analyst needs to take. [3] (g) The systems analyst is buying “off-the-shelf” software for the new Internet-based booking system. (i) Explain, with reasons, why the systems analyst should choose “off-the-shelf” software. [3] (ii) State possible drawbacks to making this choice. [2]

9 © UCLES 2014 0420/32/M/J/14 [Turn over (h) The number of people in a tour group must be a positive whole number between 1 and 10 inclusive. Give three different types of test data. Using the number of people in a tour group, 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]

10 © UCLES 2014 0420/32/M/J/14 (i) Write an algorithm, using pseudocode or a flowchart, which: • inputs the number of people • checks the number is between 1 and the number of places left on a tour • outputs an error message if not • deducts the number of people from the number of places left on the tour. [6]

11 © UCLES 2014 0420/32/M/J/14 (j) This system needs to be thoroughly tested. Describe what types of testing should be used. [3] (k) State one method that could be used to implement this new system. Describe the method and give two reasons why it should be chosen for the new Internet- based booking system. Method Description Reason 1 Reason 2 [5]

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. 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/32/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/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 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 32 © Cambridge International Examinations 2014 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 chart • easier to use/understand (than a PERT chart) • allows sharing of information • ensure project kept to an agreed timescale • ensure project is kept to an agreed budget [3] (b) (i) One mark per reason, any three of the following max 3 marks: • gives first-hand knowledge of how system works • as analyst sees exactly what is done • …and so obtains reliable information • reduced disruption to work in progress/staff • little planning required etc. [3] (ii) One mark per reason, any three of the following max 3 marks: • can ask standard questions • …so results can be easily/efficiently/quickly analysed • respondents can remain anonymous • can respond at a convenient time • no need for analyst to be present • more efficient/less expensive for large groups • more efficient/less expensive geographically dispersed groups • incentives can be provided to return questionnaire etc. [3] (c) Content – One mark for any one of these to a maximum of 6 marks • appropriate title e.g. Author’s House Tours • calendar for selection of tour day • list of times for selection of tour time • (dropdown menu) for number of people in tour • entry of name • entry of address • entry of telephone number • entry of email address • option to confirm • secure payment/option to proceed to payment • submit • contact us option

Page 3 Mark Scheme Syllabus Paper IGCSE – May/June 2014 0420 32 © Cambridge International Examinations 2014 Layout • screen is well laid out e.g. heading, use of company logo etc. • screen not too cluttered or too empty • order of boxes etc. is logical • clearly a computer-based form One mark for any one of these to a maximum of 3 marks Maximum total marks 8 [8] (d) Information – email address / smart phone number Why required – any two points • to send confirmation of the tour • …and details of the tour • contact customer if there is a problem • send tickets/barcode for printing [3] (e) (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 • personal details, name, address, phone no, email • credit card details One mark per data store, max 2 • (author house) tour bookings • personal details • database (only if none of the above are given) One mark for output • available booking slots/date and time (on screen) • ticket with barcode [5]

Page 4 Mark Scheme Syllabus Paper IGCSE – May/June 2014 0420 32 © Cambridge International Examinations 2014 (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] (f) 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] (g) (i) Up to three points from e.g. • booking software immediately/readily available • already tried and tested • technical support online/by phone • usually compatible with other existing software • cheaper than developing bespoke software • large user base for mutual support [3] (ii) Up to two points from e.g. • cannot be tailored to the meet the requirements for the house tour booking system… • …employees may need to change their way of working • no contact with the actual programmers if there is a problem • may contain unwanted features [2]

Page 5 Mark Scheme Syllabus Paper IGCSE – May/June 2014 0420 32 © Cambridge International Examinations 2014 (h) One mark per data type, one mark per example of number of people in tour group for the data type, one mark per reason must match example and data type. The following are examples only there are many correct answers. • normal • 7 • this checks that system can accept appropriate inputs • erroneous • –2 • checks that negative numbers are rejected • extreme/boundary • 10 • checks that extreme data is accepted/boundary data treated appropriately [9] (i) Marking points any 6 - Input number of people (not inside a loop) - Check in range - 1 to number_of_places_left_on_tour - If not - Output error message - Otherwise - …..deduct number of people from number_of_places_left_on_tour Sample algorithm (worth all 7 marking points available) input number_of_people (1) if number_of_people < 1 or number_of_people > number_of_places_left_on_tour (2) then (1) print “Number of people must be fewer than the number of places left on this tour” (1) else (1) number_of_places_left_on_tour
number_of_places_left_on_tour - number_of_people (1) [6] (j) Two marks for the type of testing up to two types from e.g. • black box • white box • system • alpha • beta • user • testing that the system meets its requirements • volume testing One further mark for a description of one of the types of testing given [3]

Page 6 Mark Scheme Syllabus Paper IGCSE – May/June 2014 0420 32 © Cambridge International Examinations 2014 (k) One mark for chosen method Two marks for description of that method Two marks for reasons chosen, must match method chosen and be applied to the house tours. Method • Direct changeover Description • new system replaces old system immediately/overnight • no transition time/overlap Reason • no need to run 2 systems side by side so less expensive for the company running the house tours • immediate benefits to company from new system • less disruptive to booking staff • more likely to work when first installed since it will have been fully tested first Method • Pilot implementation Description • new system introduced for just type of house tour • then assessed before introducing for other house tours Reason • if the new system fails then only one type of house tour is affected • makes sure system fully works before adopting for another tour • can revert to old system as still in operation at other houses [5]