2000 as Computer Application

2000-ASL COMP APP

PAPER 1

HONG KONG EXAMINATIONS AUTHORITY HONG KONG ADVANCED LEVEL EXAMINATION 2000

COMPUTER APPLICATIONS AS-LEVEL PAPER 1

8.30 am – 11.30 am (3 hours) This paper must be answered in English

1.

This paper consists of two sections, A and B. Section A carries 40 marks and Section B carries 60 marks. Answer all questions in Section A and Section B.

2.

©

Hong Kong Examinations Authority All Rights Reserved 2000

2000-AS-COMP APP 1–1

Section A (40 marks) Answer all questions in this section. 1. (a) A teacher uses a database file to store the information about his students. The file has the following structure: Field ID Name Test1 Test2 Test3 Totaltest Exam Grade Data type character character integer integer integer integer integer character Data length 8 25 3 3 3 3 3 1 Description Student identity number Name of student Marks on test 1 Marks on test 2 Marks on test 3 Total marks on tests 1 to 3 Examination marks Grade based on average of all marks

The teacher inputs marks and grades to the database file after each test or examination. At the end of the school term, he finds some problems in the file design. Identify fields that are redundant and explain why the fields are redundant. (4 marks) (b) The teacher would like to add a field that will store the talent of the students (e.g. special skills, strengths, personal interests, etc.) to the database file. The teacher cannot decide whether the field should be declared a character type or a memo type. Compare the two data types and recommend the most suitable data type for the teacher to use. (4 marks) 2. A student prepares a presentation using a graphical presentation software. There are twenty slides in the presentation. Twenty slides appear one after the other and the presentation is rather dull. Suggest FOUR features of a graphical presentation software that could be used to make the presentation more interesting. (4 marks)

2000-AS-COMP APP 1−2

−1−

All Rights...