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

GCE JAN 2007 : A2 2 Uses of Information Systems

4 pages, 24 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 ...

ADVANCED General Certificate of Education January 2007 Information and Communication Technology assessing Module 5: Uses of Information Systems A2W21 Assessment Unit A2 2 [A2W21] TUESDAY 9 JANUARY, MORNING TIME 1 hour 30 minutes. INSTRUCTIONS TO CANDIDATES Write your Centre Number and Candidate Number on the Answer Booklet provided. 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. A2W2W7 2833 Answer all seven questions. 1 A teacher obtained the following examination results by entering values into the shaded cells in a spreadsheet. All other cells in the spreadsheet were locked. A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 B C D E F G H I Pass mark = 120 Examination Results Student Test 1 Test 2 Test 3 Total Grade Amber Black Brown Gray Green Grey Lemon White 34 54 66 7 43 23 45 34 45 67 54 62 35 43 27 90 25 4 43 44 67 21 23 24 104 125 163 113 145 87 95 148 Fail Pass Pass Fail Pass Fail Fail Pass (a) Identify the type of contents contained in each of cells A4 and B6. (b) Describe the contents of cell E6. [2] (c) Describe the contents of cell F6. [4] (d) Explain how the teacher could make use of cell I4. [4] (e) The teacher wishes to compare how students have performed in Test 1 and Test 2. Describe how the teacher could create a suitable graph using the spreadsheet. 2 [2] [4] A student books a flight on an airline s web site. (a) For each of the following headings, identify two activities which take place as the booking is made. (i) Input (ii) Output (iii) Processing (iv) Feedback A2W2W7 2833 [8] 2 (b) Describe how the web site might assist the airline to make decisions at each of the following levels. (i) Operational level (ii) Strategic level 3 [8] The manager of a video rental shop is looking at ways of improving its business. The manager uses both internal and external sources of information. (a) One internal source is the number of videos out on loan. The manager uses this information to order extra copies of the most popular videos. Identify two other internal sources of information and state how each could be used by the manager. [4] (b) Describe three external sources of information and state how each could be used by a video rental shop. [6] 4 A college uses a computerised system for examination entries and results. (a) Explain what is meant by a data processing system in this case. [4] Reports from a management information system (MIS) are used to check the success rate of each course. (b) Explain how the MIS will use this data processing system. (c) Describe two reasons why the quality of the reports from the MIS might be unsatisfactory even when the data is accurate and up-to-date. 5 [4] [4] A company plans to implement an off-the-shelf payroll package using parallel running. (a) Explain what is meant by parallel running and explain why it is suitable for this package. [4] (b) The two employees who will use the system must be trained. Describe how these employees could be trained by each of the following methods and comment on the suitability of each in this case. (i) A formal course. (ii) A video tape. A2W2W7 2833 [6] 3 [Turn over 6 A company uses a computer network which is not connected to the Internet. (a) Describe three ways in which the company s data might be at risk. [6] (b) Some of the company s data is critical to its business. Describe a suitable backup strategy and explain how this data will be recovered. [4] (c) Some of the data is updated at the end of each month. Describe a suitable backup strategy and explain how this data will be recovered. 7 [4] A software house wishes to ensure that its employees comply with the law. (a) Describe two implications of Copyright Designs and Patents legislation for the employees. [4] (b) Describe two implications of Computer Misuse legislation for the employees. [4] A2W2W7 2833 4 S 11/06 1200 9-066-1

Formatting page ...

Additional Info : Gce ICT January 2007 Assessment Unit A2 2, Module 5: Uses of Information Systems
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: