0417_s16_qp_32 | Spreadsheet | 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: 243 | Pages: 8

Extension: PDF | Download: 0

Share
Related documents
Description
IGCSE PAST PAPERS
Transcript
  This document consists of 7  printed pages and 1  blank page. DC (NH) 128275/4 R  © UCLES 2016 [Turn over * 942 3 82 62 5 0* INFORMATION AND COMMUNICATION TECHNOLOGY   0417/32 Paper 3 Data Analysis and Website Authoring May/June 2016   2 hours 30 minutes Additional Materials: Candidate Source Files READ THESE INSTRUCTIONS FIRST Write your name, Centre number and candidate number in the spaces at the top of this page.Write in dark blue or black pen.Do not use staples, paper clips, glue or correction fluid.DO NOT  WRITE IN ANY BARCODES.Carry out all  instructions in each step. You can track your progress through the examination by crossing out each question number.Enter your name , Centre number and candidate number  on every printout before it is sent to the printer. Printouts with handwritten candidate details on will not  be marked.At the end of the examination put this  Question Paper and all your printouts into the Assessment Record Folder.If you have produced rough copies of printouts, put a neat cross through each one to indicate that it is not  the copy to be marked.The number of marks is given in brackets [ ] at the end of each question or part question.Write today’s date in the box below. Cambridge International Examinations Cambridge International General Certificate of Secondary Education The syllabus is approved for use in England, Wales and Northern Ireland as a Cambridge International Level 1/Level 2 Certificate.  2 0417/32/M/J/16 © UCLES 2016 Task 1 – Evidence Document ã Open the file 1632evidence.rtf ã Make sure your name, Centre number and candidate number will appear on every page of your Evidence Document by placing these details in the header.ã Save this Evidence Document as a word processed document in your work area as 1632evidence  followed by your candidate number. For example, 1632evidence9999You will need your Evidence Document during the examination to enter answers to questions and to place your screenshots in when required. Task 2 – Spreadsheet You are going to prepare a spreadsheet for the Goa Elephant Sanctuary to manage employees’ wages. Use the most efficient formulae. Display all currency values in Indian rupees to 2 decimal places. For example,   12.00 or INR 12.00 1 rupee = 100 paisa  1   ã  Using a suitable software package, load the file 1632sheet.csv   ã  Save this file as a spreadsheet with the file name 1632_  and your Centre number and candidate number. For example, 1632_ZZ999_9999  ã  Place an automated file name which includes the file path, on the left in the footer. [1] 2   ã  Insert 2 new rows between rows 12 and 13. [1] 3   ã  In cell A14 enter the title Goa Elephant Sanctuary [1] 4   ã  Merge cells A14 to H14.  ã  Format this cell so that the text is centre aligned with a black, 24 point, serif font. [3] 5   ã  Make the contents of cells in rows 1, 2, 15 and 16 bold and italic. [1] 6   ã  In cell D17 enter a function to look up, from the external file 1632jobs.csv  the job description of the employee. [6] 7   ã  In cell E17 enter a function to: look up from the Pay grade table the annual Pay rate   for this employee multiply this by the value in the Works   column. [5] 8   ã  In cell G17 enter a formula to display:  Full time  if the Works   column contains 1  Not started  if the Works   column contains 0  Part time  if not 0 or 1. [7] 9   ã  In cell H17 enter a formula to calculate the weekly wage in rupees, rounded down to the nearest paisa. 1 rupee = 100 paisa.   1 year = 52 weeks. [2] 10   ã  Replicate the formulae entered in steps 6, 7, 8 and 9 for each employee. [1]  3 0417/32/M/J/16 © UCLES 2016 [Turn over11   ã  In cell H48 enter a function to add the total weekly wage bill. [1] 12   ã  Apply appropriate formatting to all cells. [1] 13   ã  Sort the weekly wage table into descending order of Annual salary then ascending order of  Job description  .   [2] 14   ã  Save and print the spreadsheet showing the formulae. Make sure: your name, Centre number and candidate number are entered in an appropriate place on your spreadsheet it is in landscape orientation the row and column headings are displayed the contents of all cells are fully visible. [2] PRINTOUT 1 Make sure that you have entered your name , Centre number and candidate number  on your spreadsheet showing the formulae. 15   ã  Print the spreadsheet showing the values. Make sure the: printout fits on a single page contents of all cells are fully visible. [1] PRINTOUT 2 Make sure that you have entered your name , Centre number  and candidate   number  on your spreadsheet showing the values. 16   ã  Change the data so that: Orrjit Dutta works 0.6  of a week Rujul Rangan works full time  Pravar Subramanium works 0.8  of a week. [2] 17   ã  Save and print the spreadsheet showing the values. Make sure the: printout fits on a single page contents of all cells are fully visible. [1] PRINTOUT 3 Make sure that you have entered your name , Centre number  and candidate   number  on your spreadsheet showing the values. [Total: 38]  4 0417/32/M/J/16 © UCLES 2016 Task 3 – Web Page You are going to help develop a website for the Goa Elephant Sanctuary to raise awareness of the project. Viewers of the website may have slow internet connection, so efficient markup must be used.  ã Create a new folder called 1632_html  ã Locate the following files and place them in your 1632_html  folder.  1632img1.jpg 1632img2.jpg 1632img3.jpg 1632img4.jpg 1632img5.jpg 1632img6.jpg 1632img7.jpg 1632img8.jpg 1632logo.jpg18   ã  Create a web page called 1632ges.htm  This web page must work in all browsers and will have a table structure as shown below. Each table cell is identified with a letter and all dimensions are in pixels:A736 × 172B184 × 140C184 × 140D184 × 140E184 × 140F184 × 140G184 × 140H184 × 140 I 184 × 140J736 × 140 Table borders and the letters shown in the table must not  appear on your final web page. [8] 19   ã  Place in cell A the image 1632logo.jpg   ã  Resize this image to 730 pixels wide, maintaining its aspect ratio. [2]
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