1



TERM THREE-2015 END-YEAR EXAM

FORM 3, COMPUTER STUDIES

TIME: 2 ¼ HOURS

1. What does the following control measures against computer crime involve? 4 Marks

a. Audit trail

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

b. Data encryption

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

c. Log files

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

d. Passwords

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

1. List four examples of flat panel displays 2 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

2. Define the term mail merging 2 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

4. Define the following terms used in data communications=

i. Data signal (1 Mark)

ii. Multiplexing (1 Mark)

iii. Bandwidth (1 Mark)

iv. Baseband (1 Mark)

v. Attention (1 Mark)

5 Name two files that are created in mail merging process 2 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

6. While purchasing computers for his school, the principal Musambweni high school decided to consult an expert. As a computer student advise him on four hard ware considerations 4 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

7. Name four methods used in data management on a worksheet 2 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

8. List four formatting techniques used in ms excel 2 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

9. a. Describe three methods of testing the program for errors 3 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

b. List down four selection controls use in writing a program 2 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

c. Outline four benefits of modularization in programming 2 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

10. Get the value of X 9 Marks

a. 11.0112(X10

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

b. 4538(X2

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

c. AD216(X8

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

b. Outline four ways in which data integrity may be maintained 4 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

c. Discuss four advantages of using questionnaires as a fact finding tool 4 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

d. What is the role of a clipboard in a computer? 1 Mark

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

11. a. List three advantages of using computer in your church 3 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

b. Differentiate between static RAM and dynamic RAM. 4 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

c. Describe the following types of queries found in Ms. Access 3 Marks

i. Update query

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

ii. Append query

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

ii. Make table query

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

d. Distinguish between source program and object code 2 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

e. Give the appropriate circumstances for using either insert mode or type over mode 2 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

12. a. Masai Teacher’s college has decided automate its library for effective services to the students

Identify four methods they are likely to use to gather information during system development

4 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

b. Define the following terms in relation to Internet 4 Marks

i. Downloading

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

ii. Hyperlink

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

iii. Web browser

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

iv. Internet service provider

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

c. Differentiate between sorting and filtering as used in electronic spreadsheet program 2 Marks

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

d. Define the following terms 3 Marks

i. Spam mail

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

ii. Mail attachment

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

iii. On board modem

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

e. Define the term icon as used in computing 1 Mark

…………………………………………………………………………………………………………………..

…………………………………………………………………………………………………………………..

13. Explain the following types of computer network

i. Local area network (LAN) 2 Marks

ii. Wide area network (WAN) 2 Marks

14. Draw and explain the satellite transmission system 6 Marks

15. State five communication devices as used to establish computer network 5 Marks

16. What is the function of a repeater on the network? 1 Mark

17. Name two advantages of satellite communication 2 Marks

18. Differentiate between single mode and multimode fiber optic 2 Marks

19. State three advantages and one disadvantage of wireless communication 4Marks

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download