mark scheme maximum mark : 72 syllabus/component · pdf file0418/03 june 2006 page 7 of 13...

0418/03 June 2006

© UCLES 2006 [Turn Over]

UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS

June 2006

INTERNATIONAL GCSE

MARK SCHEME

MAXIMUM MARK : 72

SYLLABUS/COMPONENT : 0418/03

INFORMATION TECHNOLOGY

0418/03 June 2006


Information Table

Mark-up 0.05

0.07

Number of stock

items

Small =COUNTIF($C$9:$C$20,A5)

Large =COUNTIF($C$9:$C$20,A6)

Date Item Size Purchase Increase Sale

38800 Basic exercise bike =IF(D9>=300,D9*seven,D9*five) =SUM(D9:E9)

38806 Cross trainer =IF(D10>=300,D10*seven,D10*five) =SUM(D10:E10)

38813 Multi gym =IF(D11>=300,D11*seven,D11*five) =SUM(D11:E11)

38822 Treadmill =IF(D12>=300,D12*seven,D12*five) =SUM(D12:E12)

38856 Rowing machine =IF(D13>=300,D13*seven,D13*five) =SUM(D13:E13)

38857 Trampoline =IF(D14>=300,D14*seven,D14*five) =SUM(D14:E14)

38863 Benches =IF(D15>=300,D15*seven,D15*five) =SUM(D15:E15)

38870 Punch bags =IF(D16>=300,D16*seven,D16*five) =SUM(D16:E16)

38870 Weights =IF(D17>=300,D17*seven,D17*five) =SUM(D17:E17)

38875 Elliptical cross trainers =IF(D18>=300,D18*seven,D18*five) =SUM(D18:E18)

38885 Step trainer =IF(D19>=300,D19*seven,D19*five) =SUM(D19:E19)

38890 Press =IF(D20>=300,D20*seven,D20*five) =SUM(D20:E20)

Formulae: Countif – number of small

COUNTIF function correct 1 mark

Countif – number of Large

COUNTIF function correct 1 mark

Alignment not important

Row/Column may not be the same as this example

Do not penalise for the use of named cells/ranges or

column reference

Formulae:

If Purchase >=300 then use content of named cell ‘seven’, else use

content of named cell ‘five*, multiplied by the content of Purchase

IF function used correctly to achieve the right result 1 mark

Named cell range 'seven' multiplied by purchase 1 mark

Named cell range 'five' used multiplied by purchase 1 mark Alignment not important

Row/Column may not be the same as this example

Formula:

Sale = Purchase + Increase Sale formula correct 1 mark

Alignment not important

Replication:

Both formulae replicated correctly 1 mark

Layout - Data model created as shown to include date and

item 1 mark

All of the formulae and labels are visible in cell 1 mark

Single page landscape orientation 1 mark

0418/03 June 2006


Information Table

Mark-up 5%

7%

Number of stock items

Small 7

Large 5


March 24, 2006 Basic exercise bike Small $94.00 $4.70 $98.70

March 30, 2006 Cross trainer Large $295.00 $14.75 $309.75

April 6, 2006 Multi gym Large $449.00 $31.43 $480.43

April 15, 2006 Treadmill Large $839.00 $58.73 $897.73

May 19, 2006 Rowing machine Small $519.00 $36.33 $555.33

May 20, 2006 Trampoline Large $349.00 $24.43 $373.43

May 26, 2006 Benches Small $139.00 $6.95 $145.95

June 2, 2006 Punch bags Small $258.00 $12.90 $270.90

June 2, 2006 Weights Small $79.00 $3.95 $82.95

June 7, 2006 Elliptical cross trainers Large $444.00 $31.08 $475.08

June 17, 2006 Step trainer Small $45.00 $2.25 $47.25

June 22, 2006 Press Small $88.00 $4.40 $92.40

Format Mark-up as % with 0 dp

2 Cells in Information Table formatted to % Integer

- values as shown 1 mark

Format the results in the Purchase, Increase and

Sales columns to 2dp displaying $

All 3 columns formatted to $ and 2dp 1 mark

Test data:

All data must be 100% accurate. Ignore initial

capitalization on any words, other than the first unless

there is inconsistency.

Date must contain month in words. Accept dd/mm/yyyy

or mm/dd/yyyy formats

Data added 100% accurately 4 marks

Page orientation not specified

All data fits on a single page 1 mark

All data is visible 1 mark

0418/03 June 2006

of 13


March 30, 2006 Cross trainer Large $295.00 $14.75 $309.75

April 6, 2006 Multi gym Large $449.00 $31.43 $480.43

April 15, 2006 Treadmill Large $839.00 $58.73 $897.73

May 20, 2006 Trampoline Large $349.00 $24.43 $373.43



June 2, 2006 Punch bags Small $258.00 $12.90 $270.90


Searching:

Size equals Large

Only these five rows should be visible

Correct data extracted 2 marks

All columns must be visible

Searching:

Date after 01 June 2006 and Purchase is greater than 150

Only these two rows should be visible


All columns must be visible

0418/03 June 2006


Printout of Stylesheet should be included:

h1 { color: #008000; font-family: Arial; font-size: 45pt; text-align: Center; font-weight: bold }

h2 { color: #00FF00; font-family: Times New Roman; font-size: 18pt; text-align: Left;

font-weight: bold }

h3 { color: #00FF00; font-family: Arial; font-size: 12pt; text-align: Left }

Correct style created for h1 1 mark



Printout of style sheet included – must be a stylesheet – not a webpage 1 mark

Ensure the candidate’s name is printed

0418/03 June 2006

of 13

Heading – Style h1

From stylesheet, dark green, sans-serif font, largest text size, bold,

centre aligned. Accept initial caps or upper case.

Heading 100% correct and h1 used as specified 1 mark

Table created with 5 rows and 2 columns 1 mark

Merge columns 1 and 2 in the 3rd

row 1 mark

Merge columns 1 and2 in the 4th

row 1 mark

Merge columns 1 and2 in the 5th

row 1 mark

Correct text appears in each cell 1 mark

Menu contains SWAD6MEN.TXT - in h2

Menu added 1 mark

SWAD6GYM.JPG in this cell

Any vertical alignment is acceptable.

Horizontal centre alignment. Resized to 500

pixels wide.

All image must be visible

Image inserted 1 mark

correct position centre align 1 mark

Style h2 applied to correct text (2 cells),

light green, serif font, (approx) 18 point,

align left, bold 1 mark

Style h3 applied to correct text (4 cells), light

green, sans-serif font, (approx) 14 point, left

aligned 1 mark

0418/03 June 2006


HTML code is likely to vary greatly from this example – only check for required elements.

<html>

<head>

<title>GYMNASTIC</title>

<link rel="stylesheet" type="text/css" href="gyms.css">

</head>

<body>

<h1>GYMNASTIC</h1>

<div align="left">

<table border="0" cellpadding="0" cellspacing="0" width="300" align="left">

<tr>

<td>

<h2>Home Page</h2>

</td>

<td>

<h2><a href="SWAD6GYM.HTM" target="EXTERNAL">Rowing Machine</a></h2>

</td>

<td>

<h2>Order Form</h2>

</td>

</tr>

</table>

</div>

<div align="left">

<table border="4" cellpadding="0" cellspacing="0" width="300">

<tr>

<td>

<h2>What we do</h2>

</td>

<td>

<h3>Our company sells gym equipment to both public and private

customers, at well below retail prices.</h3>

</td>

</tr>

<tr>

<td>

<h3>We keep the costs low as we do not have a retail shop, our only shop

is on-line.</h3>

</td>

<td>

<h3>You can contact our office through many different media.</h3>

</td>

</tr>

<tr>

<td colspan="2">

<h3>Through our website on-line - use our order form.</h3>

<h3>By post - order our catalogue and complete the order form.</h3>

<h3>By phone or fax - all contact details on this website.</h3>

</td>

</tr>

<tr>

<td colspan="2"><img border="0" src="SWAD6GYM.JPG" width="500" height="137"

align="center"></td>

</tr>

<tr>

<td colspan="2">

<h2>In all cases you can order our catalogue for a full listing of our

services.</h2>

</td>

</tr>

</table>

</body>

</html>

External stylesheet attached 1 mark

Any name can be used

Table border set to 4 point 1 mark

SWAD6GYM.JPG in this cell

Aspect ratio maintained. Image should be

centre aligned. Resized to 500 pixels wide.

Image resized 1 mark

Reference from hyperlink ‘Rowing Machine’ to

open SWAD6GYM.HTM in new window called

EXTERNAL 1 mark


0418/03 June 2006

of 13

SWAD6ROW.JPG in this cell

Any vertical or horizontal alignment is acceptable

Image resized to 300 pixels wide


Aspect ratio must be maintained

Image placed as specified 1 mark

Check this Image has replaced the text 1 mark

Must be placed outside the table

0418/03 June 2006



<head>

<title>GYM EQUIPMENT SUPPLIED FROM GYMNASTIC</title>

<link rel="stylesheet" type="text/css" href="gyms.css">

</head>

<body lang=EN-GB style='tab-interval:36.0pt'>

<h1>ROWING MACHINES FROM GYMNASTIC</h1>

<table border="0" cellpadding="0" cellspacing="0" width="666" height="571">

<tr>

<td width="386" height="416">

<h2>Resistance</h2>

<h3>Space-saving hydraulic piston resistance to simulate the feel of

rowing</h3>

<h2>Size (L x W x H)</h2>

<h3>49" x 31" x 24"</h3>

<h2>Weight</h2>

<h3>50 lbs</h3>

<h2>Rowing motion</h2>

<h3>Standard</h3>

<h2>Manufactured</h2>

<h3>Germany</h3>

<h2>Monitor functions</h2>

<h3>Measurements of time, number of strokes rowed, stroke rating (with

audible setting), energy consumption, automatic display alternation, and

target settings</h3>

<h2>Assembly</h2>

<h3>Minor assembly required</h3>

</td>

<td width="276" height="416"><img border="0" src="SWAD6ROW.JPG" width="300"

height="200"></td>

</tr>

</table>

<p><a href="swad6hm.htm"><img border="0" src="swad6ico.gif" width="35"

height="35"></a></p>

</body>

External stylesheet applied 1 mark

Any name can be used. Stylesheet must not be

overridden

SWAD6ROW.JPG


Image resized 300 pixels wide



Check for SWAD6ICO.GIF not .JPG - Width 35

Image converted to GIF 1 mark Image resized to be 35 pixels wide and maintain the aspect ratio 1 mark

Hyperlink created from graphic to SWAD6HM.HTM 1 mark

0418/03 June 2006


SLIDE 1

Master slide – check consistency

Candidate name and today’s date top left,

colour black, small text, 1 mark

Font size to be smallest text on the slide

Heading:

Dark blue, right aligned, large font between 50 & 68 point

Penalise for initial caps if omitted.

Heading formatted correctly, 1 mark

Text of heading entered correctly 1 mark

Subheading:

Bright blue, centre aligned, medium font between 36

& 48 point. Ignore initial caps.

Subheading formatted correctly, 1 mark

Text of subheading entered correctly 1 mark

Presenter Notes –

Not on the slide:

100% correct and right place or suitably adapted text.

Presenter notes present 1 mark


Logo –Any suitable clipart chosen

Placed in top right quadrant of the screen

Logo placed top right 1 mark

Logo not overlapping text or object 1 mark

0418/03 June 2006


SLIDE 2

Candidate’s name and today’s date:

Placed in top left quadrant of the screen

Colour black

Heading:

Dark blue, right aligned, large font between

50 & 68 point

Do not penalize for capital ‘E’ if consistent

with other slides

Heading entered and formatted correctly

1 mark

Bulleted list:

Dark green, left aligned, small font between 16 &

34 point

Allow any bullet points

Bulleted list added correctly and in right place

1 mark

Bulleted list formatted as specified 1 mark

Background:

Light green

Must be consistent

throughout all slides

Vertical Bar Chart created from data –

displaying a legend:

Business/IT 350

Catering 275

Art & Design 196

Science 371

Technology 215

Chart created correctly 1 mark

legend displayed& valid 1 mark

Presenter Notes:

100% correct & right place 1 mark

Logo:

Suitable clipart chosen

Placed in top right

quadrant of the screen

Allow ‘and’

Double headed arrow dark blue

vertical line between bullet and graph

Any form of arrow head is acceptable

Arrow present 1 mark

0418/03 June 2006


SLIDE 3


Placed in top left quadrant of the screen

Colour black.

Heading:

Dark blue, right aligned, large font between 50 & 68 point

Do not penalize for capital ‘A’ if consistent with other slides

Heading entered and formatted correctly 1 mark

Bulleted list:

Dark green, left aligned, small font between 16 & 34 point

Consistent symbol with slide 2

Bulleted list added correctly and in right place related to

image 1 mark

Bulleted list formatted as specified and bullet symbol

consistent with slide 2 1 mark

Background:

Light green

Must be consistent

throughout all slides

Logo:


Placed in top right quadrant

of the screen

Graphic (category 'sport’)

Clipart inserted correctly 1 mark

From ARF

Colour correct 1 mark

Slide transitions added 1 mark

Slide animation added 1 mark

Presenter Notes:



International General Certificate of Secondary Education MARK SCHEME for the October/November 2006 question paper

0418 INFORMATION TECHNOLOGY

0418/03 Paper 3, maximum raw mark 72

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.

In

fo

rm

atio

n T

ab

le

Manager's

D

iscount M

0.06

Cle

arance D

iscount

C

0.03

Nu

mb

er o

f sales

Kitchen

=C

OU

NT

IF

($D

$9:$D

$20,A

5)

Household

=

CO

UN

TIF

($D

$9:$D

$20,A

6)

Date

Pro

du

ct

Offer

Typ

e

Price

Disco

un

t

Valu

e

38763

=

IF

(C

9=

"M

",E

9*six

,E

9*three)

=E

9-F

9

38800

=

IF

(C

10=

"M

",E

10*six

,E

10*three)

=E

10-F

10

38816

=

IF

(C

11=

"M

",E

11*six

,E

11*three)

=E

11-F

11

38834

=

IF

(C

12=

"M

",E

12*six

,E

12*three)

=E

12-F

12

38867

=

IF

(C

13=

"M

",E

13*six

,E

13*three)

=E

13-F

13

38876

=

IF

(C

14=

"M

",E

14*six

,E

14*three)

=E

14-F

14

38919

=

IF

(C

15=

"M

",E

15*six

,E

15*three)

=E

15-F

15

38919

=

IF

(C

16=

"M

",E

16*six

,E

16*three)

=E

16-F

16

38924

=

IF

(C

17=

"M

",E

17*six

,E

17*three)

=E

17-F

17

38930

=

IF

(C

18=

"M

",E

18*six

,E

18*three)

=E

18-F

18

38943

=

IF

(C

19=

"M

",E

19*six

,E

19*three)

=E

19-F

19

38954

=

IF

(C

20=

"M

",E

20*six

,E

20*three)

=E

20-F

20

Fo

rm

ula

e: C

ou

ntif –

n

um

be

r o

f K

itc

he

n

CO

UN

T fu

nc

tio

n u

se

d c

orre

ctly

1

m

ark

Co

un

tif –

n

um

be

r o

f H

ou

se

ho

ld

CO

UN

T fu

nc

tio

n u

se

d c

orre

ctly

1

m

ark

Alig

nm

en

t n

ot im

po

rta

nt

Ro

w/C

olu

mn

m

ay n

ot b

e th

e sa

me

a

s th

is e

xa

mp

le

Do

n

ot p

en

alise

th

e u

se

o

f n

am

ed

ce

lls/ra

ng

es o

r co

lum

n re

fe

re

nce

Fo

rm

ula

e:

If O

ffe

r=

M th

en

u

se

c

on

te

nt o

f n

am

ed

c

ell ‘s

ix

’, e

ls

e u

se

d c

on

te

nt

of n

am

ed

c

ell ‘th

re

e’, m

ultip

lie

d b

y th

e c

on

te

nt o

f P

ric

e.

IF

fu

nc

tio

n u

se

d c

orre

ctly

to

a

ch

ie

ve

th

e rig

ht re

su

lt

1 m

ark

Na

me

d c

ell ra

ng

e ' s

ix

' m

ultip

lie

d b

y p

ric

e

1

m

ark

Na

me

d c

ell ra

ng

e 't

hre

e' u

se

d m

ultip

lie

d b

y p

ric

e

1

m

ark

Alig

nm

en

t n

ot im

po

rta

nt

Ro

w/C

olu

mn

m

ay n

ot b

e th

e sa

me

a

s th

is e

xa

mple

Re

plic

atio

n:

Bo

th

fo

rm

ula

e re

plic

ate

d c

orre

ctly

1 m

ark

La

yo

ut - D

ata

m

od

el c

re

ate

d a

s s

ho

wn

to

in

clu

de

d

ate

, la

be

ls

a

nd

d

ata

1 m

ark

All o

f th

e fo

rm

ula

e a

nd

la

be

ls

a

re

fu

lly

v

is

ib

le

in

c

ells

1 m

ark

Sin

gle

p

ag

e la

nd

sc

ap

e o

rie

nta

tio

n

1 m

ark

Fo

rm

ula

:

Va

lue

=

P

ric

e - D

isco

un

t

Va

lu

e fo

rm

ula

c

orre

ct 1

m

ark

Alig

nm

en

t n

ot im

po

rta

nt

Page 2

IGCSE - OCT/NOV 2006

Mark Scheme

0418

Syllabus

3

Paper

© UCLES 2006

Mark Scheme Syllabus Paper

IGCSE - OCT/NOV 2006 0418 3

© UCLES 2006

Information Table

Manager's Discount M 6%

Clearance Discount C 3%

Number of sales

Kitchen 7

Household 5

Date Product Offer Type Price Discount Value

15-Feb-2006Washer M Kitchen $350.00 $21.00 $329.00

24-Mar-2006Iron M Kitchen $25.00 $1.50 $23.50

9-Apr-2006Television C Household $1,050.00 $31.50 $1,018.50

27-Apr-2006Dryer C Kitchen $150.00 $4.50 $145.50

30-May-2006Kettle C Kitchen $15.00 $0.45 $14.55

8-Jun-2006Radio C Household $34.00 $1.02 $32.98

21-Jul-2006Washer M Kitchen $550.00 $33.00 $517.00

21-Jul-2006Oven M Kitchen $650.00 $39.00 $611.00

26-Jul-2006Washer C Kitchen $421.00 $12.63 $408.37

1-Aug-2006Television C Household $624.00 $18.72 $605.28

14-Aug-2006Radio C Household $28.50 $0.85 $27.65

25-Aug-2006Television M Household $624.00 $37.44 $586.56

Format Manager’s Discount and Clearance

Discount as % with 0 dp

2 Cells in Information Table formatted to % Integer

values as shown 1 mark

Test data:

All data must be 100% accurate. Date must contain month

in words. Accept dd/mmm/yyyy or mmm/dd/yyyy formats.

Data added 100% accurately 4 marks

deduct 1 mark per error

Page orientation not specified

All data fits on a single page 1 mark

All data and values are visible 1 mark

Format the results in the Price, Discount and Value

columns to 2dp displaying $

All 3 columns formatted to $ and 2dp 1 mark



© UCLES 2006


15-Feb-2006Washer M Kitchen $350.00 $21.00 $329.00


27-Apr-2006Dryer C Kitchen $150.00 $4.50 $145.50


21-Jul-2006Washer M Kitchen $550.00 $33.00 $517.00

21-Jul-2006Oven M Kitchen $650.00 $39.00 $611.00

26-Jul-2006Washer C Kitchen $421.00 $12.63 $408.37




Searching:

Type equals Kitchen

Only these seven rows should be visible


All data must be visible

Searching:

eDate less than 01/07/06 and Value is less than 30

Only these two rows should be visible


All data must be visible



© UCLES 2006

Printout of Stylesheet should be included:

h1 { color: #000000; font-family: Charlesworth; font-size: 45pt; text-align: Center;

font-weight: bold }

h2 { color: #0000FF; font-family: Arial; font-size: 18pt; font-style: italic;

font-weight: bold; text-align: left }

h3 { color: #003399; font-family: Arial; font-size: 14pt; text-align: left }




Printout of style sheet included – must be a stylesheet – not a webpage 1 mark

Ensure the candidate’s name is printed



© UCLES 2006

Heading – Style h1

From stylesheet, black, serif font, largest text size, bold, centre

aligned. Accept initial caps or upper case (not lower case C).

Heading 100% correct and h1 used as specified 1 mark

SWAA6HOM.JPG in this cell

Resized to 150 pixels high not maintaining

aspect ratio.

Image inserted 1 mark

In correct position 1 mark

Image fully visible 1 mark

Table contains SWAA6INT.HTM

Table created with 6 rows and 2 columns 1 mark

Merge columns 1 and 2 in the 1st

row 1 mark

Correct text appears in each cell 1 mark

Style h3 – applied correctly to table

From stylesheet, Dark Blue, sans-serif font,

smallest text size, left aligned

h3 applied to correct text 1 mark

Style h2 – applied correctly to table

From stylesheet, Bright Blue, sans-serif font,

bold, italic and middle text size, left aligned

h2 applied to correct text 1 mark

Menu contains SWAA6MEN.TXT - Style h2

Menu added correct place 1 mark

Style h2 1 mark



© UCLES 2006


<html>

<title>The College IVC</title>

<link rel="stylesheet" type="text/css" href="col.css">

</head>

<body>

<h1>THE COLLEGE</h1>

<div align="right">

<table border="6" width="76%" align="right">

<tr>

<td width="80%" colspan="2">

<p align="center"><img border="0" src="swaa6hom.jpg" width="472"

height="150"></td>

</tr>

<tr>

<td width="17%">

<h2>Business/IT</h2>

</td>

<td>

<h3>The courses offered here are: Administration, Accounting, Call

Centre Techniques, Computer Literacy, Export Management, Information

Technology, Internet Technologies, Marketing, Management,

Programming, Secretarial Procedures, Travel & Tourism, Webpage

Creation and Word Processing.</h3>

</td>

</tr>

<tr>

<td>

<h2>Catering</h2>

</td>

<td>

<h3>The courses offered here are: Accommodation & Reception,

Advanced Culinary Diplomas in Patisserie & Confectionery, Advanced

Culinary Diploma in Kitchen & Larder, Bar Skills, Counter Service,

Food & Drink Service, Food Preparation & Cookery, Off-Licensed

Supervision and Restaurant Supervision.</h3>

</td>

</tr>

<tr>

<td>

<h2>Art & Design</h2>

</td>

<td>

<h3>The courses offered here are: Art & Design, Art & Crafts, Film

Studies, Apple Macintosh Training, Photography, Art/Drawing & Painting,

Ceramics, Media Studies, Multimedia Authoring, Making Sense of the Media,

Industrial Design, Product Design, Transport Design and Installation Art

& Events.

</h3>

</td>

</tr>

<tr>

<td>

<h2>Science</h2>

</td>

<td>

<h3>The courses offered here are: Animal Care, Dog Grooming, Dog

Training, Environmental Conservation, Floristry & Flower Arranging,

Agriculture, Horticulture, Forestry, Horse Studies, Caring for Animals,

External stylesheet attached & applied 1 mark

Any name can be used. Stylesheet must not be

overridden.


SWAA6HOM.JPG in this cell

Resized to 150 pixels high, width between

450 and 500


All links must be relative, no credit will be given for absolute references.



© UCLES 2006

Landscape Management and Zoology & Behavioural Sciences. This

section includes courses such as Science, Laboratory Technician and

Process Operations.</h3>

</td>

</tr>

<tr>

<td>

<h2>Technology</h2>

</td>

<td width="63%">

<h3>The courses offered here are: Brickwork, Carpentry/Joinery,

Bench Joinery, Machine Woodwork, Furniture Craft, Painting and

Decorating, Marble and Graining, Installation Work and Regulations, Gas

Safety, Electrical and Electronic Engineering, Security Systems,

Electronic Servicing, Control Systems, Basic Engineering Competences,

Basic Mechanical Skills, Programmable Logic Controllers, Engineering

Maintenance Systems Competences and Mechanical Power Transmissions.</h3>

</td>

</tr>

</table>

</div>

<h2>Departments

Business/IT<br>

Catering<br>

Art & Design<br>

Science<br>

Technology

Opening hours

Mon - Thurs 9 am - 9 pm<br>

Fri & Sat 10 am - 4 pm

General

Enrolment <br>

Admissions<br>

Student guidance<br>

Fees & finance<br>

Library<br>

<a href="swaa6flx.htm" target="EXTERNAL">Flexible learning</a></h3>

<h2>Contact details<br>

</h2>

</body>

</html>

Relative reference from hyperlink ‘Flexible learning’ to

open SWAA6FLX.HTM in new window called EXTERNAL

1 mark



© UCLES 2006

SWAA6FLX.JPG in this cell



Aspect ratio must be maintained

Image placed as specified 1 mark

Check this Image has replaced the text 1 mark



© UCLES 2006

<html>

<head>

<title>The Flexible Learning Centre IVC</title>

<link rel="stylesheet" type="text/css" href="col.css">

</head>

<body>

<h1>THE FLEXIBLE LEARNING CENTRE</h1>

<div align="center">

<center>

<table border="1" width="947" height="630">

<tr>


<h2>The Flexible Learning Centre encourages and offers a

student-centred approach to learning via technology-based activities.</h2>

<h2>Take advantage of computer based learning packages.</h2>

<h2>Assistance is always available from learning

support and academic staff based in the Centre. </h2>

<h2>Attendance is on a drop-in basis.</h2>

<h2>A range of flexible IT courses is available.</h2>

<h2>Courses include: </h2>

<ul>

<li><h3>Introduction to the PC</h3>

<li><h3>Using Windows</h3>

<li><h3>Word Processing</h3>

<li><h3>Spreadsheets</h3>

<li><h3>Database</h3>

<li><h3>Internet Technology</h3>

<li><h3>Graphical Presentation</h3>

<li><h3>Desktop Publishing</h3>

</li>

</ul>

</td>

<td width="439" height="630"><img border="0" src="swaa6flx.jpg" align="right" </td>

</tr>

</table>

</center>

</div>

<p><a href="colhome.htm" target="_self"><img border="0" src="swaa6ico.gif" width="35"

height="35"></a></p>

</body>

External stylesheet applied 1 mark

Any name can be used but must be consistent with

previous page. Stylesheet must not be overridden.

Check for SWAA6ICO.GIF not .JPG - Width 35

Image converted to GIF 1 mark Image resized to be 35 pixels wide and maintain the aspect ratio 1 mark

Hyperlink created from graphic to COLHOME.HTM 1 mark

All links must be relative, no credit will be given for absolute references.



© UCLES 2006

SLIDE 1

Heading:

Dark green, right, large font between 50 & 72 point

Heading formatted correctly, 1 mark

Text of heading entered correctly 1 mark


Candidate name and date top right, colour

black, small text, 1 mark


Subheading:

Bright green, centred, medium font between 36 & 46

point

Subheading formatted correctly, 1 mark

Text of subheading entered correctly 1 mark


Automated slide number inserted

Centre aligned, starts at 1

Slide number in correct place 1 mark


Logo (category 'Kitchen Electrical Equipment'): -Suitable

clipart chosen

Placed in bottom right quadrant of the screen

Logo placed bottom right 1 mark

Presenter Notes –

Not on the slide:

100% correct and right place or suitably adapted text.

Presenter notes present 1 mark


Background: Light green 1 mark

Must be consistent throughout all slides

Master slide – overlapping

Any master slide object not overlapping text or object on

any slide 1 mark



© UCLES 2006

SLIDE 2



Colour black


Pie Chart created from data – Displaying a

legend and values set to currency $ sign

and 0 dp

Freezer 127.99

Fridge 205.99

Fridge/Freezer 498.99

Oven 589.99

Tumble Dryer 185.99

Washing Machine 404.99

Chart created correctly 1 mark

All legend displayed 1 mark

$ and 0dp 1 mark

Bulleted list:

Bright green, left aligned, small font between

16 & 32 point. Allow any bullet points

Bulleted list added correctly and in right place

1 mark

Bulleted list formatted as specified

1 mark

Any form of vertical line between chart and bullets is

acceptable (not arrows) 1 mark

Heading:

Style the same as slide 1.

Heading entered and formatted correctly 1 mark

Logo:


Placed in bottom right


Slide number

inserted

centred

Presenter Notes:




© UCLES 2006

SLIDE 3



Colour black


Slide number

inserted & centred

Logo:


Placed in bottom right


Graphic - category Kitchen Electrical Equipment,

Suitable clipart, fully visible and not distorted

Clipart inserted correctly 1 mark Bulleted list:

Bullets as slide 2

Added correctly and in right place related

to image 1 mark

Formatted correctly – must be consistent

with slide 2 1 mark

Heading:

Style the same as slide 1.

Text & formatting of heading correct 1 mark

From ARF

Colour correct 1 mark

Slide transitions added 1 mark

Slide animation added 1 mark

Presenter Notes:



International General Certificate of Secondary Education MARK SCHEME for the May/June 2007 question paper


0418/03 Paper 3 (Practical Test B), 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




demonstrated.


examination.


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.

Pa

ge

2

M

ark

S

ch

em

e

Sy

lla

bu

s

Pa

pe

r

IG

CS

E –

M

ay

/J

un

e 2

00

7

04

18

0

3

Ca

nd

id

ate

n

am

e C

en

tre

n

um

be

r C

an

did

ate

n

um

be

r

© U

CLE

S 2007

CC

od

e

Nu

mb

er o

f ite

ms

Dc

od

e

Ra

te

SX

=

CO

UN

TIF

($

A$

7:$

A$

80

,A

2)

A

0

.2

25

BE

=

CO

UN

TIF

($

A$

7:$

A$

80

,A

3)

B

0

.1

8

UT

B

=C

OU

NT

IF

($

A$

7:$

A$

80

,A

4)

C

0

.1

CC

od

e

Co

mp

an

y

Co

de

Ite

m

Un

it

Qu

an

tity

C

os

t

Dis

co

un

t

Pric

e

BB

=

VL

OO

KU

P(A

7,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

Pe

ncil

0.0

2

10

0

=E

7*F

7

=IF

(C

7=

"A

",G

7*R

ate

A,IF

(C

7=

"B

",G

7*R

ate

B,IF

(C

7=

"C

",G

7*R

ate

C,0

)))

=G

7-H

7

BB

=

VL

OO

KU

P(A

8,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Ru

ler

0.1

4

12

=

E8

*F

8

=IF

(C

8=

"A

",G

8*R

ate

A,IF

(C

8=

"B

",G

8*R

ate

B,IF

(C

8=

"C

",G

8*R

ate

C,0

)))

=G

8-H

8

BB

=

VL

OO

KU

P(A

9,J7

co

de

!$

A$

2:$

B$

14

,2

)

D

esk

14

6.3

3

=

E9

*F

9

=IF

(C

9=

"A

",G

9*R

ate

A,IF

(C

9=

"B

",G

9*R

ate

B,IF

(C

9=

"C

",G

9*R

ate

C,0

)))

=G

9-H

9

BB

=

VL

OO

KU

P(A

10

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

ha

ir

55

.2

3

=

E1

0*F

10

=

IF

(C

10

="A

",G

10

*R

ate

A,IF

(C

10

="B

",G

10

*R

ate

B,IF

(C

10

="C

",G

10

*R

ate

C,0

)))

=G

10

-H

10

BB

=

VL

OO

KU

P(A

11

,J7

co

de

!$

A$

2:$

B$

14

,2

)

W

aste

b

in

5.2

5

=

E1

1*F

11

=

IF

(C

11

="A

",G

11

*R

ate

A,IF

(C

11

="B

",G

11

*R

ate

B,IF

(C

11

="C

",G

11

*R

ate

C,0

)))

=G

11

-H

11

BB

=

VL

OO

KU

P(A

12

,J7

co

de

!$

A$

2:$

B$

14

,2

)

S

hre

dd

er

23

.4

1

=

E1

2*F

12

=

IF

(C

12

="A

",G

12

*R

ate

A,IF

(C

12

="B

",G

12

*R

ate

B,IF

(C

12

="C

",G

12

*R

ate

C,0

)))

=G

12

-H

12

DY

=

VL

OO

KU

P(A

13

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

lea

r T

ap

e

1.1

2

6

=E

13

*F

13

=

IF

(C

13

="A

",G

13

*R

ate

A,IF

(C

13

="B

",G

13

*R

ate

B,IF

(C

13

="C

",G

13

*R

ate

C,0

)))

=G

13

-H

13

DY

=

VL

OO

KU

P(A

14

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Ma

tt T

ap

e

0.2

2

12

=

E1

4*F

14

=

IF

(C

14

="A

",G

14

*R

ate

A,IF

(C

14

="B

",G

14

*R

ate

B,IF

(C

14

="C

",G

14

*R

ate

C,0

)))

=G

14

-H

14

DY

=

VL

OO

KU

P(A

15

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

Pa

pe

r C

lip

s

0.7

45

6

0

=E

15

*F

15

=

IF

(C

15

="A

",G

15

*R

ate

A,IF

(C

15

="B

",G

15

*R

ate

B,IF

(C

15

="C

",G

15

*R

ate

C,0

)))

=G

15

-H

15

DY

=

VL

OO

KU

P(A

16

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

Pe

ncil

0.0

2

10

0

=E

16

*F

16

=

IF

(C

16

="A

",G

16

*R

ate

A,IF

(C

16

="B

",G

16

*R

ate

B,IF

(C

16

="C

",G

16

*R

ate

C,0

)))

=G

16

-H

16

MB

=

VL

OO

KU

P(A

17

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Blu

e-T

ack sm

all

2.5

45

1

0

=E

17

*F

17

=

IF

(C

17

="A

",G

17

*R

ate

A,IF

(C

17

="B

",G

17

*R

ate

B,IF

(C

17

="C

",G

17

*R

ate

C,0

)))

=G

17

-H

17

MB

=

VL

OO

KU

P(A

18

,J7

co

de

!$

A$

2:$

B$

14

,2

)

R

ed

F

ile

0

.5

65

1

=

E1

8*F

18

=

IF

(C

18

="A

",G

18

*R

ate

A,IF

(C

18

="B

",G

18

*R

ate

B,IF

(C

18

="C

",G

18

*R

ate

C,0

)))

=G

18

-H

18

MB

=

VL

OO

KU

P(A

19

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

lack F

ile

0

.5

65

1

=

E1

9*F

19

=

IF

(C

19

="A

",G

19

*R

ate

A,IF

(C

19

="B

",G

19

*R

ate

B,IF

(C

19

="C

",G

19

*R

ate

C,0

)))

=G

19

-H

19

UT

B

=V

LO

OK

UP

(A

20

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Tra

nsfe

r ca

se

0

.4

80

75

2

0

=E

20

*F

20

=

IF

(C

20

="A

",G

20

*R

ate

A,IF

(C

20

="B

",G

20

*R

ate

B,IF

(C

20

="C

",G

20

*R

ate

C,0

)))

=G

20

-H

20

UT

B

=V

LO

OK

UP

(A

21

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Tra

nsfe

r F

ile

0

.2

59

75

2

0

=E

21

*F

21

=

IF

(C

21

="A

",G

21

*R

ate

A,IF

(C

21

="B

",G

21

*R

ate

B,IF

(C

21

="C

",G

21

*R

ate

C,0

)))

=G

21

-H

21

UT

B

=V

LO

OK

UP

(A

22

,J7

co

de

!$

A$

2:$

B$

14

,2

)

R

ed

B

iro

2

.4

2

=

E2

2*F

22

=

IF

(C

22

="A

",G

22

*R

ate

A,IF

(C

22

="B

",G

22

*R

ate

B,IF

(C

22

="C

",G

22

*R

ate

C,0

)))

=G

22

-H

22

UT

B

=V

LO

OK

UP

(A

23

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

lack B

iro

2

.4

5

=

E2

3*F

23

=

IF

(C

23

="A

",G

23

*R

ate

A,IF

(C

23

="B

",G

23

*R

ate

B,IF

(C

23

="C

",G

23

*R

ate

C,0

)))

=G

23

-H

23

UT

B

=V

LO

OK

UP

(A

24

,J7

co

de

!$

A$

2:$

B$

14

,2

)

G

re

en

B

iro

2

.4

1

=

E2

4*F

24

=

IF

(C

24

="A

",G

24

*R

ate

A,IF

(C

24

="B

",G

24

*R

ate

B,IF

(C

24

="C

",G

24

*R

ate

C,0

)))

=G

24

-H

24

UT

B

=V

LO

OK

UP

(A

25

,J7

co

de

!$

A$

2:$

B$

14

,2

)

A

Re

d F

ile

0

.5

65

2

00

0

=E

25

*F

25

=

IF

(C

25

="A

",G

25

*R

ate

A,IF

(C

25

="B

",G

25

*R

ate

B,IF

(C

25

="C

",G

25

*R

ate

C,0

)))

=G

25

-H

25

RT

=

VL

OO

KU

P(A

26

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Re

d F

ile

0

.5

65

2

5

=E

26

*F

26

=

IF

(C

26

="A

",G

26

*R

ate

A,IF

(C

26

="B

",G

26

*R

ate

B,IF

(C

26

="C

",G

26

*R

ate

C,0

)))

=G

26

-H

26

RT

=

VL

OO

KU

P(A

27

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Pla

stic

P

ocke

ts

0.4

55

1

0

=E

27

*F

27

=

IF

(C

27

="A

",G

27

*R

ate

A,IF

(C

27

="B

",G

27

*R

ate

B,IF

(C

27

="C

",G

27

*R

ate

C,0

)))

=G

27

-H

27

RT

=

VL

OO

KU

P(A

28

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

lack B

iro

2

.4

5

=

E2

8*F

28

=

IF

(C

28

="A

",G

28

*R

ate

A,IF

(C

28

="B

",G

28

*R

ate

B,IF

(C

28

="C

",G

28

*R

ate

C,0

)))

=G

28

-H

28

RT

=

VL

OO

KU

P(A

29

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

lue

B

iro

2

.4

5

=

E2

9*F

29

=

IF

(C

29

="A

",G

29

*R

ate

A,IF

(C

29

="B

",G

29

*R

ate

B,IF

(C

29

="C

",G

29

*R

ate

C,0

)))

=G

29

-H

29

RT

=

VL

OO

KU

P(A

30

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

Pe

ncil

0.0

2

10

0

=E

30

*F

30

=

IF

(C

30

="A

",G

30

*R

ate

A,IF

(C

30

="B

",G

30

*R

ate

B,IF

(C

30

="C

",G

30

*R

ate

C,0

)))

=G

30

-H

30

DU

=

VL

OO

KU

P(A

31

,J7

co

de

!$

A$

2:$

B$

14

,2

)

R

ed

fo

lde

r

0.3

9

5

=E

31

*F

31

=

IF

(C

31

="A

",G

31

*R

ate

A,IF

(C

31

="B

",G

31

*R

ate

B,IF

(C

31

="C

",G

31

*R

ate

C,0

)))

=G

31

-H

31

DU

=

VL

OO

KU

P(A

32

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Blu

e-T

ack sm

all

2.5

45

1

0

=E

32

*F

32

=

IF

(C

32

="A

",G

32

*R

ate

A,IF

(C

32

="B

",G

32

*R

ate

B,IF

(C

32

="C

",G

32

*R

ate

C,0

)))

=G

32

-H

32

DU

=

VL

OO

KU

P(A

33

,J7

co

de

!$

A$

2:$

B$

14

,2

)

G

re

en

file

0

.5

3

5

=E

33

*F

33

=

IF

(C

33

="A

",G

33

*R

ate

A,IF

(C

33

="B

",G

33

*R

ate

B,IF

(C

33

="C

",G

33

*R

ate

C,0

)))

=G

33

-H

33

DU

=

VL

OO

KU

P(A

34

,J7

co

de

!$

A$

2:$

B$

14

,2

)

P

ap

er 6

5g

m

1.2

4

=

E3

4*F

34

=

IF

(C

34

="A

",G

34

*R

ate

A,IF

(C

34

="B

",G

34

*R

ate

B,IF

(C

34

="C

",G

34

*R

ate

C,0

)))

=G

34

-H

34

DU

=

VL

OO

KU

P(A

35

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Ma

tt T

ap

e

0.2

2

12

=

E3

5*F

35

=

IF

(C

35

="A

",G

35

*R

ate

A,IF

(C

35

="B

",G

35

*R

ate

B,IF

(C

35

="C

",G

35

*R

ate

C,0

)))

=G

35

-H

35

DU

=

VL

OO

KU

P(A

36

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Pla

stic

P

ocke

ts

0.4

55

4

0

=E

36

*F

36

=

IF

(C

36

="A

",G

36

*R

ate

A,IF

(C

36

="B

",G

36

*R

ate

B,IF

(C

36

="C

",G

36

*R

ate

C,0

)))

=G

36

-H

36

Com

pany

Lookup used

1 m

ark

E

xternal file/sheet for code

1 m

ark

C

orrect range

1 m

ark

C

orrect return colu

mn

1 m

ark

Cost

Correct form

ula

e

1 m

ark

Soil

Nested IF

1 m

ark

C

orrect nam

ed cells

3 m

arks

C

orrect form

ula

e (3 parts)

3 m

arks

R

eturns Z

ero if not A

BC

1 m

ark

Replicatio

n

All 4 form

ula

e

1 m

ark

Orie

ntatio

n

Landscape

1 m

ark

Heade

r

nam

e, candid

ate no, centre no

1 m

ark

Rate

Data entry 100%

1 m

ark

CO

UN

TIF

C

orrect form

ula

e

3 m

arks

Pric

eC

orrect form

ula

e

1 m

ark

Pa

ge

3

M

ark

S

ch

em

e

Sy

lla

bu

s

Pa

pe

r

IG

CS

E –

M

ay

/J

un

e 2

00

7

04

18

0

3

Ca

nd

id

ate

n

am

e C

en

tre

n

um

be

r C

an

did

ate

n

um

be

r

© U

CLE

S 2007

DU

=

VL

OO

KU

P(A

37

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Pa

pe

r 5

0g

m

0.8

1

0

=E

37

*F

37

=

IF

(C

37

="A

",G

37

*R

ate

A,IF

(C

37

="B

",G

37

*R

ate

B,IF

(C

37

="C

",G

37

*R

ate

C,0

)))

=G

37

-H

37

SX

=

VL

OO

KU

P(A

38

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

Re

d fo

lde

r

0.3

9

10

0

=E

38

*F

38

=

IF

(C

38

="A

",G

38

*R

ate

A,IF

(C

38

="B

",G

38

*R

ate

B,IF

(C

38

="C

",G

38

*R

ate

C,0

)))

=G

38

-H

38

SX

=

VL

OO

KU

P(A

39

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

lack B

iro

2

.4

1

=

E3

9*F

39

=

IF

(C

39

="A

",G

39

*R

ate

A,IF

(C

39

="B

",G

39

*R

ate

B,IF

(C

39

="C

",G

39

*R

ate

C,0

)))

=G

39

-H

39

SX

=

VL

OO

KU

P(A

40

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

lue

B

iro

2

.4

2

=

E4

0*F

40

=

IF

(C

40

="A

",G

40

*R

ate

A,IF

(C

40

="B

",G

40

*R

ate

B,IF

(C

40

="C

",G

40

*R

ate

C,0

)))

=G

40

-H

40

BE

=

VL

OO

KU

P(A

41

,J7

co

de

!$

A$

2:$

B$

14

,2

)

G

re

en

file

0

.5

3

5

=E

41

*F

41

=

IF

(C

41

="A

",G

41

*R

ate

A,IF

(C

41

="B

",G

41

*R

ate

B,IF

(C

41

="C

",G

41

*R

ate

C,0

)))

=G

41

-H

41

BE

=

VL

OO

KU

P(A

42

,J7

co

de

!$

A$

2:$

B$

14

,2

)

P

lastic

P

ocke

ts

0.4

55

2

=

E4

2*F

42

=

IF

(C

42

="A

",G

42

*R

ate

A,IF

(C

42

="B

",G

42

*R

ate

B,IF

(C

42

="C

",G

42

*R

ate

C,0

)))

=G

42

-H

42

BE

=

VL

OO

KU

P(A

43

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

lack B

iro

2

.4

1

=

E4

3*F

43

=

IF

(C

43

="A

",G

43

*R

ate

A,IF

(C

43

="B

",G

43

*R

ate

B,IF

(C

43

="C

",G

43

*R

ate

C,0

)))

=G

43

-H

43

BE

=

VL

OO

KU

P(A

44

,J7

co

de

!$

A$

2:$

B$

14

,2

)

P

ap

er 5

0g

m

0.8

4

=

E4

4*F

44

=

IF

(C

44

="A

",G

44

*R

ate

A,IF

(C

44

="B

",G

44

*R

ate

B,IF

(C

44

="C

",G

44

*R

ate

C,0

)))

=G

44

-H

44

CH

=

VL

OO

KU

P(A

45

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Blu

-T

ack E

co

n

1.8

35

1

0

=E

45

*F

45

=

IF

(C

45

="A

",G

45

*R

ate

A,IF

(C

45

="B

",G

45

*R

ate

B,IF

(C

45

="C

",G

45

*R

ate

C,0

)))

=G

45

-H

45

CH

=

VL

OO

KU

P(A

46

,J7

co

de

!$

A$

2:$

B$

14

,2

)

R

ed

fo

lde

r

0.3

9

5

=E

46

*F

46

=

IF

(C

46

="A

",G

46

*R

ate

A,IF

(C

46

="B

",G

46

*R

ate

B,IF

(C

46

="C

",G

46

*R

ate

C,0

)))

=G

46

-H

46

UT

B

=V

LO

OK

UP

(A

47

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Re

d file

0

.2

25

4

0

=E

47

*F

47

=

IF

(C

47

="A

",G

47

*R

ate

A,IF

(C

47

="B

",G

47

*R

ate

B,IF

(C

47

="C

",G

47

*R

ate

C,0

)))

=G

47

-H

47

CH

=

VL

OO

KU

P(A

48

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

Pe

ncil

0.0

2

10

0

=E

48

*F

48

=

IF

(C

48

="A

",G

48

*R

ate

A,IF

(C

48

="B

",G

48

*R

ate

B,IF

(C

48

="C

",G

48

*R

ate

C,0

)))

=G

48

-H

48

CH

=

VL

OO

KU

P(A

49

,J7

co

de

!$

A$

2:$

B$

14

,2

)

R

ed

B

iro

2

.4

2

=

E4

9*F

49

=

IF

(C

49

="A

",G

49

*R

ate

A,IF

(C

49

="B

",G

49

*R

ate

B,IF

(C

49

="C

",G

49

*R

ate

C,0

)))

=G

49

-H

49

CH

=

VL

OO

KU

P(A

50

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

lack B

iro

2

.4

1

=

E5

0*F

50

=

IF

(C

50

="A

",G

50

*R

ate

A,IF

(C

50

="B

",G

50

*R

ate

B,IF

(C

50

="C

",G

50

*R

ate

C,0

)))

=G

50

-H

50

CH

=

VL

OO

KU

P(A

51

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

lue

B

iro

2

.4

5

=

E5

1*F

51

=

IF

(C

51

="A

",G

51

*R

ate

A,IF

(C

51

="B

",G

51

*R

ate

B,IF

(C

51

="C

",G

51

*R

ate

C,0

)))

=G

51

-H

51

CH

=

VL

OO

KU

P(A

52

,J7

co

de

!$

A$

2:$

B$

14

,2

)

P

ap

er 5

0g

m

0.8

3

=

E5

2*F

52

=

IF

(C

52

="A

",G

52

*R

ate

A,IF

(C

52

="B

",G

52

*R

ate

B,IF

(C

52

="C

",G

52

*R

ate

C,0

)))

=G

52

-H

52

CH

=

VL

OO

KU

P(A

53

,J7

co

de

!$

A$

2:$

B$

14

,2

)

P

lastic

P

ocke

ts

0.4

55

2

=

E5

3*F

53

=

IF

(C

53

="A

",G

53

*R

ate

A,IF

(C

53

="B

",G

53

*R

ate

B,IF

(C

53

="C

",G

53

*R

ate

C,0

)))

=G

53

-H

53

CH

=

VL

OO

KU

P(A

54

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

Pe

ncil

0.0

2

10

0

=E

54

*F

54

=

IF

(C

54

="A

",G

54

*R

ate

A,IF

(C

54

="B

",G

54

*R

ate

B,IF

(C

54

="C

",G

54

*R

ate

C,0

)))

=G

54

-H

54

CH

=

VL

OO

KU

P(A

55

,J7

co

de

!$

A$

2:$

B$

14

,2

)

G

re

en

file

0

.5

3

5

=E

55

*F

55

=

IF

(C

55

="A

",G

55

*R

ate

A,IF

(C

55

="B

",G

55

*R

ate

B,IF

(C

55

="C

",G

55

*R

ate

C,0

)))

=G

55

-H

55

TI

=V

LO

OK

UP

(A

56

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Blu

-T

ack E

co

n

1.8

35

1

0

=E

56

*F

56

=

IF

(C

56

="A

",G

56

*R

ate

A,IF

(C

56

="B

",G

56

*R

ate

B,IF

(C

56

="C

",G

56

*R

ate

C,0

)))

=G

56

-H

56

TI

=V

LO

OK

UP

(A

57

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Tra

nsfe

r ca

se

0

.4

80

75

2

0

=E

57

*F

57

=

IF

(C

57

="A

",G

57

*R

ate

A,IF

(C

57

="B

",G

57

*R

ate

B,IF

(C

57

="C

",G

57

*R

ate

C,0

)))

=G

57

-H

57

TI

=V

LO

OK

UP

(A

58

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Ma

tt T

ap

e

0.2

2

12

=

E5

8*F

58

=

IF

(C

58

="A

",G

58

*R

ate

A,IF

(C

58

="B

",G

58

*R

ate

B,IF

(C

58

="C

",G

58

*R

ate

C,0

)))

=G

58

-H

58

TI

=V

LO

OK

UP

(A

59

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

lack F

ile

0

.5

65

1

=

E5

9*F

59

=

IF

(C

59

="A

",G

59

*R

ate

A,IF

(C

59

="B

",G

59

*R

ate

B,IF

(C

59

="C

",G

59

*R

ate

C,0

)))

=G

59

-H

59

TI

=V

LO

OK

UP

(A

60

,J7

co

de

!$

A$

2:$

B$

14

,2

)

P

lastic

P

ocke

ts

0.4

55

2

=

E6

0*F

60

=

IF

(C

60

="A

",G

60

*R

ate

A,IF

(C

60

="B

",G

60

*R

ate

B,IF

(C

60

="C

",G

60

*R

ate

C,0

)))

=G

60

-H

60

TI

=V

LO

OK

UP

(A

61

,J7

co

de

!$

A$

2:$

B$

14

,2

)

9

p

art file

1

.2

25

1

=

E6

1*F

61

=

IF

(C

61

="A

",G

61

*R

ate

A,IF

(C

61

="B

",G

61

*R

ate

B,IF

(C

61

="C

",G

61

*R

ate

C,0

)))

=G

61

-H

61

PM

=

VL

OO

KU

P(A

62

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

Pe

ncil

0.0

2

10

0

=E

62

*F

62

=

IF

(C

62

="A

",G

62

*R

ate

A,IF

(C

62

="B

",G

62

*R

ate

B,IF

(C

62

="C

",G

62

*R

ate

C,0

)))

=G

62

-H

62

PM

=

VL

OO

KU

P(A

63

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Ma

tt T

ap

e

0.2

2

12

=

E6

3*F

63

=

IF

(C

63

="A

",G

63

*R

ate

A,IF

(C

63

="B

",G

63

*R

ate

B,IF

(C

63

="C

",G

63

*R

ate

C,0

)))

=G

63

-H

63

PM

=

VL

OO

KU

P(A

64

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

lack B

iro

2

.4

1

=

E6

4*F

64

=

IF

(C

64

="A

",G

64

*R

ate

A,IF

(C

64

="B

",G

64

*R

ate

B,IF

(C

64

="C

",G

64

*R

ate

C,0

)))

=G

64

-H

64

PM

=

VL

OO

KU

P(A

65

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

Pa

pe

r 5

0g

m

0.8

5

0

=E

65

*F

65

=

IF

(C

65

="A

",G

65

*R

ate

A,IF

(C

65

="B

",G

65

*R

ate

B,IF

(C

65

="C

",G

65

*R

ate

C,0

)))

=G

65

-H

65

PM

=

VL

OO

KU

P(A

66

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Ma

tt T

ap

e

0.2

2

12

=

E6

6*F

66

=

IF

(C

66

="A

",G

66

*R

ate

A,IF

(C

66

="B

",G

66

*R

ate

B,IF

(C

66

="C

",G

66

*R

ate

C,0

)))

=G

66

-H

66

PM

=

VL

OO

KU

P(A

67

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Pla

stic

P

ocke

ts

0.4

55

1

0

=E

67

*F

67

=

IF

(C

67

="A

",G

67

*R

ate

A,IF

(C

67

="B

",G

67

*R

ate

B,IF

(C

67

="C

",G

67

*R

ate

C,0

)))

=G

67

-H

67

PM

=

VL

OO

KU

P(A

68

,J7

co

de

!$

A$

2:$

B$

14

,2

)

R

ed

B

iro

2

.4

3

=

E6

8*F

68

=

IF

(C

68

="A

",G

68

*R

ate

A,IF

(C

68

="B

",G

68

*R

ate

B,IF

(C

68

="C

",G

68

*R

ate

C,0

)))

=G

68

-H

68

PM

=

VL

OO

KU

P(A

69

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Blu

e-T

ack sm

all

2.5

45

1

0

=E

69

*F

69

=

IF

(C

69

="A

",G

69

*R

ate

A,IF

(C

69

="B

",G

69

*R

ate

B,IF

(C

69

="C

",G

69

*R

ate

C,0

)))

=G

69

-H

69

PM

=

VL

OO

KU

P(A

70

,J7

co

de

!$

A$

2:$

B$

14

,2

)

P

en

cil sh

arp

en

er

0.2

6

=

E7

0*F

70

=

IF

(C

70

="A

",G

70

*R

ate

A,IF

(C

70

="B

",G

70

*R

ate

B,IF

(C

70

="C

",G

70

*R

ate

C,0

)))

=G

70

-H

70

PM

=

VL

OO

KU

P(A

71

,J7

co

de

!$

A$

2:$

B$

14

,2

)

G

re

en

F

ile

0

.5

65

1

=

E7

1*F

71

=

IF

(C

71

="A

",G

71

*R

ate

A,IF

(C

71

="B

",G

71

*R

ate

B,IF

(C

71

="C

",G

71

*R

ate

C,0

)))

=G

71

-H

71

SX

=

VL

OO

KU

P(A

72

,J7

co

de

!$

A$

2:$

B$

14

,2

)

R

ed

F

ile

0

.5

65

1

=

E7

2*F

72

=

IF

(C

72

="A

",G

72

*R

ate

A,IF

(C

72

="B

",G

72

*R

ate

B,IF

(C

72

="C

",G

72

*R

ate

C,0

)))

=G

72

-H

72

Pa

ge

4

M

ark

S

ch

em

e

Sy

lla

bu

s

Pa

pe

r

IG

CS

E –

M

ay

/J

un

e 2

00

7

04

18

0

3

Ca

nd

id

ate

n

am

e C

en

tre

n

um

be

r C

an

did

ate

n

um

be

r

© U

CLE

S 2007

OW

=

VL

OO

KU

P(A

73

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Re

d file

0

.2

25

1

0

=E

73

*F

73

=

IF

(C

73

="A

",G

73

*R

ate

A,IF

(C

73

="B

",G

73

*R

ate

B,IF

(C

73

="C

",G

73

*R

ate

C,0

)))

=G

73

-H

73

OW

=

VL

OO

KU

P(A

74

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Tra

nsfe

r F

ile

0

.2

59

75

2

0

=E

74

*F

74

=

IF

(C

74

="A

",G

74

*R

ate

A,IF

(C

74

="B

",G

74

*R

ate

B,IF

(C

74

="C

",G

74

*R

ate

C,0

)))

=G

74

-H

74

OW

=

VL

OO

KU

P(A

75

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Ma

tt T

ap

e

0.2

2

12

=

E7

5*F

75

=

IF

(C

75

="A

",G

75

*R

ate

A,IF

(C

75

="B

",G

75

*R

ate

B,IF

(C

75

="C

",G

75

*R

ate

C,0

)))

=G

75

-H

75

PT

=

VL

OO

KU

P(A

76

,J7

co

de

!$

A$

2:$

B$

14

,2

)

P

lastic

P

ocke

ts

0.4

55

2

=

E7

6*F

76

=

IF

(C

76

="A

",G

76

*R

ate

A,IF

(C

76

="B

",G

76

*R

ate

B,IF

(C

76

="C

",G

76

*R

ate

C,0

)))

=G

76

-H

76

PT

=

VL

OO

KU

P(A

77

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Tra

nsfe

r ca

se

0

.4

80

75

2

0

=E

77

*F

77

=

IF

(C

77

="A

",G

77

*R

ate

A,IF

(C

77

="B

",G

77

*R

ate

B,IF

(C

77

="C

",G

77

*R

ate

C,0

)))

=G

77

-H

77

PT

=

VL

OO

KU

P(A

78

,J7

co

de

!$

A$

2:$

B$

14

,2

)

B

lue

fo

lde

r

0.5

65

1

=

E7

8*F

78

=

IF

(C

78

="A

",G

78

*R

ate

A,IF

(C

78

="B

",G

78

*R

ate

B,IF

(C

78

="C

",G

78

*R

ate

C,0

)))

=G

78

-H

78

PT

=

VL

OO

KU

P(A

79

,J7

co

de

!$

A$

2:$

B$

14

,2

)

R

ed

F

ile

0

.5

65

1

=

E7

9*F

79

=

IF

(C

79

="A

",G

79

*R

ate

A,IF

(C

79

="B

",G

79

*R

ate

B,IF

(C

79

="C

",G

79

*R

ate

C,0

)))

=G

79

-H

79

PT

=

VL

OO

KU

P(A

80

,J7

co

de

!$

A$

2:$

B$

14

,2

)

C

Blu

e-T

ack sm

all

2.5

45

1

0

=E

80

*F

80

=

IF

(C

80

="A

",G

80

*R

ate

A,IF

(C

80

="B

",G

80

*R

ate

B,IF

(C

80

="C

",G

80

*R

ate

C,0

)))

=G

80

-H

80


IGCSE – May/June 2007 0418 03

Candidate name Centre number Candidate number

© UCLES 2007

CCode Number of items Dcode Rate

SX 4 A 23%

BE 4 B 18%

UTB 7 C 10%

CCode Company Code Item Unit Quantity Cost Discount Price

BB Bettabuy B Pencil £0.02 100 £2.00 £0.36 £1.64

BB Bettabuy C Ruler £0.14 12 £1.68 £0.17 £1.51

BB Bettabuy Desk £146.30 3 £438.90 £0.00 £438.90

BB Bettabuy Chair £55.20 3 £165.60 £0.00 £165.60

BB Bettabuy Waste bin £5.20 5 £26.00 £0.00 £26.00

BB Bettabuy Shredder £23.40 1 £23.40 £0.00 £23.40

DY Dygitell Clear Tape £1.12 6 £6.72 £0.00 £6.72

DY Dygitell C Matt Tape £0.22 12 £2.64 £0.26 £2.38

DY Dygitell B Paper Clips £0.75 60 £44.70 £8.05 £36.65

DY Dygitell B Pencil £0.02 100 £2.00 £0.36 £1.64

MB Ms Bright C

Blue-Tack

small £2.55 10 £25.45 £2.55 £22.91

MB Ms Bright Red File £0.57 1 £0.57 £0.00 £0.57

MB Ms Bright Black File £0.57 1 £0.57 £0.00 £0.57

UTB

University of Tawara

Beach C Transfer case £0.48 20 £9.62 £0.96 £8.65

UTB


Beach C Transfer File £0.26 20 £5.20 £0.52 £4.68

UTB


Beach Red Biro £2.40 2 £4.80 £0.00 £4.80

UTB


Beach Black Biro £2.40 5 £12.00 £0.00 £12.00

UTB


Beach Green Biro £2.40 1 £2.40 £0.00 £2.40

UTB


Beach A Red File £0.57 2000 £1,130.00 £254.25 £875.75

RT Rootrainer Trees C Red File £0.57 25 £14.13 £1.41 £12.71

RT Rootrainer Trees C

Plastic

Pockets £0.46 10 £4.55 £0.46 £4.10

RT Rootrainer Trees Black Biro £2.40 5 £12.00 £0.00 £12.00

RT Rootrainer Trees Blue Biro £2.40 5 £12.00 £0.00 £12.00

RT Rootrainer Trees B Pencil £0.02 100 £2.00 £0.36 £1.64

DU Dudley Red folder £0.39 5 £1.95 £0.00 £1.95

DU Dudley C

Blue-Tack

small £2.55 10 £25.45 £2.55 £22.91

DU Dudley Green file £0.53 5 £2.65 £0.00 £2.65

DU Dudley Paper 65gm £1.20 4 £4.80 £0.00 £4.80

DU Dudley C Matt Tape £0.22 12 £2.64 £0.26 £2.38

DU Dudley C

Plastic

Pockets £0.46 40 £18.20 £1.82 £16.38

DU Dudley C Paper 50gm £0.80 10 £8.00 £0.80 £7.20

SX Simplex B Red folder £0.39 100 £39.00 £7.02 £31.98

SX Simplex Black Biro £2.40 1 £2.40 £0.00 £2.40

SX Simplex Blue Biro £2.40 2 £4.80 £0.00 £4.80

BE Beauchamp Green file £0.53 5 £2.65 £0.00 £2.65

BE Beauchamp

Plastic

Pockets £0.46 2 £0.91 £0.00 £0.91

BE Beauchamp Black Biro £2.40 1 £2.40 £0.00 £2.40

BE Beauchamp Paper 50gm £0.80 4 £3.20 £0.00 £3.20

CH Cheaper C

Blu-Tack

Economy £1.84 10 £18.35 £1.84 £16.52

CH Cheaper Red folder £0.39 5 £1.95 £0.00 £1.95

Rate 0dp & % values 1 mark

Unit, Cost, Discount, Price ONLY

Sterling & 2dp 1 mark




© UCLES 2007

UTB


Beach C Red file £0.23 40 £9.00 £0.90 £8.10

CH Cheaper B Pencil £0.02 100 £2.00 £0.36 £1.64

CH Cheaper Red Biro £2.40 2 £4.80 £0.00 £4.80

CH Cheaper Black Biro £2.40 1 £2.40 £0.00 £2.40

CH Cheaper Blue Biro £2.40 5 £12.00 £0.00 £12.00

CH Cheaper Paper 50gm £0.80 3 £2.40 £0.00 £2.40

CH Cheaper

Plastic

Pockets £0.46 2 £0.91 £0.00 £0.91

CH Cheaper B Pencil £0.02 100 £2.00 £0.36 £1.64

CH Cheaper Green file £0.53 5 £2.65 £0.00 £2.65

TI TryIT C

Blu-Tack

Economy £1.84 10 £18.35 £1.84 £16.52

TI TryIT C Transfer case £0.48 20 £9.62 £0.96 £8.65

TI TryIT C Matt Tape £0.22 12 £2.64 £0.26 £2.38

TI TryIT Black File £0.57 1 £0.57 £0.00 £0.57

TI TryIT

Plastic

Pockets £0.46 2 £0.91 £0.00 £0.91

TI TryIT 9 part file £1.23 1 £1.23 £0.00 £1.23

PM Papermite B Pencil £0.02 100 £2.00 £0.36 £1.64

PM Papermite C Matt Tape £0.22 12 £2.64 £0.26 £2.38

PM Papermite Black Biro £2.40 1 £2.40 £0.00 £2.40

PM Papermite B Paper 50gm £0.80 50 £40.00 £7.20 £32.80

PM Papermite C Matt Tape £0.22 12 £2.64 £0.26 £2.38

PM Papermite C

Plastic

Pockets £0.46 10 £4.55 £0.46 £4.10

PM Papermite Red Biro £2.40 3 £7.20 £0.00 £7.20

PM Papermite C

Blue-Tack

small £2.55 10 £25.45 £2.55 £22.91

PM Papermite

Pencil

sharpener £0.20 6 £1.20 £0.00 £1.20

PM Papermite Green File £0.57 1 £0.57 £0.00 £0.57

SX Simplex Red File £0.57 1 £0.57 £0.00 £0.57

OW Owen C Red file £0.23 10 £2.25 £0.23 £2.03

OW Owen C Transfer File £0.26 20 £5.20 £0.52 £4.68

OW Owen C Matt Tape £0.22 12 £2.64 £0.26 £2.38

PT Patel

Plastic

Pockets £0.46 2 £0.91 £0.00 £0.91

PT Patel C Transfer case £0.48 20 £9.62 £0.96 £8.65

PT Patel Blue folder £0.57 1 £0.57 £0.00 £0.57

PT Patel Red File £0.57 1 £0.57 £0.00 £0.57

PT Patel C

Blue-Tack

small £2.55 10 £25.45 £2.55 £22.91


Step 16

Company Item Quantity Price

Ms Bright Red File 1 £0.57

Ms Bright Black File 1 £0.57

Beauchamp Plastic Pockets 2 £0.91

Cheaper Plastic Pockets 2 £0.91

TryIT Black File 1 £0.57

TryIT Plastic Pockets 2 £0.91

Papermite Green File 1 £0.57

Simplex Red File 1 £0.57

Patel Plastic Pockets 2 £0.91

Patel Blue folder 1 £0.57

Patel Red File 1 £0.57

Hidden Rows 1-5 1 mark

Hidden Columns A, C, E, G, H 1 mark

Search Price <1 2 marks

Search Quantity >=60 AND Price >2 2 marks




© UCLES 2007

Step 17

Company Item Quantity Price

Dygitell Paper Clips 60 £36.65

University of Tawara Beach Red File 2000 £875.75

Simplex Red folder 100 £31.98

STYLESHEET

h1 { color: #000066; font-family: Arial, sans-serif; font-size: 24pt; text-align: center; font-weight:

bold }

h2 { color: #000066; font-family: Arial, sans-serif; font-size: 18pt; text-align: center }

h3 { color: #0000FF; font-family: Arial, sans-serif; font-size: 12pt; text-align: right }

h4 { color: #0000FF; font-family: Arial, sans-serif; font-size: 12pt; text-align: center }

li { color: #000000; font-family: “Times New Roman”, serif; font-size: 10pt; text-align: left; font-

style: italic}

p { color: #0000FF; font-family: “Times New Roman”, serif; font-size: 10pt; text-align: left }


Colour all correct 1 mark

Font all correct 1 mark

Size all correct – including units 1 mark

Alignment all correct 1 mark

h1 bold 1 mark

li italic 1 mark




© UCLES 2007

<html>

<head>

<title>Homepage</title>

<link rel="stylesheet" type ="text/css" href="styles.css">

</head>

<body>

<h3>Last edited by Candidate name, candidate number, centre number<h3>

<h1>Hothouse Design</h1>

<table width="100%" border="3" cellspacing="4" cellpadding="4">

<tbody>

<tr>

<td><h4>Home Page</h4></td>

<td><h4>About us</h4></td>

<td><h4>Products</h4></td>

Top right Last edited by & NAME & No’s 1 mark

style h3 1 mark

Table 4 rows & 2 columns 1 mark

Merge cells in row 1 1 mark


Merge rows 2 & 3 in 2nd

col 1 mark

Correct text in each cell 1 mark

Style h1 From stylesheet 1 mark

Image Correct image aspect ratio

and position 1 mark

Menu Contains J7MENU.HTM 1 mark

Style h4 1 mark



Style p From stylesheet 1 mark

Style li From stylesheet 1 mark




Table Cell padding 4 1 mark

Cell spacing 4 1 mark

Width 100% 1 mark

Border 3 1 mark




© UCLES 2007

<td><h4><a href="J7OFFER.htm" target="_external">Special offers</h4></a></td>

</tr>

</tbody>

</table>

<table cellspacing="4" cellpadding="4" width="100%" border=1>

<tr>

<td colspan="2"><h2>Hothouse Design can provide your stationery and ICT needs, with a first rate service

and high quality products.</h2></td>

</tr>

<tr>

<td><p>We offer a range of products including:</p>

<li>stationery</li>

<li>computer hardware</li>

<li>computer software</li>

<li>computer consumables</li>

<p>and much more.</p></td>

<td rowspan="2"><img src="J7SUPPLY.jpg" width="300"></td>

</tr>

<tr>

<td><h2>You can contact us in many ways.</h2></td>

</tr>

<tr>

<td colspan="2"><h3>Through our website on-line - use our order form. By post - order our catalogue and

complete the order form. By phone or fax - all contact details on this website. You can order our catalogue for a

full listing of our services.</h3></td>

</tr>

</table>

</body>

</html>



Width 100% 1 mark

Border 1 1 mark

Image Width = “300” 1 mark

Hyperlink Correct target window 1 mark




© UCLES 2007

<html>

<head>

<title>Special Offers Page</title>

<link rel="stylesheet" type ="text/css" href="styles.css"

</head>

<body>

<p>Last updated by Candidate name, candidate number and centre number</p>

<h1>This weeks special offers!</h1>


<tr>


<h4><b>Limited whilst stocks last</b></h4>

<p>Contact the sales team for:</p>

<li>12 pencils 4H to 4B £0.80</li>

<li>Rounded scissors £0.20</li>

<li>Parcel Tape - roll £0.85</li>

<li>Highlighters - each £0.18</li>

<h3>We offer many more exciting offers including daily SPECIAL OFFERS</h3>

<p>Please ring our sales staff for details</p>

</td>

<td>

<img src="j7supp1.jpg" width = "250" />

Image Width 250 1 mark


Top left NAME & No’s 1 mark

Image Correct & in this cell 1 mark

Image Replaced text 1 mark




© UCLES 2007

</td>

</tr>

</table>

<p>Click on the logo for the homepage</p>

<a href="homepage.htm"><img src="j7logo.gif" width="50" height="53"></a>

</body>

</html>

Image Width 50 & height 52 or 53 1 mark

If height not visible in code look at browser view

Correct Hyperlink 1 mark




© UCLES 2007

Presenter notes on all slides 1 mark

100 % Correct 1 mark

right place 1 mark

Heading Dark blue, right aligned, 48 point 1 mark

Subheading Blue, right aligned, 32 point 1 mark

Master slide - CHECK CONSISTENCY

Logo pen/pencil, top right 1 mark

Page numbering Bottom right & automated 1 mark

Name cand no, centre no bottom left 1 mark

All 3 Not overlapping text or object 1 mark




© UCLES 2007


Bullets Black, left aligned, 24 point, consistent 1 mark

Subheading Blue, right aligned, 32 point 1 mark

Image J7SUPP1,jpg 1 mark

Fills most of right side with no overlap 1 mark

Line 3 point, black 1 mark

Horizontal 1 mark




© UCLES 2007


Bullets Black, left aligned, 24 point, consistent 1 mark

Correct &Consistent with slide 2 1 mark

Chart Correct chart 1 mark

Product names all visible 1 mark

Products label 1 mark

Number Sold label 1 mark

Right side 1 mark




© UCLES 2007

Audience notes Printed with space to annotate 1 mark

3 per page ` 1 mark




© UCLES 2007

Animation Bullets only 2 marks

Transition slides 2 and 3 2 marks





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.



demonstrated.


examination.


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.


IGCSE – October/November 2007 0418 03


© UCLES 2007

DCode Rate Type Count

A 0.045 Cartridge =COUNTIF($A$7:$A$80,G2)

B 0.09 Paper =COUNTIF($A$7:$A$80,G3)

C 0.125 Storage =COUNTIF($A$7:$A$80,G4)

Type Item Supplier Code Sales Unit Cost Cost Discount Price

Storage CD-R Maxell A 10 =VLOOKUP(D7,N7code.csv!$A$2:$B$14,2) =E7*F7 =IF(E7>=30,RateC*G7,IF(E7>=20,RateB*G7,IF(E7>=10,RateA*G7,0))) =G7-H7

Storage CD-R Sony B 10 =VLOOKUP(D8,N7code.csv!$A$2:$B$14,2) =E8*F8 =IF(E8>=30,RateC*G8,IF(E8>=20,RateB*G8,IF(E8>=10,RateA*G8,0))) =G8-H8

Storage CD-RW Sony E 2 =VLOOKUP(D9,N7code.csv!$A$2:$B$14,2) =E9*F9 =IF(E9>=30,RateC*G9,IF(E9>=20,RateB*G9,IF(E9>=10,RateA*G9,0))) =G9-H9

Paper P2345 HP A 30 =VLOOKUP(D10,N7code.csv!$A$2:$B$14,2) =E10*F10 =IF(E10>=30,RateC*G10,IF(E10>=20,RateB*G10,IF(E10>=10,RateA*G10,0))) =G10-H10

Storage DVD-R Maxell H 12 =VLOOKUP(D11,N7code.csv!$A$2:$B$14,2) =E11*F11 =IF(E11>=30,RateC*G11,IF(E11>=20,RateB*G11,IF(E11>=10,RateA*G11,0))) =G11-H11

Cartridge HP56 HP H 1 =VLOOKUP(D12,N7code.csv!$A$2:$B$14,2) =E12*F12 =IF(E12>=30,RateC*G12,IF(E12>=20,RateB*G12,IF(E12>=10,RateA*G12,0))) =G12-H12

Storage CD-R Sony B 8 =VLOOKUP(D13,N7code.csv!$A$2:$B$14,2) =E13*F13 =IF(E13>=30,RateC*G13,IF(E13>=20,RateB*G13,IF(E13>=10,RateA*G13,0))) =G13-H13

Cartridge HP29 HP J 1 =VLOOKUP(D14,N7code.csv!$A$2:$B$14,2) =E14*F14 =IF(E14>=30,RateC*G14,IF(E14>=20,RateB*G14,IF(E14>=10,RateA*G14,0))) =G14-H14

Cartridge HP26 HP I 6 =VLOOKUP(D15,N7code.csv!$A$2:$B$14,2) =E15*F15 =IF(E15>=30,RateC*G15,IF(E15>=20,RateB*G15,IF(E15>=10,RateA*G15,0))) =G15-H15

Cartridge HP15 HP L 6 =VLOOKUP(D16,N7code.csv!$A$2:$B$14,2) =E16*F16 =IF(E16>=30,RateC*G16,IF(E16>=20,RateB*G16,IF(E16>=10,RateA*G16,0))) =G16-H16

Storage DVD-RW Sony K 1 =VLOOKUP(D17,N7code.csv!$A$2:$B$14,2) =E17*F17 =IF(E17>=30,RateC*G17,IF(E17>=20,RateB*G17,IF(E17>=10,RateA*G17,0))) =G17-H17


Storage CD-RW Imation D 12 =VLOOKUP(D19,N7code.csv!$A$2:$B$14,2) =E19*F19 =IF(E19>=30,RateC*G19,IF(E19>=20,RateB*G19,IF(E19>=10,RateA*G19,0))) =G19-H19

Paper P2348 HP F 8 =VLOOKUP(D20,N7code.csv!$A$2:$B$14,2) =E20*F20 =IF(E20>=30,RateC*G20,IF(E20>=20,RateB*G20,IF(E20>=10,RateA*G20,0))) =G20-H20



Cartridge HP56 HP H 20 =VLOOKUP(D23,N7code.csv!$A$2:$B$14,2) =E23*F23 =IF(E23>=30,RateC*G23,IF(E23>=20,RateB*G23,IF(E23>=10,RateA*G23,0))) =G23-H23

Paper P2348 HP F 1 =VLOOKUP(D24,N7code.csv!$A$2:$B$14,2) =E24*F24 =IF(E24>=30,RateC*G24,IF(E24>=20,RateB*G24,IF(E24>=10,RateA*G24,0))) =G24-H24

Cartridge BCI-6PY Amazon M 12 =VLOOKUP(D25,N7code.csv!$A$2:$B$14,2) =E25*F25 =IF(E25>=30,RateC*G25,IF(E25>=20,RateB*G25,IF(E25>=10,RateA*G25,0))) =G25-H25

Storage DVD-R Maxell H 4 =VLOOKUP(D26,N7code.csv!$A$2:$B$14,2) =E26*F26 =IF(E26>=30,RateC*G26,IF(E26>=20,RateB*G26,IF(E26>=10,RateA*G26,0))) =G26-H26


Cartridge T036120 Amazon D 5 =VLOOKUP(D28,N7code.csv!$A$2:$B$14,2) =E28*F28 =IF(E28>=30,RateC*G28,IF(E28>=20,RateB*G28,IF(E28>=10,RateA*G28,0))) =G28-H28





Cartridge BCI-24BK Amazon B 6 =VLOOKUP(D33,N7code.csv!$A$2:$B$14,2) =E33*F33 =IF(E33>=30,RateC*G33,IF(E33>=20,RateB*G33,IF(E33>=10,RateA*G33,0))) =G33-H33


Cartridge BCI-6BK Amazon D 3 =VLOOKUP(D35,N7code.csv!$A$2:$B$14,2) =E35*F35 =IF(E35>=30,RateC*G35,IF(E35>=20,RateB*G35,IF(E35>=10,RateA*G35,0))) =G35-H35

Cartridge T037020 Amazon E 10 =VLOOKUP(D36,N7code.csv!$A$2:$B$14,2) =E36*F36 =IF(E36>=30,RateC*G36,IF(E36>=20,RateB*G36,IF(E36>=10,RateA*G36,0))) =G36-H36


Cartridge BCI-6PC Amazon M 1 =VLOOKUP(D38,N7code.csv!$A$2:$B$14,2) =E38*F38 =IF(E38>=30,RateC*G38,IF(E38>=20,RateB*G38,IF(E38>=10,RateA*G38,0))) =G38-H38

Cartridge BCI-6PM Amazon M 1 =VLOOKUP(D39,N7code.csv!$A$2:$B$14,2) =E39*F39 =IF(E39>=30,RateC*G39,IF(E39>=20,RateB*G39,IF(E39>=10,RateA*G39,0))) =G39-H39


Paper P2354 HP B 10 =VLOOKUP(D41,N7code.csv!$A$2:$B$14,2) =E41*F41 =IF(E41>=30,RateC*G41,IF(E41>=20,RateB*G41,IF(E41>=10,RateA*G41,0))) =G41-H41

Rate Data entry 100% 1 mark

Unit cost Lookup used 1 mark

External file/sheet for code 1 mark

Correct range 1 mark

Correct return column 1 mark

Cost Correct formulae 1 mark

Discount Nested IF – must be 3 tiers 1 mark

Correct named cells 3 marks

Correct formulae (3 parts) 3 marks

Returns zero 1 mark

Replication All 4 formulae 1 mark

Orientation Landscape 1 mark

COUNTIF Correct formulae 3 marks

1 mark for each correct formulae with correct range –

do not accept references within the range

Price Correct formulae 1 mark

Header Name and Numbers 1 mark




© UCLES 2007

Paper P2346 HP C 15 =VLOOKUP(D42,N7code.csv!$A$2:$B$14,2) =E42*F42 =IF(E42>=30,RateC*G42,IF(E42>=20,RateB*G42,IF(E42>=10,RateA*G42,0))) =G42-H42






Paper P2351 HP D 8 =VLOOKUP(D48,N7code.csv!$A$2:$B$14,2) =E48*F48 =IF(E48>=30,RateC*G48,IF(E48>=20,RateB*G48,IF(E48>=10,RateA*G48,0))) =G48-H48





Cartridge BCI-6C Amazon D 2 =VLOOKUP(D53,N7code.csv!$A$2:$B$14,2) =E53*F53 =IF(E53>=30,RateC*G53,IF(E53>=20,RateB*G53,IF(E53>=10,RateA*G53,0))) =G53-H53

Cartridge BCI-6M Amazon D 2 =VLOOKUP(D54,N7code.csv!$A$2:$B$14,2) =E54*F54 =IF(E54>=30,RateC*G54,IF(E54>=20,RateB*G54,IF(E54>=10,RateA*G54,0))) =G54-H54

Cartridge BCI-6Y Amazon D 2 =VLOOKUP(D55,N7code.csv!$A$2:$B$14,2) =E55*F55 =IF(E55>=30,RateC*G55,IF(E55>=20,RateB*G55,IF(E55>=10,RateA*G55,0))) =G55-H55







Cartridge BCI-6PBK Amazon F 4 =VLOOKUP(D62,N7code.csv!$A$2:$B$14,2) =E62*F62 =IF(E62>=30,RateC*G62,IF(E62>=20,RateB*G62,IF(E62>=10,RateA*G62,0))) =G62-H62

Cartridge HP23 HP K 10 =VLOOKUP(D63,N7code.csv!$A$2:$B$14,2) =E63*F63 =IF(E63>=30,RateC*G63,IF(E63>=20,RateB*G63,IF(E63>=10,RateA*G63,0))) =G63-H63










Cartridge HP23 HP K 6 =VLOOKUP(D73,N7code.csv!$A$2:$B$14,2) =E73*F73 =IF(E73>=30,RateC*G73,IF(E73>=20,RateB*G73,IF(E73>=10,RateA*G73,0))) =G73-H73


Cartridge T042220 Amazon F 10 =VLOOKUP(D75,N7code.csv!$A$2:$B$14,2) =E75*F75 =IF(E75>=30,RateC*G75,IF(E75>=20,RateB*G75,IF(E75>=10,RateA*G75,0))) =G75-H75









© UCLES 2007

Storage CD-R Maxell A 10 £2.79 £27.90 £1.26 £26.64

Storage CD-R Sony B 10 £2.99 £29.90 £1.35 £28.55

Storage CD-RW Sony E 2 £4.79 £9.58 £0.00 £9.58

Paper P2345 HP

A 30 £2.79 £83.70 £10.46 £73.24

Storage DVD-R Maxell H 12 £7.99 £95.88 £4.31 £91.57

Cartridge HP56 HP H 1 £7.99 £7.99 £0.00 £7.99

Storage CD-R Sony B 8 £2.99 £23.92 £0.00 £23.92

Cartridge HP29 HP J 1 £8.79 £8.79 £0.00 £8.79

Cartridge HP26 HP I 6 £8.29 £49.74 £0.00 £49.74

Cartridge HP15 HP L 6 £9.29 £55.74 £0.00 £55.74

Storage DVD-RW Sony K 1 £8.99 £8.99 £0.00 £8.99

Cartridge HP15 HP L 2 £9.29 £18.58 £0.00 £18.58

Storage CD-RW Imation D 12 £4.49 £53.88 £2.42 £51.46

Paper P2348 HP F 8 £4.99 £39.92 £0.00 £39.92



Cartridge HP56 HP H 20 £7.99 £159.80 £14.38 £145.42

Paper P2348 HP F 1 £4.99 £4.99 £0.00 £4.99

Cartridge BCI-6PY Amazon M 12 £5.49 £65.88 £2.96 £62.92

Storage DVD-R Maxell H 4 £7.99 £31.96 £0.00 £31.96


Cartridge T036120 Amazon D 5 £4.49 £22.45 £0.00 £22.45

Cartridge HP45 HP L 12 £9.29 £111.48 £5.02 £106.46



Cartridge HP49 HP I 3 £8.29 £24.87 £0.00 £24.87

Cartridge BCI-24BK Amazon B 6 £2.99 £17.94 £0.00 £17.94


Cartridge BCI-6BK Amazon D 3 £4.49 £13.47 £0.00 £13.47

Cartridge T037020 Amazon E 10 £4.79 £47.90 £2.16 £45.74


Cartridge BCI-6PC Amazon M 1 £5.49 £5.49 £0.00 £5.49

Cartridge BCI-6PM Amazon M 1 £5.49 £5.49 £0.00 £5.49


Paper P2354 HP B 10 £2.99 £29.90 £1.35 £28.55

Paper P2346 HP C 15 £3.29 £49.35 £2.22 £47.13


Paper P2352 HP A 4 £2.79 £11.16 £0.00 £11.16

Cartridge HP200 HP I 6 £8.29 £49.74 £0.00 £49.74



Paper P2351 HP D 8 £4.49 £35.92 £0.00 £35.92

Paper P2356 HP C 2 £3.29 £6.58 £0.00 £6.58

Paper P2346 HP C 10 £3.29 £32.90 £1.48 £31.42



Cartridge BCI-6C Amazon D 2 £4.49 £8.98 £0.00 £8.98

Cartridge BCI-6M Amazon D 2 £4.49 £8.98 £0.00 £8.98

Cartridge BCI-6Y Amazon D 2 £4.49 £8.98 £0.00 £8.98

DCode Rate Type Count

A 5% Cartridge 28

B 9% Paper 18

C 13% Storage 28

Type Item Supplier Code Sales Unit Cost Cost Discount Price

Rate 0dp & % values 1 mark

Unit Cost, Cost, Discount, Price

2dp & currency sterling 1 mark




© UCLES 2007

Paper P2356 HP C 10 £3.29 £32.90 £1.48 £31.42


Paper P2347 HP D 2 £4.49 £8.98 £0.00 £8.98

Paper P2351 HP D 8 £4.49 £35.92 £0.00 £35.92



Cartridge BCI-6PBK Amazon F 4 £4.99 £19.96 £0.00 £19.96

Cartridge HP23 HP K 10 £8.99 £89.90 £4.05 £85.85




Paper P2352 HP A 5 £2.79 £13.95 £0.00 £13.95

Paper P2353 HP A 10 £2.79 £27.90 £1.26 £26.64

Paper P2351 HP D 5 £4.49 £22.45 £0.00 £22.45

Paper P2352 HP A 1 £2.79 £2.79 £0.00 £2.79



Cartridge HP23 HP K 6 £8.99 £53.94 £0.00 £53.94


Cartridge T042220 Amazon F 10 £4.99 £49.90 £2.25 £47.65



Paper P2346 HP C 30 £3.29 £98.70 £12.34 £86.36

Paper P2352 HP A 1 £2.79 £2.79 £0.00 £2.79



Step 16

Item Supplier Sales Price

CD-R Maxell 10 £26.64

DVD-R Maxell 12 £91.57

DVD-R Maxell 4 £31.96


Step 17

Item Supplier Sales Price

P2345 HP 30 £73.24

CD-RW Imation 24 £98.06

T037020 Amazon 20 £87.18

P2346 HP 30 £86.36

STYLESHEET

h1 { color: #000000; font-family: Times New Roman, serif; font-size:36pt; text-align: Center }

h2 { color: #000000; font-family: Times New Roman, serif; font-size: 18pt; text-align: Center }

h3 { color: #FF0000; font-family: Arial, sans-serif; font-size: 12pt; text-align: center; font-weight:

bold }

h4 { color: #FF0000; font-family: Arial, sans-serif; font-size: 12pt; text-align: left }

li { color: #FF0000; font-family: Arial, sans-serif; font-size: 10pt; text-align: left }

p { color: #800000; font-family: Arial, sans-serif; font-size: 10pt; text-align: left }


Columns A, D, F, G, H 1 mark

Search Supplier = Maxell 2 marks

Search Sales >=20 AND Price< 100 2 marks

Colour all correct 1 mark

Font all correct 1 mark

Size all correct 1 mark

correct units 1 mark

Alignment all correct 1 mark

h3 bold 1 mark




© UCLES 2007


Top left Last edited by & NAME & No’s 1 mark

in style h4 1 mark

style h1 From stylesheet 100% correct 1 mark




Merge rows 2 & 3 in 2nd

col 1 mark








Image Correct position & aspect ratio 1 mark


Full width of table cell

Menu Contains N7Menu.TXT in style h2 1 mark




© UCLES 2007

<HTML>

<HEAD>

<TITLE>Homepage</TITLE>


</HEAD>

<BODY>

<h4>Last edited by A.N.Other, Candidate 9999, Centre number ZZ999<h4>

<h1>Peripherals and Consumables</h1>

<TABLE cellSpacing="2" cellPadding="10" width="100%" border=2>

<TR>

<TD colspan="2"><h2>We stock a wide range of computer peripherals, accessories and

consumables.</h2></TD>

</TR>

<TR>

<TD><p>Peripherals include:</p>

<li>printers</li>

<li>scanners</li>

<li>network and WIFI,</li>

<p>and consumables like:</p>

<li>cartridges</li>

<li>specialist paper</li>

<li>Blank CDs and DVDs.</li></TD>

<TD rowspan="2"><img src="n7cart.jpg" height="200"></TD>

</TR>

<TR>

<TD><h3>You can contact us in many ways.</h3></TD>

</TR>

<TR>

<TD colspan="2"><h4>Through our website on-line - use our order form. By post - order our

catalogue and complete the order form. By phone or fax - all contact details on this website. You can

order our catalogue for a full listing of our services.</h4></TD>

</TR>

</TABLE>

<TABLE cellSpacing="2" cellPadding="10" width="600" border="2">

<TBODY>

<TR>

<TD><h2>Home Page</h2></TD>

<TD><h2>Products</h2></TD>

<TD><h2><a href="N7OFFERS.htm" target="_external">Special Offers</a></h2></TD>

<TD><h2>Order Form</h2></TD>

</TR>

</TBODY>

</TABLE>

</BODY>

</HTML>



Border 2 1 mark

Width 100% 1 mark

Image Height = “200” 1 mark

Hyperlink Correct target window 1 mark




Width “600” 1 mark

Border = 2 1 mark




© UCLES 2007

<html>

<head>

<title>Special Offers Page</title>

<link rel="stylesheet" type ="text/css" href="styles.css">

</head>

<body>

<p>Last updated by A.N.Other, Candidate 9999, Centre ZZ999</p>

<h1>This weeks special offers!</h1>


<tr>


<h4><b>On writeable and rewritable media</b></h4>

<p>Each listed is a 10 pack:</p>

<li>CD-R Maxell £2.79</li>

<li>CD-R Sony £2.99</li>

<li>CD-RW Imation £4.49</li>

<li>DVD-R Maxell £7.99</li>


Top left NAME & No’s 1 mark

Image In this cell 1 mark

Image Replaced text 1 mark










demonstrated.


examination.





© UCLES 2008 Page 2 of 14 [Turn Over

Code Rate

C 1.1

I 3

P 1.6

Department Dcode Number Total Duration

=VLOOKUP(B7, J8code'!$A$2:$B$13,2) MD =COUNTIF($B$16:$B$89,B7) =SUMIF($B$16:$B$89,B7,$D$16:$D$89)

=VLOOKUP(B8,J8code'!$A$2:$B$13,2) AC =COUNTIF($B$16:$B$89,B8) =SUMIF($B$16:$B$89,B8,$D$16:$D$89)

=VLOOKUP(B9,J8code'!$A$2:$B$13,2) PR =COUNTIF($B$16:$B$89,B9) =SUMIF($B$16:$B$89,B9,$D$16:$D$89)

=VLOOKUP(B10,J8code'!$A$2:$B$13,2) SA =COUNTIF($B$16:$B$89,B10) =SUMIF($B$16:$B$89,B10,$D$16:$D$89)

=VLOOKUP(B11,J8code'!$A$2:$B$13,2) HR =COUNTIF($B$16:$B$89,B11) =SUMIF($B$16:$B$89,B11,$D$16:$D$89)

=VLOOKUP(B12,J8code'!$A$2:$B$13,2) PU =COUNTIF($B$16:$B$89,B12) =SUMIF($B$16:$B$89,B12,$D$16:$D$89)

=VLOOKUP(B13,J8code'!$A$2:$B$13,2) MA =COUNTIF($B$16:$B$89,B13) =SUMIF($B$16:$B$89,B13,$D$16:$D$89)

Date Dcode Code Duration Units

39450 HR P 321 =IF(C16="C",D16*Cheap,IF(C16="I",D16*Intl,IF(C16="P",D16*Peak,0)))

39450 HR I 334 =IF(C17="C",D17*Cheap,IF(C17="I",D17*Intl,IF(C17="P",D17*Peak,0)))


39450 PU C 586 =IF(C19="C",D19*Cheap,IF(C19="I",D19*Intl,IF(C19="P",D19*Peak,0)))



39450 MD C 430 =IF(C22="C",D22*Cheap,IF(C22="I",D22*Intl,IF(C22="P",D22*Peak,0)))

39450 MD P 359 =IF(C23="C",D23*Cheap,IF(C23="I",D23*Intl,IF(C23="P",D23*Peak,0)))



39450 SA P 878 =IF(C26="C",D26*Cheap,IF(C26="I",D26*Intl,IF(C26="P",D26*Peak,0)))


39450 SA C 302 =IF(C28="C",D28*Cheap,IF(C28="I",D28*Intl,IF(C28="P",D28*Peak,0)))


39450 MD I 352 =IF(C30="C",D30*Cheap,IF(C30="I",D30*Intl,IF(C30="P",D30*Peak,0)))





39450 RT P 390 =IF(C35="C",D35*Cheap,IF(C35="I",D35*Intl,IF(C35="P",D35*Peak,0)))

39450 RT C 326 =IF(C36="C",D36*Cheap,IF(C36="I",D36*Intl,IF(C36="P",D36*Peak,0)))


Department Lookup used 1 mark


Correct range & return column 1 mark

Header Name, candidate no, Centre no 1 mark Rate Data entry 100% 3 marks

COUNTIF Correct function that can

be replicated 1 mark

Correct range

(accept named range) 1 mark

Correct reference 1 mark

SUMIF Correct function 1 mark

Correct compare range 1 mark


Correct calculate range 1 mark





39450 MA C 352 =IF(C40="C",D40*Cheap,IF(C40="I",D40*Intl,IF(C40="P",D40*Peak,0)))


39451 MA P 388 =IF(C42="C",D42*Cheap,IF(C42="I",D42*Intl,IF(C42="P",D42*Peak,0)))





39451 PR P 249 =IF(C47="C",D47*Cheap,IF(C47="I",D47*Intl,IF(C47="P",D47*Peak,0)))



39451 PU P 324 =IF(C50="C",D50*Cheap,IF(C50="I",D50*Intl,IF(C50="P",D50*Peak,0)))











39451 HR C 361 =IF(C61="C",D61*Cheap,IF(C61="I",D61*Intl,IF(C61="P",D61*Peak,0)))








39451 SA I 359 =IF(C69="C",D69*Cheap,IF(C69="I",D69*Intl,IF(C69="P",D69*Peak,0)))


39451 AC P 304 =IF(C71="C",D71*Cheap,IF(C71="I",D71*Intl,IF(C71="P",D71*Peak,0)))

39451 AC C 264 =IF(C72="C",D72*Cheap,IF(C72="I",D72*Intl,IF(C72="P",D72*Peak,0)))
















39452 PR C 366 =IF(C86="C",D86*Cheap,IF(C86="I",D86*Intl,IF(C86="P",D86*Peak,0)))




Units Nested IF 1 mark


Correct function (3 parts) 3 marks

Returns Zero if not CIP 1 mark


Orientation Landscape & fit to page 1 mark



Code Rate

C 1.1

I 3.0

P 1.6


Managing Director MD 16 8467

Accounts AC 10 5037

Production PR 7 3476

Sales SA 11 4482

Human Resources HR 11 5224

Purchasing PU 5 2655

Maintenance MA 9 4016


03/01/2008 HR P 321 514

03/01/2008 HR I 334 1002

03/01/2008 HR P 332 531

03/01/2008 PU C 586 645

03/01/2008 HR P 1462 2339

03/01/2008 HR P 400 640

03/01/2008 MD C 430 473

03/01/2008 MD P 359 574

03/01/2008 MD P 376 602

03/01/2008 MD P 168 269

03/01/2008 SA P 878 1405

03/01/2008 SA P 289 462

03/01/2008 SA C 302 332

03/01/2008 MD P 438 701

03/01/2008 MD I 352 1056

03/01/2008 MD P 798 1277

03/01/2008 MD I 769 2307

03/01/2008 MD I 937 2811

03/01/2008 MD P 313 501

03/01/2008 RT P 390 624

03/01/2008 RT C 326 359

03/01/2008 RT C 880 968

03/01/2008 RT P 820 1312

03/01/2008 RT P 333 533

03/01/2008 MA C 352 387

03/01/2008 MA C 806 887

04/01/2008 MA P 388 621

04/01/2008 MA P 488 781

04/01/2008 MA C 302 332

04/01/2008 MA P 351 562

04/01/2008 MA P 527 843

04/01/2008 PR P 249 398

04/01/2008 MD P 942 1507

04/01/2008 MD P 776 1242

04/01/2008 PU P 324 518

04/01/2008 PU P 354 566

04/01/2008 MD P 824 1318

04/01/2008 MD C 426 469

Rate 1dp 1 mark

Row 1 Centre 1 mark

Bold 1 mark

Cells A2-A4 Right aligned 1 mark

Row 6 & 15 Centre & bold 1 mark

Orientation Portrait 1 mark

Units 0 dp 1 mark




04/01/2008 HR P 739 1182

04/01/2008 HR P 300 480

04/01/2008 MD P 263 421

04/01/2008 PR P 168 269

04/01/2008 PR P 807 1291

04/01/2008 PR P 821 1314

04/01/2008 PR P 796 1274

04/01/2008 HR C 361 397

04/01/2008 HR P 351 562

04/01/2008 HR C 282 310

04/01/2008 HR P 342 547

04/01/2008 SA P 711 1138

04/01/2008 SA P 398 637

04/01/2008 SA C 276 304

04/01/2008 SA P 297 475

04/01/2008 SA I 359 1077

04/01/2008 PU P 558 893

04/01/2008 AC P 304 486

04/01/2008 AC C 264 290

05/01/2008 AC P 936 1498

05/01/2008 AC C 512 563

05/01/2008 AC C 310 341

05/01/2008 AC P 368 589

05/01/2008 AC P 837 1339

05/01/2008 AC C 854 939

05/01/2008 AC P 230 368

05/01/2008 AC P 422 675

05/01/2008 MD P 296 474

05/01/2008 SA C 219 241

05/01/2008 SA P 368 589

05/01/2008 SA I 385 1155

05/01/2008 PR P 269 430

05/01/2008 PR C 366 403

05/01/2008 MA P 354 566

05/01/2008 MA P 448 717

05/01/2008 PU P 833 1333


Step 18

Date Dcode Code Units

03/01/2008 HR I 1002

03/01/2008 MD I 1056

03/01/2008 MD I 2307

03/01/2008 MD I 2811

04/01/2008 SA I 1077

05/01/2008 SA I 1155


Hidden Column D 1 mark

Search Code = I 2 marks



Step 19

Date Dcode Units

04/01/2008 PU 518

04/01/2008 PU 566

04/01/2008 SA 1138

04/01/2008 SA 637

04/01/2008 SA 304

04/01/2008 SA 475

04/01/2008 SA 1077

04/01/2008 PU 893


Step 20

Total Duration By Department

0

1000

2000

3000

4000

5000

6000

7000

8000

9000

Managing D

irecto

r

Accounts

Pro

duction

Sales

Human R

esources

Purc

hasing

Mainte

nance

Search Date = 04/01/2008 AND DCode = PU or SA 2 marks

Hidden Rows 1-14 and Columns C & D 1 mark

Chart Vertical bars 1 mark

Correct data 1 mark

Title 100% correct 1 mark

Labels Cat axis fully visible 1 mark

Legend No legend 1 mark



STYLESHEET

h1 { color: #000000; font-family: ”Times New Roman”, serif; font-size: 20px; text-align: Center;

font-weight: bold }

h2 { color: #0000FF; font-family: ”Times New Roman”, serif; font-size: 18px; text-align: Center;

font-weight: bold }

h3 { color: #000000; font-family: ”Times New Roman”, serif; font-size: 16px; text-align: left }

li { color: #000000; font-family: Arial, sans-serif; font-size: 14px; text-align: left }

p { color: #000066; font-family: Arial, sans-serif; font-size: 14px; text-align: left; font-style: italic }

Colour All correct 1 mark

Font All correct 1 mark

Size All correct 1 mark

Units correct 1 mark

Alignment All correct 1 mark

h1 & h2 Bold 1 mark

p Italic 1 mark


<HTML>

<HEAD>

<TITLE>Sample</TITLE>

<link rel="stylesheet" type ="text/css" href="J8styles.css">

</HEAD>

<BODY>

<a name=TOP></a>

<h3>Last edited by Candidate name, centre number, candidate number<h3>

<h1>Sample Website for client X</h1>

<TABLE cellSpacing="6" cellPadding="6" width="100%" border=”4”>

<TR>

<TD colspan="3"><h3>Our Vision is to promote your business through the development and hosting of a web

presence.</h3></TD>

</TR>

<TR>

<TD><img src="J8PROD.jpg"></TD>

Top left Last edited by & Name & No’s in style h3 1 mark




Merge rows 2,3 & 4 in 3rd

col 1 mark


Heading in style h1& 100% correct 1 mark

Image Placed in correct cell 1 mark

Centre aligned 1 mark

Menu Contains J8MENU.HTM in h2 1 mark

External stylesheet attached

With relative references 1 mark





Width 100% 1 mark

Border 4 1 mark

Style h2 All 3 cells 1 mark



Anchor Set to TOP 1 mark

Image J8PROD.JPG in cell B 1 mark

J8HIST.JPG in cell D 1 mark

J8TEL.JPG in cell F 1 mark

Style h2 All 3 cells 1 mark Style h2 All 3 cells 1 mark


<TD><h2>Our Products</h2></TD>

<TD rowspan="3"><p>Each section of this table can be used to convey information, or to provide a link to

other areas.</p>

<p> For example there may be:</P>

<li>your flagship products</li>

<li>special offers</li>

<li>price reductions</li>

<p> in order to entice customers to buy your products. Images, text, animations, movie 'clips' and sounds

can be included on the web site.</p></TD>

</TR>

<TR>

<TD><img src="J8HIST.jpg"></TD>

<TD><h2><a href="J8COHIST.htm" target="_history">Company History</a></h2></TD>

</TR>

<TR>

<TD><img src="J8TEL.jpg"></TD>

<TD><h2>Contact Us</h2></TD>

</TR>

<TR>

<TD colspan="3" align="center"><img src="J8MOVIE.jpg" width="400" height="50"></TD>

</TR>

</TABLE>

<BR>


<TBODY>

<TR>

<TD><h2><a href="#TOP">Home</a></h2></TD>


<TD><h2><a href="J8COHIST.htm" target="_history">History </a></h2></TD>


</TR>

</TBODY>

</TABLE>

</HTML>


Height = “50” 1 mark

Hyperlink Correct target window

Relative reference 1 mark



Width 100% 1 mark

Border 2 1 mark



Hyperlink Correct anchor



<html>

<head>

<title>Company History</title>


</head>

<body>

<h3>Last updated by Candidate name, candidate number and centre number</h3>

<h1>Company History</h1>


<tr>


<h3><b>This great company was founded in 1879 by Bernard House.</b></h3>

<p>Although it has a great company history, we have adapted to every technological change presented to

them. Their use of ICT is unsurpassed, even the web pages can contain data drawn from a wide variety of

sources like the electronic drawing board.</p>

<h3>Here is an example of our versatility:</h3>

</td>

<td>

<img src="j8image.gif" width = "300" />

</td>

</tr>

Image Width 300 (height 310 +-2)

Maintain aspect ratio 1 mark



Top left Name & No’s replaced ‘Candidate name’ 1 mark



</table>


<TBODY>

<TR>

<TD><a href="SAMPLE.htm">Home</a></TD>

<TD>Products</TD>

<TD>History</TD>

<TD>Contact Us</TD>

</TR>

</TBODY>

</TABLE>

</body>

</html>

Home Correct Hyperlink 1 mark

Vertical line, green 6 point 1 mark

Diagonal line, green 6 point 1 mark

Clip art Pen or Pencil 1 mark

Horizontal line, green 6 point 1 mark

Automatic numbering corner 1 mark Between lines Name & No’s 1 mark

Heading 100% correct, black 48 pt sans-serif, not overlapping

1 mark



Text 24 point blue, left aligned, serif 1 mark


© UCLES 2008

Chart From step 20, placed 1 mark

No overlap 1 mark




© UCLES 2007

<li>DVD-RW Sony £8.99</li>

<h3>We offer many more exciting deals including daily SPECIAL OFFERS</h3>

<p>Please ring our sales staff for details</p>

</td>

<td>

<img src="n7media.jpg" width = "300" />

</td>

</tr>

</table>

<p>Click on the logo for the homepage</p>

<a href="homepage.htm"><img src = "n7icon.gif" width = "40" height = "42"><a>

</body>

</html>

Image Width 300 1 mark

Image Gif format, Width 40 & Height 42 1 mark

Correct Hyperlink 1 mark




© UCLES 2007

Presenter notes on all slides 1 mark

100 % Correct 1 mark

right place 1 mark

Heading Black, centre aligned, 48 point 1 mark

Subheading Dark red, left aligned, 32 point 1 mark


Logo Peripheral, bottom right 1 mark

Page numbering Bottom left & automated 1 mark

Name and date Top right 1 mark

All 3 Not overlapping text or object 1 mark




© UCLES 2007


Top Bullets Red, left aligned, 24 point, consistent 1 mark

Subheading Dark red, left aligned 32 point 1 mark

2nd

Bullets Red, left aligned, 24 point, consistent 1 mark

Image N7PRINT,jpg on right side 1 mark

No overlap 1 mark

Line 5 pt, red 1 mark

vertical 1 mark




© UCLES 2007


Bullets Red, left aligned, 24 point, consistent 1 mark

Consistent with slide 2 1 mark

Chart Correct chart 1 mark

Type names visible 1 mark

Type & Total Sales labels 1 mark

Left side & bullets right side 1 mark




© UCLES 2007


3 / slide 1 mark




© UCLES 2007


Transition slides 2 and 3 2 marks










demonstrated.


examination.






Code Rate

C 1.1

I 3

P 1.6


=VLOOKUP(B7, J8code'!$A$2:$B$13,2) MD =COUNTIF($B$16:$B$89,B7) =SUMIF($B$16:$B$89,B7,$D$16:$D$89)

=VLOOKUP(B8,J8code'!$A$2:$B$13,2) AC =COUNTIF($B$16:$B$89,B8) =SUMIF($B$16:$B$89,B8,$D$16:$D$89)

=VLOOKUP(B9,J8code'!$A$2:$B$13,2) PR =COUNTIF($B$16:$B$89,B9) =SUMIF($B$16:$B$89,B9,$D$16:$D$89)

=VLOOKUP(B10,J8code'!$A$2:$B$13,2) SA =COUNTIF($B$16:$B$89,B10) =SUMIF($B$16:$B$89,B10,$D$16:$D$89)

=VLOOKUP(B11,J8code'!$A$2:$B$13,2) HR =COUNTIF($B$16:$B$89,B11) =SUMIF($B$16:$B$89,B11,$D$16:$D$89)

=VLOOKUP(B12,J8code'!$A$2:$B$13,2) PU =COUNTIF($B$16:$B$89,B12) =SUMIF($B$16:$B$89,B12,$D$16:$D$89)

=VLOOKUP(B13,J8code'!$A$2:$B$13,2) MA =COUNTIF($B$16:$B$89,B13) =SUMIF($B$16:$B$89,B13,$D$16:$D$89)



39450 HR I 334 =IF(C17="C",D17*Cheap,IF(C17="I",D17*Intl,IF(C17="P",D17*Peak,0)))


39450 PU C 586 =IF(C19="C",D19*Cheap,IF(C19="I",D19*Intl,IF(C19="P",D19*Peak,0)))



















Department Lookup used 1 mark



Header Name, candidate no, Centre no 1 mark Rate Data entry 100% 3 marks

COUNTIF Correct function that can

be replicated 1 mark

Correct range

(accept named range) 1 mark


SUMIF Correct function 1 mark

















39452 PR C 366 =IF(C86="C",D86*Cheap,IF(C86="I",D86*Intl,IF(C86="P",D86*Peak,0)))




Units Nested IF 1 mark


Correct function (3 parts) 3 marks

Returns Zero if not CIP 1 mark


Orientation Landscape & fit to page 1 mark



Code Rate

C 1.1

I 3.0

P 1.6


Managing Director MD 16 8467

Accounts AC 10 5037

Production PR 7 3476

Sales SA 11 4482

Human Resources HR 11 5224

Purchasing PU 5 2655

Maintenance MA 9 4016


03/01/2008 HR P 321 514

03/01/2008 HR I 334 1002

03/01/2008 HR P 332 531

03/01/2008 PU C 586 645

03/01/2008 HR P 1462 2339

03/01/2008 HR P 400 640

03/01/2008 MD C 430 473

03/01/2008 MD P 359 574

03/01/2008 MD P 376 602

03/01/2008 MD P 168 269

03/01/2008 SA P 878 1405

03/01/2008 SA P 289 462

03/01/2008 SA C 302 332

03/01/2008 MD P 438 701

03/01/2008 MD I 352 1056

03/01/2008 MD P 798 1277

03/01/2008 MD I 769 2307

03/01/2008 MD I 937 2811

03/01/2008 MD P 313 501

03/01/2008 RT P 390 624

03/01/2008 RT C 326 359

03/01/2008 RT C 880 968

03/01/2008 RT P 820 1312

03/01/2008 RT P 333 533

03/01/2008 MA C 352 387

03/01/2008 MA C 806 887

04/01/2008 MA P 388 621

04/01/2008 MA P 488 781

04/01/2008 MA C 302 332

04/01/2008 MA P 351 562

04/01/2008 MA P 527 843

04/01/2008 PR P 249 398

04/01/2008 MD P 942 1507

04/01/2008 MD P 776 1242

04/01/2008 PU P 324 518

04/01/2008 PU P 354 566

04/01/2008 MD P 824 1318

04/01/2008 MD C 426 469

Rate 1dp 1 mark

Row 1 Centre 1 mark

Bold 1 mark

Cells A2-A4 Right aligned 1 mark



Units 0 dp 1 mark




04/01/2008 HR P 739 1182

04/01/2008 HR P 300 480

04/01/2008 MD P 263 421

04/01/2008 PR P 168 269

04/01/2008 PR P 807 1291

04/01/2008 PR P 821 1314

04/01/2008 PR P 796 1274

04/01/2008 HR C 361 397

04/01/2008 HR P 351 562

04/01/2008 HR C 282 310

04/01/2008 HR P 342 547

04/01/2008 SA P 711 1138

04/01/2008 SA P 398 637

04/01/2008 SA C 276 304

04/01/2008 SA P 297 475

04/01/2008 SA I 359 1077

04/01/2008 PU P 558 893

04/01/2008 AC P 304 486

04/01/2008 AC C 264 290

05/01/2008 AC P 936 1498

05/01/2008 AC C 512 563

05/01/2008 AC C 310 341

05/01/2008 AC P 368 589

05/01/2008 AC P 837 1339

05/01/2008 AC C 854 939

05/01/2008 AC P 230 368

05/01/2008 AC P 422 675

05/01/2008 MD P 296 474

05/01/2008 SA C 219 241

05/01/2008 SA P 368 589

05/01/2008 SA I 385 1155

05/01/2008 PR P 269 430

05/01/2008 PR C 366 403

05/01/2008 MA P 354 566

05/01/2008 MA P 448 717

05/01/2008 PU P 833 1333


Step 18

Date Dcode Code Units

03/01/2008 HR I 1002

03/01/2008 MD I 1056

03/01/2008 MD I 2307

03/01/2008 MD I 2811

04/01/2008 SA I 1077

05/01/2008 SA I 1155


Hidden Column D 1 mark

Search Code = I 2 marks



Step 19

Date Dcode Units

04/01/2008 PU 518

04/01/2008 PU 566

04/01/2008 SA 1138

04/01/2008 SA 637

04/01/2008 SA 304

04/01/2008 SA 475

04/01/2008 SA 1077

04/01/2008 PU 893


Step 20

Total Duration By Department

0

1000

2000

3000

4000

5000

6000

7000

8000

9000

Managing D

irecto

r

Accounts

Pro

duction

Sales

Human R

esources

Purc

hasing

Mainte

nance

Search Date = 04/01/2008 AND DCode = PU or SA 2 marks

Hidden Rows 1-14 and Columns C & D 1 mark

Chart Vertical bars 1 mark

Correct data 1 mark


Labels Cat axis fully visible 1 mark

Legend No legend 1 mark



STYLESHEET

h1 { color: #000000; font-family: ”Times New Roman”, serif; font-size: 20px; text-align: Center;

font-weight: bold }

h2 { color: #0000FF; font-family: ”Times New Roman”, serif; font-size: 18px; text-align: Center;

font-weight: bold }

h3 { color: #000000; font-family: ”Times New Roman”, serif; font-size: 16px; text-align: left }


p { color: #000066; font-family: Arial, sans-serif; font-size: 14px; text-align: left; font-style: italic }

Colour All correct 1 mark

Font All correct 1 mark

Size All correct 1 mark

Units correct 1 mark

Alignment All correct 1 mark

h1 & h2 Bold 1 mark

p Italic 1 mark


<HTML>

<HEAD>

<TITLE>Sample</TITLE>

<link rel="stylesheet" type ="text/css" href="J8styles.css">

</HEAD>

<BODY>

<a name=TOP></a>

<h3>Last edited by Candidate name, centre number, candidate number<h3>

<h1>Sample Website for client X</h1>


<TR>

<TD colspan="3"><h3>Our Vision is to promote your business through the development and hosting of a web

presence.</h3></TD>

</TR>

<TR>

<TD><img src="J8PROD.jpg"></TD>

Top left Last edited by & Name & No’s in style h3 1 mark




Merge rows 2,3 & 4 in 3rd

col 1 mark


Heading in style h1& 100% correct 1 mark

Image Placed in correct cell 1 mark


Menu Contains J8MENU.HTM in h2 1 mark


With relative references 1 mark





Width 100% 1 mark

Border 4 1 mark

Style h2 All 3 cells 1 mark



Anchor Set to TOP 1 mark

Image J8PROD.JPG in cell B 1 mark

J8HIST.JPG in cell D 1 mark

J8TEL.JPG in cell F 1 mark

Style h2 All 3 cells 1 mark Style h2 All 3 cells 1 mark


<TD><h2>Our Products</h2></TD>

<TD rowspan="3"><p>Each section of this table can be used to convey information, or to provide a link to

other areas.</p>

<p> For example there may be:</P>

<li>your flagship products</li>

<li>special offers</li>

<li>price reductions</li>

<p> in order to entice customers to buy your products. Images, text, animations, movie 'clips' and sounds

can be included on the web site.</p></TD>

</TR>

<TR>

<TD><img src="J8HIST.jpg"></TD>

<TD><h2><a href="J8COHIST.htm" target="_history">Company History</a></h2></TD>

</TR>

<TR>

<TD><img src="J8TEL.jpg"></TD>


</TR>

<TR>

<TD colspan="3" align="center"><img src="J8MOVIE.jpg" width="400" height="50"></TD>

</TR>

</TABLE>

<BR>


<TBODY>

<TR>

<TD><h2><a href="#TOP">Home</a></h2></TD>


<TD><h2><a href="J8COHIST.htm" target="_history">History </a></h2></TD>


</TR>

</TBODY>

</TABLE>

</HTML>


Height = “50” 1 mark





Width 100% 1 mark

Border 2 1 mark



Hyperlink Correct anchor



<html>

<head>

<title>Company History</title>


</head>

<body>

<h3>Last updated by Candidate name, candidate number and centre number</h3>

<h1>Company History</h1>


<tr>


<h3><b>This great company was founded in 1879 by Bernard House.</b></h3>

<p>Although it has a great company history, we have adapted to every technological change presented to

them. Their use of ICT is unsurpassed, even the web pages can contain data drawn from a wide variety of

sources like the electronic drawing board.</p>

<h3>Here is an example of our versatility:</h3>

</td>

<td>

<img src="j8image.gif" width = "300" />

</td>

</tr>

Image Width 300 (height 310 +-2)

Maintain aspect ratio 1 mark



Top left Name & No’s replaced ‘Candidate name’ 1 mark



</table>


<TBODY>

<TR>

<TD><a href="SAMPLE.htm">Home</a></TD>

<TD>Products</TD>

<TD>History</TD>

<TD>Contact Us</TD>

</TR>

</TBODY>

</TABLE>

</body>

</html>

Home Correct Hyperlink 1 mark

Vertical line, green 6 point 1 mark

Diagonal line, green 6 point 1 mark

Clip art Pen or Pencil 1 mark


Automatic numbering corner 1 mark Between lines Name & No’s 1 mark

Heading 100% correct, black 48 pt sans-serif, not overlapping

1 mark


© UCLES 2008

Chart From step 20, placed 1 mark

No overlap 1 mark










demonstrated.


examination.




syllabuses.



© UCLES 2008

Heading Red, left aligned, 60 pt 1 mark

100% correct 1 mark

Subheading Red, centre aligned, 36 pt 1 mark

100% correct 1 mark

Presenter notes 100% correct 1 mark

Right place 1 mark

Master slide – CHECK CONSISTENCY

Background Pale grey 1 mark

Between ! and " 1 mark

Red stripe Vertical (edge of grey) 1 mark

Two horizontal 1 mark

6 point lines 1 mark

Logo Telephone 1 mark

Correct place 1 mark

Slide numbering Bottom right & automated, on all slides 1 mark

Name, cand no, Centre no Bottom left black, 12 pt, sans-serif 1 mark

Telephone Analysis text Black 44 pt, sans-serif, left aligned 1 mark

Position & 100% correct 1 mark

Master slide items Not overlapping any object 1 mark



© UCLES 2008


Subheading Red, centre aligned, 36 pt 1 mark

100% correct 1 mark

Left bullets Black, left aligned, 24 pt, consistent 1 mark

100% correct 1 mark

Right bullets Black, left aligned, 24 pt, consistent 1 mark

100% correct 1 mark



© UCLES 2008


Chart Correct chart type & 4 segments 1 mark

Call type labels correct 1 mark

% value labels correct 1 mark

Centre of slide space & enlarged with no distortion 1 mark

No legend 1 mark



© UCLES 2008

Subheading Red, centre aligned, 36 pt, no bullet 1 mark

100% correct 1 mark

Bullets Black, left aligned, 24 pt, consistent 1 mark

100% correct & in correct place 1 mark

Image Telephone 1 mark




© UCLES 2008


3 slides / page 1 mark



© UCLES 2008

Transition Between all slides 1 mark

Animation Bullets only (1–6 and 7–11) 1 mark



© UCLES 2008

STYLESHEET

h1 { color: #FF0000; font-family: “Times New Roman”, serif; font-size: 20px;

text-align: Center; font-style: italic; font-weight: bold }

h2 { color: #FF0000; font-family: “Times New Roman”, serif; font-size: 18px;

text-align: Center }

h3 { color: #000000; font-family: “Times New Roman”, serif; font-size: 16px;

text-align: left }


p { color: #000066; font-family: Arial, sans-serif; font-size: 14px; text-align: left }

h1 & h2 Red 1 mark

p Dark blue 1 mark

h1, h2, h3 TNR primary then serif 1 mark

li, p Arial primary then sans-serif 1 mark

h1 & h2 Centre aligned 1 mark

h1 Bold 1 mark

h1 Italic 1 mark

Bottom left Last updated by & name & no’s 1 mark

Style h3 1 mark

Text 100% correct 1 mark


Style p From stylesheet 1 mark Style p From stylesheet 1 mark Style p From stylesheet 1 mark Style p From stylesheet 1 mark Row Right aligned 1 mark

Correct images 5 marks







Images Correct 5 marks

Browser view fully visible

1 mark



© UCLES 2008

<html>

<head>

<title>Hothouse Design</title>

<link rel="stylesheet" type="text/css" href="n8style1.css">

</head>

<body>

<h1>Hothouse Design Ltd</h1>

<table border="5" cellpadding="20" cellspacing="5" width="100%" height="300px">

<tr bgcolor="#000000" align="center">

<td> <img src="N8about.gif">

</td>

<td> <img src="N8what.gif">

</td>

<td> <img src="N8client.gif">

</td>

<td> <img src="N8work.gif">

</td>

<td> <a href="N8conta1.htm" target="_contact"><img src="N8contac.gif"></a>

</td>

</tr>

<tr align="right">

<td> About us

</td>

<td> What we do

</td>

<td> Our clients

</td>

<td> Work with us

</td>

<td> <a href="N8conta1.htm" target="_contact"> Contact us</a>

</td>

</tr>

</table>

<h3>Last updated by [candidate name], [centre number], [candidate number]</h3>

</body>

</html>

Row Right aligned 1 mark

Row Centre aligned 2 marks

Background colour black 1 mark

Hyperlink Correct 1 mark

Window Correct 1 mark

Hyperlink Correct 1 mark

Window Correct 1 mark



Width 100% 1 mark

Height 300 1 mark

Border 5 1 mark

Correct external stylesheet attached 1 mark



© UCLES 2008

<html>

<head>

<title>Contact us</title>

<link rel="stylesheet" type="text/css" href="n8style1.css">

</head>

<body>

<h1>The Hothouse Design Group has offices in the following locations:</h1>

<h3>Hothouse Design Head Office</h3>

<p>Hothouse Design (UK) Ltd

<br>1 Hills Road, Cambridge, CB1 2EU, England</p>

<h3>Hothouse Design International Offices</h3>

<p>Hothouse Design

<br>Buenos Aires, Argentina</p>

<p>Hothouse Design

<br>Helsinki, Finland</p>

<p>Hothouse Hellenic Ltd

<br>Athens, Greece</p>

<p>Hothouse Design (Asia Pacific)

<br>Singapore</p>

<p>Hothouse Design Inc.

<br>New York, USA

<p>Hothouse Design Australia

<br>Melbourne, Australia</p>

<h3>Last updated by [candidate name], [centre number], [candidate number]</h3>

</body>

</html>

Correct external stylesheet attached 1 mark

Bottom left Last updated by & name & no’s 1 mark

Style h3 1 mark




© UCLES 2008

Name SCode Total minutes

=VLOOKUP(B2,N8code.csv!$A$2:$B$13,2) GBA =SUMIF($B$11:$B$84,B2,$D$11:$D$84)

=VLOOKUP(B3,N8code.csv!$A$2:$B$13,2) GBR =SUMIF($B$11:$B$84,B3,$D$11:$D$84)

=VLOOKUP(B4,N8code.csv!$A$2:$B$13,2) LEX =SUMIF($B$11:$B$84,B4,$D$11:$D$84)

=VLOOKUP(B5,N8code.csv!$A$2:$B$13,2) MAR =SUMIF($B$11:$B$84,B5,$D$11:$D$84)

=VLOOKUP(B6,N8code.csv!$A$2:$B$13,2) RSP =SUMIF($B$11:$B$84,B6,$D$11:$D$84)

=VLOOKUP(B7,N8code.csv!$A$2:$B$13,2) SMO =SUMIF($B$11:$B$84,B7,$D$11:$D$84)

=VLOOKUP(B8,N8code.csv!$A$2:$B$13,2) VCR =SUMIF($B$11:$B$84,B8,$D$11:$D$84)

Date SCode Duration Minutes Seconds Length

39450 MAR 321 =INT(C11/60) =C11-(D11*60) =IF(D11<6,"Short",IF(D11<12,"Medium","Long"))

39450 LEX 334 =INT(C12/60) =C12-(D12*60) =IF(D12<6,"Short",IF(D12<12,"Medium","Long"))

39450 VCR 332 =INT(C13/60) =C13-(D13*60) =IF(D13<6,"Short",IF(D13<12,"Medium","Long"))

39450 SMO 586 =INT(C14/60) =C14-(D14*60) =IF(D14<6,"Short",IF(D14<12,"Medium","Long"))

39450 GBR 1462 =INT(C15/60) =C15-(D15*60) =IF(D15<6,"Short",IF(D15<12,"Medium","Long"))






39450 GBA 878 =INT(C21/60) =C21-(D21*60) =IF(D21<6,"Short",IF(D21<12,"Medium","Long"))




39450 RSP 352 =INT(C25/60) =C25-(D25*60) =IF(D25<6,"Short",IF(D25<12,"Medium","Long"))












Name Lookup used 1 mark



Header Name, candidate no, Centre no 1 mark

SUMIF Correct formulae 1 mark







© UCLES 2008












Length Nested IF 1 mark

Correct formulae 2 marks


Orientation Landscape & fit to 1 page width 1 mark

Minutes Cn/60 1 mark

Integer function 1 mark

Seconds Formula works 2 marks




© UCLES 2008

Name SCode Total minutes

G Barney GBA 92

G Brown GBR 83

L Exley LEX 116

M Arnott MAR 115

R Springett RSP 33

S Morris SMO 76

V Cresswell VCR 48


03/01/2008 MAR 321 5 21 Short

03/01/2008 LEX 334 5 34 Short

03/01/2008 VCR 332 5 32 Short

03/01/2008 SMO 586 9 46 Medium

03/01/2008 GBR 1462 24 22 Long

03/01/2008 GBR 400 6 40 Medium

03/01/2008 VCR 430 7 10 Medium

03/01/2008 SMO 359 5 59 Short

03/01/2008 MAR 376 6 16 Medium

03/01/2008 MAR 168 2 48 Short

03/01/2008 GBA 878 14 38 Long

03/01/2008 GBR 289 4 49 Short

03/01/2008 LEX 302 5 2 Short

03/01/2008 GBA 438 7 18 Medium

03/01/2008 RSP 352 5 52 Short

03/01/2008 GBA 798 13 18 Long

03/01/2008 LEX 769 12 49 Long

03/01/2008 GBA 937 15 37 Long

03/01/2008 LEX 313 5 13 Short

03/01/2008 MAR 390 6 30 Medium

03/01/2008 GBA 326 5 26 Short

03/01/2008 GBR 880 14 40 Long

03/01/2008 LEX 820 13 40 Long

03/01/2008 VCR 333 5 33 Short

03/01/2008 MAR 352 5 52 Short

03/01/2008 LEX 806 13 26 Long

04/01/2008 MAR 388 6 28 Medium

04/01/2008 SMO 488 8 8 Medium

04/01/2008 GBA 302 5 2 Short

04/01/2008 LEX 351 5 51 Short

04/01/2008 LEX 527 8 47 Medium

04/01/2008 MAR 249 4 9 Short

04/01/2008 SMO 942 15 42 Long

04/01/2008 MAR 776 12 56 Long

04/01/2008 MAR 324 5 24 Short

04/01/2008 SMO 354 5 54 Short

04/01/2008 LEX 824 13 44 Long

04/01/2008 LEX 426 7 6 Medium

04/01/2008 LEX 739 12 19 Long

04/01/2008 GBA 300 5 0 Short

04/01/2008 GBR 263 4 23 Short

Row 1 only Centre & bold 1 mark

Row 10 only Centre & bold 1 mark





© UCLES 2008

04/01/2008 MAR 168 2 48 Short

04/01/2008 VCR 807 13 27 Long

04/01/2008 MAR 821 13 41 Long

04/01/2008 MAR 796 13 16 Long

04/01/2008 VCR 361 6 1 Medium

04/01/2008 GBR 351 5 51 Short

04/01/2008 SMO 282 4 42 Short

04/01/2008 RSP 342 5 42 Short

04/01/2008 GBR 711 11 51 Medium

04/01/2008 SMO 398 6 38 Medium

04/01/2008 GBA 276 4 36 Short

04/01/2008 MAR 297 4 57 Short

04/01/2008 MAR 359 5 59 Short

04/01/2008 GBA 558 9 18 Medium

04/01/2008 GBA 304 5 4 Short

04/01/2008 SMO 264 4 24 Short

05/01/2008 GBR 936 15 36 Long

05/01/2008 LEX 512 8 32 Medium

05/01/2008 VCR 310 5 10 Short

05/01/2008 RSP 368 6 8 Medium

05/01/2008 MAR 837 13 57 Long

05/01/2008 SMO 854 14 14 Long

05/01/2008 GBA 230 3 50 Short

05/01/2008 VCR 422 7 2 Medium

05/01/2008 RSP 296 4 56 Short

05/01/2008 MAR 219 3 39 Short

05/01/2008 SMO 368 6 8 Medium

05/01/2008 MAR 385 6 25 Medium

05/01/2008 LEX 269 4 29 Short

05/01/2008 LEX 366 6 6 Medium

05/01/2008 MAR 354 5 54 Short

05/01/2008 GBA 448 7 28 Medium

05/01/2008 RSP 833 13 53 Long




© UCLES 2008

Step 18


03/01/2008 GBR 1462 24 22 Long

03/01/2008 GBA 878 14 38 Long

03/01/2008 GBA 798 13 18 Long

03/01/2008 LEX 769 12 49 Long

03/01/2008 GBA 937 15 37 Long

03/01/2008 GBR 880 14 40 Long

03/01/2008 LEX 820 13 40 Long

03/01/2008 LEX 806 13 26 Long

04/01/2008 SMO 942 15 42 Long

04/01/2008 MAR 776 12 56 Long

04/01/2008 LEX 824 13 44 Long

04/01/2008 LEX 739 12 19 Long

04/01/2008 VCR 807 13 27 Long

04/01/2008 MAR 821 13 41 Long

04/01/2008 MAR 796 13 16 Long

05/01/2008 GBR 936 15 36 Long

05/01/2008 MAR 837 13 57 Long

05/01/2008 SMO 854 14 14 Long

05/01/2008 RSP 833 13 53 Long



04/01/2008 VCR 807 13 27 Long

05/01/2008 RSP 833 13 53 Long

Search Length = Long 2 marks

Search Length = Long and SCode = VCR OR RSP 2 marks



for the guidance of teachers

0417 INFORMATION AND COMMUNICATION

TECHNOLOGY




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.


examination.




Mark Scheme: Teachers’ version Syllabus Paper


© UCLES 2009

<HTML>

<HEAD>

<TITLE>Supa Scuba</TITLE>

<link rel="stylesheet" type ="text/css" href="J9style1.css">

</HEAD>

<BODY>

<a name="TOP"></a>

<h5>Last edited by Candidate name, centre number, candidate number</h5>

<TABLE cellspacing="2" cellpadding="2" width="100%" border="2">

<TR align="center" valign="center">

<TD><img src ="J9LOGO.jpg"></TD>

<TD colspan = "2"> <h1>Supa Scuba</h1></TD>

</TR>


<TD colspan = "3"> <h3>With over 70% of the world covered in water, you may be missing opportunities

to see some of the world's most fascinating sights. See vibrant creatures like fish, shrimps, and an array of

underwater flora like spectacular corals. Look to us for adventures in the deep, see a different perspective

on the world.</h3></TD>

</TR>


<TD rowspan = "4"> <img src="J9SUNSET.JPG" width="183" height="320"></TD>

<TD><h4><a href="J9DIVE.HTM" target="_scubadive">Amazing fish</a></h4></TD>

<TD><a href="J9DIVE.HTM" target="_scubadive"><img src="J9SHOAL.JPG"></a></TD>

</TR>


<TD><h4>Colours beyond comprehension</h4></TD>

<TD><img src="J9FISH.JPG"></TD>

</TR>


<TD><h4>Dolphin experiences, on the boat and in the water</h4></TD>

<TD><img src="J9DOLPHI.JPG"></TD>

</TR>

</TABLE>

<p><a href="#Top">Click Here</a> to return to the top of the page.</p>

</HTML>

Images Correct cells 5 marks

Correct stylesheet attached 1 mark



Width 100% 1 mark

Border 2 1 mark

Anchor Top 1 mark

Hyperlink Click Here 1 mark

Returns to Top 1 mark

J9SUNSET.JPG Width 183 1 mark

Height 320 1 mark

Target _scubadive 1 mark

to j9dive.htm 1 mark

Target _scubadive 1 mark

to j9dive.htm 1 mark

Top right Last edited by & name & No’s 1 mark

style h5 1 mark



© UCLES 2009

h1 { color: #0000AA; font-family: Arial, sans-serif; font-size: 48pt; text-align: center }

h2 { color: #0000AA; font-family: Arial, sans-serif; font-size: 15pt; text-align: left }

h3 { color: #0000FF; font-family: Arial, sans-serif; font-size: 12pt; text-align: center }

h4 { color: #000000; font-family: Arial, sans-serif; font-size: 12pt; text-align: center }

h5 { color: #000022; font-family: Arial, sans-serif; font-size: 10pt; text-align: left }

li { color: #000080; font-family: "Times New Roman", serif; font-size: 12pt; text-align: left;

font-style: italic; list-style-type: disc }

p { color: #008080; font-family: "Times New Roman", serif; font-size: 12pt; text-align: left }

body { background-color: #F0FFFF }

h1 48pt 1 mark

h4 Black (000000) 1 mark

h1, h2, h3, h5 No green 1 mark

p Colour 008080 1 mark

h5 Left aligned 1 mark

Page New styles 1 mark



© UCLES 2009

<HTML>

<HEAD>

<TITLE>Diving with us</TITLE>

<link rel="stylesheet" type ="text/css" href="J9style2.css">

</HEAD>

<BODY>

<h5>Last edited by Candidate name, centre number, candidate number</h5>

<h2>Supa Scuba Diving Holidays</h2>

<TABLE border = "2">


<TD colspan = "2"><h4>As a company we pride ourselves on our customer satisfaction. We offer a full

range of holiday experiences around the globe. These are designed to meet your every need. If you do not

see exactly what you are looking for, contact us and ask for our bespoke holiday service.</h4></TD>

</TR>


<TD colspan = "2"><h5>We offer the widest range of package holidays to match your budget. Try one of

the following ideas:</h5></TD>

</TR>


<TD><p>Experienced divers</p>

Text Correct cell 1 mark

Style h4 & from file 1 mark


Style h5 & from file 1 mark


3 titles Style p & from file 3 marks

2 lists Style li & from file 2 marks

Image J9clown.jpg in correct cell 1 mark


Table Border = “2” 1 mark

Top left Last edited by & name & No’s 1 mark Heading 100% correct 1 mark

Style h2 1 mark



© UCLES 2009

<ul>

<li>Go deep</li>

<li>Wreck week</li>

<li>Shark experience</li>

<li>Wall dives</li>

<li>Cave dives</li>

</ul>

<p>Beginners</p>

<ul>

<li>Meet the fish</li>

<li>Turtle week</li>

<li>Learn to dive</li>

<li>Snorkel with us</li>

</ul>

<p>Family packages</p></TD>

<TD><img src = "J9CLOWN.JPG" width = "280"></TD>

</TR>

</TABLE>

<p><a href="J9SCUBA.HTM" target="_self">Homepage</a></p>

<p>Contact us</p>

</HTML>

Unordered list correct place 1 markUnordered list Correct place 1 mark

J9clown.jpg Width 280 1 mark

Hyperlink Correct website 1 mark


Background Pale blue 1 mark

Between 1/3 and 1/5 1 mark

Blue stripe Vertical (edge of blue) 1 mark

Two horizontal 1 mark

4 point lines 1 mark

Image Fish 1 mark

Correct place 1 mark

Resized, cropped to fit, >50% 1 mark

Slide numbering Bottom left & automated 1 mark

Name, cand no, Centre no Bottom centre, black, 12pt, bold, sans-serif 1 mark

Heading 100% correct 1 mark

Dark blue, 48pt, sans-serif 1 mark

Left align & position 1 mark


Unordered list correct place 1 mark Unordered list Correct place 1 mark



© UCLES 2009


Heading Dark blue, left aligned, 60pt 1 mark

Subheading Blue, centre aligned, 30pt 1 mark

Subheading Blue, centre aligned, 30pt 1 mark

Bullets Black, left aligned, 20pt 1 mark



© UCLES 2009

Presenter notes On all slides 1 mark

100% Correct 1 mark

Right place 1 mark

Chart Trip type labels visible 1 mark

% value visible 1 mark

Centre & not distorted 1 mark

No legend 1 mark

Slide transitions Visible 2 marks



© UCLES 2009

Webpage Code Total Hours Mins

=VLOOKUP(B2,Sheet1!$A$2:$B$12,2) BH =SUMIF($B$11:$B$84,B2,$C$11:$C$84) =INT(C2/60) =C2-(D2*60)

=VLOOKUP(B3,Sheet1!$A$2:$B$12,2) C =SUMIF($B$11:$B$84,B3,$C$11:$C$84) =INT(C3/60) =C3-(D3*60)

=VLOOKUP(B4,Sheet1!$A$2:$B$12,2) D =SUMIF($B$11:$B$84,B4,$C$11:$C$84) =INT(C4/60) =C4-(D4*60)

=VLOOKUP(B5,Sheet1!$A$2:$B$12,2) EH =SUMIF($B$11:$B$84,B5,$C$11:$C$84) =INT(C5/60) =C5-(D5*60)

=VLOOKUP(B6,Sheet1!$A$2:$B$12,2) FP =SUMIF($B$11:$B$84,B6,$C$11:$C$84) =INT(C6/60) =C6-(D6*60)

=VLOOKUP(B7,Sheet1!$A$2:$B$12,2) H =SUMIF($B$11:$B$84,B7,$C$11:$C$84) =INT(C7/60) =C7-(D7*60)

=VLOOKUP(B8,Sheet1!$A$2:$B$12,2) HOL =SUMIF($B$11:$B$84,B8,$C$11:$C$84) =INT(C8/60) =C8-(D8*60)

Date PageCode Minutes

39820 H 12

39820 BH 17

39820 EH 11

39820 C 16

39820 D 13

39820 D 5

39820 EH 16

39820 C 14

39821 FP 18

39821 FP 18

39821 HOL 11

39821 D 11

39821 BH 14


Formulae, data & labels Fully visible 1 mark

Print area & single page Selected data only 1 mark

Hours Correct reference / 60 1 mark

Integer calculated 1 mark

Mins Correct reference subtract 1 mark

Reference * 60 1 mark

Header name, & numbers 1 mark

Webpage Lookup used 1 mark

Correct lookup reference 1 mark

Lookup – relative reference 1 mark


Range – absolute reference 1 mark


Total Correct SUMIF function 1 mark



Lookup relative reference 1 mark





© UCLES 2009


Date PageCode Minutes

08/01/2009 FP 34

09/01/2009 FP 25

09/01/2009 FP 24

10/01/2009 FP 24

08/01/2009 HOL 23

14/01/2009 FP 20

09/01/2009 HOL 19

08/01/2009 FP 18

08/01/2009 FP 18

09/01/2009 FP 17

08/01/2009 HOL 16

10/01/2009 FP 16

11/01/2009 FP 16

09/01/2009 FP 15

11/01/2009 FP 15

09/01/2009 FP 14

10/01/2009 FP 12

11/01/2009 HOL 12

08/01/2009 HOL 11

08/01/2009 HOL 11

10/01/2009 HOL 11

14/01/2009 HOL 11

10/01/2009 HOL 10

10/01/2009 FP 8

09/01/2009 HOL 7

11/01/2009 FP 7

10/01/2009 FP 6

08/01/2009 HOL 4

10/01/2009 HOL 3

Search PageCode = FP or HOL 2 marks

Rows 1–9 hidden 1 mark

Sort Descending on minutes 1 mark











examination.




syllabuses.




0417 INFORMATION AND COMMUNICATION

TECHNOLOGY







examination.






© UCLES 2010

Candidate name, Centre number, candidate number

<HTML>

<HEAD>

<TITLE>Relaxing Holiday Company - June 2010</TITLE>

<link rel="stylesheet" type ="text/css" href="JXstyles1.css">

</HEAD>

<BODY>

<a name="START"></a>

<TABLE width="100%" id="top">


<TD colspan = "4"> <img src ="JXTITLE.jpg"></TD>

</TR>

<TR>

<TD colspan = "4">

<h3>Last edited by Candidate name, centre number, candidate number

</TD>

</TR>

<TR>

<TD>

<h2>Sun

</TD>

<TD>

<h2>Sea

</TD>

<TD>

<h2>Sand

</TD>

<TD>

<h2><a href="#SNOWZONE">Snow</a>

</TD>

</TR>

</TABLE>

<TABLE width = 90% align="center" id="middle">

<TR>

<TD rowspan = "3"><img src ="JXHarbour.jpg"></TD>

<TD> <h3>We offer holidays to suit your every need. We can often make dreams come true. </TD>

</TR>

<TR>

<TD> <h3>Let us arrange your holiday for you. We will collect you from your home and offer the best service

of any holiday company in the world.</TD>

</TR>

<TR>

<TD> <h3>Combine our service with superb value for money. Contact us with your requirements and we are

sure that we will not disappoint you.</TD>

</TABLE>

<TABLE width="100%" id="bottom">

<TR>

<TD>

<h2><img src ="JXimg2.jpg" width="160">

</TD>

<TD>

<h2><a href="JXSEA.HTM" target="_sea"><img src ="JXImg3.jpg"></a>

</TD>

<TD>

<h2><img src ="JXImg5.jpg" width="160">

</TD>

<TD>

Target _sea 1 mark

Case as shown

to JXSEA.HTM 1 mark

Ignore case

Accept base target placed in head of

page

Table Width 100% 1 mark



Anchor START 1 mark

Can be in first cell of table

Upper case

Not visible on page

Hyperlink Snow 1 mark

To anchor SNOWZONE 1 mark

Upper case and wrong checklist


Must be relative referencing



© UCLES 2010

<h2><a href="mailto:[email protected]"><img src ="JXImg6.jpg"></a>

</TD>

</TR>


<TD colspan = "4"> <img src ="JXFOOTER.jpg"></TD>

</TR>

<TR>

<a name="SNOWZONE"></a>

<TD colspan = "4">

<h1> Try RHC Snowzone</h1>

<h3> Why not relax with a chilling winter holiday on the slopes. We can cater for a range of destinations,

both short haul and long haul and can offer some of the best 'off piste' skiing and boarding. Try out catered

chalets for the ultimate luxury. Leave the slopes and return to the chalet to find a superb a la carte dinner

prepared for you by one of the world finest chefs. You will not find these holidays in any brochure, each holiday

is unique to your requirements. Contact us using the link above for further details.</h3>

</TD>

</TR>

<TR>

<TD colspan = "4">

<h2><a href="#START">Click Here</a> to return to the top of the page.</h2>

</TD>

</TR>

</TABLE>

</BODY>

</HTML>


Click Here only

Rest of text intact

Returns to start 1 mark

Allow follow through on name

Anchor SNOWZONE 1 mark

Case as shown

No extra text

Target Phone image as link 1 mark

JXImg6 only

Penalise for absolute image reference

Correct mailto: 1 mark

Ignore case



© UCLES 2010

C

Top left Last edited by & name & No’s 1 mark

Any order for name and numbers

Top table From JXTOP.htm 1 mark

Table must be fully visible

Middle table 3 rows and 2 columns 1 mark

Merged cells in column 1 1 mark

Table centre aligned in window 1 mark

Award only if tables fully visible

Correct text each cell 1 mark

Can check in markup if needed

Style h3 1 mark

JXHARBOUR.JPG left cell 1 mark

NEW SCREENSHOT



© UCLES 2010

C

Bottom table From JXBOTTOM.htm 1 mark

Table must be fully visible

Sun image left 1 mark

Sea image 2nd 1 mark

Sand image 3rd 1 mark

Phone image right 1 mark

Sun resized to 160 & aspect 1 mark

Sand resized to 160 & aspect 1 mark



© UCLES 2010

File JXPRES.RTF Imported 1 mark

All slides present and intact

Titles larger than bullets 1 mark

and consistent style (fonts/bullets)

Bulleted lists consistent style 1 mark

Size may vary from slide to slide

Master slide – CHECK CONSISTENCY

Background White, slide numbers bottom left 1 mark

Left 1/3 of slide

Name, cand no, Centre no Top right black, 12pt, serif 1 mark

Right ! of slide

Image Sun – bottom right 1 mark

Must not be source files – flexible

Right 1/3 of slide


Not touching and all present

New slide Inserted as first slide 1 mark


Including case, can be on single line

Any alignment/No bullet points

Below subtitle 1 mark

Subtitle 100% correct 1 mark

Including case, can be on single line

Any alignment/No bullet points

Smaller font than title



© UCLES 2010

Slide 4

Answer 1 File not present/misnamed 1 mark

Not in current directory/folder

Text ‘answer n here’ has been replaced 1 mark

Must be all

Answer 2 Body {} 1 mark

Background-color: #025fb4 1 mark

e.g. body {background-image: url(j9sunset.jpg); background-color: #025fb4}

Answer 3 No green element 1 mark

Accept hex with FF for middle 2 digits

In hexadecimal/colour code/definition 1 mark



© UCLES 2010

Slide 5

Answer 4 Space between text and cell wall 1 mark

Inside/in table/cell 1 mark

Interchange cell wall and border

Answer 5 Space between 1 mark

Walls of 2 adjacent cells 1 mark

Interchange cell wall and border

Printed 2 slides per page 1 mark



Candidate name Centre number candidate number

© UCLES 2010

!"#$%&'$%(&) *(+") ,-%.#)

!"#$$%&'()*+,-./0123456787*97)7::+*+;<= )8>= !?$&@1AB(7.7*C97.7DE+)*<=

!"#$$%&'()F+,-./0123456787*97)7::+*+;<= ?$G= !?$&@1AB(7.7*C97.7DE+)F<=

!"#$$%&'()H+,-./0123456787*97)7::+*+;<= /IJ= !?$&@1AB(7.7*C97.7DE+)H<=

!"#$$%&'()C+,-./0123456787*97)7::+*+;<= A@.= !?$&@1AB(7.7*C97.7DE+)C<=

!"#$$%&'()K+,-./0123456787*97)7::+*+;<= L8#= !?$&@1AB(7.7*C97.7DE+)K<=

!"#$$%&'()M+,-./0123456787*97)7::+*+;<= 0NA= !?$&@1AB(7.7*C97.7DE+)M<=

!"#$$%&'()E+,-./0123456787*97)7::+*+;<= 1>8= !?$&@1AB(7.7*C97.7DE+)E<=

= = =

/(&$0) /1(+") !'2#)

,OPQORS= := !0&LAB(7)7*C97)7DE+)::+7B7*C97B7DE<=

BTURQORS= *= !0&LAB(7)7*C97)7DE+):*+7B7*C97B7DE<=

LOR3V= F= !0&LAB(7)7*C97)7DE+):F+7B7*C97B7DE<=

8WRXY= H= !0&LAB(7)7*C97)7DE+):H+7B7*C97B7DE<=

LOS= C= !0&LAB(7)7*C97)7DE+):C+7B7*C97B7DE<=

,QPT= K= !0&LAB(7)7*C97)7DE+):K+7B7*C97B7DE<=

,QYS= M= !0&LAB(7)7*C97)7DE+):M+7B7*C97B7DE<=

8QZQ4[= E= !0&LAB(7)7*C97)7DE+):E+7B7*C97B7DE<=

0TW[T\UTR= D= !0&LAB(7)7*C97)7DE+):D+7B7*C97B7DE<=

$3[]UTR= :;= !0&LAB(7)7*C97)7DE+)*;+7B7*C97B7DE<=

@]5T\UTR= ::= !0&LAB(7)7*C97)7DE+)*:+7B7*C97B7DE<=

.T3T\UTR= :*= !0&LAB(7)7*C97)7DE+)**+7B7*C97B7DE<=


Formulae, data and labels Fully visible 1 mark

Orientation Landscape 1 mark

Print area Selected data only 1 mark

Days Correct SUMIF function 1 mark


Check range works




Check range works


Other functions like SUMIFS may be used

Footer name and numbers 1 mark

Destination Lookup used 1 mark

Lookup or Vlookup

Correct lookup reference 1 mark

Do not allow range



Including filename


Check range works


Award if visible and Lookup used

Check first row

Trips COUNTIF function 1 mark


Check range works


Correct lookup 1 mark




© UCLES 2010

!"#$%&'$%(&) *(+") ,-%.#) ! ! !

"#$#%#&! "'(! ) ! ! !

*+,-%./! *01! ) ! ! !

23456! 278! 9: ! ! !

;<=>#! ;?@! 9A ! ! !

B#/=>C.&! B'D! 99 ! ! !

EF>!D#<G#! EH;! I ! ! !

J$#>/#<=! J('! 9K ! ! !

! ! ! ! ! !

/(&$0) /1(+") !'2#) ! ! !

L#<-#F4! 9! KI ! ! !

M.NF-#F4! K! A9 ! ! !

B#FO$! A! PK ! ! !

'5F>/! P! :Q ! ! !

B#4! R! 9SP ! ! !

L-<.! :! IS ! ! !

L-/4! )! )) ! ! !

'-3-&6! I! RR ! ! !

E.56.%N.F! Q! IA ! ! !

0O6+N.F! 9S! :: ! ! !

?+C.%N.F! 99! 9KR ! ! !

@.O.%N.F! 9K! )S ! ! !

! ! ! ! ! !

!'2) /(&$0) 3"'-) !*(+") !%#1(4&$) !4-'$%(&)

K)! Q! KS9S 278! 8! 9S!

9P! I! KS9S B'D! ?! 9P!

K9! I! KS9S J('! ?! )!

K! I! KS9S *01! 8! 9S!

9S! R! KS9S EH;! 8! 9P!

K)! R! KS9S "'(! ?! K9!

KI! Q! KS9S ;?@! ?! 9P!

K9! P! KS9S ;?@! ?! 9S!

K! 9K! KS9S *01! 8! 9P!

9:! R! KS9S 278! 8! 9P!

9I! 99! KS9S EH;! 8! K9!

P! )! KS9S 278! 8! )!

99! A! KS9S J('! ?! )!

A! P! KS9S *01! 8! 9P!

R! :! KS9S *01! 8! )!

A! 9S! KS9S ;?@! ?! 9P!

9! :! KS9S B'D! ?! 9P!

9Q! :! KS9S J('! ?! 9P!

KA! 99! KS9S EH;! ?! 9P!

R! )! KS9S J('! 8! 9P!

9! :! KS9S 278! ?! 9P!

KA! 9K! KS9S B'D! 8! )!

Row 1, 10, 24 Centre aligned 1 mark

Only three rows shown

Bold and italic 1 mark




© UCLES 2010

!"# "$# !$"$ %&'# &# "(#

"(# ""# !$"$ )*+# &# "$#

"# ,# !$"$ -*.# /# 0#

,# "# !$"$ 123# /# "(#

"0# 4# !$"$ 5.*# &# "(#

!# 6# !$"$ 78%# &# "$#

"(# 9# !$"$ 5.*# /# 0#

,"# 0# !$"$ 5.*# /# "(#

0# 6# !$"$ :;/# &# 0#

"6# 6# !$"$ :;/# /# "(#

"0# 9# !$"$ 78%# /# 0#

!"# "# !$"$ -*.# &# 0#

!4# "!# !$"$ )*+# /# "(#

6# ""# !$"$ 5.*# /# !"#

!,# ""# !$"$ )*+# /# "(#

!4# 4# !$"$ %&'# /# 0#

!4# $# !$"$ :;/# &# "(#

!0# "$# !$"$ -*.# /# 0#

"9# 9# !$"$ %&'# /# "$#

!9# 0# !$"$ -*.# /# "(#

,# "$# !$"$ )*+# &# "$#

"4# $# !$"$ :;/# /# "$#

"4# ,# !$"$ -*.# &# "(#

(# <# !$"$ :;/# /# !"#

"!# (# !$"$ 78%# /# "$#

(# ""# !$"$ :;/# /# "(#

,$# 6# !$"$ %&'# &# "(#

!<# 4# !$"$ %&'# &# "(#

"$# (# !$"$ )*+# /# "(#

!4# 4# !$"$ :;/# /# "$#

!<# "$# !$"$ %&'# &# "(#

0# ""# !$"$ )*+# /# "(#

0# "!# !$"$ 5.*# &# "(#

"(# "!# !$"$ %&'# &# 0#

6# <# !$"$ 123# &# "$#

!6# 6# !$"$ :;/# /# "$#

"(# 0# !$"$ 78%# /# "(#

"!# !# !$"$ %&'# /# "(#

""# "# !$"$ :;/# /# 0#

6# ,# !$"$ 5.*# &# "(#

!!# 0# !$"$ %&'# &# 0#

!,# (# !$"$ %&'# /# "(#

!(# "!# !$"$ 5.*# /# "(#

!$# !# !$"$ 5.*# /# 0#

(# ""# !$"$ )*+# &# "$#

"4# "$# !$"$ :;/# &# 0#

",# 4# !$"$ :;/# &# 0#



© UCLES 2010

!"# $# %&!& '()# *# "#

%$# +# %&!& ,-*# *# "#

%&# %# %&!& ./0# 1# !&#

2&# !!# %&!& 345# *# "#

!6# "# %&!& 7(8# *# "#

!"#$%& !'()#*+,& !*-.,'#+&

,-*# *# !&#

,-*# *# !+#

,-*# *# "#

,-*# *# !+#

,-*# *# !&#

,-*# *# %!#

,-*# *# !+#

,-*# *# !&#

,-*# *# !&#

,-*# *# "#

,-*# *# "#

Search DCode = EGY 1 mark

and Discount = Y 1 mark

Rows 1–23 hidden 1 mark

Columns A, B, C Hidden 1 mark



© UCLES 2009


A B C

1 Code Rate

2 D 1.21

3 N 1.3

4 P 1.65

5

6 Company Ccode Number

7 =VLOOKUP(B7,N9code.csv!$A$2:$B$16,2) A =COUNTIF($B$24:$B$116,B7)

8 =VLOOKUP(B8,N9code.csv!$A$2:$B$16,2) B =COUNTIF($B$24:$B$116,B8)

9 =VLOOKUP(B9,N9code.csv!$A$2:$B$16,2) C =COUNTIF($B$24:$B$116,B9)

10 =VLOOKUP(B10,N9code.csv!$A$2:$B$16,2) D =COUNTIF($B$24:$B$116,B10)

11 =VLOOKUP(B11,N9code.csv!$A$2:$B$16,2) E =COUNTIF($B$24:$B$116,B11)

12 =VLOOKUP(B12,N9code.csv!$A$2:$B$16,2) F =COUNTIF($B$24:$B$116,B12)

13 =VLOOKUP(B13,N9code.csv!$A$2:$B$16,2) G =COUNTIF($B$24:$B$116,B13)

14 =VLOOKUP(B14,N9code.csv!$A$2:$B$16,2) H =COUNTIF($B$24:$B$116,B14)

15 =VLOOKUP(B15,N9code.csv!$A$2:$B$16,2) R =COUNTIF($B$24:$B$116,B15)

16 =VLOOKUP(B16,N9code.csv!$A$2:$B$16,2) J =COUNTIF($B$24:$B$116,B16)

17 =VLOOKUP(B17,N9code.csv!$A$2:$B$16,2) K =COUNTIF($B$24:$B$116,B17)

18 =VLOOKUP(B18,N9code.csv!$A$2:$B$16,2) L =COUNTIF($B$24:$B$116,B18)

19 =VLOOKUP(B19,N9code.csv!$A$2:$B$16,2) M =COUNTIF($B$24:$B$116,B19)

20 =VLOOKUP(B20,N9code.csv!$A$2:$B$16,2) N =COUNTIF($B$24:$B$116,B20)

21 =VLOOKUP(B21,N9code.csv!$A$2:$B$16,2) P =COUNTIF($B$24:$B$116,B21)

Rate data entry 100% 1 mark

Replication both formulae 1 mark

Orientation landscape and 1 page wide 1 mark

Row and Column headings visible 1 mark

Column width all items fully visible 1 mark

Print area selected data only 1 mark

COUNTIF correct function 1 mark

correct range 1 mark

range – absolute reference 1 mark

correct reference 1 mark

reference – relative 1 mark

Header candidate name, Centre no, candidate no 1 mark

Company lookup used 1 mark

correct lookup reference 1 mark

lookup – relative reference 1 mark

external file/sheet for code 1 mark

correct range 1 mark

range – absolute reference 1 mark

correct return column 1 mark



© UCLES 2009


Code Rate

D 1.21

N 1.30

P 1.65

Company Ccode Number

Sellotape A 6

Scotch B 0

Simplex C 5

Dudley D 4

Coltex E 3

Pritt F 9

Easirase G 0

Stiples H 9

Quest R 9

Cheaper J 6

Papermite K 10

TryIT L 9

Bryter M 7

Owen N 4

Quest P 5

Cells B2–B4 2 decimal places 1 mark

Cells A2–A4 right aligned 1 mark

Orientation portrait and fit to page 1 mark

Row and Column headings NOT visible 1 mark

Data and Labels fully visible 1 mark





© UCLES 2009

F G H

23 Unit Retail Pack Size Retail

24 =IF(D24="D",E24*Discount,IF(D24="N",E24*Normal,IF(D24="P",E24*Premium,E24))) 1 =F24*G24

































Units nested IF 1 mark

correct named cells 3 marks

correct function (3 parts) 3 marks

returns Unit Purchase if not DNP 1 mark

Replication both formulae 1 mark

Orientation landscape and fit to page 1 mark

Row and Column headings visible 1 mark

Column width items all fully visible 1 mark


Retail correct formula 1 mark




© UCLES 2009

Ref Supplier Description Code Unit Purchase Unit Retail Pack Size Retail

10612 L Elite 70 Lever Arch File A4 Black D ! 4.75 ! 5.74 1 ! 5.74

12734 J PVC 2 Ring Binder A4 Black ! 0.29 ! 0.29 10 ! 2.85

13279 M Lever Arch File Spine Labels Red Pkd 10 D ! 1.57 ! 1.89 1 ! 1.89

31815 H Ring Binder Yellow Pkd 1 N ! 0.20 ! 0.26 1 ! 0.26

8772 L Clear Pockets A4 Size Pkd 100 ! 4.06 ! 4.06 1 ! 4.06

30436 E Bostik Blu-Tack Handy Size ! 0.26 ! 0.26 10 ! 2.60

6445 M Lever Arch Files Blue A4 P ! 11.90 ! 19.63 1 ! 19.63

33312 R Folder PVC 38mm Black ! 0.52 ! 0.52 1 ! 0.52

33276 R Folder PVC 50mm White D ! 0.53 ! 0.64 1 ! 0.64

46471 L Glass Clear Plastic Pockets Pkd 100 N ! 0.46 ! 0.59 1 ! 0.59

47275 J Laminated Ring Binder Purple ! 0.72 ! 0.72 10 ! 7.20

32415 F Pritt Glue Stick Large 40gms N ! 14.62 ! 19.01 1 ! 19.01

47246 L 3 Flap Elastic Folder Bordeaux P ! 4.01 ! 6.62 1 ! 6.62

40386 F Glue Sticks Small 10 gms N ! 0.15 ! 0.19 1 ! 0.19

49152 F Pritt Mini Adhesive Roller Permanent ! 0.60 ! 0.60 1 ! 0.60

47274 J Laminated Ring Binder Grey ! 0.72 ! 0.72 10 ! 7.20

44835 C Poly Packaging Tape 50mmx66m Pkd 1 D ! 0.26 ! 0.31 6 ! 1.89

29739 P Square Cut Folder 270gsm Foolscap Blue N ! 0.84 ! 1.09 1 ! 1.09

33256 A Sellotape Original Tape 25mm x 66m ! 5.25 ! 5.25 12 ! 62.94

38478 C Poly Clear Tape 48mm x 66m ! 1.12 ! 1.12 6 ! 6.72

86889 F Pritt Childsplay Magic Craft Glue P ! 0.64 ! 1.05 1 ! 1.05

60433 D Poly Clear Tape 25mm x 33m P ! 0.75 ! 1.23 10 ! 12.29

47273 J Laminated Ring Binder Green ! 0.72 ! 0.72 10 ! 7.20

19601 K 5 Part Organiser Files Blue ! 0.92 ! 0.92 5 ! 4.59

43004 B Deluxe Tape Dispenser Black N ! 1.09 ! 1.41 10 ! 14.11

22470 L Blue Strip Top Open Pkd 25 D ! 3.62 ! 4.37 1 ! 4.37

33287 N Foolscap Lever Arch File Blue N ! 0.23 ! 0.29 10 ! 2.93

27533 H PVC 2 Ring Binder A5 Green ! 0.52 ! 0.52 10 ! 5.20

29753 K Ring Binder Red D ! 0.75 ! 0.90 1 ! 0.90

68151 F Pocket Correction Pen ! 0.64 ! 0.64 1 ! 0.64

49153 F Pritt Mini Adhesive Roller Restickable N ! 0.60 ! 0.77 1 ! 0.77

Data and Labels fully visible 1 mark

Print area rows 23 to 54 only 1 mark

Orientation landscape 1 mark

Row 23 centre aligned 1 mark

bold 1 mark

italic 1 mark

Pack SIze integer 1 mark

3 fields Euro 1 mark

2 decimal places 1 mark








© UCLES 2009

Ref Supplier Description Code Unit Purchase Unit Retail Pack Size Retail

33314 R Folder PVC 38mm Red ! 0.52 ! 0.52 1 ! 0.52

33106 R Folder PVC 50mm Red D ! 0.53 ! 0.64 1 ! 0.64

38387 K Eurofolio Ring Binders A4 Red ! 0.57 ! 0.57 10 ! 5.65

Search Unit Purchase > 0.51 and < 0.58 1 mark

and Description contains Red 1 mark



© UCLES 2009

<HTML>

<HEAD>

<TITLE>New Offers</TITLE>

<link rel="stylesheet" type ="text/css" href="N9styles.css">

</HEAD>

<BODY>

<a name="TOP"></a>

<p>Last edited by Candidate name, centre number, candidate number</p>

<TABLE cellspacing="4" cellpadding="4" width="100%" border="0">

<TR>

<TD colspan = "4" width="75%"> <h1>Hothouse Design</h1></TD>

<TD colspan = "1" rowspan="5"><img src="N9PEN.JPG" width="100" height="300"></TD>

</TR>

<TR>

<TD colspan="4">

<h2>Stationery Supplies</h2><BR>

<h3>This week we have special offers adhesive products, files, folders and writing materials. Our star

offers can be found on the following range of products:</h3></TD>

Top left Last edited by & NAME & No’s 1 mark

style p 1 mark

Table cell padding 4 1 mark

cell spacing 4 1 mark

width 100% 1 mark

border 0 1 mark

Merged Adhesives 1 mark

Files 1 mark

Merged Adhesives 1 mark

Files 1 mark

Images correct cells 5 marks

Sponsored links replaced 1 mark

Style p 1 mark

Valign top 1 mark

Place list here replaced 1 mark

Style li 1 mark


Anchor TOP above table in body section 1 mark

N9PEN.JPG width 100 1 mark

height 300 1 mark



© UCLES 2009

</TR>

<TR>

<TD colspan="2" width="44%"><h3>Adhesives</h3></TD>

<TD colspan="2" width="44%"><h3>Files</h3></TD>

</TR>

<TR>

<TD><a href="N9TAPE.HTM" target="_adhesivetape"><IMG SRC="N9TAPE.JPG"></a></TD>

<TD><IMG SRC="N9GLUE.JPG"></TD>

<TD><IMG SRC="N9FILE.JPG"></TD>

<TD><IMG SRC="N9FOLDER.JPG"></TD>

</TR>

<TR>

<TD colspan="4">

<p>Click on the image above to take you to this weeks star offers. These offer the best value for money

that can be found anywhere on the internet, local shop or wholesaler.</p>

</TR>

</TABLE>

<TABLE cellSpacing="4" cellPadding="4" width="100%" border="2">

<TR>

<TD width="33%" valign="top"><p>Select from the following sponsored links to take you to our partner

companies:</p>

</TD>

<TD width="33%">

<ul>

<li>Rootrainer Trees</li>

<li>Rock ICT</li>

<li>Kuroki Koi</li>

<li>Electry</li>

<li>International Tea and Coffee Traders</li>

</ul>

</TD>

<TD valign="top">

<p>Click Here to e-mail us.</p>

<p><a href="#Top">Click Here</a> to return to the top of the page.</p>

</TD>

</BODY>

</TABLE>

</HTML>

Table cell padding 4 1 mark

cell spacing 4 1 mark

width 100% 1 mark

border 2 1 mark

Adhesives 2 columns, 44% 1 mark

Files 2 columns, 44% 1 mark


Returns to Top 1 mark

Target _adhesivetape 1 mark

To n9tape.htm 1 mark



© UCLES 2009

Automatic page numbering 1 mark Clip art pen 1 mark

Black, 24pt, sans-serif correct 1 mark Black, 12pt, sans-serif 1 mark

Red, 48pt, right aligned, serif 1 mark Black, 24pt, centre align, serif 1 mark

Master slide no overlap 1 mark



© UCLES 2009

Red, 48pt, right aligned, serif 1 mark

Correct image, fills most of the slide 1 mark

Reflected/flipped 1 mark

Animation, bullets only 1 mark

Appear one at a time 1 mark

mark scheme maximum mark : 72 syllabus/component · pdf file0418/03 june 2006 page 7 of 13...

Documents