0417_s11_qp_31 | Web Page

Please download to get full document.

View again

of 8
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Documents

Published:

Views: 246 | Pages: 8

Extension: PDF | Download: 2

Share
Related documents
Description
UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS International General Certificate of Secondary Education *7199891253* INFORMATION AND COMMUNICATION TECHNOLOGY Paper 3 Practical Test 0417/31 May/June 2011 2 hours 30 minutes Additional Materials: Candidate Source Files READ THESE INSTRUCTIONS FIRST Make sure that your Centre number, candidate number and name are written at the top of this page and are clearly visible on every printout, before it is sent to the printer. Printouts with hand
Transcript
    This document consists of  6 printed pages and 2 blank pages. IB11 06_0417_31/4RP© UCLES 2011 [Turn over          *                 7                 1                 9                 9                 8                 9                 1                 2                 5                 3                *             UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONSInternational General Certificate of Secondary Education INFORMATION AND COMMUNICATION TECHNOLOGY 0417/31  Paper 3 Practical Test May/June 20112 hours 30 minutes Additional Materials: Candidate Source Files READ THESE INSTRUCTIONS FIRST Make sure that your  Centre number  , candidate number  and name are written at the top of this page andare clearly visible on every printout, before it is sent to the printer. Printouts with handwritten information will not be marked.DO NOT WRITE IN ANY BARCODES.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.At the end of the exam put this Question Paper  and 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 theyare not the copy to be marked.  2   © UCLES 2011 0417/31/M/J/11    1 Create a new word processed document. Save this with the filename EVIDENCE2 Place your name, Centre number and candidate number in the header of this document. You work for a company called RockICT. You are going to manipulate a spreadsheet about the performance of athletes in the Shot Putt as they prepare for the 2012 Olympic games. 3 Using a suitable software package, load the file J1GAMES.CSV   4 Place your name, candidate number and Centre number in the header.Place the automated file name and file path in the footer. 5 Search the internet to find the current Olympic record holders for the men’s andwomen’s Shot Putt.For each of these records, find the: ã athlete’s name ã country that they represented ã distance thrown in metres to 2 decimal places ã year the record was set ã name of the city hosting the Olympic games in that year.Place this information in cells B3 to F4 of the spreadsheet. 6 Print only cells A1 to F4. Make sure that your name, Centre number and candidatenumber are printed in the header of the page. 7 In cell A8 use a lookup function to show the country name in full. Use the Code columnfor the lookup value and the file J1COUNTRY.CSV for the array. This function mustinclude both absolute and relative referencing and must not use a named range.Replicate this function so that the country name is shown in full for each athlete. 8 In cell K8 use a function to select and display the longest of the 6 throws made by theathlete.Replicate this function so that the best throw is shown for each athlete. Because athletes sometimes miss a throw or throw outside the area, this is recorded in thespreadsheet as a no throw using the letters NT. 9 In cell L8 use a function to add the distances of all the throws for this athlete. Ensurethat the function does not include the distance if it is recorded as NT (a no throw).Replicate this function so that the total distance thrown is shown for each athlete. 10 In cell M8 use a function to count the number of throws that were NOT recorded as NT.Replicate this function so that the number of throws that were NOT recorded as NT isshown for each athlete.  3   © UCLES 2011 0417/31/M/J/11 [Turn over       11 In cell N8 calculate the average throw length for only the throws where a distance wasrecorded. Use the contents of cells L8 and M8 to help you.Round this value to 1 decimal place.Replicate this function so that the average throw length is shown for each athlete. 12 In cell O8 use a formula to display the word  Yes if the athlete’s longest throw breaks theOlympic record or display the word No if it does not. (Remember that there are tworecords, one for men and one for women.)Replicate this formula so that this is automatically displayed for each athlete. 13 Right align all cells in columns D to O inclusive. 14 Set the page orientation to landscape. 15 Save the data model with the filename ATHLETES   16 Hide columns B to J. 17 Print the spreadsheet showing the formulae used. Make sure that the contents of allthese cells are visible and that the printout fits on two pages wide. Make sure that therow and column headings are visible when printed.Make sure that your name, Centre number and candidate number are printed in theheader of the page. 18 Make all data in columns A to O fully visible. 19 Select only the athletes where the Country  is Great Britain .Use the athletes’ names and the average distance that each of these athletes throwsthe shot to create a vertical bar chart. 20 Label this chart with the title Average distance for British athletes   21 Make sure that category axis labels show the names of the athletes and these are fullyvisible. 22 Print this chart. Save this using the filename CHART  Make sure that your name, candidate number and Centre number are printed with thischart. 23 Open the spreadsheet saved in step 15. 24 Hide columns L and M. 25 Format only the cells in rows 6 and 7 so that they are bold, italic and centre aligned.  26 Interrogate the data to find all the athletes who have broken the current Olympic record. 27 Sort this data into descending order of  Gender  , then into descending order on the Best throw  column, showing the values and labels in full (except columns L and M). 28 Print this data showing the values.Make sure that your name, Centre number and candidate number are printed in theheader of the page.  4   © UCLES 2011 0417/31/M/J/11 You are going to edit a webpage and manipulate the objects within it.    29 Create a new folder called WEBSITE in your work area.Download the following files from http://www.RockICT.net/2011June into your  WEBSITE    folder: J1ATH1.HTMJ1ATHLETIC1.GIFJ1BANNER.JPGJ1BG1.JPGJ1BG4.JPGJ1IMG1.JPGJ1IMG2.JPGJ1IMG3.JPGJ1IMG4.JPGJ1IMG5.JPGJ1IMG6.JPGJ1IMG7.JPGJ1IMG8.JPGJ1IMG9.JPGJ1IMG10.JPGJ1SHOT.HTMJ1SHOT.JPGJ1STYLE1.CSSJ1STYLE2.CSSJ1STYLE3.CSSJ1STYLE4.CSSJ1STYLE5.CSS30 Open the image J1BG1.JPG in a suitable application.(You will manipulate this image to create the background image which will be used in astylesheet.) 31 Resize the image so that it is 800 pixels wide and maintain its aspect ratio. Take ascreenshot to show how you resized the image. Place this in the evidence documentyou created in step 1.Save this image as J1BG2.JPG in your  WEBSITE  folder. 32 Reduce the image resolution, if necessary, to ensure that the stored image is no larger than 100kb.Save the image as J1BG3.JPG in your  WEBSITE  folder.Show screenshot evidence of the file size of these images in your evidence document. 33 Open the image J1ATHLETIC1.GIF in a suitable application. 34 Flip the image so that the athlete faces the left side of the page. Save this image as J1ATHLETIC2.JPG in your  WEBSITE  folder.  35 Using a suitable software package, open the file J1SHOT.HTM
Recommended
9702_s11_qp_31

9702_s11_qp_31

12 pages

9706_s11_qp_31

9706_s11_qp_31

12 pages

9708_s11_qp_31

9708_s11_qp_31

12 pages

9691_s11_qp_31

9691_s11_qp_31

16 pages

9713_s11_qp_31

9713_s11_qp_31

20 pages

9700_s11_qp_31

9700_s11_qp_31

12 pages

5070_s11_qp_31

5070_s11_qp_31

8 pages

9707_s11_qp_31

9707_s11_qp_31

8 pages

9701_s11_qp_31

9701_s11_qp_31

12 pages

View more...
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks