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

GCE JAN 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 January 2009 Information and Communication Technology assessing Module 2: Components of Information and Communication Technology ASW21 Assessment Unit AS 2 [ASW21] FRIDAY 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 eight questions. For Examiner s use only Question Number 1 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. 2 3 4 5 6 7 8 QWC Total Marks 4295 Marks BLANK PAGE 4295 2 [Turn over 1 A joystick is used in a computer game. Examiner Only Marks Remark (a) Explain how data is captured using a joystick. __________________________________________________________ __________________________________________________________ __________________________________________________________ __________________________________________________________ __________________________________________________________ _______________________________________________________ [4] (b) Describe two advantages of using a joystick instead of the keyboard to play a game. 1. ________________________________________________________ __________________________________________________________ __________________________________________________________ 2. ________________________________________________________ __________________________________________________________ _______________________________________________________ [4] 4295 3 [Turn over 2 A teacher uses a computer to update pupils marks in a database. Examiner Only Marks Remark (a) Describe two ways in which RAM will be used in this case. 1. ________________________________________________________ __________________________________________________________ __________________________________________________________ 2. ________________________________________________________ __________________________________________________________ _______________________________________________________ [4] (b) Describe two ways in which external memory will be used in this case. 1. ________________________________________________________ __________________________________________________________ __________________________________________________________ 2. ________________________________________________________ __________________________________________________________ _______________________________________________________ [4] (c) Explain how a computer uses ROM. __________________________________________________________ __________________________________________________________ _______________________________________________________ [3] 4295 4 [Turn over 3 A large university uses a WAN. Examiner Only Marks Remark (a) Explain the main difference between a WAN and a LAN. __________________________________________________________ __________________________________________________________ _______________________________________________________ [2] The WAN includes a firewall and a proxy server. (b) Describe two reasons why a firewall is used on a network. 1. ________________________________________________________ __________________________________________________________ __________________________________________________________ 2. ________________________________________________________ __________________________________________________________ _______________________________________________________ [4] (c) Describe two reasons why a proxy server is used on a network. 1. ________________________________________________________ __________________________________________________________ __________________________________________________________ 2. ________________________________________________________ __________________________________________________________ _______________________________________________________ [4] 4295 5 [Turn over 4 A computer user must complete the following onscreen form. Examiner Only Marks Remark (a) Explain the purpose of data validation. __________________________________________________________ __________________________________________________________ _______________________________________________________ [2] (b) By referring to the screen, name and describe two validation checks. Validation check ___________________________________________ Description _______________________________________________ _______________________________________________________ [2] Validation check ___________________________________________ Description _______________________________________________ _______________________________________________________ [2] 4295 6 [Turn over (c) Explain the purpose of data verification. Examiner Only Marks Remark _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] (d) Explain how data verification is used in this case. _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] 4295 7 [Turn over 5 (a) Describe the main features of batch processing. Examiner Only Marks Remark __________________________________________________________ __________________________________________________________ __________________________________________________________ __________________________________________________________ __________________________________________________________ _______________________________________________________ [4] (b) Describe the main features of real-time processing. __________________________________________________________ __________________________________________________________ __________________________________________________________ __________________________________________________________ __________________________________________________________ _______________________________________________________ [4] (c) Identify and justify a common application where batch processing is suitable. __________________________________________________________ __________________________________________________________ _______________________________________________________ [2] (d) Identify and justify a common application where real-time processing is suitable. __________________________________________________________ __________________________________________________________ _______________________________________________________ [2] 4295 8 [Turn over BLANK PAGE (Questions continue overleaf) 4295 9 [Turn over 6 (a) Describe the main features of each of the following: Examiner Only Marks Remark A menu interface __________________________________________________________ __________________________________________________________ __________________________________________________________ __________________________________________________________ _______________________________________________________ [3] A command line interface __________________________________________________________ __________________________________________________________ __________________________________________________________ __________________________________________________________ _______________________________________________________ [3] 4295 10 [Turn over (b) Describe how a number of copies of a report could be printed using each of the following: Examiner Only Marks Remark A menu interface __________________________________________________________ __________________________________________________________ __________________________________________________________ __________________________________________________________ _______________________________________________________ [3] A command line interface __________________________________________________________ __________________________________________________________ __________________________________________________________ __________________________________________________________ _______________________________________________________ [3] 4295 11 [Turn over 7 Consider the following data capture form. Examiner Only Marks Name Pat Smith Age (in years) 28 Home owner N Income Remark 15,000 Identify and justify the most suitable data representation for each of the following: Name Representation _________________________________________________ Justification ___________________________________________________ ___________________________________________________________ [2] Age Representation _________________________________________________ Justification ___________________________________________________ ___________________________________________________________ [2] Home owner Representation _________________________________________________ Justification ___________________________________________________ ___________________________________________________________ [2] Income Representation _________________________________________________ Justification ___________________________________________________ ___________________________________________________________ [2] 4295 12 [Turn over BLANK PAGE (Questions continue overleaf) 4295 13 [Turn over 8 A library stores details about its music collection in a database using the following tables. Examiner Only Marks Remark Table 1 AlbumID Album Title Artist No. of Tracks A101 . . . SongID Song Title Composer S101 . . Table 2 Table 3 SongID AlbumID S101 A101 (a) By referring to the above tables explain what is meant by A key field _______________________________________________ _________________________________________________________ _______________________________________________________[2] A composite key __________________________________________ _________________________________________________________ _______________________________________________________[2] 4295 14 [Turn over (b) Explain how these tables will be linked in the database. Examiner Only Marks Remark _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________[3] (c) Describe how the librarian could search for the names of all the songs on a particular album where the AlbumID is known. _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________[3] (d) Describe how the librarian could produce a list of the names of all songs by a particular artist. _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _______________________________________________________[5] Quality of written communication 4295 15 [Turn over 935-035-1 16 [Turn over

Formatting page ...

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