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:2012
1
a. State two examples of icons found in each of the following and state their usefulness: i. Formatting tool bar (1 Mark) ii. Mail merge tool bar (1 Mark) b. State two factors to consider when choosing an application software. (1 Mark) c. Explain three types of database operations used in Microsoft excel. (3 Marks) d. Consider the data in the cells below entered in a worksheet as shown in table 1 below: Cell D13 D14 E20 E21 E22 Data 400 300 =D13*D14 Fruits =D14
i. Name the data type in the following cells ? D13 (1 Mark) ? E20 (1 Mark) ? E21 (1 Mark) ii. Give the value in cells ? E20 (1 Mark) ? E22 (1 Mark) e. Explain the contents of the files that are created in mail merge. (3 Marks) f. Explain two benefits which an organization may enjoy after automating their production system. (2 Marks)
2
g. Figure 1 below shows Microsoft Power window, name the parts labelled A to F. (3 Marks)
h. Explain the difference between animation effects and transition effects as used in Microsoft PowerPoint. (3 Marks) i. Define the following terms: i. HTML tags (1 Mark) ii. Internet protocols (1 Mark) iii. Information superhighway (1 Mark) j. Identify any three features of a web browser. State the usefulness of each of the features identified. (3 Marks) k. With the aid of illustration differentiate between landscape and portrait page orientation. (2 Marks)
QUESTION TWO – 20 MARKS
a. Describe two distinct ways in which you can create a PowerPoint presentation. (3 Marks) b. A student would like to view the synonyms of an English word in a document. Outline the steps to follow to achieve this. (3 Marks) c. In relation to Ms Excel 2003, define the following: (4 Marks) i. Workbook ii. Graphs iii. Freezing iv. Logic Operations d. The following is a list of students and the marks they scored in the various subjects as recorded in a worksheet as shown in table 2 below. A B C D E 1 Names Biology History English Computer 2 John 57 78 60 50 3 Yusuf 49 75 50 70 4 Baraka 60 63 56 74 5 Kirimi 71 61 69 63 6 George 40 60 49 60
3
i. Write a formula to calculate the following ? Total marks for all students doing Biology (1 Mark) ? Least score for Baraka (1 Mark) ? The highest score in History (2 Marks) ii. Write a formula to count all the computer students with marks less than 70. (2 Marks)
e. Describe four character case options available in a word processor. (4 Marks)
QUESTION THREE – 20 MARKS
a. List any two components needed for internet connection and explain their relevance. (2 Marks) b. Identify and describe three parts of an e-mail address. (3 Marks) c. In formatting a PowerPoint slide, what do you understand by promotion and demotion of text? (2 Marks) d. Define the following terms as applied in Microsoft PowerPoint and briefly describe the usefulness of each of them: i. Speaker notes ii. Slide sorter view e. Identify any three elements of a good power presentation. Briefly explain each of those attributes. (3 Marks) f. State any four services provided by the internet. Briefly explain any two of them. (3 Marks) g. Identify three types of view in Microsoft PowerPoint and define each of them. (3 Marks)
QUESTION FOUR – 20 MARKS
a. Prepare an html document with the following attributes: (5 Marks) ? Title - “MY HTML” ? Head1 – “HTML is easy to Learn” ? First paragraph – “Welcome to the world of HTML. This is the first paragraph. While short it is still a paragraph!” ? Second paragraph – “And this is the second paragraph.” b. Describe the following terms as used in electronic spreadsheet. (5 Marks) i. Automatic recalculation ii. Data range iii. Cell reference iv. Database v. Data series c. Give four advantages of the electronic spreadsheet over the manual spreadsheet. (4 Marks) d. Explain how you can automatically find all the occurrences of the word “Kenya” and replace it with “My country” in a Microsoft word document. (3 Marks) e. Mention two disadvantages of using a word processor. (1 Mark) f. What do you understand by the term indentation? Briefly describe two types of indentation. (2 Marks)
4
QUESTION FIVE – 20 MARKS
a. Define the following terms as used with internet technology: i. Hypertext (1 Mark) ii. Hyperlink (1 Mark) iii. URL (1 Mark) iv. Webpage (1 Mark) b. Differentiate between a web browser and a search engine. Mention any two examples of each. (3 Marks) c. Mention two benefits of mail merging. (1 Mark) d. Identify and explain any two negative effects of internet to the society today. (2 Marks) e. Differentiate between footnotes and footers; describe the steps you would follow to make use of them in a word document. (3 Marks) f. Define the following as applied in Microsoft PowerPoint: i. Labels ii. Placeholders iii. Style checker g. Explain how spreadsheets can be used in the following areas: i. Statistical analysis (2 Marks) ii. Data management (2 Marks)
More Question Papers