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

Centre Number Candidate Number Name UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS International General Certificate of Secondary Education COMPUTER STUDIES 0420/01 Paper 1 May/June 2006 2 hours 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. Answer all questions. No marks will be awarded for using brand names of software packages or hardware. At the end of the examination, fasten all your work securely together. The number of marks is given in brackets [ ] at the end of each question or part question. For Examiner’s Use This document consists of 15 printed pages and 1 blank page. IB06 06_0420_01/4RP © UCLES 2006 [Turn over www.XtremePapers.com

2 © UCLES 2006 0420/01/M/J/06 For Examiner's Use 1 Explain, using examples where appropriate, the meaning of these computer terms. (a) smart card [2] (b) relational database [2] (c) Read Only Memory (ROM) [2] (d) de-skilling [2] (e) top-down design [2] 2 State two features that are available on a digital phone. 1 2 [2]

3 © UCLES 2006 0420/01/M/J/06 [Turn over For Examiner's Use 3 (a) Give one effect of hacking. [1] (b) Give two ways of protecting computer systems against hacking. 1 2 [2] 4 Give three file management tasks that are done by a computer operating system. 1 2 3 [3] 5 (a) Give two ways that computers can help teachers teach a lesson. 1 2 [2] (b) Give two ways that teachers could use a computer system to send work electronically to students who are absent from a lesson. 1 2 [2]

4 © UCLES 2006 0420/01/M/J/06 For Examiner's Use 6 (a) Give two benefits of using a high-level language for writing programs. 1 2 [2] (b) State one type of program that would be written in a low-level language rather than a high-level language and give a reason why. Type Reason [2]

5 © UCLES 2006 0420/01/M/J/06 [Turn over For Examiner's Use 7 The spreadsheet shows the computer equipment on loan to a staff member in a company. Cells B13 and C7:E13 contain formulae. A B C D E 1 2 PC Software Development Ltd 3 Ref: 2106 4 Computer equipment on loan to: S. Harrison 5 6 Item Year 1 Year 2 Year 3 Year 4 7 PC system 1600 800 400 200 8 Notebook computer 1000 500 250 125 9 Hand-held computer 320 160 80 40 10 Laptop case 80 40 20 10 11 PC cover 16 8 4 2 12 Mouse mat 8 4 2 1 13 Total value ($) 3024 1512 756 378 14 (a) State a cell that contains a data item. [1] (b) Describe how the numbers in the range of cells B7:E13 can be changed to include money symbols. [2] (c) Give a formula that could be in cell B13 to calculate the total value of the equipment in Year 1. [1] (d) Each year the value of the equipment is halved. State a formula that could be in cell C7 to calculate the value of the PC system in Year 2. [1] (e) If the value in cell B10 is changed to 60, state all the cells where the values would change automatically. [2] (f) On the spreadsheet diagram shade the cells that must be selected in order to create and label a chart showing the Total value ($) of the computer equipment for Years 1, 2, 3 and 4. [2]

6 © UCLES 2006 0420/01/M/J/06 For Examiner's Use 8 Data-logging is used for monitoring the level of oxygen in a river. (a) State one item of hardware that is used to collect the oxygen data. [1] (b) Explain how the oxygen data is processed by the computer. [2] (c) State two ways that the oxygen data could be displayed for a user to understand. 1 2 [2] (d) Explain what the computer would do if the amount of oxygen in the water is too high. [1] (e) Give two advantages of using data-logging for monitoring the oxygen data in a river. 1 2 [2]

7 © UCLES 2006 0420/01/M/J/06 [Turn over For Examiner's Use 9 START INPUT N STOP PRINT N IS N EVEN? IS N = 1? N = 3 N + 1 N = N / 2 Yes Yes No No Trace the flow chart using the numbers 2 and 3. Write down each of the values of N in the order that they are printed out. (a) 2 [1] (b) 3 [2]

8 © UCLES 2006 0420/01/M/J/06 For Examiner's Use 10 Many bank customers now bank on-line using the Internet. (a) State two advantages for the bank of on-line banking. 1 2 [2] (b) State two disadvantages for a bank customer of on-line banking. 1 2 [2] (c) State three data protection rules that could apply to the customer data stored on a bank computer system. 1 2 3 [3]

9 © UCLES 2006 0420/01/M/J/06 [Turn over For Examiner's Use 11 A mail order company is considering using a computer system for stock control and order processing. (a) Give two fact finding methods that would be used. 1 2 [2] (b) Give two items that would be included in the feasibility report. 1 2 [2] (c) Give three tasks that would be done at the design stage. 1 2 3 [3] (d) Describe one way that the conversion from the old system to the new system could be done. [1]

10 © UCLES 2006 0420/01/M/J/06 For Examiner's Use 12 A music club keeps its members’ details on a computer file. (a) Complete the table below which shows the data type, field length and validation check used for the club members’ data. Data type Field length Validation check Name Address Date of birth E-mail address [4] (b) New members can join the music club by completing an application form on the club website. Using the screen below design a web page which shows: • the form for collecting new members’ details • a link to another web page listing events for the year. [5]

11 © UCLES 2006 0420/01/M/J/06 [Turn over For Examiner's Use (c) Each member is given a reference number. Give one reason why the reference number must be unique. [1] (d) Give a situation when a record would be amended. [1] (e) State the type of file access that is used to update a record. [1] 13 Expert systems are used for fault diagnosis. (a) Explain how an expert system could be used to advise a technician on how to repair a computer that is no longer working. [3] (b) Give two applications, other than fault diagnosis, that use an expert system. 1 2 [2]

12 © UCLES 2006 0420/01/M/J/06 For Examiner's Use 14 Batch processing is used for producing electricity bills. (a) Give two reasons why batch processing is used rather than real-time processing for producing electricity bills. 1 2 [2]

13 © UCLES 2006 0420/01/M/J/06 [Turn over For Examiner's Use (b) Select words from the list below to complete the systems flowchart for electricity bill payments. errors master file sorted transaction file update validate validated transaction file payments sort new master file [6] (c) Describe how a master file could be recovered after a systems failure. [2]

14 © UCLES 2006 0420/01/M/J/06 For Examiner's Use 15 (a) Give four features of a computer-aided design (CAD) program that could be used to design a water jug. 1 2 3 4 [4] (b) Give one benefit for a manufacturer of using a computer-aided design/computer-aided manufacture (CAD/CAM) system. [1] 16 (a) A formula for calculating the body mass index (BMI) is: weight in kilograms BMI = (height in metres) x (height in metres) Calculate the BMI for a person whose weight is 80kg and height is 2 metres. [1]

15 © UCLES 2006 0420/01/M/J/06 For Examiner's Use (b) Using pseudocode or otherwise, write an algorithm that will input the ID, weight (kg) and height (m) of 30 students, calculate their body mass index (BMI) and output their ID, BMI and a comment as follows: A BMI greater than 25 will get the comment ‘OVER WEIGHT’, a BMI between 25 and 19 (inclusive) will get ‘NORMAL’ and a BMI less than 19 will get ‘UNDER WEIGHT’. [6]

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 University of Cambridge Local Examinations Syndicate (UCLES), which is itself a department of the University of Cambridge. 0420/01/M/J/06 BLANK PAGE

UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS International General Certificate of Secondary Education MARK SCHEME for the May/June 2006 question paper 0420 COMPUTER STUDIES 0420/01 Paper 1, maximum mark 100 These mark schemes are published as an aid to teachers and students, to indicate the requirements of the examination. They show the basis on which Examiners were initially instructed to award marks. They do not indicate the details of the discussions that took place at an Examiners’ meeting before marking began. Any substantial changes to the mark scheme that arose from these discussions will be recorded in the published Report on the Examination. All Examiners are instructed that alternative correct answers and unexpected approaches in candidates’ scripts must be given marks that fairly reflect the relevant knowledge and skills demonstrated. Mark schemes must be read in conjunction with the question papers and the Report on the Examination. The minimum marks in these components needed for various grades were previously published with these mark schemes, but are now instead included in the Report on the Examination for this session. • CIE will not enter into discussion or correspondence in connection with these mark schemes. CIE is publishing the mark schemes for the May/June 2006 question papers for most IGCSE and GCE Advanced Level and Advanced Subsidiary Level syllabuses and some Ordinary Level syllabuses. www.XtremePapers.com

Page 2 Mark Scheme Syllabus Paper IGCSE – May/June 2006 0420 01 © University of Cambridge International Examinations 2006 1 Generally, one mark for each valid point. Two examples gain two marks. (a) smart card integrated chip card data held in tiny silicon chip replaces the need for magnetic stripes harder for criminals to copy/change data used by banks, mobile phones, satellite TV receivers [2] (b) relational database contents of files are linked/data held in a number of interrelated files or relations linked by common fields uses tables [2] (c) read-only memory (ROM) non volatile memory used to store systems software read from but not written to cannot change [2] (d) de-skilling skilled/semi skilled labour replaced by microprocessor-controlled systems e.g. manufacturing [2] (e) top down design breaking down the problem/task/program into sub problems/smaller tasks/modules stepwise refinement [2] 2 Any two features download screen savers receive text messages internet caller display PIN code range 59 m indoors, 300 m outdoors clear signal [2] 3 (a) One effect from fraud/transferring money viewing sensitive confidential data changing data sell data virus/logic bomb blackmail [1] (b) Two ways from passwords/codes encryption monitoring attempts to access the system/logging use lock keyboard/computer/doors firewalls smart card fingerprints/biometrics restrict access set up false web sites [2]

Page 3 Mark Scheme Syllabus Paper IGCSE – May/June 2006 0420 01 © University of Cambridge International Examinations 2006 4 Any three file management tasks from e.g. load/save sort merge de-fragment delete calculate file size/space left automatic backup directories [3] 5 (a) Any two ways from e.g. on-line teaching/testing multimedia presentation interactive board use internet – access web sites e.g. see expert systems demo video conferencing [2] (b) Any two ways from e.g. e-mail/file attachments send document as a FAX using computer put on bulletin board put on school web site use ISP messaging facility use ISP texting facility [2] 6 (a) Any two advantages from e.g. H L similar to English H L easy to understand Easy to correct errors/test problem orientated portable [2] (b) Award one mark for example and one mark for reason example e.g. operating system game reason fast 1 → 1 with machine code no need to compile/uses assembler [2]

Page 4 Mark Scheme Syllabus Paper IGCSE – May/June 2006 0420 01 © University of Cambridge International Examinations 2006 7 (a) B7:B12, E3 [1] (b) Select B7:E13, Format, Cell, Currency [2] (c) =SUM(B7:B12) or (B7+B8+B9+B10+B11+B12) [1] (d) =B7/2 or B7* 0.5 [1] (e) C10:E10 one mark B13:E13 one mark [2] (f) B6:E6 one mark B13:E13 one mark [2] 8 (a) One from probe/sensor AD converter [1] (b) Two from data stored in computer database compared with set parameters compared with previously stored readings [2] (c) Two from graph database table [2] (d) alarm [1] (e) Two from readings are taken automatically accurate measurements are made no human error readings are taken at exactly the right time [2] 9 (a) 1 [1] (b)    → ← ,5 , 10       → ← 1 ,2 ,4 ,8 , 16 one mark one mark [2]

Page 5 Mark Scheme Syllabus Paper IGCSE – May/June 2006 0420 01 © University of Cambridge International Examinations 2006 10 (a) Two from less staff/employment costs/queues in the bank can close branches/less costs for maintaining branches less paper/electronic transactions [2] (b) Two from need to have/be able to use devices capable of accessing the internet security risks cannot have the personal service offered by the conventional bank cannot get cash [2] (c) Three from the data must be up-to-date the data can only be used for the purpose for which it was collected data must be accurate data must be destroyed when no longer needed data user must register what data is stored and the use data must be used fairly and lawfully data must be protected from accidental damage only authorised people can have access to that data hackers are prosecuted fines are imposed data is misused [3] 11 (a) Any two from interviewing/asking questions questionnaires observing inspecting files/paper/screens [2] (b) Any two from cost/benefit analysis any conflict between requirement and law development time does technology exist/is it practical description of business plus problems part of business being looked at e.g. processing of orders objectives of the proposed system alternative solutions and why others were rejected do the staff have the expertise to cope with the new system/enough money to go ahead/technology available plan for implementation course of action/how to proceed [2]

Page 6 Mark Scheme Syllabus Paper IGCSE – May/June 2006 0420 01 © University of Cambridge International Examinations 2006 (c) Any three from decide on software hardware design input formats output formats file structures/tables test plan flow charts/algorithms processing [3] (d) Any one from direct changeover parallel conversion phased conversion pilot conversion [1] 12 (a) Data type Date is DATE, others are text/alphanumeric/string one mark Field length Date of birth = 8 one mark Others = 30 E-mail = 40 one mark Validation Date is DATE, Picture/Format Check, Length Check, Range Check Others are Type Check Or all are Presence Check one mark [4] (b) Award one mark each appropriate heading all 6 fields present clearly not a hand written form sufficient spaces for data icon/hyperlink/hot spot on screen [5] (c) Award one mark two people can have same name [1] (d) One mark e.g. change of address/phone number/e-mail address/marry [1] (e) random/direct access [1]

Page 7 Mark Scheme Syllabus Paper IGCSE – May/June 2006 0420 01 © University of Cambridge International Examinations 2006 13 (a) Any three from 'faults' input knowledge base searched using inference engine/rules solution(s) suggested knowledge base contains knowledge of experts [3] (b) Award one mark each medical diagnosis geological surveys - oil and mineral deposits construction industry - quantity surveyor costings mineral prospecting social services - calculate benefit financial services - predict stock market movement/recommend investments speech recognition chess forensic science [2] 14 (a) Award one mark each large volume of data off-line preparation no immediate urgency for batch of data to be processed instant processing/immediate results not required computer used for other jobs [2] (b) Award one mark each validate errors validated transaction file sorted transaction file update master file [6] (c) Award one mark per point use of grandfather/father/son (or backup) re-run old master file with transaction file follow disaster recovery plan [2]

Page 8 Mark Scheme Syllabus Paper IGCSE – May/June 2006 0420 01 © University of Cambridge International Examinations 2006 15 (a) Any four from 3D views rotation modifying stored drawings automatic calculations cross sections surface area volume simulation [4] (b) Any one from flexible manufacturing product changes can be made quickly product changes can be made inexpensively manufacturer can respond quickly to current demands can make modifications to products without the delay of change in setup [1] 16 (a) 20 [1] (b) Award one mark for each correct step in the algorithm Initialise one mark Loop (30) one mark Input ID, weight, height one mark IF………THEN………ELSE three marks (or CASE OF……….OTHERWISE) Calculate BMI one mark Output ID, BMI and comment one mark [6]