Computer Paper 1 SECTION A (40 MARKS)
Answer all prediction questions from this section in the spaces provided
- List the components of a computer system hardware. (2 Marks)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………… - Describe the term key to storage systems (1 Mark)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………… - One classification of software is system software
(a) i. What is meant by system software (1 Mark)
…………………………………………………………………………………………………………………………………………………………………………………..…………………………………………..
ii. Give one example of system software. (1 Mark)
……………………………………………………………………………………………………………………………………………………………..……………………….……………………………………….
(b) i. Name one other software classification (1 Mark)
………………………………………………………………………………………………………………………………………………………………………………………………………………………………
ii. Give one example of this type of software (1 Mark)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………… - a. What do you understand by the term database management system? (DBMS)? (1 Mark)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………….
b. Define the following terms as used in a database. (2 Marks)
i. Primary Key
………………………………………………………………………………………………………………
ii. Record
……………………………………………………………………………………………………………… - Differentiate between COMports and LPT ports (2 Marks)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………… - List three factors to consider when deciding on the choice of electronic data processing method (3 Marks)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………… - Ventilation is an important practice in the computer lab because it enhances proper circulation of air.
Outline three ways in which air is regulated in the computer room. (3 Marks)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………… - What do the following control measures against computer crime involve? (4 Marks)
a. Audit trail
……………………………………………………………………………………………………………….
b. Data encryption
………………………………………………………………………………………………………………..
c. Log files
……………………………………………………………………………………………………………
d. Passwords
…………………………………………………………………………………………………………… - Highlight the use of find and replace features in word processors. (2 Marks)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………… - Explain why two’s complement is preferred to one’s complement in computing. (1 mark)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………… - Computers have evolved through a number of generations. List any three characteristics of the first generation of computers. (3 marks)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………… - List four formatting techniques used in Ms excel (2 Marks)
………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………. - List four examples of flat panel displays. (2 Marks)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………… - Explain the following terms as used in the word processing. (4 Marks)
a. Indenting
……………………………………………………………………………………………………………….
b. Alignment
……………………………………………………………………………………………………………….
c. Footnote
……………………………………………………………………………………………………………….
d. Endnote
……………………………………………………………………………………………………………….. - Describe the role of an operating system in
i. Memory management
………………………………………………………………………………………………………………..
ii. Job scheduling
…………………………………………………………………………………………………………………
iii. Error handling
………………………………………………………………………………………………………………..
iv. Resource control
………………………………………………………………………………………………………………..
SECTION B (60 MARKS) - a. State the three basic types of program control structures. (3 Marks)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..
b. Draw a flowchart which will simulate the processing of student’s report. The simulation should be such that the user repeatedly inputs marks per subject for six subjects using a looping control structure. The computer processes the total marks and mean score of the student.
NOTE:- It is assumed that the student does six subjects
- The output required are: Average score and total marks
c. Differentiate between analogue and digital data. (2 Marks)
………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
d. Outline three advantages of using computers for data processing over other types of office and business equipment.
………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
- a. Convert the following numbers to their decimal equivalent. (6 Marks)
i. 11.0112
………………………………………………………………………………………………………………………………………………………………………………………………………………………………
ii. 12.158
………………………………………………………………………………………………………………………………………………………………………………………………………………………………
iii. A3.3/6
………………………………………………………………………………………………………………………………………………………………………………………………………………………………
b. Outline four ways in which data integrity may be maintained. (4 Marks)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….
c. Explain four advantages of using questionnaires as a fact finding tool. (4 Marks)
………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
d. What is the role of a recycle bin? (1 Mark)
……………………………………………………………………………………………………………… - a. Masai teacher’s college has decided to 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. What do the following terms mean in relation to internet? (4 Marks)
i. Downloading
………………………………………………………………………………………………………………..
ii. Hyperlink
………………………………………………………………………………………………………………..
iii. Web browsers
……………………………………………………………………………………………………………….
(iv) Internet service providers
………………………………………………………………………………………………………………
c. Differentiate between sorting and filtering as used in electronic spreadsheet program (2 Marks)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….
d. What do the following terms mean
i. Spam mail
………………………………………………………………………………………………………………………………………………………………………………………………………………………………
ii. Disk
………………………………………………………………………………………………………………………………………………………………………………………………………………………………
iii. Onboard moderm
………………………………………………………………………………………………………………………………………………………………………………………………………………………………
e. What does the term WIMP mean as used in computing?
…………………………………………………………………………………………………………………………………………………………………………………………………………………………….. - (a) Define a database model (1Mark)
………………………………………………………………………………………………………………………………………………………………………………………………………………………………
b. List four advantages of using database systems (2marks)
………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
c. In a database system, data integrity ensures the correctness and completeness of the data in the database. Differentiate the following types of integrity constraints:
i. Validity integrity (1mark)
………………………………………………………………………………………………………………
ii. Entity integrity (1mark)
……………………………………………………………………………………………………………….
iii. Referential integrity (1mark)
………………………………………………………………………………………………………………
d. Briefly describe the three database models (3 Marks)
………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
e. Using diagrams describe the following three types of relationships. (3Marks)
i. One – to – one ii. One – to – many iii. Many – to – many f. File organization refers to the arrangement of records on secondary storage. Briefly describe the following file organization methods. (3 Marks)
i. Serial
…………………………………………………………………………………………………………..
ii. Sequential
………………………………………………………………………………………………………….
iii. Random
………………………………………………………………………………………………………….. - a. Your School has decided to replace its library control system. The current system was implemented ten years ago but has restricted reporting facilities and has a text – based interface. The school intends to replace the old system with a new computerized system, and is now considering both ‘parallel running ‘ and ‘direct changeover’
i. Briefly explain the terms parallel running and direct change over as used in system implementation. (2 Marks)
…………………………………………………………………………………………………………………………………………………………………………………………………………………………
ii. Give two disadvantages of direct changeover overparallel running (1 Marks)
………………………………………………………………………………………………………………………………………………………………………………………………………………………………..
iii. Identify two main risks of direct changeover during system implementation (2 Marks)
………………………………………………………………………………………………………………………………………………………………………………………………………………………………
iv. Mention any two advantages of running both the manual system and the computerized system simultaneously (2 Marks)
………………………………………………………………………………………………………………………………………………………………………………………………….…………………………..
b. i. What is a website? (2 marks)
………………………………………………………………………………………………………………………………………………………………………………………………………………………………
ii. Name three facilities that are needed to connect to the internet. (3 Marks)
………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
c. State three ways students can benefit by having internet in a school (3 Marks)
