April 23, 2022

  Pos. School KCSE  Mean County 1  Kenya High 10.467   Nairobi 2 Kapsabet Boys 10.11  Nandi 3 Kisima Mixed 10.05  Nyandarua 4 Alliance High 10.019  Kiambu 5 Mary Hill Girls 9.92  Kiambu 6 Alliance Girls 9.92   Kiambu 7 Strathmore School 9.88  Nairobi 8 Moi High School Kabarak 9.88   Nakuru 9 Mang’u High 9.868  Kiambu 10 Light Academy 9.84  Nairobi 11 Anestar Boys High 9.7  Nakuru 12 Moi Girls Eldoret 9.65  Uasin Gishu 13 Pangani Girls 9.56  Nairobi 14 Nairobi School 9.55  Nairobi 15 Kianda School 9.53  Nairobi 16 Nakuru Girls High 9.52  Nakuru 17 St Brigid’s Kiminini 9.4  Trans Nzoia 18 Murang’a High 9.2733 Murang’a 19 Riara Springs 9.2  Nairobi 20 Friends School Kamusinga 9.1608  Bungoma 21  Moi Tea Girls Sec. 9.16  Kericho 22 Maseno School 9.09  Kisumu 23  Kipsigis Girls High 9.08  Kericho 24  Sheikh Khalifa 9.01  Mombasa 25 Kagumo High 8.99  Nyeri 26 Bishop Gatimu Ngandu 8.962  Nyeri 27 Segero Adventist National 8.927  Uasin Gishu 28 Maranda High 8.90628  Siaya 29 Pope Benedict Seminary 8.9  Kisii 30 Bunyore Girls High 8.8925  Vihiga 31 Litein High School 8.84  Kericho 32 Agoro Sare High 8.834  Homa Bay 33 Nakuru Boys High 8.81  Nakuru 34 Damacrest Academy 8.8  Kiambu 35 Baricho High 8.8  Kirinyaga 36 Light Academy 8.72  Mombasa 37 Limuru Girls 8.7  Kiambu 38 Kanga High 8.7  Migori 39 Meru School 8.67  Meru 40 Machakos School 8.6207  Machakos 41 Mudasa Academy 8.62  Vihiga 42 Mary Mother of Grace 8.62  Laikipia 43 Kiage Tumaini 8.6  Kisii 44 Kitui School 8.5878  Kitui 45 Asumbi Girls 8.58519  Homa Bay 46 Karima Girls High 8.58  Nyandarua 47 Kahuhia Girls 8.53  Murang’a 48 Nkubu High 8.5  Meru 49 Carmel Girls 8.5  Machakos 50 Kisasi Boys 8.47  Kitui 51 Moi Girls Mbiruri 8.405  Embu 52 Precious Blood Riruta 8.4  Nairobi 53 Moi Forces Lanet 8.4  Nakuru 54 Mbita High 8.4  Homa Bay 55 Karura SDA 8.4  Nairobi 56 Kabare Girls 8.4  Kirinyaga 57 Kisii School 8.381  Kisii 58 St Mary’s Igoji Girls 8.37  Meru 59 Sacho High School 8.36  Baringo 60 Metkei Girls 8.34  Elgeyo Marak-wet 61 Njiiri School 8.33  Murang’a 62 Elburgon Secondary 8.33  Nakuru 63 Chogoria Girls 8.31  Tharaka Nithi 64 Mutira Girls 8.3  Kirinyaga 65 Moi Siongiroi Girls 8.3  Bomet 66 Lugulu Girls High 8.2578  Bungoma 67 Memon Academy 8.2  Mombasa 68 Kyeni Girls 8.2  Embu 69 Muthale Girls 8.102  Kitui 70 Tengecha Girls High 8.1  Kericho 71 St Mary’s Boys Nyeri 8.1  Nyeri 72 Qubaa Muslim 8.1  Mombasa 73 Kathiani Girls 8.1 Machakos 74 St Francis Misyani 8.06  Machakos 75 Baringo High School 8.06  Baringo 76 Makueni Boys 8.054  Makueni 77 St Anthony Boys, Kitale 8.01  Trans Nzoia 78 Nyambaria High 8.01  Nyamira 79 Kangaru Girls 8.01  Embu 80 Mahiga Girls 8  Nyeri 81 Elite Girls 8  Laikipia 82 St Joseph’s Boys Kitale 7.92  Trans Nzoia 83  Sacred Heart Roreti Girls 7.9  Kericho 84 Orero Boys 7.9 Hama Bay 85 Kapsabet Girls 7.9 Nandi 86  lstiqama Academy 7.9  Mombasa 87 Graceland Girls 7.87  Laikipia 88 Nanyuki High School 7.82  Laikipia 89 Naivasha Girls 782  Nakuru 90 St Peter’s Nyakemincha 7.806  Nyamira 91 Pioneer Girls 7.8  Murang’a 92 Ndalani Sec 7.8  Machakos 93 Kiurani Boys 7.8  Tharaka Nithi 94 Kiaguthu Boys 7.8  Murang’a 95 Mugoiri Girls 7.7928  Murang’a 96 Tenwek High School 7.79  Bomet 97 St Patrick’s Iten 7.79  Elgeyo Marakwet 98 Kaplong Girls High School 7.79  Bomet 99 Chavakali Boys 7.756  Vihiga 100 Thika High 7.74  Kiambu 101 Ndururumo High School 7.74  Laikipia 102 Mary Mount Secondary 7.74  Nakuru 103 Tengecha Boys 7.73  Kericho 104 Edenburg 7.727  Murang’a 105 Nyangwa 7.71  Embu 106 Kabianga High 7.7046  Kericho 107 Machakos Girls 77  Machakos 108 Kianyaga 7.7  Kirinyaga 109 Kenyatta Mwatate 7.7  Taita Taveta 110 Kaplong Boys High 7.7  Bomet 111 Kakamega High 77  Kakamega 112 Homa Bay Boys 77  Homa Bay 113 St Charles Lwanga 7.6897  Kitui 114 Nairobi Leadership Academy 7.67  Nairobi 115 Matinyani Boys 7.67  Kitui 116 Njonjo Girls High 7.64  Laikipia 117 St Charles Lwanga 1chuni 7.6  Kisii 118 Chuka Boys 7.6  Tharaka Nithi 119 Nyandarua High 7.58  Nyandarua 120 Booker Academy 7.508  Kakamega 121 Ramba Boys 7.5  Siaya 122 Paul Boit Boys 7.5  Uasin Gishu 123 Nyabururu Girls 7.5  Kisii 124 Ngiriambu High 7.5  Kirinyaga 125 Ngiriambu High 7.5 Kirinyaga 126 Kamureito Secondary 7.5  Bomet 127 Segero Adventist High 7.47  Uasin Gishu 128 AIc Litein Girls 7.46  Keilcho 129 Butere Girls High 7.452  Kakamega 130 Bahari Girls Kilifi 7.436  Kilifi 131 Tumaini International 7.4  Machakos 132 St. Mary’s Yala 7.4  Siaya 133 Nyeri High 7.4  Nyeri 134 Kisumu Boys 7.4  Kisumu 135 Kerugoya Girls 7.4  Kirinyaga 136 Riokindo High 7.35  Kisii 137 Nyahururu Highway Schools 7.35  Nyandarua 138 St Peters Mumias 7.332  Kakamega 139 Uzalendo School 7.33  Baringo 140 Kimangao Girls 7.3267  Kitui 141 St Peter’s Boys Mumias 7.322  Kakamega 142 Matungulu Girls 7.3  Machakos 143 Kyamboo Secondary 7.3  Kitui 144 Kebirigo Boys 7.3  Nyamira 145 Cardinal Otunga Mosocho 7.289  Kisii 146 Keveye Girls 7.2593  Vihiga 147 Bura Girls 7.22  Taita Taveta 148 Sawagongo High 7.2  Siaya 149 Rapogi High 7.2  Migori 150 Ikuu Boys 7.2  Tharaka Nithi 151 Cardinal Otunga Girls 7.2  Bungoma 152 Buru Buru Girls 7.2  Nairobi 153 Barpello High School 7.2  Baringo 154 Saseta Girls High School 7.15  Bomet 155 Meteitei Secondary 7.12  Nandi 156 Mabole Boys 7.118  Kakamega 157 St Peters Abwao 7.1  Migori 158 Samoei Secondary 7.1  Nandi 159 Nyang’ori Boys 7.1  Vihiga 160 Moi Girls Vokoli 7.1  Vihiga 161 Mary Leakey Girls 7.1  Kiambu 162 Kapnyeberai Secondary 7.1  Nandi 163 Matuga Girls 7.097  Kwale 164 Kabarnet High School 7.06  Baringo 165 Ugenya Boys 7.05  Siaya 166 Ng’iya Girls 7.05  Siaya 167 St Joseph Cheptiret 7.024  Uasin Gishu 168 Molo Academy 7.02  Nakuru 169 Ikanga Boys 7.01  Kitui 170 Chepterit Girls 7.01  Nandi 171 St Mary’s Girls Mumias 7.007  Kakamega 172 St Peters Seminary 7  Kakamega 173 Sironga Girls 7  Nyamira 174 Rockfields Senior 7  Nairobi 175 Kerugoya Boys 7  Kirinyaga 176 St Angela’s Girls 6.99  Kitui 177 St Lukes Kimilili 6.9833  Bungoma 178 St.Luke’s Boys Kimilili 6.983  Bungoma

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY /BACHELOR OF SCIENCE IN INFORMATION COMMUNICATION TECHNOLOGY BIT2106 BCT2104 SOFTWARE ENGINEERING PRINCIPLES FULL TIME/PART TIME/DISTANCE LEARNING DATE: DECEMBER, 2018 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION 1: 30 MARKS (COMPULSORY) a) Requirements changes are inevitable; describe four sources of changes in requirements. 4 Marks b) Describe four types software maintenance highlighting the importance of each. 4 Marks c) Define a critical system, describing three types and examples of each. 5 Marks d) Before you carry out the requirements engineering process it is always important to undertake a feasibility study. i. What is a feasibility study? 2 Marks ii. Discuss three reasons why it is important to carry out a feasibility study. 3 Marks e) You are the project manager of a software engineering team. You also charged with responsibility of selecting the members who will work with you in the team. Discuss six staff selection factors that you would consider during the exercise. 6 Marks f) Describe “availability” as a desired software quality in software. Discuss four metrics for availability 6 Marks QUESTION 2: 20 MARKS a) Define the following terms 6 Marks i. Software ii. Software engineering iii. Software process b) Using a clearly labeled diagram describe the Component-Based Software Engineering process of developing software, stating two advantages and two disadvantages of the process . 8 Marks c) State and explain three types of interfaces that may be defined during the interface specification activity. 3 Marks d) Outline three challenges of using prototyping in software development. 3 Marks QUESTION 3: 20 MARKS a) Read the following scenario and answer the questions that follow. “A video library stocks the both DVDs and video tapes. When a potential client visits the shops; the librarian checks in the database to establish whether the client is registered or not. If the client is not registered, he/she is advised by the librarian to register with the library first before any services could be rendered. Once a client has been registered, he/she is eligible to borrow at most one library item per week. The item borrowed must be returned before any other item can be borrowed. If the client does not return the item within a month, he/she is surcharged a certain amount per day up to the time he/she returns the item” Assume that you are using “use case” approach to requirements elicitation to implement the above described system: Required i. Describe what a use case is. 2 Marks ii. Show the notation used in a use case 2 Marks iii. Identify the actors in the scenario above 3 Marks iv. Draw a use case diagram to model the video library system. 6 Marks b) Describe three types of non-functional requirements that must be established during requirement engineering process. 3 Marks c) Discuss four interactions styles at the interface stating two advantages and two disadvantages of each. 4 Marks QUESTION 4: 20 MARKS a) An obselete software system could be defined as one that has reached the end of the economic useful life and is due for replacement by another information system. Discuss five symptoms of obselete. 5 Marks b) Using a well labeled diagram distinguish between thin and fat client architectures. 4 Marks c) Distinguish between static verification and dynamic verification. 4 Marks d) You are involved in the Verification and Validation of a system in order to discover defects. Required: i. Describe two faults that you would put in your error check list for your static analysis activity. 2 Marks ii. State and explain five guidelines that you would follow when testing a system in order to reveal defects. 5 Marks QUESTION 5: 20 MARKS a) Describe the components that make a Distributed System. 6 Marks b) Assume you are software engineer and you are required to familiarize your self with the ACM/IEEE codes of ethics. Discuss four principles that you would find in these documents. 4 Marks c) Discuss four software cost estimation techniques available to the project manager stating when each is applicable. 4 Marks d) After the requirements engineering process is complete, the SRS is written down. Describe the SRS document stating the various guidelines you should follow when writing it. 6 Marks

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY BIT2106 SOFTWARE ENGINEERING PRINCIPLES BCT 2104: PRINCIPLES OF SOFTWARE ENGINEERING FULL TIME/PART TIME/DISTANCE LEARNING DATE: DECEMBERT, 2018 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE a) Distinguish between systems engineering and software engineering (2 marks) b) Define a software process and state FOUR key stages (6 marks) c) Describe FOUR ethical issues in software engineering (8 marks) d) Explain the need for managing risks in software engineering (4 marks) e) State the challenges faced by a software engineer in managing software projects (6marks) f) What is a critical system and give THREE examples (4 marks) QUESTION TWO a) What is the difference between software validation and software verification (2 marks) b) Using a suitable illustration describe the spiral model (10 marks) c) State some of the challenges that a software engineer faces in the 21st century (8 marks) QUESTION THREE a) Explain the importance of software evolution and the activities involved (6 marks) b) Describe non-functional requirements and give THREE examples (5 marks) c) State FOUR problems in incremental development (4 marks) d) What are the benefits of software prototyping (5 marks) QUESTION FOUR a) Why do we need to inspect and test systems? (4 marks) b) Project planning is essential in software engineering. What are the types of plans that should form part of the documentation (7 marks) c) Describe FIVE architectural design consideration decisions (5 marks) d) State FOUR characteristics in object orientated design (4 marks) QUESTION FIVE a) State THREE advantages and THREE disadvantages of software reuse (6 marks) b) What is your understanding of the following i) Change management (4 marks) ii) Configuration management (4 marks) c) What has contributed mainly to software projects failure in the last 10 years (6 marks)

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY/BACHELOR OF BUSINESS INFORMATION TECHNOLOGY BIT2105 BBIT112 APPLICATION PROGRAMMING FULL TIME/PART TIME/DISTANCE LEARNING DATE: DECEMBER, 2018 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE a) Describe the following components found in the Common Language Runtime (CLR) of a .(DOT) NET Framework i) Common Language Specification (CLS) ii) Common Type System (CTS) [4 Marks] b) Explain the significance of the following windows in Visual Basic IDE: i) Form Designer ii) Solution Explorer Window iii) ToolBox Window [6 Marks] c) What will be displayed when the following set of lines are executed. Each set of statements are executed independent of one another i) Dim Boy as String = “Jack” Dim Girl as String = “Jill” NamesTextBox.Text = Boy & “ and “ & Girl & “ went up the hill” ii) Dim x As Double = 3, y as Double = 1 Dim z As Double z = x + (y * x) x = y z = x + z ValuesListBox.Items.Add(x + y + z) [4 Marks] d) Rewrite the following code segment using the With and End With statements RegistrationTextBox.BackColor = Color.White NamesTextBox.BackColor = Color.White RegistrationTextBox.ForeColor = Color.Black NamesTextBox. ForeColor = Color.Black [2 Marks] e) Convert the following mathematical notation into the equivalent Visual Basic expressions i) ii) 3(X + Y) [2 Marks] f) You are required to write a Visual Basic program that will enable user to calculate the sum, product, division and difference of two numbers entered through textboxes after a click of the respective buttons. The results should be displayed by use text box control. The program should enable the user to clear the textboxes ready for the next input. i) Sketch your graphical user interface assigning appropriate properties to your form and other controls [2 Marks] ii) Write the code for your program and declare you variables appropriately [10 Marks] QUESTION TWO a) Briefly explain the following categories of user interfaces i) Command-line interfaces ii) Form-based visual interfaces [4 Marks] b) Describe the following principles of control design i) Function grouping ii) Consistent sizing [2 Marks] c) Explain the significance of using the following controls in your Visual Basic applications i) CheckBox controls ii) MaskedTextBox Controls [4 Marks] d) Distinguish between a Do While…Loop and Do Until…Loop [2 Marks] e) Using nested loops, write a Visual Basic program to generate and display the following multiplication table in an output window (debug window) after a click of a button control. Sketch your GUI 1 2 3 4 5 6 7 2 4 6 8 10 12 14 3 6 9 12 15 18 21 4 8 12 16 20 24 28 5 10 15 20 25 30 35 6 12 18 24 30 36 42 7 14 21 28 35 42 49 [8 Marks] QUESTION THREE a) Differentiate between a combo box and list box. [2 Marks] b) A GUI is required to allow the user calculate the area of a circle in Visual Basic. The user is to type the value of the radius in a textbox. When the user clicks a command button, the volume is displayed in a textbox control. Use the formula shown below for area calculation: i) Sketch a suitable GUI for the above and write down the properties that you would set for all the controls in the above GUI and their values. [3 Marks] ii) Write code in a button to calculate and display the area in any appropriate control [9 Marks] c) Explain briefly the following data types as used in visual basic i) Date ii) Short iii) Decimal [6 Marks] QUESTION FOUR a) Describe the following types of ComboBox controls i) DropDown ComboBox ii) Simple ComboBox iii) DropDownList ComboBox [6 Marks] b) Using examples explain the following Array class members i). GetLength ii). Sort iii). Average [6 Marks] c) Describe the following terms as used with VB.net 8 Marks i) Object ii) Class iii) Methods iv) Instance Variables [8 Marks] QUESTION FIVE a) Describe the ActiveX Data Objects (ADO.NET) [2 Marks] b) Using a diagram, to illustrate describe how the database is connected to the web windows form. [6 Marks] c) Explain the following properties of the Connection object i) Table adapter ii) DataSource iii) Provider [6 Marks] d) Write VB.net code that can be used to delete the current record from a table named tblEmployes. [6 Marks]

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY/APPLIED COMPUTING BIT 2104: DATABASE DESIGN AND DEVELOPMENT BAC 1301: DATABASE DESIGN & DEVELOPMENT FULL TIME/PART TIME/DISTCNCE LEARNING DATE: DECEMBER, 2018 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE [30 MARKS] a) What factors can be used to measure database performance 6 Marks b) Discuss the important role played by users in the process of database design. 6 Marks c) Describe the main phases involved in database design. 6 Marks d) Describe the characteristics of a table in third normal form (3NF). 3 Marks e) How do the contents of a users’ requirements specification differ from a systems specification? 5 Marks f) Compare and contrast the main tasks carried out by the DA (data administrator) and DBA(database administrator). 4 Marks QUESTION TWO [20 MARKS] a) What are the main activities associated with operational maintenance stage? 4 Marks b) Explain the purpose of testing the database system. 4 Marks c) Describe the purpose of the data conversion and loading stage. 4 Marks d) Describe the potential benefits of developing a prototype database system. 4 Marks e) Discuss the two main activities associated with application design. 4 Marks QUESTION THREE [20 MARKS] a) Explain briefly what is meant by database security and database integrity within a relational database system and highlight the relationship between them. 5 Marks b) Explain briefly the differences between Entity Relationship modelling and Normalisation. 5 Marks c) You are given an enrolment database with two tables- PROGRAMME and STUDENT. Write SQL statement to accomplish the tasks that follow. i. Display full name of the student 2 Marks ii. Display all students taking applied computing 2 Marks iii. Increase the fee by 3% if the student is taking Bsc. software development. 2 Marks iv. Display the total fee(cost) by department. 2 Marks v. Remove the student Henry Mutua from the student table. 2 Marks QUESTION FOUR [20 MARKS] A theme park wishes to create a database about its activities. There are a number of areas in the park with each area having several rides. Each rides has one supervisor who is in charge of that ride alone (unless he is seconded to a development project for a period of time). A ride is run by several staff, and staff may run different rides on different days, although a staff member belongs to only one area. Each ride is maintained by one or more maintenance staff who may maintain several rides. Area details include Area# (unique) and Area Name. Ride details include Ride# (unique), Ride Name, Ride Type and Maximum Capacity. Supervisor details include Supervisor Code (unique), Supervisor Name, Salary, Phone#. Staff details include Staff# (unique), Staff Name, Grade, Salary and Date allocated to on a particular day. Maintenance Staff details include Maintenance Code, Name, Shift, Salary, Time spent maintaining a particular ride. (a) State the entity types with their identifiers and all details of relationships (name, degree and relevant membership classes). 10 Marks (b) Draw an Entity Relationship diagram and use the relational mapping rules to create a linked relational schema. 7 Marks (c) Explain what is meant by an optional membership class and give an example. 3 Marks QUESTION FIVE [20 MARKS] The form below shows a representative form for a University Timetabling database. ModuleCode: COM171J1 ModuleName: Database Development Where Class# contains unique values and Type values are L – lecture, T – tutorial and P – practical. (a) State the first normal form (1NF), second normal form (2NF) and third normal form (3NF) rules. 6 Marks (b) Represent the above form as an un-normalised relational scheme and apply the rules of normalisation to normalise up to third normal form (3NF) 14 Marks

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY/ BACHELOR OF BUSINESS IN INFORMATION TECHNOLOGY BIT 2103: PRINCIPLES OF ARTIFICIAL INTELLIGENCE /FOUNDATIONS OF ARTIFICIAL INTELLIGENCE FULL TIME/PART TIME/DISTANCE LEARNING DATE: DECEMBER, 2018 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE (COMPULSORY) [30 MARKS]. (a). Briefly explain the meaning of the following concepts. Use an example to illustrate your answer for each concept. (i) Artificial intelligence (2 Marks) (ii) Intelligent agent (2 Marks) (iii) Inference (2 Marks) (b). Explain four differences between intelligent agents and other convectional softwares. (4 Marks) (c) Briefly explain the meaning of the following concepts with reference to artificial intelligence i) Forward chain reasoning (2 Marks) ii) Spatial intelligence (2 Marks) (d) Distinguish between Musical and bodily kinesthetic intelligence. State potential careers and techniques used for improving each intelligence (4 Marks) (e) Write whether each statement is true (T) or false (F), and provide a short explanation: ( i) greedy search and hill climbing search are inefficient (2 Marks) (ii) Breadth first search is optimal (2 Marks) (iii) Uniform cost search is complete (2 Marks) (f) Briefly explain three assumptions of artificial intelligence (3 Marks). (g) Briefly explain three types of intelligent agents (3 Marks). QUESTION TWO [20 MARKS] (a) Describe two limitations of depth first search (2 Marks). (b) Explain four characteristics of un informed searching methods (4 Marks) (c) Briefly describe the meaning of the term “search problem” (1 Mark) (d).State and explain five elements of defining search problem. (5 Marks) (e). Consider the search tree shown Figure below. (i)Use depth first search algorithm to find a path from S to E. What is the path cost? (4 Marks) (ii) Use breadth first algorithm find a path from S to C. Specify the path cost (4 Marks) QUESTION THREE [20 MARKS] (a) Describe five properties of a good knowledge representation technique (5 Marks). (b) Translate the following statements into predicate logic. (i) all men are mortal (2 Marks). (ii) Everything in the garden is lovely (2 Marks). (iii) John and Ann are married (2 Marks). (c) Use Sematic network to represent the following predicate logic statement. (3 Marks) isa(person,mammal), instance(Mike-Hall, person), team(Mike- Hall,Cardiff), has_part(person,head), team_colours(Cardiff,blue/black) (d) Construct Semantic Net representations of the following sentence: (3 Marks) Dave is Kenyan and he is a lecturer. Lecturers teach in a university (e) Translate the following predicate logic into a frame. (3 Marks) Gender(Adam,Male),spouse(Adam,Beth), child (Adam,Charles), child(Adam,Donna) child(Adam,Ellen) QUESTION FOUR [20 MARKS] (a) Briefly explain three goals of inference. (3 Marks). (b) Explain the differences between the following inferencing methods. Use an example to illustrate your answer in each case. (i). Deductive and inductive Inferencing (4 Marks). (ii). Fuzzy logic inferencing and case-based inferencing. (4 Marks). (c) Briefly explain seven components of an expert system (7 Marks) (d) Define the term “ heuristics” as used in artificial intelligence (2 Marks) QUESTION FIVE [20 MARKS] (a) State and explain any four types of agents’ environments that interact with intelligent agents (4 Marks). (b) Briefly explain the following components of an agent. Give one example to illustrate your answer. i) Sensor (2 Marks) ii) Actuator (2 Marks) ii) Agent function (2 Marks) (c) Consider the following knowledgebase of a certain family father_of (peter, fred) . father_of (peter, tom). father_of (james,david). gender (tom, male) student (tom, KCAU). Formulate predicate- logic queries that can be typed in Prolog to find the following knowledge (i) a list of all the fathers (2 Marks) (ii) all the children of peter. (2 Marks) (v) Confirm the existence of a kcau student known as tom (2 Marks) (d) Explain any two applications of intelligent agents in business enterprises (4 Marks)

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREES OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY BIT1309 FINANCIAL MANAGEMENT FOR IT FULLTIME/ PART TIME/ DISTANCE LEARNING DATE: DECEMBER, 2018 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE (30 MARKS) a) Briefly explain your understanding of; i) Accrued expenses ii) Prepaid expenses iii) Bad debts written off iv) Allowance for doubtful debts (4 Marks) b) The following trial balance was extracted from books of Z Tamaa a sole trader on 31st July 2018 Additional information 1. Salaries due kshs 3,500 2. Insurance prepaid kshs 4,140 3. Commission receivable due kshs 1200 4. Allowance for doubtful debts is to be maintained at 5% on accounts receivable (debtors) 5. Provision for depreciation on furniture is at 15% on cost 6. Inventory (stock) on 31st July 2018 kshs 50,080 Required a) Prepare an income statement for the year ended 31st July 2018 (10Marks) b) A statement of financial position (balance sheet) as at 31st July 2018 (6Marks) a) Discuss five specific users of accounting information. (10 Marks) QUESTION TWO (20 MARKS) a) Explain branches of accounting. (4 Marks) b) A balanced trial balance does not guarantee the accuracy of financial statement. Discuss this statement giving examples of errors where the trial balance still balances. (10 Marks) c) An asset whose value is Kshs. 1,000,000 is to be depreciated at 20% p.a on reducing balance basis. Calculate the annual depreciation charges for the first three years. (6 Marks) QUESTION THREE (20 MARKS) The Edward Company uses a double column cash book to record its cash and bank related transactions. It engaged in the following transactions during the month of March 2018: March 01: Cash balance $1,450 (Dr.), bank balance $1,500 (Dr.). March 02: Paid Mark & Co. by check $120. March 04: Received from John & Co. a check amounting to $400. March 05: Deposited into bank the check received from John & Co. on March 04. March 08: Purchased stationary for cash, $25. March 12: Purchased merchandise for cash, $525. March 13: Sold merchandise for cash, $1,800. March 15: Cash deposited into bank, $850. March 17: Withdrew from bank for personal expenses, $40. March 19: Issued a check for merchandise purchased, $630. March 20: Drew from bank for office use, $150. March 22: Received a check from Peter & Co. and deposited the same into bank immediately, $880. March 25: Paid a check to Daniel Inc. for $270. March 26: Bought furniture for cash for office use, $175. March 28: Paid office rent by check, $120. March 29: Cash sales, $650. March 30: Withdrew from bank for office use, $145. March 31: Paid salary to employees by check, $300. Required: Record the above transactions in respective ledger accounts and extract a trial balance as at march 2018. (20 Marks) QUESTION FOUR (20 MARKS) a) i Define internal control system. (10 Marks) ii Evaluate the importance of internal control system in an organisation. b) Mr Kipper Ling runs a business providing equipment for bakeries. He always makes a note of sales and purchases on credit and associated returns, but he is not sure how they should be recorded for the purposes of his accounts. (10 Mark) Write up the following transactions arising in the first two weeks of august 2016 into the following relevant day books: i. Sales daybook ii. Purchases daybook iii. Sales return daybook iv. Purchases return daybook 1 August Mrs Bakewell buys $500 worth of cake tins. 1 August Mr Kipper Ling purchases $2,000 worth of equipment form wholesalers TinPot Ltd. 2 August Mr Kipper Ling returns goods costing $150 to another supplier, 1 Cook. 3 August Jack Flap buys $1,200 worth of equipment 3 August Mr Bakewell returns $100 worth of the goods supplied to her. 4 August Mrs Victoria Sand Witch buys a new oven for $4,000 5 August Mr Kipper Ling purchases $600 worth of baking trays from regular supplier TinTin Ltd 8 August Mr Kipper Ling purchases ovens costing $10,000 from Hot Stuff Ltd 8 August Mr Kipper Ling returns equipment costing $300 to Tinpot Ltd QUESTION FIVE (20 MARKS) a) (i) Define the term depreciation (ii) Explain any four factors that cause depreciation of non current assets (4Marks) (iii) Distinguish between straight line method of calculating depreciation and the reducing balance method (4Marks) b) J. Mwakisha a contractor started business on 1st January 2013.The acquisitions by cheque and disposal of machinery over the subsequent 3 years were as follows; Machine Date of acquisition Original cost Date of disposal The machines are depreciated on a straight line basis using a rate of 20% p.a Required for each of the year’s 2013, 2014 and 2015 i) Machinery account ii) Provision for depreciation on machinery account iii) Income statement extract

UNIVERSITY EXAMINATIONS: 2017/2018 EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY /BACHELOR OF BUSINESS INFORMATION TECHNOLOGY BIT 1305/BBIT 103: COMPUTER NETWORKS/ COMPUTER NETWORKS AND MANAGEMENT FULL TIME/PART TIME/DISTANCE LEARNING DATE: DECEMBER, 2018 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE [30 MARKS] a. State any two functions and virtues of a router. [2 Marks] b. (i) At which layers of the OSI Model do Wide Area Networks operate in? [2 Marks] (ii) Discuss in detail the functions of the transport layer, highlighting how TCP and UDP protocols contribute to these functions. [5 Marks] c. Given the IP address 167.34.32.45, identify the following: (i) IP class (show your working) [3 Mark] (ii) Network address [1 Mark] (iii)Subnet mask [1 Mark] (iv) Host address [1 Mark] d. Explain the steps taken when a host on an Ethernet LAN has information to send. [6 Marks] e. Connection to the Internet can be broken down into the physical connection, the logical connection, and applications. Discuss how these assist in connecting individual computers to the Internet [6 Marks] f. Explain briefly the concept of intranets and extranets [4 Marks] QUESTION TWO [20 MARKS] a) Communications facilities in the world are systematically being upgraded from analog to digital facilities. Discuss any three reasons behind this very significant movement. [6 Marks] b) Name the 568A and 568B wiring patterns [8 Marks] c) State any four attributes of a good network [4 Marks] d) With the aid of a relevant diagram, describe the construction of a fibre optic cable. [4 Marks] QUESTION THREE [20 MARKS] a. Differentiate between (i) Logical and Physical network topologies [2 Marks] (ii) Cut-through switching and store-and-forward switching [2 Marks] (iii) Network segmentation and data segmentation. [2 Marks] b. The TCP/IP model describes the functionality of the protocols that make up the TCP/IP protocol suite. These protocols, which are implemented on both the sending and receiving hosts, interact to provide end-to-end delivery of applications over a network. Explain the steps involved in a complete communication process. [7 Marks] c. Explain the functions of each of the seven layers of the OSI Reference Model [7 Marks] QUESTION FOUR [20 MARKS] a) Answer the following questions in relation to OSI and TCP/IP reference models: (i) You download a file from an FTP site on the Internet. What is the highest layer in the OSI model used in this FTP operation? [1 Mark] (ii) Which layer of the OSI reference model is responsible for ensuring reliable end-to-end delivery of data? [1 Mark] (iii) At which OSI layer is a logical path created between two host systems on a LAN? [1 Mark] (iv) When files are transferred between a host and an FTP server, the data is divided into smaller pieces for transmission. As these pieces arrive at the destination host, they must be reassembled to reconstruct the original file. What provides for the reassembly of these pieces into the correct order? [1 Mark] b) You work as a network administrator at TestKing.com. Your boss, Mrs. Tess King, is interested in the OSI layers. Match the terms with the appropriate layer below. Some options are not used. [6 Marks] c) Discuss the following concepts as used in computer networks: (i) Fault Tolerance [2 Marks] (ii) Scalability [2 Marks] d) State any three (3) major reasons why computers are networked. [3 Marks] e) The MAC address for your PC NIC is: F6-2C-B7-D3-A6-97. What is the address of the OUI portion of this NIC card, expressed as a binary number? [3 Marks] QUESTION FIVE [20 MARKS] (a) Give the functions or applications of the following network troubleshooting commands: i. Hostname [1 Mark] ii. Ipconfig /all [1 Mark] iii. Ping [1 Mark] iv. Tracert [1 Mark] (b) List and briefly discuss the functions of any two (2) networking and any two (2) internetworking devices. [6 Marks] (c) A person wishes to start a family business whose main operation will be typesetting and laying out publications. His finances allow him to only purchase two computers, a DeskJet printer and a network ready photocopier. He has approached you for advice on how he can set up a very basic network connecting all these devices. Required: (i) Clearly explain how you would help him set up the network, stating what you would require (in terms of cables, any extras that might be required) to have the network up and running. [7 Marks] (ii) What solution can you recommend for connection to the internet for this small company [3 Marks]

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREES OF BACHELOR OF SCIENCE IN IT/ BUSINESS IT/ APPLIED COMPUTING BIT 1303A/BUSS 208: E-COMMERCE FULLTIME/ PART TIME/ DISTANCE LEARNING ORDINARY EXAMINATIONS DATE: DECEMBER, 2018 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION 1 (30 MARKS) a) DISTINGUISH between the terms: E-Commerce and E-Business. (4 Marks) b) EXPLAIN the following terms as used in E-Business; i. Brick and Mortar Organizations ii. Virtual Organizations iii. Click and Mortar Organizations (2 Marks Each) c) A framework for e-commerce consist of the following components ; the ecommerce applications, e-commerce support services and e-commerce infrastructure. DESCRIBE 2 (two) examples of each of those components. (4 Marks) d) LIST four technologies that led businesses into the second wave of electronic commerce. (4 Marks) e) LIST 2 (three) advantages and 2 Disadvantages of E-Commerce over the traditional Commerce. (4 Marks) f) LIST 4 (four) the security and transaction threats of electronic Commerce systems and their solutions. (4 Marks ) g) DISCUSS some of the regulatory and legal issues of electronic Commerce (4 Marks ) QUESTION 2 (20 MARKS) a) DESCRIBE 4 (four) E-Commerce business models. (8 Marks ) b) DESCRIBE 4 (four) E-Commerce Revenue Models. (8 Marks ) c) EXPLAIN 2 (two) revenue strategy issues that companies face when selling online. (4 Marks ) QUESTION 3 (20 MARKS) a) DESCRIBE the fundamental technologies for Designing and implementing electronic Commerce systems. (8 Marks ) b) DISCUSS what is meant by “database-driven e-Commerce Web sites”. (4 Marks ) c) EXPLAIN 4 (four) ways in which an organization can create an effective business presence on the Web ? (4 Marks ) d) DISCUSS the difficulties in measuring the use of your website and related social media campaign. (4 Marks ) QUESTION 4 (20 MARKS) a) It is important to identify which business processes can be streamlined using ecommerce technologies. It is equally important to realize that some processes make effective use of traditional commerce and can’t be improved upon using technology. DISCUSS 2 (two) examples of each of the following ; i. Business processes that are well-suited for electronic commerce: ii. Business processes that are well-suited to traditional commerce: iii. Business processes that are well suited to a combination of e-commerce and traditional (2 Marks Each) b) DISCUSS 4 (four) E-Commerce Market Strategies (8 Marks ) c) EXPLAIN 2 (two) techniques and strategies that will influence ecommerce trends in the near future? (6 Marks ) QUESTION 5 (20 MARKS) a) LIST 4 (four) types of e-Commerce Payment systems. (8 Marks ) b) WHAT is a block chain in the context of electronic money? (4 Marks ) c) EXPLAIN the use of a block chain in Bitcoin. Why is it required? (4 Marks ) d) DISCUSS whether Bitcoin is a currency. (4 Marks )

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREES OF BACHELOR OF SCIENCE IN IT/ BUSINESS IT/ APPLIED COMPUTING/ ISF/ SD BIT 1303A/BBIT 105/BAC 1203/ BISF 1203/ BSD 1203: PROGRAMMING METHODOLOGY/ INTRODUCTION TO PROGRAMMING FULLTIME/ PART TIME/ DISTANCE LEARNING ORDINARY EXAMINATIONS DATE: DECEMBER, 2018 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE [30 MARKS] a) Explain any FOUR data types in the C programming language. (4 Marks) b) Write single line statements to accomplish the following: i) Prompt the user to enter an integer (2 Marks) ii) Read an integer from the keyboard an assign it to variable “num” (2 Marks) iii) If the variable “num” is not equal to 9, print “value not 9” (2 Marks) iv) Print the message “This is a C program”, on two lines where first line ends with C. (2 Marks) c) Distinguish between relational and logical operators and give examples of each. (6 Marks) d) Briefly explain any TWO advantages and TWO disadvantages of imperative programming paradigm. (4 Marks) e) Define the term ‘algorithm’ and describe any FOUR characteristics of algorithms (5 Marks) f) Predict and explain the output of the following C code: (3 Marks) #include<stdio.h> #define min(a,b) (a<b)? a:b int main() { int a,b; a=8; b=3; printf(“%d”,min(a,b)); return 0; } QUESTION TWO [20 MARKS] a) Describe any THREE attributes of a variable. (3 Marks) b) Identify THREE rules for naming variables in C (3 Marks) c) Write a C main() function that finds the length of a typed string value (6 Marks) d) Write a program in C that prints the square of all elements of a square matrix using a function that is called from main(). (8 Marks) QUESTION THREE [20 MARKS] a) Discuss the idea behind programming language control structures. (2 Marks) b) Explain the differences between the following: i) ‘A’ and “B” (2 Marks) ii) Escape sequence character and format specifier character (2 Marks) iii) Symbolic constant and literal constant (2 Marks) c) Write a program in C that reads N numbers iteratively and prints biggest and smallest of these numbers (6 Marks) d) Discuss any THREE differences between first and second generation of programming languages. (3 Marks) e) Identify any THREE advantages of using C as a programming language (3 Marks) QUESTION FOUR [20 MARKS] a) Define the following terms commonly used in C and offer examples: i) Compound statement (2 Marks) ii) Operator precedence (2 Marks) b) Explain what each of the following lines of code does. Also write the output of the program. (6 Marks) int i, j; for(i=1, j=0; i+j<25; i+=2, j+=3) { printf(“%d \n”, j+i); } c) A program is required to request and accept a digit between 1 and 10. If the digit is 1-4 the program should assign the user 200 points and display these points. Otherwise it should request for a number between 50 and 150, divide this input by 200 and display the output. Create a flowchart or write pseudocode to illustrate the solution. (5 Marks) d) Write a program in C to store the integers in the following table (hint: ignore the row and column labels) (5 Marks) (5 Marks) QUESTION FIVE [20 MARKS] a) Discuss any THREE program errors and give examples of such errors (6 Marks) b) Explain the following types of testing: i) Alpha testing (2 Marks) ii) Beta testing (2 Marks) c) A program is required to request and accept the marks for four subjects, then compute and display the total marks, the average and the grade. The grade is computed in the following manner: • 70-100 = A • 60-69 = B • 50-59 = C • 40-49 = D • 0-39 = F Required: i) Create a flowchart to design the solution. (4 Marks) ii) Write C code to implement this solution. (6 Marks) 0 1 2 3 0 10 20 30 40 1 100 200 300 400 2 1000 2000 3000 4000

UNIVERSITY EXAMINATION: 2018/2019 ORDINARY EXAMINATION FOR THE DEGREE IN BACHELOR OF SCIENCE IN INFORMATION SYSTEMS SECURITY, BASIC SOFTWARE DEVELOPMENT, BSC I.T, BBIT. BIT1301 PROBABILITY AND STATISTICS FULLTIME/PARTTIME/DISTANCE LEARNING DATE: DECEMBBER 2018 TIME: 2 HOURS INSTRUCTIONS: Answer question ONE and Any other TWO questions QUESTION ONE (30 MARKS) a) Distinguish between: i. Correlation and regression (2Marks) ii. Discrete and continuous data (2Marks) b) i. Find the value of b given that the harmonic mean of 2/3 b, ¼ b and 4/5 b is 4. (2Marks) ii. Use the three numbers in i above to show that HM < GM < AM. (3Marks) c) The probability of getting a defective product from a factory is 0.12%. Out of 80 units randomly selected, what is the probability that: i. Exactly four units are defective (2Marks) ii More than two units are defective (3 Marks) (d) Consider the following grouped frequency distribution table Class Interval Frequency Construct: (i) A histogram and a frequency polygon (ii) An O-give (iii) Estimate the median from curve (ii) above (8 Marks) (e) A and B are two events such that 1 ( / ) 4 P A B and 1 ( / ) 5 P B A .Given that P A B p ( ) find (i) P A( ) (2 Marks) (ii) P B( ) (2 Marks) (iii) Suppose 1 ( ) 5 P A B find the value of p (3Marks) QUESTION TWO (20 MARKS) (a) Name and explain four levels of measurements in statistics. (8Marks) (b) A random variable X has the following probability distribution X 0 1 2 3 4 5 6 7 f(x) 0 k 2k 2k 3k k 2 2k2 7k2+k Find the following: (i) The value of k. (ii) P(X≤6) (iii) E(x) and Var(x) (12 Marks) QUESTION THREE (20 MARKS) (a) Briefly describe correlation and regression analysis. (6 Marks) (b) The table below shows a verbal reasoning test score x and an English test score, y, for each of a random sample of 8 children who took both tests. (i) Fit a linear regression line for prediction of the English score. (ii) Estimate the English score given the verbal reasoning score is 115. (iii)Compute the sample coefficient of correlation and interpret it. (14 Marks) QUESTION THREE (20MARKS) (a) Define the following terms as used in statistics (i) Statistics (ii) Skewness (iii) Kurtosis (iv) Sample space (v) Event (10 Marks) (b) A student is likely to wake up on time with a probability 3 4 .If he wakes up on time, there is a probability of 9 10 that he will arrive in the dinning hall in time for breakfast. If he over sleeps, there is a probability of 1 2 that he will arrive at the dinning hall in time for breakfast. If he is late in arriving at the dinning hall, there is a probability of 2 3 that he will miss breakfast, but on any occasion he arrives at the dinning hall on time, he has breakfast. (i) What is the probability that on any one day, he will miss breakfast? (ii) If he misses breakfast, what is the probability that he woke up late? (iii) If the student arrives late for breakfast one day, what is the probability that he woke up late? (10 Marks) QUESTION FIVE (20MARKS) (a) Scores of an exam given to IT students are assumed to be normally distributed with a mean 62 and variance 6. What is the probability that: (i) A student taking the exam scores below 66. (ii) A student taking the exam scores between 60 and 70. (iii) What must be the cut off point for passing exam if the examiner wants only the top 90% of all students to pass? (10 Marks) (b) For two frequency distributions given below, the mean from the first (f1) was 10.66 and that from the second (f2) was 13.5. Find the value of x and y. (10 Marks)

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY/ BACHELOR OF BUSINESS IN INFORMATION TECHNOLOGY BIT 1207A: DATABASE SYSTEMS PRINCIPLES FULLTIME/PARTTIME/DISTANCE LEARNING DATE: DECEMBER 2018 TIME: 2 HOURS Instructions o Answer question ONE and any other TWO. o Question One carry 30 marks, others 20 marks each. QUESTION ONE. (COMPULSORY) (a) Define relational database system. (3 Marks) (b) With respect to information management, compare the following concepts; (i) Data security and Integrity (4 Marks) (ii) Tuple and attribute (4 Marks) (iii) File based system and DBMS (4 Marks) (c) There are three default database schemas that found in SQL namely informationschema, mysql and test. Discuss each showing its role in DBMS. (6 Marks) (d) Describe any four disadvantages of the file-based systems (4 Marks) (e) Discuss the five components of the database management system (5 Marks) QUESTION TWO (a) Read the scenarios below and come up with an ERD diagram showing all possible attributes together with PK. “A company has several departments. Each department has a supervisor and at least one employee. Employees must be assigned to at least one, but possibly more departments.” (6 Marks) (b) (i) What is data integrity (2 Marks) (ii) Discuss four important database security features (4 Marks) (iii) What are constraints? Discuss three benefits of constraints (4 Marks) QUESTION THREE a) i) Define the term ‘SQL’ with reference to database systems (2 Marks) ii) Distinguish between data definition and data manipulation (2 Marks) b) Use the table (STUDENT) below to answer the questions that follow; i. Write SQL statement to create the above table: (4 Marks) ii. Write SQL statement to insert data new record number 5. Use your own data (4 Marks) iii. Write SQL statement to change ‘KILONZO’ to ‘KALONZO’ in record 1 . (4 Marks) iv. Write SQL statement to list all details for those doing BSC-IT (4 Marks) QUESTION FOUR (a) Discuss three levels of database design. (6 Marks) (b) Write short notes on the following topics: (8 Marks) (i) Data warehouse (ii) Data mining (iii) Client/Server database (iv) Web database (c) Discuss three dependencies’ used during normalization (6 Marks) QUESTION FIVE (a) Discuss normalization. Show why its is important in database design and demonstrate how it is done. Include UNF, 1NF, 2NF and 3NF (10 Marks) (b) Discuss, with the help of a diagrams, the database life cycle. (10 Marks)