Get premium membership and access revision papers, questions with answers as well as video lessons.
Ins 111: Computer Applications Question Paper
Ins 111: Computer Applications
Course:Bachelor Of Science In Information Sciences
Institution: Moi University question papers
Exam Year:2013
MOI UNIVERSITY
SCHOOL OF INFORMATION SCIENCES
DEPARTMENT OF INFORMATION TECHNOLOGY
FIRST SEMESTER 2012/2013 ACADEMIC YEAR EXAMINATIONS
COURSE CODE: INS 111
COURSE TITLE: COMPUTER APPLICATIONS TIME: 2 Hrs 15 Mins
==============================================================================
INSTRUCTIONS TO CANDIDATES:
• Answer question 1 and any TWO questions
SECTION A: Compulsory
QUESTION ONE (20 MARKS) COMPULSORY
(Question 1-20 is 1 mark each)
1. ________ has the options for changing the page orientation.
A) Page setup
B) Insert
C) Review
D) Page layout
2. ________ controls the amount of space between each letter.
A) Toolbar
B) Character spacing
C) Drawing toolbar
D) Options spacing
3. Which one of the following is NOT a type of test alignment.
A) Center
B) Left
C) Edge
D) Right
4. Allows you to display hidden formatting characters.
A) Show/Hide
B) Display
C) Formatting Characters
D) Display Characters
5. What key on the keyboard can you push to activate overtype?
A) Insert
B) Alt
C) Shift
D) F5
6. Word wrap is ________
A) When a word is deleted because it is too long to fit on a line
B) When Word hyphenates a word at the end of a line
C) When Word determines if there is room for a word at the end of a line or if it must go on the next line
D) When the typist determines if there is room for a word at the end of a line or if it must go on the next line
7. What function offers you the possibility to view different results depending on the entered condition)
A) =If()
B) =Sum()
C) =SumIf()
D) =TrueFalse()
8. What key is used to select multiple ranges of cells in a spreadsheet?
A) Shift
B) Ctrl
C) Alt
D) AltCar or AltGr
9. What key should be used to change the content of a cell in a spreadsheet?
A) F1
B) F2
C) F3
D) F4
10. If you copy the formula =$B38 into another cell, the result will be:
A) The column part will remain the same
B) The row part will remain the same
C) Both the column and row will remain the same
D) Both will change
11. The arrow keys can be used to _____________
A) Delete text
B) Move the cursor in the text that has already been entered
C) Save the document
D) Move the cursor while deleting text
12. ____________ are pictures that illustrate the meaning of the text and make the document more attractive.
A) Diagrams
B) Clip art
C) Graphics
D) Charts
13. Screen scroll is used to
A) Add text to a document
B) Decrease the length of a page
C) Increase the length of a page
D) Bring hidden parts of a document into view
14. Changing the size of a form can easily br done by
A) Entering the Form Design View and resizing the form by placing the mouse over the edge and shaping the form
B) Entering the Form properties sheet and type in the new size of the form
C) Changing the size of the form in Form View by pulling on the edge of the form with the mouse
D) Editing the background image in the Form properties sheet
15. This database object displays data in a custom format. They are often easier to read than tables
A) Form
B) Field
C) Filter
D) Report
16. To have the Country or City field begin with a capital letter, the Input Mask could be set as
A) >LB) ???????????????
C) >0D) >917. Which of the following describes a relational database?
A) It provides a relationship between integers
B) It consists of separate tables of related data
C) It retrieves data related to its queries
D) It provides a relationship between floats
18. Which of the following best describes a queery?
A) A query enables people to enter or view data in your database easily
B) A query summarizes and prints dat
C) A query retrieves data that satisfies conditions that you set
D) Data
19. These are design templates that can be applied to an entire presentation that allows for consistency throughout the presentation
A) Designs
B) Styles
C) Themes
D) Templates
20. ___________ are effects that are in place when you switch from one slide to the next
A) Animations
B) Designs
C) Effects
D) Transitions
SECTION B: Choose ANY TWO QUESTIONS
QUESTION TWO (20 Marks)
1. Which key moves your cursor fromone cell to the next in a table?
A) Tab
B) Shift
C) Enter
D) Ctrl + Enter
2. Which keyboard shortcut centers selected text
A) Ctrl + C
B) Alt + C
C) Alt + E
D) Ctrl + E
3. Which keystroke will BEST take you to the end of a long document?
A) Ctrl + PageDown
B) Shift + End
C) Ctrl + End
D) The right scroll bar
4. In order to save a MS Word document as a web page you need to:
A) Put the appropriate graphics and links on the document
B) Save the document in simple text format
C) Use your web browser as an editor and save as URL
D) Save as HTML
5. The Hide/Show button found in the Standard Toolbar ___________
A) Creates s new paragraph
B) Displays or hides symbos for characters like spaces and tabs
C) Displays or hides the Standard Toolbar
D) Displays or hides the text just typed
6. Discuss mail merge in Microsoft Word giving a detailed step by step process of achieving it. (5 marks).
7. You are working on an assignment and one of the task is to draw an organization chart. Describe how you will achieve this in Microsoft Word. (5 marks)
8. You have been assigned the task of creating the timetable for the School of Information Sciences. The schedule runs five days a week and three sessions a day, two sessions in the morning and one on the afternoon. You are required to indicate the course units only in the slots. Discuss how you will achieve the following tasks: (5 marks)
A) Create the table
B) Fit the text contents to the cells
C) Merge cells
D) Modify borders of the cells
E) Change text direction for “break” and “lunch” sessions
QUESTION THREE
1. Describe how animation is achieved in Microsoft Powerpoint. (4 marks)
2. Name the role of transition in slides and explain how it is achieved. (2 marks)
3. Describe how you will achieve the following. (10n marks)
A) Insert a picture into the slide
B) Add background music
C) Change the background colour of all the slides
D) Change the layout of all the slides
E) Include a recorded narration for the slides
4. Describe how you can create a customized slide template. (4 marks)
QUESTION FOUR (20 MARKS) (Qn 1-11 = 1 mark each)
1. Formatting changes only the appearance of data, it does not affect the data itself.
A) True
B) False
2. When a worksheet is printed, the gridlines that surround the text are printed by default.
A) True
B) False
3. Once you hide a row, it remains hidden as long as the workbook is active.
A) True
B) False
4. If there are too many numbers after the decimal place displayed in a cell, creating a distraction from the data, you could make the data appear cleaner by:
A) Reenter all the numberws
B) Decrease the column width
C) Decrese the font size
D) Using the number group to decrease the nimber of digits displayed
5. As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears.
A) True
B) False
6. If you have data that runs across five columns, from clumn A to column E, one way to center a tite across the top of the data would be to:
A) Type the data in A1 and merge cells A1:A5
B) Type the data inA1 and merge cells A1:E1
C) Type the data in C1
D) Choose Center from the Format menu
7. If you have columns hat are truncating you content, but you cannot increase the width og the worksheet and be able to print on one page, a solution for making the text visible without losing data would be to:
A) Abbreviate all text
B) Reduce the font size to 8pt
C) Click Wrap text
D) Delete one column
8. The MOST efficient way yo format several cells with a specific font, number format, alignment and font colour would be to;
A) Use Format Painter
B) Format each element using the Toolbar
C) Select all and use the Formating dialog box
D) Apply a table style
E) Red and yellow
9. When you copy a range of cells, you must press the ____ key while you drag the selection to its new location.
10. A group of worksheet cells is called a _____
11. The ____ button quickly inserts Excel functions.
12. Compare ANY two chart types available in Excel. (2 marks)
13. Name the shortcut key combinations used for navigating (2 marks)
A) To the top of the Worksheet (cell A1)
B) To the end of a column.
14. Write formulas for the operations (i) – (iv) based on the spreadsheet given below along with the relevant cell address: (5 marks)
A B C D E F G
1 SNO Name INS111 INS112 INS113 Total Average
2 1001 Jackie 70 80 87 -- --
3 1002 Sam 90 98 89 -- --
4 1003 Juliet 90 90 98 -- --
5 1004 Fatma 60 76 79 -- --
6 1005 Carl 50 45 67 -- --
7 Max --
8 Min --
9 Total --
i. To calculate the Total Marks as sum of INS111, INS112 & INS113 for each student and display in column F
ii. To calculate the average marks for each student and display them in column G
iii. To calculate the highest marks in INS113 and display it in cell E7
iv. To calculate the total number of students appearing for the INS111 test and display it in cell C9
v. To calculate the lowest marks in INS112 and display them in cell D8
QUESTION FIVE (20 MARKS) (Qn 1-5 = 1 mark each)
1. Which one of the following is NOT a database model
A) Network database model
B) Relational database model
C) Object oriented database model
D) All are database models
2. Microsoft Access 2008 is a _____
A) RDBMS
B) OODBMS
C) ORDBMS
D) Network database model
3. What is the maximum length that a text field can be?
A) 120
B) 255
C) 265
D) 75
4. Which one of the following is NOT a database object?
A) Tables
B) Queries
C) Relationships
D) Reports
5. A ____ enables you to view data from a table based on a specific criterion
A) Form
B) Query
C) Macro
D) Report
6. Explain the following terminologies as used in MS Access 2007
A) Record (1 mark)
B) Attributes (1 mark)
C) Database (1 mark)
D) File (1 mark)
E) Relationship (1 mark)
7. Explain ANY two benefits og using a database over the traditional approach of storing information.
(2 marks)
8. The following is a snapshot of a local Hotel Database based in Nairobi: (3 marks)
Hotel (Hotel_No, Name, Address)
Room (Room_No, Hotel_No, Type, Price)
Booking (Hotel_No, Guest_No, Date_From, Date_To, Room_No)
Guest (Guest_No, Name, Address)
Required. Write an SQL query to display the following information. (5 marks)
A) List full details of all hotels
B) List all bookings for 6th March 2013
C) List the names and addresses of all guests from Nairobi, alphabetically ordered by name.
More Question Papers