UNIVERSITY EXAMINATIONS: 2015/2016
EXAMINATION FOR THE DIPLOMA IN BUSINESS/ INFORMATION
TECHNOLOGY
DIT104 COMPUTER ORGANIZATION
DATE: AUGUST 2016 TIME: 1½HOURS
INSTRUCTIONS: Answer Any THREE Questions.
QUESTION ONE
a) What is an operating system and what are its functions? Name two operating systems
[4 marks]
b) Differentiate between Freeware, Public Domain, Shareware, and Open-Source software
[3 Marks]
c) List the components of the CPU and explain the purpose of each [3 Marks]
d) Transform 47 (base 10) to base 2 and transform 10001001 to a decimal number
[4 Marks]
e) Explain the meaning of Multiprocessing, Multiprogramming, and Time Sharing.
[3 Marks]
f) Explain the Storage Device Hierarchy [3 Marks]
QUESTION TWO
a) Describe how a computer represent and store data and instructions [4 Marks]
b) Differentiate between a High-Level Language and Machine Language. List the
advantages of using a High-Level Language instead of Machine Language for
programming a computer. [5 Marks]
c) Discuss the function of the following translation softwares [6 Marks]
i. Assembler
ii. Compiler
iii. Interpreter
d) Using diagrams explain different network topologies [5 Marks]
QUESTION THREE
a) List some three popular internet search engines [3 Marks]
b) Describe URL and HTTP [4 Marks]
c) Explain the following cell addressing methods and give example for each case
[3 marks]
i. Relative cell addressing method
ii. Absolute cell addressing method
iii. Mixed cell addressing method
d) Computer memory can be divided into two broad categories.Discuss [4 marks]
e) Explain the following functions as used in Microsoft Excel. Give examples of each
i. TODAY() [2 Marks]
ii. SUMIF [2 Marks]
iii. COUNTIF [2 Marks]
QUESTION FOUR
a) Explain the following features as used in Ms Word [6 marks]
i. Mail merge
ii. Auto correct
iii. Macros
b) Describe information processing cycle [4 marks]
c) Explain the function of the following keyboard shortcuts as used in Ms Word [4 marks]
i) Ctrl+X
ii) Ctrl+V
iii) Ctrl+C
iv) Ctrl+Y
d) Describe each of the following Ms Word Features [6 marks]
i) Hyperlink and Bookmark
ii) Mail Merge
iii) Headers and Footers
QUESTION FIVE
a) How are charts useful in Excel? Compare any three chart types available in Excel.
[4 Marks]
b) Write formulas for the operations (i) – (iv) based on the spreadsheet given below along with
the relevant cell address:
i. To calculate the Total Marks as sum of Science, Maths & Computers for each student and
display them in column F. [4 Marks]
ii. To calculate the average marks for each student and display them in column G [3 Marks]
iii. To calculate the highest marks in Computers and display it in cell E7 [2 Marks]
iv. To calculate the total number of students appearing for the Science test and display it in
cell C8. [3 Marks]
c) Outline any four uses of internet today [4 marks]
