UNIVERSITY EXAMINATIONS: 2012/2013
FIRST YEAR EXAMINATION FOR THE BACHELOR OF SCIENCE
IN INFORMATION TECHNOLOGY
BIT 1109 COMPUTER ORGANIZATION & APPLICATIONS
DATE: DECEMBER, 2012 TIME: 2 HOURS
INSTRUCTIONS: Answer Question ONE and any other TWO
QUESTION ONE
a) Differentiate between the following
i) PROM and EPROM [2 Marks]
ii) Bit and Byte [2 Marks]
iii) System Software and utility software [2 Marks]
iv) Flatbed and handheld scanners [2 Marks]
b) i) Give any Three functions of any Operating system [3 Marks]
ii) State three examples of Operating Systems [3 Marks]
c) 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]
d) i) Explain the meaning of the internal and external MS-DOS commands
[2 Marks]
ii) Give three examples of each from d(i) above [6 Marks]
QUESTION TWO
a) Explain the meaning of the following terms as pertains to storage devices
i) Primary storage
ii) Secondary storage
[2 Marks]
b) i) Discuss any two types of Secondary storage media in the market today.
[2 Marks]
ii) Distinguish Between Volatile and Non-Volatile memory [4 Marks]
iii) Identify and explain any two functions of BIOS in your computer
[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 [2 Marks]
i) Replace
ii) Mail merge
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) PMT() [2 Marks]
d) Discuss the use of power point presentation in the current times. [2 Marks]
QUESTION FOUR
a) Discuss any three publishing 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 [6 Marks]
i) Access time
ii) Seek time
iii) Transfer rate
QUESTION FIVE
a) Discuss any three Ms-windows accessories [6 Marks]
b) List any two word processors other than Ms-Word clearly why they are not in use
today [4 Marks]
c) Describe any three functions of control panel in Ms-Windows [3 Marks]
d) What do you understand by Von Neumann computer architecture? With a welllabeled diagram, show the relationship between these components. [7 Marks]
