KASAMA COLLEGE OF EDUCATION Affiliate of THE UNIVERSITY OF ZAMBIA

SECONDARY TEACHERS’ DIPLOMA END OF TERM 2 EXAMINATIONS- 2017

COMPUTER STUDIES EDUCATION TIME: 1 Hour 30 minutes

Confidential

MARKS : 50

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15.

B - Software tool C- Backing store C- Query Processing B- Demodulator C- Assembler B- Moderm C- Almost unlimited Array A- Volatile Distance covered by the networks A- Monitor B- Information B- Rules that have been set D- very the link status on the computer’s network card A- Faulty hard drive Ctrl + Alt+ Del

Section B 16. Identify four of these input devices and for each one describe a different item of data that will

be input 1. Chip reader Bank/credit card account information/supermarket code 2. Bar code reader Information from a product label/product identity number 3. Electronic scales Weight of an item 4. Touch screen Identification of product 5. Number pad Bar code number when bar code reader cannot read bar code/the number of items 6. Magnetic stripe reader Information about the customer 17. State the hardware, software and services required to access and use the Internet. a. Hardware: Modem/broadband/Router Software: communications software/dial-up software/software to connect to Internet ISP/browser, e-mail b. State two ways that a report could be sent to the office using the Internet i. e-mail ii. file attachment iii. uploading to web site iv. fax v. messaging/chat room c. State two of the additional items of hardware that would be required for video conferencing. i. video camera/digital camera/web cam ii. microphone

iii. iv. v. vi.

AD/DA converter with compression for video and sound ISDN/ADSL/midband/broadband Satellite dish Speakers

18.

A

B

C

D

E

F

Stock

Amount Sold

Stock left

Prices (K)

Total Sales (K)

Wap

20

10

10

220

2200

Water Resistant

10

2

8

115

230

Calendar

5

4

1

76

304

Data Bank

15

5

10

33

165

Day Date

10

5

5

95

475

1 2 3 4 5 6 7

Total

3374

a. State the format of the data in column B. Numbers and letters b. Columns D, E and F contain formulae. Write down a formula that could be in cell F7 to calculate the Total Sales. =SUM( F2:F6) or =F2+F3+F4+F5+F6 c. The value in C5 is changed to 6. State the cells in which the values should change automatically. d. F5 and F7

19. State three storage media that use: a. Magnetic Technology. b. Laser Technology. c. Micro chip Technology.

Floppy And Hard disc CDs, DVD Flashes, Memory Cards

20.

(a) What operating system is installed on this computer? Windows 7 home Premium (b) What type of software is an operating system? System software (c) What is the meaning of operating system? Is a software that controls, coordinates all the computers peripherals and act as a platform of all other application software (d) What is the processing speed of this computer? 1.5Ghz (e) That is the size of memory that determines the program to be installed 2.00 GB

Section C [10 Marks] Answer any question in this section. Each question carries 10 Marks 1. Explain any three hardware requirements for setting a Local Area Network (LAN). (a) Routers (b) Modem

(c) (d) (e) (f) (g) (h)

Network cables NIC (Network Interface Card) Hub Switch Bridge Gateway

2. Explain the Topologies in Local Area Network (LAN) (a) Point to Point (b) Star (c) Ring (d) Bus (e) Mesh (f) Hybrid (g) Tree (h) Thin client