
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

GCE MAY 2008 : (AS 2) Software Applications and Tools

16 pages, 20 questions, 0 questions with responses, 0 total responses,

	gce	+Fave Message
	Profile Timeline Uploads Q & A

Home > gce >

Instantly get Model Answers to questions on this ResPaper. Try now!
NEW ResPaper Exclusive!

Formatting page ...

Centre Number 71 Candidate Number ADVANCED SUBSIDIARY (AS) General Certificate of Education 2008 Number of printouts attached (to be completed at the end of the examination) Assessment Unit AS 2 assessing A3J21 Applied Information and Communication Technology Unit 2: Software Applications and Tools [A3J21] MONDAY 19 MAY FRIDAY 23 MAY TIME 2 hour 30 minutes. INSTRUCTIONS TO CANDIDATES Write your Centre Number and Candidate Number in the spaces provided at the top of this page. Save each document using the name specified in each task. Always add your Candidate Number, Centre Number, Question Number and Printout Label to every printout produced. All printouts may be labelled by hand. All printouts must be attached to the examination paper at the end of the examination in the correct order. Use the treasury tag provided to attach your printouts to the examination paper. You may not take the examination paper with you. INFORMATION FOR CANDIDATES The total mark for this paper is 100. Figures in brackets printed down the right-hand side of pages indicate the marks awarded to each question or part question. In order to complete this examination you should have access to the following: supersavers08_June.mdb supersavers08_June.xls images08_June folder supersavers08_June.ppt 4581 For Examiner s use only Marks Question available DB1 DB2 DB3 DB4 DB5 DB6 DB7 SS1 SS2 SS3 SS4 SS5 WP1 WP2 WP3 WP4 WP5 WP6 MM1 MM2 5 3 3 2 7 4 9 10 4 4 7 7 3 2 2 6 6 8 3 5 Total 100 Marks Remark A database has been set up called supersavers08_June.mdb Examiner Only Marks Remark Open the database and examine the relationships between the tables. In January 2008, the committee of Supersavers decided to run a raffle to raise funds for the refurbishment of their building. Tickets would be priced at 100 each. Members would be allowed to purchase a maximum of three tickets. Tickets could be paid for in one lump sum or by instalments before the end of May. The raffle was scheduled to take place at the end of June. In order to store data relating to tickets and payments, two additional tables have been added to the database. Task DB1 Payments for tickets will be collected by collectors during their regular visits. Open the TICKET PAYMENT table in design view and create a new field as follows: Field Name Payment Method Data Type Text Field Size 6 The new field should be positioned after the Amount field in the table design. Create a validation rule for the Payment Method field to ensure that payments can only be cash or cheque. Print a screenshot of the design of the TICKET PAYMENT table showing clearly the fieldname and lookup tab of the new field you have added. Label the printout TICKETPAYMENTDESIGN. Close the TICKET PAYMENT table and save the changes. [5] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4581 2 [Turn over Task DB2 Examiner Only Marks Remark Payments for tickets will only be accepted between the 1st of February 2008 and the 31st May 2008. Create a validation rule for the Date field in the TICKET PAYMENT table to ensure that payments will only be accepted if they are within the specified range. Add appropriate validation text. Produce a screenshot showing the validation rule and validation text you have entered. Save the screenshot as VALIDATION. Print VALIDATION. Label the printout VALIDATION. Close the TICKET PAYMENT table and save the changes. [3] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. Task DB3 To test your validation, open the TICKET PAYMENT table and add the following record: Ticket Payment Ref: Ticket No: Amount: Payment Method: Date: 35 6 10 Cash 10/06/2008 Produce a screenshot which shows that the data has been entered as shown and that a validation rule has worked. Save the screenshot as DATA. Label the printout DATA. Close the TICKET PAYMENT table without saving changes. [3] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4581 3 [Turn over Task DB4 Examiner Only Marks Remark Task DB4 Using the relationships feature, create a one-to-many relationship between the SAVER table and the TICKET table. Print a copy of the new relationship layout for the database on one A4 page. Label the printout RELATIONSHIPS. Close the Relationships view and save changes. [2] Do not forget to include your Candidate Number, Centre Number and Question Number to include yourfooter on the above document. Do not forget in a header or Candidate Number, Centre Number and Question Number in a header or footer on the above document. Task DB5 Task DB5 As some new collectors have recently been employed, Margaret has asked for a data capture form for entering collector details. Create a data capture form as shown above. Save the form as COLLECTORFORM. Use your form to add the following new collector: Collector No: CollectorCollector No: Name: Collector Address: CollectorCollector Name: Telephone: Area No: 9 Rebecca Smithfield Collector Address: 25 Markston Street Collector Telephone: 0999077723 Area No: G Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. Produce a printout showing ONLY the above record, ensuring all data is fully visible. Label the printout COLLECTORDATA. [7] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4581 4 [Turn over TASK DB6 Examiner Only Marks Remark As an incentive for collectors to sell more tickets, the committee has decided to offer a bonus of 50 to each collector who manages to sell more than three tickets. Margaret needs to produce a list showing which collectors have met this target. In this task, you will use the TICKET table, SAVER table, AREA table and COLLECTOR table to create a query. Using the query function, create a query which will show collector details and count the total tickets sold. The query should show Collector No, Collector Name and calculate a value for Number of Tickets Sold. Save the query as TICKETS. Produce a screenshot of the design of the query. Save the screenshot as TICKETSDESIGN. Print TICKETSDESIGN. Label the printout TICKETSDESIGN. [4] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4581 5 [Turn over Task DB7 Examiner Only Marks Remark As it is approaching the end of May, Margaret needs to make sure that all tickets have been paid for in full. She wants to produce a report that will show her at a glance how much is outstanding for each ticket. TICKET PAYMENT SUMMARY Total Paid Balance Due 1 Alison Boyd 02850774661 100.00 0.00 2 Cara Molloy 02824681012 100.00 0.00 3 Daire Largey 02864889761 50.00 50.00 4 Elizabeth McCourt 02899885612 40.00 60.00 5 Elizabeth McCourt 02899885612 100.00 0.00 6 Maurice Hawkins 02833779951 50.00 50.00 7 Kathleen Frobisher 02895648721 100.00 0.00 8 Tony McDermott 02890000000 100.00 0.00 9 Alex Murphy 02844449860 100.00 0.00 10 Alex Murphy 02844449860 100.00 0.00 11 Jessica Gargan 02867935588 50.00 50.00 12 Conor McQuillan 02899327851 100.00 0.00 13 Conor McQuillan 02899327851 85.00 15.00 14 Conor McQuillan 02899327851 100.00 0.00 15 Callum McCann 02875314569 50.00 50.00 16 Stephen McAleenan 02845685215 100.00 0.00 17 Anne Fitzpatrick 02874108520 100.00 0.00 18 Declan Lonsdale 02896358466 100.00 0.00 19 Declan Lonsdale 02896358466 100.00 0.00 Produce a report as shown above. The report should show the Ticket No, Saver First Name, Saver Last Name and Saver Telephone. The report should use the Amount field to calculate and display the Total Paid. The report should include a text box to calculate and display the Balance Due. Save the report as SUMMARYDETAILS. Print a copy of SUMMARYDETAILS on one A4 page in portrait layout. Label the printout SUMMARYDETAILS. [9] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. The database activities are now complete. 4581 6 [Turn over The committee has decided that each of the collectors can be paid a monthly expenses claim. Margaret has decided to use the spreadsheet to set up a template form to allow the collectors to claim their expenses. TASK SS1 Open the spreadsheet called supersavers08_June.xls In the header of Sheet1 enter the following data: In the footer of Sheet 1 enter today s date, your candidate number and your centre number. In Sheet 1 enter, format and save the following data. Rename Sheet 1 as Expenses and rename Sheet 2 as Tickets. Produce a screenshot showing that all data has been entered correctly and that the sheets have been renamed. Save the screenshot as EXPENSES1. Print the screenshot. Label the printout EXPENSES1. Select the range A10:I29. Set the print area to print this selection only. Print a copy of the selected area on one A4 page. (Ensure that the Gridlines and Row and column headings are showing). Label the printout EXPENSES2. Examiner Only 4581 Marks Remark [10] 7 [Turn over TASK SS2 Margaret is going to set up the area codes as a list that she can select from when she goes to calculate the collectors expenses. The Name Box in a spreadsheet is shown in the position below: In the Expenses sheet select the range in column A from A1 to A8. Move to the Name Box. In the Name Box enter AREACODE and press the Return/Enter key. Place the cursor in cell C11. Select Validation from the Data menu. You should see the screen shown below: 4581 8 [Turn over Examiner Only Marks In the Settings tab, select List from the Allow: drop down menu option. In the Source menu box type in =AREACODE Produce a screenshot showing that the Validation criteria have been entered correctly. Print the screenshot. Label the printout AREACODESOURCE. Press the OK button. Click the list box in cell C11 to show the contents of the list AREACODE. Produce a screenshot of the AREACODELIST. Print a screenshot of the AREACODELIST. Label the printout AREACODELIST. Remark [4] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. TASK SS3 In the Expenses sheet enter a formula in cell I16 to calculate the car miles allowance. Enter a formula in cell I29 to calculate the TOTAL CLAIMED expenses. Produce a screenshot showing both formulae on one A4 page using landscape view. Save the screenshot as FORMULAE. Print FORMULAE. Label the printout FORMULAE. [4] Margaret wants to keep this template she has created separately from the savings of the members. 4581 9 [Turn over TASK SS4 Examiner Only Marks Remark Using the sheet named Expenses, create a macro with shortcut Ctrl+Shift+E that will allow the following instructions to be carried out: Print the range A10:I30 Display the header and footer details Show gridlines Use portrait layout Set page-size to A4 Print Save the macro as PRINTMACRO. Print the macro code. Label the printout MACROCODE. Save the spreadsheet. [7] Margaret has imported data from the database and has stored this data in the sheet you have named Tickets. She wants to know if the savers have paid the full amount for their tickets. TASK SS5 Using the sheet named Tickets enter a formula in column H that will display a message to Margaret showing whether payments for tickets have been paid in full or are incomplete. (Remember that tickets cost 100 each). Move to cell H2 and produce a screenshot of the formula you have entered. Save the screenshot as FORMULATICKETS. Print the screenshot on one A4 page making sure the formula is visible and that row and column headings are displayed. Label the printout FORMULATICKETS. [7] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. The spreadsheet activities are now complete. 4581 10 [Turn over TASK WP1 Examiner Only Marks Remark Following the decision to hold a raffle to raise building funds, it has been decided that collectors must be issued with a Ticket Payment Record to record ticket payments. Open a new blank document. The document should be landscape. The document should use Arial Black with a font size of 12. Save the document as RECORD1. Produce a screenshot that shows the above formatting. Save the screenshot as SCREENSHOT1. Print a copy of SCREENSHOT1. Label the printout as SCREENSHOT1. [3] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. TASK WP2 Using RECORD1 insert the Super Savers Logo from the images08_June folder in the left hand corner of the header. The logo must be adjusted so that it is 30% of its original height. Save the document as RECORD2. Produce a screenshot of RECORD2 that shows the logo in the correct position and with the correct size. Save the screenshot as SCREENSHOT2. Print a copy of SCREENSHOT2. Label this printout as SCREENSHOT2. [2] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4581 11 [Turn over TASK WP3 Examiner Only Marks Using RECORD2 insert the following text in the centre of the footer: TICKET PAYMENT RECORD Save the document as RECORD3. Produce a screenshot of RECORD3 that shows the text in the correct position. Save the screenshot as SCREENSHOT3. Print a copy of SCREENSHOT3. Label this printout as SCREENSHOT3. Remark [2] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. TASK WP4 Using RECORD3 place the following text starting at Line 1 Column 1 COLLECTOR NAME COLLECTOR NO. At Line 3 Column 1 insert a table that has 20 columns and 17 rows. Select Table AutoFormat from the Table menu and choose Table Classic1. Produce a screenshot that shows the title in the correct position, the correct table set up in the correct position and the correct AutoFormat choice. Save the screenshot as SCREENSHOT4. Print a copy of SCREENSHOT4. Label this printout as SCREENSHOT4. Save the document as RECORD4. [6] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4581 12 [Turn over TASK WP5 Examiner Only Marks Using RECORD4, in the table you have created insert the text Saver No. in the top left hand cell. Insert the numbers 1 18 after this along the top row. Insert the word Totals in the top right hand cell of the table and in the bottom left hand cell of the table. Place a double line around the top row using box setting. Shade this row using the Shading option, Style 20%. Produce a screenshot that shows the correct text, the double line around the top row and a dialog box showing the correct style option. Save the screenshot as SCREENSHOT5. Print a copy of SCREENSHOT5. Label this printout as SCREENSHOT5. Save the document as RECORD5. Remark [6] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. TASK WP6 Using the mailmerge facility insert the fields for Collector Name, and Collector No in RECORD5 from the COLLECTOR table in the supersavers08_June.mdb database. Position the fields appropriately. Produce a screenshot showing the fields that are to be merged and their position. Save the screenshot as SCREENSHOT6. Print a copy of SCREENSHOT6. Label the printout as SCREENSHOT6. Complete the merge. Save the merged document as MERGE. Print the FOURTH page of this document to show a sample statement. Label the printout SAMPLE. [8] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. The wordprocessing activities are now complete. 4581 13 [Turn over TASK MM1 Examiner Only Marks Remark Margaret Mercer, the secretary, is continuing to develop her induction package for new members of staff. She wishes to include a range of multimedia presentations on relevant topics. Open the presentation supersavers08_June.ppt Create a Master Slide containing; your centre number in the bottom left hand corner; your candidate number in the bottom right hand corner. Insert the club logo in the centre of the master slide. Format the logo so that Color is washout . Produce a screenshot of this master slide. Save the screenshot as SLIDES1. Print SLIDES1. Label the printout SLIDES1. [3] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. TASK MM2 Insert TWO more slides with the following titles How to protect your computer. How to use e-mail to keep in touch. Use suitable graphics from the images08_June folder and add relevant text to explain these functions. Print your slides in handout format on one A4 page. Label your printout SLIDES2. [5] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. The multimedia activities are now complete. 4581 14 [Turn over Final Check You should have the following 23 printouts in this order. Each should have your Candidate Number, Centre Number and Question Number and be labelled with the printout name in each task. Indicate that you have completed the task by ticking the appropriate box in the table below. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. Label TICKETPAYMENTDESIGN VALIDATION DATA RELATIONSHIPS COLLECTORDATA TICKETSDESIGN SUMMARYDETAILS EXPENSES1 EXPENSES2 AREACODESOURCE AREACODELIST FORMULAE MACROCODE FORMULATICKETS SCREENSHOT1 SCREENSHOT2 SCREENSHOT3 SCREENSHOT4 SCREENSHOT5 SCREENSHOT6 SAMPLE SLIDES1 SLIDES2 Task DB1 DB2 DB3 DB4 DB5 DB6 DB7 SS1 SS1 SS2 SS2 SS3 SS4 SS5 WP1 WP2 WP3 WP4 WP5 WP6 WP6 MM1 MM2 Completed THIS IS THE END OF THE TASK PAPER 4581 15 [Turn over 1/08 529-020-1 9

Formatting page ...

Additional Info : Gce Applied ICT May 2008 Assessment Unit AS 2 - Software Applications and Tools
Tags : General Certificate of Education, A Level and AS Level, uk, council for the curriculum examinations and assessment, gce exam papers, gce a level and as level exam papers , gce past questions and answer, gce past question papers, ccea gce past papers, gce ccea past papers

gce chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: