UNIVERSITY EXAMINATIONS: 2011/2012
YEAR 1 EXAMINATION FOR THE BACHELOR OF SCIENCE IN
INFORMATION TECHNOLOGY
BIT 1109 COMPUTER ORGANIZATION & APPLICATIONS
DATE: APRIL 2012 TIME: 2 HOURS
INSTRUCTIONS: Answer Question One and Any other Two Questions
QUESTION ONE (COMPULSORY)
a) Differentiate between the following
i) ROM and RAM [2 Marks]
ii) Bit and Byte [2 Marks]
iii) Application Software and System Software [2 Marks]
iv) Hardcopy and Softcopy [2 Marks]
b) (i) Define an Operating System [1 Mark]
(ii) Give TWO functions of any Operating system [2 Marks]
(iii) State three examples of Operating Systems [3 Marks]
c) Explain the following cell addressing methods as used in Microsoft Excel
d) The following is a toolbar used often in Word processing
i. Identify its name [2 Marks]
ii. Outline the name and function of the labeled icons [6 Marks]
A B C D
E F
2
e) Explain the meaning of the following MS-DOS commands:
i. DIR *.TXT /P
ii. TYPE MARY.TXT
iii. COPY *.EXE C:\JANE
iv. FORMAT A:/S /Q
[8 Marks]
QUESTION TWO
(a) Explain the meaning of the following terms as pertains to storage devices
i) Sequential / Serial access
ii) Direct / Random access [2 Marks]
(b) (i) What are the different types of Secondary storage media? [2 Marks]
(ii) Explain the term Primary Storage [2 Marks]
(iii) Distinguish Between Volatile and Non-Volatile memory [2 Marks]
(iv ) Identify and explain the functions of any two system utility programs [2 Marks]
(c) Explain by using examples the following cell addressing methods as they apply in spreadsheets
(i) Mixed cell addressing method [2 Marks]
(ii) Absolute cell addressing method [2 Marks]
(iii) Relative cell addressing method [2 Marks]
(iv) 3-D cell addressing method [2 Marks]
(d) Explain the function of the following features/tools in word Processing
i. Replace
ii. Frames
[2 Marks]
QUESTION THREE
(a)List the steps you would follow to perform the following tasks: –
i. Creating a document for the first time
ii. Saving a document file in a new directory without changing the filename
iii. Opening a document that has been saves in My Documents folder
[6 Marks]
(b)What are search engines as used in internet? Give two examples of search engines in the market
today. [4 Marks]
(c)Explain the following functions as used in spreadsheet. Give examples of each
(i) TODAY() [2 Marks]
(ii) AVERAGE() [2 Marks]
(iii) COUNTIF() [2 Marks]
(iv) COUNTA() [2 Marks]
(d) Discuss the use of power point presentation in the current times. [2 Marks]
QUESTION FOUR
(a)Explain what you understand by the term e-mail program. Give any two e-mail programs that are
currently in use today. [3 Marks]
(b)Outline five components of access database. [5 Marks]
(c)Explain any six data types you may use in a Microsoft Access table. [6 Marks]
(d)Describe the following
i) Access time
ii) Seek time
iii) Transfer rate [6 Marks]
QUESTION FIVE
(a) Fill the following table. Show all your workings.
[12 Marks]
(b) List any two word processors other than MS Word [2 Marks]
(c) Describe any three functions of control panel in Ms-Windows [3 Marks]
(d) What do you understand by System Components? With a well-labeled diagram, show the
relationship between these components. [3 Marks]
