0418 s03 Ms 1+2+3+4

Download as pdf or txt
Download as pdf or txt
You are on page 1of 40

JUNE 2003

INTERNATIONAL GCSE

MARK SCHEME

MAXIMUM MARK: 80

SYLLABUS/COMPONENT: 0418/01
INFORMATION TECHNOLOGY
Paper 1 (Written)

www.xtremepapers.net
Page 1 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 1

Question Part
Answers
Numbers Mark

1 A Laptop computer 1
B Printer 1
C Floppy Disc 1
D Scanner 1
E Joystick 1

2 Scanner 1
Keyboard 1

3 You can get an itemised receipt 1


Supermarkets do not run out of stock so often 1

4 Two from:
Overdue book reminders can be sent automatically
Less time spent on checking books in/out
Fines can be worked out quickly/automatically
Easier/quicker to look up information on borrowers
Easier/quicker to look up information on books
Less space needed
Gives access to Internet to order books etc.
Greater accuracy 2

5 Two from:
Messages can be sent instantaneously by e-mail
You do not have to leave your house to send e-mail
Signatures/important documents cannot be sent by e-mail
Replies to e-mails can be quicker
E-mail can be cheaper/the cost of a phone call is less than the
cost of a stamp
You can send file attachments
Less waste of paper
You need a computer in order to receive e-mails
With e-mails you cannot send physical objects 2

6 RIGHT 90 LEFT 90
REPEAT 6 REPEAT 6
FORWARD 25 BACKWARD 25
LEFT 60 LEFT 60
END REPEAT END REPEAT 5

7 (a) Any cell in column A, apart from A1 1


(b) Any cell in column B, C, D or E, apart from row 1 1
(c) Any cell in column D, apart from D1 or
Any cell in column F, apart from F1 1
(d) = D$*E$ (where $ = same row) except D1*E1 (must have *) 1

© University of Cambridge Local Examinations Syndicate 2003

www.xtremepapers.net
Page 2 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 1

Question Part
Answers
Numbers Mark

8 Input Device = mark sense reader/keyboard/OMR 1


Output Device = Laser printer/ink jet printer/monitor/printer 1

9 Two from:
Take more accurate readings
More readings can be taken in a short period of time
Results can be more easily/quickly produced
Graphs are more easily/automatically produced.
Safety reasons
Does not get tired 2

10 Two from:
Save it to floppy disc/writeable CD ROM
Save to secure network area
Change/use password
Prevent other users seeing the screen 2

Do not accept physical locking

11 Two from:
Desk Top Publishing
Advertising posters/tickets

Spreadsheet
Accounts for the fete

Database
Names/addresses of helpers (parents/pupils)/local companies
(for sending letters)

Word processing
Letters to parents/community advertising fete
Letters to local companies for sponsorship

1 for each separate type of software, 2 max 2


1 for each valid use, 2 max 2

12 Hardware = bar code reader 1


Software = database 1

© University of Cambridge Local Examinations Syndicate 2003

www.xtremepapers.net
Page 3 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 1

Question Part
Answers
Numbers Mark

13 Two from:
It is too dangerous to build the real thing
It is too expensive to build the real thing
It is too time consuming to build the real thing
Time scales are too vast
It is too expensive to change options in the real thing 2

14 Two from:
Do not use disks from unknown sources
Use anti-virus software/virus checker/killer
Do not connect to the Internet/network/WAN/LAN
Do not open attachments from unknown/suspicious sources
Use a firewall 2

15 Two from:
Hackers can access their credit/debit card details
Do not get much exercise from not going out
Fewer social contacts
Cannot see the goods in reality/might turn out to be different to
what was seen on computer/might be out of stock.
Rogue websites
Time consuming/quicker (only if qualified)
Computer fraud 2

16 (a) Three from:


Temperature sensor
Pressure sensor
Moisture sensor
Humidity sensor
Wind sensor
Light sensor
Anemometer
Rain gauge/sensor 3

(b) Two from:


Computer can take readings during holidays
Computer readings are more accurate
Readings can be taken more frequently
Readings can be taken any time of day or night
Graphs are more easily/automatically produced
Data can be more easily/automatically analysed 2

© University of Cambridge Local Examinations Syndicate 2003

www.xtremepapers.net
Page 4 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 1

Question Part
Answers
Numbers Mark

17 (a) Advantages - one from:


Do not have to remember to take their books home/take their
homework to school
Can present their work more neatly
Pupils can share ideas
Less waste of paper 1

Disadvantages - one from:


Must have a home computer
Transmission of viruses
Must have Internet/Modem
Must remember passwords/usernames
Pupils can copy off others 1

(b) Two from:


Parents unable to use the phone
Undesirable sites may be accessed
Phone bills will rise
May receive unsolicited e-mails from undesirable characters
Health reasons
Demand on equipment
Can waste time exploring unreliable sites
Can get distracted playing games 2

18 Two from:
Backache
RSI
Eyestrain
Headaches 2

Two from:
Get straight back chairs/sit with straight back/do not slouch/
finger exercises periodically
Get anti-glare screens/look away from screen periodically
Have eyesight tested/get glasses
Take regular breaks
(There must be a health problem stated before prevention
mark can be awarded) 2

19 Two from:
Cheaper running cost for school - phone bill
Less likely to waste time on irrelevant sites
Information is easier to find
Internet tends to be slower
Teacher knows what responses to expect
Greater validity of data/less likely to encounter distasteful data
on a CD
Internet connections can be unreliable
You do not need a connection to the Internet 2

© University of Cambridge Local Examinations Syndicate 2003

www.xtremepapers.net
Page 5 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 1

Question Part
Answers
Numbers Mark

20 Text = name/form 1
Numeric = students marks/number of absences 1
Boolean/logical = gender/finished paper or not 1
Date = date of test/homework 1

21 (a) Hackers may read the data and pass it on 1


Hackers may delete the data 1
Hackers may amend the data 1

(b) Three from:


Data can be encrypted
Usernames/passwords can be used
Do not connect the computers to a network
If connected to a network use dedicated lines
Physical security - locks on computer room doors
(There must be a misuse stated before prevention mark can be
awarded) 3

22 Four from:
Hackers may intercept data and defraud customer
Customers deprived of personal touch
Banks make more money do not have to have branches in
expensive high streets
Bank workers become unemployed
Bank workers forced to retrain
Easier for customers to mismanage accounts
Easier for customers to make transactions
Do not have to visit branch to make payments
Do not have to wait for post/immediate payments can be made 4

23 Six from:
Laptops can be transported from room to room
Cannot share resources on laptops/more difficult to print out
work
Cannot use laptops to access work that may have been saved
in other lessons
Can use laptops outside the classroom in Science/Geography
Laptops may be more expensive than network stations
Difficult to use keyboard/mouse on laptop
Laptops need recharging from time to time
When the network is down cannot use network computers/can
still use laptops
Can store personal data on laptop
Any other suitable answer 6

© University of Cambridge Local Examinations Syndicate 2003

www.xtremepapers.net
Page 6 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 1

Question Part
Answers
Numbers Mark

24 Three maximum from:


Pressure sensors
Microprocessor
Light sensors
Heat sensors
Contact switches/push switch
Input keypad
Sound sensor
Infra red sensor
Motion sensor/movement sensor 3

Three maximum from:


Pass number input to keypad
Zones selected
Microprocessor continually monitoring sensors
If light sensor deactivated/heat sensor/contact switch/pressure
pad activated
Microprocessor sends signal to sound alarm/flashing
light/house lights
Alarm Light flashes/lights come on/alarm sounds
Signal automatically sent to police 3

5 max
total

© University of Cambridge Local Examinations Syndicate 2003

www.xtremepapers.net
www.xtremepapers.net
JUNE 2003

INTERNATIONAL GCSE

MARK SCHEME

MAXIMUM MARK: 80

SYLLABUS/COMPONENT: 0418/02
INFORMATION TECHNOLOGY
Paper 2 (Written)

www.xtremepapers.net
Page 1 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 2

Question Part
Answers
Numbers Mark

1 Plotter 1
Speaker 1

2 CD ROM 1
Magnetic tape 1

3 MIDI 1

4 Human error 1

5 Control 1
Coding 1
An interview 1
Hacking 1

6 It is quick to find a customer's record 1


It is easier to edit drawings 1

7 (a) Two from:


Can sort records
Can insert records
Can produce graphs
Can save file
Can print file/records
Can edit records
Can delete records
Can encrypt records
Can password protect the file
Can create input forms
Can create reports 2

(b) Direct/random 1

(c) Visual verification


Double entry - copies typed by separate secretaries and
compared 1
Two different versions of double entry are acceptable 1

(d) Either Scanner or Digital camera 1

(e) Two from:


You can be fined for:
You can go to prison for:
Gaining unauthorised access to any program or data held in a
computer
Committing computer fraud/blackmail
Writing programs designed to change or impair the
performance of a computer or data stored on a computer
(viruses)
It must be the actions of the law and must not be Data
Protection Act 2

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 2 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 2

Question Part
Answers
Numbers Mark

(f) Two from:


Have had to re-train
Computer-related health problems
Less noise/more pleasant environment
Greater job satisfaction/easier to make corrections/do not have
to type it all again
Unemployment/redundancy/change job 2

8 Two from:
Can copy data without leaving a trace
Can delete data without leaving a trace
Do not need to physically break in to a building
Can spend as much time as it takes to break password
security without being detected
Copies on disc can be smuggled out easier than on paper
because it is compact 2

9 (a) MICR 1

(b) Serial/sequential 1

(c) (CAD)CAM 1

10 (a) Keyed in 1
Read bar code 1

(b) Check digit, length check or existency check - no alternatives


to these three 1

(c) Two from:


Account number
Expiry date
Start date
Issue number
Sort code 2

(d) Two from:


Valid issue number/account number/sort code
Sufficient funds
Expiry date not past
Checks that there are no unusual spending patterns
Pin number is checked
Not been reported stolen 2

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 3 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 2

Question Part
Answers
Numbers Mark

11 Two from:
Work might have been accidentally deleted
Work might have been deleted/changed by hacker
System malfunction may have corrupted work 2

12 Producing gas bills 1


Sending out reminders for overdue books 1

13 (a) Price 1

(b) Paperback or hardback 1

(c) ISBN 1
Because this field is unique for each book 1

(d) Two from:


Parallel running
Direct changeover
Phased implementation
Pilot running
2

(e) Technical documentation


Two from:
Program listing
List of variables
File structure
Purpose of the system
Screen layouts
Print formats
Purpose of the program
Hardware requirements
Software requirements
Sample runs
Systems flowchart/program flowchart/algorithm 2
How to install software

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 4 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 2

Question Part
Answers
Numbers Mark

(f) User documentation


Two from:
How to load software
How to run software
How to save a file
Screen layouts
Print formats
How to search
How to sort
How to print
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)
Troubleshooting guide
How to install software (only if not mentioned in technical
documentation) 2

14 (a) Two marks are available for hardware. Company will need to
buy:
Webcams/small video cameras
Microphones
Speakers
Modem 2

Three marks are available for description from:


Employees are connected on-line
Images of the employees appear on the screen
Software is needed in each computer to operate the
conference
Employees who speak can be heard by all the other
employees in the conference 2
Only four marks are available in total 4 total

(b) Two from:


Do not have to pay for conference room
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 2

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 5 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 2

Question Part
Answers
Numbers Mark

15 (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
Interview a sample of patients 4

(b) Mineral prospecting


Car engine fault diagnosis
Tax
Chess games
Any other suitable answer 2

16 Six from:
The bar code of the ISBN is read
Check digit calculated to validate ISBN
ISBN is matched with number on file of books/on hard disk
Information from the books computer database is read ready
for printing
Details from customer's credit/debit card read
Sort code allows shop computer to contact bank's computer
Details checked for validity
Account checked for sufficient funds
If invalid/insufficient funds then transaction is rejected
Amount deducted from customer's bank account
Amount credited to shop's bank account
Itemised receipt printed out 6

17 Bank advantage: one from:


Fewer employees/lower wage bill
Fewer branches to maintain 1

Bank disadvantage: one from:


Large initial capital expenditure
Customer mistrust of such systems 1

Customer advantage: one from:


Easier to see state of finances
Can transfer funds more easily in emergency/at any time of
day/holidays 1

Customer disadvantage: one from:


Miss the personal touch
Have to be computer literate
Still have to travel to withdraw cash 1

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 6 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 2

Question Part
Answers
Numbers Mark

18 (a) Methods of collecting information:


Three from:
Interviewing workers
Questionnaires to workers
Observation of working practices
Collecting documents 3

(b) Appropriate methods


Two from:
Phone operators - questionnaires/observation
Office employees - interviews/collecting documents/
questionnaires
Drivers - questionnaires 2

Reasons
Two from:
Phone operators constantly busy - difficult to pin down for
interview
Secretaries - can process orders in a batch so could be
available for interview
Deal with many documents so collecting these would give
good insight
Drivers never available during day and only use one document 2

Four from:
Field lengths
Field types/data types
Validation checks
Key field selected
Relationships 4

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
www.xtremepapers.net
JUNE 2003

INTERNATIONAL GCSE

MARK SCHEME

MAXIMUM MARK: 70

SYLLABUS/COMPONENT: 0418/03
INFORMATION TECHNOLOGY
Paper 3 (Practical)

www.xtremepapers.net
Page 1 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 3

Printout of the second e-mail prepared and ready to send to autoresponder -

Check send to address: [email protected]


Check subject line ICTCOREX
Check for attachment present KUROKI.TXT
## If candidate has attached file KUROKI.CSV instead of KUROKI.TXT then allow this ##

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
A. Student <today’s date>
Name top left of page Date top right of page
## Does not have to be in the header ## ## Does not have to be in the header ##

A4 page size, Landscape Heading inserted, centre aligned,

Page 2
All margins 3.5 cm 14 point, bold, underscored
Kuroki Koi
## Allow for paper feed inconsistencies with printers – Different font to body text
(the line length must be between 22.5 and 23 cm) ##
© University of Cambridge Local Examinations Syndicate 2003

Rootrainer Trees has diversified during the past financial year and has set up a new business strand called Kuroki Koi. The business deals with

IGCSE EXAMINATIONS – JUNE 2003


ornamental fish called koi carp. The decision to move away from the Rootrainer name was taken in an attempt to add an oriental and authentic
facade to this business. The idea was developed by Takeo Ogawa, who is the head of Rootrainer's ‘South East Asian Division’ that covers all
operations in Japan, Thailand, Australia, India and Indonesia.

Mark Scheme
Takeo had noticed on his recent trips to Europe and America that there was a growing interest in the cultures of many Asian countries. The
natural progression from this was to look at opportunities of turning this cultural interest into hard cash. Allied with the business structures set in
place by Rootrainer Trees, Takeo has developed 'Kuroki Koi'. The business has been started with two distinct markets identified. The first of
these is the elite, highly prized and very profitable koi carp exported from his native Japan to specialist outlets in several locations in the West.
These include:

· London Bullet points


· Paris Indented at least 4cm
· Milan ## Accept if start of text indented by 4cm from margin ##
· Washington

Syllabus
· Seattle

0418
There are plans to open new outlets (as franchises) in Riyadh, Dubai and Athens during the next twelve months. The second business strand is
aimed at the mass market, particularly relating to the English obsession with gardening. Takeo plans to sell directly to over 7000 garden
centres within the British Isles in the next two years, and then move into the Netherlands, France, Germany and Spain the year after that. The

Paper
production of cheaper, 'mass produced' but lower quality koi will require the establishment of fish farms somewhere in Western Europe during

3
the next twelve months.

Page numbering bottom left

Page Number

www.xtremepapers.net
A. Student <today’s date>

The location of these farms will depend upon several factors: the host country must be a member of the European Union; the warmer the

Page 3
temperature the more rapidly the fish will grow and therefore have a minimum time from hatching to a marketable product; the population must
have some experience of animal husbandry, preferably with fish; and the area must have first class transportation links to ensure less stress on
© University of Cambridge Local Examinations Syndicate 2003

the fish during distribution. Possible locations considered so far are:

IGCSE EXAMINATIONS – JUNE 2003


There will clearly be a need for major investment in the new fish farms and it is proposed to use the initial profits from the more exclusive koi

Mark Scheme
sales to partially fund this growth. To reduce costs the company will run alongside Ogawa Bonsai and Rootrainer Trees, using the same
distribution network and will also use its sister company Ogawa Bonsai to assist in marketing.

Vouchers for Kuroki Koi will be given free with all Ogawa Bonsai trees sold, giving the holder a 10% discount on any koi carp purchased within
a 12 month period. This strategy will hopefully encourage people who would not previously have considered a pond and koi carp to adopt a
more oriental flavour to their garden. Once hooked - excuse the pun - the more exclusive (and expensive) fish can be sold, generating a self-
perpetuating marketplace.

Syllabus
0418
Results of the surveys of preferred koi breeds are included below for the English mass market. The results of this survey were extracted from
customers leaving a variety of garden centres identifying the specific koi they would put into a pond if they had one.

Paper
Page break inserted here

3
Page Number

www.xtremepapers.net
A. Student <today’s date>

Another possible development of this idea would be to introduce specialist koi purchasing trips to Japan, for the discerning customer to hand

Page 4
select their own koi. By arranging a hassle free trip, which includes shipping and quarantining of their selected fish at the appropriate time of
year would net a large potential profit. Although the number of customers would be likely to be small, the opportunity for clients to hand select
© University of Cambridge Local Examinations Syndicate 2003

koi in the natural surroundings of the Niigata region should provide the 'chance of a lifetime'. The area selected would probably be Mushigami.

IGCSE EXAMINATIONS – JUNE 2003


If this trip were marketed correctly, the profits should be extensive and on top of the trip costs, charges for the transportation, quarantining and
veterinary charges would also be a possibility.

Mark Scheme
Body text left aligned
10 point
1.5 line spacing

Syllabus
0418
Paper
3
Page number bottom left of page
## Does not have to be in the footer ##

Page Number

www.xtremepapers.net
Page 5 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 3

Page orientation portrait

Heading ‘Benigoi Koi’ at the top


Benigoi Koi ## Does not have to be in the header and any
alignment is acceptable ##

Species Main Other Metallic Rating


Benigoi Orange None Y 62
Benigoi Red None N 45
Benigoi Red None Y 55
Benigoi Orange None N 56

Check data entry of last 3 records


## Must be 100% accurate ## Sorted in any order

A. Student

Name bottom right of report


## Does not have to be at bottom of page ##

Page Number

© University of Cambridge Local Examinations Syndicate 2003

www.xtremepapers.net
Page 6 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 3

Heading ‘Koi with Yellow’ at the top


## Does not have to be in the header
and any alignment is acceptable ##

Koi with Yellow Sorted in ascending order of ‘Species’

Species Main Other Rating Only these 4 fields selected


Ki Bekko Yellow Black 32 ## Can be any order or layout ##

Ki Utsuri Black Yellow 28


Kigoi Yellow None 58 Search Main = Yellow OR
Kujaku Yellow Platinum 43 Other = Yellow

Average 40.25

Calculated Field
Average Rating calculated

A. Student

Name bottom left of report


## Does not have to be at bottom of page ##

Page Number

© University of Cambridge Local Examinations Syndicate 2003

www.xtremepapers.net
Page 7 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 3

A. Student Heading present Portrait page orientation


## Any alignment, font All margins 2cm
or point size, is acceptable ## ## Allow for paper feed inconsistencies
Kuroki Koi with printers – (the line length must be
between 16.75 and 17.25 cm) ##

Rootrainer Trees has diversified during the


past financial year and has set up a new
business strand called Kuroki Koi. The
business deals with ornamental fish called
koi carp. The decision to move away from
the Rootrainer name was taken in an
attempt to add an oriental and authentic
facade to this business. The idea was
developed by Takeo Ogawa, who is the
head of Rootrainer's ‘South East Asian
Division' which covers all operations in
Japan, Thailand, Australia, India and
Indonesia.

Takeo had noticed on his recent trips to


Europe and America that there was a
growing interest in the cultures of many
Asian countries. The natural progression
from this was to look at opportunities of
turning this cultural interest into hard cash.
Allied with the business structures set in
place by Rootrainer Trees, Takeo has
developed 'Kuroki Koi'. The business has
been started with two distinct markets identified. The first of these is the elite, highly prized and
very profitable koi carp exported from his native Japan to specialist outlets in several locations in
the West. These include:
Image of any fish inserted
## It may also be a lake, pond or ocean picture ##
· London Placed top right of page
· Paris ## Graphic area no more than 40% of printed page
· Milan and no less than 10% of page ##
· Washington ## Orientation of graphic not important ##
· Seattle Text must wrap around all the image

There are plans to open new outlets (as franchises) in Riyadh, Dubai and Athens during the next
twelve months. The second business strand is aimed at the mass market, particularly relating to
the English obsession with gardening. Takeo plans to sell directly to over 7000 garden centres
within the British Isles in the next two years, and then move into the Netherlands, France,
Germany and Spain the year after that. The production of cheaper, 'mass produced' but lower
quality koi will require the establishment of fish farms somewhere in Western Europe during the
next twelve months.

Page Number

© University of Cambridge Local Examinations Syndicate 2003

www.xtremepapers.net
Page 8 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 3

A. Student <today’s date>

The location of these farms will depend upon several factors: the host country must be a member
of the European Union; the warmer the temperature the more rapidly the fish will grow and
therefore have a minimum time from hatching to a marketable product; the population must have
some experience of animal husbandry, preferably with fish; and the area must have first class
transportation links to ensure less stress on the fish during distribution. Possible locations
considered so far are:

La Roda Spain Warm


Whitstable England Close to market Table inserted here
Emmen Netherlands Natural lakes ## 100% accuracy in all data entry needed ##
Toulouse France Warm, good
transport
Crawley England Close to market

There will clearly be a need for major investment in the new fish farms and it is proposed to use
the initial profits from the more exclusive koi sales to partially fund this growth. To reduce costs
the company will run alongside Ogawa Bonsai and Rootrainer Trees, using the same distribution
network and will also use its sister company Ogawa Bonsai to assist in marketing.

Vouchers for Kuroki Koi will be given free with all Ogawa Bonsai trees sold, giving the holder a
10% discount on any koi carp purchased within a 12 month period. This strategy will hopefully
encourage people who would not previously have considered a pond and koi carp to adopt a
more oriental flavour to their garden. Once hooked - excuse the pun - the more exclusive (and
expensive) fish can be sold, generating a self-perpetuating marketplace.

Results of the surveys of preferred koi breeds are included below for the English mass market.
The results of this survey were extracted from customers leaving a variety of garden centres
identifying the specific koi they would put into a pond if they had one.
Database extract placed here
Species Rating ## Format of the extract is not important ##
Kohaku 92
Hi Utsuri 76
Tancho Sanke 67 Searching for
Rating > = 60
Ogon 64
Benigoi 62
Shiromuji 62 Sorted descending on Rating
Hi Showa 62
Ogon 60
Chagoi 60 Only these 2 fields selected
## Can be arranged in any order or layout ##

Another possible development of this idea would be to introduce specialist koi purchasing trips to
Japan, for the discerning customer to hand select their own koi. By arranging a hassle free trip,
which includes shipping and quarantining of their selected fish at the appropriate time of year
would net a large potential profit. Although the number of customers would be likely to be small,
the opportunity for clients to hand select koi in the natural surroundings of the Niigata region
should provide the 'chance of a lifetime'. The area selected would probably be Mushigami. If this
trip were marketed correctly, the profits should be extensive and on top of the trip costs, charges
for the transportation, quarantining and veterinary charges would also be a possibility.

Check for no widows, orphans, lists or tables Body text fully justified
which overlap two pages 12 point
Single line spacing
Page Number

© University of Cambridge Local Examinations Syndicate 2003

www.xtremepapers.net
www.xtremepapers.net
JUNE 2003

INTERNATIONAL GCSE

MARK SCHEME

MAXIMUM MARK: 72

SYLLABUS/COMPONENT: 0418/04
INFORMATION TECHNOLOGY
Paper 4 (Practical)

www.xtremepapers.net
Formula: Formula:
Ins Rate = Lookup (Category in Named Range) Rate multiplied by Ins Rate
## Alignment not important ## ## Alignment not important ##
## Row/Column may not be the same as this example ## ## Row/Column may not be the same as this example ##
## Must display the use of a named range ## ## Do not penalise the use of named cells/ ranges ##

Page 1
© University of Cambridge Local Examinations Syndicate 2003

Category Car Type Doors Rate Ins Rate Insurance Total Deposit

IGCSE EXAMINATIONS – JUNE 2003


=LOOKUP(A2,ins) =D2*E2 =D2+F2 =IF(D2>60,"Yes","No")
=LOOKUP(A3,ins) =D3*E3 =D3+F3 =IF(D3>60,"Yes","No")
=LOOKUP(A4,ins) =D4*E4 =D4+F4 =IF(D4>60,"Yes","No")

Mark Scheme
=LOOKUP(A5,ins) =D5*E5 =D5+F5 =IF(D5>60,"Yes","No")
=LOOKUP(A6,ins) =D6*E6 =D6+F6 =IF(D6>60,"Yes","No")
=LOOKUP(A7,ins) =D7*E7 =D7+F7 =IF(D7>60,"Yes","No")
=LOOKUP(A8,ins) =D8*E8 =D8+F8 =IF(D8>60,"Yes","No")
=LOOKUP(A9,ins) =D9*E9 =D9+F9 =IF(D9>60,"Yes","No")

Insurance Table
Category Ins
A 0.1

Syllabus
B 0.15

0418
C 0.2
D 0.25
E 0.3 Formula: Formula:
Rate + Insurance IF Rate greater than 60, Yes, if less than or
F 0.35 ## Alignment not important ## equal to 60, No

Paper
## Row/Column may not be the same as this example ## ## Alignment not important ##

3
## Do not penalise the use of named cells ## ## Row/Column may not be the same as this example ##

Page orientation landscape


This printout must show formulae view
Column width/row height must show all of formulae and labels

www.xtremepapers.net
Page 2 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 4

Format the results in the Ins


Rate column to percentage Format the results in the Rate,
Insurance and Total columns to
currency showing $ and 2 dp

Category Car Type Doors Rate Ins Rate Insurance Total Deposit
A Economy 2 $38.00 10% $3.80 $41.80 No
B Compact 2 $44.00 15% $6.60 $50.60 No
B Compact 4 $48.00 15% $7.20 $55.20 No
C Intermediate 2 $58.00 20% $11.60 $69.60 No
C Intermediate 4 $60.00 20% $12.00 $72.00 No
D Jeep wrangler 2 $78.00 25% $19.50 $97.50 Yes
E Premium 4 $94.00 30% $28.20 $122.20 Yes
F Luxury 4 $95.00 35% $33.25 $128.25 Yes

Insurance Table
Category Ins
A 0.1
B 0.15
C 0.2
D 0.25
E 0.3
F 0.35

Test data:
## Four columns and Insurance Table must be
100% accurate ##

Page orientation not specified


This printout must show data and fit on a single page

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 3 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 4

Searching:
Total greater than 60 and less than 100 and Doors
=2
## Only these two rows should be visible ##

Category Car Type Doors Rate Ins Rate Insurance Total Deposit
C Intermediate 2 $58.00 20% $11.60 $69.60 No
D Jeep wrangler 2 $78.00 25% $19.50 $97.50 Yes

Searching:
Total is greater than 50 and the Category is B or C
## Only these four rows should be visible ##

Category Car Type Doors Rate Ins Rate Insurance Total Deposit
B Compact 2 $44.00 15% $6.60 $50.60 No
B Compact 4 $48.00 15% $7.20 $55.20 No
C Intermediate 2 $58.00 20% $11.60 $69.60 No
C Intermediate 4 $60.00 20% $12.00 $72.00 No

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 4 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 4

Heading – Style H1 Table created with 5 rows


New web page ## From stylesheet, Dark Green, sans-serif and 2 columns
called font, largest text size, bold, centre aligned ##
AHHOME.HTM Top row cells merged, row 3
## Does not need cells merged
to be labeled ##
Style H1
About Us
Hyperlink
created
Car Types
Mini Car Hire for all occasions
Economy
Compact
Intermediate
Jeep Wrangler
Full size Style H2 We have a wide range of vehicles available that can be picked up at our offices,
the airport, your hotel or your villa.
Weekly Rates Quality Assurance Weekly Hire Charges
239.40 We ensure that all of our vehicles are All vehicles come with fully
fully serviced. We only use the cars for comprehensive insurance. We have
245.70 Style H3 one session before changing/replacing daily rates and weekly rates.
292.60 them.
364.00
573.30 Style H3 CARS2003.JPG in this
## From stylesheet, Style H2
716.45 ## From stylesheet, cell
Bright Green, serif
Bright Blue, sans-serif ## Any vertical or horizontal
font, smallest text size,
font, italic and middle text alignment is acceptable
Contact Details left aligned ##
size, left aligned ## Image resized 150 pixels
width ## All image must be
Menu contains AHMENU.TXT – Style H2 visible ##

· HTML code is likely to vary greatly from this example – only check for required elements.
· Note that some candidates may use .JPEG as an extension. Do not penalise this.
· Note that if no html code is included, a visual check of the table is not sufficient, and marks should be deducted, as you
cannot check that a style sheet has been used. No PC’s from section 17 can be awarded.
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Argon Hire</title>
<link rel="stylesheet" type="text/css" href="argon.css">
</head>
<body>
<h1>Argon Hire</h1>
<p>&nbsp;</p>
External stylesheet attached to web
<h2>About Us</h2>
<div align="left">
<table border="6" width="74%" align="right">
<tr>
<td width="100%" colspan="2">
<h1>Our Services</h1> Check for table border set to 6
</td>
</tr>
<tr>

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 5 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 4

<td width="50%">
<h2>Car Hire for all occasions</h2>
</td>
<td width="50%">&nbsp;</td>
</tr>
<tr>
<td width="50%">
<h3>We have a wide range of vehicles available that can be
picked up at our offices, the airport, your hotel or your villa.&nbsp;</h3>
</td>
<td width="50%"><img border="0" src="CARS2003.JPG" width="150"
height="120"></td>
</tr>
<tr>
<td width="50%">
<h2>Quality Assurance</h2>
</td>
<td width="50%"> Check graphic size for
<h2>Weekly Hire Charges</h2> CARS2003.JPG is set to width 150
</td>
</tr>
<tr>
<td width="50%">
<h3>We ensure that all of our vehicles are fully serviced. We only
use the cars for one season before changing/replacing them.</h3>
</td>
<td width="50%">
<h3>All vehicles come with fully comprehensive insurance.&nbsp;
We have daily rates and weekly rates.</h3>
</td>
</tr>
</table>
</div>
<h2><a href=" AHINTRO.HTM " target="EXTERNAL">Car Types</a><br>
Mini<br>
Economy<br>
Compact<br>
Intermediate<br>
Jeep wrangler<br> Reference from hyperlink “Car Types”
Fullsize</h2> to open AHINTRO.HTM (also allow
<h2>Weekly Rates<br> ARGHIRE.HTM) in new window called
239.40<br> EXTERNAL or other name (FrontPage
245.70<br> default New Page 2)
292.60<br>
364.00<br>
573.30<br>
716.45<br>
<br>
</h2>
<h2>Contact details</h2>

</body>

</html>

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 6 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 4

Style H1, H2, H3 used


## No specific instruction on
which text ##

Many of our vehicles can be ordered over the Internet and collection or delivery can be arranged wherever
convenient

Check this graphic has replaced the


<html> text
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Crops</title>
<link rel="stylesheet" type="text/css"
href="unsaved:///../food%20chain/foodstyle.css">
<link rel="stylesheet" type="text/css" href="argon.css">
</head>

<body>
External stylesheet attached to
<h1>Cars</h1> this web page

<h2><u1:p></u1:p>We have many vehicles to choose from.<o:p></o:p></h2>

<h3><u1:p></u1:p>The variety of vehicles for hire are shown in the table


below:<img border="0" src="HIRE2003.JPG" align="right" width="225"
height="100"><o:p></o:p></h3>

<table width="341">
<col width="64" span="3" style="width:48pt">
<tr height="17" style="height:12.75pt"> HIRE2003.JPG
<td height="17" width="199" style="height: 12.75pt"> ## Any vertical or
<h3>Car Type</h3> horizontal alignment is
acceptable Image resized
</td> 225 pixels width ##
<td class="xl22" width="58"> All image must be visible
<h3>Daily<br> ##
Total</h3>
</td>
<td class="xl22" width="64">

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 7 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 4

<h3>Weekly<br>
Total</h3>
</td>
</tr>
<tr height="17" style="height:12.75pt">
<td height="17" style="height: 12.75pt" width="199">
<h3>Mini</h3>
</td>
<td width="58">
<h3>$41.80</h3>
</td>
<td width="64">
<h3>$239.40</h3>
</td>
</tr>
<tr height="17" style="height:12.75pt">
<td height="17" style="height: 12.75pt" width="199">
<h3>Economy</h3>
</td>
<td width="58">
<h3>$42.90</h3>
</td>
<td width="64">
<h3>$245.70</h3>
</td>
</tr>
<tr height="17" style="height:12.75pt">
<td height="17" style="height: 12.75pt" width="199">
<h3>Economy</h3>
</td>
<td width="58">
<h3>$47.30</h3>
</td>
<td width="64">
<h3>$270.90</h3>
</td>
</tr>
<tr height="17" style="height:12.75pt">
<td height="17" style="height: 12.75pt" width="199">
<h3>Compact</h3>
</td>
<td width="58">
<h3>$50.60</h3>
</td>
<td width="64">
<h3>$292.60</h3>
</td>
</tr>
<tr height="17" style="height:12.75pt">
<td height="17" style="height: 12.75pt" width="199">
<h3>Compact</h3>
</td>
<td width="58">
<h3>$55.20</h3>
</td>
<td width="64">
<h3>$319.20</h3>
</td>
</tr>
<tr height="17" style="height:12.75pt">
<td height="17" style="height: 12.75pt" width="199">
<h3>Intermediate</h3>
</td>
<td width="58">
<h3>$62.40</h3>
</td>
<td width="64">
<h3>$364.00</h3>

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 8 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 4

</td>
</tr>
<tr height="17" style="height:12.75pt">
<td height="17" style="height: 12.75pt" width="199">
<h3>Intermediate</h3>
</td>
<td width="58">
<h3>$63.60</h3>
</td>
<td width="64">
<h3>$371.00</h3>
</td>
</tr>
<tr height="17" style="height:12.75pt">
<td height="17" style="height: 12.75pt" width="199">
<h3>Jeep wrangler</h3>
</td>
<td width="58">
<h3>$97.50</h3>
</td>
<td width="64">
<h3>$573.30</h3>
</td>
</tr>
<tr height="17" style="height:12.75pt">
<td height="17" style="height: 12.75pt" width="199">
<h3>Minivan 7 seater</h3>
</td>
<td width="58">
<h3>$111.80</h3>
</td>
<td width="64">
<h3>$662.20</h3>
</td>
</tr>
<tr height="17" style="height:12.75pt">
<td height="17" style="height: 12.75pt" width="199">
<h3>Fullsize</h3>
</td>
<td width="58">
<h3>$120.15</h3>
</td>
<td width="64">
<h3>$716.45</h3>
</td>
</tr>
<tr height="17" style="height:12.75pt">
<td height="17" style="height: 12.75pt" width="199">
<h3>Premium</h3>
</td>
<td width="58">
<h3>$131.60</h3>
</td>
<td width="64">
<h3>$789.60</h3>
</td>
</tr>
<tr height="17" style="height:12.75pt">
<td height="17" style="height: 12.75pt" width="199">
<h3>Luxury</h3>
</td>
<td width="58">
<h3>$137.75</h3>
</td>
<td width="64">
<h3>$831.25</h3>
</td>
</tr>

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 9 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 4

</table>
<h3><u1:p></u1:p>Many of our vehicles can be ordered over the Internet and
collection or delivery
can be arranged wherever convenient.<o:p></o:p></h3>

<h2><u1:p></u1:p>We operate within the European Union: </h2>

<h3 style="word-spacing: 0; line-height: 100%; margin: 0">Italy</h3>

<h3 style="word-spacing: 0; line-height: 100%; margin: 0">Germany</h3>

<h3 style="word-spacing: 0; line-height: 100%; margin: 0">Greece</h3>

<h3 style="word-spacing: 0; line-height: 100%; margin: 0">Spain</h3>

<h3 style="word-spacing: 0; line-height: 100%; margin: 0">United


Kingdom<o:p></o:p></h3>

<h3><u1:p></u1:p>Why wait? Contact us for further information.</h3>

<h3> Home Page <a href="ahhome.htm"><img border="0" src="HOMEICON.GIF"


width="35" height="35"></a> </h3>

</body>

</html>
Check for HOMEICON.GIF not
Check hyperlink from graphic to .JPG
AHHOME.HTM Width 35

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 10 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 4

One printout 3 slides per page as a handout example below with each slide
shown on separate sheets.

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 11 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 4

SLIDE 1

Logo:
## Suitable clipart insert on master slide ##
## Must be consistent throughout all slides ##
Background:
## Pale green ##
## Must be consistent throughout all slides ##

Heading:
## Dark green, left, large font between 50 and 72 point ##
## Allow one data entry error ##

Subheading:
## Bright blue, left, medium font between 36 & 44 point ##
## Allow one data entry error ##

Auto Slide number:


Candidate’s name and today’s date: ## Placed in bottom right quadrant of the slide ##
## Placed in bottom left quadrant of the screen ## ## Must be consistent throughout all slides ##
## Colour black ##
## Font size to be smallest text on the slide ##

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 12 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 4

SLIDE 2

Background: Logo:
## Pale green ## ## Suitable clipart insert on master slide ##
## Must be consistent throughout all slides ## ## Must be consistent throughout all slides ##

Heading:
## Dark green, left, large font between 50 & 72 point ##
## Allow one data entry error ##

Bulleted list:
## Bright blue, left
aligned, small font
between 18 & 32 point ##
## Allow any bullet points
– but must be present ##
## Allow one data entry
error ##

Auto Slide number:


Chart created from data: ## Placed in bottom right quadrant of the slide ##
## Must be consistent throughout all slides ##
Mini 41.80
Economy 42.90
Compact 50.60
Intermediate 62.40
Jeep wrangler 97.50
Minivan 111.80
Fullsize 120.15
Line drawn to separate bullets from chart,
Premium 131.60
must be green:
Luxury 137.75
## Any form of line is acceptable ##
## Any form of chart is acceptable ##

Candidate’s name and today’s date:


## Placed in bottom left quadrant of the screen ##
## Colour black ##
## Font size to be smallest text on the slide ##

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net
Page 14 Mark Scheme Syllabus Paper
IGCSE EXAMINATIONS – JUNE 2003 0418 4

SLIDE 3

Background:
## Pale green ## Logo:
## Must be consistent throughout all slides ## ## Suitable clipart insert on master slide ##
## Must be consistent throughout all slides ##

Heading:
## Dark green, left, large font between 50 & 72 point ##
## Allow one data entry error ##

Bulleted list:
## Bright blue,
left aligned,
small font Graphic CARSALE.JPG:
between 18 & ## Placed in right half of the screen ##
32 point ## ## Must take up at least 10% of the screen ##
## Allow any
bullet points –
but must be
present ##
## Allow one
data entry
error ##

Auto Slide number:


## Placed in bottom right quadrant of the slide ##
Candidate’s name and today’s date: ## Must be consistent throughout all slides ##
## Placed in bottom left quadrant of the screen ##
## Colour black ##
## Font size to be smallest text on the slide ##

© University of Cambridge Local Examinations Syndicate 2003


www.xtremepapers.net

You might also like