Confidential ICT Curriculum Unit

3765/1 ICT Trial Exam 2007 1 Selangor Education State Department

SECTION A (36 scores) This section consists of 25 questions. Answer ALL questions in the answer sheet provided at the end of this question paper. Questions 1- 10 Choose the BEST answers for questions 1-10. 1. Question number 1 is based on Figure 1: Figure 1 X is best described as A. Spam C. spyware B. Cookies D. electronic profile 2. Transistor was invented in ________________ generation. A. First B. Second C. Third D. Fourth

3. Computer ethic refers to ___________. I A study about moral principal. II A custom that guides human behaviour. III A regulation that must be obeyed by the public. IV A knowledge about what is good and what is bad. A. I, II and III C. I, III and IV B. I, II and IV D. II, III and IV 4. To convert conventional images to digital images, _____________ are used. 5. The risk to a bus network is that ____

A. the bus itself might become inoperable

B. the failure of one device usually affects the rest of the network C. devices attached or detached at any point on the bus disrupt the rest of the network D. all of the above statements are true about risk to a bus network A. cameras C. computers B. scanners D. audio devices Confidential ICT Curriculum Unit 3765/1 ICT Trial Exam 2007

2 Selangor Education State Department

6. A _____ is a high-speed network that connects networks in an area such as a city or town and handles the bulk of communications activity across that region. A. Local Area Network (LAN) C. Wide Area Network (WAN) D. Variable Area Network (VAN)

B. Metropolitan Area Network (MAN)

7. There are two types of programming approaches, which are ______ programming. I. object III. structured II. design IV. object-oriented

A. I and II B. I and III C. II and III D. III and IV 8. One of the benefits of database is to ______________________. A. Access information easier B. Transform data to other format C. Differentiate software and hardware credits D. Develop the application software based on run-time. 9. Printer resolution is measured by the number of _____ a printer can output. A. dots per inch (dpi) C. pixels per inch (ppi) B. characters per inch (cpi) D. bits per inch (bpi) 10. Current personal computer hard disks have storage capacities from 40 to 300 ____ and more. A. KB B. GB C. MB D. PB

Questions 11 15 are true and false statements. Write T for true statements and F for false statements. 11. During the process of creating, editing, and formatting a document, the computer holds it on a storage medium. 12. Automatic Teller Machines (ATMs) are good examples of online Transaction Processing Systems. 13. Computer-Aided Design (CAD) is an example of multimedia used in creating movies.

14. We need computer ethics and laws to guide users from misusing the computer. a. Using materials from websites as a resource for assignment without giving credit to the original author is considered unethical. b. Selling pirated software to a friend is an example of law breaking conduct. 15. Peer-to-peer networks are ideal for very large businesses and corporate users. Confidential 3765/1 ICT Trial Exam 2007 ICT Curriculum Unit Questions 16 20 Match the following phrases to their correct statements below. 16. A Query a) Someone who has the same intent as a cracker but does not have the technical skills and knowledge. They are often teenagers. 17. Script Kiddie b) User manual, output records and program listing. 18. Documentation phase 3 Selangor Education State Department

c) The tasks of reorganizing of the disk so that the files are stored in contiguous sectors. 19. Disk Defragmenter d) Networking within PC using cross cable. 20. Peer to peer network e) Is a description of the records you want to retrieve from a database, based on certain criteria. Questions 21-25 Fill in the blanks with correct answers.

21. A computer system consists of four major hardware components; input devices, .............................., ..................................., and .......................... 22. The six phases in multimedia development are , and publishing. ., design,

23. Antivirus software is a program that viruses in your computer memory, storage media or incoming files. It will viruses and other malicious software. 24. Program and . helps the programmer to ..prevent and . computer

assess the weakness of a program. 25. They are four types of Intellectual Property protection. They are ___________ for invention, _______________ for brand identity, _______________ for product appearance and ____________ for material Confidential ICT Curriculum Unit SECTION B (20 scores) This section consists of FIVE questions. Answer ALL questions in the space provided. 4 Selangor Education State Department 3765/1 ICT Trial Exam 2007

Question 1 The following illustrations are steps in scanning virus not in the proper order. Rearrange the steps on how to scan antivirus using 1, 2, 3 and 4 as indicators. Use the space provided at the right of each illustration. (4 scores) Question 2 Below are four examples of computer software. Based on the examples, answer the questions that follow. a) Explain any two of the software given. (2 scores) ___________________________________________________ ___________________________________________________ b) Explain briefly the use the software you have chosen in Question a) (2 scores) _____________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ Windows XP Microsoft excel AVG AntiVirus Zip Disk Confidential ICT Curriculum Unit Question 3 a) The multimedia program that is developed can be published and distributed to the users through two common medium of delivery. They are: (2 scores) _____________________________________________________________________ _____________________________________________________________________ 3765/1 ICT Trial Exam 2007 5 Selangor Education State Department

_____________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ c) Give an example of the advantage of using multimedia in medicine. (1 score) _____________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ e) Give an example of a task or activity that is carried out in the Design Phase of Multimedia Development. (1 score) _____________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ Question 4 In the school library where the number of books is increasing, librarians face problems in registering or cataloguing their books without the help of a computer system. As a programmer, based on pseudo code given, complete the flow chart (on page 6) provided to solve the problem. Library system Purpose : Computerizes library system Data input: Book s title Author

 Publisher Processing: Get all the data Check data Output: Book registered Confidential ICT Curriculum Unit Question 5 Answer the following questions on Computer Networks and Communication. a) Give two advantages of using a networking rather than a stand-alone pc. (2 scores) ______________________________________________________________ ______________________________________________________________ b) Define the network communication technology of Extranet. (2 scores) _______________________________________________________________ _______________________________________________________________ Request book title, author, publisher from user. Check data input Any field empty? TRUE FALSE Print Please Fill Up all the data Print _____________ Confidential 3765/1 ICT Trial Exam 2007 3765/1 ICT Trial Exam 2007

6 Selangor Education State Department

ICT Curriculum Unit SECTION C (14 scores)

7 Selangor Education State Department

This section consists of THREE questions. You MUST answer QUESTION 1. You can choose to answer question 2 OR question 3. Question 1 Based on the following situation, answer questions (a) (d). The form teacher of 4 IT class is required to submit a report on the monthly test results for each student to the school administration. As and ICT student, you are asked to develop a Test Marks Information System (TMIS) to assist the teachers in recording the subject marks obtained by each student. TIMS should generate a report to show the subject marks, total marks and average marks of the student from each class. (a) Define Information System. (1 score) _____________________________________________________________________ _____________________________________________________________________ Answer Question (b) (d) in the box provided on page 8. (b) Imagine that you are creating a database in the computer that consists of the following items: (i) one table for student, namely table STUDENT (ii) one table for class, namely CLASS. You are to DRAW the tables of your database on the paper. The database should store student ID, name, class, form teacher and marks for each subject taken. Fill in the field names and relevant data in each table. (4 scores) (c) Based on the table that you have drawn for question (a), state the Primary Key for both tables. Write your answer in the box provided. (1 score)

(d) Show the relationship of both tables. You can do so by drawing a line for the tables you have sketched in question (a). (1 score) Total: 7 scores Confidential ICT Curriculum Unit 3765/1 ICT Trial Exam 2007

8 Selangor Education State Department

PRIMARY KEY: ___________________ (1 score) Question 2 Figure 2 shows the phases of Program Development process. Based on the figure, answer the following questions. Figure 2 Program Design Phase Testing and Debugging Phase Compiling, testing and debugging program Problem Analysis Phase Analysis and problem definition Phase Q Phase PConfidential ICT Curriculum Unit 3765/1 ICT Trial Exam 2007 9 Selangor Education State Department

Write your answer for Questions (a) (d) in the space provided. (a) Name Phase P and Phase Q (2 scores) __________________________________________________________________ __________________________________________________________________ (b) Arrange the phases in correct sequence. (1 score) __________________________________________________________________ __________________________________________________________________ (c) State two importance of Phase P in Program Development process. (2 scores) __________________________________________________________________

__________________________________________________________________ __________________________________________________________________ __________________________________________________________________ (d) Describe any translation method used in Phase Q. (2 scores) Total: 7 scores __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ Confidential 3765/1 ICT Trial Exam 2007 ICT Curriculum Unit Question 3 Figure B Figure A a) Refer to Figure A and Figure B. Which figure uses a straight cable for connection? (1 score) ______________________________________________________________ b) Describe how to create a sharing folder which appears on the desktop. (2 scores) 10 Selangor Education State Department

_____________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ c) Sketch two topologies other than Figure A in the boxes below. (4 scores) i) ii) SERVERConfidential 3765/1 ICT Trial Exam 2007

ICT Curriculum Unit END OF QUESTION PAPER

11

Selangor Education State Department