0417_w14_qp_3 | 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: 11 | Pages: 8

Extension: PDF | Download: 0

Share
Related documents
Description
ict paper 3
Transcript
  This document consists of 5  printed pages and 3  blank pages. DC (AC) 88637/3 © UCLES 2014 [Turn over Cambridge International Examinations Cambridge International General Certificate of Secondary Education *  32 8 61 84 5 32*  INFORMATION AND COMMUNICATION TECHNOLOGY   0417/03 Paper 3 Practical Test October/November 2014   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 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 they are not  the copy to be marked.   w  w  w  . X   t  r  e  m  e  P  a   p  e  r  s  . c  o  m    2 0417/03/O/N/14 © UCLES 2014    1 Create a new word processed document. Make sure your name, Centre number and candidate number will appear on every page of this document.   Save this evidence document in your work area as N14EVIDENCE  followed by your candidate number. For example, N14EVIDENCE9999. You will need this file later. 2 Locate and download the following files from the website  http://www.hothouse-design.co.uk/tawara-cycles  Place these in your user area:  N14031.jpg N14032.jpg N14033.jpg N14cost.csv N14invoice.csv N14roadbike.htm N14tc.htm N14title.png N14type.csv You are going to prepare a spreadsheet for Tawara Cycles, which will be an invoice to send to a customer. This invoice has 5 items that have been ordered.The contents of this invoice may change. Make sure your formulae will work if the data changes.Display all currency values in dollars with 2 decimal places. 3 Using a suitable software package, load the file N14invoice.csv Save this file as a spreadsheet. 4 Merge cells A1 to F1 so they become a single cell.   Format the text in this cell so it is a white 16  point serif font. Format this cell so that it is centre aligned and has a dark grey background. 5 Format cells F2 to F6 so that they are right aligned.  6 In cell A9 replace the text Candidate details here with your name, Centre number and candidate number. 7 In cell B11 use a function to count the number of item codes in this invoice.  8 In cell B12 use a function to calculate the total number of Units   in this invoice.  9 Copy the contents of the file N14type.csv  into cells A30 to B39 of your invoice.  10 Use the cells A31 to B39 to create a named range called Type Show evidence of the creation of this named range in your evidence document. 11 Hide rows 30 to 39.    3 0417/03/O/N/14 © UCLES 2014 [Turn over12 In cell C20 use a formula to look up the type of cycle. Use the first character of the  Item Code   as the single lookup value and the named range Type   for the array.  13 In cell D20 use a function to look up the Unit Cost of the cycle. Use the Item Code   as the single lookup value and file N14cost.csv  for the array. This function must include both absolute and relative referencing and must not include a named range. 14 In cell F20 calculate the total cost for this item.  15 Replicate the formulae entered in steps 12, 13 and 14 for each item.  16 In cell F26 use a function to calculate the sum of the Item Total column, which will be the invoice Sub total   before any discount is applied.   The company offers discounts to customers based on the number of units they order. 17 In cell F27 use a formula to calculate the discount using the Sub total  , Number of units   and the three  discount rates A, B and C.   Multiply the Sub total   by:   ã Discount A if less than 5 units are sold   ã Discount B if between 5 and 19 (inclusive) units are sold   ã Discount C if 20 or more units are sold. 18 In cell F28 use a formula to calculate the  Invoice total   which is the Sub total   less the Discount amount  .  19 Apply appropriate formatting to all numeric cells.  20 On the left in the header enter the text  Invoice date : followed by a space and then the automated date.   On the right in the header enter the text  Invoice time : followed by a space and then the automated time. 21 Save and print the spreadsheet showing formulae. Make sure:   ã it is in landscape orientation   ã the row and column headings are displayed   ã the printout fits to two pages wide   ã the contents of all cells (except those hidden in step 11) are fully visible. 22 Print the invoice showing the values. Make sure:   ã the printout fits on a single portrait page ã the contents of all cells (except those hidden in step 11) are fully visible. 23 The customer has changed one item in the order. Instead of 5 Roadster 3 cycles,   they now require 10. Update the invoice. 24 Save and print the invoice showing the values. Make sure:   ã the printout fits on a single portrait page   ã the contents of all cells (except those hidden in step 11) are fully visible.  4  © UCLES 20140417/03/O/N/14 Your manager would like to see the effects of changing the discount on this invoice.  25 Change the Discount percentage rates to:   ã Discount A 7%  ã Discount B 12%  ã Discount C 18%26 Save and print the invoice showing the values. Make sure:   ã the printout fits on a single portrait page ã the contents of all cells (except those hidden in step 11) are fully visible. Tawara Cycles has a website which is currently being updated. The owners have decided that a new stylesheet will be developed and attached to each web page. You will create the stylesheet to meet their requirements.All colour codes must be in hexadecimal. 27 Create a new stylesheet in a suitable package. 28 Set the stylesheet so that each table has:   ã a yellow background colour   ã a width of 80% of the window   ã navy blue solid borders   ã collapsed borders   ã external borders of 4 pixels   ã internal gridlines of 2 pixels   ã cell padding to the top and bottom of 10 pixels ã cell padding to the left and right of 20 pixels ã text centre aligned in all cells. 29 Add the text Stylesheet for table styles  to your stylesheet as a comment.  30 Add your name, Centre number and candidate number to your stylesheet as a comment.  31 Save your stylesheet as N14table.css 32 Place a copy of your stylesheet in your evidence document.  33 Using a suitable software package, open the file N14tc.htm 34 Attach the stylesheet saved in step 31 to this web page.  35 Replace the text Place candidate details here   with your name, Centre number and candidate number. 36 Use the image placed in the left column (the road bike image) to create a hyperlink to a new web page called roadbike.htm  which will open in a new window called _  road  
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