0418 01 information technology - · pdf fileuniversity of cambridge international...
TRANSCRIPT
UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
International General Certificate of Secondary Education
MARK SCHEME for the May/June 2006 question paper
0418 INFORMATION TECHNOLOGY
0418/01 Paper 1 maximum raw mark 120
This mark scheme is published as an aid to teachers and students, to indicate the requirements of the
examination. It shows the basis on which Examiners were initially instructed to award marks. It does
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.
Page 2 Mark Scheme Syllabus Paper
IGCSE – May/June 2006 0418 1
© University of Cambridge International Examinations 2006
1 A Joystick
B Digital camera
C Memory stick
D Mouse
E Keyboard
1 mark each 5 marks
2 Bar code reader
Joystick
1 mark each 2 marks
3 Control program typing letters
Database automatic washing machine
Measuring program storing records of books in a library
Search engine monitoring rainfall in a weather
station
Word processor doing research on the Internet
1 mark each correct arrow 5 marks
4 Evaluation
Implementation
Implementation
Evaluation
1 mark each 4 marks
5 Magnetic Stripe reader
Keypad
Bar code reader
1 mark each 3 marks
6 6
50
RIGHT
END REPEAT
RIGHT 180/LEFT 180/PENUP/LEFT 90
FORWARD 60
PENDOWN
REPEAT 4
FORWARD 60
RIGHT 90
6
50
RIGHT
END REPEAT
PENUP
FORWARD -60
PENDOWN
REPEAT 4
BACKWARD 60
LEFT 90
Each pair of 2 statements 1 mark each 5 marks
Any solution which works will gain credit.
Page 3 Mark Scheme Syllabus Paper
IGCSE – May/June 2006 0418 1
© University of Cambridge International Examinations 2006
7 (a) Three methods and three corresponding advantages from:
Parallel running/implementation 1 mark
Information is not lost/always a second copy 1 mark
Phased implementation 1 mark
Still have most of system if things go wrong/ no expense of running two systems together
1 mark
Direct implementation/changeover 1 mark
Time is not lost/do not have expense of running two systems together 1 mark
Pilot running 1 mark
Still have most of system if things go wrong/ no expense of running two systems together
1 mark
6 marks max
(b) Normal data is data which is within an acceptable range/ is usual for the situation 1 mark
Between 0 and 500 (<500 is acceptable as is an example in the correct range 1 mark
Extreme data is data which is at either end of a normal range of data 1 mark
0 and 500 1 mark
Abnormal data is data which is outside the acceptable range/ is of the wrong data type
1 mark
Any negative number or number greater than 500 or text example 1 mark
(c) Three from:
Program listing/algorithm
List of variables
File structure
Purpose of the system
Screen layouts
Print formats/report formats
Purpose of the program
Hardware requirements/information
Software requirements
Sample runs
Known bugs
Validation rules
Systems flowchart (1 mark for writing flow chart only)
Program flowchart 3 marks
8 Three from:
ROM cannot be changed
RAM can be read from and written to
ROM is read only memory and RAM is random access memory
ROM holds instructions that need to be unchanged such as BIOS/program cycles in a washing
machine/program instructions in games such as gameboys, playstations etc.
RAM holds the work that is being currently done by the user
Ram is volatile/ROM is non-volatile
3 marks
9 (a) (b)
1 mark each 2 marks
Page 4 Mark Scheme Syllabus Paper
IGCSE – May/June 2006 0418 1
© University of Cambridge International Examinations 2006
10 (a) Direct/random not RAM 1 mark
(b) Harry Potter and the Philosopher’s Stone 1 mark
(c) Must be device
Borrower - bar code reader/magnetic stripe reader 1 mark
Book - bar code reader 1 mark
(d) Quicker to input 1 mark
Less likelihood of errors on input 1 mark
(e) Two from:
check digit
length check
type check – all digits
existency check 2 marks
(f) Paperback or hardback 1 mark
(g) Text/alphanumeric/string 1 mark
(h) Code number 1 mark
(i) Five from:
computer reads a record from the book file
compares the date due back
with 27th
May
if date due back is less/earlier than 27th
May
using the borrower number
reads the corresponding record from the borrower file
address is read from record
mail merged letter/email is generated
otherwise reads next record and repeats above
until end of file 5 marks
11 Booking a flight using a computerised booking system
Withdrawing money from a cash machine
1 mark each 2 marks
12 (a) any cell from B4 to E7 1 mark
(b) five 1 mark
(c) D4-C4 1 mark
(d) centred 1 mark
(e) =SUM(E4:E7) / =E4+E5+E6+E7 1 mark
Page 5 Mark Scheme Syllabus Paper
IGCSE – May/June 2006 0418 1
© University of Cambridge International Examinations 2006
13 (a) Each field must have appropriate space for answers or be example
Personal data (name, address, phone, date of birth, etc.) 2 marks for 4 items, 1 for 3 items
else 0
Parent’s name and phone number/ e-mail address
Space for minimum of two lines of medical condition(s)
Information fills the page and clearly be an input screen form 5 marks
(b) Three from:
Field Name
Field Type
Field Length
Key Field
Validation Check
Index
Input mask 3 marks
(c) Two from:
Data could be changed
Data could be deleted
Data could be distributed to anybody 2 marks
(d) Three from:
Password protect computer
Password protect file
Keep computer/removable media locked securely away when not in use
Encrypt data
Keep data on removable storage medium only
Anti-spyware
Firewalls 3 marks
14 (a) OMR 1 mark
(b) a disc 1 mark
(c) e-mail 1 mark
15 TRUE
FALSE
FALSE
FALSE
1 mark each 4 marks
Page 6 Mark Scheme Syllabus Paper
IGCSE – May/June 2006 0418 1
© University of Cambridge International Examinations 2006
16 (a) Five from:
Save spreadsheet
Load images from clipart
Download images from the Internet
Scan images
Upload images from digital camera
Load word processing software
Insert pictures/import pictures/copy and paste pictures
Insert spreadsheet/import spreadsheet/copy and paste spreadsheet/embed spreadsheet
Type in text
Insert file/paste chart
Format reports
Edit images
(Max three marks from ‘images’) 5 marks
(b) Moisture/humidity sensor 1 mark
light sensor 1 mark
(c) Sensors measure analogue quantities 1 mark
computers use digital data 1 mark
(d) Analogue to digital converter 1 mark
(e) Two from:
Computer readings are more accurate
Readings can be taken continuously
Humans cannot work without a break
Actions are taken immediately
Readings can be taken at night/during the holidays 2 marks
(f) Five from:
temperature read from temperature sensor
computer compares this temperature
with preset value
if lower computer/microprocessor switches heater on
if lower computer/microprocessor closes windows
if higher computer/microprocessor switches heater off
if higher computer/microprocessor opens windows
if still higher computer/microprocessor switches fan on
and repeats continuously 5 marks
17 (a) Two from:
flight simulations
driving simulations
nuclear power stations
simulating traffic flow
any civil engineering situation which can be modelled
1 mark for each 2 marks
(b) Two from:
too expensive to build real thing
too large a time scale required
wasteful of materials
variables can be easily changed/different scenarios can be easily used 2 marks
Page 7 Mark Scheme Syllabus Paper
IGCSE – May/June 2006 0418 1
© University of Cambridge International Examinations 2006
18 Input – symptoms are typed in/input direct from data logger/embedded computer
processing
expert system compares symptoms
with those in the knowledge base
using inference engine
using rules base
matches are found
Output – suggested/probable faults 4 marks
19 Eight from:
Customer – advantages
Don’t have to waste time travelling (long distances to banks)
Disabled people don’t have to travel to bank/leave home
Easier for customers to make transactions
Don’t have to spend money on travelling expenses travelling (long distances to banks)
No embarrassment of having to ask for loans face to face
Can bank when banks are closed
Don’t have to wait for post/immediate payments can be made
Less danger of mugging
Customer – disadvantages
Lack of socialising/social contacts
Hackers may intercept data and defraud customer
Deprived of personal touch
Easier for customers to mismanage accounts
Phone bills can increase
Without broadband other family members cannot use the phone
Cannot deposit/withdraw cash/money
More vulnerable to phishing
Customers must have a computer/Internet access/(basic) computer skills
Bank – advantages
Fewer cashiers needed – less spent on wages
Fewer branch offices needed – less spent on rates/rent
Less actual cash handled – fewer robberies
Less money spent on security staff
Bank – disadvantages
Lose customers due to lack of personal touch
Initial outlay on computers expensive
Greater risk of fraud so lose money
Need to retrain staff 8 marks
UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
International General Certificate of Secondary Education MARK SCHEME for the October/November 2006 question paper
0418 INFORMATION TECHNOLOGY
0418/01 Paper 1, maximum raw mark 120
This mark scheme is published as an aid to teachers and students, 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.
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 grade thresholds for various grades are published in the report on the examination for most
IGCSE, GCE Advanced Level and Advanced Subsidiary Level syllabuses.
• CIE will not enter into discussions or correspondence in connection with these mark schemes.
CIE is publishing the mark schemes for the October/November 2006 question papers for most IGCSE,
GCE Advanced Level and Advanced Subsidiary Level syllabuses and some Ordinary Level
syllabuses.
Page 2 Mark Scheme Syllabus Paper
IGCSE - OCT/NOV 2006 0418 1
© UCLES 2006
1 A Laptop computer
B Speakers
C Inkjet printer
D Web cam
E Monitor
1 mark each 5 marks
2 Memory Stick
Hard disc
1 mark each 2 marks
3 FALSE
TRUE
TRUE
TRUE
1 mark each 4 marks
4 Optical Mark reader printing out car designs
Plotter reading information from credit cards
Magnetic stripe reader choosing from set of options
Touch screen making backup copies
Zip drive reading information from students’ exam answers
1 mark each correct arrow 5 marks
5 Database software
Spreadsheet software
Word processing software
1 mark each 3 marks
6 (a) OCR
(b) direct
(c) sensor
1 mark each 3 marks
7 (a) (i) ring 1 mark
(ii) bus 1 mark
(b) Local area network 1 mark
Page 3 Mark Scheme Syllabus Paper
IGCSE - OCT/NOV 2006 0418 1
© UCLES 2006
8 FORWARD 20 FORWARD 20
RIGHT 90 RIGHT 90
PENUP PENUP
FORWARD 5 FORWARD 5
PENDOWN PENDOWN
FORWARD 20 OR FORWARD 20
RIGHT 90 RIGHT 90
FORWARD 50 FORWARD 50
RIGHT 90 REPEAT 2
FORWARD 25 RIGHT 90
RIGHT 90 FORWARD 25
FORWARD 25 END REPEAT
1 mark each group of statements 5 marks
9 (a) two from
Observation 1 mark, Watching people in their work practices – 1 mark
Questionnaires 1 mark, recording of responses to questions to users about the
system – 1 mark
Interviews 1 mark, face to face questions to users about the system – 1 mark
Examining documents 1 mark, looking at/through current paperwork – 1 mark 4 marks
(b) four from
data capture forms
input screens/user interface
report layouts
output screens
validation routines
queries/searches
macros 4 marks
10 suitable example for on-line processing i.e. booking systems, cash machines, EFTPOS 1 mark
suitable description such as input data is acted upon immediately and files updated immediately 1 mark
suitable example for batch processing, such as cheque processing, payroll, utility bills, stock control
(some types) 1 mark
suitable description such as data is collected altogether before being input to the system/data is
processed in one go 1 mark
11 (a) two from
ROM cannot be changed/RAM can be changed
RAM can be read from and written to
ROM is read only memory and RAM is random access memory
ROM is non-volatile/RAM is volatile 2 marks
(b) holds instructions that need to be unchanged such as BIOS/program cycles in a washing
machine/program instructions in games such as gameboys, playstations, etc. 1 mark
12 (a) range check 1 mark
(b) (i) 0/45/60 1 mark
(ii) 0/60 1 mark
(iii) 87 1 mark
(c) (i) =if(d2<35,“Fail”,“Pass”) / =if(d2>=35,“Pass”,“Fail”)
1 mark for correct condition
1 mark for “Pass”, “Fail” 2 marks
Page 4 Mark Scheme Syllabus Paper
IGCSE - OCT/NOV 2006 0418 1
© UCLES 2006
(ii) highlight e2 to e32 – 1 mark
click on fill down – 1 mark
OR
highlight e2 and show fill handle – 1 mark
drag down to e32 – 1 mark
OR
highlight e2 and click on copy – 1 mark
highlight e3 to e32 and click on paste – 1 mark 2 marks
(d) Spreadsheet
Spreadsheet
Word processor
Spreadsheet 4 marks
(e) two from:
real thing may be:
too dangerous
too large a time scale required
wasteful of materials/too expensive to build
It’s easier to alter a model
Any other suitable answer 2 marks
13 (a) computers work with digital data 1 mark
analogue data must be converted into data which the computer can understand 1 mark
(b) analogue to digital converter/ADC 1 mark
(c) two from:
Computer readings are more accurate.
Readings can be taken more frequently/continuously.
Nurses can get tired and forget to take readings.
Nurses are so busy they might not be able to take readings regularly.
Up to date readings. 2 marks
14 (a) four from:
input screen asking for sample details
sample details are typed in
expert system compares them with those in the knowledge base
using inference engine
percentage probability is suggested for each mineral
user makes decisions based on output 4 marks
(b) two from:
Car fault diagnosis
Medical diagnosis
Tax
Chess games
Animal/Plant identification
Weather forecasting 2 marks
Page 5 Mark Scheme Syllabus Paper
IGCSE - OCT/NOV 2006 0418 1
© UCLES 2006
15 (a) (i) direct/random 1 mark
(ii) hard/floppy disc/zip disc/jaz disc 1 mark
(b) two from:
pupil changes phone number
pupil changes address
pupil changes form/year/grade
medical history changes
pupil gains qualifications
pupil leaves school
pupil changes name/parents 2 marks
(c) two from:
put password on computer
put password on file
lock office door when not in use
encrypt data
stores data on removable medium/device/removes data to secure location 2 marks
(d) A copy of file(s)/data 1 mark
stored on alternative medium/in a separate room 1 mark
to be used in case original is corrupted 1 mark 16 (a) user id/account number 1 mark
password/PIN 1 mark (b) two from:
Don’t have to waste time travelling long distances to banks.
Don’t have to spend money on travelling expenses travelling long distances to banks.
No embarrassment of having to ask for loans face to face.
Can bank when banks are closed.
Personal security reasons.
People with disabilities find it easier. 2 marks (c) two from:
fewer cashiers needed – less spent on wages
fewer branch offices needed – less spent on rates/rent
less actual cash handled – fewer robberies 2 marks (d) two from:
use of encryption key
encoding of data
so that data is unintelligible
needs translating using a special key 2 marks (e) two from:
Security of information transmitted over the internet.
Lose personal touch.
Less opportunity for socialising with friends/neighbours.
More expensive phone bills.
Lack of exercise.
Might not be able to use the phone if Internet is dialup.
Might be domestic disputes over whose turn it is to use the Internet. 2 marks 17 five max from:
ISBN
Book data (title, author, category, hardback/softback, publisher, particular shop/branch,
any other suitable item of data.) – 2 marks for 4 items, 1 for 3 items else 0
Selling price/cost price
Information fills the page and is clearly an input screen
Appropriate spaces after each field 5 marks
Page 6 Mark Scheme Syllabus Paper
IGCSE - OCT/NOV 2006 0418 1
© UCLES 2006
18 (a) (i) bar code reader/keypad 1 mark
(ii) magnetic stripe reader/keypad (only if not given in i) 1 mark
(b) five from:
product number is validated
using check digit
product number is compared with each item
a match would be made with 002136987421
number in stock is reduced by 1
163 becomes 162
Number in stock/162 is compared with…
…is compared with re-order level.150
If equal then needs re-ordering 5 marks
(c) four from:
PIN is checked
supermarket computer contacts bank computer
using sort code present on card
expiry date check carried out on card
existency check carried out on card/account number
matching account details looked up on file
balance/credit check is carried out on account
if available funds present money is deducted from account and added to supermarket
bank account/transferred from customer account to supermarket account 4 marks
19 (a) two from:
take photos using a digital camera – 1 mark
download from camera and save – 1 mark
OR
take photos using traditional camera – 1 mark
scan the developed photo/develop onto CD ROM and save – 1 mark
OR
find images on the Internet – 1 mark
copy and paste/download images – 1 mark
OR
find appropriate images of Clipart – 1 mark
copy and paste/download images from a CD ROM – 1 mark
OR
scan images – 1 mark
save images – 1 mark
OR
use of art/drawing package – 1 mark
save image – 1 mark 4 marks
(b) three from:
create new slide
import/insert/copy and paste images
insert sound file
create text box
type in text (in text box) 3 marks
Page 7 Mark Scheme Syllabus Paper
IGCSE - OCT/NOV 2006 0418 1
© UCLES 2006
20 seven from:
pupils:
advantages:
much wider source of knowledge
up to date information
better quality diagrams/charts
easier to find relevant information
(use of emails) so no need to carry bags
disadvantages:
can easily get sidetracked looking at irrelevant sites
can be lulled into plagiarism
need to acquire skills in searching techniques
teachers:
advantages:
can set more demanding tasks
can have work emailed to them
work is more presentable – easier to mark
pupils find learning more interesting
more interesting resources available
disadvantages:
difficult to know if it is the pupil’s own work
too many emails can overload teacher and/or system
viruses can cause system to break down
school:
advantages:
pupils more motivated – better exam results
pupils more motivated – better school environment
disadvantages:
pupils may access unsavoury sites
pupils may download coursework
expense of networking/ISP rentals
expense of phone bills
one for reasoned conclusion 8 marks
UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
International General Certificate of Secondary Education MARK SCHEME for the May/June 2007 question paper
0418 INFORMATION TECHNOLOGY
0418/01 Paper 1 (Written), maximum raw mark 120
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.
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.
• CIE will not enter into discussions or correspondence in connection with these mark schemes.
CIE is publishing the mark schemes for the May/June 2007 question papers for most IGCSE, GCE
Advanced Level and Advanced Subsidiary Level syllabuses and some Ordinary Level syllabuses.
Page 2 Mark Scheme Syllabus Paper
IGCSE – May/June 2007 0418 01
© UCLES 2007
Question
Number
Answer Part
mark
1
A Microphone B Light pen
C Remote control D Memory stick
E Numeric keypad
1 each
2 Plotter
Robot arm
1
1
3 (a)
(b)
(c)
(d)
an OMR sheet
A bank cheque
a CD RW
a dot matrix printer
1
1
1
1
4 False
True
False
False
False
1
1
1
1
1
5 memory stick
DVD R
fixed hard disk drive
1
1
1
6 Right 90
Forward 75
Right 90
Forward 75
Penup
Forward 85
Pendown
Forward 65
Right 90
Forward 75
Right 90
Penup
Forward 40
Pendown
Forward 35
1 mark for each group of 3 statements
5
Page 3 Mark Scheme Syllabus Paper
IGCSE – May/June 2007 0418 01
© UCLES 2007
Question
Number
Answer Part
mark
7 (a) Three from:
Temperature
Moisture
Humidity
Light
pH
Gas sensor (O2, CO2)
3
(b) Three from:
Name + what variable is changed.
water sprinkler/humidifier - humidity
heater/cooler/air con. - temperature
light bulb – light intensity/level
motor for opening/closing windows - temperature
fan – temperature
3
(c) Five max. from:
temperature is compared with preset value
if lower microprocessor switches on heater
if lower microprocessor shuts windows
if higher microprocessor switches heater off
if higher microprocessor switches fan on
if higher microprocessor opens windows
moisture sensor constantly monitors moisture content of soil
humidity is compared with preset value
moisture level is compared with preset value
if lower microprocessor switches on sprinkler
if higher microprocessor switches off sprinkler
light is compared with preset value
if lower microprocessor switches on light bulb
if higher microprocessor switches off light bulb
5
(d) Three explanations from:
Computers are more accurate than human beings
Computers can work continuously without taking a break
Computers do not forget to take readings
Computers can take readings more frequently
Computers can respond quicker to changes than human beings
3
8
three from:
Real thing may be:
Too dangerous
Too expensive
Too large a time scale required
Wasteful of materials
Too vast a scale
3
Page 4 Mark Scheme Syllabus Paper
IGCSE – May/June 2007 0418 01
© UCLES 2007
Question
Number
Answer Part
mark
9 (a) Problem – Headaches
Prevention – Use anti-glare screen/Take regular breaks
Problem – Eyestrain
Prevention – Use anti-glare screen/Take regular breaks
Problem – RSI
Prevention – Use ergonometric keyboard / wrist rests/Take regular breaks
Problem – Backache
Prevention – Use straight backed chair/Take regular breaks
1mark for each problem (2 max)
1 mark for each prevention (2 max)
4
(b) Problem -electrocution
Prevention – RCB installed
Problem – trailing cables
Prevention – create ducts/cover cables with carpets etc.
Problem – heavy equipment falling
Prevention – sturdy tables
Problem – fire
Prevention – extinguisher
1mark for each problem (2 max)
1 mark for each prevention (2 max)
4
10 (a) three descriptions from:
observation
questionnaires
interviews
collecting documents
3
(b) He could find details of a book more quickly
He would save space in his bookshop
1
1
(c) Maximum 5 from:
Title
Author’s name
Reference number/ISBN/Publisher/Picture of cover/ Dewey number/
genre/ fiction or non-fiction/target age group/picture of author/date published/
summary of contents/no. of copies/cost price/selling price/number of pages
Information fills the page AND is clearly a screen form
Appropriate spacing for each field
1
1
2 marks
for 4
items, 1
for 3
items
else 0
1
1
(d) typing in the data twice and comparing them
visually comparing the typed in data with the original
1
1
Page 5 Mark Scheme Syllabus Paper
IGCSE – May/June 2007 0418 01
© UCLES 2007
Question
Number
Answer Part
mark
11 (a) two from:
computer works in digital
phone lines carry sound/analogue signal
need to convert digital to analogue/analogue to digital
2
(b) Two from:
user id/account number
password
memorable name
2
(c) Three from:
Causes data to be scrambled/encoded
Requires an encryption key/software to encrypt
Requires a decryption key/encryption software to decrypt
Results in data which is not understandable/readable
protects sensitive data
from being understood if falls in to the wrong hands.
3
(d) Disadvantages to bank – two from:
Lose older customers who don’t like change
Initial set up costs of equipment/ Initial outlay on computers expensive
Need to employ highly paid technical experts to maintain system
Initial large redundancy payments
Upset/Lose customers due to lack of personal touch
Greater risk of fraud so lose money/description of effects of phishing
Need to retrain staff
2
(e) Disadvantages to customer – two from:
Lack of socialising/ social contacts
Identity theft/misuse of personal data
Customers must have a computer/Internet access/(basic) computer skills
Hackers may intercept data and defraud customer
Deprived of personal touch
Easier for customers to mismanage accounts
Phone bills can increase
Without broadband other family members cannot use the phone
Cannot deposit/withdraw cash/money
More vulnerable to phishing
2
(f) three from:
cheques are collected together
during the course of the day
cheques are then processed all at once
cheques are processed overnight
bank accounts updated following morning
3
12 RAM
ROM
ROM
3
Page 6 Mark Scheme Syllabus Paper
IGCSE – May/June 2007 0418 01
© UCLES 2007
Question
Number
Answer Part
mark
13 (a) 4 1
(b) Bar code 1
(c) 5027200190653 1
(d) Producer/food type 1
(e) Check digit
two from:
A single digit
is calculated using the other digits
and added on to the end of the number
recalculated at a later stage to ensure validity of data entry
1
2
(f) Three from:
The bar code field in the data file is read
Record by record
Until a match is found with the bar code entered
The corresponding number in stock is read
One is subtracted from this number
Written back to file.
3
(g) Two from:
PIN is entered
PIN is read from chip
Numbers compared
If identical, transaction is authorised
If not identical transaction refused
2
(h) Four from:
Details from customer’s card read
Bank code allows shop computer to contact bank’s computer
Card details checked for not stolen
Account checked for sufficient funds
If card stolen or insufficient funds then transaction is rejected
If card not stolen and sufficient funds then transaction is authorised
Amount deducted from customer’s bank account
Amount credited to shop’s bank account
Itemised receipt printed out
4
14 (a) webcams/small video cameras
microphones
1
1
(b) three from:
saves travelling time
Do not have to pay for conference room.
Do not have to hire transport.
Conferences can be called at short notice.
Don’t have to carry bulky documents to conference
Disabled students do not have to travel
3
Page 7 Mark Scheme Syllabus Paper
IGCSE – May/June 2007 0418 01
© UCLES 2007
Question
Number
Answer Part
mark
15 (a) (i)
(ii)
the old and the new system run side by side
If the new system breaks down you still have the old system as a backup
It can be a slow process/all tasks have to be performed twice/have to pay two
sets of wages
the new system replaces the old system in one go
saves money in wages/very fast method of implementation
if anything goes wrong you don’t have the old system to fall back on
1
1
1
1
1
1
(b)
Technical – three from:
Program listing
Programming language
Flowchart/algorithm
List of variables
File structure
Purpose of the system/program
Input format or example
Output format or example
Hardware requirements
Software requirements
Sample runs
Known bugs
Validation rules
User – three from:
How to load software/ run software.
How to save a file.
How to search
How to sort
How to print
How to add records
How to delete/edit records
Purpose of the system/program (only if not mentioned in technical
documentation)
Input format or example (only if not mentioned in technical documentation)
Output format or example (only if not mentioned in technical documentation)
Hardware requirements (only if not mentioned in technical documentation)
Software requirements (only if not mentioned in technical documentation)
Sample runs (only if not mentioned in technical documentation)
Error handling
Troubleshooting guide/Contact details/help line/FAQ
3 max
3 max
(c) three from:
comparing the solution with the original task requirements;
identifying any limitations to the system;
identifying any necessary improvements
evaluating the users' responses to using the system
Comparing test results of new system with old system results
Comparing the performance of the new system with performance of the old.
3
Page 8 Mark Scheme Syllabus Paper
IGCSE – May/June 2007 0418 01
© UCLES 2007
Question
Number
Answer Part
mark
16 Six from:
Interactive user screen appears
Questions about geological profile are asked
Answers to questions/geological profile are typed in
Inference engine searches
Searches the Knowledge base
using the Rules (base)
Suggested probabilities of finding oil are output using
Probable depth of likely deposit
Predictions of geological deposits above oil
Detailed Output format
6
UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
International General Certificate of Secondary Education MARK SCHEME for the October/November 2007 question paper
0418 INFORMATION TECHNOLOGY
0418/01 Paper 1 (Written), maximum raw mark 120
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.
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.
• CIE will not enter into discussions or correspondence in connection with these mark schemes.
CIE is publishing the mark schemes for the October/November 2007 question papers for most IGCSE,
GCE Advanced Level and Advanced Subsidiary Level syllabuses and some Ordinary Level
syllabuses.
Page 2 Mark Scheme Syllabus Paper
IGCSE – October/November 2007 0418 01 Question
Number
Answer Part mark
1
A Touchscreen B Video camera
C Midi interface D Plotter
E Printer
1 each
2 CD ROM drive
Memory stick
1
1
3
CAD a bank worker
MICR an examination paper marker
OMR a shop worker
Touch screen a payroll office worker
Batch processing system an aircraft designer
1
1
1
1
1
4 (a)
1
(b)
1
(c)
1 for
horizontal
line
1 for
correct
verticals
5 Penup
Forward 20
Pendown
Right 90
Forward 100
Right 90
Forward 230
Right 90
Forward 75
Penup
Forward 25
Pendown
Right 90
Forward 80
(Right 90)
1
1
1
1
1
N.B.
Pendown and Right 90
are interchangeable
Page 3 Mark Scheme Syllabus Paper
IGCSE – October/November 2007 0418 01 6 True
False
True
False
False
1
1
1
1
1
7 (a)
(b)
(c)
(d)
A DVD
A floppy disc
A laser printer
A trackerball
1
1
1
1
8 (a)
Three from:
Data capture forms
Report layouts/output format
Validation routines
Queries
Test data/routines
Macro
Specifying hardware and software requirements
3
(b) five max from:
Staff payroll number or equivalent
Personal data (name, address, phone no., fax no., email address, work
phone number, next of kin, date of birth, gender, qualifications, photo etc.)
- 2 marks for 4 items, 1 for 3, else 0
Job description
Appropriate spacing for each field
Information fills the page and is clearly a computer output screen
1
2
1
1
1
(c) Description of abnormal data i.e. data that is outside the range of acceptability
Description of normal data i.e. acceptable data/valid data
Description of extreme data i.e. on the edge of acceptability
1
1
1
(d) Five from:
Gathering data from experts
Designing knowledge base
Creating a knowledge base
Creating a structure to relate each item in the database/knowledge base
Creating an interrogation technique to get at the data
Designing a user interface/method of displaying the results/method of
inputting data/input screen/output screen
Design/create Inference engine
Design/create rule base
Testing the system
5
(e) Two from:
Car fault diagnosis
Mineral/oil prospecting
Tax
Chess games
Plant/animal/rock identification
2
Page 4 Mark Scheme Syllabus Paper
IGCSE – October/November 2007 0418 01 (f) Three from:
Pulse/heart rate
Temperature
Blood pressure
Glucose/sugar level
Rate of respiration
Oxygen level in blood
3
(g) Analogue to digital converter
Sensors measure analogue quantities
Computers work in digital
1
1
1
(h) Three from:
Will not take breaks/can operate continuously (not constantly)
Fewer mistakes/greater accuracy
More than one variable can be measured at any one time
Readings can be taken more frequently
Results are analysed automatically/faster to react/charts are produced
automatically
More reliable/readings taken at regular intervals
Nurses are free to do other tasks
Reduces chance of nurses being exposed to contagious diseases
3
9 (a) C5
1
(b) Any in range A1:A6, B1:B6, C1:G1, B8, E8,F8
1
(c) E2-D2
1
(d) SUM(C2:C6) or C2+C3+C4+C5+C6
1
(e) Copy cell C8
Paste into G8
or
Click on cell G8
Double click on Autosum/click on Autosum and press enter
or
Click on cell C8
Ctrl+move to G8
1
1
or
1
1
or
1
1
(f) Two from:
Designing structures of buildings/architects designs
Flight simulation/car driving simulation
Simulating chemical reactions
Simulating nuclear reactions
Population growth
Queuing
2
Page 5 Mark Scheme Syllabus Paper
IGCSE – October/November 2007 0418 01 10 (a) i) Two from:
Webcams/small video cameras
Microphones
Speakers
Modem
ii) Two from:
Any aspect of connecting equipment together/what each component does
employees are connected on-line/may need to access the Internet/WAN
to work
Images of the employees appear on the screen in real time
Software is needed in each computer to operate the conference
Employees can be heard by all the other employees in the conference
2
2
(b) Two from:
Different time zones make it difficult to have a video conference between
people in different countries
Start up costs can be high/equipment can be expensive to buy
Communication link can go down/reception can be poor
Equipment can fail
Can seem impersonal
Pictures and sound can be out of sync
2
11 Three from:
Internet - INTERnational NETwork
Is a Wide Area Network (WAN)
Can access it from anywhere
Greater amount of information available
Unlimited access
Intranet - INTernal Restricted Access NETwork
Usually a Local Area Network (LAN)
Password controlled pages
Behind a firewall
Can set up specific information pages on Intranet systems
Information within the school is easily accessible by all users
Can limit the places where users can go to study
No wasted time looking through millions of resources
Intranet is better protected for use of emails/from viruses/from hackers
3
12 (a) Two from:
Microwaves
Ovens
Washing machines
Dish washers
Or any reasonable labour saving device
2
(b) Four from:
Increased leisure time/free time/more time to do other things
Increase in social interaction
Can go out whenever they want
Unhealthy diet – TV dinners
Better quality meals – easier to prepare exotic dishes
Part time workers can now work full time
4
Page 6 Mark Scheme Syllabus Paper
IGCSE – October/November 2007 0418 01 13 True
False
False
1
1
1
14 Inputs:
Pressure pads
Light sensors
temperature sensors
Contact switches/push switch
Input keypad
Pass number input to keypad
Zones selected
Sound sensor
Infra red sensor/proximity sensor
Motion sensor/movement sensor
Digital/video camera
3 max
Processing:
Microprocessor continually monitors sensors.
If light sensor detects light beam interrupted:
If movement sensor activated:
If contact switch activated:
If pressure sensed by processor is greater than preset value:
It temperature sensed by processor is greater than preset value:
If sound sensed by processor is greater than preset value:
Microprocessor sends signal to output device.
4 max
Outputs:
Alarm light flashes/lights come on
Alarm sounds
Signal automatically sent to police
3 max
Must have at least one from each section to gain full marks
6 max
15 (a) Three from:
Looking at other people’s data
Changing other people’s data
Deleting other peoples data
Spreading data around
3
(b) Two from:
Use of usernames/ids
Use of passwords
Firewalls
Physical locks of computers/room
Use of biometrics
Special access rights for administrator
2
Page 7 Mark Scheme Syllabus Paper
IGCSE – October/November 2007 0418 01 (c) Two from:
Protects data during transmission phase
Results in data which is not understandable
Is understandable only to authorised users
Need a decryption key/software to decrypt data
2
(d) Five from:
Open/use DTP/word processing package
Create frames/boxes
Take photo using camera
Upload from camera/load from CD ROM/download from Internet/scan
photo
Save the picture
Load magazine document
Import/copy and paste/insert into document
Position the picture/resize picture/editing picture
Type text/import text files
5
(e) Three from:
Sound plus example
Video/animation
Links to other websites
Hot spots
Buttons for navigation/moving around the site
Hit counters
3
(f) Three from:
Website can be hacked into and modified/viruses can be introduced
Can be difficult to read/navigate
Have to have a computer/electricity
Is not portable
Have to have a modem/Internet/router
Can accidentally go to undesirable sites
Cost of maintaining website
Technical knowledge required to maintain website
3
(g) Six from:
Advantages-
Information is up to date
Easier to produce neatly presented work
Internet has vast amounts of information
Speed of search only if referring to use of search engine
Disadvantages-
Danger of accessing doubtful websites.
Can take long time to find required information
Can access biased websites
Can access inaccurate websites
Lack of expertise leads to inefficient searching
Can get easily distracted
+ reasoned conclusion
Must be at least one of each (advantage + disadvantage) to gain full marks
6
Page 8 Mark Scheme Syllabus Paper
IGCSE – October/November 2007 0418 01 16 (a) Four from:
Departure airport typed in
Arrival airport/destination/country typed in
Date of departure typed in
Duration of holiday typed in
Computer database searches for matching departure airport
If match found
Computer database searches for matching arrival airport
If flight on correct date found
Search if seats/tickets available
If so marks seat as booked
Reduces number of seats/tickets available by one
Prints flight details
4
(b) Three from:
Collection of data
Over a period of time
Data is processed all at once
Usually at quiet processor times
Double booking could occur
People would have to wait to see if their booking was made
Cannot change options if no flights available
3
2007
INTERNATIONAL GCSE
MARKING SCHEME
MAXIMUM MARK: 120
SYLLABUS/COMPONENT: 0418/01
Information Technology
SPECIMEN PAPER
Page 2 Mark Scheme Syllabus Paper CIE IGCSE - Specimen Paper - 2007 0418 1
Question Number
Answer Part mark
1
A Touchpad B Trackerball C Mouse D Keyboard E Bar code reader
1 1 1 1 1
2 False True False False False
1 1 1 1 1
3
three from Windows Icons Menus Pointers
3
4
CD ROM Floppy Disc
1 1
5 Bar code Magnetic stripe Magnetic tape Laser printer
1 1 1 1
6 Right 90 Forward 50 Right 90 Penup Forward 10 Pendown Forward 60 Penup Forward 10 Pendown Forward 30 Right 90 Forward 50 Right 90 Forward 60 5 marks - 1 mark for each group of 3 statements
5
7 (a) 1 RAM two from: Random access memory Volatile memory / lost when power is lost Can be changed / can be written to and read from 2 ROM two from: Read only memory Permanent memory / is not lost when power is lost Cannot be changed / can only be read from
2 2
Page 3 Mark Scheme Syllabus Paper CIE IGCSE - Specimen Paper - 2007 0418 1
7(b) one from:
used to hold data currently in use used to hold programs currently in use
1
8(a) two from: can store more data than the memory stick cheaper to replace (not just ‘cheaper’ on its own) not so easy to lose
2
8(b) two from: more compact / easier to carry faster access to data faster data transfer more robust / difficult to damage
2
9(a) Dot matrix printer 1 9(b) Graph plotter 1 9(c) Laser printer 1 10(a) three from:
a network of computers / LAN solely within a company or organization good security for confidential information secure email communication
3
10(b) three from: modulates and demodulates information / converts analogue to digital / digital to analogue Internet connects computers using phone lines phone system is analogue computer is digital therefore conversion is necessary
3
10(c) user name / id password
1 1
10(d) 1 two from: changes data so that it appears to be meaningless needs a decryption key to be understood 2 two from: provides security for sensitive data protects against results of unauthorised access / hacking prevents data from being understood by hackers
2 2
11(a) one from: faxed signed document is legally acceptable can’t be hacked into it can’t be affected by viruses
1
11(b) two from: fax can be seen by anyone in the company / not confidential paper can jam in the fax machine may not be readable when it arrives receiver’s fax line may be continually engaged receiver’s fax may be out of paper receiver’s fax may not be switched on
2
12(a) 7 1 12(b) 5 1 12(c) BFK 297 1 12(d) Size of engine / Price 1 12(e) Text/Alphanumeric 1 12(f) Registration 1
Page 4 Mark Scheme Syllabus Paper CIE IGCSE - Specimen Paper - 2007 0418 1
13(a) two from:
unauthorised attempting to gain access to a computer system
2
13(b) two from: a program designed to make a computer system unreliable / crash / delete data copies itself between computers / within one computer
2
13(c) two from: virus checker / virus killer do not open email attachments do not use floppy discs/CDs/DVDs/memory sticks you don’t know the origin of do not download files from the Internet
2
14 real time batch on line real time
1 1 1 1
15(a) three from: observation questionnaires interviews collecting documents
3
15(b) Patient number Personal data (name, address, phone no., fax no., email address, work phone number, next of kin, religion) Medical History with at least 3 lines allowed for completion Information fills the page
1 2 marks for 4 items, 1 for 3 items else 0 1 1
15(c) typing in the data twice and comparing it visual verification
1 1
15(d) three from: field length field/data type validation rules field name record length number of tables (in relational database) file/table names key field relationships/links to other tables
3
15(e) two from: parallel running direct changeover pilot running phased implementation
2
Page 5 Mark Scheme Syllabus Paper CIE IGCSE - Specimen Paper - 2007 0418 1
15(f) parallel running/pilot running
two from: there is a backup/fallback system in case of malfunction time can be taken in correcting malfunctions can train staff gradually direct changeover two from: time is not wasted in changeover cheaper as you don’t have to pay two sets of staff system is tested rigorously before implementation less likely to malfunction phased implementation two from: if system malfunctions only small part of business affected don’t have to pay two sets of staff can make sure system works before extending it
2
15(g) two from: to make sure user requirements have been met to identify any shortcomings to identify possible improvements
2
16(a) five from: the payroll number/432175 is read from the transaction file each record is read from the master file the payroll number is compared until the matching record/432175 is found the number of hours/42 is read (from the transaction file) the rate per hour/17.35 is read (from the master file) these are multiplied together the tax rate/27% is read (from the master file) tax is calculated subtracted from the wage name/Jaswinder Dhillon is read (from the master file) workers details printed on payslip
5
16(b) 1 Length check No less than AND no more than 6 characters
1 1
2 Range check Less than 100 AND greater than 0
1 1
16(c) serial access 1
16(d) 1 magnetic disc 2 direct access
1 1
16(e) 1 name/address/phone number changes 2 new worker starts 3 worker leaves/is sacked/dies
1 1 1
Page 6 Mark Scheme Syllabus Paper CIE IGCSE - Specimen Paper - 2007 0418 1
17 two from:
pressure pad detects weight of burglar light/infra red sensor detects broken beam contact sensor detects door /window opening temperature sensor detects body heat sound sensor detects any noise made by burglar
one mark for each sensor, one mark for each use. Two sensors maximum 4 max
18 three from: more accurate less dangerous doesn’t forget results/graphs automatically produced
3
19(a) two from: car engine fault diagnosis medical diagnosis chess games
2
19(b) four from: current system is observed potential users interviewed potential users given questionnaires existing documents examined user requirements decided system specification decided knowledge base designed inference engine designed design rule base designing a method of displaying the results hardware chosen knowledge base created inference engine created rule base created
4
Page 7 Mark Scheme Syllabus Paper CIE IGCSE - Specimen Paper - 2007 0418 1
20 six from:
Bank Advantages: maximum of two marks from: fewer workers needed - less wages fewer branches needed - less rental workers can be less qualified - lower wages Disadvantages: maximum of two marks from: customer dissatisfaction - lose business initial large expenditure on redundancies initial large expenditure on retraining Customer Advantages: maximum of two marks from: don’t have to spend money on traveling to the bank don’t have to spend time traveling to the bank easier to transfer money from one account to another Disadvantages: maximum of two marks from: hackers could hack into your account loss of personal touch cannot withdraw money
6 max
UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
International General Certificate of Secondary Education MARK SCHEME for the May/June 2008 question paper
0418 INFORMATION TECHNOLOGY
0418/01 Paper 1 (Written), maximum raw mark 120
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.
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.
• CIE will not enter into discussions or correspondence in connection with these mark schemes.
CIE is publishing the mark schemes for the May/June 2008 question papers for most IGCSE, GCE
Advanced Level and Advanced Subsidiary Level syllabuses and some Ordinary Level syllabuses.
Page 2 Mark Scheme Syllabus Paper
IGCSE – May/June 2008 0418 01
© UCLES 2008
1 A Trackerball (1)
B Web cam (1)
C Magnetic stripe reader (1)
D Joystick (1)
E DVD drive (1) [5]
2 Buzzer (1)
Motor (1) [2]
3 F (1)
T (1)
F (1)
T (1)
F (1) [5]
4 (a) a keyboard (1)
(b) a school register (1)
(c) a floppy disc (1)
(d) a graph plotter (1) [4]
5 Three from:
Giving software copies to others without the owner’s permission
Making a copy of a disk without the owner’s permission
Selling copies of the software without the owner’s permission
Using the software on a network when the licence does not allow it
Renting out the software on a network when the licence does not allow it
Renting out the software/sharing software with others without the permission of the owner
Using the copyright name on other software
Amending software/using parts of code in own programs without permission
Buying pirated software [3]
Page 3 Mark Scheme Syllabus Paper
IGCSE – May/June 2008 0418 01
© UCLES 2008
6 Penup
Forward 20
Right 90 Right 90 and Pendown interchangeable
Pendown
Forward 75
Right 90
Forward 80
Penup
Forward 85
Pendown
Forward 55
Right 90
Forward 50
Penup
Forward 25
Pendown Pendown and Right 90 interchangeable
Right 90
Forward 75
1 mark for each group of 3/4 statements [5]
7 (a) Three from:
ROM cannot be changed/permanent/RAM is temporary memory
RAM can be read from and written to
RAM is volatile/ROM is non-volatile
ROM is read only memory and RAM is random access memory [3]
(b) ROM stores BIOS/program cycles in a washing machine/program instructions in games (1)
RAM holds the data currently being used by the user (1) [2]
8 Problem – electrocution
Prevention – RCB installed/cable insulation
Problem – trailing cables
Prevention – create ducts/cover cables with carpets/description of how length of cabling could be
reduced e.g. WiFi
Problem – heavy equipment falling
Prevention – large/sturdy tables
Problem – fire
Prevention – appropriate type of extinguisher/regular maintenance of equipment/ventilation
1 mark for each problem (2 max)
1 mark for each prevention (2 max) [4]
Page 4 Mark Scheme Syllabus Paper
IGCSE – May/June 2008 0418 01
© UCLES 2008
9 (a) Destination/country/resort name (1)
Features such as:
Hotel name/name of campsite/length of stay/Resort features/type of room/star rating/name of
nearest airport to resort/name of departure airport(s)/length of flight/places of interest to visit/
type of holiday/dates of availability/reference number of holiday/price of holiday/picture of
resort or hotel
(3 marks for 5 items, 2 for 4 items, 1 for 3 items, else 0)
Information fills the page AND is clearly a screen form (1) [5]
(b) Two from:
Data is entered twice
Data versions are compared by computer
If versions are different, typist is alerted (2)
Two from:
Data on screen/in system
Is visually compared with
that on data capture form (2) [4]
(c) Three from:
Validation is checking data entered
Is acceptable/reasonable/within a given range
Verification is checking versions of data have been entered identically/is checking data has
been copied correctly
From one medium to another (3)
Two from:
Range check
Check digit
Control total
Hash total
Invalid character check/type check
Picture/format check/input mask
Presence check
Existency check
Length check (2) [5]
Page 5 Mark Scheme Syllabus Paper
IGCSE – May/June 2008 0418 01
© UCLES 2008
(d) Six from:
Parallel running/implementation
Information is not lost/always a second copy
Have to pay two sets of workers
Phased implementation
Still have most of system if things go wrong
No expense of running two systems together
Lose some data if things go wrong
Direct implementation/changeover
Time is not lost
Do not have expense of running two systems together
If things go wrong lose all data
Pilot running
Pilot/phased/parallel are slow methods of implementation (6) +1 for reasoned conclusion [7]
(e) Technical:
Purpose – (help programmers/analysts) make improvements to system/repair system/
maintain system (1) Two from:
Program listing
Flowchart/algorithm
List of variables
File structure
Purpose of the system
Purpose of the program
Screen layouts
Print formats
Hardware requirements
Software requirements
Sample runs
Known bugs
Error messages
Validation routines (2) User:
Purpose – help users to learn how to use system (1) Two from:
How to load software/run software
How to save a file
How to search
How to sort
How to print
How to add records
How to delete/edit records
Troubleshooting guide
Screen layouts (only if not mentioned in technical documentation)
Error messages (only if not mentioned in technical documentation)
Print formats (only if not mentioned in technical documentation)
Hardware requirements (only if not mentioned in technical documentation)
Software requirements (only if not mentioned in technical documentation)
Sample runs (only if not mentioned in technical documentation)
Tutorials (2) [6]
Page 6 Mark Scheme Syllabus Paper
IGCSE – May/June 2008 0418 01
© UCLES 2008
10 Three from:
Increased unemployment
Increased employment (with reasons)
Have had to retrain
Less noise/more pleasant environment
Safer environment
Less heavy lifting/healthier work
Workers can be deskilled [3]
11 (a) Four from:
Doctors interviewed for requirements
Data is collected from experts
Knowledge base is designed/created
Rule base is designed/created
Inference engine is designed/created
Input Screen is designed/created
Output format is designed/created (4)
Ailments with known diagnoses are used to test the system and results evaluated/does new
system match original system specification/interviewing doctors about effectiveness of
system (1) [5]
(b) Two from:
(Car engine) fault diagnosis
Prospecting
Tax
Careers
Chess games
Animal/plant classification [2]
12 (a) Three from:
Temperature
Pressure
Moisture
Humidity
Light
Motion [3]
(b) Sensor measures analogue data (1)
Computer works with digital data (1) [2]
(c) Three from:
Computer can take readings during holidays/readings can be taken any time of day or
night/24/7/do not take breaks
Computer readings are more accurate
Readings can be taken more frequently
Can produce graphs/results more quickly
Computer doesn’t forget to take readings [3]
Page 7 Mark Scheme Syllabus Paper
IGCSE – May/June 2008 0418 01
© UCLES 2008
(d) Five from:
Save spreadsheet in suitable format
Create graphs
Load/open word processing software
Insert spreadsheet/import spreadsheet/copy and paste spreadsheet/embed spreadsheet into
document
Insert/copy and paste graphs
Type in/insert text
Insert/import images
Format images/charts
Format reports/text [5]
13 Producing utility bills (1)
Inputting details of new stock into a library’s database (1)
Reading data from bank cheques (1) [3]
14 (a) (i) Ring (1)
(ii) Star (1) [2]
(b) Advantages
Two from:
Share hardware
Share software
Share data/information
(Electronic) communication
Users can be more effectively controlled/monitored (2)
Disadvantages
Two from:
Work can be misused more easily
Viruses more easily spread
Printer queues
Slower access to Internet
If server crashes all computers are affected
Increased security risk (2) [4]
15 (a) 5 [1]
(b) 4 [1]
(c) 0027200190653 5 [1]
(d) Number in stock [1]
(e) Text/alphanumeric [1]
Page 8 Mark Scheme Syllabus Paper
IGCSE – May/June 2008 0418 01
© UCLES 2008
(f) Bar code [1]
(g) Four from:
Bar code is entered
The bar code field in the data file is read
Record by record
Until a match is found with the bar code entered
The corresponding number in stock is read
One is subtracted from this number
Written back to file
No. in stock checked with re-order quantity
If < = re-order quantity
then re-ordered/flagged [4]
(h) Five from:
Card details checked for validity
PIN is entered
PIN is read from chip
Numbers compared
If identical transaction is authorised
If not identical transaction refused
Customer bank contacted by computer/automatically
Check if enough funds in account
If card invalid/insufficient funds then transaction is rejected
If card valid and sufficient funds then transaction is authorised
Money deducted from customer account
Money credited to supermarket account [5]
(i) Two from:
User name/account number
Password/PIN [2]
(j) Two from:
Key needed to encrypt
Data is jumbled up/encoded
Key must be known to decrypt it
Prevents people from understanding data [3]
Page 9 Mark Scheme Syllabus Paper
IGCSE – May/June 2008 0418 01
© UCLES 2008
(k) Eight from:
Customer – advantages
Less danger of mugging
Don’t have to waste time travelling (long distances to shops)
Elderly/Disabled people don’t have to travel to shop/leave home
Don’t have to spend money on travelling expenses travelling (long distances to shops)
Greater choice of goods
Can shop when shops are closed
Easier to search and find what you’re looking for
Customer – disadvantages
Lack of socialising/social contacts
Customers must have a computer/Internet access/(basic) computer skills
Hackers may intercept data and defraud customer
Deprived of personal touch
Phone bills can increase
Without broadband other family members cannot use the phone
Cannot see/feel goods in reality
More vulnerable to phishing
Goods sometimes don’t arrive/substitute goods may be sent/take longer to arrive
Must have a credit card
Shipping charges
Shop – advantages
Fewer staff needed/less spent on wages
Fewer shops needed/less spent on rates/rent
Less actual cash handled/fewer robberies
Less money spent on security staff
Potentially larger customer base
Shop – disadvantages
Initial outlay on computers is expensive
Need to retrain staff
Less customer loyalty/loss of customers due to lack of personal touch
Costs of system maintenance
Greater costs due to more delivery staff [8]
Full marks can only be awarded if at least 1 mark from each section is achieved.
Max 5 from any one section.
UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
International General Certificate of Secondary Education MARK SCHEME for the October/November 2008 question paper
0418 INFORMATION TECHNOLOGY
0418/01 Paper 1 (Written), maximum raw mark 120
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.
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.
• CIE will not enter into discussions or correspondence in connection with these mark schemes.
CIE is publishing the mark schemes for the October/November 2008 question papers for most IGCSE,
GCE Advanced Level and Advanced Subsidiary Level syllabuses and some Ordinary Level
syllabuses.
Page 2 Mark Scheme Syllabus Paper
IGCSE – October/November 2008 0418 01
© UCLES 2008
Question
Number
Answer Part
mark
1
A Desktop computer
B Laser printer
C Pin pad
D Microphone
E Laptop computer
[1]
[1]
[1]
[1]
[1]
2
CD ROM DVD ROM DVD R
Floppy disc Hard disc Memory Stick
[1] [1]
3
F
T
T
F
T
[1]
[1]
[1]
[1]
[1]
4
Dot Matrix printer high quality high volume output
Laser printer high quality low volume output
Inkjet printer multimedia presentation
Monitor high quality very large printouts
Graph plotter continuous stationery
[1]
[1]
[1]
[1]
[1]
5 (a) Magnetic tape [1]
(b) Chip [1]
(c) DVD ROM [1]
(d) Bar code [1]
6 Right 90
Forward 70
Right 90
Forward 60
Penup
Forward 80
Pendown
Forward 85
Penup
Right 90 these two are interchangeable
Forward 50
Pendown
Forward 20
Right 90
Forward 100
1 mark for each group of 3 statements
[5]
Page 3 Mark Scheme Syllabus Paper
IGCSE – October/November 2008 0418 01
© UCLES 2008
7
(a) (b) (c)
1 mark
each
[total 3]
8 Two from:
Faster to arrive/to be delivered
Cheaper must be qualified (e.g. paying for a phone call is cheaper than buying a
stamp/cheaper than paying transport costs)
You don’t have to leave your house to send e-mail.
Email can be accessed/read from any location
Replies to e-mails can be quicker.
Easier (cheaper, quicker) to send same message to many people
[2]
9 (a) Interview shop assistants / customers / Hussain / OR face-to-face question session
Can change script to suit circumstances / questions can be explained / repeated /
interviewer can interpret body language
Observing shop assistants / customers / Hussain / OR watching over the whole
process
Can gain broader overview of processes / saves workers’ time / can gain a more
accurate view of what is happening
Examining documents used in current system
Can follow data flow more easily / informs input / output format design
Distributing questionnaires to shop assistants / customers / Hussain / OR using
written questions to gather responses
Better for busy people / don’t have to prearrange appointments / more honest as
they are anonymous / takes less time to get all the results (compared with e.g.
interview)
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
(b) Title
Author’s name
Reference / Accession number / ISBN / Bar code number / Publisher / Picture of
cover / Dewey number / genre / category / fiction or non-fiction / target age group /
picture of author / date published / place published / summary of contents / critique / no. of copies / price / edition / number of pages / hardback or paperback / language
Information fills the page AND is clearly a screen form
Appropriate sizing for each field
[1]
[1]
2 marks
for 4
items, 1
mark for
3 items
else 0
[1]
[1]
[max. 5]
(c) Three from:
Field name
Field Type
Field Length
Key Field
Validation Check
Index
Input mask
[3]
Page 4 Mark Scheme Syllabus Paper
IGCSE – October/November 2008 0418 01
© UCLES 2008
(d) Normal data
Data which is acceptable / within the given range / accept example
Abnormal data
Data of the wrong type / outside the given range / accept example
Extreme data
Data at either end of the range allowed / accept example
[1]
[1]
[1]
[1]
[1]
[1]
(e) Three matched pairs from:
Parallel running / implementation
Have to pay two sets of workers / takes a long time before system is (fully)
implemented/individual transactions take longer
Direct changeover
If unsuccessful lose all the data / no backup
Pilot running
If unsuccessful lose some data / takes a long time before system is (fully)
implemented
Phased implementation
If unsuccessful lose some data / takes a long time before system is (fully)
implemented
[6]
(f) Three from:
The ease of use (of the solution)
The appropriateness of the solution
Compare the solution with the original task requirements / old system / design /
objectives of system / users needs
(Identify any) limitations
(Identify any) improvements which can be made to the system
Evaluating the users' responses (to the results of testing the system)
[3]
(g) Three from:
RSI – wrists
RSI – fingers
Headaches
Back problems / neck pain
Sight problems / eye strain / dry eyes
[3]
10 Three from:
Are input devices
Card inserted into card reader / chip reader
Used with bank cards / credit cards
Used at ATMs or EFTPOS systems
PIN is typed in (using PIN PAD)
Details on chip are read by chip reader
PIN entered is compared with PIN on chip
[3]
11 On-line
Batch
On-line
Batch
[1]
[1]
[1]
[1]
12 (a) E2 [1]
(b) Any cell in range A1:A6 OR A1:E1 [1]
(c) = C2-B2 [1]
Page 5 Mark Scheme Syllabus Paper
IGCSE – October/November 2008 0418 01
© UCLES 2008
(d) Copy D2
Highlight D3:D6
Click paste
OR
Select / Go to / Click / Highlight D2 / drag from D2
Using fill handle / little black square / cross in bottom right hand corner of cell
Drag down to D6
OR
Select / Go to / Click / Highlight D2 / drag from D2
Drag down to D6
Fill down
1 for
each
line
[3 max]
(e) 6 [1]
(f) Two from:
Named simulation e.g. car driving simulation
Flight simulation / pilot training
Mathematical models
Scientific models
Civil engineering models / buildings / engineering / architectural
Weather model
Supermarket queues
Chemical reactions
Nuclear reactions
Economic models
Space exploration model
Car crash model
[2]
(g) Two from:
Some situations are / real thing might be dangerous / it (model) is less dangerous
Cost of building real thing / materials
It may take a long time to obtain results from the real thing
Easier to modify
[2]
13 Six from:
Input – answers typed in / symptoms are typed in
Processing –
Expert system compares symptoms
Compares symptoms with those in the knowledge base
Compares symptoms using inference engine
Compares symptoms using rules base
Matches of symptoms are found
Output –
Questions asked by system
Suggested / possible diagnoses
[6]
14 (a) Three from:
Humidity
Moisture
Temperature
pH
Light
[3]
(b) Sensors produce analogue data / signal
Computers work in digital
[1]
[1]
(c) Analogue to digital converter / ADC [1]
Page 6 Mark Scheme Syllabus Paper
IGCSE – October/November 2008 0418 01
© UCLES 2008
(d) Two from:
(Computer readings are) more accurate / precise
Readings can be taken more frequently.
Readings can be taken any time of day or night / operates 24/7 / no breaks
needed
Can produce graphs more quickly
More reliable / readings taken at regular intervals / computers don’t forget to take
readings
[2]
15 (a) Three from:
Several people can take part in a conference regardless of where they are
People are connected online / using internet
Images of the members of conference appear on the screen
Software is needed in each computer to operate the conference
Codec is needed
People who speak can be heard/seen by all the other people in the conference
1 mark for relevant hardware (at least two items)
[3]
(b) Two from:
Do not have to pay for conference room / less expensive than hiring larger
accommodation
Time is not wasted in travelling to a venue
Do not have to pay employee travelling expenses
Do not have to pay for hotel rooms / overnight stays
Conferences can be called at short notice
Can ensure safety of employees
[2]
16 Technical
Technical
Technical
User
[1]
[1]
[1]
[1]
17 DTP three from:
Advantages
Disabled people / elderly people do not have to go to the library
It can be printed in Braille
You can read it at a time which suits you Disadvantages
Need for physical distribution
No sound
No animation
No video
Printing costs/paper and ink costs Presentation three from:
Advantages
Sound
Animation
Video
Interactive / hyperlinks Disadvantages
Library will need to have screen / computer / appropriate software
Not everyone will visit the library / takes time to go to the library / costs money to
travel to the library / may not get information to every household / may not be seen
by everyone Must have at least one disadvantage and one advantage to get full marks
There is a mark available for a reasoned conclusion
[6]
Page 7 Mark Scheme Syllabus Paper
IGCSE – October/November 2008 0418 01
© UCLES 2008
18 Eight from:
Advantages
Less danger of mugging
Saves time rather than queuing
Don’t have to waste time travelling to shops / banks / theatres etc.
Disabled people don’t have to travel / leave home
Don’t have to spend money on travelling expenses (travelling long distances
to shops / banks / theatres)
Greater choice of goods / seats
Can shop when shops / bank are closed / can book tickets when theatres are
closed / can shop / bank / book 24/7
Less traffic pollution
Disadvantages
Lack of socialising / social contacts
Customers must have a computer / (basic) computer skills
Hackers may intercept data / defraud customer
Deprived of personal touch
Phone bills can increase
Without broadband other family members cannot use the phone
Cannot see / feel goods in reality
More vulnerable to phishing
Lack of exercise
May not get the exact goods they ordered
A mark is available for a reasoned conclusion
Max 5 from either advantages or disadvantages
[8]
UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
International General Certificate of Secondary Education MARK SCHEME for the May/June 2009 question paper
for the guidance of teachers
0417 INFORMATION AND COMMUNICATION
TECHNOLOGY
0417/01 Paper 1 (Written), maximum raw mark 120
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 must be read in conjunction with the question papers and the report on the
examination.
• CIE will not enter into discussions or correspondence in connection with these mark schemes.
CIE is publishing the mark schemes for the May/June 2009 question papers for most IGCSE, GCE
Advanced Level and Advanced Subsidiary Level syllabuses and some Ordinary Level syllabuses.
Page 2 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – May/June 2009 0417 01
© UCLES 2009
1 A Magnetic stripe (1)
B Magnetic ink characters (1)
C Chip (1)
D Optical marks (1)
E Bar code (1) [5]
2 Graphics tablet (1)
Touch screen (1) [2]
3 F (1)
F (1)
T (1)
T (1)
F (1) [5]
4 Desk top publishing ! producing a school magazine (1)
Measuring program ! monitoring temperature in a science experiment (1)
Spreadsheet ! managing personal finance (1)
Inference engine ! suggesting medical diagnoses (1)
Database ! storing pupil records in a school (1) [5]
5 (a) Numeric (Integer) (1)
(b) Alphanumeric (1)
(c) Boolean (1)
(d) Date (1) [4]
6 Forward 80
Right 90
Forward 180
Right 90
Forward 70
Penup
Forward 10
Pendown Pendown and Right 90 are interchangeable
Right 90
Forward 80
(Left 90)
1 mark for each pair of statements [5]
Page 3 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – May/June 2009 0417 01
© UCLES 2009
7 (a) Hybrid/tree (1) [1]
(b) Star (1)
Bus (1) [2]
(c) (i) A hub (1)
(ii) A switch (1)
(iii) A proxy server (1)
(iv) A bridge (1) [4]
8 F (1)
T (1)
T (1)
F (1) [4]
9 Real Time (1)
Batch (1)
Real Time (1)
Batch (1) [4]
10 (a) 1 [1]
(b) A4 [1]
(c) Any cell in the range B2 to F5 [1]
(d) (=) D2*E2 [1]
(e) Fill down (1)! Copy and paste (1)! Dragging the fill handle down (1) [3]
Page 4 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – May/June 2009 0417 01
© UCLES 2009
11 (a) Questionnaires (1)
Interviews (1)
Examination of documents (1)
Observation (1) [4]
(b) To detect typing errors/data entry errors/transcription errors [1]
(c) Either:
Visual verification (1)
Typed in data is visually compared with original data (1)
Or
Double entry (1)
Date is typed in twice and computer compares the two versions (1) [2 max]
(d) Four from:
Name
Title/gender
Customer number/id
Address
Post code
(Work/Mobile) phone number
(Home/Mobile) phone number
Email address
Car registration number(s) [4]
(e) Four from:
Button to close form
Button to first record/form
Button to end of file/new record
Button to previous record/form
Button to next record/form
Submit/continue button
Space to enter required record number
Search facility/engine
Button to go to sub forms [4]
(f) Field names (1)
Validation routines (1)
Field Lengths (1) [3]
(g) Three from:
Parallel running
Pilot running
Phased implementation
Direct changeover [3]
(h) The appropriateness of the solution (1)
Comparing the solution with the original task requirements (1)
Any improvements which can be made to the system (1) [3]
Page 5 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – May/June 2009 0417 01
© UCLES 2009
12 (a) Two from:
Flight/pilot simulation/training
Large scale chemical experiments
Design of fairground rides
Design of large buildings/bridges
Traffic control
Building fire simulation
Car driving simulation
Drug trials [2]
(b) Three from:
Real thing may be too expensive to build
Real thing requires too large a time scale
Real thing would be too wasteful of materials
Real thing is too vast a scale
Real thing may occur too rarely
Rate of change can be adjusted for human eye to detect
Corrections can be made if mistakes in real thing/amendments are easier in a model [3]
13 Inference engine (1)
Interactive input screen (1)
Knowledge base (1)
Rules base (1) [4]
14 (a) RSI (1)
Headaches (1) [2]
(b) Take regular breaks (1)
Put a screen filter in front of the monitor (1) [2]
(c) Electrocution (1)
Fire (1) [2]
(d) Don’t overload electrical sockets (1)
Make sure there are no bare wires (1) [2]
15 Three from:
Keyboard/typing in data
A bar code (reader)
A magnetic stripe (reader)
Touch screen
Three from:
Scanning bar codes/swiping magnetic stripes/touch screen gives fast data entry/keying in data
can be slow
Scanning bar codes/swiping magnetic stripes/touch screen reduces errors/keying in data can
lead to data errors
Keyboards/touch screens are robust/bar codes can be flimsy
Magnetic stripes are more robust than bar codes [6]
Page 6 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – May/June 2009 0417 01
© UCLES 2009
16 (a) Three from:
Reduced cost of wage bill
Computer readings are more accurate/human errors are reduced
Readings can be taken more frequently/continuously
Nurses can get tired and forget to take readings
Nurses are so busy they might not be able to take readings regularly
Nurses won’t be exposed to contagious diseases
Automatic warnings can be generated
Graphs can be produced automatically
Nurses can be freed up to do other tasks [3]
(b) Four from:
Sensors are used (to generate data)
Data are then sent to computer
Sensors read analogue data
Computers work with digital data only
Data needs to be converted so computers can process/understand data [4]
17 Six from:
Advantages
Workers can use own office so documents do not get lost in transit/bulky documents/equipment
do not have to be carried around
Company can call meeting at short notice
Employees can work from home
Company does not have to pay travelling expenses
Company does not have to pay hotel expenses
Company does not have to pay for conference room facilities
Travelling time is saved
Might be dangerous to fly/travel
Disabled people may find it difficult to travel
Disadvantages
Takes time to train employees
Difficult to call international meetings because of time differences
Initial cost of hardware
Equipment can break down
Strength of signal/bandwith/lipsync can be a problem/connection can be lost/power cuts
Loss of personal/social contact
Takes time for workers to learn new technology
Can’t sign documents
Max. 4 advantages/disadvantages
One mark available for reasoned conclusion [6]
Page 7 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – May/June 2009 0417 01
© UCLES 2009
18 Four from:
Data more difficult to copy
Extra layer of security with PIN number
Even if stolen card cannot be used unless thief knows PIN number
Larger amount of information can be stored
Disabled people find it easier than signing
Reduces disputes at checkouts over validity of signature/
Saves time at checkouts
Not affected by magnetic fields [4]
19 Eight from:
Fax
Advantages
Can be used as a legal document
Documents can be very long
Disadvantages
Cannot be certain if correct person has received it
Very slow transmission rates
Not very good quality
Documents cannot be edited easily
Cannot send multimedia files
Won’t be received if line is busy/receiving fax machine switched off/out of paper
Wastes/expense of ink/paper
Advantages
Can be confident message will only go to the correct person (if addressed correctly)
Fast transmission times
Attachments can be downloaded and edited
Easier to send large documents
Disadvantages
Can be slow turnaround times
Some systems have limits to size of attachments
Addresses more difficult to remember than phone numbers
Description of how phishing can occur
Description of how viruses can be transmitted
Bulletin boards
Advantages
You don’t need an ISP
Messages can be moderated
Automatically creates an archive
Disadvantages
Lack of privacy (every member of the group can see every message)
In older systems only one person can be online at one time
Doesn’t alert you to incoming messages
One mark available for reasoned conclusion [8]
UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
International General Certificate of Secondary Education MARK SCHEME for the October/November 2009 question paper
for the guidance of teachers
0417 INFORMATION TECHNOLOGY
0417/01 Paper 1 (Written), maximum raw mark 120
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 must be read in conjunction with the question papers and the report on the
examination.
• CIE will not enter into discussions or correspondence in connection with these mark schemes.
CIE is publishing the mark schemes for the October/November 2009 question papers for most IGCSE,
GCE Advanced Level and Advanced Subsidiary Level syllabuses and some Ordinary Level
syllabuses.
Page 2 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – October/November 2009 0417 01
Question
Number Answer
Part
mark
1
A Scanner
B Dot matrix printer
C Hard disc drive
D Graphics tablet
E Multimedia projector
[1]
[1]
[1]
[1]
[1]
2
Bar code reader Keyboard Laser printer
Memory Stick Mouse Zip disc drive
[1] [1]
3
True False
Dot matrix printers produce high quality output ! [1]
Laser printers are very noisy ! [1]
Graph plotters are used when extremely large hard
copy is required ! [1]
Inkjet printers are used where continuous stationery
is required !
[1]
4 (a)
(b)
(c)
(d)
A mouse
A bank cheque
A memory stick
A microphone
[1]
[1]
[1]
[1]
5
True False
RAM is not volatile ! [1]
ROM is used to store the BIOS of a computer ! [1]
The data in ROM is easier to change than that in
RAM ! [1]
RAM is used to store the data the user is currently
working on ! [1]
6 Triangle:
1 mark for a correct loop e.g. REPEAT 3, END REPEAT
1 mark for RIGHT 120
Backward sequence
1 mark for PENUP, BACKWARD 80, PENDOWN
Square:
1 mark for a correct loop e.g. REPEAT 4, END REPEAT
1 mark for FORWARD 100 coming immediately after RIGHT 90 as given
[5]
Page 3 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – October/November 2009 0417 01
7
Health Safety
Headaches caused by prolonged use !
[1]
Trailing wires in a computer room !
[1]
RSI though continual typing !
[1]
Back problems through bad posture !
[1]
Too many plugs in an electric socket !
[1]
Drinking water whilst using a computer !
[1]
8
Producing utility bills
Paying for goods at an EFTPOS terminal ! [1]
Making an airline booking ! [1]
Producing monthly payrolls
Monitoring a patient’s condition in a hospital ! [1]
Reading data from bank cheques
9 (a) Four from
ID number/Borrower number
Photo of borrower
Name
Address
Post code
Email address
Gender/Title
Date of Birth
Max. two from:
Home Phone number
Work Phone number
Mobile Phone number
[4]
Page 4 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – October/November 2009 0417 01
(b) Four from:
Data fills the screen
Clearly defined input area for each record
Appropriate spacing for each field
Back button/arrow/previous record facility
Forward button/arrow/next record facility
Number of record is on screen
Submit button/facility
First record button/facility
Last record button/facility
An easy to read font/font size/
A sensible font colour/background colour
Easy to follow instructions for completing screen/help icon
No overlapping of items
Exit button/return to homepage button/facility
[4]
(c) Double entry/data entered twice
computer compares the two versions
Visual checking/verification
Typed in data is compared with original data
[1]
[1]
[1]
[1]
(d) Three from
Normal data is data which is within an acceptable range/ is usual for the situation
Any example between 1 and 6
Extreme data is data which is at either end of a normal range of data
Examples: 1, 6
Abnormal data is data which is outside the acceptable range/is of the wrong
data type
Example: any negative number or number greater than 6 or text example
[1]
[1]
[1]
[1]
[1]
[1]
(e)
Improvements can be made ! [1]
The hardware and software can be specified
Limitations of the system can be identified ! [1]
To see how many books are required
To make sure the user is satisfied with the system ! [1]
So that program coding can be written
Page 5 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – October/November 2009 0417 01
(f) Technical
Three from:
Program listing
Programming language
Flowchart/algorithm
List of variables
File structure
Purpose of the system/program
Input format or example
Output format or example
Hardware requirements
Software requirements
Sample runs/test runs
Known bugs/possible errors
Validation rules
User
Three from:
How to load software/run software/install software.
How to save a file.
How to search
How to sort
How to print
How to add records
How to delete/edit records
Purpose of the system/program (only if not mentioned in technical documentation)
Input format or example (only if not mentioned in technical documentation)
Output format or example (only if not mentioned in technical documentation)
Hardware requirements (only if not mentioned in technical documentation)
Software requirements (only if not mentioned in technical documentation)
Sample runs (only if not mentioned in technical documentation)
Error messages (only if not mentioned in technical documentation)
Error handling
Tutorials
Troubleshooting guide/Contact details/help line/FAQ
[3 max]
[3 max]
10
The customer types in the PIN 3 [1]
If the PIN and the number stored in the chip are the same go onto the
next step 5
[1]
The customer’s account is checked to see if it has sufficient funds 7 [1]
The card is inserted into the reader 1
The PIN number is compared with that stored in the chip 4 [1]
The transaction is authorized 8 [1]
The device checks if the card is valid 2 [1]
The supermarket computer contacts the customer’s bank computer 6 [1]
[Total: 7]
Page 6 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – October/November 2009 0417 01
11 (a) Six from:
Interactive user screen appears
Details of car type are entered
Questions about engine problems are asked/on-board computer connected to
expert system
Answers to questions/engine problems are typed in
Inference engine searches
Searches the Knowledge base
using the Rules (base)
Suggested probabilities of faults are output
In the form of a report to the mechanic/on screen output
[6]
(b) Two from:
Medical diagnosis
Mineral prospecting
Chess games
Plant identification
Animal identification
Tax advice
Careers advice/guidance
Insurance
Drug efficacy
[2]
12 (a)
Pressure sensor ! [1]
Proximity sensor
Temperature sensor ! [1]
Oxygen sensor
(b) Computers work in digital
Sensors produce analogue data
[1]
[1]
(c) Five from:
Microprocessor continually monitors sensors
Data is converted from analogue to digital/ADC is used
Compares water level with pre-programmed value
If water level reached microprocessor switches off valve
Else valve left on/switched on
Compares temperature with pre-programmed value
If temperature higher microprocessor switches off heater
Else heater left on/switched on
Compares weight of clothes with pre-programmed value
If clothes too heavy microprocessor sounds alarm/stops machine/motor stops
running
Else cycle continues/motor starts
[5]
Page 7 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – October/November 2009 0417 01
(d) Four from:
Microprocessor controlled devices do much of housework
Do not need to do many things manually
Do not need to be in the house when food is cooking
Do not need to be in the house when clothes are being washed
Can leave their home to go shopping/work at any time of the day
Greater social interaction/more family time
More time to go out/more leisure time/more time to do other things/work
Are able to do other leisure activities when convenient to them
Can lead to unhealthy eating due to dependency on ready meals
Can lead to laziness/lack of fitness
Can encourage a healthy lifestyle because of smart fridges analyzing food
constituents
[4]
13 (a) Two from:
Modem
Router
Or any other suitable answer
[2]
(b) Five from:
WAN is a wide area network
WAN covers a large geographical area/worldwide
The Internet is a WAN
LAN is a Local Area Network
LAN covers a small area such as one building/A school network is a LAN
A WAN consists of connected LANs
More difficult to share peripherals using a WAN
[5]
14 (a) 4 [1]
(b) 5 [1]
(c) Product type [1]
(d) Mupe [1]
(e) Bar code [1]
(f) Range check
Two from:
Values less than 0 (or ‘lower limit’) or more than an upper limit
Will be rejected/not allowed/must be within
A correct example can be awarded both marks
[1]
[2]
15
Graph plotter
Trackerball
Microphone ! [1]
Speakers ! [1]
Optical mark reader
Web cam ! [1]
Page 8 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – October/November 2009 0417 01
16 Three from
User ID/Passwords/PIN
User ID/Password/PIN entered is compared with that held on system/never
tell anyone your password/regularly change password/make it not easy to
guess/only person who knows password can access account
Encryption
Data is scrambled up/key must be known to unscramble it/prevents people
from understanding data
Firewall
Prevents unauthorised users/computers from accessing network
Digital certificates
Transactions are digitally signed/authenticated/transaction is linked to the PC
being used to carry out online banking
Anti Spyware
Prevents spyware from invading your computer and gaining personal information
Make sure website is secure
Locked padlock is present on display
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[Total: 6 max]
17 Eight from:
Drawbacks:
Not all information is accurate
Some information is purely for advertising/selling purposes
Might need proxy server to prevent access to certain types of site
Some information is pornographic
Anyone can put information on the Internet
Much of the information on the Internet is not filtered
Need to identify the validity of the author
Need to be careful about whether information is fact or opinion
Information can be biased
Results from search engine could be skewed because of
sponsorship/marketing
Internet is not policed
So much information available which might be unreliable
Benefits:
Wide range of information to select (desirable/reliable information)
Able to search quickly (using search engines) to find (reliable/desirable)
information
Information can be downloaded and edited (to make it desirable/reliable)
Can use the final part of a URL to identify reliability
Information can be up to date/real time so reliable
.ac, .gov, .org are usually fairly reliable
Can compare information from sites to see if it is reliable
[8]
UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
International General Certificate of Secondary Education MARK SCHEME for the May/June 2010 question paper
for the guidance of teachers
0417 INFORMATION AND COMMUNICATION
TECHNOLOGY
0417/11 Paper 11 (Written), maximum raw mark 100
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 must be read in conjunction with the question papers and the report on the
examination.
• CIE will not enter into discussions or correspondence in connection with these mark schemes.
CIE is publishing the mark schemes for the May/June 2010 question papers for most IGCSE, GCE
Advanced Level and Advanced Subsidiary Level syllabuses and some Ordinary Level syllabuses.
Page 2 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – May/June 2010 0417 11
© UCLES 2010
Ques.
No.
Answer Part
mark
1
A DVD RAM B Pen drive
C Magnetic tape D Magnetic disc
1, 1
1, 1
2
Blu ray disc Graph plotter Graphics tablet
Optical mark reader Projector Web cam
1
1
3
TRUE FALSE
Input devices are examples of hardware. !
Backing storage devices are examples of software. !
A Graphic User Interface is a part of an operating system. !
A laptop computer cannot be carried around. !
1
1
1
1
4
Remote Control to input freehand drawings into a computer
Keyboard operating a television
Touch screen entering text when writing a book
Chip reader selecting options in a tourist information kiosk
Graphics tablet reading information from a credit card
1
1
1
1
1
5 (a)
(b)
(c)
(d)
a hub is a device used to connect computers together to form a LAN
an Intranet is a network with restricted access
a Proxy server can allow networked computers to connect to the internet
a WLAN is a wireless local area network
1
1
1
1
6 Three from:
Pen drives have greater storage capacity
Pen drives are more portable
Not all machines have CD drives
Faster access to data
More robust
More secure as biometric data can be incorporated
Don’t need specialist hardware/software for pen drives
3
Page 3 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – May/June 2010 0417 11
© UCLES 2010
7 PENUP
FORWARD 70
PENDOWN
FORWARD 60
PENUP
FORWARD 80
RIGHT 90/PENDOWN
PENDOWN/RIGHT 90
FORWARD 80
RIGHT 90
FORWARD 100
1 mark for each 2/3 statements
5
8
Web logs !
Databases
Models
Wikis !
DTP
Social networking sites !
1
1
1
9
TRUE FALSE
Withdrawing money from an ATM !
Producing utility bills !
Booking a plane ticket !
Producing payslips !
1
1
1
1
Page 4 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – May/June 2010 0417 11
© UCLES 2010
10 (a) Three from:
Humidity
Moisture
Temperature
Light
pH
CO2
3
(b) Sensors feed back analogue data
Computers can only work with digital/binary data/cannot read analogue
1
1
(c)
Computer readings are more accurate. !
Students always forget to take readings
Students might be unavailable to take readings during school holidays. !
Computers can record data for later use.
Computers can analyse the results.
Computers can react to changes in the conditions immediately. !
1
1
1
(d) Two from:
Earth/chemical particles will not affect its performance.
It can operate without needing to refill the paper as regularly/can work on
continuous paper.
Running costs are low.
2
(e) Two from:
It will be cheaper to buy.
Print outs will be clearer.
It is more compact.
2
11 (a) 4 1
(b) 5 1
(c) Relational database 1
(d) Two from:
Data does not have to be typed in twice/referential integrity.
Quicker to enter new data.
So fewer errors are likely.
So less memory/storage capacity is used.
So it is easier to edit data.
2
(e) Code 1
(f) Book Borrowed 1
(g) Cost 1
(h) Date 1
(i) Range check 1
(j) Format/picture/input mask 1
Page 5 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – May/June 2010 0417 11
© UCLES 2010
12 A router – so that data can be transferred from one network to another
A browser – to access the (world wide) web /view web pages/surf the net
Email – so that he can send messages to people outside the network/home
An ISP – in order that he can access the internet/email/to provide internet service
1
1
1
1
13 (a)
Data encryption techniques are easy to crack.
Data can be accessed without being in the building where it is stored. !
Data thieves do not leave physical signs of robbery. !
Data passwords are easy to guess.
1
1
(b)
Make backups of the data.
Users should write down their password in case they forget it.
Have a firewall connected to the network. !
Have different levels of access to the data. !
1
1
14 (a)
True
(!)
False
(!)
Examining documents has to be done in the presence of all the
workers. !
Appointments have to made with a worker in order to complete
a questionnaire. !
It is possible to change questions in the course of an interview. !
Observing the current system can provide a detailed view of
the workings of the system. !
1
1 1 1
(b)
Inputs to the current system
User and information requirements
Data capture forms !
Validation routines !
Problems with the current system
File structure !
Report layouts !
Limitations of the system
1
1
1
1
Page 6 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – May/June 2010 0417 11
© UCLES 2010
15 Direct changeover – One from:
It is the quickest method of implementation/the benefits are available immediately
Do not have the expense of running two systems
Parallel running
There is always the old system to fall back on in the event of the new system failing
Phased implementation – One from:
Still have rest of old system if new system fails
Training can be gradual
Enables refinement of each phase of the system before fully implementing
3
16 Two strategies and two reasons from:
Strategy – compare the solution with the original task requirements/design brief
Reason – to ensure that requirements have been met
Strategy – identify any limitations/necessary improvements to the system
Reason – so that system works without problems
Strategy – Collect data from the users of the new system
Reason – to see how well they are coping with the new system/ to see how well the
new system works
Strategy – analyse (evaluate) the users’ responses to the results of testing/using
the system
Reason – so that users needs are taken into account
4
(2 + 2)
17 Three from:
Web cam/video camera to input/capture video (images of participants/documents)
router/modem to transmit data to participants’ (computers)
Microphone to input voices of participants/to speak to other participants
Headphones/speakers to output voices to participants/hear other participants
Large screen/projector to see other participants
3
18
The number in stock of the matching record is read 4
Until a match is found with the entered bar code 3
The bar code field in the data file is read record by record 2
The bar code on the product is read by the bar code reader 1
The new value of number in stock is written back to the file 8
If it is equal to the re-order number then more goods are automatically re-
ordered 7
One is subtracted from the number in stock 5
The number in stock is compared with the re-order number 6
1
1
1
1
1
1
1
Page 7 Mark Scheme: Teachers’ version Syllabus Paper
IGCSE – May/June 2010 0417 11
© UCLES 2010
19 Three from:
If the airplane crashed you wouldn’t need to replace it – saving money
If the airplane crashed nobody is injured
It is easy to recreate extreme weather conditions
It is easy to create unusual flying conditions
Can recreate mechanical/computer failure from previous real situations
Cheaper fuel costs
3
20 Phishing
One from:
is using e-mails pretending to be the target's bank
Fake email to get personal details
Pharming
One from:
is installing malicious code on a pc or server to redirect to fake websites
redirecting users to websites which look authentic to get personal details
Spam (is the sending/receiving of) unsolicited/junk emails
1
1
1
21 (a) Two from:
Unlikely to be lost (if addressed correctly)
Faster to arrive
Quicker/easier to send the same message to several people
You don’t have to leave the office to send a letter
2
(b) Two from:
Very large documents can be sent/emails often have a limit to the size of
attachments
Legal documents can be sent/email signatures are not legally binding
Special delivery ensures delivery/If undelivered can be tracked/if lost can claim
compensation
Might not have the software to open attachments
Recipient may not have/doesn’t need email address/access to computers/internet
2