Get premium membership and access revision papers, questions with answers as well as video lessons.

Got a question or eager to learn? Discover limitless learning on WhatsApp now - Start Now!

Computer Application Software (Day) Question Paper

Computer Application Software (Day)

Course:Bachelor Of Commerce

Institution: Kca University question papers

Exam Year:2011

1
UNIVERSITY EXAMINATIONS: 2010/2011
FIRST YEAR EXAMINATION FOR THE DEGREE OF BACHELOR OF
COMMERCE
CMS 103: COMPUTER APPLICATION SOFTWARE (DAY)
DATE: AUGUST 2011 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
Question One
a) Differentiate between the following terms
i) Computer vs Computer system (2 Marks)
ii) Computer architecture vs Computer Organization (2 Marks)
b) Discuss the applicability of the functionalities provided with the following software in an office
environment
i) Word processors (4 Marks)
ii) Spreadsheets (4 Marks)
iii) Database management systems (4 Marks)
c) State the use of the following application softwares
i) Internet explorer (1 Mark)
ii) Excel (1 Mark)
iii)PageMaker (1 Mark)
iv)AutoCAD (1 Mark)
2
d) Discuss the contribution made by office automation systems in end user computing (10 Marks)
Question Two
a) Explain the term non printing characters (2 Marks)
b) How will you view the non printing characters (2 Marks)
c) Using relevant examples differentiate between Insert and Overtype (4 Marks)
d) Explain how you would bold text with the ribbon (4 Marks)
e) The tabs will align your text in relation to a specific position on the horizontal ruler.
Outline any four types of tabs in word (4 Marks)
f) Outline any four uses of a text box (4 Marks)
Question Three
A) Outline the procedure of producing the worksheet (6 Marks)
i) Explain the concepts of headers and footers as used in excel (4 Marks)
ii)Give the steps of changing the chart type from a column chart to a bar chart (4 Marks)
Question Four
a) What is a Datasheet in access? (2 Marks)
3
b) Explain how you would create A blank database (4 Marks)
c) What is the meaning of the term primary key (2 Marks)
d) Explain using examples the importance of understanding data types in ms access (4 Marks)
e) Substantiate with appropriate examples how one-to-one differ from one-to-many relationship
(4 Marks)
f) Show how you would create a ms access query (4 Marks)
Question Five
a) Differentiate between the following set of terms
i.Header & Footer. (2 Marks)
ii.Cut & copy. (2 Marks)
iii.Superscript & Subscript. (2 Marks)
iv.Drop cap & Title case. (2 Marks)
v.Save & save as. (2 Marks)
b) To determine the students who qualify to go for a tour, the school’s management has decided that
any of the following conditions should be met:
Conditions
Mathematics...............................> 85
Age..........................................>=18
Average ...................................>= 60
If ANY of the conditions is met, it should return the Granted; however, failure on ALL should return
Denied.
(Assuming Mathematics is in Cell C3, Age is in Cell A3 and Average is in Cell G3)
Write a formula or function that will check the above conditions (6 Marks)
c) Define the term spreadsheet (2 Marks)
d) State four objects that you can create using MS Access (4 Marks)

Computer Application Software (Day) Question Paper

More Question Papers

Popular Exams