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

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

16 pages, 21 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 ...

1 2 Centre Number 3 71 4 Candidate Number 5 6 ADVANCED SUBSIDIARY (AS) General Certificate of Education January 2009 7 8 9 11 Assessment Unit AS 2 12 assessing 13 Unit 2: Software Applications and Tools 14 [A3J21] 15 MONDAY 12 JANUARY FRIDAY 16 JANUARY 16 18 19 20 TIME INSTRUCTIONS TO CANDIDATES Write your Centre Number and Candidate Number in the spaces 22 name specified in each task. Always add your Candidate Number, Centre Number, Question Number and Printout Label to every 23 printout produced. All printouts may be labelled by hand. All 24 printouts must be attached to the examination paper at the end of the examination in the correct order. Use the treasury tag provided 25 to attach your printouts to the examination paper. 26 You may not take the examination paper with you. INFORMATION FOR CANDIDATES 28 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. 30 In order to complete this examination you should have access to the following: 31 adventures09_jan.mdb 32 adventures09_jan.xls graphics09_jan folder 29 33 34 35 For Examiner s use only Marks Question available 4321 DB1 DB2 DB3 DB4 DB5 DB6 DB7 DB8 SS1 SS2 SS3 SS4 SS5 SS6 WP1 WP2 WP3 WP4 WP5 MM1 MM2 5 2 2 2 5 7 2 10 5 6 7 9 4 7 3 2 3 5 7 2 5 Total 2 hour 30 minutes. 21 provided at the top of this page. Save each document using the 27 A3J21 Applied Information and Communication Technology 10 17 Number of printouts attached (to be completed at the end of the examination) 100 Marks Remark A database has been set up called adventures09_jan.mdb Examiner Only Marks Remark The owners of Afterschool Adventures are using the database to store data about the children, parents and staff, who use the facilities. Open the database and examine the relationships between the tables. TASK DB1 This database currently consists of four tables called PARENT, CHILD, GROUP and STAFF. Details about each child are stored in the CHILD table. The joining date for each child must be recorded. Open the CHILD table in design view and create a new field as follows. Field Name Data Type l Date Format l Join Date Short Date Modify the properties of this field to ensure that it will automatically default to today s date. Print a screenshot of the design of the CHILD table showing clearly the Field Name, Data Type and Field Properties of the new field you have added. l Label the printout CHILDDESIGN. l Close the CHILD 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. 4321 2 [Turn over TASK DB2 Examiner Only Marks Remark A payment method for fees must be recorded in the PARENT table. l l l Create a validation rule for the Payment Method field in the PARENT table that will ensure that payments can only be made daily, weekly or monthly. The validation text that should be shown is INCORRECT PAYMENT METHOD . Print a screenshot of the table design showing clearly the validation text you have entered. l Save as VALIDATION. l Print VALIDATION. l Label the printout VALIDATION. l Close the PARENT table and save the changes. [2] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. TASK DB3 The screenshot shown below is the result of an incorrect record having been added to the PARENT table. l l Add a record to the PARENT table that would cause this message to be displayed. Produce a screenshot that shows the data that has been entered and the error message. l Save the screenshot as RULECHECK. l Print RULECHECK. l Label the printout RULECHECK. l Close the PARENT table without saving the changes. [2] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4321 3 [Turn over TASK DB4 Examiner Only Marks l Remark Using the relationships feature, create a one-to-many relationship between the GROUP table and the CHILD table. l Print a copy of the new relationship layout for the database on one A4 page. l Label the printout RELATIONSHIPS. l Close the relationships view and save changes. [2] TASK DB5 The owners want to be able to add data easily to the database. The creation of a data-capture form for entering children s details is necessary. l Create a form that displays all fields from the CHILD table. l The form should display CHILD DETAILS as the title. l The form should include a suitable graphic from the graphics folder. l Save the form as CHILDFORM. l Produce a screenshot showing CHILDFORM in design view. l Save the screenshot as CHILDDESIGN. l Print CHILDDESIGN. l Label the printout CHILDDESIGN. l Use your form to add the following new child. Child No Child First Name O Malley Parent No 2 Date of birth 7/10/2003 Medical Details Nut allergy, asthma School Glen Road School Collection Time 14:00 Group ID ROBIN Join Date l Martine Child Last Name l (automatic) 02/12/2008 Produce a printout of the form showing ONLY the above record ensuring all data is fully visible. Label the printout CHILDFORM. [5] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4321 4 [Turn over TASK DB6 Examiner Only Marks Remark On occasion staff may need to contact parents as a result of a child s medical condition. In this task you will use the PARENT table and the CHILD table to create a query that will identify all children who have asthma. l l Create a query which will show all children who have asthma together with their parents details. The query should show Child Last Name, Child First Name, Date of Birth, Parent Last Name, Parent First Name and Mobile Number. l The records should be displayed in alphabetical order by child last name. l Save the query as ASTHMA. l Produce a screenshot of the design of the query, making sure all of the criteria and fields are visible. l Save the query as ASTHMADESIGN. l Print ASTHMADESIGN. l Label the printout ASTHMADESIGN. [7] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. TASK DB7 l l l Run the query ASTHMA. Print a copy of the results of the query on one A4 page making sure all data is visible. Label the printout ASTHMALIST. [2] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4321 5 [Turn over TASK DB8 Examiner Only Marks Remark Children who attend Afterschool Adventures are allocated to groups. Staff have asked for a summary report which will show which children have been allocated to each group. l l l l l l l l Produce a report as shown above. The report should show Group ID, Description, Child Last Name, Child First Name and Date of Birth. Children should be listed in alphabetical order of their surname. A calculation should be included to show the number of children in each group. Appropriate formatting should be applied. Save your report as GROUPS. Print a copy of GROUPS on one A4 page. Label the printout GROUPS. [10] 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. 4321 6 [Turn over A member of staff called Janice has the job of entering the payment details onto a spreadsheet for each of the parents in the Adventurers scheme. Examiner Only Marks Remark Open the spreadsheet called adventures09_jan.xls and examine the data closely in each of the sheets. TASK SS1 Janice has been entering data that records how many hours each child has been cared for each day of the month. This will be used to complete the billing for each parent. l l l l Move to the sheet named december Examine the data on this sheet. Notice that it is not possible to view all data without sliding the horizontal scroll bar. Janice wants to make some changes to this sheet. Select an appropriate column and switch on the Freeze Panes feature so that columns A and B freeze i.e. remain in place while using the horizontal scroll bar. Scroll horizontally to display columns A, B, N, O, P, Q, R, S, T, U, V, W and at least rows 1 37. l Produce a screenshot showing these rows and columns. l Save the screenshot as FREEZE. l Print the screenshot on one A4 page in landscape view. l Label the printout FREEZE. l Save the spreadsheet. [5] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4321 7 [Turn over TASK SS2 Examiner Only Marks Remark Janice needs to work out the payment due for each child. l Move to the sheet named december l Move to cell X5 and enter the text Total Hours . l Move to cell Y5 and enter the text Number of collections . l Move to cell Z5 and enter the text Total Charges . l Ensure that the text in all cells can be clearly seen. l Move to cell X8 and enter a formula that will total the hours for this row. l Copy this formula for the column X9:X25. l Move back to cell X8 and ensure your formula is showing in the formula bar. l Produce a screenshot called TOTALHOURS on one A4 page in landscape view which shows the text you have entered and the formula you have created in X8 clearly in the formula bar. l Save the screenshot TOTALHOURS. l Print the screenshot TOTALHOURS. l Label the printout TOTALHOURS. l Save the spreadsheet. [6] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. TASK SS3 Janice now needs to calculate the total number of collections for each child. l l Move to the sheet named december In cell Y8 enter a formula that will count the number of times each child has been picked up. l Copy this formula for the column Y9:Y25. l Move back to cell Y8 and ensure this formula is showing in the formula bar. l Produce a screenshot called COLLECTIONS on one A4 page in landscape view which clearly shows the formula you have created in Y8 in the formula bar. l Save the screenshot COLLECTIONS. l Print the screenshot COLLECTIONS. l Label the printout COLLECTIONS. l Save the spreadsheet. [7] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4321 8 [Turn over TASK SS4 Examiner Only Marks Remark Janice now needs to calculate the final bill for each child. l l In the sheet named december move to cell Z8. Using absolute addressing, enter a formula that will show the total charge for each child. l Copy this formula for the column Z9:Z25. l Move back to cell Z8 and ensure the formula is showing in the formula bar. l Produce a screenshot called TOTALCHARGE on one A4 page in landscape view which clearly shows the formula you have created in Z8 in the formula bar. l Save the screenshot TOTALCHARGE. l Print the screenshot TOTALCHARGE. l Label the printout TOTALCHARGE. l Save the spreadsheet. [9] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. TASK SS5 Janice needs to keep a check each month to ensure Afterschool Adventures makes a profit. At this time the breakeven amount is 1500. l In the sheet named december move to cell A4 and enter two new rows. l In cell A4 enter the text TOTAL MONTHLY COSTS. l In cell C4 enter 1500. l In cell A5 enter the text INCOME. l In cell A6 enter the text PROFIT/LOSS. l In cell C5 enter a formula which will calculate the total money collected for this month. l Produce a screenshot of the formula you have just entered. l Save the screenshot as MONTHLYTOTAL. l l Print the screenshot on one A4 page making sure the formula is visible and that row and column headings are displayed. Label the printout MONTHLYTOTAL. [4] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4321 9 [Turn over TASK SS6 Examiner Only Marks l l Remark In cell C6 enter a formula to calculate the profit or loss. In cell B6 enter a formula that will print PROFIT if Afterschool Adventures makes a profit this month or will print LOSS if Afterschool makes a loss. l Produce a screenshot of the formula you have entered. l Save the screenshot as PROFITORLOSS. l Print the screenshot on one A4 page making sure the formula is visible. l Label the printout PROFITORLOSS. l Save the spreadsheet. [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. 4321 10 [Turn over TASK WP1 Examiner Only Marks Remark Group leaders reward the children for effort and good behaviour by presenting one child in each group with a certificate of merit each week. Certificates are ready for distribution apart from the child s name which will be handwritten on the document. In this task you will create a Certificate of Merit which can be easily changed as required. l Open a new blank document. l The document should be in Lucidia Calligraphy with a font size of 24. l Set the page to landscape. l Produce a screenshot that shows the above formatting. l Save the screenshot as SCREENSHOT1. l Print a copy of SCREENSHOT1. l Label the printout SCREENSHOT1. l Save the document as CERTIFICATE1. [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 l Using the Format menu, go to the Background option and select Printed Watermark. l Insert the Afterschool Adventures logo from the graphics09_Jan folder l Save the document as CERTIFICATE2. l Print a copy of CERTIFICATE2. l Label the printout as CERTIFICATE2. [2] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4321 11 [Turn over TASK WP3 Examiner Only Marks l Remark Go the Format menu and create a page border around your document that uses a setting of 3D, with Art set to the first group of stars. l Produce a screenshot that shows this formatting. l Save the screenshot as SCREENSHOT2. l Print a copy of SCREENSHOT2. l Label this printout as SCREENSHOT2. l Save the document as CERTIFICATE3. [3] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. TASK WP4 l Select an appropriate logo for a certificate, from the graphics_Jan09 folder l Position and size this logo in the top left hand corner of the document. l Enter the following text starting at line 2 column 1 in CERTIFICATE3. AFTERSCHOOL ADVENTURES This is to certify that _________________________ has been awarded a Certificate of Merit for excellent behaviour l Centre the text appropriately. l Save the document as CERTIFICATE4. l Print a copy of CERTIFICATE4. l Label the printout as CERTIFICATE4. [5] Do not forget to include your Candidate Number, Centre Number and Question Number in a header or footer on the above document. 4321 12 [Turn over TASK WP5 Examiner Only Marks Remark Group Leaders have decided to produce stickers, pre-printed for folders that are kept for each child in every group. They want to include the following information held for each child in the CHILD table in the database: Group ID, Child No, Child First Name and Child Last Name. The Group Leaders want to have the stickers sorted into groups for convenience. They want each label to show the information clearly in the following order: Group ID Child No Child First Name Child Last Name l l l Open a new blank document. Using the mail merge wizard and the Labels option, produce labels of size Avery Standard 3113-sticker. Select recipients from the CHILD table in the database. All records should be selected. l Sort the records by Group ID. l Arrange your labels and use More items . to insert the relevant fields. l Group ID and Child No should be on separate lines. Child First Name and Child Last Name should be on the same line separated by a space. l Update all labels. l Produce a screenshot showing the design of your labels. l Save the screenshot as SCREENSHOT3. l Print a copy of SCREENSHOT3 on one A4 page. l Label the printout as SCREENSHOT3. l Preview the labels. l Complete the merge. l Save the document as LABELS. l Print a copy of LABELS on one A4 page. l Label the printout as LABELS. [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. 4321 13 [Turn over Group leaders are to be involved in promotional events for Afterschool Adventures. The owners have decided to provide some training regarding presentation skills. Examiner Only Marks Remark TASK MM1 l Create a new blank presentation. l Select a slide layout with a bulleted list in two columns. l Go to the Format menu and select the slide design Ocean . l Produce a screenshot showing this formatting. l Save the screenshot as SCREENSHOT4. l Print a copy of SCREENSHOT4. l Label the printout as SCREENSHOT4. [2] TASK MM2 l Add the following text to each column of the first slide in your presentation. How to create a Master Slide How to add a slide design How to manage slide animation How to manage slide transition l Change the view to Normal. l Create TWO additional blank slides. l Print the title How to create a Master Slide on the first blank slide. l Provide instructions on how to do this task on this slide. l Print the slides in Handout view showing three slides to an A4 page. l Label your printout as SLIDES. [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. 4321 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. Label Task 1. CHILDDESIGN DB1 2. VALIDATION DB2 3. RULECHECK DB3 4. RELATIONSHIPS DB4 5. CHILDDESIGN DB5 6. CHILDFORM DB5 7. ASTHMADESIGN DB6 8. ASTHMALIST DB7 9. GROUPS DB8 10. FREEZE SS1 11. TOTALHOURS SS2 12. COLLECTIONS SS3 13. TOTALCHARGE SS4 14. MONTHLYTOTAL SS5 15. PROFITORLOSS SS6 16. SCREENSHOT1 WP1 17. CERTIFICATE2 WP2 18. SCREENSHOT2 WP3 19. CERTFICATE4 WP4 20. SCREENSHOT3 WP5 21. LABELS WP5 22. SCREENSHOT4 MM1 23. SLIDES Completed MM2 THIS IS THE END OF THE TASK PAPER 4321 15 [Turn over 935-078-1 9

Formatting page ...

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