UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS International General Certificate of Secondary Education

INFORMATION AND COMMUNICATION TECHNOLOGY Paper 3 Practical Test

0417/03
May/June 2010 2 hours 30 minutes

Additional Materials:

Candidate Source Files

*5230304889*

READ THESE INSTRUCTIONS FIRST Make sure that your Centre number, candidate number and name are clearly visible on every printout, before it is sent to the printer. Printouts with handwritten information will not be marked. Carry out every instruction in each step. Steps are numbered on the left hand side of the page. On the right hand side of the page for each step, you will find a box which you can tick ( ) when you have completed it; this will help you track your progress through the test. Before each printout you should proof-read the document to make sure that you have followed all instructions carefully. At the end of the test put all your printouts into the Assessment Record Folder. If you have produced rough copies of printouts, these should be neatly crossed through to indicate that they are not the copy to be marked.

This document consists of 6 printed pages.
IB10 06_0417_03/RP © UCLES 2010

[Turn over

2 You work for a company called Hothouse Design. You are going to create a new website for a client called The Relaxing Holiday Company. This website must open in any browser with any screen resolution. The homepage will have three separate tables and look like this:

1

Download the following files from http://www.hothouse-design.co.uk/2010XJune to your own work area: JXBOTTOM.HTM JXBUBBLE.JPG JXDEST.CSV JXFOOTER.JPG JXHARBOUR.JPG JXIMG1.JPG JXIMG2.JPG JXIMG3.JPG JXIMG4.JPG JXIMG5.JPG JXIMG6.JPG JXPRES.RTF JXSEA.HTM JXSHEET.CSV JXSTYLES1.CSS JXSTYLES2.CSS JXTEXT.TXT JXTITLE.JPG JXTOP.HTM

2

Using a suitable software package, create a new webpage called JXRHC.HTM Attach the stylesheet JXSTYLES1.CSS to this webpage.

© UCLES 2010

0417/03/M/J/10

3

3 4 5 6 7 8 9 10 11

Create the top table using the contents of JXTOP.HTM Set the table width to 100% of the width of the window. At the top of the page create an anchor called START Replace the text candidate name, Centre number, candidate number with your name, Centre number and candidate number. Create the middle table with 3 rows and 2 columns as shown in the diagram on the previous page. Set the table width of the middle table to 90% of the width of the window. Align the middle table with the centre of the window, as shown in the diagram. Place the image JXHARBOUR.JPG in the left cell of the middle table. Use the contents of the file JXTEXT.TXT to place the following text, as style h3, in the middle table: • Place the text We offer holidays to suit your every need. We can often make dreams come true. in the top right cell. • Place the text 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. in the middle right cell. • Place the text Combine our service with superb value for money. Contact us with your requirements and we are sure that we will not disappoint you. in the bottom right cell. Make sure that the styles which are in the stylesheet are not over-ridden. Create the bottom table using the contents of JXBOTTOM.HTM Set the table width of the bottom table to 100% of the width of the window. Replace the text Place anchor here with an anchor called SNOWZONE This anchor must not be visible on the page. Create a hyperlink from the word Snow in the top table to the anchor that you have just created. Make only the words Click Here a hyperlink to the anchor called START Select the most appropriate image from those obtained in step 1 and use this to replace the word Sun in the bottom table. Select the most appropriate image from those obtained in step 1 and use this to replace the word Sea in the bottom table. Select the most appropriate image from those obtained in step 1 and use this to replace the word Sand in the bottom table. Select the most appropriate image from those obtained in step 1 and use this to replace the words Contact us in the bottom table. Set the width of each of the images placed in steps 17 to 20 to 160 pixels wide and maintain the aspect ratio. Create a hyperlink from the image placed in step 18 to point to the file JXSEA.HTM which should open in a new window called _sea Create a hyperlink from the image placed in step 20 to send an e-mail to RHC@cie.org.uk
0417/03/M/J/10

12 13 14 15 16 17 18 19 20 21 22 23

© UCLES 2010

[Turn over

4

24 25 26

Save the webpage as JXRHC1.HTM Print a copy of the HTML source. Attach the stylesheet JXSTYLES2.CSS to this webpage. Save the webpage as JXRHC2.HTM Open this page in your web browser. Print screenshot evidence of this page. You may use more than one printout to make sure that the entire page is visible. Open the webpage JXSEA.HTM Attach the stylesheet JXSTYLES2.CSS to this webpage. Make the text Home a link to JXRHC2.HTM Save the webpage.

27 28 29 30

You are going to create a short presentation for the manager of The Relaxing Holiday Company about the website. 31 Import the file JXPRES.RTF placing the text as slides in your presentation software. Remove any blank slides. (This should provide four slides, each containing a title and some bullet points.) Save the presentation. 32 The master slide must have: • a white background • your Centre number, candidate number and name in a 12 point black serif font in the top right corner • a clipart image of the sun as a logo in the bottom right corner • slide numbers in the bottom left corner. Insert a new slide before slide 1. Use a layout with a title and subtitle for the new slide. Enter the text New website for as a subtitle for the slide. Enter the text The Relaxing Holiday Company as the title for the slide. Move this title so that it is below the subtitle. 35 36 37 Explain why the background image in JXSTYLES1.CSS does not work. Give your answer by replacing the text Answer 1 here on slide 4. On slide 4 replace the text Answer 2 here with only the html code in the stylesheet JXSTYLES1.CSS that makes the background colour of the page visible. The stylesheet should have set h1 and h2 to white and h3 to yellow. Explain why the text for styles h1 and h2 is not white and h3 is not yellow. Give your answer by replacing the text Answer 3 here. Describe what cell padding in html coding is. Give your answer by replacing the text Answer 4 here on slide 5. Describe what cell spacing in html coding is. Give your answer by replacing the text Answer 5 here on slide 5. On all slides make sure that no objects overlap any of the master slide items. Save the presentation using a new filename. Print the presentation with two slides on each page.

33 34

38 39 40 41

© UCLES 2010

0417/03/M/J/10

5

Your manager has asked you to manipulate a spreadsheet about some holiday bookings. 42 43 44 Using a suitable software package, load the file JXSHEET.CSV Place your name, candidate number and Centre number in the footer. In the Destination column use a lookup function to show the destination name. Use the Code column for the lookup value and the file JXDEST.CSV for the array. This function must include both absolute and relative referencing and must not use a named range. Replicate this function so that the destination name is shown for each of the codes. 45 In cell C2 use a function to count the number of trips to the destination where the value in the Dcode column matches the contents of cell B2. This function must include both absolute and relative referencing and must not use a named range. Do not count any entries in rows 1 to 24. Replicate this function into cells C3 to C8 to calculate the number of trips booked to each of the other destinations. 46 In cell C11 use a function to add the total number of days (using the Duration column) for holidays starting in the month of January. This function must include both absolute and relative referencing and must not use a named range. Replicate this function into cells C12 to C22 to calculate the total number of days booked for the other months in 2010. 47 48 Set the page orientation to landscape. Save the data model and print a copy of the cells A1 to C22 only, showing the formulae used. Make sure that the contents of all cells in this range are visible and that the printout fits on a single page wide. Make sure that your name, candidate number and Centre number are printed in the footer of the page. 49 50 51 52 Format only the cells in rows 1, 10 and 24 to be centre aligned. Format only the cells in rows 1, 10 and 24 so that they are bold and italic. Set the page orientation to portrait. Save the data model and print all of the sheet showing the values. Make sure that the contents of all cells are visible and that the printout is one page wide. Make sure that your name, candidate number and Centre number are printed in the footer of the page. 53 54 55 Hide rows 1 to 23 inclusive. Hide columns A, B and C. Interrogate the data, to find all the bookings where the country is Egypt and the discount is yes. Print this data. Make sure that your name, candidate number and Centre number are printed in the footer of the page.

© UCLES 2010

0417/03/M/J/10

[Turn over

6 After the examination time – on the html printouts of your webpage Highlight those portions of the code which show that: • • • • • • • • • • your name, Centre number and candidate number are present on all printouts the external style sheet is attached to the webpage the top and bottom tables have a width of 100% the middle table has a width of 90% the anchor Start has been placed the anchor Snowzone has been placed the hyperlink from the text ‘Snow’ links to the anchor ‘Snowzone’ the hyperlink from the text ‘Click here’ links to the anchor ‘Start’ the hyperlink from the sea image opens JXSEA.HTM in a new window called _sea the hyperlink from the ‘Contact us’ image sends an e-mail to RHC@cie.org.uk

Permission to reproduce items where third-party owned material protected by copyright is included has been sought and cleared where possible. Every reasonable effort has been made by the publisher (UCLES) to trace copyright holders, but if any items requiring clearance have unwittingly been included, the publisher will be pleased to make amends at the earliest possible opportunity. University of Cambridge International Examinations is part of the Cambridge Assessment Group. Cambridge Assessment is the brand name of University of Cambridge Local Examinations Syndicate (UCLES), which is itself a department of the University of Cambridge.

© UCLES 2010

0417/03/M/J/10