Bit 2122:Structured Advanced Programming Question Paper
Bit 2122:Structured Advanced Programming
Course:Bachelor Of Information Technology
Institution: Meru University Of Science And Technology question papers
Exam Year:2011
1
a) Define the following terms i. Spreadsheets (1 Mark) ii. Word processor (1 Mark) iii. Assembly language (1 Mark) b) Distinguish between application software and system software. Give two examples of each type of software. (2 Marks) c) State four characteristics of good spreadsheets software. (2 Marks) d) Define the following terms as applied in Microsoft Word. i. Text animation (1 Mark) ii. Headers and footers (2 Marks) iii. Font formatting (1 Mark) e) Text – base line in Microsoft Word 2003 can be altered/shifted in two main ways. Identify the two commands for implementing this alteration and define each of them. (2 Marks) f) In relation to Ms Excel 2003, define the following i. Workbook. (1 Mark ii. Work sheet (1 Mark) iii. Cell reference (1 Mark) iv. Freezing (1 Mark) v. Filtering (1 Mark) g) Ms Excel 2003 has three main types of data that a user can enter in a worksheet, name them and give an example of each. ( 3 Marks) h) Differentiate between an operator and an operand as applied in Ms Excel. Give two examples of each. (2 Marks) i) Define the following keyboard shortcuts as applied in Ms Excel. i. Ctrl + Home (1 Mark)
2
ii. Ctrl + Arrow right (1 Mark) iii. Ctrl + Arrow down (1 Mark) iv. Ctrl + End (1 Mark) j) What is the role of the following features in Microsoft Word? i. Thesaurus (1 Mark) ii. Page setup (1 Mark) iii. Find and replace (1 Mark)
QUESTION TWO (20 MARKS)
a) i) What are the main steps required to mail merge a document. Briefly describe each step. (5 Marks) ii) Briefly illustrate the usefulness of mail merge. (3 Marks) b) Describe the procedure of labeling envelopes as applied in Ms Word 2003. (3 Marks) c) Define the following as applied in Ms Excel. i. Contiguous range of cells (1 Mark) ii. Non – contagious range of cells (1 Mark) d) What do you understand by the term indentation? Briefly describe two types of indentation. (4 Marks) e) Identify three advantages of creating a document using Microsoft Word as compared to a convectional typewriter. (3 Marks)
QUESTION THREE (20 MARKS)
a) Define the following worksheet functions as applied in Ms Excel. Using correct syntax give an example showing how to implement each of item. i. Average (2 Marks) ii. Sum (2 Marks) iii. Count (2 Marks) iv. Max (2 Marks) b) i) What do you understand by the term „formula containing a function?? (1 Mark) ii) Describe a process for entering/implementing a formula that contains a function. (3 Marks) c) State any four functions of spreadsheets. (4 Marks) d) Explain how you can automatically find all occurrences of the word “Africa” and replace it with “our continent” in a Microsoft Word document. (4 Marks)
3
QUESTION FOUR (20 MARKS)
a) Distinguish between arithmetic operators and relational operators as used in Microsoft Excel. (4 Marks) b) There are three types of cell referencing used when creating formulae and manipulating cell(s) content in Ms Excel. Identify them and discuss them briefly. (6 Marks) c) i) Define the term proofreading. (1 Mark) ii) Microsoft Word has proofing tools such as spelling and grammar checker and Thesaurus. Discuss the two tools and give the process you would follow to make use of each of them. (6 Marks) d) Define any three text alignment options available in Microsoft Word 2003. (3 Marks)
QUESTION FIVE (20 MARKS)
a) Differentiate between footnotes and endnotes, and describe the steps you would follow to make use of them in a word document. (4 Marks) b) Describe how you would implement the following using Microsoft Word. i. Design a table with ten rows and five columns. (2 Marks) ii. Insert an additional column between the fourth and fifth column created in b(i) above. (2 Marks) iii. Merge the cells in the first row into a single cell. (2 Marks) iv. Split the cell in the second row, first column. (2 Marks) c) Define the two commands for filtering data in Microsoft Excel. (2 Marks) d) Differentiate between the following terms as used in Microsoft Word. i. Copy – paste and cut – paste (1 Mark) ii. Save an save as (1 Mark) e) Describe the following commands in Ms Word 2003 i. Drop cap (2 Marks) ii. Print preview and page set up. (2 Marks)
More Question Papers