A1-R3: IT TOOLS AND APPLICATIONS 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-OFF ANSWER SHEET only, attached to the question paper, as per the instructions contained therein. PART ONE is NOT to be answered in the answer book.
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) 3.
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
A1-R3
Page 1 of 6
JULY, 2003
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) My 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
A1-R3
Page 2 of 6
JULY, 2003
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 2.2 2.3
In order to Quit Word, you will first click on File menu followed by click on the Close option. Print Preview does not allow editing of the document. A red wavy line points to those words in your document that possibly have an incorrect spelling. In Mail Merge, the merge field names acts as placeholders, that is, they reserve a place for the data source. In its default setting, a workbook is made up of 3 sheets and the number can be extended to 225 sheets. The formulas in Excel are made up of arithmetic operators and functions. 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. When you link data maintained in an Excel workbook to a Word document, it contains a copy of the actual data. While presenting through PowerPoint, you will present using the Slide View. The technology used in Mobile Phones uses the integration of Information Technology and Telecom technologies.
2.4 2.5 2.6 2.7 2.8 2.9 2.10
A1-R3
Page 3 of 6
JULY, 2003
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)
3.1
X Active cell
A.
3.2
Legend
B.
3.3
Range
C.
3.4
XY Chart
D.
3.5
Page Layout View
E.
3.6
Mail Merge
F.
3.7
Soft page breaks
G.
3.8
Document1
H.
3.9
ClipArt Gallery
I.
3.10
Slide sorter
J. K. L.
A1-R3
Y It refers to an area on a worksheet, which is rectangular and contains two or more cells. It refers to a view that displays your document, as it will appear when you print it. Default name of the document when Word is loaded. In this cell you can type new data or edit the data it contains. It refers to a combination of one or more sources of text into a single document. Graphics available in Power Point to be directly included into a presentation. It is two-dimensional and has numeric values plotted along both axes. It lists each pattern or symbol that is used as a marker in a chart, followed by the corresponding data series or category name. Helps PowerPoint slides to be rearranged for a presentation. First sheet in Excel. To apply preset animation in Power Point Automatically included by Word when a page ends.
Page 4 of 6
JULY, 2003
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. C. E. G. I. K.
4.1 4.2 4.3 4.4 4.5 4.6 4.7 4.8 4.9 4.10
A1-R3
Recycle Bin Modem Speaker's Notes Function My Documents AutoContent Wizard
B. D. F. H. J. L.
Folder Headers and Footers Thesaurus Operating System Absolute Relative
An organized collection of software that controls the overall operations of a computer is called as _________. 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. _________ is an icon on the desktop that represents a temporary holding place for files to be deleted. In Windows you will store all your files in a _________. _________ normally carry the information like page numbers, dates, company names etc. If you make use of _________, it will provide list of related words and different form of selected word. To change the cell reference C4:C9 to an _________ row and column reference, you would enter it as $C$4:$C$9. A _________ in Excel is a ready-made formula. _________ provide presenter with a page that corresponds to each slide and contains a small image of the slide along with additional notes. _________ is the easiest place to start creating a presentation if you are new to PowerPoint software.
Page 5 of 6
JULY, 2003
PART TWO (Answer ALL questions) 5. a) b) c) d) e) f)
Answer any five of the following: What is multimedia? Write four areas where Information Technology has made benefits to our society. What are Internal commands in DOS? Name any four Internal DOS commands. Write the names of any four input devices used in computers. Linux has been developed as a cooperative effort over Internet. Comment on this statement. Write the steps that will disable the Recycle Bin and directly delete files and folders with no opportunity to restore them. (2x5)
6. a)
Answer any three from the following: What is a range in Excel? What does naming a range mean? What is the process of creating them? There are three ways to view and edit your presentation. Describe each one of them briefly. Describe the Mail merge operation in Microsoft Word. What is Mail Merge Helper? What are the steps involved in its usage? What are the points to be kept in mind while creating a Presentation? (5x3)
b) c) d) 7. a) b) c) d)
8. a) b) c) d) e)
A1-R3
Answer any three from the following: In Linux, how does the script know what shell it should use? Name any four procedural programming languages mentioning the application area where each is being generally used. In Microsoft Excel, when you are dealing with large volumes of numbers, representing data via charts is advantageous. Support this statement with your viewpoint. Convert the following numbers: i) Binary 110101 into Decimal Number. ii) Decimal 25 into Binary Number. (5x3) 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. Explain the startup process for a personal computer. What is the difference between standalone operating systems and network operating systems? Differentiate between multiprogramming and time-sharing. What is a page break? What are soft and hard page breaks? How do you change the number formats in Microsoft Excel? (6+6+4+2+2)
Page 6 of 6
JULY, 2003
A1-R3: IT TOOLS AND APPLICATIONS 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.
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) 3.
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
Which of the following is a utility that rearranges your discontiguous files and free space on your computer so that your files are stored in contiguous units and free space is consolidated in one contiguous block? A) degaussing B) patch C) defragmenter D) logical block addressing
1.2
Which of the following is the program your personal computer uses to get the computer system started after you turn it on? A) boot B) source code C) initialization D) BIOS
1.3
Which of the following is NOT a mouse technique commonly used in Windows? A) lifting B) dragging C) double-clicking D) clicking
1.4
Which of the following charts is not likely to be included in an analysis or presentation graphics package? A) Bar B) Pie C) Temperature D) Line
A1-R3
Page 1 of 5
JANUARY, 2004
1.5
You need to know the Order of Operations especially when entering complicated formulae. The order is: A) Add, Subtract, Multiply, Divide, Brackets, Exponents B) Exponents, Multiply, Divide, Brackets, Subtract, Add C) Brackets, Exponents, Divide, Multiply, Add, Subtract D) Subtract, Add, Multiply, Divide, Exponents, Brackets
1.6
Which is the best definition for a software package? A) An add-on for your computer such as additional memory B) A set of computer programs used for a certain function such as word processing C) A cushion you can buy for a computer to protect it D) The box, manual and license agreement that accompany commercial software
1.7
One of the following is not an Output device: A) Plotter B) Speech synthesizer C) MICR D) Smart and intelligent terminal
1.8
If text was highlighted and “Edit” “Copy” was clicked, what would happen? A) Text would be copied from the document and placed in clipboard B) Text would be removed from the document and placed in clipboard C) Text from clipboard would be placed in the document at the place where the cursor was blinking D) None of the above
1.9
RAM means A) Random Access memory B) Read Also Memory C) Read Access Memory D) Random Also Memory
1.10
A program that works like a calculator for keeping track of money and making budgets. A) Calculator B) Scholastic C) Keyboard D) Spreadsheet
A1-R3
Page 2 of 5
JANUARY, 2004
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 2.2
An assembly language is a third generation high level language. In order to Quit MS-Word, you will first click on File menu followed by click on the Close option. You can delete files be dragging them to he Recycle Bin on the desktop. Word processors can easily support the use of graphics. Pie chars show the relationship o parts to a whole area whereas line charts are best for showing the amount of change in values over time. C++ is an example of database management system. Three types of data can be entered into a spreadsheet. They are values, labels and formulas. In its default setting, a workbook is made up of 3 sheets and the number can be extended to 255 sheets While presenting through PowerPoint, you will present using the Slide View. In the “Print Preview”, mouse pointer changes to magnifying glass.
2.3 2.4 2.5 2.6 2.7 2.8 2.9 2.10 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)
3.1
X Cut
A.
3.2 3.3
Scanner X-Windows
B. C.
3.4 3.5
Slide sorter Interface
D. E.
3.6 3.7 3.8 3.9
Multimedia Peripheral Boot start Design Template
F. G. H. I.
3.10
Legend
J.
A1-R3
Y Point of connection between two programmes or pieces of equipment GUI for UNIX This command removes information from a file and places it on the Clipboard It is an input device. It lists each pattern or symbol that is used as a market in a chart, followed by the corresponding data series or category name. Loading the operating system Movement from one slide to another Ready made slide backgrounds A program that personal computer uses to get the computer system started after you turn it on. Hardware devices that are not part of the main computer system and are often added later to the system
K.
Using IT to create a presentation through the seamless integration of alternative information formats is called
L.
Helps PowerPoint slides to be rearranged for a presentation.
Page 3 of 5
JANUARY, 2004
4.
A. D. G. J.
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) Active cell Multiprocessing Operating system My documents
4.1
B. E. H. K.
Byte Multiprogramming Icon Range
C. F. I. L.
Modern Application software Desktop Clip Art
A small graphic image that represents an application, command or a tool is called as _________.
4.2
The screen background and main area of Windows is called as _________ where you can open and manage files and programs.
4.3
MS-Word offers a wide collection of _________ graphics that you can insert in documents and then suit your needs.
4.4
_________ is used to measures computer memory which is equals to eight bits.
4.5
A general operating system related technique that allows two or more programs to execute concurrently on the same computer is called _________.
4.6
_________ is the coordinated processing of programs by more than one computer processor.
4.7
_________ refers to an area on a worksheet, which is rectangular and contains two or more cells.
4.8
_________ is the area you can type new data or edit the data it contains.
4.9
An organized collection of software that controls the overall operations of a computer is called as _________.
4.10
A(n) _________ 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.
A1-R3
Page 4 of 5
JANUARY, 2004
PART TWO (Answer ALL questions) 5. a) b) c) d) e) f)
Answer any five of the following: Name any four operating systems commonly used in personal computers. Describe the function of Taskbar in Windows. Briefly describe the template document called Normal. Describe briefly, what is a table in Microsoft Word and what are its parts? List the differences between an embedded chart and a chart sheet in Microsoft Excel. Describe the process of adding and deleting a slide in a PowerPoint presentation. (2 x 5)
6. a) b) c) d)
7. a) b) c) d)
8. a) b)
c)
d) e)
A1-R3
Answer any three from the following: Explain the difference between Relative and Absolute referencing. How can you convert Relative reference into Absolute reference in Microsoft Excel? What are Headers and Footers? When will you require adjusting margins and hyphenating your document? To select an entire document Microsoft Word offers three ways. Describe each one of them. Describe the Mail Merge operation in Microsoft Word. What is Mail Merge Helper? What are the steps involved in its usage? (5 x 3) Answer any three from the following: Write a brief note on need for computer and system literacy. What is a computer virus? What is the remedy available for computer viruses? How does it differ from a bug? What is Linux’s Open-Source License? What platforms does Linux support? Define the following terms with respect to a computer: i) Firmware ii) Information iii) Sub-routine (5 x 3) What is an operating System? Explain four major functions performed by it. Discuss the purpose of the following utilities: i) file viewer ii) diagnostic iii) uninstaller iv) screen saver Write briefly about the following DOS commands: i) XCOPY ii) VER iii) ATTRIB What is word-wrap? Write the names of any four secondary storage devices. ([2+4]+[1.5x4]+[1+1+2]+2+2)
Page 5 of 5
JANUARY, 2004
A1-R3: IT TOOLS AND APPLICATIONS 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.
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) 3.
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) B) C) D)
A language translator is best described as: an application software a system software a hardware component an operating system
1.2 A) B) C) D)
A Floppy Disk is organized as Tracks Sectors Tracks and Sectors Heads and Sectors
1.3 A) B) C) D)
Optical storage technique is used in Floppy Disk Drive Hard Disk Drive Magnetic Disk Drive CD-ROM Drive
1.4 A) B) C) D)
Which one of the following is not an internal DOS command? RD TIME FORMAT TYPE
A1-R3
Page 6 of 5
JANUARY, 2004
1.5 A) B) C) D)
The errors that can be pointed out by the compiler are Syntax errors Semantics errors Logical errors None of the above
1.6 A) B) C) D)
Address of the first cell in a worksheet is: 1 A A1 1A
1.7 A) B) C) D)
Windows is popular because of itsGUI Features Multitasking capacity Desktop Technology Because it is inexpensive
1.8 A) B) C) D)
Which of the following is not a text function in MS-Excel? CHAR() LEN() VAR() ABS()
1.9 A) B) C) D)
1 Kilo Bits is 1000 bits 1024 bits 512 bits 1048 bits
1.10
After a table has been created, in MS-WORD, which of the following operations cannot be performed? Insert rows in a table Delete and insert columns Split the table into two tables None of the above
A) B) C) D)
A1-R3
Page 7 of 5
JANUARY, 2004
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 Railway Ticket Reservation System is not an on-line processing system. 2.2 DIR and DIRECTORY are similar commands. 2.3 Computer software is normally classified as system software and application software. 2.4 To check spellings of the text in a worksheet, in MS-Excel, we need to take the help of a word processor. 2.5 LINUX is a multi-user, time-sharing system. 2.6 It is necessary to load MS-DOS first before running MS-WINDOWS. 2.7 Index holes in a floppy are meant of indexing files. 2.8 Without a mouse one cannot work with MS-WINDOWS. 2.9 ^U selects the Italics style for the selected text in MS-WORD. 2.10 Partition Table is found in Hard Disks. 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
Courier
A.
Line Editor
3.2
Scanner
B.
Number of non-blank cells
3.3
TREE
C.
Interpreter
3.4
NOW( )
D.
Mail Merge
3.5
COUNT( )
E.
Measure of Microprocessor Speed
3.6
PRINT
F.
Font
3.7
Main Document
G.
Alt + F4
3.8
Executing Instructions Line by Line
H.
Alt + F6
A1-R3
Page 8 of 5
JANUARY, 2004
3.9
Megahertz
I.
An input device
3.10 To Quit Windows
J.
Current Date/Time
K.
Directory Structure
L.
An External Command
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.
Laser
B. Ctrl + X
D. G. J. M. P.
Hard Password Title Bar CLS High Level
E. H. K. N.
4.1
Soft Assembly CHKDSK Ctrl + C
C. File F. I. L. O.
Scandisk Dot Matrix Magnetic Tape Virus
When WORD automatically starts a new page, this page break is called the ______________ page break.
4.2
The ______________ command can be used to correct the file system.
4.3
For placing the prompt in the first line on screen, the DOS command is ________.
4.4
_________________ unit can be considered both as a secondary storage device and as an I/O device.
4.5
A worksheet can be protected with a ________________.
4.6
The _________________ printers are used for DTP applications.
4.7
The commands to open, close and print a worksheet are available under the ____________ menu.
A1-R3
Page 9 of 5
JANUARY, 2004
4.8
A assembler translates ______________ language programs into machine language.
4.9
The ___________ indicates the active document in WINDOWS.
4.10
_________ cuts the selected text and graphics and puts it in Clipboard.
PART TWO (Answer ALL questions) 5. a) b) c) d) e)
6. a) b) c) d) e) f)
A1-R3
Answer any four of the following: What are the External commands in DOS? How are they different from internal commands? Name any two External DOS commands. Describe the various operations that can be performed on a database in MS-EXCEL. What is the significance of accessories in Window Operating System? Describe in short about WORD PAD. How you can protect your documents in MS-WORD? Explain the procedure of protecting them. Perform the following Conversions: i) Convert (18)10 to Binary Number ii) Convert (110001)2 to Decimal Number (5 x4) Answer any five from the following: How you can delete files and folders permanently in Window Operating System? What is the use of AUTOEXEC.BAT file in DOS? Name any four secondary storage devices. Give two factors that make High Level Languages more advantageous than machine-level languages. What are basic characteristics of Formulas in MS-Excel? What is Animation? How is it different from Video? (2 x 5)
Page 10 of 5
JANUARY, 2004
7. a) b) c) d)
8. a) b) c) d)
A1-R3
Answer any three from the following: What is the aim of any Presentation? How you can make your Presentation effective? How you can check spellings in MS-WORD? What are the various options available to correct the wrong spellings? What are non-impact printers? Explain briefly any two of them. Describe the basic features of Functions in MS-Excel. Write functions for displaying Date and Time. (5 x 3) Answer any three from the following: Distinguish between: i) System software and Application software. ii) Compiler and Interpreter Explain the functions of an Operating System in a computer. What are Headers and Footers in MS-WORD? What are the advantages of using them? Describe in short about File Structure of LINUX. (5 x 3)
Page 11 of 5
JANUARY, 2004