Computer Studies Paper 1 Questions - Kapsabet Boys Post Mock 2023 Exams

Instructions

• This paper consists of TWO sections; A and B
• Answer all questions in sections A.
• Answer question 16 and any other three questions from section B.

QUESTIONS

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

1. State any two peripheral devices that are powered by the system unit. (1mark)
2. The following are symbols of some keys found on the keyboard. Name the keys represented by the symbols. (2marks)
   
3.  Explain any three functions of system software in a computer (3marks)
4.  As a computer student you have been asked to assist in buying an input device. State any four
   factors to consider when buying input devices. (4marks)
5.  
   1. The Arithmetic Logic Unit, The Control Unit and the Main Memory use electrical pathways or links called buses. Describe the three types of buses. (3marks)
   2. What is the role of special purpose memories in the microprocessor? (1 mark)
6. Outline the three differences between primary memory and secondary memory. (3mks)
7. State two advantages of integrated software as opposed to single purpose. (2marks)
8.  
   1. Define the term mail merging (1 mark) 
   2. Name two files that are created in mail merging process (1marks)
9.  
   1. Distinguish between a workbook and a worksheet as used in spreadsheets (2marks) 
   2. What is the meaning of “what if analysis” with respect to spreadsheet? (1mak)
10. Define the following terms in relation to internet (2marks)
    1. Downloading
    2. Hyperlink
11. Benjos was instructed by his teacher while typing a Microsoft word document to replace all the occurrences of the word MS with Microsoft. Highlight the steps to do this (3marks)
12.  What is the difference between logical and physical file? (2marks)
13. Explain any three types of computer processing files. (6marks)
14. Give a reason why HTML is not considered as a true programming language. (1mark)
15.  
    1. Define the following computer crimes
       1. Piracy (1mark)
       2. Industrial espionage (1mark)

SECTION B (60 MARKS)
Answer questions 16 (COMPULSORY) and any other three questions in this section

16.  
    1. Draw a flowchart for a program that is to prompt for N numbers, accumulate the sum and them find the average. The output is the accumulated totals and the average. (5marks)
    2. Write a pseudo code for the above program. (4marks)
    3.  State three types of control structures use in programming. (3marks)
17.  
    1.  
       1. Subtract 110₂ from 11010₂ (1mark)
       2. Find the sum of binary number 101.101₂ and 110.100₂ (1mark)
    2.  
       1. Convert binary number 11010110.1001₂ into octal number.(1mark)
       2. Convert binary number 11010110.1001₂ into hexadecimal number.(1mark)
    3. Convert the following numbers to their decimal equivalent
       1.  11.011₂   (2marks)
       2.  0.11011₂  (2marks)
    4.  
       1. Convert 3BD₁₆ to Octal. (3marks)
       2. Using one’s complement, calculate 510 – 910. use six bit in your calculation. (3mks)
    5. State the following types of transcription errors: (2marks)
       1. 3455 instead of 3456
       2. Simth instead of Smith
18.  
    1. State and explain the following types of relationship as used in database design
       
    2.  
       1. Explain the difference between primary key and an index key as used in database application (2 marks)
       2. Outline the functions of a primary key (2marks)
    3. Describe the following types of database model
       1. Network model (2marks)
       2.  Relational model (2marks)
19.  
    1.  
       1. What is an operating system? (1mark)
       2. Maintaining security is one of the functions the operating system. Explain how the operating system maintains security (2marks)
       3. Explain how an operating system controls I/O devices. (2marks)
    2. What does the following control measures against computer crime involve? (5marks)
       1. Audit trail
       2. Data encryption
       3. Log files
       4. Passwords
       5. Firewall
    3. Briefly explain what happen during power on self test (POST) (3marks)
    4. Explain the functions of complementary metal-oxide semiconductor (CMOS) (2marks)
20.  
    1. State two advantages and two disadvantages of the ring network topology
       Advantage (2marks)
       Disadvantages (2marks)
    2. State two roles and responsibilities of the following ICT professional:
       Network Administrator. (2mks)
    3. The worksheet below shows sales for the month of July by the employees of Newtech information center. Use it to answer the questions that follow.
       

       	A	B	C	D	E	F
       1	First name	Second name	Sales in sh.	Sales in sh.	Sales in sh.
       2	Yonah	Kassim	2000.12510	12000	25000
       3	Jose	Kiddo	7200.1741	5000	10000
       4	Kelvin	Joro	1500.131	700	5000
       5	Lores	Ayona	2600.1011	8500	4000
       6	Bett	Gilbert	2000.1200	2000	4500
       7	Osoro	Kiplat	1001.0113	5500	6600
       8	Zainad	Jad	500.1211	6000	7500
       9	Hassan	Makotti	400.10010	8000	2000
       10	Jonnie	Imran	3111.0110	7000	15000
       11
       12

       
       Write the correct expression:
       1.  In cell D3 that would print “PROMOTE” if the amount of sales is greater than
          sh. 1600 and DEMOTE” if not (2mks)
       2.  In cell E3 that would print remark “WINNER” if sales are the highest and
          “MEMBER” if not (5mks)
       3.  Expression to count students whose second name starts with letter J. (4 marks)
       4. In cell D3 and D7 that would round the values in cell C3 into zero decimal place and C7 into 2 decimal places (2marks)