Computer Studies Questions - Maseno Mock Examinations 2022

QUESTIONS

SECTION A

1. Differentiate between computer on board devices and peripheral devices giving an example in each case. (3 marks)
2. State two advantages of using a mouse as an input device. (2 marks)
3. List and explain any four factors to consider when acquiring a monitor. (4 marks)
4.    
   1. What is a user-friendly operating system? (1 mark)
   2. Give two features of a user-friendly operating system. (2 marks)
5. State the purpose of the following utility software.
   
   1. Device driver (1 mark)
   2. File compression (1 mark)
6. Explain the following types of paragraph alignment
   
   1. Centred (1 mark)
   2. Justified (1 mark)
7. Give two advantages of using tables to represent data in word processing. (2 marks)
8. State two advantages of using DTP software over word processor. (2 marks)
9. Explain the following two categories of Desktop Publishing Software
   
   1. Graphic based DTPS (1 mark)
   2. Layout-based DTPS (2 marks)
10.    
    1. List two components needed for internet connection. (2 marks)
    2. Write the following acronyms in full (2 marks)
       
       1. HTML
       2. URL
11. State any three functions of an antivirus software. (3 marks)
12. Give any two features of a good password. (2 marks)
13. Draw a well labelled diagram of the data processing cycle. (3 marks)
14. Give three ways in which robots can be used in the army during war. (3 marks)
15. Explain three effects of ICT on employment. (3 marks)

SECTION B.
Answer question 16 (Compulsory) and any other three questions.

16.    
    1. State three advantages of using high level programming language. (3 marks)
    2. What is meant by the term system entropy? (2 marks)
    3. Differentiate between hard systems and soft systems. (2 marks)
    4. The gross salary of Bright Technologies is based on basic salary, year’s worker and monthly commission based on monthly sales profit as follows;
       • Employees who have worked for more than 5 years receive an additional pay of 5% to their basic salary.
       • Monthly commissions are based on monthly sales profit of computers and accessories as follows
         

         Monthly sales profit	Commission rate %
         Above 100,000 Between 50,000 and 100,000 Between 0 and 50,000	20 5 5

         Draw a flowchart that would be used to calculate the gross salary. (8 marks)
17.    
    1. Define the following terms
       1. Bit (1 mark)
       2. Byte (1 mark)
    2. Convert 10¹/₃ to its binary equivalent. (3 marks)
    3. Subtract 111₂ from 10011₂(2 marks)
    4. Find the value of x in the equation below (2 marks)
       X₂ + 1101₂ = 1000110₂
    5. Perform the following arithmetic operation using two’s compliment. (6 marks)
       34₈ – 67₁₀ leaving your answer in binary form.
18. The table below shows a worksheet containing information on household items. Use it to answer the question that follow.
    

    NO	A	B	C	D	E
    1	Item description	No ot Units	Cost per unit	Total cost
    2	Wheat flour	12	110
    3	Rice	6	145
    4	Sugar	7	140
    5	Salt	2	20

    1. Write a formular to calculate the total cost of rice. (1 mark)
    2. The prices of all items increased by 10% and the value 10% is placed in all B8. Using cell addresses with absolute referencing only, write a formula to calculate the new price of salt. (2 marks)
    3. Write a function to display the number of cells in which the cost per unit is equal to 110.(2 marks)
    4. Write a function to display the least total cost for all items. (2 marks)
    5. What is meant by each of the following terms as used in the internet?
       1. Surf (1 mark)
       2. Uploading (1 mark)
       3. Inbox (1 mark)
    6. List three ways in which parents can protect their children from accessing inappropriate content from the internet. (3 marks)
    7. State the two problems associated with using e-mail technology for communication (2 marks)
19. Study the diagram below and answer the questions that follow.
    
    
    1. Name the communication media shown in the above diagram. (1 mark)
    2. Name the parts labelled A,B,Cand D (4 marks)
    3. List three advantages of the above communication media. (3 marks)
    4. State any three advantages of networking. (3 marks)
    5. List four factors to consider when choosing an input device. (2 marks)
    6. State any two advantages of real time processing (2 marks)
20.    
    1. State one function of each of these objects in a database. (4 marks)
       1. Table
       2. Query
       3. Forms
       4. Reports
    2. State two features of a primary key field. (2 marks)
    3. Briefly describe the following field properties (3 marks)
       1. Format
       2. Input mask
       3. Required
    4. List any two sources of graphics in a word processor (2 marks)
    5. List two health problems associated with improper sitting posture while using a computer. (2 marks)
    6. State two ways of mitigating intellectual property theft (piracy) (2 marks)