March 28, 2022

UNIVERSITY EXAMINATIONS: 2020/2021 EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 305: PROGRAMMING METHODOLOGY DATE: NOVEMBER, 2021 TIME: 2 HOURS Instructions: Answer ALL questions. QUESTION ONE (20 MARKS) a) Amina has been advised to use a high level programming language to develop a system for a certain organization: (i) Outline two features of the programming language [2 Marks] (ii) List three examples of high level programming languages [3 Marks] b) Name two characteristics of a good algorithm. [2 Marks] c) State and explain two types of repetition structures in C programming. [3 Marks] d) State whether the following statements are true or false:- [2 Marks] (i) Keywords can be used as variable names (ii) Special characters can be used as variable names e) Outline four differences between an interpreter and a compiler [4 Marks] f) Write a program in c to calculate total of two floating point numbers then display the average. [4 Marks] QUESTION TWO (15 MARKS) a) Write a C program that counts the number of digits 9 to 0 [5 Marks] b) The figure below shows a trapezoid. Write a C program that will solve the area of the trapezoid c) Identify and correct the errors in each of these statements: – [3 Marks] i. Printf(welcome); ii. scanf(“d”, x); iii. printf(“welcome”) d) Explain four data types supported by C language [4 Marks] QUESTION THREE (15 MARKS) a) Write C program that reads 4 percentage scores from a games scoreboard then prints a message using the following criteria: [5 Marks] b) Explain why the main() function is special in a C program [2 Marks] c) Write a C program that prompts the user to enter the radius of a circle and then calculates the area of a circle. (3 Marks) Page 3 of 3 d) Write a C program that prints the following output on the screen. [3 Marks] This is final Exam paper for the Diploma students Observe the rules e) Differentiate between printf and scanf as used in C programming. [2 Marks] QUESTION FOUR (15 MARKS) a) Write a C program that prompts the user to enter three numbers, calculate and prints the sum as output. [4 Marks] b) List and briefly explain THREE type of control structures supported by C language. [6 Marks] c) With the aid of an example illustrate the syntax of commenting a block of statement in C programming language. [5 Marks]

UNIVERSITY EXAMINATIONS: 2020/2021 EXAMINATION FOR DIPLOMA IN INFORMATION TECHNOLOGY DIT 304: PRINCIPLES OF COMPUTER SUPPORT AND MAINTENANCE DATE: DECEMBER, 2021 TIME: 2 HOURS INSTRUCTIONS: Answer Question ONE and Any Other Two Questions QUESTION ONE (COMPULSORY) a) Describe in details THREE major reasons why we partition drives just before formatting and installation of operating systems. [6 Marks]. b) Discuss FIVE factors one would consider before purchasing a server for network operations. [5 Marks] c) Describe any THREE causes of overheating of microprocessor. [3 Marks] d) Joe realized on his personal desktop that there was no display received from the VGA card despite all other system components functioning well. i. Discuss TWO possible faults with the system and relevant solutions. [4 Marks] ii. Give TWO possible causes for the faults mentioned above. [2 Marks] QUESTION TWO a) Describe FOUR main system board components and their functions in computer operations. (4 Marks) b) Describe how you can disassemble a computer system. (5 Marks) c) Mr. Kamau started his computer and after some minutes of operation the computer entered into a deadlocked state. He was not able to perform any task. Explain in detail THREE exact causes of the problem. (6 Marks) QUESTION THREE a) Daughter boards are commonly used when assembling computers, describe THREE scenarios when they are applicable. (3 Marks) b) Give the solutions for the following video display unit troubleshooting tips: (6 Marks) i. The picture does not appear ii. The screen is NOT synchronized iii. Shaking screen c) State and describe the process of setting up logical locations on system physical drivers and give TWO reasons why we carry out the process. (3 Marks) d) Philip was required to conduct training on the use of new computer systems in his company. Describe TWO training methods that could have used. (3 Marks) QUESTION FOUR a) Discuss FOUR safety aspects that should be considered when selecting a power supply unit (4 Marks) b) Distinguish between disk compressor and disk defragmenter utilities as used in computers. (2 Marks) c) Sarah noted that some of her documents in her computer were encrypted and she was forced to pay a certain fee through internet to decrypt her files. i. Identify this type of attack (1 Mark) ii. Outline four causes of attack identified in (i). (4 Marks) d) Give the procedure of how one would install a PS2 KEYBOARD device while the computer is still on. (4 Marks)

UNIVERSITY EXAMINATIONS: 2021/2022 EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 302: FINANCIAL MANAGEMENT FOR IT DATE: NOVEMBER 2 HOURS INSTRUCTIONS: ANSWER QUESTIONS ONE AND ANY OTHER TWO QUESTION ONE (20 Marks) a) Grills Co. Ltd has been trading for some years as a distributor. The following list of balances has been extracted from his ledger as at 30th June 2021 The following matters are to be taken in to account: i) Stock in trade at 30th June 2021was Shs. 9,884 ii) Rates paid in advance at 30th June 2021, Shs.40 iii) Rent receivable due at 30th June 2021, Shs.250 iv) Lighting and heating due at 30th June 2021, sh.85 v) Provision for doubtful debts to be increased to Shs.388 vi) Included in the amount for insurance Shs.172, is an item for Shs. 82 for motor insurance and this amount should be transferred to motor expenses. vii)Depreciation has been and is to be charged on vans at an annual rate of 20% on cost. viii) Depreciate buildings Shs.500 Required: i) Prepare income statement for the year ended 30th June 2021 (10 Marks) ii) Prepare statement of financial position as at 30th June 2021 (10 Marks) QUESTION TWO (15 Marks) a) The following transactions are extracted from the books of Wali enterprises for the month ended 31st July 2021 1: Started business with Kshs. 600,000 in the bank and 500,000 in cash 2 Bought goods on credit from Ndung’u Kshs. 270,000 3: Bought goods on credit form S. Muigai Kshs. 75,000 5: Bought goods for cash Kshs. 54,000 6: We returned goods to Ndung’u Kshs. 12,000 8: Bought goods on credit from S. Muigai Kshs. 57,000 10: Sold goods on credit to K. Mwaniki Kshs. 117,000 12: Sold goods for cash Kshs. 63,000 18: Took Kshs.900 of the cash and paid it to the bank 21: Bought machinery by cheque Kshs. 165,000 22: Sold goods on credit to M. Otieno Kshs. 66,000 28: We returned goods to S. Muigai Kshs. 9,000 29: We paid Ndung’u by cheque Kshs. 258,000 31: Bought machinery on credit from Kinuthia Kshs.81,000 Required: i) Enter the transactions in the relevant ledger accounts. (8 Marks) ii) Balance off the ledger accounts and extract a trial balance. (7 Marks) QUESTION THREE (15 Marks) An organization bought a motor vehicle at Ksh. 600,000. The motor vehicle depreciation is to be calculated at a rate of 10% per annum. Required: i) Determine the value of depreciation for year 1,2 and 3 based on reducing balance method. (2 Marks) ii) Determine the value of depreciation for year 1,2 and 3 based on straight line method. (3 Marks) iii) Explain five significance of preparing income statement and balance sheets. (5 Marks) iv) Explain two uses of the special and three general journals. (5 Marks) QUESTION FOUR (15 Marks) a) Explain four errors that violate the equality of a trial balance totals (4 Marks) b) Write short notes on the following accounting concepts (3 Marks) i) Prudence concept ii) Revenue Realization Concept iii) Historical Cost Concept c) Explain two Characteristics of assets and liabilities (2 Marks) d) Explain three significance of balancing off of the ledger accounts (3 Marks) e) Explain three Limitations of accounting information (3 Marks)

Diploma in Supply Chain Management Free Knec Past Papers Diploma in Supply Chain Management Module 1 Business Law Business law 2013 Nov Business law 2014 July Business law 2014 July a Business law 2015 July Business law 2015 Nov Business law 2016 July Business law 2016 Nov Business law 2017 July Business law 2017 Nov Business law 2018 July Business law 2018 Nov Communication skills Economics Elements of Law Elements of Law 2013 July Elements of Law 2014 July Elements of Law 2014 Julya   Financial Accounting Financial Accounting July 2013 Financial Accounting Nov 2013 Financial Accounting July 2014 Financial Accounting July 2015 Financial Accounting July 2016 Financial Accounting July 2017 Financial Accounting Nov 2017 Financial Accounting July 2018 Financial Accounting Nov 2018  

UNIVERSITY EXAMINATIONS: 2020/2021 EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY/ DIPLOMA IN BUSINESS INFORMATION TECHNOLOGY DBIT403/ DIT 301: OPERATING SYSTEMS DATE: DECEMBER, 2021 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE (20 marks) COMPULSORY a) Briefly explain the following types of operating systems: (5Marks) i. Multi-user operating system ii. Multi-processor and Multitasking operating system iii. Network operating systems iv. Real time operating systems v. Time sharing operating systems b) Deadlock prevention is accomplished by preventing any of the Coffman conditions from occurring. Briefly explain how the four conditions can be prevented. (4 Marks) c) Using a diagram explain the concept of an operating system acting as the bridge between the computer hardware and software. (4 Marks) d) Clearly explain any five functions of an operating system (5 MARKS) e) Explain the term “deadlock” as used in operating systems (2 Marks) QUESTION TWO (15 MARKS) a) With the aid of a well labeled diagram, illustrate and briefly explain the five states of a process as used in operating systems (5 Marks) b) Explain the following types of operating systems: – (6 Marks) i. batch operating system ii. Real time operating systems iii. Network operating systems (NOS) (b) Describe four advantages of threads over processes. (4 Marks) QUESTION THREE (15 MARKS) a) List and explain four conditions necessary for a deadlock to occur (8 Marks) b) Briefly explain three functions of a computer operating system. (3 Marks) c) State and explain two ways of avoiding deadlock (2 Marks) c) Explain the following memory management requirements:- (2 Marks) i) Protection ii) Sharing QUESTION FOUR [15 MARKS] a. Define the term Operating system and give three examples of the same. (3 Marks) b. State and explain any three processing scheduling algorithms (6 Marks) c. Explain three file management activities supported by an operating system (3 Marks) d. State and explain 3 basic function of input and output management (3 Marks)

UNIVERSITY EXAMINATIONS: 2020/2021 EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 205: PRINCIPLES OF DATABASE DESIGN DATE: NOVEMBER, 2021 TIME: 2 HOURS Instructions: Answer Question ONE (COMPULSARY) and ANY other TWO questions. QUESTION ONE [20 MARKS] a) List any four factors a database designer should consider when selecting a DBMS system in your organization. [4 Marks] b) Wanguru Company Limited intends to introduce a new computerized system in order the management of its employee’s records. Outline FOUR good features you would want to see in the implemented Wanguru database system. [4 Marks] c) KCA University uses the Database approach instead of a manual systems approach for keeping records. Explain any four disadvantages of using manual database approach. [4 Marks] d) Discuss FOUR components of a database management system (DBMS). [4 Marks] e) Explain FOUR classifications of relationships based on Degree. [4Marks] QUESTION TWO [15 MARKS] a) Describe the following attributes and give an example in each case: i. Derived Attribute ii. Key Attribute iii. Composite Attribute iv. Single-Valued Attribute v. Optional Attribute [5 Marks] b) List three types of users associated with the database implementation [3 Marks] c) Describe the following classes of database integrity and explain how they are enforced. i). Entity integrity ii). Referential integrity iii). User defined Integrity [3 Marks] d) Write a simple SQL statement that can be used to insert students details into the database [4 Marks] QUESTION THREE [15 MARKS] The report below shows information about DreamHome rental details. a) Normalize the report above to third normal form. [10 Marks] b) State and explain three types of anomalies found in a database table. [5 Marks] QUESTION FOUR (15 MARKS) a) Define the following terms as used in database design and development and give one example in each case. i. Entity [2 Marks] ii. Database Management System [2 Marks] iii. Strong Entity [2 Marks] iv. Weak Entity [2 Marks] b) Design a Hierarchical Database Model based on the data below [5 Marks] c) Identify and explain THREE factors to consider when selecting a DBMS system. [2 Marks]

Six principles to be incorporated to ensure that management information needs are adequately met: Accuracy – The degree to which the Logistics Information System reports should match with the actual physical counts. The logistics information must accurately reflect both the current status as well as the periodic activity for measures such as customer orders as well as levels of inventory. Availability – Logistics information must be readily available when required. Enterprises usually have substantial data relating to logistics activities, but these are often paper based or very difficult for retrieval from computer systems. It is necessary that these are available speedily to improve customer response and decision making. Timeliness – Refers to the time lapse between when an activity occurs and when the activity becomes visible in the information system. It is essential that timely information be provided for quicker management feedback. Corrective action can be taken and loss can be minimized with timely management controls. Thus, timely information reduces uncertainty and identifies problems, reduces inventory requirements and increases decision accuracy. Exception-based Logistics Information System – LIS needs to be exception-based in order to highlight problems and opportunities. The information system must identify exception situations, which require attention of management and decision-making. Managers can then focus on situations, which require maximum attention and offer opportunity to improve service or reduce cost. LIS need to be state of the art, highly exception-oriented and must utilize the system for identifying decisions requiring management attention. Appropriate Format – Logistics reports and screens need to contain the right information in the proper structure and must follow a logical sequence. Flexibility – LIS must be flexible to meet the requirements of both system users and customers. Tailored data to meet specific customer requirements must be made available by information systems. Within the organization, information systems must be capable of upgrading to meet future requirements of the enterprise without incurring huge costs or time.

Logistics information systems are the means of capturing, analyzing, and communicating information related to logistics and supply chain management. Need for timely and accurate information is critical owing to the following reasons: Total customer service includes information related to order status, product availability, delivery etc. To reduce supply chain inventory, information is very essential as this can minimize demand uncertainty There is more flexibility with information as there is clarity as to how, when and where resources may be utilized to gain strategic advantage This has triggered the need for an effective Logistics Information System.

UNIVERSITY EXAMINATIONS: 2021/2022 EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY/ DIPLOMA IN BUSINESS INFORMATION TECHNOLOGY DIT 203: SYSTEM ANALYSIS AND DESIGN DATE: DECEMBER 2021 TIME: 2 HOURS INSTRUCTIONS: Answer Question One And Any Other Two Questions. QUESTION ONE a) Define the following terms as used in System Analysis and Design. [5 Marks] i) System ii) Sub-System iii) Information System iv) System Design v) Feasibility studies b) Define the term stake holders and give three stake holders of a software system. State and explain system stake holders [5 Marks] c) Explain the advantages of flow charts [5 Marks] d) QuickCabsis an independent taxi company operating in a major city. QuickCabsowns taxis which it rents out to drivers on an annual basis. Each vehicle is effectively rented out to three drivers to cover three 8 hour shifts in a day. QuickCabsis a profitable company because it has built up a good reputation locally, and there is always a waiting list of drivers wanting to apply to rent a vehicle. QuickCabsexpands gradually by purchasing new vehicles from local car dealers. Each driver pays an annual rental fee in advance to QuickCabsin return for use of a vehicle for 8 hours a day every day of the year. In addition to the annual rental, QuickCabstakes 5% of the money a driver earns every week. QuickCab sis responsible for taxing, insuring and maintaining the vehicles. If a vehicle is due for a service or needs to be repaired, QuickCabscontacts a garage and arranges it. QuickCabskeeps records of the repairs and services for each vehicle, and records of the corresponding garages. At the end of each shift, drivers give the money they have earned to BCSCabs. If they needed to refuel the vehicle, they also submit an expense claim at the end of the shift. At the end of every week, QuickCabscalculates the amount owed to each driver based on the money earned from fares, the expense claims and the deduction of 5%. The drivers are then paid. Required: (i) Create a context diagram for QuickCab. [5 Marks] QUESTION TWO [20 MARKS] a) Explain any three desirable properties of good system design. [6 Marks] b) State and explain the three advantages and two disadvantages of using Questionnaires as a technique for gathering system requirements. [5 Marks] c) Discus main characteristics of user Interface. [4 Marks] QUESTION THREE a) Describe the system development life cycle. [10 Marks] b) Discuss the main roles of a system analyst in a software project management. [3 Marks] c) Using your own words, define “effective system” [2 Marks] QUESTION FOUR a) Give a detailed explanation of a feasibility study. Explain what it is, its importance in system development life cycle as well as all the types of feasibility study, and write a sample feasibility study report (including the main parts). [9 Marks] b) Describe software usability. [2 Mark] (i) Identify the main factors contributing to software usability. [4 Marks]

1. Stock outs- It‘s impossible to build equipment or run production plant when you are missing the necessary parts. This is especially problematic if the parts are not commonly available as the lead time can be weeks or months. 2. Lead time variability- Sometimes lead time varies from vendor to vendor which may create inventory surplus and sometimes stock outs. Ordering excess inventory strains your cashflow and one effective strategy to eliminate variability is to consolidate a company‘s suppliers thus everything arrives at the same time. 3. Shipping delays- It is the most unpredictable issue that arises hence affecting lead time, shipment can be affected by raw material shortage or force majeure 4. Too many processes-When factory workers have to build every component of a finished assembly, it will take longer to complete a project. 5. Disorganized inventory-Inventory lacking proper records and poorly stored can be hard to administrate, this makes it hard to make effective decision on planning for lead time

UNIVERSITY EXAMINATIONS: 2021/2022 EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY/ DIPLOMA IN BUSINESS INFORMATION TECHNOLOGY DIT 108: COMPUTER ORGANISATION AND ARCHITECTURE FULLTIME/ PART TIME DATE: NOVEMBER, 2021 TIME: 2 HOURS INSTRUCTIONS: QUESTION ONE IS COMPULSORY, CHOOSE TWO OTHER QUESTIONS QUESTION ONE (20 MARKS) Compulsory a) Define the following acronyms and terms as used in computer systems [5 Marks] (i) ISA (ii) binary (iii) 3Gb (iv) CD RW (v) EEPROM b) Differentiate between the following expressions used in computer systems [8 Marks] (i) Computer architecture and computer organisation (ii) CMOS and Cache (iii) Analogue and digital (iv) Northbridge and southbridge c) Perform the following operation 10110001 – 101111 [2 Marks] d) Name the four components that make up a modern computer as first developed in the von Neumann machine. For each give the function. A neat diagram should accompany the description [5 Marks] QUESTION TWO (15 MARKS) a) Explain four reasons why an organization may decide to buy ready-made software instead of developing software in house. [4 Marks] b) State and explain any two features of third generation computers. [4 Marks] c) Define the following terms as used in computing: [5 Marks] i) Byte ii) Logic gate iii) Binary notation iv) Information v) Memory d) State the functions of the following [2 Marks] i. Memory stick ii. Motherboard QESTION THREE (15 MARKS) a) Define the term device driver. Give reasons why it is important to install device drivers when integrating hardware devices (4 Marks) b) Give the function of the following parts of a computer (4 Marks) i. Registers ii. Motherboard iii. Peripheral devices iv. Ports c) Give any two differences between Random access memory (RAM) and Read only memory (ROM) as used in computing [3 Marks] d) Give any four functions the Operating system in a computer [4 Marks] QUESTION FOUR (15 MARKS) a) List any two logic gates and give their truth tables and draw the symbols [5 Marks] b) Give the difference between SSI and VLSI [2 Marks] c) Describe any two input devices used with computers today. [4 Marks] d) Make the following number conversions [4 Marks] (i) 277.63(8) to ______________(10) (ii) 110010010(2) to ____________(8) (iii) 4A0.5F(16) to ______________(2) (iv) 33.33(10) to ______________(16)

Lead Time is the amount of time, defined by the supplier, that elapses from the time a customer expresses a desire until that desire is satisfied. Its elements include; order receipt, order fill (by whatever means), and shipment. The supplier always defines the Lead Time, because the supplier determines how to fill an order. Lead Time is used to: Create action messages in advance of a need in the planning system. Define the completion date of an action Ways of reducing lead time: 1. Increasing order frequency Ordering more frequently in small quantities can help reduce your lead time and carrying costs. This is particularly true if you‘re ordering from domestic suppliers that come with the assurance of shorter and more predictable lead times. While ordering more frequently in smaller quantities could be more expensive as you won‘t enjoy the perks of bulk shipping, you should be able to reduce your carrying costs. So it‘s up to you to decide which option is best for your business. With new shipments constantly coming in, you‘ll be able to cut down the amount of inventory in your facility, freeing up space for other products. 2. Automating the transmission of information A purchase order may need to go through a few different stages of approval before it‘s sent off to your supplier. It‘s also likely that your suppliers have structured their businesses in similar ways with multiple stages in the supply chain. As a result, you‘re suffering longer lead times. A great way to start on automating processes would be to use inventory management software. The inventory management software can generate purchase orders once inventory levels hit the reorder point. 3. Provide forecasts to your supplier When dealing with hundreds of SKUs, it can be difficult to keep a close monitor on every one of them. You can share sales data with your suppliers, allowing them to anticipate an incoming order by referring to past sales data. If they‘re expecting a new order, they can speed up the fulfillment process by setting aside your usual order, ready to be packed and shipped upon receiving the purchase order.