UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS International General Certificate of Secondary Education
MARK SCHEME for the May/June 2010 question paper for the guidance of teachers
0417 INFORMATION AND COMMUNICATION TECHNOLOGY 0417/03
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.
•
CIE will not enter into discussions or correspondence in connection with these mark schemes.
CIE is publishing the mark schemes for the May/June 2010 question papers for most IGCSE, GCE Advanced Level and Advanced Subsidiary Level syllabuses and some Ordinary Level syllabuses.
Page 2
Mark Scheme: Teachers’ version IGCSE – May/June 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>
Syllabus 0417
Correct stylesheet attached Must be relative referencing
Anchor START Can be in first cell of table Upper case Not visible on page
Paper 03 1 mark
1 mark
<a name="START"></a> <TABLE width="100%" id="top"> <TR align="center" valign="center"> <TD colspan = "4"> <img src ="JXTITLE.jpg"></TD> Table Width 100% 1 mark </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> Hyperlink Snow 1 mark <h2>Sand To anchor SNOWZONE 1 mark </TD> Upper case and wrong checklist <TD> <h2><a href="#SNOWZONE">Snow</a> </TD> Table Width 90% 1 mark </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 Width 100% 1 mark </TABLE> <TABLE width="100%" id="bottom"> Target _sea 1 mark <TR> Case as shown <TD> to JXSEA.HTM 1 mark <h2><img src ="JXimg2.jpg" width="160"> Ignore case </TD> Accept base target placed in head of <TD> page <h2><a href="JXSEA.HTM" target="_sea"><img src ="JXImg3.jpg"></a> </TD> <TD> <h2><img src ="JXImg5.jpg" width="160"> </TD> <TD> © UCLES 2010
Page 3
Mark Scheme: Teachers’ version IGCSE – May/June 2010
Syllabus 0417
Paper 03
<h2><a href="mailto:RHC@cie.org.uk"><img src ="JXImg6.jpg"></a> </TD> Target Phone image as link 1 mark </TR> JXImg6 only <TR align="center" valign="center"> Penalise for absolute image reference <TD colspan = "4"> <img src ="JXFOOTER.jpg"></TD> Correct mailto: 1 mark </TR> Ignore case <TR> <a name="SNOWZONE"></a> <TD colspan = "4"> <h1> Try RHC Snowzone</h1> Anchor We SNOWZONE mark <h3> Why not relax with a chilling winter holiday on the slopes. can cater for a range of 1 destinations, Case as shown 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 chaletNo to extra find atext 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> Hyperlink Click Here 1 mark </TR> Click Here only </TABLE> Rest of text intact </BODY> Returns to start 1 mark </HTML> Allow follow through on name
© UCLES 2010
Page 4 Top left
Mark Scheme: Teachers’ version IGCSE – May/June 2010 Last edited by & name & No’s 1 mark Any order for name and numbers Top table
Syllabus 0417
Paper 03
From JXTOP.htm Table must be fully visible
1 mark
C
Middle table 3 rows and 2 columns Merged cells in column 1 Table centre aligned in window Award only if tables fully visible Correct text each cell Can check in markup if needed Style h3 JXHARBOUR.JPG left cell NEW SCREENSHOT
© UCLES 2010
1 mark 1 mark 1 mark 1 mark 1 mark 1 mark
Page 5
Mark Scheme: Teachers’ version IGCSE – May/June 2010
Syllabus 0417
Paper 03
C
Bottom table From JXBOTTOM.htm Table must be fully visible Sun image left Sea image 2nd Sand image 3rd Phone image right Sun resized to 160 & aspect Sand resized to 160 & aspect
© UCLES 2010
1 mark 1 mark 1 mark 1 mark 1 mark 1 mark 1 mark
Page 6
Mark Scheme: Teachers’ version IGCSE – May/June 2010
Master slide – CHECK CONSISTENCY Background White, slide numbers bottom left Left 1/3 of slide Name, cand no, Centre no Top right black, 12pt, serif Right ½ of slide Image Sun – bottom right Must not be source files – flexible Right 1/3 of slide Master slide items Not overlapping any object Not touching and all present New slide Title
Syllabus 0417
Paper 03
1 mark 1 mark 1 mark 1 mark
Inserted as first slide 1 mark 100% correct 1 mark Including case, can be on single line Any alignment/No bullet points Below subtitle 1 mark 100% correct 1 mark Including case, can be on single line Any alignment/No bullet points Smaller font than title
Subtitle
File JXPRES.RTF
© UCLES 2010
Imported All slides present and intact Titles larger than bullets and consistent style (fonts/bullets) Bulleted lists consistent style Size may vary from slide to slide
1 mark 1 mark 1 mark
Page 7
Mark Scheme: Teachers’ version IGCSE – May/June 2010
Slide 4 Answer 1
Syllabus 0417
Paper 03
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
Page 8
Mark Scheme: Teachers’ version IGCSE – May/June 2010
Slide 5 Answer 4 Answer 5
Printed
2 slides per page
Syllabus 0417
Paper 03
Space between text and cell wall Inside/in table/cell Interchange cell wall and border Space between Walls of 2 adjacent cells Interchange cell wall and border
1 mark 1 mark
1 mark
© UCLES 2010
1 mark 1 mark
Page 9 Destination
Lookup used Lookup or Vlookup Correct lookup reference Do not allow range Lookup – relative reference Correct range Including filename Range – absolute reference Check range works Destination Correct return column Award if visible and Lookup used =VLOOKUP(B2,JXDEST.csv!$A$2:$B$11,2,0) Check first row =VLOOKUP(B3,JXDEST.csv!$A$2:$B$11,2,0)
=VLOOKUP(B4,JXDEST.csv!$A$2:$B$11,2,0) =VLOOKUP(B5,JXDEST.csv!$A$2:$B$11,2,0) =VLOOKUP(B6,JXDEST.csv!$A$2:$B$11,2,0) =VLOOKUP(B7,JXDEST.csv!$A$2:$B$11,2,0) =VLOOKUP(B8,JXDEST.csv!$A$2:$B$11,2,0) Month January February March April May June July August September October November December Footer
name and numbers
Mark Scheme: Teachers’ version IGCSE – May/June 2010 1 mark
Syllabus 0417 Trips
1 mark 1 mark 1 mark
Paper 03 COUNTIF function Correct range Check range works Range – absolute reference Correct lookup Lookup – relative reference
1 mark 1 mark 1 mark 1 mark 1 mark
1 mark 1Code mark
BAH COZ EGY IND MAL SRI THA
Mcode 1 2 3 4 5 6 7 8 9 10 11 12
Trips =COUNTIF($D$25:$D$98,B2) =COUNTIF($D$25:$D$98,B3) =COUNTIF($D$25:$D$98,B4) =COUNTIF($D$25:$D$98,B5) =COUNTIF($D$25:$D$98,B6) =COUNTIF($D$25:$D$98,B7) =COUNTIF($D$25:$D$98,B8) Days =SUMIF($B$25:$B$98,B11,$F$25:$F$98) =SUMIF($B$25:$B$98,B12,$F$25:$F$98) =SUMIF($B$25:$B$98,B13,$F$25:$F$98) =SUMIF($B$25:$B$98,B14,$F$25:$F$98) =SUMIF($B$25:$B$98,B15,$F$25:$F$98) =SUMIF($B$25:$B$98,B16,$F$25:$F$98) =SUMIF($B$25:$B$98,B17,$F$25:$F$98) =SUMIF($B$25:$B$98,B18,$F$25:$F$98) =SUMIF($B$25:$B$98,B19,$F$25:$F$98) =SUMIF($B$25:$B$98,B20,$F$25:$F$98) =SUMIF($B$25:$B$98,B21,$F$25:$F$98) =SUMIF($B$25:$B$98,B22,$F$25:$F$98)
1 mark
Candidate name Centre number candidate number © UCLES 2010
Days
Correct SUMIF function 1 mark Correct range 1 mark Check range works Range – absolute reference 1 mark Lookup – relative reference 1 mark Correct range 1 mark Check range works Range – absolute reference 1 mark Other functions like SUMIFS may be used
Replication Formulae, data and labels Orientation Print area
All 3 formulae Fully visible Landscape Selected data only
1 mark 1 mark 1 mark 1 mark
Page 10
Mark Scheme: Teachers’ version IGCSE – May/June 2010
Destination Bahamas Cozumel Egypt India Maldives Sri Lanka Thailand
Code BAH COZ EGY IND MAL SRI THA
Month January February March April May June July August September October November December
Mcode Days 1 28 2 31 3 42 4 69 5 104 6 80 7 77 8 55 9 83 10 66 11 125 12 70
Day 27 14 21 2 10 27 28 21 2 16 18 4 11 3 5 3 1 19 23 5 1 23
Month 9 8 8 8 5 5 9 4 12 5 11 7 3 4 6 10 6 6 11 7 6 12
Trips 7 7 16 13 11 8 12
Year 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010
Syllabus 0417
Row 1, 10, 24 Centre aligned Only three rows shown Bold and italic Orientation Portrait
DCode EGY MAL THA COZ SRI BAH IND IND COZ EGY SRI EGY THA COZ COZ IND MAL THA SRI THA EGY MAL
Discount Duration Y 10 N 14 N 7 Y 10 Y 14 N 21 N 14 N 10 Y 14 Y 14 Y 21 Y 7 N 7 Y 14 Y 7 N 14 N 14 N 14 N 14 Y 14 N 14 Y 7 © UCLES 2010
1 mark 1 mark 1 mark
Paper 03
Page 11 21 14 1 3 17 2 14 31 7 15 17 21 29 5 23 29 29 27 18 28 3 19 19 4 12 4 30 26 10 29 26 7 7 14 5 25 14 12 11 5 22 23 24 20 4 19 13
Mark Scheme: Teachers’ version IGCSE – May/June 2010 10 11 3 1 9 5 8 7 5 5 8 1 12 11 11 9 0 10 8 7 10 0 3 6 4 11 5 9 4 9 10 11 12 12 6 5 7 2 1 3 7 4 12 2 11 10 9
2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010
IND MAL BAH COZ THA SRI THA THA EGY EGY SRI BAH MAL THA MAL IND EGY BAH IND BAH MAL EGY BAH EGY SRI EGY IND IND MAL EGY IND MAL THA IND COZ EGY SRI IND EGY THA IND IND THA THA MAL EGY EGY
N N Y Y N N Y Y N Y Y N Y Y Y Y N Y Y Y N Y N Y Y Y N N Y Y N Y N N N Y Y Y Y N N Y Y Y N N N
14 10 7 14 14 10 7 14 7 14 7 7 14 21 14 7 14 7 10 14 10 10 14 21 10 14 14 14 14 10 14 14 14 7 10 10 14 14 7 14 7 14 14 7 10 7 7 © UCLES 2010
Syllabus 0417
Paper 03
Page 12 17 29 20 30 15
DCode EGY EGY EGY EGY EGY EGY EGY EGY EGY EGY EGY
Mark Scheme: Teachers’ version IGCSE – May/June 2010 9 4 2 11 7
2010 2010 2010 2010 2010
Discount Duration Y 10 Y 14 Y 7 Y 14 Y 10 Y 21 Y 14 Y 10 Y 10 Y 7 Y 7
MAL EGY COZ SRI BAH
Y Y N Y Y
Syllabus 0417
7 7 10 7 7
Search Rows Columns
DCode = EGY and Discount = Y 1–23 hidden A, B, C Hidden
© UCLES 2010
1 mark 1 mark 1 mark 1 mark
Paper 03