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

This document consists of 11 printed pages and 1 blank page. IB13 06_0420_33/FP © UCLES 2013 [Turn over *8107056863* For Examiner's Use UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS International General Certificate of Secondary Education COMPUTER STUDIES 0420/33 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/33/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 rent a holiday villa for a week of their choice, • the web-based semi-automatic rental 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 rent a holiday villa are sent a brochure with pictures and details of the holiday villas available to rent. Each holiday villa has a unique brochure number. Each holiday villa can be rented for one week; a deposit of 25% is required when the rental is agreed, the remainder must be paid 4 weeks before the rental is due to start. When a person wants to rent a holiday villa they select a holiday villa from the brochure; then ring up the company to ask if the holiday villa is available for the week chosen. The telephone line is available Monday to Saturday from 08:00 to 20:00 hours. A diary is kept for each holiday villa showing the weeks that have been already rented and those still available for rental. If the holiday villa is available then the rental is agreed, if it is unavailable then other similar holiday villas are offered as an alternative. When a rental is agreed, the following details are always required: • holiday villa brochure number • rental week • number of people in rental group aged 18 and over • number of children under 18 • details of person renting the holiday villa o name o address o telephone number The following may be required: • age of each child under 18 The diary for the holiday villa is updated and payment for the deposit is taken using a credit/debit card over the telephone. A receipt for the deposit, confirmation of the rental and details of the holiday villa are posted to the person who has booked the holiday villa. The final payment is taken 4 weeks before the rental is due to start.

3 © UCLES 2013 0420/33/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 holiday villa rental system which will contain all the information described above. It will allow people to rent their holiday villas online, process secure debit/credit card payments; receive receipts and other paperwork via email attachments. The new holiday villa rental system will have a website that contains all the details that were available in the brochure. For each holiday villa there will be a calendar for the next 18 months showing the weeks still available for rental and the price per week. There will be a search facility available so that holiday villas can be viewed by: • number of people accommodated • location • price • availability In the new system, a person will use the holiday villa website to choose a villa to rent for a week. When the rental is confirmed and the deposit has been paid they will receive a receipt for the deposit, confirmation of the rental and details of the holiday villa via an email attachment. The final payment will be taken 4 weeks before the rental 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/33/M/J/13 For Examiner's Use 1 (a) The systems analyst has decided to use project management software to produce a PERT 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) The systems analyst wants to find out about the existing rental system from the people who have used it to rent villas. (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 should not choose that method. Method Explanation [3]

5 © UCLES 2013 0420/33/M/J/13 [Turn over For Examiner's Use (c) Draw a design for a screen to be used to enter the required details online when a villa rental is agreed. [8] (d) What extra information is needed in addition to that given in the list of details always required? Why is this information needed? Information Why it is needed [3]

6 © UCLES 2013 0420/33/M/J/13 For Examiner's Use (e) Draw a systems flowchart, with a key, to show how the web-based rental system should work. (i) Include in the key: • 4 symbols that you have used in your flowchart • a description of the purpose of each of these symbols Key Symbol Description [4]

7 © UCLES 2013 0420/33/M/J/13 [Turn over For Examiner's Use (ii) Include in your systems flowchart: • what happens when a person makes an enquiry • what happens when a rental is agreed [8]

8 © UCLES 2013 0420/33/M/J/13 For Examiner's Use (f) The systems analyst wants to ensure that the deposit and final payment taken over the Internet are secure. Explain what steps the systems analyst needs to take. [3] (g) The systems analyst is employing a programmer to write bespoke software for the new web-based villa rental system. (i) Explain with reasons why the systems analyst should make this choice. [3] (ii) What drawbacks could there be to making this choice? [2]

9 © UCLES 2013 0420/33/M/J/13 [Turn over For Examiner's Use (h) The number of children under 18 in the rental group must be a positive whole number between 0 and 5 inclusive. Give two different types of test data. Using the number of children in the rental 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 [6]

10 © UCLES 2013 0420/33/M/J/13 For Examiner's Use (i) Write an algorithm, using pseudocode or a flowchart, which: • inputs the number of children under 18 • checks the number is between 0 and 5 • outputs an error message if not • allows a maximum of 3 attempts [6]

11 © UCLES 2013 0420/33/M/J/13 For Examiner's Use (j) Describe three advantages to people booking the holiday villas when using the new web-based system compared to using the brochure. 1 2 3 [6] (k) Describe how the new villa rental system should be evaluated. [2]

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/33/M/J/13 BLANK PAGE

CAMBRIDGE INTERNATIONAL EXAMINATIONS International General Certificate of Secondary Education MARK SCHEME for the May/June 2013 series 0420 COMPUTER STUDIES 0420/33 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 33 © Cambridge International Examinations 2013 1 (a) One per reason, max 3 marks: - analyse the critical path for a complex problem with many tasks - track the actual progress made and compare it to the original estimate - project management software allows for easy production and updating of PERT charts - show all stages/tasks to be done - 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 - allows sharing of information - ensure project kept to an agreed timescale - ensure project is kept to an agreed budget [3] (b) (i) Method - Questionnaire/survey 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 customers to interview - …so very time consuming - 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 don’t usually write about their rental procedures [3]

Page 3 Mark Scheme Syllabus Paper IGCSE – May/June 2013 0420 33 © Cambridge International Examinations 2013 (c) Content - appropriate title e.g. Holiday Villa Rental - dropdown menu for villa number - calendar for selection of rental week - dropdown menu for number of people aged 18 or over - dropdown menu for number of children under 18 - entry of name - entry of address - entry of telephone number - entry of email address - login - option to confirm - secure payment - contact us option - terms and conditions One mark for any one of these to a maximum of 7 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 - font size is appropriate and readable - clearly a computer-based form One mark for any one of these to a maximum of 3 marks [8] Maximum total marks 8 (d) Information - email address Why required any 2 points - to send receipt for deposit - …details of the holiday villa - ….confirmation of rental - reminder of final payment - very time consuming [3]

Page 4 Mark Scheme Syllabus Paper IGCSE – May/June 2013 0420 33 © Cambridge International Examinations 2013 (e) (i) 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] (ii) One mark per process, max 3: - Selection of villa - Checking availability - Updating weeks rented - Creation of rental information - Taking deposit/checking credit card - Email confirmation/villa details/receipt One mark per input, max 3 - Villa information, number and rental week - Personal details, name address, phone no, email - Credit card details - Rental party details One mark per data store, max 2 - Villa details - Villa weeks rented/booked - Personal details - database (only if none of the above are given) One mark per output, max 3 - Availability of villa (screen not paper) - Confirmation - Receipt for deposit - Villa details [8]

Page 5 Mark Scheme Syllabus Paper IGCSE – May/June 2013 0420 33 © Cambridge International Examinations 2013 (f) One mark per point - Encrypt the data - Use SSL (secure socket layer) - Use secure cookies - Make use of passwords - Make use of firewalls [3] (g) (i) up to three points from e.g. - can be tailored to the meet the requirements for villa rental - in contact with the actual programmers if there is a problem - software can develop as it is used - doesn’t contain unwanted features [3] (ii) up to two points from e.g. - not immediately available - more expensive to develop than purchasing “off-the-shelf” software - not fully tested - no Internet tutorials available - no support helpline available [2] (h) For each of two types of test data One mark per type, one mark per example must be appropriate to this system and match type, one mark per reason must match example. The following are examples only there are many correct answers. - Normal - 1 - this checks that system can accept appropriate inputs - Abnormal/erroneous - -2 - checks that negative numbers are rejected - Extreme/boundary - 0 - checks that boundary/extreme data is accepted [6]

Page 6 Mark Scheme Syllabus Paper IGCSE – May/June 2013 0420 33 © Cambridge International Examinations 2013 (i) Marking points - Initialisation - Loop control - Input number of children inside loop - Check in range 0 - …..to 5 - Output error message - Increment error count - Exit if 3 attempts have been made Sample algorithm error_count =0 (1) repeat input number_of_children (1) if number_of_children < 0 or number_of_children > 5 (2) then print “Number of children must be between 0 and 5” (1) error_count = error_count +1 (1) until error_count =0 or error_count =3 (1) if error_count =3 then exit (1) [6] (j) Up to three advantages with a matching reason from case study e.g. - Can book at anytime - Website open 24/7 unlike phone line - Easier to check availability - Website has a search facility for availability - Easier to select villas using different criteria - Web site has a search facility with several criteria [6] (k) up to two points 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 renting whether or not the new system was easy to use - compare usage before and after. [2]