April 19, 2022

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREES OF BACHELOR OF SCIENCE IN IT/ BUSINESS IT/ APPLIED COMPUTING BIT 1302A/BUSS 208/BAC 2105: E-COMMERCE FULLTIME/ PART TIME/ DISTANCE LEARNING ORDINARY EXAMINATIONS DATE: AUGUST, 2019 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE (30 MARKS) Tesco Case Study Tesco, well known as Britain‟s leading food retail group with a presence also elsewhere in Europe, Asia and the United States has also been a pioneer online. Tesco is generally recognized as the world‟s largest online grocer and it has an annual turnover of £1 billion online in the UK and has launched in other countries, internationally and is diversifying into non-food categories. In 2006, Tesco launched Tesco Direct Web Site to rival catalogue retailers and got over 8,000 products (beds and sofas through to kitchenware, electricals, cameras, bikes and golf clubs) available giving customers more products at great Tesco prices than they have ever had access to before. Customers can choose the product they want on a new website or from a new catalogue and then order in one of three ways: On-line via the tesco.com website By phone In selected stores at the new Tesco Direct desks The Tesco.com site acts as a portal to most of Tesco’s products, including various non-food ranges (for example, Books, DVDs and Electrical items under the „Extra‟ banner). As with other online retailers, Tesco.com relies on in-store advertising and marketing to the supermarket’s Clubcard loyalty scheme’s customer base to persuade customers to shop online. However, for non-food goods the supermarket does advertise online using keyword targeted ads. For existing customers Tesco used email marketing and direct mail marketing to provide special offers and promotions to the customers. E-retailer Tesco.com uses as a „commitment-based segmentation‟ or „loyalty ladder‟ which is based on recency of purchase, frequency of purchase and value to identify categories of customer life cycle such as, “logged-on”, 81 developing”, “established”, “Dedicated” etc, to target communication to customers. Tesco.com have a touch strategy which includes a sequence of follow-up communications triggered after different events in a customer‟s lifecycle. The growth of Tesco has been achieved through a combination of initiatives. Product range development is one key area. In November 2004, Tesco’s introduced a music download service and as the technology grows, it is hoped that Tesco.com turn into a digital download store of all sorts, rather than just music. In 2007 it launched price comparison site Tesco Compare based on analysis of customer demands Questions a) Identify the E-commerce model and E-tailing business model adopted by Tesco (4 Marks) b) In 2006, Tesco launched Tesco Direct to rival catalogue retailers. Identify the advantages of this approach to (6Marks) i. Tesco company ii. Tesco Customers c) One of the critical success factors of retailing is customer acquisition and retention. From the case study identify and the advantages of the Marketing and Advertising approaches used by Tesco company. (8 Marks) d) Explain the different security measures that could be taken by Tesco to protect itself and its online customers (6 Marks) e) Why is user profile important in e-commerce? Describe three ways to compile user profile. (6 Marks) QUESTION TWO (20 MARKS) a) Define the term digital economy. (2 Marks) b) Explain; i. The term electronic marketplace and outline its main components. (9 Marks) ii. The three main functions of e-markets. (3 Marks) c) Describe each of the following standards for e-payments: (6 Marks) i. Secure socket layer (SSL) ii. Transport Layer Security (TLS) iii. Secure Electronic Transaction (SET) QUESTION THREE (20 MARKS) a) Using a well-labeled diagram, discuss the 3-tier architecture for developing e-commerce infrastructure. (10 Marks) b) Explain each of the following security issues: (10 Marks) i. Authorization ii. Authentication iii. Auditing iv. Nonrepudiation v. Integrity QUESTION FOUR (20 MARKS) a) Explain the four (4) parties usually involved in e-payments. (8 Marks) b) Define the term e-marketing. (2 Marks) c) Outline any three characteristics of marketing communications that take place via the Internet. (6 Marks) d) Outline any two (2) tangible benefits of EDI. (4 Marks) QUESTION FIVE (20 MARKS) a) Internet and its use in E-Commerce have raised pervasive ethical, social and political issues on a scale unprecedented for computer technology. Explain the following ethical, social and political issues that have developed around ecommerce (6 Marks) i. Information rights ii. Property rights iii. Governance b) When confronted with a situation that seems to present ethical dilemma, outline how you would analyze and reason about the situation (8Marks) c) Outline three key factors for the success of an E-commerce business. (6 Marks)

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY/ BACHELOR OF SCIENCE IN APPLIED COMPUTING/ BUSINESS INFORMATION TECHNOLOGY BIT 1301/ BUSS 202/ BAC 1202: PROBABILITY AND STATISTICS FULL TIME/PART TIME/DISTANCE LEARNING DATE: AUGUST, 2019 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE [30 MARKS] (a) The Marks obtained by 9 students are given below:45,32,37,46,39,36,41,48,36. Calculate the geometric mean. [3 Marks] (b) Differentiate between the following terms as used in statistics: (i) A measure of skewness and a measure of kurtosis. [2 Marks] (ii) An outcome and an event. [2 Marks] (c) Calculate the mean, median and standard deviation of the population data below. 3, 6, 7, 1, 8, 6, 1, 7, 2, 5, 7. [5 Marks] (d) Briefly describe stratified random sampling method. [3 Marks] (e) Digital limited is a manufacturing company that deals in the production of soft drink bottles. During a quality assurance exercise, it was noted that of every production lot, 0.2 per cent of soda bottles are found to be defective. The soda bottles are packed in crates each containing 25 bottles. A soft drinks manufacturer recently bought 1,500 crates of soda bottles from Digital Limited. Using the Poisson distribution, determine the number of crates that will contain at least two defective soda bottles [4 Marks] (f) The following table contains the probability distribution for the number of mobile phones sold in small shop per day: Number Phones Probability 0 0.25 1 0.30 2 0.20 3 0.15 4 0.10 Page 2 of 4 (i) Compute the mean number of mobile phones sold per day. [2 Marks] (ii) Compute the standard deviation of the mobile phones sold per day. [3 Marks] (g) For a frequency distribution, the first four moments about x=6 are 3,20,10,30 respectively. Determine the mean, the variance, the third and fourth moments about the mean. Comment on skewness and kurtosis of this data. (6 Marks) QUESTION TWO [20 MARKS] (a) The following data relates to annual profits in thousands of shillings made by an ICT firm in different years 28 35 61 29 36 48 57 27 48 40 47 42 41 37 51 62 31 32 35 40 38 37 44 51 37 46 42 38 61 59 60 44 38 44 45 45 47 38 58 47 69 63 54 39 47 50 33 56 57 64 (i) Using a class interval of 10, construct a frequency distribution table for the data. (4Marks) (ii) Construct an Ogive and find the; (a) Number of firms having profit between Ksh 37,000 and Ksh 58,000. (b) Median profit (6 Marks) (b)These are Marks for 20 students in an assignment 84,17,38,45,47,53, 76,54,75,22,66,65,55,54,51,44,39,19,54,72 Draw a steam and leaf diagram to illustrate the data and determine the mode. (4Marks) (c)The average height of 20 boys is 160cm, with a standard deviation of 4 cm. The average height of 30 girls is 155 cm, with a standard deviation of 3.5 cm. Find the standard deviation of the whole group. (6 Marks) QUESTION THREE [20 MARKS] (a) Define the following terms as used in probability. (i) Conditional probability. (ii) Sample space. (iii) Mutually exclusive events. (iv) Event. [4 Marks] (b) Fruit seller found out that out of 40 apples in a box, 8 were bad and could not be sold. Two fruits are drawn at random by a customer, one at a time without replacement. (i) Find the probability that the two apples drawn are good. [3 Marks] (ii) Find the probability that at least one of the apples is bad. [3 Marks] (c) A husband and a wife appear in an interview for two vacancies in the same post. The probability of a husband’s selection is 1/8 and that of the wife’s is 1/5. Find the probability that (i) Both of them will be selected. [2 Marks] (ii) Only one of them will be selected. [2 Marks] (d) A and B are two events such that p [4 Marks] QUESTION FOUR [20 MARKS] The table below shows the Probability and statistics examination Marks for a class of one hundred students in KCA university. The mean score of the students was 46.5 (i) Show that the values of a and b are 12 and 6 respectively. (5 Marks) (ii) Estimate the median for the above sample. (3 Marks) (iii) Determine the variance and the standard deviation (5 Marks) (iv) Given that 32% of the students failed the examination, what was the cut off points. (4 Marks) (v) Estimate the mode for this data. (3 Marks) QUESTION FIVE [20 MARKS] (a) As soon as a bottle of soda is opened, it begins to lose its carbonation. Fourteen 300ml bottles of Coca-Cola were obtained, and each was assigned a randomly selected time period (in hours). Each bottle was opened and allowed to stand at room temperature. The carbonation (y) in each bottle was measured (in volumes) after the prescribed time period (x). The summary statistics are given below. (i) Find the Karl Pearson’s coefficient to correlation and interpret it. [ 4 Marks] (ii) The coefficient of determination and comment on its value. [2 Marks] (b) Morning Lighting Company is studying the relationship between kilowatt-hours (thousands) and the number of rooms in a private single-family residence. A random sample of 8 homes yielded the following. You are further given that the Kilowatt-Hours depends upon the number of rooms. (i) Determine the regression equation. [7 Marks] (ii) Determine the estimated Kilowatt-Hours for 13 rooms. [3 Marks] (c)The Marks of 500 IT students in an examination are normally distributed with a mean of 45 Marks and a standard deviation of 20 Marks. Given the pass mark is 40; estimate the number of students who passed. [4 Marks] Number of rooms 12 9 14 6 10 8 10 10 Kilowatt-Hours (000s) 9 7 10 5 8 6 8 10

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY/ BUSINESS IT/ APPLIED COMPUTING BIT1207A BBIT107 BAC1207 DATABASE SYSTEMS PRINCIPLES FULLTIME/ PARTTIME/ DISTANCE LEARNING DATE: AUGUST 2019 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) Discuss the five advantages of DBMS (5 Marks) b) Discuss three responsibilities of DBA. (3 Marks) c) Write any four properties of a transaction. (4 Marks) d) Explain various data models with suitable examples for each (9 Marks) e) For each of the following terms, explain what the term stands for, the essence of the functions it provides and a set of example SQL statements (at least TWO for each) that implement these functions: i. DDL. (3 Marks) ii. DML. (3 Marks) iii. DCL. (3 Marks) QUESTION TWO a) Read the following scenario: 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. At least one employee is assigned to a project, but an employee may be on vacation and not assigned to any projects. Draw an ERD diagram showing all possible attributes together with PK and FK. (10 Marks) b) Describe the Data Dictionary and give a suitable example (4 Marks) c) What is data integrity? (2 Marks) d) What are constraints? Discuss three benefits of constraints (4 Marks) QUESTION THREE a). Differentiate between the following concepts as used in databases. i. Cardinality and degree of a relationship ii. Primary key and surrogate key (4 Marks) b). Consider the flat database below: i. Identify and discuss three anomalies that may occur in this data base. (6 Marks) ii. Convert this table into third normal form. (6 Marks) iii. Store the records into the resultant table(s). (4 Marks) QUESTION FOUR a) Discuss, with the help of a diagrams, the database life cycle. (8 Marks) b) PhoneTech technologies, a company that sells Nokia mobile phones has implemented a database that tracks details about their stock. The following is one of the table named Phone located in a database called Cellphones. Use this information to answer the questions that follow. i. Write down a SQL DML statement to display Nokia X series. (3 Marks) ii. Write down a SQL DML statement to remove all Nokia 2690 phones from the table. (3 Marks) iii. Write down a SQL DML statement to display the standard deviation on the price. (3 Marks) iv. Write down a SQL DML statement to display total price by PhoneType. (3 Marks) QUESTION FIVE a) What is logical data independence and why is it important? (4 Marks) b) Differentiate between 2-Tier and 3-Tier database architecture. (4 Marks) c) What are the TWO basic database access operations in a transaction (4 Marks) d) What is the purpose of concurrency control in a transaction processing system? (2 Marks) e) Discuss any THREE database design issues. (6 Marks)

UNIVERSITY EXAMINATIONS: 2018/2019 ORDINARY EXAMINATION FOR BACHELOR OF SCIENCE INFORMATION TECHNOLOGY, BSc. APPLIED COMPUTING, BSD, BISF BIT 1206: DISCRETE MATHEMATICS (DAY/EVENING) DATE: AUGUST, 2019 TIME: 2 HOURS INSTRUCTIONS: Answer question ONE and Any other TWO questions QUESTION ONE a) Let a = 1101010 and b = 1011011 in B7 [seven bit sequences]. Find a + b, a ∗ b and a′ (4 Marks) b) Determine whether or not the following is a sub algebra of D70 [Divisors of 70] i) X = {1, 5, 10, 70} (4 Marks) ii) Y = {1, 2, 35, 70} (4 Marks) c) Test the validity of the following argument: If it rains, Erick will be sick. It did not rain. Erick was not sick. (8 Marks) d) Show that p ˄ q logically implies p ↔ q (4 Marks) e) Consider a graph where V (G) = {A, B, C,D} and E (G) = [{A, B},{B, C}, {B,D},{C,D}] Find the degree and parity of each vertex in G (4 Marks) f) Let: U = {1, 2, 3, … . .8, 9} A = {1, 2, 3, 4} B = { 2, 4,6,8} C= { 3, 4,5,6} be sets Find i) A ∪ B (1 Mark) ii) B ∩ C (1 Mark) Total [30 Marks] QUESTION TWO a) Suppose f: A → B and g: B → C one to one functions. Show that (g ⃘f) ∶ A → C is one to one (4 Mark) b) Recall that a function f: IR→ IR may be identified with its graph. Give a geometrical condition which is equivalent to i) f is one to one (1 Mark) ii) f is onto (1 Mark) iii) f is invertible (1 Mark) c) Write the negation of each of statement as simply as possible i) If he studies, he will pass the exam (3 Marks) ii) He swims if and only if the water is warm. (3 Marks) iii) If it snows, then he does not drive the car. (3 Marks) d) Let 𝑝 denote, “He is rich” and let 𝑞 denote, “He is happy”. Write each statement in symbolic form i) Being rich is a necessary condition to being happy (1 Mark) ii) One is never happy when one is rich (1 Mark) iii) He is poor only if he is happy (1 Mark) iv) To be rich means the same as to be happy (1 Mark) Total [20 Marks] QUESTION THREE a) How many Diagonals does a regular polygon with 𝑛 sides have? (5 Marks) b) Which regular polygon has the same number of diagonals as sides? (5 Marks) c) Find the number 𝑚 of triangles that can be formed by the vertices of a regular polygon with n sides (and hence 𝑛 vertices) (5 Marks) d) Find the number 𝑚 of triangles that can be formed by the vertices of a regular polygon with 𝑛 sides (and hence 𝑛 vertices) if the sides of the polygon are not to be sides of any triangle. (5 Marks) Total [20 Marks] QUESTION FOUR a) List the elements of the following sets i) A = {𝑥: 𝑥 ∈ 𝐍, 3 < 𝑥 < 9} (1 Mark) ii) B = {𝑥: 𝑥 ∈ 𝐍, 𝑥 2+1 = 10} (1 Mark) iii) C = {𝑥: 𝑥 ∈ 𝐍, 𝑥 is odd , −5 < 𝑥 < 5} ` (1 Mark) b) i) Draw a Venn diagram of sets A, B, C where A ⊆ B, sets A and C are disjoint but B and C have elements in common (4 Marks) ii) Write A ∩ (B ∪ C) as the (disjoint) union of fundamental products. (5 Marks) c) Let G be the graph below: Determine whether each of the following is a closed path, trail, simple path or cycle. i) (B, A, X, C, B), (1 Mark) ii) (X, A, B, Y), (1 Mark) iii) (B, X, Y, B). (1 Mark) d) i) Define the subgraph G – e where e is an edge in G (1 Mark) ii) Define a bridge for a connected graph G (1 Mark) iii) Let G be the graph below. Find: a) G – X (1 Mark) b) G – Y (1 Mark) c) G – Z (1 Mark) Total [20 Marks] QUESTION FIVE (a) Draw the multigraph G whose adjacency matrix A is A = (5 Marks) (b) Let G be the graph where V (G) = {A, B, C, X, Y, Z} and E (G) = [{A, C}, {A, X}, {A, Y}, {B, Y}, {B, Z}] i) Find G-A (2 Marks) ii) Determine the number of connected components of G-A (2 Marks) (c) Draw a diagram of each of the following graphs G (V, E): i) V = {A, B, C, D} E = [{A, B}, {A, D}, {B, C}, {B, D}, {C, D}] (2 Marks) ii) E= [{a, b}, {a, c}, {b, c}, {d, e}] (2 Marks) d) V= {a, b, c, d, e} Determine the contrapositve of each statement. i) If he has courage he will win. (1 Mark) ii) It is necessary to be strong in order to be a sailor. (1 Mark) iii) Only if he does not tire will he win. (1 Mark) iv) It is sufficient for it to be a square in order to be a rectangle. (1 Mark) v) Prove: (p → q) if 𝑥 is an integer and 𝑥 is odd, then 𝑥 is odd (3 Marks) Total [20 Marks]

UNIVERSITY EXAMINATIONS: 2019/2020 EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE INFORMATION TECHNOLOGY BIT1205 SYSTEMS ANALYSIS & DESIGN FULL TIME/PART TIME/DISTANCE LEARNING DATE: AUGUST, 2019 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE (30 MARKS) (a) Differentiate between system analysis and system design (4Marks) (b) Discuss briefly any five requirement elicitation techniques (10Marks) (c) Define the following terms as used during system analysis project (6Marks) i) Information Technology ii) Information system. iii) Software (d) Draw a DFD for the following scenario;- (10Marks) Employees at a manufacturing company are paid each week. Their working hours are recorded manually on time sheets. The hours consist of standard hours and possibly overtime hours. The time sheets are collected each week and the details are input into the system. The data is verified and validated by the accounts department then valid data is written to the payroll transactions file. Invalid entries are output as error reports. The transaction file is used to update the employee master file, and cheques and pay slips are printed. A pay slip summary is also printed for the accounts department. QUESTION TWO (20MARKS) (a) A company could obtain software either by buying a ready-made package or commissioning its own. Discuss the advantages and disadvantages of buying a package? (6Marks) (b) A new package can be installed and probably customized. Define these two terms. (4Marks) (c) Discuss briefly any five types of information systems that can be implemented in an organization. (10Marks) QUESTION THREE (20MARKS) a) New systems developed in-house frequently require a complex suite of programs. During the development of the system, implementation will take place at different levels and at different times. Discuss four types of implementation that can be done (8Marks) b) Define the following terms;- (4Marks) i) Legacy systems ii) BPR (Business Process re-engineering) iii) CASE tools iv) System request c) State and briefly explain any four design tools. (4Marks) d) Discuss two types of feasibility studies that are done during the planning phase of a systems development life cycle. (4Marks) QUESTION FOUR (20 MARKS) a) A system analyst has completed investigations and analysis for a new system, he draws up a system requirement specification;- Identify and explain the elements of the requirement specification document. (10Marks). b) Discuss any three (3) types of systems maintenance (6Marks) c) Outline the four skills required by a project manager. (4Marks) QUESTION FIVE (20 MARKS) a) A fast food organization has expanded the number of its outlets around the city. At the moment the outlets use conventional cash tills. The organization would like to implement a Point-of-Sale (POS) system in all its outlets with linkages to a centralized computer. Assume you are the organizations system analyst and you have been asked to assist in the conversion process from the existing system to a new one. Describe any changeover options that are available and recommend the most suitable one for the system. (12Marks) b) Explain two methods used to deal with user resistance (3Marks) c) Outline the steps of the waterfall model (5Marks)

UNIVERSITY EXAMINATIONS: 2019/2020 EXAMINATION FOR THE DEGREE OF: BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY / BACHELOR OF BUSINESS INFORMATION TECHNOLOGY/ BACHELOR IN APPLIED COMPUTING/ BACHELOR IN INFORMATION AND COMMUNICATION TECHNOLOGY BIT 1205/ BBIT 104/ BCT 2101: SYSTEMS ANALYSIS AND DESIGN FULL TIME/PART TIME/DISTANCE LEARNING DATE: AUGUST, 2019 TIME: 2 HOURS INSTRUCTIONS: ATTEMPT QUESTIONS ONE AND ANY OTHER TWO QUESTION ONE a) Provide a brief explanation as to why an Organization should develop a New Information system. ( 6 Marks) b) The term systems development is used to describe all the activities that go into producing an information systems solution to an organizational problem or opportunity. Outline the activities involved. (6 Marks) c) Give a detailed explanation of Systems Analysis. (6 Marks) d) Read and understand the following narrative description. The purpose of the TEXTBOOK INVENTORY SYSTEM at a campus bookstore is to supply textbooks to students for classes at the local university. The university’s academic departments submit initial data about courses, instructors, textbooks and project enrollments to the bookstore on a TEXTBOOK MASTER LIST. The bookstore generates a PURCHASE ORDER, which is sent to the publishing companies supplying textbooks. Book orders arrive at the bookstore accompanied by a PACKING SLIP, which is checked and verified by the receiving department. Students fill out a BOOK REQUEST that includes course information. When they pay for their books, the students are given a SALES RECEIPT. Required: Draw a context DFD for the portion of the narrative described above (8 Marks) e) Explain FOUR categories of information systems (4 Marks) QUESTION TWO a) Feasibility study can be defined as Use a feasibility study to determine whether the solution is feasible, or achievable given the organization’s resources and constraints. Explain the different types of feasibility. (8 Marks) b) Differentiate between Logical and physical Design. (4 Marks) c) Explain FOUR tools that the system analyst need to utilize during project costing (8 Marks) QUESTION THREE Systems analysis can be defined as the detailed investigation and analysis of the requirements of a system to fulfill a given business problem. a) List FIVE fact finding methods used and describe a situation in which the technique is most appropriate. (10 Marks) b) Discuss the importance of feasibility study within systems investigation. (10 Marks) QUESTION FOUR a) Explain skills that system analyst must possess (4 Marks) b) Define the term Conversion and explain the different types of conversion (10 Marks) c) Explain THREE principles of developing a user centered design (6 Marks) QUESTION FIVE a) A company has decided to purchase ‘off the shelf’ (OTS) software to handle the financial aspects of its business. Describe at least FIVE general criteria that should be used to decide which OTS software applications are suitable for the company. (10 Marks) b) If no OTS software can be found that exactly matches the required criteria, what other options does the company have to obtain suitable software? (6 Marks) c) What are visual models and how are they used in Information Systems Development? (4 Marks)

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREES OF BACHELOR OF SCIENCE IN IT/ BUSINESS IT/ APPLIED COMPUTING BIT 1204: FUNDAMETNALS OF ORGANIZATONAL BEHAVIOUR/PRINCIPLES OF MANAGEMENT FULLTIME/ PART TIME/ DISTANCE LEARNING ORDINARY EXAMINATIONS DATE: AUGUST, 2019 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE a) Define management and describe the management process. (8Marks) b) Discuss challenges managers face in managing diversity. (8Marks) c) Discuss how an organization can compete globally. (6Marks) d) Explain the importance of planning in an organization. (6Marks) e) Justify why human resource is the most important asset for an organization. (2Marks) QUESTION TWO a) Explain the steps in the decision-making process. (8Marks) b) Explain how a manager can manage change in a dynamic environment. (6Marks) c) Describe management role in encouraging ethical behavior. (6Marks) QUESTION THREE a) Explain the motivational implications of Maslow hierarchy of needs theory. (10Marks) b) Describe the situations that can signal problems in an organization. (6Marks) c) What motivates you in you as student of KCA University? (4Marks) QUESTION FOUR a) Describe the importance of control in an organization. (8Marks) b) Explain the reasons for organizing. (6Marks) c) Explain the mistakes that managers make in their jobs. (4Marks) QUESTION FIVE a) Define the following concepts (8Marks) i. Span of control ii. Authority iii. Motivation iv. Delayering. b) Describe the qualities of good objectives. (6Marks) c) Compare old and new styles of management. (6Marks)

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREE OF BIT, BSD, BAC, BISF BIT 1203, BSD 1204, BISF 1204, BAC: WEB DESIGN AND DEVELOPMENT/ FUNDAMENTALS OF WEB DESIGN FULL TIME/PART TIME/DISTANCE LEARNING DATE: AUGUST, 2019 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE (a) Briefly explain the following; [4 Marks] (i) Usenet (ii) Gopher (iii) Telnet (iv) TCP/IP (b) State the difference between the following terms as used in HTML [8 Marks] (i) ROWSPAN and COLSPAN (ii) A tag and HREF tag (iii) FRAMESET tag and FRAME tag (iv) XML and HTML (c) State and explain the attributes associated with rows and cells as used with the <table> tag [6 Marks] (d)Write HTML code to divide a page as illustrated in the diagram below [8 Marks] (e) Describe the attributes that the <IMG> element supports. [4 Marks] QUESTION TWO (20 MARKS) (a) Describe the following attributes of form element [8 Marks] (b) Write HTML code to generate the following table [8 Marks] (c) Write HTML code that will link two web pages using an image [4 Marks] QUESTION THREE (20 MARKS) a). Describe the purpose of the following as used in forms (i) Radio Buttons (ii) Check Boxes (iii) Drop Down Boxes (6 Marks) b). (i) Explain what you understand by the term Web Page editor (1 Mark) (ii) Discus the advantages of a web page editor (3 Marks) (iii) State and explain any FOUR features provided by these editors (8 Marks) c). Html tags can be grouped in to two groups describe the two groups (2 Marks) (a) Write a html code to produce the following form [10 Marks] Tell us what you think about our web site, our products, our organization, or anything else that comes to mind. We welcome all of your comments and suggestions. What kind of comment would you like to send? Please contact me as soon as possible regarding this matter. Submit Comments Clear Form (b) State the function of the following image tags [6 Marks] (i) <IMG SRC> (ii) <BORDER> (iii) <ALT> (iv) <VSPACE> (v) <VALIGN> (vi) <HSPACE> (c) State four functions of web page [4 Marks] QUESTION FOUR (20 MARKS) (a) Describe the functions of the following tags (i) <Code> (ii) <font> (iii) <PRE>….</PRE> (iv) <STRONG> [4 Marks] (b) Write HTML code to produce the following document [8 Marks] COMPUTER COMPONENTS OUTLINED a. HARDWARE i. INPUT ii. OUTPUT 1. VDU 2. PRINTER iii. CPU 1. ALU 2. CU 3. MMU b. SOFTWARE i. OPERATING SYSTEM ii. APPLICATION c. USERS i. PEOPLE ii. OTHER COMPUTERS (c) Explain the function of the following servers (i) File server (ii) Printer server (iii) Proxy server (iv) Application server [8 Marks] QUESTION FIVE (20 MARKS) (a) Explain how one would insert the following in HTML page give the tags involved, its attributes and the code (i) Inserting an image (ii) Inserting horizontal line (iii) Alternating Scrolling text on the screen [9 Marks] (b) Explain the function of the following tags and write a HTML code to illustrate their usage (v) <DL> (vi) <DD> (vii) <DT> [5 Marks] (c) Describe the function of the following HTML tags (i) <BR> (ii) <Basefont> (iii) <EM> (iv) <ADDRESS> [4 Marks] (d) State two factors to take into consideration before inserting an image as background in a HTML document [2 Marks]

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREES OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY/ SOFTWARE DEVELOPMENT/ BUSINESS IT/ INFO. SEC& FORENSICS/ APPLIED COMPUTING BIT 1111/ KCAU 001/ BAC 1106/: INFORMATION LITERACY FULL TIME/PART TIME/DISTANCE LEARNING DATE: AUGUST, 2019 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE 🙁 15 MARKS) a) What is your understanding of the term “Citation”? (2 Marks) b) Referencing enhances academic writing in many ways. Explain (6 Marks) c) Susan a Bachelor of Science in Information Technology Student at KCA University retrieved two publications (a book and a journal) that she wished to use writing his assignments. Details of the two publications are as follows: Using 6th edition of the APA Manual for publications, prepare the reference entries for the above items. QUESTION TWO: (10 MARKS) a) Explain the concept of information Literacy and how it is related to life-long learning (4 Marks) b) Discuss the planning stage when tackling an information Task (6 Marks) QUESTION THREE: (10 MARKS) Giving Examples, Distinguish between Primary, Secondary and Tertiary sources of information. QUESTION FOUR: (10 MARKS) Define plagiarism and discuss four types of plagiarism most likely to happen among students when undertaking academic tasks. QUESTION FIVE: (10 MARKS) Discuss the Purpose and use of Library OPAC. Include at least five functions you carry out when using KCA University library OPAC

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREES OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY/ SOFTWARE DEVELOPMENT/ BUSINESS IT/ INFO. SEC& FORENSICS/ APPLIED COMPUTING BIT1111 KCAU001 BAC1106 HIV&AIDS FULL TIME/PART TIME/DISTANCE LEARNING DATE: AUGUST, 2019 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE [15 MARKS] a) Outline FIVE misconceptions on HIV/AIDs. (5Marks). b) Your friend has been diagnosed with HIV/AIDs, briefly describe FIVE ways you could help him/her deal with the trauma. (5Marks) c) Citing examples, identify FIVE needs of people living with HIV/AIDS (5 Marks) QUESTION TWO [10 MARKS] a) Academicians should be in the first line track in the fight against HIV/AIDS. Discuss citing FIVE reasons. (5 Marks) b) Identify FIVE things that are fueling the spread of HIV/AIDs in the African continent. (5 Marks) QUESTION THREE [10 MARKS] a) Citing examples, identify the impact of HIV/AIDs on the following i) Households ii) Children (4 Marks) b) Discuss the importance of pre and post counseling to people seeking to know their HIV/AIDS Status (6 Marks) QUESTION FOUR [10 MARKS] a) Analyze THREE ways how traditional practices have fuelled the spread of HIV/AIDS in Kenya (6 Marks) b) HIV/AIDS infection is said to undergo different phases. Discuss (4 Marks) QUESTION FIVE [10 MARKS] a) Explain the Importance of Group therapy for people infected or affected with HIV/AIDs (5 Marks) b) Describe Five ways academicians could join hands in the fight against HIV/AIDs (5 Marks)

UNIVERSITY EXAMINATIONS: 2018/2019 EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY/ APPLIED COMPUTING/ BUSINESS INFORMATION TECHNOLOGY BIT 1109/ BBIT 102/ BAC 1101: COMPUTER ORGANIZATION AND APPLICATIONS FULL TIME/PART TIME/ DISTANCE LEARNING DATE: AUGUST, 2019 TIME: 2 HOURS INSTRUCTIONS: ATTEMPT QUESTIONS ONE AND ANY OTHER TWO QUESTION ONE a) Kamau is an examination officer at KCA University. Currently the examination results are kept in the computer but he read in the newspaper that data in the computer can get lost but he did not understand how that can happen. Explain briefly the FOUR causes of computer data loss. (4 Marks) b) Discuss TWO circumstances under which the dot matrix printer would be a suitable output device in an organization. (2 Marks) c) Outline FOUR limitations of a touch screen as an output device. (4 Marks) d) For each category listed, provide two examples: (5 Marks) i. Operating systems ii. Application software iii. Freeware iv. Utility software v. Database management software(DBMS) e) Discuss the THREE documents necessary in creating a mail merge document (6 Marks) f) Explain THREE limitations of a manual database that have since been overcome by electronic database management system. (3 Marks) g) Explain TWO circumstances under which an organization would install a ring topology network. (2 Marks) h) Outline FOUR ways you can apply word processing program within the industry. (4 Marks) QUESTION TWO a) A computer system contains various types of memories. Explain any FIVE types of these computer memories. (10 Marks) b) A student wants to transfer all files in the desktop of a computer to a new folder in drive C. state the steps he should follow. (4 Marks) c) Off the shelf software is preferred for small/medium sized business. Discuss THREE reasons that could inform such a decision (3 Marks) d) Outline the procedure used in selecting the following in ms-word i. An entire paragraph (1 Mark) ii. An entire sentence (1 Mark) iii. An entire document (1 Mark) QUESTION THREE a) A large manufacturing firm has opened distribution outlets in three regions within the country and intends to connect them using computer networks i. Describe the type of network that you would recommend to the firm (2 Marks) ii. Outline THREE appropriate devices that could be used during installation of such a network (3 Marks) iii. Explain THREE benefits that the organization will get for installing the network (3 Marks) b) Using examples in each case differentiate between relative referencing and absolute referencing. (4 Marks) c) Describe any TWO type of user interfaces used in operating systems (4 Marks) d) Highlight TWO health related problems that would be caused by each of the following devices: i. Keyboard (2 Marks) ii. CRT visual display unit (2 Marks) QUESTION FOUR a) There are FIVE computer generations. They all describe technological advancement in both hardware and software. Describe THREE features of both the FIRST and FIFTH generation computers. (6 Marks) b) Mito college has created a database file to store details of the students. The database contains the following fields; Name, Date of birth, Adm no, Passport photo, Gender and next of kin i. Define the term database (1 Mark) ii. Allocate the most appropriate data type for each field (6 Marks) iii. Write an expression that would be used to extract records for students whose age is above 18years and below 25 years (2 Marks) c) State the function of the following features in Ms-word: i. Thesaurus (1 Mark) ii. Format painter (1 Mark) iii. Indentation (1 Mark) iv. Watermark (1 Mark) v. Drop cap (1 Mark) QUESTION FIVE a) With the aid of a diagram, illustrate THREE types of charts that might be used to analyze business trends in spreadsheet. (6 Marks) b) Outline FOUR characteristics of the second generation languages (4 Marks) c) Distinguish between the following terms: i. Worksheet and workbook (2 Marks) ii. End note and footer (2 Marks) iii. Operating system and application software (2 Marks) iv. Superscript and subscript (2 Marks) v. Printer and plotter (2 Marks)

UNIVERSITY EXAMINATIONS: 2019/2020 EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY BIT 1106A: OPERATING SYSTEMS DISTANCE LEARNING DATE: AUGUST, 2019 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTIONS ONE(COMPLUSORY) a) What are the four conditions required for deadlock to occur? (8 Marks) b) List and describe the three memory allocation algorithms? (6 Marks) c) What are the advantages of multi-programming? (2 Marks) d) What is a semaphore? Explain the two types (4 Marks) e) Explain demand paging (2 Marks) f) i) What are CPU schedulers? (2 Marks) ii) Describe various types of schedulers. (6 Marks) QUESTION TWO a) Describe the three state process model, describe what transitions are valid between the three states, and describe an event that might cause such a transition. (6 Marks) b) i) What is a process? (2 Marks) ii) What are attributes of a process? (4 Marks) c) What is the function of the ready queue? (3 Marks) d) What is a race condition? Give an example? (3 Marks) e) What are monitors and condition variables? (2 Marks) QUESTION THREE a) Describe the following scheduling algorithms FCFS Round Robin Shortest Job First (6 Marks) b) Given the following processes and burst times PROCESS Burst time Calculate the average wait time when each of the above scheduling algorithms is used? Assume that a quantum of 8 is being used. (9 Marks) c) Which scheduling algorithm, as an operating systems designer, would you implement? (5 Marks) QUESTION FOUR a) Describe the Producer/Consumer problem. (3 Marks) b) Describe the problems associated with producing a software solution to the producer/ consumer problem. (5 Marks) c) Show a possible solution to the above problem, stating any assumptions that you make. (8 Marks) d) Describe the benefits of a mono-programming operating system. (4 Marks) QUESTION FIVE a) Describe the four generations of computing and how operating systems developed as a result. (8 Marks) b) Describe the two general roles of an operating system, and elaborate why these roles are important. (4 Marks) c) There is some debate as to what will constitute a fifth generation computer. Assume such a computer is available. What do you think will differentiate it from the computers of today? (8 Marks)