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

GCE JUN 2009 : AS 2 Components of Information and Communication Technology

16 pages, 41 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 2009 Information and Communication Technology assessing Module 2: Components of Information and Communication Technology ASW21 Assessment Unit AS 2 [ASW21] FRIDAY 12 JUNE, AFTERNOON TIME 1 hour 30 minutes. INSTRUCTIONS TO CANDIDATES Write your Centre Number and Candidate Number in the spaces provided at the top of this page. Write your answers in the spaces provided in this question paper. Answer all seven questions. INFORMATION FOR CANDIDATES The total mark for this paper is 90, including a maximum of 4 marks for quality of written communication. Figures in brackets printed down the right-hand side of pages indicate the marks awarded to each question or part question. For Examiner s use only Question Number 1 2 3 4 5 6 7 QWC Total Marks 4686 Marks BLANK PAGE 4686 2 [Turn over 1 A PC incorporates a hard disk, a CD-R drive and a DVD-RW drive. Examiner Only Marks Remark (a) Describe three ways in which the hard disk will be used. 1. _______________________________________________________ _________________________________________________________ _________________________________________________________ 2. _______________________________________________________ _________________________________________________________ _________________________________________________________ 3. _______________________________________________________ _________________________________________________________ _______________________________________________________ [6] (b) Explain how data is written to a CD-R ___________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [3] DVD-RW ________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [3] 4686 3 [Turn over 2 The computers in an office are linked as a network. Examiner Only Marks Remark (a) Describe two disadvantages of networking the computers. 1. _______________________________________________________ _________________________________________________________ _______________________________________________________ [2] 2. _______________________________________________________ _________________________________________________________ _______________________________________________________ [2] An ICT consultant suggests a star network rather than a bus network. (b) Without drawing diagrams, describe each of the following network topologies. Star _____________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [3] Bus _____________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [3] 4686 4 [Turn over (c) Describe how each of the following topologies will be affected by cable failure. Examiner Only Marks Remark Star _____________________________________________________ _________________________________________________________ _______________________________________________________ [2] Bus _____________________________________________________ _________________________________________________________ _______________________________________________________ [2] 4686 5 [Turn over 3 One of the functions of the arithmetic and logic unit (ALU) is to perform arithmetic calculations. Examiner Only Marks Remark (a) Describe two other functions of the ALU. 1. _______________________________________________________ _________________________________________________________ _______________________________________________________ [2] 2. _______________________________________________________ _________________________________________________________ _______________________________________________________ [2] (b) Identify two other components in a typical processor and state the purpose of each. Component _______________________________________________ Purpose __________________________________________________ _______________________________________________________ [2] Component _______________________________________________ Purpose __________________________________________________ _______________________________________________________ [2] 4686 6 [Turn over BLANK PAGE (Questions continue overleaf) 4686 7 [Turn over 4 An employer uses the following spreadsheet to investigate the cost of awarding employees a 5% increase in salary. A B Employee Current Salary D 3 B. Brown 23 000 1150 24 150 4 G. Gray 25 500 1275 26 775 5 G. Green 21 500 1075 22 575 6 L. Lemon 29 000 1450 30 450 7 W. White 18 500 925 E F G Increase (%) Remark Salary New Increase Salary 19 425 1 C Examiner Only Marks 5 2 8 9 Total 117 500 5875 123 375 (a) By referring to specific cells, explain each of the following features of a spreadsheet. A formula ________________________________________________ _________________________________________________________ _______________________________________________________ [2] Cell formatting ____________________________________________ _________________________________________________________ _______________________________________________________ [2] A function ________________________________________________ _________________________________________________________ _______________________________________________________ [2] Cell replication ____________________________________________ _________________________________________________________ _______________________________________________________ [2] 4686 8 [Turn over (b) Explain how the employer could use this spreadsheet for what if calculations. Examiner Only Marks Remark _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [3] 4686 9 [Turn over 5 A software package includes a Graphical User Interface and a Command Line Interface. Examiner Only Marks Remark (a) Explain how each of the following is used in a typical Graphical User Interface. Icons ____________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [3] Menus ___________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [3] Windows _________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [6] 4686 10 [Turn over (b) Describe two drawbacks with a Command Line Interface. Examiner Only Marks Remark 1. _______________________________________________________ _________________________________________________________ _______________________________________________________ [2] 2. _______________________________________________________ _________________________________________________________ _______________________________________________________ [2] 4686 11 [Turn over 6 Students enrol for a course by completing an application form. Examiner Only Marks Remark Each student is allocated a unique PIN which includes a check digit. (a) Name and describe three other types of validation check. Name ____________________________________________________ Description _______________________________________________ _________________________________________________________ Name ____________________________________________________ Description _______________________________________________ _________________________________________________________ Name ____________________________________________________ Description _______________________________________________ _______________________________________________________ [6] (b) Explain how a check digit should detect a transposition error in a PIN. _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [3] 4686 12 [Turn over Data from these forms is keyed into a database. Examiner Only Marks Remark (c) Explain the purpose of data verification. _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] (d) Name and describe a verification check which could be performed in this case. Name ____________________________________________________ Description _______________________________________________ _______________________________________________________ [2] 4686 13 [Turn over 7 A retailer holds sales data in a flat file. Examiner Only Marks Remark The data held about a sample sale is shown in the table below. The retailer wishes to replace the flat file with a normalised database. Sales Order Form Invoice No: Date: Customer Ref: 1234 08/08/08 8765 Name: Address Green 12 New Lane Any Town Tele: Fax: E-mail: 901212121 902122121 gr@green.co Product No: 100 102 103 104 Description Screwdriver Hammer Saw Spirit level Quantity 4 5 6 7 Unit Cost ( ) 5.00 6.00 7.00 8.00 Cost ( ) 20.00 30.00 42.00 56.00 Invoice Total 148.00 (a) Describe two problems that can arise with data which is not normalised. 1. _______________________________________________________ _________________________________________________________ _______________________________________________________ [2] 2. _______________________________________________________ _________________________________________________________ _______________________________________________________ [2] 4686 14 [Turn over (b) Explain how the above data will be organised in the database. Examiner Only Marks Remark _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [5] (c) Describe how a report can be created using a database. _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [3] Quality of written communication THIS IS THE END OF THE QUESTION PAPER 4686 15 [Turn over 938-061-1

Formatting page ...

Additional Info : Gce ICT June 2009 Assessment Unit AS 2, Module 2: Components of Information and Communication Technology
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: