Bit2103:Introduction To Computer Applications Question Paper
Bit2103:Introduction To Computer Applications
Course:Bachelor Of Information Technology
Institution: Meru University Of Science And Technology question papers
Exam Year:2010
(a) Outline the advantages and disadvantages of developing pre-packaged software. (6 Marks) (b) Compare and contrast Manual and electronic spreadsheets. (4 Marks) (c) What is the role of the following features in Microsoft word? (i) Word wrap (ii) Auto text (iii) Thesaurus (iv) Drop cap (v) Type over mode (vi) Word art (6 Marks) (d) Identify five advantages of document creation with Ms Word as compared to a conventional typewriter. (5 Marks) (e) Differentiate between the following terms as used in Microsoft word: (i) Copy – paste and Cut – Paste (ii) Save and Save As (2 Marks) (f) Describe the startup process for a personal computer. (3 Marks) (g) The windows operating system has a number of options that assist in operations. Explain the functions of the following options: (i) Programs (ii) Documents (iii)Find
(iv) Help (4 Marks)
QUESTION TWO – (20 MARKS)
(a) Distinguish between the following terms as used in Microsoft PowerPoint: (i) Slide Master and Notes Master (ii) Slide sorter and slide show. (4 Marks) (b) Explain by giving the key features of the following application software packages. (i) Word processing software (ii) Spreadsheet software (iii)Database management software. (6 Marks) (c) A company uses Excel to store salary information. Explain how you can accomplish the following using the sheet provided below.
Name Gross Salary Tax Net Salary
Abel 32500 Alex 25,000 Cathy 30000 Steve 75000 Edward 90000 Dave 45000 Carol 45000 Frank 90000
(i) The above records in ascending order by making use of the NAME column. (2 Marks) (ii) Explain how you can filter those records having names with „A?. (3 Marks) (iii)Explain how you can draw a bar graph to represent your data. (3 Marks) (iv) Explain how you can format your values in comma style and in two decimal points. (2 Marks)
QUESTION THREE – (20 MARKS)
(a) Define the following terms as used in Microsoft Excel: (i) Range (ii) Workbook (iii)Cell (iv) Worksheet (4 Marks) (b) Distinguish between the following terms as used in Microsoft Excel: (i) Absolute referencing and Relative referencing
(ii) Sorting and filtering (4 Marks) (c) How do you format the worksheet to have all the currency values in two decimal places and to be preceded by the symbol SR (South African Rand) (2 Marks) (d) Explain how you can perform the following tasks in Microsoft word: (i) Design a table having six columns and ten rows (ii) Apply tests effects to selected data. (4 Marks) (e) What are the main steps required to mail merge a document. (6 Marks)
QUESTION FOUR - (20 MARKS)
(a) Using Microsoft Word Application to represent information, how do you include the following features? (i) A page border (ii) Use the Auto text feature for the title and name of the author. (iii)Type the text and format into THREE columns. (iv) Use the text box feature to produce the caption with a black background. (6 Marks) (b) Differentiate between the following terms as used in word processing. (i) Header and Title (ii) Footnotes and footer (4 Marks) (c) Explain how you can automatically find all the occurrences of the word “application? and replace it with the word “program” which is bold, blue, 17 and underlined in a Microsoft word document. (3 Marks) (d) What is a slide transition? How do you set the slide transitions (4 Marks) (e) Distinguish between hardware and software with appropriate examples. (3 Marks)
QUESTION FIVE – (20 MARKS)
(a) Give three examples of Windows Utility Programs and their functions. (4 Marks) (b) Explain four cell data types as used in Spreadsheets. (4 Marks) (c) Using examples distinguish between formulas and functions as used in Microsoft Excel (3 Marks) (d) Name and discuss five toolbars in Ms Excel (5 Marks) (e) Name the parts indicated by alphabets on the following chart. (4 Marks)
Expenditure Amounts
0 5 10 15 20 25 30 35
Food Gas Motel Categories
Amounts
Jan Feb Mar Apr May Jun
A
E
F
C D
B
More Question Papers