Please Limited time Offer!

Answer ALL the questions in SECTION

  1. Mention two devices that can connected to the computer via HDMI cable                                         (2marks)

……

  • State three ways in which ICT can be used to enhance customer service delivery in a supermarket

          (3marks)

……………

  • List two types of job opportunities that are available in the field of computer hardware                    (2marks)

……………

  • Mr. Kamau is a teacher at Chianda High School used Ms-Excel to process the marks obtained by his student during the term. The table below shows the details entered in the Ms-Excel worksheet
 ABCDEFGHI
1NameCAT 1CAT 2CAT TOTAL EXAMTOTAL MARKSPOSITIONGRADEREMARK
2Mark Jama14062056761  
3Caleb Wekeza13082134556  
4Kanini Mulue10041459733  
5Justine Melanie11071857752  
6Julia Wahome06091548635  
7Austin Kilome08071550654  

Hints

CAT1is out 15, CAT2 is out 15 and Exam is out 70

  • Give the formula used to calculate the Total Marks for Julia Wahome                                           (1mark)

…………………………………………………………………………………………………………………………………………………………………………………………………………………… ……………

(b)Write a function that gives each student his position in class based on the performance             (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(c) Write a logical function that will display the following remarks in column I                                (2marks)

Total MarksRemark
0 – 49Fail
50 – 59Above Average
60 – 69Fair
70 – 79Good
80 – 100Excellent

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….…………….

  • Give two reasons to justify why SATA cables are used in modern computers to connect the hard disk to the motherboard                                                                                                                                    (2marks)

…………

  • Give three file systems supported by windows operating system                                                        (3marks)

…………

  • Describe the use of the following keys found on a standard keyboard                                              (2marks)
  • Esc

………

  • Prt sc

…………

  • Explain the following terms with references to algorithm
  • Definiteness                                                                                                                                   (2marks)

………

  • Finiteness                                                                                                                                       (2marks)

………

  • Mention two ICT related courses offered in Kenyan universities at undergraduate level                   (2marks)

…………

  1. What is flaming                                                                                                                                   (2marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  1. A Principal of a school wishes his school to have an internet connection in a bid to improve its service delivery. Mention three internet connectivity requirements that must be present to enable the connection.

(3marks)

……………

  1. Identify two limitations of traditional approach to system development                                             (2marks)

……………

  1. Use flowchart to demonstrate how IF THEN and REPEAT…… UNTIL can be implemented            (2marks)

…………………

  1. State three functions of Repeater stations in data communication                                                        (3marks)

……………

  1. Describe three layout guides available in DTP that assist a user to place an object in a preferred position

         (3marks) 

…………

SECTION B (60 MARKS)

  1. a)   State three features of a compiler                                                                                                    (3marks)

………

  • When writing a computer program programmers are always advised to use approaches and techniques that make the program easy to follow and maintain. List four ways in which a programmer can make program code easy to follow                                                                                                                (4mark
  1. a) Briefly describe the three main coding schemes                                                                                 (3marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • Convert the following numbers to binary number
  • B2.AAH                                                                                                                                      (3marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  •  base 10                                                                                                                                    (3marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • The table below was created using Ms-Access use it to answer the questions that follow

Table Name: Product

Product IDProduct NameUnit CostQuantityTotal
P00101Milk120344080
P00201Bread100565600
P00301Beans150456750
  • State the most appropriate data type for Product ID and Total                                                    (2marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • Suggest how you would set the input mask for the Product Name so that the data entered  in that field appear the way they are in the table                                                                                              (2marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • Represent the dynaset shown below in a SQL form given that the table Name is product          (2marks)
Product IDProduct NameUnit CostQuantityTotal
P00101Milk120344080

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • a) Describe four services available in the internet that support business                                    (4marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • Modern computing has embraced the use of drop box, google drive and OneDrive. These platforms are hosted by the internet and many computer users prefer backing up their data using these facilities. Give three reasons to justify this phenomenon                                                                                           (3marks)

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • Jeff a computer student from Ramba High school launched the browser to access the internet , the browser displayed an error message Server Not Found on the screen this didn’t allow Jeff to access the internet. State three possible causes of this anomaly                                                                         (3marks)

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • Briefly describe the following features of word processor                                                                (2marks)
  • Subscript

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • Drop cap

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • State two arithmetic operation that can be performed on a row of a numeric data in a word processor table

(1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • In each case of (e) above give the expression used                                                                           (2marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • a) Enumerate four breakthroughs in health care instigated by ICT                                                        (4marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • Mention four application areas of Artificial Intelligence                                                                  (3marks)

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

…………………………………………………………………………………………………………………

  • List three scanning devices available at Electronic Point Sale Terminal                                          (3marks)

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • Describe two ways of preventing eavesdropping                                                                              (2marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  •  System failure is considered as threat to data security. Describe three measures an organization should put in place to guard against system failure                                                                                       (3marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

  • a) Identify modes of data communication represented in (i), (ii), (iii) and (iv) below                           (4marks)
  • Principal Addressing students in assembly using public address system

…………………………………………………………………………………………………………………

  •  WhatsApp chat

…………………………………………………………………………………………………………………

  • Phone conversation

…………………………………………………………………………………………………………………

  • Walkie talkie conversation

…………………………………………………………………………………………………………………

  • List three challenges experienced by computer networks that are set up using twisted pair cables (3marks)

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………