A1-R3: IT TOOLS AND APPLICATIONS : JULY 2003
NOTE:
1. There are TWO PARTS in this Module/paper. PART ONE contains FOUR questions and PART TWO contains FOUR questions.
2. PART ONE is to be answered in the TEAR-OFFANSWER SHEET only, attached to the question paper, as per the instructions contained therein. PART ONE is NOT to be answered in the answer book.
3. Maximum time allotted for PART ONE is ONE HOUR. Answer book for PART TWO will be supplied at the table when the answer sheet for PART ONE is returned. However, candidates who complete PART ONE earlier than one hour, can collect the answer book for PART TWO immediately after handing over the answer sheet for PART ONE.
TOTAL TIME: 3 HOURS TOTAL MARKS: 100
(PART ONE-40; PART TWO – 60)
PART ONE
(Answer all the questions)
1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1 x 10)
1.1 A computerized Hotel Management system
A) Is primarily for the benefit of the Hotel staff
B) Is primarily for the benefit and convenience of the Guests checking into the hotel.
C) Benefits both the Hotel Staff and Guests checking in.
D) Is neither beneficial for the Hotel Staff nor Guests.
1.2 Software designed for a specific purpose is called as
A) System software
B) Compiler
C) Specific software
D) Application software
1.3 One of the following is not an Output device:
A) Plotter
B) Speech synthesizer
C) MICR
D) Smart and intelligent terminal
1.4 RAM means
A) Random Access memory
B) Read Also Memory
C) Read Access Memory
D) Random Also Memory
1.5 The name of the desktop icon that opens a window displaying information about your system’s disk drives and also special system folders such as the Printer folder and the Control panel
A) our Computer
B) Recycle Bin
C) Network Neighborhood
D) Internet Explorer
1.6 The definition of Multimedia does not include
A) Animation
B) Graphics
C) Multimedia Projector
D) Text
1.7 One of the following is not a high level language
A) C++
B) FORTRAN
C) BASIC
D) ASSEMBLY
1.8 Which one of the following is not an Operating System
A) MS-DOS
B) COM
C) LINUX
D) MS-Windows
1.8 Which one of the following is a Secondary Storage Device
A) CD-ROM
B) RAM
C) ROM
D) OMR
1.10 One of the following is a Systems Tools in Windows
A) Notepad
B) Disk Defragmenter
C) Disk Fragmenter
D) Disk Operating System
2. Each statement below is either TRUE or FALSE. Choose the most appropriate one and ENTER in the “tear-off” sheet attached to the question paper, following instructions therein. (1 x 10).
2.1 In order to Quit Word, you will first click on File menu followed by click on the Close option.
2.2 Print Preview does not allow editing of the document.
2.3 A red wavy line points to those words in your document that possibly have an incorrect spelling.
2.4 In Mail Merge, the merge field names acts as placeholders, that is, they reserve a place for the data source.
2.5 In its default setting, a workbook is made up of 3 sheets and the number can be extended to 225 sheets.
2.6 The formulas in Excel are made up of arithmetic operators and functions.
2.7 Pie charts show the relationship of parts as applied to the total values whereas area and line charts are best for showing the amount of change in values over time.
2.8 When you link data maintained in an Excel workbook to a Word document, it contains a copy of the actual data.
2.9 While presenting through PowerPoint, you will present using the Slide View.
2.10 The technology used in Mobile Phones uses the integration of Information Technology and Telecom technologies.
3. Match words and phrases in column X with the closest related meaning/ word(s)/phrases in column Y. Enter your selection in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1 x 10)
X Y
3.1 Active cell A. It refers to an area on a worksheet, which is rectangular and contains two or more cells.
3.2 Legend B. It refers to a view that displays your document, as it will appear when you print it.
3.3 Range C. Default name of the document when Word is loaded.
3.4 XY Chart D. In this cell you can type new data or edit the data it contains.
3.5 Page Layout View E. It refers to a combination of one or more sources of text into a single document.
3.6 Mail Merge F. Graphics available in Power Point to be directly included into a presentation.
3.7 Soft page breaks G. It is two-dimensional and has numeric values plotted along both axes.
3.8 Document1 H. It lists each pattern or symbol that is used as a marker in a chart, followed by the corresponding data series or category name.
3.9 ClipArt Gallery I. Helps PowerPoint slides to be rearranged for a presentation.
3.10 Slide sorter J. First sheet in Excel.
K. To apply preset animation in Power Point
L. Automatically included by Word when a page ends.
4. Each statement below has blank space to fit one of the word(s) or phrases in the list below. Enter your choice in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1 x 10)
A. Recycle Bin B. Folder
C. Modem D. Headers and Footers
E. Speaker's Notes F. Thesaurus
G. Function H. Operating System
I. our Documents J. Absolute
K. AutoContent Wizard L. Relative
4.1 An organized collection of software that controls the overall operations of a computer is called as _________.
4.2 A _________ is a device used to connect a personal computer with a telephone line, so that the computer can be used to access Internet or communicate with other computers.
4.3 _________ is an icon on the desktop that represents a temporary holding place for files to be deleted.
4.4 In Windows you will store all your files in a _________.
4.5 _________ normally carry the information like page numbers, dates, company names etc.
4.6 If you make use of _________, it will provide list of related words and different form of selected word.
4.7 To change the cell reference C4:C9 to an _________ row and column reference, you would enter it as $C$4:$C$9.
4.8 A _________ in Excel is a ready-made formula.
4.9 _________ provide presenter with a page that corresponds to each slide and contains a small image of the slide along with additional notes.
4.10 _________ is the easiest place to start creating a presentation if you are new to PowerPoint software. For more questions papers visit www.doeacconline.com
PART TWO
(Answer ALL questions)
5. Answer any five of the following:
a) What is multimedia?
b) Write four areas where Information Technology has made benefits to our society.
c) What are Internal commands in DOS? Name any four Internal DOS commands.
d) Write the names of any four input devices used in computers.
e) Linux has been developed as a cooperative effort over Internet. Comment on this statement.
f) Write the steps that will disable the Recycle Bin and directly delete files and folders with no opportunity to restore them.
(2x5)
6. Answer any three from the following:
a) What is a range in Excel? What does naming a range mean? What is the process of creating them?
b) There are three ways to view and edit your presentation. Describe each one of them briefly.
c) Describe the Mail merge operation in Microsoft Word. What is Mail Merge Helper? What are the steps involved in its usage?
d) What are the points to be kept in mind while creating a Presentation?
(5x3)
7. Answer any three from the following:
a) In Linux, how does the script know what shell it should use?
b) Name any four procedural programming languages mentioning the application area where each is being generally used.
c) In Microsoft Excel, when you are dealing with large volumes of numbers, representing data via charts is advantageous. Support this statement with your viewpoint.
d) Convert the following numbers:
i) Binary 110101 into Decimal Number.
ii) Decimal 25 into Binary Number.
(5x3)
8.
a) Distinguish between impact and non-impact printers. Categorize dot matrix printer, daisy wheel printer, thermal printer and inkjet printer as impact or non-impact printer.
b) Explain the startup process for a personal computer. What is the difference between stand-alone operating systems and network operating systems?
c) Differentiate between multiprogramming and time-sharing.
d) What is a page break? What are soft and hard page breaks?
e) How do you change the number formats in Microsoft Excel?
(6+6+4+2+2)
