Cambridge IGCSE Computer Studies 0420 — 2013 Oct/Nov Paper 3 · Variant 2

This document consists of 13 printed pages and 3 blank pages. IB13 11_0420_32/FP © UCLES 2013 [Turn over *4709729700* For Examiner's Use UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS International General Certificate of Secondary Education COMPUTER STUDIES 0420/32 Paper 3 Alternative to Coursework October/November 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/O/N/13 For Examiner's Use In this question you are asked to read about: • an existing manual, paper-based system for parents to book and pay for their child to take part in a school trip, • a web-based semi-automatic booking and payment 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 Students wishing to go on a school trip take a form home for their parents to complete. There is a standard form that gives details of the trip, asks for the parent’s consent and shows a record of payments made.

3 © UCLES 2013 0420/32/O/N/13 [Turn over For Examiner's Use In addition a record of payments received from each student is kept in an accounts book in the school office. When a student brings in a payment it is recorded in the accounts book and on the consent form. If the full amount has not been received 4 weeks before the start of the trip then a reminder letter is sent to the parent. Description of the proposed computer-based system The intention is to replace all the paperwork by introducing a web-based semi-automatic booking and payment system which will contain all the information described above, but will allow parents to log on securely to the school’s intranet from a computer at home. In the new system, a parent is given a unique secure logon to complete the online consent form and to make payments using a credit/debit card. Every payment is confirmed by email and, once confirmed, shown on the online form. If the full amount has not been received 4 weeks before the start of the trip then an email reminder is sent to the parent. The record of payments is automatically transferred to the spreadsheet kept on the school office computer. 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 and user 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/O/N/13 For Examiner's Use 1 (a) The systems analyst needs to ensure that the project is delivered on time and on budget. Explain why the systems analyst has chosen to use a Gantt chart rather than a PERT chart to track the progress of this project. [2]

5 © UCLES 2013 0420/32/O/N/13 [Turn over For Examiner's Use (b) The systems analyst has decided to use the following methods to gather information about the existing manual system. • A questionnaire for the parents • An interview for the school office staff Explain why each of the methods used was appropriate for this manual system. A questionnaire for the parents: Explanation An interview for the school office staff: Explanation [4] State one other method that the systems analyst could use. [1]

6 © UCLES 2013 0420/32/O/N/13 For Examiner's Use (c) Use the following boxes to design two user-friendly screens for the web-based school trip booking and payment system. Screen 1 shows the details of the trip; screen 2 is the consent form. Explain what you did to make each screen user-friendly. (i) Screen 1 (school trip details) Explanation [5]

7 © UCLES 2013 0420/32/O/N/13 [Turn over For Examiner's Use (ii) Screen 2 (consent form) Explanation [5] (d) The systems analyst wants to ensure that the school intranet is secure from unauthorised use. Explain what steps the systems analyst needs to take. [3]

8 © UCLES 2013 0420/32/O/N/13 For Examiner's Use (e) Draw a systems flowchart, with a key, to show how the web-based school trip booking and payment system should work. (i) Include in the key: • 4 symbols used in your flowchart • A description of the purpose of each of these symbols Key Symbol Description [4]

9 © UCLES 2013 0420/32/O/N/13 [Turn over For Examiner's Use (ii) Include in your systems flowchart: • Completing the consent form • Making a payment • Checking for final payment [6]

10 © UCLES 2013 0420/32/O/N/13 For Examiner's Use (f) Write an algorithm, using pseudocode or a flowchart, which: • inputs the amount to be paid by a parent (AmountToPay) • adds this to the total amount already paid by that parent • checks the total amount paid does not exceed the total price of the trip • exits if this is the case • outputs the amount now outstanding • outputs appropriate prompts and messages You can assume: Price has already been set to the total price of the trip. Total has been set to the total amount already paid by a parent. [8]

11 © UCLES 2013 0420/32/O/N/13 [Turn over For Examiner's Use (g) Given a value of $600 for Price and a value of $440 for Total, suggest two values for AmountToPay that you would use to test your algorithm. Give a reason why you chose each value. Value Reason chosen Value Reason chosen [4] (h) Which method should the systems analyst use to provide the software for the new web-based system? Explain with reasons which method the systems analyst should choose. Method Reasons [4]

12 © UCLES 2013 0420/32/O/N/13 For Examiner's Use (i) Describe a test strategy for the new web-based school trip booking and payment system. [3] (j) State four items that should be included in the technical documentation supplied with this new system. For each one explain why it should be included. Item 1 Reason Item 2 Reason Item 3 Reason Item 4 Reason [8]

13 © UCLES 2013 0420/32/O/N/13 For Examiner's Use (k) State three ways to evaluate the new web-based school trip booking and payment system. [3]

14 © UCLES 2013 0420/32/O/N/13 BLANK PAGE

15 © UCLES 2013 0420/32/O/N/13 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. 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/O/N/13 BLANK PAGE

CAMBRIDGE INTERNATIONAL EXAMINATIONS International General Certificate of Secondary Education MARK SCHEME for the October/November 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 October/November 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 – October/November 2013 0420 32 © Cambridge International Examinations 2013 1 (a) One per reason, max 2 marks: – simple project – not a complex problem with many tasks – few inter task dependencies – timescale is more obvious – Gantt charts are easier to understand/PERT charts can be confusing – production of PERT charts can be expensive – PERT charts can be complicated to manage [2] (b) Up to three points from (i) Questionnaire for parents – asks standard questions – so results can be analysed easily/quickly – no need for analyst to be present – parents can complete at a time convenient to them – (parents) can remain anonymous – incentives to return questionnaire – inexpensive/more efficient method for large groups (of parents) Up to three points from interviewing for school office staff – allows questions to be tailored to the individual – can ask supplementary questions – can ask for clarification – staff may tell you things that you haven’t identified as issues Max 4 overall, but up to 3 for each part [4] (ii) Any one from – observation – document search [1]

Page 3 Mark Scheme Syllabus Paper IGCSE – October/November 2013 0420 32 © Cambridge International Examinations 2013 (c) (i) max three marks for design, one mark for trip details, max two marks for other screen design max two marks for explanation about user friendliness must relate to candidate’s design Screen Explanation – inclusion/entry of trip details: Destination Activities Date(s Cost – use of a suitable font to aid readability – use of drop down boxes for ease of selection – appropriate title – to clearly identify the screen – use of suitable picture(s) /logo/video clip – to make the screen more attractive/understandable /identifiable – navigation to consent form/ student details/parent details/payment – clear links through the process [5] (ii) max three marks for design, max two marks for explanation about user friendliness must relate to candidate’s design Screen Explanation – entry of student details Name Class – clear prompts/instructions for user (to improve accuracy of form filling) – highlighting any errors to show the parent where there are problems with the information entered – explanation of why data entry method used – entry of parent details: Name Address Telephone no – Consent – use of submit/reset – to clarify actions – email [5]

Page 4 Mark Scheme Syllabus Paper IGCSE – October/November 2013 0420 32 © Cambridge International Examinations 2013 (d) up to three points from: – use of login/passwords(keyed or biometric)/smart cards – use of firewall – anti-virus software – anti-hacking/pharming/phishing/spyware software [3] (e) (i) One mark per symbol and description Hard disk (database) 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 for per process, max 3: – Storing consent details – Updating parents’ payments – Transferring payments to school (trip) spreadsheet – Sending email confirmation of payments – Sending email reminder for final payments One mark per input, max 2 – Logon Details – Information for consent form/list of details – Payment details/debit or credit card details One mark per data store, max 2 – Pupil/Parent/Consent details – Trip details – Spreadsheet/payment details – Database/data store/storage (only if none of the above are given) One mark per output, max 2 – trip/consent details (screen not paper) – Confirmation of payment (email) – Request for final payment (email) [6]

Page 5 Mark Scheme Syllabus Paper IGCSE – October/November 2013 0420 32 © Cambridge International Examinations 2013 (f) up to eight marks from: Prompt to enter amount to pay Input amount to pay (Note only one mark if the first two statements are reversed) Check new total would not be greater than total price of trip Output error message if greater than Exit routine Update total amount Calculate amount outstanding Output appropriate message Output amount outstanding Sample algorithms print ″Enter amount to pay″ (1) input AmountToPay (1) Total = Total + AmountToPay (1) if Total > Price (1) then print “Payment is too large” (1) exit (1) AmountOutstanding = Price - Total (1) print ″Amount still outstanding″ (1) print AmountOutstanding (1) print ″Enter amount to pay″ (1) input AmountToPay (1) if AmountToPay + Total > Price (1) then print “Payment is too large” (1) exit (1) Total = Total + AmountToPay (1) AmountOutstanding = Price - Total (1) print ″Amount still outstanding″ (1) print AmountOutstanding (1) [8] (g) One mark per value suitable for amount paid, one mark per reason (the following two numbers are examples) – 100 – this checks that system processes appropriate inputs – 200 – rejected payment too large, error message produced – 160 – boundary/extreme data that is doesn’t produce an error message – 161 – boundary data that produces an error message [4]

Page 6 Mark Scheme Syllabus Paper IGCSE – October/November 2013 0420 32 © Cambridge International Examinations 2013 (h) one mark for the choice, three marks for reasons only (MUST match up with choice) existing software/off the shelf chosen for the following reasons e.g.: – software readily/immediately available – already fully tested and de-bugged – usually less expensive to buy – technical support online/by phone – usually compatible with other existing software – large user base mutual support bespoke software/tailor made chosen for the following reasons e.g.: – can be tailored to meet the exact requirements for the school trip booking – in contact with the actual programmers if there is a problem – software can develop as it is used – doesn’t contain unwanted features [4] (i) One mark per point up to a maximum of three Test data max 2 – Use of test data sets – normal test data has known outcomes – extreme test data checks validation rules – abnormal test data should produce error messages – mention of normal, abnormal, and extreme data (all 3 with no valid expansions, one mark if above not given) Types of testing max 2 – Black box – White box – System – Alpha – Beta – User, etc. Other – testing that the school trip payment system meets the requirements of the school – volume testing [3]

Page 7 Mark Scheme Syllabus Paper IGCSE – October/November 2013 0420 32 © Cambridge International Examinations 2013 (j) One mark per item, one mark per reason must match item, e.g. program listing/coding – so alterations can be made programming language(s) used – so the application can be recompiled System flowchart – overview of whole system flowchart/algorithm/pseudocode – so that the logic can be altered if required input/output formats hardware requirements – for testing any alterations/to know what is needed to run the system software requirements – for testing any alterations/to know what is needed to run the system known ‘bugs’ in the system – so they can be removed list of variables used (and their meaning/description) – so that alterations to code don’t spawn new errors file structures/data model – - so that files and file sizes can be checked Test plan/sample runs (with results and actual test data used) – - so that test can be re-run when alterations are made validation rules – so that any extra inputs can be subject to similar validation [8] (k) one mark for each point related to the school scenario, e.g. – discuss with school office staff/parents whether or not new system works – discuss with school office staff/parents whether or not system was easy to use – consider if objectives of new system have been met – look at results from tests – look at printouts, etc. to see if system produced the correct outcomes [3]