UNIVERSITY EXAMINATIONS: 2011/2012
FIRST YEAR EXAMINATION FOR THE BACHELOR OF SCIENCE
IN INFORMATION TECHNOLOGY
BIT 1109 COMPUTER ORGANIZATION & APPLICATIONS
DATE: AUGUST, 2012 TIME: 2 HOURS
INSTRUCTIONS: Answer Question ONE and any other TWO
QUESTION ONE
a) 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]
b) Explain the meaning of the following MS-DOS commands:
i. FC MARY.TXT JOHN.ABC [2 Marks]
ii. MD PETER [2 Marks]
iii. DEL C:\JANE \*.EXE [2 Marks]
iv. FORMAT A:/S /Q [2 Marks]
c) i. Define a spread sheet [1 Mark]
ii. Give TWO functions of any Spread sheet [2 Marks]
iii. State three examples of spread sheet [3 Marks]
d) Differentiate between the following
i. LAN and WAN [2 Marks]
ii. Bit and Byte [2 Marks]
iii. Application Software and System Software [2 Marks]
iv. Hardcopy and Softcopy [2 Marks]
QUESTION TWO
a) Discuss with relevant examples, the following numbering systems:
i. Binary [2 Marks]
ii. Octal [2 Marks]
iii. Decimal [2 Marks]
iv. Hexadecimal [2 Marks]
b) Describe any five functions of control panel in Ms-Windows [5 Marks]
c) With the help of a well-labeled diagram, Discuss Von Neumann computer
architecture. [7 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. SUM() [2 Marks]
ii. PMT() [2 Marks]
iii. MIN() [2 Marks]
iv. TODAY() [2 Marks]
d) Discuss any two uses 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) Discuss and give an example of the following storage devices
i. Sequential / Serial access
ii. Direct / Random access
[2 Marks]
b) What are the different types of Secondary storage media? [2 Marks]
c) Explain the term Primary Storage [2 Marks]
d) Distinguish Between Volatile and Non-Volatile memory [2 Marks]
e) Identify and explain the functions of any two system utility programs [2 Marks]
f) 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]
g) Explain the function of the following features/tools in word Processing
i. Replace
ii. Frames
[2 Marks]
