# ict igcse practical paper

UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS General Certificate of Education Advanced Subsidiary Level and Advanced Level .c rs om *3393483587* APPLIED INFORMATION AND COMMUNICATION TECHNOLOGY Paper 2 Practical Test 9713/02 October/November 2010 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. DO NOT WRITE IN ANY BARCODES. Carry out every instruction in each task.

Use a spreadsheet to analyse the production dates for these advertisements. 8 Using a suitable software package, load the file NXJOBS. CSV 9 Insert a new row 8 and in cell A8 add the text Project 6 10 Replace the word Advertisement with the word Project wherever it appears in the spreadsheet. [2] [1] [3] [8] [37] [3] [1] © UCLES 2010 9713/02/O/N/10 3 11 In cell B3 enter the date 28th November 2010. In cell B4 enter the date 16th October 2010. In cell B5 enter the date 2nd November 2010. In cell B6 enter the date 30th November 2010. In cell B7 enter the date 1st December 2010.

In cell B8 enter the date 2nd December 2009. 12 Delete row 2 from the spreadsheet. 13 Embolden all cells in row 1 and all cells in column A. 14 In cell C2 use a function to extract the day as a numeric value from cell B2. 15 In cell D2 use a function to extract the month as a numeric value from cell B2. 16 In cell E2 use a function to extract the year as a numeric value from cell B2. 17 In cell J2 calculate the end date for the project using the start date and the number of days it will take for planning, design, creation and installation. 18 Replicate the formulae used in steps 14 to 17 for all projects. 9 In cell J7 change the date to 23rd July 2010. 20 Format all the date cells in columns B and J into the format dd/mm/yy. 21 Insert a formula in cell K2 which uses the file NXMONTH. CSV to look up the season from the Start date and adds this to the date. For example: 01/01/2010 will be displayed as 01 January 2010 (Winter) 22 In cell L4 use a formula to calculate the difference in months, between the start date and the end date. Replicate this formula for all projects. 23 In cell A10 use a formula to count the number of projects that start in Winter. 4 Create a header which says Planning time for projects and a footer which contains your name, Centre number and candidate number. 25 Save and print your spreadsheet, adjusting the page layout if necessary so that the whole table fits on a single page. Make sure that the contents of all cells are fully visible.

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 9713/02/O/N/10

## Calculate the price of your order

Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee