Computer Studies Paper 1 Questions - Maranda High Pre Mock Exams 2023

INSTRUCTION TO CANDIDATES  

• This paper consists of Two sections A and B  
• Answer ALL questions in section A
• Answer question16 and any other THREE questions from section B 

SECTION A 

Answer ALL the Questions in This Section (40 Marks) 

1. With reference to cables, list two reasons why a keyboard may not function properly. (2mks)
2. Give any three advantages of a monitor as an output device. (3mks)
3. Describe any two ways of inputting data into a computer. (4mks)
4. Why is it necessary to consider user needs when purchasing a new software. (1mk)
5. Define patch as used in operating system. (1mk)
6. State any three ways of identifying an illegal copy of operating system. (3mks)
7. Give any three advantages of presenting information using tables. (3mks)
8. Differentiate between the SUM and SUMIF function as used in spreadsheet. (2mks)
9. State any three negative moral effects of internet to the society. (3mks)
10. Explain two advantages of spreadsheet in government office concerned with carrying out national  census. (4mks)
11. State three precautions a bank can take to control illegal data alterations. (3mks)
12. List any three ways of recovering data lost through accidental erasure. (3mks) 
13. Distinguish between sign in and sign up as used in e-mails. (2mks)
14. State any three factors to consider before designing a publication. (3mks)
15. Give any three benefits of using DTP software in publishing over the word processor. (3mks)

SECTION B 

ANSWER QUESTION 16 AND ANY OTHER THREE FROM THIS SECTION. (60 MARKS) 16. a)

1.  
   1. Differentiate between assembler and compiler. (2mks)
   2. Draw an algorithm that accepts two numbers that are greater than zero, the two numbers are  multiplied to display a product. If the product is greater than twenty the program should ask for  re-input. (7mks)
   3. Explain how the system would behave if the two numbers entered are 8 and 4. (2mks)
   4. Define the following terms as used in programming. (4mks)
      1. Structured programming
      2. Tag in web scripting
      3. Bug  
      4. Syntax
2. Use the spreadsheet extract below to answer questions that follows. 
   

   	A	B	C	D	E	F	G	H	I	J	K
   1	FORM TWO CLASS PERFORMANCE
   2	Name	Class	Adm No.	CAT 1	CAT 2	CAT 3	Total	Average	Score	Overall Position	Remark
   3	Maina John	E	7984	80	70	59
   4	Ken Korir	W	7896	75	55	72
   5	Bernard K	E	8092	86	59	75
   6	John Soi	E	7460	80	79	70

   1. Write the function used to assign Bernard position. (2mks)
   2. Write a function in Cell B7, which would be used to count the number of students from “E”.   (2mks)
   3. Write the function in Cell G7, which would calculate total of totals that are greater than 280.   (2mks)
   4. Identify any Four formatting features used in Row 2. (2mks)
   5. Differentiate between action query and select query. (2mks)
   6. Describe any two types of error data that may occur during data collection. (4mks)
   7. Define the term sampling as used in data collection. (1mk)
3.  
   1. State three ways in which ICT can improve the access of News in Kenya. (3mks)
   2. Explain two benefits of training staff using multimedia training package instead of face to face  training. (4mks)
   3. List three components of an expert system (3mks)
   4. Give three reasons why one may need to restart a computer. (3mks)
   5. Give two benefits of mail merging. (2mks)
4.  
   1. Explain any three benefits of using ATMs in banking industry. (6mks)
   2. Explain two advantages of advertising on web instead of using an advertising brochure. (4mks)
   3. Mention any three ways of ensuring efficient back up of data. (3mks)
   4. Give any two benefit of hacking to an organization’s computer system. (2mks)
5.  
   1. Mention three features used to describe a numbering system. (3mks)
   2. Perform the binary arithmetic below. 
      −13³/₄ + 6⁵/₈ using ones compliment. (5mks)
   3. In a certain coding scheme, letter F is represented as 1101. Represent letter K in the coding scheme.   (2mks)
   4. Explain any two reasons why an organization may need information system. (4mks)
   5. Define the term system design. (1mk)