Get premium membership and access revision papers, questions with answers as well as video lessons.

Borabu District Mock - Computer Studies Paper 1 Question Paper

Borabu District Mock - Computer Studies Paper 1

Course:Secondary Level

Exam Year:2012

NAME……………………………………………………………….DATE ……………………………
INDEX NO………………………………………………CANDIDATE’S SIGNATURE……………
451/1
COMPUTER STUDIES
PAPER 1
(THEORY)
JULY/AUGUST 2012
TIME: 2 ½ HOURS
BORABU-MASABA DISTRICTS JOINT EVALUATION TEST– 2012
Kenya Certificate of Secondary Education (K.C.S.E)
451/1
COMPUTER STUDIES
PAPER 1
(THEORY)
JULY/AUGUST 2012
TIME: 2 ½ HOURS
INSTRUCTIONS TO CANDIDATES
Write your name and index number in the spaces provides above
Sign and write the date of examination in the spaces provided
This paper contains two section: Section A and B.
Answer all questions in section A.
Answer question 16 (Compulsory) and any other THREE questions in section B.
All answers should be written in the spaces provided in the question paper

This paper consists of 8 printed pages. Candidates should check the question paper to ensure that all the papers are printed as indicated and no questions are missing
SECTION A (40 MARKS)
Answer ALL the questions in this section in the space provided.
1. (a) State the purpose of registers in a computer system. (1mk)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(b) Name two types of registers found in the central processing unit. (lmk)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
2. State two practices to be observed in order to ensure the safety of the computer user (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
3. List four stages in data collection (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
4. (a) State two importance of internet to society. (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(b) Describe two challenges that internet has brought to society. (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
5. (a) Define portability as used in software selection (lmk)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(b) List four ways of acquiring software in an organization (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
6. (a) Subtract 1102 from 110102 (lmk)
(b) Find the sum of binary number 101.1012 and 110.1002 (lmk)
7. Outline two major functions of UPS in computer Iaboratory. (2 marks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
8. (a) Define virtual reality. (1 mark)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(b) List any two applications of virtual reality. (1 mark)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
9. (a) List three ways by which you can provide a common link or relationship between the
table in a database software (3mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(b) What is referential integrity (1 mk)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
10. Differentiate between SRAM and SDRAM (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
11. State two advantages and two disadvantages of impact over non-impact printers. (4mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
12. State two advantages of USB port over the parallel port (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
13. List down two examples of High level language (HLL) and state its most appropriate application.
(2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
14. (a) Differentiate between a logical file and a physical file. (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(b) Name four types of computer files. (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
15. a). Define the term mail merging (1 Marks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
b). Name two files that are created in mail merging process (2 Marks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
SECTION B (60 MARKS)
Answer question 16 and any other three questions from this section in the spaces provided.
16. Study the flow chart below and answer the questions that follow
(a) What would the flow chart generate as output if the value of N at input was
(i) 6? (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(ii) 1? (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(b) Write a Pseudo code that does the same thing as the chart above. (7mks)
(c) Modify the flow chart so as to reject an input below 0 and to avoid looping when the input is (4mks)
17. (a) State any three duties of the following ICT personnel.
(i) Systems analyst. (3 marks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
(ii) Database administrator. (3 marks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
(iii) Web master (3 marks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
(b) Name any three ICT courses offered in the Kenyan universities. (3 marks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
(c) Outline three advantages of telecommuting. (3 marks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
18. (a) The formula = K20 + P $ 18 was typed in cell L21 and then copied to cell M24 of a
spreadsheet. Write the formula as it appears in cell M24. (2mks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(b) (i) Define the term spreadsheet. (1 mk)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(ii) Give two examples of spreadsheet packages available in the market today. (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(iii) Explain the following terms as used in a spreadsheet.
What IF analysis (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
Cell (lmk)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
Formula (lmk)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
Pie-chart (lmk)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(c) Distinguish between the following sets of terms used in spreadsheet.
(i) Worksheet and workbook (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(ii) Filtering and sorting (2mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(d) State one way in which a user may reverse the last action taken in a spreadsheet package.
(lmk)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
19. (a) Define artificial Intelligence. (1 mark)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(b) Explain the application of artificial intelligence in the following areas. (6 marks)
(i) Natural language processing
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
(ii) Robotics
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(iii) Expert systems
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
(b) Give any three symptoms of the following computer work-related disorders and two of
their methods of prevention.
(i) Computer vision syndrome. (4 marks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(ii) Repetitive strain injuty. (4 marks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
20. (a) Define the term ergonomics (1 mark)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(b) (i) Give any three advantages of using a fibre optic cable in data transmission. (3 mks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
(ii) Name two types of fibre optic. (1 mark)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(c) State three advantages of wireless communication. (3 marks)
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
………………………………………………………………………………………………………………
(d) Explain the following terms. (3 marks)
(i) Multiplexing
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(ii) Bandwidth
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(iii) Baseband signal
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(e) Explain the use of these communication devices. (4 marks)
(i) Routers
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
(ii) Hub
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………….
End

Borabu District Mock - Computer Studies Paper 1 Question Paper

More Question Papers

Popular Exams