Answer ALL the questions in SECTION
- 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
A | B | C | D | E | F | G | H | I | |
1 | Name | CAT 1 | CAT 2 | CAT TOTAL | EXAM | TOTAL MARKS | POSITION | GRADE | REMARK |
2 | Mark Jama | 14 | 06 | 20 | 56 | 76 | 1 | ||
3 | Caleb Wekeza | 13 | 08 | 21 | 34 | 55 | 6 | ||
4 | Kanini Mulue | 10 | 04 | 14 | 59 | 73 | 3 | ||
5 | Justine Melanie | 11 | 07 | 18 | 57 | 75 | 2 | ||
6 | Julia Wahome | 06 | 09 | 15 | 48 | 63 | 5 | ||
7 | Austin Kilome | 08 | 07 | 15 | 50 | 65 | 4 |
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 Marks | Remark |
0 – 49 | Fail |
50 – 59 | Above Average |
60 – 69 | Fair |
70 – 79 | Good |
80 – 100 | Excellent |
……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….…………….
- 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)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………………
- What is flaming (2marks)
……………………………………………………………………………………………………………………………………………………………………………………………………………………………………
- 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)
…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
- Identify two limitations of traditional approach to system development (2marks)
…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
- Use flowchart to demonstrate how IF THEN and REPEAT…… UNTIL can be implemented (2marks)
…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
……………………………………………………………………………………………………………………………………………………………………………………………………………………………………
- State three functions of Repeater stations in data communication (3marks)
…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
- Describe three layout guides available in DTP that assist a user to place an object in a preferred position
(3marks)
…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
SECTION B (60 MARKS)
- 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 (4marks)
………………………………………………………………………
- 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 ID | Product Name | Unit Cost | Quantity | Total |
P00101 | Milk | 120 | 34 | 4080 |
P00201 | Bread | 100 | 56 | 5600 |
P00301 | Beans | 150 | 45 | 6750 |
- 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 ID | Product Name | Unit Cost | Quantity | Total |
P00101 | Milk | 120 | 34 | 4080 |
……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
- 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)
…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………