March 15, 2022

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY University Examinations 2012/2013 EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 0410: NETWORK DESIGNS AND SET UP DATE: AUGUST, 2012 TIME: 1hr 30min INSTRUCTIONS: Answer Question ONE and Any Other ONE Questions.   Question One (40 marks) a) Discuss the Network design and set up goals. [4 marks] b) Briefly explain the sectors to consider when implementing network. [4 marks] c) Outline the and explain the problems that affect the network performance. [4 marks] d) Describe the main Network design approaches in reference to network design and set up. [4 marks] e) Briefly explain the roles of Network administration in reference to network design and set up. [4 marks] f) Outline the network design issues. [2 marks] g) Describe the following: i. Routers [2 marks] ii. Switches [2 marks] iii. Hub [2 marks] iv. Modem [1 marks] v. Bottom up approach [1 marks] Question Two (20 marks) a) List and explain the types of data packets in design and set up of the network. [10 marks] b) Explain the three network troubleshooting tools. [6 marks] c) Discuss and elaborate the functional network management areas. [4 marks] Question Three (20 marks) a) State and explain the steps involved in trouble shouting a network. [6 marks] b) Describe the network topologies as sued in network design and set up. [10 marks] c) With aid of a diagram describe the construction of fiber optic cable. [4 marks] Question Four (20 marks) a) Define the term network interface cards. [2 marks] b) According to network Ethernet standards, discuss the following: i. 10 Base2 [2 marks] ii. 100 BaseT [2 marks] iii. Arcnet [2 marks] iv. FDDI [2 marks] c) Explain how you can troubleshoot a printer through a network. [4 marks] d) Describe how you can set up a Local Area Network of 15 computer in 20 x 20 metres square room. [4 marks]

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY University Examinations 2015/2016 YEAR II SEMESTER II EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 0407: DATABASE MANAGEMENT SYSTEMS DATE: AUGUST, 2016 TIME: 1.5 HOURS Section A: Compulsory Question (20 Marks) Question One a) Describe the entity relational model and use of diagram to aid in your description. [5 marks] b) Differentiate between relational and relationship as used in databases. [4 marks] c) Distinguish between distributed databases and decentralized databases. [4 marks] d) Elucidate any five reasons for distributed databases. [5 marks] e) Explain the ways in which implementation of distributed databases affect performance. [2 marks] Section B: Answer any two questions (20 Marks each) Question Two a) Describe what functions are in databases. [2 marks] b) Distinguish between: [6 marks] i. System defined functions vs user defined functions ii. Aggregate functions vs scalar functions iii. Push replication and pull replication c) List any four advantages of distributed databases. [4 marks] d) Discuss any two query optimization tips/options. [4 marks] e) List any three advantages and one disadvantage of database fragmentation. [4 marks] Question Three a) Explain the following SQL features. [6 marks] i. Triggers ii. Stored procedures iii. Views b) Discuss any two problems associated with concurrent access to databases. [4 marks] c) Discuss the ACID properties of any transaction. [8 marks] d) Explain locking as used in concurrently control. [2 marks] Question Four a) Discuss the following object oriented databases concepts. [8 marks] i. Abstract data types ii. Location transparency iii. Inheritance iv. Polymorphism b) As a database administrator, you may need to automate some administrative tools to enable you free some time for other duties. Elucidate any three administrative tasks that you can automate. [6 marks] c) List three main databases security principles. [3 marks] d) Explain any three user access controls that can be used in databases. [3 marks]

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY UNIVERSITY EXAMINATIONS 2014/2015 STAGE IV YEAR II SEMESTER II EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 0407: ADVANCED SUPPORT AND UPGRADING DATE: AUGUST 2014 TIME: 1.5 HOURS INSTRUCTIONS: Answer question one (compulsory) and any other two questions QUESTION ONE (30 MARKS) a. Define the following terms as used in computer assembly Antistatic wrist strup. (2 marks) Antistatic mat (2 marks) Voice Adapter cords. (2 marks) b. Explain the functions of the following components of a computer system Motherboards. (1 mark) power supply (1 mark) Chipset (1 mark) Computer care. (1 mark) c. Discuss the precautions taken before updating your BIOS. (5 marks) d. You are an employee of KRA and the permanent hard disk fails and the management doesn’t have a valid back up. Discuss four data recovery tools that you will advise the management to use. (4 marks) e. Discuss the general safety guidelines to follow while using computer labs. (10 marks) QUESTION TWO a. The BIOS is critical to your PCs proper functioning and the decision to flash it must be well thought of. Discuss ten common mistakes that you should avoid when flashing your BIOS. (10 marks) b. Disk management has proved to be a complex problem for most technicians. Discuss disk management tools that help detect and correct disk errors. (5 marks) QUESTION THREE a. Discuss the general troubleshooting process for any computer system. (10 marks) b. Discuss the different types of adapter cards that are used to expand and customize the capability of the computer. (5 marks) QUESTION FOUR a. Discuss a step by step process to install and configure a TV tuner card. (15 marks) QUESTION FIVE a. Discuss five best free data recovery tools that are in use today. (10 marks) b. Discuss the process of software installation for any computer system. (5 marks)

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY University Examinations 2012/2013 STAGE IV EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 0407: ADVANCED PC MAINTENANCE AND UPGRADE DATE: AUGUST, 2012 TIME: 2 HOURS INSTRUCTIONS: Answer Question ONE and any TWO other questions.   Question One (20 marks) a) Describe the essence of the following BIOS settings: i. Extended system configuration Data (ESCD) ii. Self-monitoring Analysis and Reporting Technology (SMART) iii. Boot order iv. AGP Aperture [8 marks] b) i. Describe the following system files: • AUTOEXEC.BAT • CONFIG.SYS • WIN.INI [6 marks] ii. The microprocessor is regarded as the brain of a computer system due to the processing tasks it handles. Using a block diagram, discuss the function of the various units within the microprocessor. [6 marks] Question Two (20 marks) a) State and explain any four common ways through which device drivers are installed in windows-based PCs. [8 marks] b) i. Describe any three factors to consider when attempting to purchase high quality hard drives. [8 marks] ii. Nyakobari sacco, a client of yours, calls and informs you that they are unable to print documents and yet the printer is connected. Outline the steps you would undertake to solve such a problem. [6 marks] Question Three (20 marks) a) State and describe any three motherboard form factors. [9 marks] b) i. Explain how best you would tell that the following components are faulty at start up. • Random Access Memory • Hard disk drive • CMOS battery [6 marks] ii. Differentiate between a Bus controller and a DMA controller. [5 marks] Question Four (20 marks) a) Outline how you would go about troubleshooting a PC with the following symptoms. • “ntldr missing” or “Non-system disk” boot error message • Computer boots directly to safe mode • Computer runs hot • “OS not found” error message [12 marks] b) i. Using appropriate examples, differentiate between the two types of preventive maintenance procedures. [6 marks] ii. Differentiate between an internal and external modem. [2 marks]

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY UNIVERSITY EXAMINATIONS 2016/2017 YEAR II SEMESTER II EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 0406: E-COMMERCE DATE: DECEMBER 2016 TIME: 1.5 HOURS INSTRUCTIONS: Answer Any FOUR Questions Question One – 15 Marks a) Explain the following terms hence state one difference between them. [5 marks]  E-commerce  E-business b) State three benefits of e-commerce universal standards. [3 marks] c) Compose online and traditional transaction in terms of richness. [5 marks] d) What is information asymmetry? [2 marks] Question Two – 15 Marks a) What are some five unique features of e-commerce? [10 marks] b) Explain what is meant by: [5 marks]  B2B  B2C  C2B  G2B  C2C Question Three – 15 Marks a) What are some limitations on growth of e-commerce? [4 marks] b) What is a business model? And how does it differ from a business plan? [5 marks] c) Explain three building blocks of the internet. [6 marks] Question Four a) Name and describe five servers available through the web. [10 marks] b) Name and explain three web move up languages. [5 marks]

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY UNIVERSITY EXAMINATIONS 2012/2013 EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 0405: WEB DEVELOPOMENT 1 DATE: AUGUST 2012 TIME: 1.5 HOURS INSTRUCTIONS: ANSWER ALL QUESTIONS IN SECTION A AND ONE QUESTION FROM SECTION B. QUESTION ONE (30 MARKS) a. Differentiate between internet and web. [2 marks] b. What is hyperlink? Give its two forms. [2 marks] c. i. Define URL [2 marks] ii. Give two forms in which a URL may be composed. [2 marks] d. Give two examples of top-level domain and two examples of second-level domain. [2 marks] e. What is an IP address? Give an example. [2 marks] f. outline FOUR main stages involved in website development. [4 marks] g. List FOUR factors to consider when developing a website. [4 marks] h. How is a file server different form a web server. [2 marks] i. List FOUR major web browser. [4 marks] j. Write a simple HTML code with title, head, and body tags so that it can display the following message and we browser. “This is my HTML code” [4 marks] QUESTION TWO (15 MARKS) a. What is a website? Give two(2) main classifications. [4 marks] b. Explain four (4) main parts of a basic web page and their functions. [4 marks] c. Describe the browser as client/server model. [4 marks] d. Give three (3) elements that must be contained on any website footer. [3 marks] QUESTION THREE (15 MARKS) a. With reference to website design, what is a protocol? [2 marks] b. List and explain two common internet protocols. [8 marks] c. Discuss four (4) main types of website protocols and their functions. [7 marks] QUESTION FOUR (15 MARKS) a. Using basic HTML, illustrate how you can create a link to contacts html page from home html page using the link labeled CONTACTS PAGE from the home page. Write an HTML code that will navigate you from the contacts page to home page using an image as the hyperlink. [7 marks] b. An HTML code that will create an ordered list for the following items (Toshiba, Dell, Apple, Mac) [4 marks] c. What is the HTML code that will change a pages background colour to green and the font colour to white? [4 marks]

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY University Examinations 2015/2016 YEAR II SEMESTER II EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 0404: ADVANCED OBJECT ORIENTED PROGRAMMING DATE: AUGUST, 2016 TIME: 1.5 HOURS INSTRUCTIONS: Answer Question ONE and Any Other TWO Questions. Question One (30 Marks) a) Define the following OOP terms. [6 marks] i. Object oriented programming ii. Objects iii. Class b) State any four advantages of OOP. [4 marks] c) What are the features required of an object oriented programming language. [4 marks] d) Explain any four applications of OOP. [6 marks] e) With the aid of an example explain the term constant as used in OOP. [4 marks] f) With the aid of an example explain the parts of a java method. [6 marks] Question Two (15 Marks) a) With the aid of an example distinguish between the Do and the Do….while looping control structures. [4 marks] b) Explain the output of the following java code. [2 marks] public class test { public static void main (string args [ ]){ for (intx=10;x<20;x=x+1) } } c) With examples, explain the following: [9 marks] i. Class variables ii. Instances variables iii. Local variables Question Three (15 Marks) a) Explain the requirement of the following mathematical expressions in Java. [3 marks] i. x++ ii. x- – iii. x+=y b) Explain what is meant by object oriented concept of: [12 marks] i. Inheritance ii. Abstraction iii. Polymorphism iv. Encapsulation Question Four (15 Marks) a) What are comments used for in programming? In your answer include the two types of comments used in java. [3 marks] b) With the aid of java code, explain the difference between an if and an if….else statement. [6 marks] c) Write a java program that would compare integers x and y and return the largest. [4 marks] Question Five (15 Marks) a) Explain any five primitive data types supported by java. [10 marks] b) Explain the three characteristics of an object. [5 marks]

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY UNIVERSITY EXAMINATIONS 2014/2015 STAGE IV SPECIAL/SUPPLEMENTARY EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 0404: OBJECT ORIENTED PROGRAMMING DATE:AUGUST 2014 TIME: 1.5 HOURS INSTRUCTIONS: Answer question one and any other two questions. QUESTION ONE (20 MARKS) COMPULSORY a. Define the following terms and phrases as used in programming. i. Machine language (2 marks) ii. Machine language. (2 marks) iii. Source code. (2 marks) iv. Object code. (2 marks) v. Library. (2 marks) b. i. What does a compiler do? (2 marks) ii. How is a compiler different from an assembler. (4 marks) iii. Describe the various steps of the programming process. i. Specification (1 mark) ii. Code design. (1 mark) iii. Coding. (1 mark) iv. Testing. (1 mark) QUESTION TWO a. i. Explain the function of the input operator and the output operator in c++. (4 marks) ii. Name any examples of data types used in programming. (4 marks) b. i. Write a program that calculate the area of a circle. (8 marks) ii. From your code in i above explain the object files below. i. cin ii. Cont QUESTION THREE a. i. Define the concept of abstraction and explain one example of where abstraction helps us in every date life. (4 marks) ii. Write a block of code to compute, store, and then output the volume of a sphere (use the formular volume v of a sphere of radius r is give by v=(4/3) PI r3) (8 marks) b. Enumerate any eight keyword in c++ programming. (8 marks) QUESTION FOUR a. i. Write a simple c++ program that display four line of text including the sum of two numbers. (10 marks) ii. From the code in (i) above give the expected output when the program is executed. (4 marks) b. Briefly explain the difference between object oriented programming and structured programming methods. (6 marks) QUESTION FIVE a. Write a program that compares two integers and output the largest. (12 marks) b. From the code in (a) above give the expected output when the program is executed. (8 marks)

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY University Examinations 2013/2014 STAGE III EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 0304 : ELECTRONICS CONSTRUCTION I DATE: AUGUST 2013 TIME: 1½ HOURS INSTRUCTIONS: ANSWER QUESTION ONE (COMPULSORY) AND ANY OTHER TWO QUESTIONS. QUESTION ONE (30 MARKS) (a) Explain the following terms used in electrics: (i) Capacitance. [2 marks] (ii) Inductance. [2 marks] (iii) Diode. [2 marks] (b) A current of 6mA flows through a 30kΩ resistor. Calculate the potential difference developed across it. [2 marks] (c) Explain two applications of capacitors in the field of electronics. [4 marks] (d) Explain the construction of the following fixed resistors: (i) Wire would resistor. [2 marks] (ii) Film resistor. [2 marks] (iii) Carbon composition resistor. [2 marks] (e) The bipolar junction transistors are mainly of two types. Explain them using diagrams. [2 marks] QUESTION TWO (20 MARKS) (a) (i) Explain the construction of a paper capacitor. [4 marks] (ii) For the diagram shown below, calculate: [12 marks] (I) The current drawn from the source. (II) The Pd across each resistor. (III) The current through each resistor. (IV) The power dissipated by the 5Ω resistor. (b) Explain any two transistor circuit configurations using appropriate diagram. [4 marks] QUESTION THREE (20 MARKS) (a) Discuss any four factors that determine the inductance of an inductor. [8 marks] (b) A constant current of 2 micro amperes charges a capacitor for 40 seconds. (i) How much charge is stored? [2 marks] (ii) If voltage across capacitor is 50V calculate its capacitance. [2 marks] (c) (i) Describe four applications of PN-junction diodes. [4 marks] (iii) Using appropriate diagrams, explain the forward and reverse connections of a PN-junction diode. [4 marks] QUESTION FOUR (20 MARKS) (a) Using a full-wave bridge rectifier circuit, explain how full wave rectification is achieved. [8 marks] (b) Explain any three factors that the capacitance of a capacitor depends on. [6 marks] (c) For the circuit below, calculate: [6 marks] (i) The voltage across C1. (ii) The equivalent capacitance. (iii) Charge stored in the circuit.

An asset is a resource with economic value that an individual, corporation or country owns or controls with the expectation that it will provide future benefit. Assets are reported on a company’s balance sheet, and they are bought or created to increase the value of a firm or benefit the firm’s operations. An asset can be thought of as something that in the future can generate cash flow, reduce expenses, improve sales, regardless of whether it’s a company’s manufacturing equipment or a patent on a particular technology. Assets can be broadly categorized into: Current Assets Current assets are short-term economic resources that are expected to be converted into cash within one year. Current assets include cash and cash equivalents, accounts receivable, inventory, and various prepaid expenses. Fixed Assets Fixed assets are long-term resources, such as plants, equipment and buildings. Financial Assets Financial assets represent investments in the assets and securities of other institutions. Financial assets include stocks, sovereign and corporate bonds, preferred equity, and other hybrid securities. Intangible Assets Intangible assets are economic resources that have no physical presence. They include patents, trademarks, copyrights and goodwill.

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY UNIVERSITY EXAMINATIONS 2016/2017 YEAR ONE SEMESTER TWO EXAMINATIONS FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 0303 : DESKTOP APPLICATION PROGRAMMING DATE: DECEMBER 2016 TIME: 1.30 HOURS INSTRUCTIONS: ANSWER QUESTION ONE [COMPULSORY] AND ANY OTHER TWO QUESTIONS QUESTION ONE [COMPULSORY] 1. Outline any five major features of visual basic programming language [5 marks] 2. (a) Differentiate between the following types of programming languages giving an example for each [9 marks] (i) Compiled language (ii) Interpreted language (iii) Intermediate language (b) Classify visual basic as either of the three above giving your justification [2 marks] 3. Write a visual basic code to find the sum of two numbers and display the result on message box. [4 marks] QUESTION TWO (a) For each of the following user interface elements, explain two design specifications for a good user experience [8 marks] (i) Windows (ii) Layout (iii) Text (iv) Dialog box (b) Write the code to display each of the following in VB (i) Check box (ii) Button (iii) List box (iv) Combo box [8 marks] (c) Write the VB syntax for declaring a multidimensional array and set array element values [4 marks] QUESTION THREE (a) Discuss the different data types used in visual basic [10 marks] (b) Write a code to find the factional of numbers from 1 to 15. [10 marks] QUESTION FOUR (a) Differentiate between the following concepts as used in VB. (i) Function and method (ii) IDE Vs SDK (iii) Class and Object [12 marks] (b) Write a VB code for a button click event, to find out the odd or even number and display on a message box. [8 marks] QUESTION FIVE (a) Write the VB code to display and provide the functionality of the below interface (b) Describe the following aspects as commonly mentioned in VB programming (i) Multiple document interface (ii) NET framework [8 marks]

Change is the process of altering the structure, the behaviour, the programs, the procedures purposes or output of a unit/ some units within an organization. Types of change: There are two major types of change in an organization: planned change unplanned change Planned change is the orchestrated alteration made at work in a department or an organization. It also refers to the long range and deliberate attempt to manage events by making conscious efforts towards altering programs or structures. Unplanned change is change that occurs spontaneously or within a very short time as a result of something natural or a particular random occurrence. Causes of change: External causes from the external environment Internal causes of change: from within the organization. External causes of change will include: Globalization: events taking place in other parts of the world can today directly influence what goes on in an organization and brings about certain changes such as in management style. Technology: introduction of new and sophisticated technology can cause and is causing problems within an organization for example in the sense that employees may not know how to use the new technology. It can also lead to redundancy and downsizing. Competitors: pressure from competitors can make an organization improve the quality of their output. They can also influence the reduction or increase of prices of commodities of goods and services. Laws: government laws and restrictions can bring about change in an organization such as maternity leave, paternity, minimum wage legislation retirement age etc. Education: training, quality of personnel within the organization will depend upon the type and level of education received as well as professional training. Politics: political leaders can interfere with the running of activities within the organization for example hiring and firing or remuneration. Internal causes of change: Decision making within the organization in terms of policies, remuneration, goals and objectives. Change of management; when the manager changes, then he/she will bring about changes. Interpersonal relations: interactions within the organization among the employees and between employees and management may bring about change which could be positive or negative. The organizational structure: structuring the organization has an effect on the performance and attitude of the employees. Availability or lack of equipment and materials: if they are available then positive change will be realized and if they are missing de -motivation and negative attitude towards management will set in. Organizational processes and procedures: these can bring about change especially if they are initiated by persons outside the organization. Individual expertise and skills can bring about change within the organization e.g. those who are exceptionally talented. Expertise can bring about change in profits or in the way things are done. Financial base: Availability of capital and a sound financial base can in itself cause either a negative or positive change within the organization. Organizational culture: leads to either positive or negative change in an organization