Computer Studies Paper 1 Questions - Mumias West Pre Mock Exams 2023

INSTRUCTIONS TO CANDIDATES

• This paper consists of TWO sections A & B
• Answer ALL the questions in section A
• Answer question 16 and any other THREE questions from section B
• All answers should be written in the spaces provided on the questions paper

For Official Use Only

QUESTIONS

SECTION A: (40 marks)
Answer all the questions in this section in the spaces provided

1. State two hardware characteristics of the computers in use in the fourth generation (1 mark)
2. State two benefits of using automated teller machines in the banking industry (2 marks)
3. Explain two electrical related problems which might be experienced in a computer laboratory (4 mark)
4. State two functions of a firewall in a computer system (2 marks)
5. Differentiate between insert and overtype modes as used in word processing (2 marks)
6. Give the function of each of the following word processing features:
   1. comment; (1 mark)
   2. document protect; (1 mark)
   3. mail merge (1 mark)
7. Write an algorithm that can be used to develop a program that prompts for a number, computes its square and then displays the result (3 marks)
8. Convert the number -11₁₀ into 9-bit ones complement (3 marks)
9. Explain two ways in which a medical practitioner has benefited from advancement in computing technology (4 marks)
10. Name two computer devices that have both input and output functionality (2 marks)
11. State two functions of the control unit of a computer system (2 marks)
12.                      
    1. Distinguish between system software and application software (2 marks)
    2. State four disadvantages of user developed software (2 marks)
13. State two reasons why a computer user may prefer optical storage media to magnetic storage media (2 marks)
14. In a spreadsheet, the formula =SUM(“5”,20,FALSE) is entered in a cell Interpret the results (2 marks)
15. XYZ industry operates an order system that coordinates orders, raw materials and inventory across its three factories Currently the orders are processed manually at each factory and communicated to others over the phone The management intends to computerize their operations State the first two computer professionals who will be required and their roles (4 marks)

SECTION B (60 marks)
Answer question 16 (compulsory) and any other three questions from this section

16.                  
    1. State two features of fourth generation programming languages (2 marks)
    2. State the stage of program development in which the programmer;
       1. creates data files; (1 mark)
       2. plans the sequence of steps to be followed by the program; (1 mark)
       3. identifies results to be generated; (1 mark)
       4. adds or removes features from a program (1 mark)
    3. A car rental firm leases its cars for Ksh250000 per day The customer is given a discount based on the number of days that the car is rented If the rental period is greater than or equals to 7 days then a 25% discount is given Write a peudocode to accept a car number and the rental period, and calculate the total amount earned by the company when a car is leased (9 marks)
17.                  
    1. In a certain coding scheme, each character occupies 8 bits Letters of the alphabet are assigned consecutive codes If letter N is represented by 11100100; What is the representation of letter A in this coding scheme? (5 marks)
    2.                      
       1. A school administers examinations to students in sciences, humanities, and languages Use the entities; EXAMINATIONS, STUDENTS, SCIENCES, HUMANITIES and LANGUAGES to illustrate a network database model (3 marks)
       2. Describe two integrity constraints that should be created in a database to maintain data integrity (4 marks)
    3. Describe two features of desktop publishing software that makes it more suitable for producing a company magazine than word processing software (4 marks)
18.                  
    1. Describe the following functions of an operating system
       1. Resource control (2 marks)
       2. Error handling (2 marks)
    2. A computer system is able to work on both graphics and word processing documents Explain how a computer can operate two applications at the same time (2 marks)
    3. State three benefits of using folders to organize information in a computer system (3 marks)
    4. A school uses a computer system which operates batch processing mode and real-time mode State a task in a school that would use:
       1. batch processing; (1 mark)
       2. real-time processing (1 mark)
    5. Describe the following terms as used in data processing
       1. Data verification; (2 marks)
       2. Data validation (2 marks)
19.                  
    1. The diagram below shows a layout of a computer network used by a medical health center
       A workstation and a printer are located in every consulting room
       
       
       1. Name the network topology depicted in the diagram (1 mark)
       2. Name the device labeled D (1 mark)
       3. If the management is to connect the above network to the internet, name:
          1. the device that the management would have to acquire; (1 mark)
          2. two types of software that the management would have to install on their computers to facilitate internet connectivity (1 mark)
       4. Explain two reasons that may have prompted the management of the health center to set up a computer network (4 marks)
       5. The management intends to link other health centers in two different towns using fibre optic media State four reasons for the choice of this media (4 marks)
    2. A teacher entered test scores in a spreadsheet in the cells range B2 to B50 State a single formula that should be entered in cell C2 and then copied to the range C3 to C50, to return the position of each pupil in the test (3 marks)
20.                        
    1. A programmer has been awarded a contract to change a manual system for all clerical duties to a computerized system at a certain company Give four ways how the programmer should go about gathering information about the manual system (4 marks)
    2. Explain three reasons that may lead to the failure of a system project (6 marks)
    3. Describe the term expert system as used in computers (2 marks)
    4. In Kenya Tea Packers Company, several people are employed as record clerks, typists and messengers The company intends to introduce a computerized system in all the departments Suggest three reasons that would make workers unhappy with a new system (3 marks)