p. 1

centre number candidate number name university of cambridge international examinations international general certificate of secondary education information technology paper 1 0418/01 october/november 2004 1 hour 15 minutes candidates answer on the question paper no additional materials are required candidate name centre number read these instructions first candidate number write your centre number candidate number and name on all the work you hand in write in dark blue or black pen in the spaces provided on the question paper you may use a soft pencil for any diagrams graphs music or rough working do not use staples paper clips highlighters glue or correction fluid answer all questions 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 do not write in the barcode do not write in the grey areas between the pages for examiner s use if you have been given a label look at the details if any details are incorrect or missing please fill in your correct details in the space given on this page stick your personal label here if provided this document consists of 12 printed pages sp cw/slm s78892 © ucles 2004 [turn over

[close]

p. 2

2 1 name the objects a b c and d using the words from the list for examiner s use adcb floppy disc drive midi interface plotter joystick monitor printer keyboard mouse scanner a b c d 4 2 ring two output devices keyboard plotter monitor scanner mouse sensor [2 © ucles 2004 0418/01/o/n/04

[close]

p. 3

3 3 tick two ways of preventing health problems caused by continuous use of computers for examiner s use fit an anti-glare screen use a joystick instead of a mouse position your chair so that you are looking up at the screen work without a break drink plenty of fluids use a wrist rest [2 4 tick the box which best describes each of the following items hardware word processor video camera scanner web page design program [4 software 5 a computer in a greenhouse causes shutters to open when it gets hot and closes them when it is cooler it also keeps a record of the temperature throughout the day circle the two types of application software which are being used control measuring data handling modelling desktop publishing word processing [2 © ucles 2004 0418/01/o/n/04 [turn over

[close]

p. 4

4 6 a floor turtle can use the following instructions instruction forward n backward n left t right t penup pendown repeat n end repeat meaning move n units forward move n units backward turn left t degrees turn right t degrees lift the pen lower the pen repeat the following instructions n times finish the repeat loop for examiner s use 50 complete the set of instructions to draw this shape by filling in the blank lines pendown 90 repeat forward 45 [5 © ucles 2004 0418/01/o/n/04

[close]

p. 5

5 7 this table shows part of a database in the table below it tick whether the statements are true or false make nokia ericsson siemens nokia motorola model 3310 a2618 c45 7110 t250 weight g 113 140 107 141 102 talk time min 255 240 300 225 210 for examiner s use true the column headed make is a record there are five records model is a field name the database has been sorted by weight false [4 8 a biology class is going to do a study to see whether the local factory is polluting the local river students will measure the pollution by using sensors and recording the results on computer a name two sensors they should use 1 2 2 b why is the computer unable to read the data directly from the sensors 1 c what device is needed to enable it to do so 1 d give two reasons why computers are used rather than manual methods 1 2 2 © ucles 2004 0418/01/o/n/04 [turn over

[close]

p. 6

6 e name a type of software which would be used to store the results 1 f they will write a report including graphs which will be printed out name a type of software which would be used to produce this report 1 g describe the steps required to produce the report 3 for examiner s use 9 describe two methods of preventing viruses other than by using virus protection software 1 2 2 © ucles 2004 0418/01/o/n/04

[close]

p. 7

7 10 a school has recently bought some laptop computers that can be used individually or connected to the network a describe two advantages of connecting the laptops to the network 1 2 2 b describe two disadvantages of connecting the laptops to the network 1 2 2 for examiner s use 11 many teachers are using presentation software to illustrate their lessons a describe two features other than text which can be found on a slide in a presentation 1 2 2 b teachers should always make a backup of their presentation i describe what is meant by backup 2 ii describe why backups are necessary 2 © ucles 2004 0418/01/o/n/04 [turn over

[close]

p. 8

8 12 a school has just bought some learning materials which can be used by pupils both in the classroom and at home they are available on a cd rom or on the internet a discuss the advantages and disadvantages of using the cd rom version compared with the internet 4 b students save and carry their work from school on a floppy disc describe the problems this may cause and suggest ways of preventing or overcoming these problems 4 for examiner s use © ucles 2004 0418/01/o/n/04

[close]

p. 9

9 13 a deputy head in a school keeps a spreadsheet of pupil data on his laptop showing the progress of pupils in the three main subjects below is a table which shows part of this spreadsheet a 1 2 3 4 5 6 7 8 9 10 11 allen bi johal ke wong mcdonald mohammed o neill rowlands jeffrey sabina jatinder su calum ali michelle jean mfmfmmff 72 53 72 54 59 71 50 89 71 80 61 81 67 60 49 91 52 53 68 78 63 82 45 96 65 62 67 71 63 71 48 92 second name b first name c gender d english e maths f g h for examiner s use science average a name the column which this spreadsheet has been sorted on 1 b write down the formula which is in cell g4 1 c if all the data were now sorted on column g in ascending order write down the name of the student who would be at the top of the list 1 d the students do not want others to see their exam scores suggest two ways that the deputy head could prevent this from happening 1 2 2 © ucles 2004 0418/01/o/n/04 [turn over

[close]

p. 10

10 e the deputy head wanted to compare the average exam score of the three subjects so he produced the following graph using the spreadsheet software describe the steps he had to go through to produce it average exam score 72 70 68 66 64 62 english maths science for examiner s use 5 f the deputy head thinks that one of the reasons why maths and science teachers are getting better results is that they use computers in their lessons a lot and english teachers do not give three reasons why computers help students to improve 1 2 3 3 © ucles 2004 0418/01/o/n/04

[close]

p. 11

11 14 a school has decided to convert one of its science laboratories into a computer room a compare the advantages and disadvantages of doing this include in your answer any safety issues which may arise during the conversion 5 b the science department will use one of the computers to keep all their stock records on a database give two advantages of keeping information in a computer database rather than on paper 1 2 2 for examiner s use © ucles 2004 0418/01/o/n/04 [turn over

[close]

p. 12

12 15 many credit card customers are concerned that their data is held on computer describe three ways in which personal data held on computers can be misused for each way explain a method for preventing it 1 prevention 2 prevention 3 prevention 6 for examiner s use 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 © ucles 2004 0418/01/o/n/04

[close]