June 2012 Paper 32 by Nicholas Patterson

UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS International General Certificate of Secondary Education

MARK SCHEME for the May/June 2012 question paper for the guidance of teachers

0417 INFORMATION AND COMMUNICATION TECHNOLOGY 0417/32

Paper 3 (Practical Test B), maximum raw mark 80

This mark scheme is published as an aid to teachers and candidates, to indicate the requirements of the examination. It shows the basis on which Examiners were instructed to award marks. It does not indicate the details of the discussions that took place at an Examiners’ meeting before marking began, which would have considered the acceptability of alternative answers. Mark schemes must be read in conjunction with the question papers and the report on the examination.

• Cambridge will not enter into discussions or correspondence in connection with these mark schemes.

Cambridge is publishing the mark schemes for the May/June 2012 question papers for most IGCSE, GCE Advanced Level and Advanced Subsidiary Level syllabuses and some Ordinary Level syllabuses.

Page 2

Mark Scheme: Teachers’ version IGCSE – May/June 2012

Page Print area

Syllabus 0417

Single page - portrait As specified Currency Euros & 2 dp

Paper 32

1 mark 1 mark 1 mark

Header Week 29 - left Name & numbers - right aligned 1 mark Footer Last edited on & date and time - centre 1 mark

Page 3 A

Syllabus 0417

Paper 32 E

The Xtreme Adventure Holiday Company

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Mark Scheme: Teachers’ version IGCSE – May/June 2012

Pay rates A B C D

7.5 8 9.2 10.75

Job codes A B H S SA TA TB TM TS

Administration/Office Snowboard Instructor Host/Hostess Ski Instructor Senior Administrator Transport assistant Trainee Snowboard Instructor Transport Manager Trainee Ski Instructor

Employees Job code TA TS TM B TA B A B B SA

Name Arne Bircher Jon Haby Thomas Tobler Tim Frueh Dekke Heitz Simone Aebi Luca Rim Lara Forrer John Zwinky Romina Von Gunten

Job description

Lookup used Correct lookup reference Lookup - relative reference Correct absolute range Correct return column

Pay code A A C B A B B B B D

1 mark 1 mark 1 mark 1 mark 1 mark

Job description =VLOOKUP(A22,$A$10:$B$18,2) =VLOOKUP(A23,$A$10:$B$18,2) =VLOOKUP(A24,$A$10:$B$18,2) =VLOOKUP(A25,$A$10:$B$18,2) =VLOOKUP(A26,$A$10:$B$18,2) =VLOOKUP(A27,$A$10:$B$18,2) =VLOOKUP(A28,$A$10:$B$18,2) =VLOOKUP(A29,$A$10:$B$18,2) =VLOOKUP(A30,$A$10:$B$18,2) =VLOOKUP(A31,$A$10:$B$18,2)

Pay

Contract hours 10 25 25 25 12 25 12 25 12 40

Lookup used Correct relative lookup reference Correct named range Correct return column Multiplied by F22

Hours worked 10 25 25 15 12 25 12 25 12 40

1 mark 1 mark 1 mark 1 mark 1 mark

Pay =VLOOKUP(C22,RATE,2)*F22 =VLOOKUP(C23,RATE,2)*F23 =VLOOKUP(C24,RATE,2)*F24 =VLOOKUP(C25,RATE,2)*F25 =VLOOKUP(C26,RATE,2)*F26 =VLOOKUP(C27,RATE,2)*F27 =VLOOKUP(C28,RATE,2)*F28 =VLOOKUP(C29,RATE,2)*F29 =VLOOKUP(C30,RATE,2)*F30 =VLOOKUP(C31,RATE,2)*F31

Page 4 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60

A B H S S S S TB S S S S TB TA B A B B S S S S S S A B B

Mark Scheme: Teachers’ version IGCSE – May/June 2012

Arenwald Wurgler Julian Bruster Sofia Walp Arda Hegler Nathan Ganz Alessandro Messerli Luca Roser Andri Jud Matteo Nufer Laura Haener Livio Stager Giulia Ramseyer Noah Truby Raphael Michlig Luca Gisi Matteo Isch Alice Thoeny Leonardo Jud Fabian Ging Leon Joost Nico Lichty Leandro Laqua Mattia Polt Camille Oberlin Matteo Hilty Mia Leupp Nico Gantert

Syllabus 0417

Paper 32

A C A B B B C A B B B C A A B B B B B B B B B B B B B

=VLOOKUP(A32,$A$10:$B$18,2) 38 =VLOOKUP(A33,$A$10:$B$18,2) 30 =VLOOKUP(A34,$A$10:$B$18,2) 20 =VLOOKUP(A35,$A$10:$B$18,2) 25 =VLOOKUP(A36,$A$10:$B$18,2) 25 =VLOOKUP(A37,$A$10:$B$18,2) 25 =VLOOKUP(A38,$A$10:$B$18,2) 30 =VLOOKUP(A39,$A$10:$B$18,2) 25 =VLOOKUP(A40,$A$10:$B$18,2) 25 =VLOOKUP(A41,$A$10:$B$18,2) 25 =VLOOKUP(A42,$A$10:$B$18,2) 25 =VLOOKUP(A43,$A$10:$B$18,2) 30 =VLOOKUP(A44,$A$10:$B$18,2) 25 =VLOOKUP(A45,$A$10:$B$18,2) 12 =VLOOKUP(A46,$A$10:$B$18,2) 25 =VLOOKUP(A47,$A$10:$B$18,2) 12 =VLOOKUP(A48,$A$10:$B$18,2) 25 =VLOOKUP(A49,$A$10:$B$18,2) 12 =VLOOKUP(A50,$A$10:$B$18,2) 25 =VLOOKUP(A51,$A$10:$B$18,2) 25 Cell F59 AVERAGE(F22:F58) Cell G60 SUM(G22:G58) =VLOOKUP(A52,$A$10:$B$18,2) 25 =VLOOKUP(A53,$A$10:$B$18,2) 25 =VLOOKUP(A54,$A$10:$B$18,2) 25 =VLOOKUP(A55,$A$10:$B$18,2) 25 =VLOOKUP(A56,$A$10:$B$18,2) 20 =VLOOKUP(A57,$A$10:$B$18,2) 25 =VLOOKUP(A58,$A$10:$B$18,2) 12 Average Single landscape page wide, all vis 1 mark Total

Printout Replication Both formulae

1 mark

38 35 20 25 28 25 30 25 10 25 35 30 25 12 25 0 30 12 25 251 mark 301 mark 0 25 5 20 30 12 =AVERAGE(F22:F58)

=VLOOKUP(C32,RATE,2)*F32 =VLOOKUP(C33,RATE,2)*F33 =VLOOKUP(C34,RATE,2)*F34 =VLOOKUP(C35,RATE,2)*F35 =VLOOKUP(C36,RATE,2)*F36 =VLOOKUP(C37,RATE,2)*F37 =VLOOKUP(C38,RATE,2)*F38 =VLOOKUP(C39,RATE,2)*F39 =VLOOKUP(C40,RATE,2)*F40 =VLOOKUP(C41,RATE,2)*F41 =VLOOKUP(C42,RATE,2)*F42 =VLOOKUP(C43,RATE,2)*F43 =VLOOKUP(C44,RATE,2)*F44 =VLOOKUP(C45,RATE,2)*F45 =VLOOKUP(C46,RATE,2)*F46 =VLOOKUP(C47,RATE,2)*F47 =VLOOKUP(C48,RATE,2)*F48 =VLOOKUP(C49,RATE,2)*F49 =VLOOKUP(C50,RATE,2)*F50 =VLOOKUP(C51,RATE,2)*F51 =VLOOKUP(C52,RATE,2)*F52 =VLOOKUP(C53,RATE,2)*F53 =VLOOKUP(C54,RATE,2)*F54 =VLOOKUP(C55,RATE,2)*F55 =VLOOKUP(C56,RATE,2)*F56 =VLOOKUP(C57,RATE,2)*F57 =VLOOKUP(C58,RATE,2)*F58 =SUM(G22:G58)

Page 5

Mark Scheme: Teachers’ version IGCSE – May/June 2012

Syllabus 0417

Paper 32

The Xtreme Adventure Holiday Company Employees Job code Name Pay code TA Arne Bircher A TS Jon Haby A Top row Merge cells A1 to G1 TM Thomas Tobler C Striped background B Tim Frueh Grey background B TA DekkeBlack Heitz 24 point serifA font

Job description Transport assistant Trainee Ski Instructor 1 mark Transport 1 markManager Snowboard 1 mark Instructor 1 markassistant Transport

Contract hours 10 25 25 25

Hours worked 10 25 25 15

Pay € 75.00 € 187.50 € 230.00 € 120.00

B A B B SA

Simone Aebi Luca Rim Lara Forrer John Zwinky Romina Von Gunten

B B B B D

12 12 € 90.00 Snowboard Instructor 25 25 € 200.00 Administration/Office 12 12 € 96.00 Snowboard Instructor 25 25 € 200.00 Rows 3-18 Hidden Currency Pay 12 column - Correct format - all cells Snowboard Instructor 12 € 96.00 Printout Single page wide, all visible Senior Administrator 40 40 € 430.00

A B H S S S

Arenwald Wurgler Julian Bruster Sofia Walp Arda Hegler Nathan Ganz Alessandro Messerli

A C A B B B

Administration/Office Snowboard Instructor Host/Hostess Ski Instructor Ski Instructor Ski Instructor

38 30 20 25 25 25

38 35 20 25 28 25

€ 285.00 € 322.00 € 150.00 € 200.00 € 224.00 € 200.00

Luca Roser

€ 276.00

TB S S S

Andri Jud Matteo Nufer Laura Haener Livio Stager

A B B B

Ski Instructor Trainee Snowboard Instructor

25 25 25 25

25 10 25 35

€ 187.50 € 80.00 € 200.00 € 280.00

Giulia Ramseyer

€ 276.00

TB TA B A B

Noah Truby Raphael Michlig Luca Gisi Matteo Isch Alice Thoeny

A A B B B

Transport assistant Snowboard Instructor Administration/Office Snowboard Instructor

25 12 25 12 25

25 12 25 0 30

€ 187.50 € 90.00 € 200.00 € 0.00 € 240.00

B S S S S S

Leonardo Jud Fabian Ging Leon Joost Nico Lichty Leandro Laqua Mattia Polt

B B B B B B

Snowboard Instructor Ski Instructor Ski Instructor Ski Instructor Ski Instructor Ski Instructor

12 25 25 25 25 25

12 25 25 30 0 25

€ 96.00 € 200.00 € 200.00 € 240.00 € 0.00 € 200.00

S A B B

Camille Oberlin Matteo Hilty Mia Leupp Nico Gantert

B B B B

Ski Instructor Administration/Office Snowboard Instructor Snowboard Instructor

25 20 25 12 Average Total

5 20 30 12 21.7027027

€ 40.00 € 160.00 € 240.00 € 96.00

Ski Instructor Ski Instructor Ski Instructor Ski Instructor Trainee Snowboard Instructor

€ 6,594.50

1 mark 1 mark 1 mark

Page 6

Mark Scheme: Teachers’ version IGCSE – May/June 2012

Syllabus 0417

Paper 32

The Xtreme Adventure Holiday Company Employees Job code TS S S

Name Jon Haby Arda Hegler Nathan Ganz

Pay code A B B

Job description Trainee Ski Instructor Ski Instructor Ski Instructor

Contract hours 25 25 25

Hours worked 25 25 28

Pay € 187.50 € 200.00 € 224.00

S S S S S S

Alessandro Messerli Luca Roser Laura Haener Livio Stager Giulia Ramseyer Fabian Ging

B C B B C B

Ski Instructor Ski Instructor Ski Instructor Ski Instructor Ski Instructor Ski Instructor

25 30 25 25 30 25

25 30 25 35 30 25

€ 200.00 € 276.00 € 200.00 € 280.00 € 276.00 € 200.00

S S S

Leon Joost Nico Lichty Mattia Polt

B B B

Ski Instructor Ski Instructor Ski Instructor

25 25 25

25 30 25

€ 200.00 € 240.00 € 200.00

Extract

Contains Ski 25 or more hours worked Single page wide

1 mark 1 mark 1 mark

Page 7

Mark Scheme: Teachers’ version IGCSE – May/June 2012 Browser

Top table

From J12Table4.htm Top left

Syllabus 0417

Paper 32

Not viewed from editing package 1 mark

1 mark Last edited by & name & No’s

1 mark

Middle table 4 rows & 2 columns Merged cells in column 1 Table centre aligned in window Correct text each cell Style h3 J12TREE.JPG in left column

Candidate name

Centre number

Candidate number

1 mark 1 mark 1 mark 1 mark 1 mark 1 mark

Page 8

Mark Scheme: Teachers’ version IGCSE – May/June 2012

Syllabus 0417

Paper 32

Bottom table From J12Table6.htm Cave swim image left Scuba image 2nd Skis image 3rd ATV image 4th Phone image right Scuba resized to 120 & aspect Skier resized to 120 & aspect ‘Date & Time here’ replaced

Candidate name

Centre number

Candidate number

1 mark 1 mark 1 mark 1 mark 1 mark 1 mark 1 mark 1 mark 1 mark

Page 9

Mark Scheme: Teachers’ version IGCSE – May/June 2012

Syllabus 0417

Paper 32

Correct stylesheet attached 1 mark <HTML> <HEAD> <TITLE>The Xtreme Adventure Holiday Company - June 2012</TITLE> <link rel="stylesheet" type ="text/css" href="J1232.css"> </HEAD> Anchor start 1 mark <BODY> <a name="start"></a> <TABLE width="100%" id="table1"> Table Width 100% 1 mark <TR align="center" valign="middle"> <TD colspan = "5"> <img src ="J12BAnner1.jpg" alt="Banner"></TD> </TR> <TR> <TD colspan = "5"> <h3>Last edited by A. Candidate, Centre:XX9999, Candidate:99999 </h3> </TD> </TR> <TR> <TD> <h2>Cave swimming</h2> </TD> <TD> <h2>Below the waves</h2> </TD> <TD> <h2>Hit the slopes</h2> </TD> <TD> Hyperlink Combination Holidays 1 mark <h2>ATV/Quad bikes</h2> To anchor combine 1 mark </TD> <TD> <h2><a href="#combine">Combination Holidays</a></h2> </TD> Table Width 75% 1 mark </TR> </TABLE> <TABLE width="75%" align="center" id="table2"> <TR> <TD rowspan = "4"><img src ="J12TREE.jpg" alt="Tree image"></TD> <TD> <h3>Make your dreams come true... Our holidays will accommodate your every need.</h3></TD> </TR> <TR> <TD> <h3>Swim in the cenotes in Mexico, cross-country skiing in Norway or alpine skiing in France.</h3></TD> </TR> <TR> <TD> <h3>For motor sports enthusiasts, try a skidoo through the snowy wastes or ride ATVs through a steamy jungle.</h3></TD> </TR> <TR> <TD> <h3>We offer superb value for money. Contact us for further details.</h3></TD> </TR> </TABLE>

Candidate name

Centre number

Candidate number

Page 10

Mark Scheme: Teachers’ version IGCSE – May/June 2012 Table

Syllabus 0417 Width 100%

Paper 32 1 mark

<TABLE id="table3" width="100%"> <TR align="center" valign="middle" > <TD colspan = "5"> <h2>Try a real adventure holiday, can be extreme, could make you scream, but for pleasure and excitement try one of these:</h2> </TD> </TR> <TR> <TD> <h2><img src ="J12IMG13.jpg" alt="Cave image"></h2> </TD> Target

_ocean to J12DIVE.HTM

1 mark 1 mark

<TD> <h2><a href="J12DIVE.HTM" target="_ocean"><img src ="J12IMG16.jpg" width="120" alt="Dive image"></a></h2> </TD> <TD> <h2><img src ="J12IMG12.jpg" width="120" alt="Ski image"></h2> </TD> <TD> <h2><img src ="J12IMG11.jpg" alt="ATV image"></h2> </TD> <TD> <h2><a href="mailto:xahc@cie.org.uk?subject=Xtreme%20Holidays"> <img src ="J12IMG15.jpg" alt="Contact us"></a></h2> </TD> Hyperlink Phone image as link 1 mark </TR> Subject

mailto:xahc@cie.org.uk Xtreme Holidays

1 mark 1 mark

<TR align="center" valign="middle"> <TD colspan = "5"> <img src ="J12Banner2.jpg" alt="Sales banner 2"></TD> </TR> <TR> Anchor combine 1 mark <TD colspan = "5"> <a name="combine"></a> <h1> Combination holidays</h1> <h3> For all you real adrenaline junkies out there, why not try two or more of our holidays combined. Maybe a week skiing followed by a spectacular off-road driving experience in the frozen wastes, or combine scuba with an aerial adventure or off-road in the tropical rain forest. All our holidays involve the adrenaline rush, followed by pure relaxation in the best hotels where you will be truly pampered. Try a day on the slopes followed by 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 image above for further details.</h3> </TD> </TR> <TR> <TD colspan = "5">

Candidate name

Centre number

Candidate number

Page 11

Mark Scheme: Teachers’ version IGCSE – May/June 2012

Syllabus 0417

Paper 32

<h2>Return to the top of the page by <a href="#start">clicking on this link</a>.</h2> <h3>Website last updated on 16/1/2012 12:04:00</h3> </TD> Hyperlink clicking on this link 1 mark </TR> Returns to start 1 mark </TABLE> </BODY> </HTML> Top right Text replaced

Enjoy your dives with: In style h2

Last edited by & name & No’s

1 mark 1 mark

Text P LI P LI P Image

in correct cell Beginners start with: pool sessions…Water diver You will: enjoy the… exotic fish Qualified divers… J12IMG16 – not resized in correct cell

1 mark 1 mark 1 mark 1 mark 1 mark 1 mark 1 mark

1 mark

Page 12

Mark Scheme: Teachers’ version IGCSE – May/June 2012

Syllabus 0417

Stylesheet J1232.css attached <HTML> <HEAD> <TITLE>Diving with Xtreme Adventures</TITLE> <link rel="stylesheet" type ="text/css" href="J1232.css"> </HEAD> <BODY>

Paper 32 1 mark

<h5>Last edited by Candidate name, centre number, candidate number</h5> <h2>Enjoy your dives with:</h2> <TABLE> <TR align="center" valign="center"> <TD colspan = "2"><img src ="J12BAnner1.jpg"></TD> </TR> <TR align="center" valign="center"> <TD colspan = "2"><img src ="J12BAnner2.jpg"></TD> </TR> <TR align="center" valign="center"> <TD> <p>Beginners start with:</p> Top list <ol> and </ol> correct place 1 mark <ol> <li>pool sessions</li> <li>safety tuition</li> <li>developing confined water skills</li> <li>first ocean dive</li> <li>guided tasks</li> <li>qualification as an Open Water diver</li> </ol> <p>You will:</p> Bottom list <ul> and </ul> correct place 1 mark <ul> <li>enjoy the experience</li> <li>view an undersea world</li> <li>see exotic fish</li> </ul> <p>Qualified divers also catered for.</p> </TD> <TD><img src ="J12IMG16.jpg"></TD> </TR> </TABLE> </HTML>

Candidate name

Centre number

Candidate number

Page 13

Mark Scheme: Teachers’ version IGCSE – May/June 2012 Image size

Image

Candidate name

Centre number

Syllabus 0417 Resized to 720 pixels wide Aspect ratio maintained

Resolution =<100K

Candidate number

Paper 32 1 mark 1 mark

1 mark

Page 14

Mark Scheme: Teachers’ version IGCSE – May/June 2012

Named range

Candidate name

Centre number

Syllabus 0417

Correct range Correct name

Candidate number

Paper 32

1 mark 1 mark