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

GCE JAN 2008 : AS 2 Components of Information and Communication Technology

16 pages, 38 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 Information and Communication Technology assessing Module 2: Components of Information and Communication Technology ASW21 Assessment Unit AS 2 [ASW21] WEDNESDAY 23 JANUARY, MORNING 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. For Examiner s use only Question Number 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. 1 2 3 4 5 6 7 QWC Total Marks ASW2W8 3763 Marks 1 (a) A computer system includes a bar code reader and a temperature sensor. Examiner Only Marks Remark (i) Explain how data is captured using a bar code reader. _____________________________________________________ _____________________________________________________ _____________________________________________________ _____________________________________________________ ___________________________________________________ [4] (ii) Explain how data is captured using a temperature sensor. _____________________________________________________ _____________________________________________________ _____________________________________________________ _____________________________________________________ ___________________________________________________ [4] (b) Shoppers can use a touch screen to get information about each of the stores in a shopping centre. Describe two reasons why a touch screen is suitable in this case. 1. _______________________________________________________ _________________________________________________________ _______________________________________________________ [2] 2. _______________________________________________________ _________________________________________________________ _______________________________________________________ [2] ASW2W8 3763 2 [Turn over 2 A computer stores its operating system in both internal and external memory. Examiner Only Marks Remark (a) Describe how ROM is used for the operating system. _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [3] (b) Describe how RAM is used for the operating system. _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [3] (c) Describe why external memory is used for the operating system. _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [3] ASW2W8 3763 3 [Turn over 3 (a) The bus and star are two types of network topology. Examiner Only Marks Remark Describe the main features of each of the following. (i) The star topology. _____________________________________________________ _____________________________________________________ _____________________________________________________ ___________________________________________________ [3] (ii) The bus topology. _____________________________________________________ _____________________________________________________ _____________________________________________________ ___________________________________________________ [3] ASW2W8 3763 4 [Turn over (b) Describe how a network could use each of the following. Examiner Only Marks Remark (i) A firewall. _____________________________________________________ _____________________________________________________ _____________________________________________________ ___________________________________________________ [3] (ii) A proxy server. _____________________________________________________ _____________________________________________________ _____________________________________________________ ___________________________________________________ [3] (iii) A router. _____________________________________________________ _____________________________________________________ _____________________________________________________ ___________________________________________________ [3] ASW2W8 3763 5 [Turn over 4 The following table shows the profit generated by a business in each of four regions. Region Sales Costs 45 000 40 500 4500 South 43 500 41 500 2000 East 29 500 23 500 6000 West 36 500 34 500 2000 Totals 154 500 140 000 Remark Profit North Examiner Only Marks 14 500 (a) Describe three features of a spreadsheet which make it suitable for producing the above table. 1. _______________________________________________________ _________________________________________________________ _________________________________________________________ 2. _______________________________________________________ _________________________________________________________ _________________________________________________________ 3. _______________________________________________________ _________________________________________________________ _______________________________________________________ [6] ASW2W8 3763 6 [Turn over (b) Describe how each of the following could be used to produce a graph comparing the profits of the four regions. Examiner Only Marks Remark (i) A wizard. _____________________________________________________ _____________________________________________________ _____________________________________________________ _____________________________________________________ _____________________________________________________ ___________________________________________________ [4] (ii) A macro. _____________________________________________________ _____________________________________________________ _____________________________________________________ _____________________________________________________ _____________________________________________________ ___________________________________________________ [4] ASW2W8 3763 7 [Turn over 5 A business uses a number of generic software packages. Each of these packages provides the user with the menu shown below. File Edit View Insert Format Tools Table Window Examiner Only Marks Remark Help (a) Explain what is meant by a generic software package. _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] (b) Explain what is meant by a drop-down menu. _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] (c) By referring to the menu shown above, explain what is meant by a shortcut. _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] (d) State two reasons why shortcuts are provided. 1. _______________________________________________________ _________________________________________________________ 2. _______________________________________________________ _______________________________________________________ [2] ASW2W8 3763 8 [Turn over (e) Describe two benefits of having the same user interface in each of the generic packages. Examiner Only Marks Remark 1. _______________________________________________________ _________________________________________________________ 2. _______________________________________________________ _______________________________________________________ [4] ASW2W8 3763 9 [Turn over 6 Data about items of garden furniture is held in a database as shown below. Examiner Only Marks ItemID ItemName UnitPrice Quantity OnOrder(Y/N) Remark 3450083 Portable log burner 79.99 150 N (a) Describe the most suitable data type for each of the following. Quantity _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] ItemName _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] UnitPrice _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] OnOrder _________________________________________________________ _______________________________________________________ [2] ASW2W8 3763 10 [Turn over (b) ItemID is used to produce a hash total. Examiner Only Marks Remark (i) Explain what is meant by a hash total. _____________________________________________________ _____________________________________________________ ___________________________________________________ [2] (ii) Describe how the hash total could be used in this case. _____________________________________________________ _____________________________________________________ _____________________________________________________ _____________________________________________________ _____________________________________________________ ___________________________________________________ [4] ASW2W8 3763 11 [Turn over 7 A person wishing to join a sports club must first complete an application form by hand. Examiner Only Marks Remark Data from completed forms is added to a database by clerical staff. (a) Describe a verification check which could be carried out in this case. _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] (b) Name and describe three different data validation checks. 1. Name ________________________________________________ Description ___________________________________________ _____________________________________________________ 2. Name ________________________________________________ Description ___________________________________________ _____________________________________________________ 3. Name ________________________________________________ Description ___________________________________________ ___________________________________________________ [6] (c) Explain why both verification and validation checks should be performed on each applicant s date of birth. _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] Quality of written communication ASW2W8 3763 12 [Turn over THIS IS THE END OF THE QUESTION PAPER ASW2W8 3763 13 [Turn over ASW2W8 ASW2W8 3763 14 [Turn [Turn over ASW2W8 3763 15 [Turn over S 6/07 302-045-1 16 [Turn over

Formatting page ...

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