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

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

16 pages, 19 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 January 2008 Applied Information and Communication Technology assessing A3J21 Assessment Unit AS 2 Number of printouts attached (to be completed at the end of the examination) Unit 2: Software Applications and Tools [A3J21] MONDAY 14 JANUARY FRIDAY 18 JANUARY For Examiner s use only Marks Question available DB1 3 DB2 3 DB3 3 DB4 2 DB5 5 DB6 8 DB7 11 DB8 3 SS1 6 SS2 6 SS3 7 SS4 8 SS5 7 WP1 3 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. WP2 2 WP3 8 WP4 7 To complete the examination you should have access to the following: supersavers08.mdb supersavers08.xls supersavers08.ppt images08 folder. MM1 3 MM2 5 TIME 2 hours 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 A3J2W8 4178 Total 100 Marks Remark In order to complete this examination you should have access to the following: supersavers08.mdb supersavers08.xls supersavers08.ppt images08 folder A database has been set up called supersavers08.mdb Open the database and examine the relationships between the tables TASK DB1 In October 2007, a WITHDRAWAL table was added to the database prior to this all withdrawals involved a manual adjustment of figures. Withdrawals will only be paid out if they are approved by a member of Super Savers management for this reason the approved field MUST be entered when a withdrawal record is being saved. Open the WITHDRAWAL table in design view and create a new field as follows: Field name Data Type Yes/No Required Approved Yes Print a screenshot of the design of the WITHDRAWAL table showing clearly the fieldname and data type of the new field you have added. Label the printout WITHDRAWALDESIGN. Close the WITHDRAWAL 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 DB2 The minimum withdrawal which can be requested is 10 and the maximum is 500. Create a validation rule for the Withdrawal Amt field in the WITHDRAWAL table to ensure that amounts 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 WITHDRAWAL 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. A3J2W8 4178 2 [Turn over TASK DB3 To test your validation, open the WITHDRAWAL table and add the following record: Withdrawal No: Saver No: 600 Approved: 05-01-08 Withdrawal Amt: 4 Withdrawal Date: 25 No 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 WITHDRAWAL 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. TASK DB4 Using the relationships feature, create a one-to-many relationship between the SAVER table and the WITHDRAWAL table. Print a copy of the new relationship layout for the database. 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 in a header or footer on the above document. A3J2W8 4178 3 [Turn over TASK DB5 Create a data-capture form for entering withdrawal details. The form should appear as shown below: Save the form as WITHDRAWALFORM. Produce a screenshot showing WITHDRAWALFORM in design view. Save the screenshot as FORMDESIGN. Print FORMDESIGN. Label the printout FORMDESIGN. [5] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. A3J2W8 4178 4 [Turn over TASK DB6 Margaret wishes to produce a list showing details of payments made by savers. Using the query function, create a query which will show saver details and total payments made. The query should show Saver No, Saver First Name, Saver Last Name and should calculate a value for Total Payments. Save the query as PAYMENTS. Produce a screenshot of the design of the query. Save the screenshot as PAYMENTSDESIGN. Print PAYMENTSDESIGN. Label the printout PAYMENTSDESIGN. Margaret now wishes to produce a list showing details of withdrawals made by savers. Using the query function, create a query which will show saver details and total withdrawals made. The query should show Saver No, Saver First Name, Saver Last Name and should calculate a value for Total Withdrawals. Save the query as WITHDRAWALS. Produce a screenshot of the design of the query. Save the screenshot as WITHDRAWALSDESIGN. Print WITHDRAWALSDESIGN. Label the printout WITHDRAWALSDESIGN. [8] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. A3J2W8 4178 5 [Turn over TASK DB7 You will now use the report wizard to produce a withdrawal statement, part of which is shown below: Withdrawal Statement Saver No 1 Date 10/10/2007 12/11/2007 15/12/2007 18/12/2007 Saver Total Saver No 2 Date 15/10/2007 20/12/2007 Mark Robinson Daire Largey Amount 20.00 10.00 20.00 50.00 Amount 50.00 100.00 150.00 4 Date 10/10/2007 Boyd 100.000 Saver Total Saver No Alison Amount 100.00 The report should use the fields Saver No, Saver First Name, Saver Last Name, Withdrawal Date and Withdrawal Amt. The report should be grouped by Saver No, Saver First Name and Saver Last Name. The report should be ordered by date. Subtotals should be created for each saver. An overall total for all savers should be displayed at the end of the report. Today s date should be included at the end of the report. Format your report so that it appears as shown above. Place the title Withdrawal Statement in the page header so that it appears on all pages of the report. Save the report as SUMMARYDETAILS. Print the last page of the report in landscape view. Label the printout SUMMARYDETAILS. [11] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. A3J2W8 4178 6 [Turn over TASK DB8 Due to the large number of payments being made, Margaret Mercer feels it is time to employ more collectors. She feels that a graph would be a useful way of conveying this information to management. In this task you will use the SAVER table and the PAYMENT table to create a query. The data from this query will be used in a later task to create a graph. Using the query function, create a query which will show the number of payments made within each area. The query should show Area No (from the SAVER table) and count the number of payments made within each area. Save the query as EXPORTDATA. Produce a screenshot of the design of the query. Save the screenshot as EXPORTDATADESIGN. Print EXPORTDATADESIGN. Label the printout EXPORTDATADESIGN. Close the database. [3] 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. A3J2W8 4178 7 [Turn over Margaret needs to review the money that has been collected for the area called Hillview. Using the spreadsheet, supersavers08.xls which has been prepared for you, complete the following tasks. TASK SS1 Select an appropriate column in the spreadsheet and switch on the Freeze Panes feature so that columns A, B, C and D freeze i.e. remain in place while using the horizontal scroll bar. Scroll horizontally to display these columns in sequence A, B, C, D, BA, BB, BC, BD, BE etc. Produce a screenshot of these columns showing at least rows 1-33. Save the screenshot as FREEZEBLANK. Print the screenshot on one A4 page. Label the printout FREEZEBLANK. [6] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. TASK SS2 Enter the following data into the cells shown Enter suitable formulae in column BA which will total savers contributions for the year. Produce a screenshot showing data you have calculated in column BA. Save the screenshot as YEARDATA. Print the screenshot on one A4 page. Label the printout YEARDATA. Produce a screenshot showing the formulae in column BA. Save the screenshot as YEARFORMULAE. Print the screenshot on one A4 page. Label the printout YEARFORMULAE. A3J2W8 4178 8 [6] [Turn over TASK SS3 A saver may only withdraw money from the scheme if they have saved more than 75. Margaret wants to display a simple code in column D so that she can see at a glance if the saver is entitled to withdraw money. She has done some research and has found that if she uses a font named WINGDINGS with a special code the following effects can be achieved. WINGDINGS CHAR(252) CHAR(251) OUTPUT OBTAINED Enter suitable formulae in column D using this information to show Margaret who is entitled to withdraw money ( ) and who is not entitled to withdraw money ( ). Produce a screenshot showing at least these columns A, B, C and D with appropriate ( ) and ( ) in place. Save the screenshot as BORROWDATA. Print the screenshot on one A4 page. Label the printout BORROWDATA. Produce a screenshot showing the formulae in column D. Save the screenshot as BORROWFORMULAE. Print the screenshot on one A4 page. Label the printout BORROWFORMULAE. [7] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. TASK SS4 The committee is exploring the idea of giving Super Savers members interest on their savings. Margaret has been asked by the committee to work out how much savers would get for interest rates of 1%, 2%, 3% and 4%. Using absolute cell referencing enter formulae in columns BC, BD, BE and BF that will calculate interest payments for savers. With the cursor in BC4 produce a screenshot showing the data you have calculated. Save the screenshot as INTEREST. Print the screenshot on one A4 page. Label the printout INTEREST. A3J2W8 4178 9 [8] [Turn over TASK SS5 In this task you will use the data from the query created in task DB8 to draw a graph. Insert a new sheet in your spreadsheet. Rename the sheet as Graph. Place the cursor in cell A1. Using the Data menu go to Import External Data and select Import Data. Select EXPORTDATA. Use the data you have imported to create a column chart. Label both axes appropriately. Title the chart PAYMENTS BY AREA . Produce a screenshot to show the data you have imported as well as the graph you have produced. Save the screenshot as GRAPH. Print the screenshot on one A4 page. Label the printout GRAPH. [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. A3J2W8 4178 10 [Turn over TASK WP1 The committee at Super Savers has decided that it is important to create a monthly statement for each saver in the club. In this task you will be asked to demonstrate the proposed statement design. Open a new blank document. Your document should be A4 in size. The document should be in Times New Roman with a font size of 14. Save the document as STATEMENT1. Produce a screenshot of the dialog box which 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 Insert the Super Savers Logo from the images08 folder in the top right hand corner of STATEMENT1. The logo must be adjusted so that it is 25% of its original height. Save the document as STATEMENT2. Produce a screenshot of STATEMENT2 that shows the logo and the Format Picture - Size dialog box. 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. A3J2W8 4178 11 [Turn over TASK WP3 In STATEMENT2, enter the following text in bold and in italics positioned to the left of the logo. Super Saver Monthly Statement December 2007 Move down the document to Line 12 Column 1. Go to the Format menu and select Columns and from this point forward create four equally spaced columns with a line between them. Enter the following text in bold and in italics at the top of each of the four columns. Date Deposit Withdrawal Balance Save the document as STATEMENT3. Produce a screenshot of STATEMENT3 that shows the above formatting. Save the screenshot as SCREENSHOT3. Print a copy of SCREENSHOT3. Label this printout as SCREENSHOT3. [8] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. A3J2W8 4178 12 [Turn over TASK WP4 Margaret Mercer must put the correct address on each Super Saver Monthly Statement. Open STATEMENT3 and use it as your starting document. Using the mailmerge wizard select all records from the SAVER table in the supersavers08 database. Insert the fields for Saver No, Saver First Name and Saver Last Name on Line 5 Column 10 and the Saver Address on Line 6 Column 10. Fields should be properly spaced. Produce a screenshot showing the fields that are to be merged and their position. Save the screenshot as SCREENSHOT4. Print a copy of SCREENSHOT4. Label the printout as SCREENSHOT4. Preview the merged statements. Complete the merge. Save the merged document as STATEMENT4. Print the THIRD page of this document to show a sample statement. Label the printout SAMPLE. [7] 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. A3J2W8 4178 13 [Turn over TASK MM1 As the number of savers continues to grow at Super Savers, the Committee is aware that more staff must be employed to support all aspects of the work in the organisation. Margaret Mercer, the secretary, has started to develop an induction package for new members of staff. As part of this, she wishes to include a multimedia presentation. Open the presentation supersavers08.ppt Create a Master Slide containing: the club logo appropriately sized at the bottom left hand corner; the words SUPER SAVERS in the footer beside the logo; your centre number and candidate number in the bottom right hand corner. Go the View menu and select Slide Sorter. Change the zoom control to 100%. Save the screenshot as SCREENSHOT5. Print SCREENSHOT5. Label the printout SCREENSHOT5. [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 With your slides showing Slide Sorter view, select the first slide and the option Slide Transition from the Slide Show menu. Select the following options: Wipe Right Slow On Mouse Click Produce a screenshot of these instructions. Save the screenshot as SCREENSHOT6. Print a copy of SCREENSHOT6 in landscape so that all information is visible. Label the printout SCREENSHOT6. [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. A3J2W8 A3J2W8 4178 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 WITHDRAWALDESIGN VALIDATION DATA RELATIONSHIPS FORMDESIGN PAYMENTSDESIGN WITHDRAWALSDESIGN SUMMARYDETAILS EXPORTDATADESIGN FREEZEBLANK YEARDATA YEARFORMULAE BORROWDATA BORROWFORMULAE INTEREST GRAPH SCREENSHOT1 SCREENSHOT2 SCREENSHOT3 SCREENSHOT4 SAMPLE SCREENSHOT5 SCREENSHOT6 Task DB1 DB2 DB3 DB4 DB5 DB6 DB6 DB7 DB8 SS1 SS2 SS2 SS3 SS3 SS4 SS5 WP1 WP2 WP3 WP4 WP4 MM1 MM2 Completed THIS IS THE END OF THE TASK PAPER A3J2W8 4178 15 S 10/07 302-073-1 9

Formatting page ...

Additional Info : Gce Applied ICT January 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: