DOEACC Society 2007 Advanced Level Course In Computer Science A1-R3: IT TOOLS AND APPLICATIONS - Question Paper

A1-R3: IT TOOLS AND APPLICATIONS

NOTE:
1. There are 2 PARTS in this Module/paper. PART 1 contains 4 ques. and PART 2 contains 4 ques..

2. PART 1 is to be answered in the TEAR-OFFANSWER SHEET only, attached to the ques. paper, as per the instructions contained therein. PART 1 is NOT to be answered in the ans book.

3. Maximum time allotted for PART 1 is 1 HOUR. ans book for PART 2 will be supplied at the table when the ans sheet for PART 1 is returned. However, candidates who complete PART 1 earlier than 1 hour, can collect the ans book for PART 2 immediately after handing over the ans sheet for PART ONE.
TOTAL TIME: three HOURS TOTAL MARKS: 100
(PART ONE-40; PART 2 – 60)

PART ONE
(Answer all the questions)

1. Each ques. beneath provide a multiple option of answers. select the most improper 1 and enter in the “tear-off” ans sheet attached to the ques. paper, subsequent instructions therein. (1 x 10)

1.1 A language translator is best defined as:
A) an application software
B) a system software
C) a hardware component
D) an operating system

1.2 A Floppy Disk is organized as
A) Tracks
B) Sectors
C) Tracks and Sectors
D) Heads and Sectors

1.3 Optical storage technique is used in
A) Floppy Disk Drive
B) Hard Disk Drive
C) Magnetic Disk Drive
D) CD-ROM Drive

1.4 Which 1 of the subsequent is not an internal DOS command?
A) RD
B) TIME
C) FORMAT
D) TYPE











1.5 The errors that can be pointed out by the compiler are
A) Syntax errors
B) Semantics errors
C) Logical errors
D) None of the above

1.6 Address of the 1st cell in a worksheet is:
A) 1
B) A
C) A1
D) 1A

1.7 Windows is popular because of its-
A) GUI Features
B) Multitasking capacity
C) Desktop Technology
D) Because it is inexpensive

1.8 Which of the subsequent is not a text function in MS-Excel?
A) CHAR()
B) LEN()
C) VAR()
D) ABS()

1.9 1 Kilo Bits is
A) 1000 bits
B) 1024 bits
C) 512 bits
D) 1048 bits

1.10 After a table has been created, in MS-WORD, which of the subsequent operations cannot be performed?
A) Insert rows in a table
B) Delete and insert columns
C) Split the table into 2 tables
D) None of the above























2. Each statement beneath is either actual or FALSE. select the most improper 1 and ENTER in the “tear-off” sheet attached to the ques. paper, subsequent 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 1st before running MS-WINDOWS.
2.7 Index holes in a floppy are meant of indexing files.
2.8 Without a mouse 1 cannot work with MS-WINDOWS.
2.9 ^U chooses the Italics style for the opted text in MS-WORD.
2.10 Partition Table is obtained in Hard Disks.

3. Match words and phrases in column X with the nearest related meaning/ word(s)/phrases in column Y. Enter your selection in the “tear-off” ans sheet attached to the ques. paper, subsequent 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
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 beneath has blank space to fit 1 of the word(s) or phrases in the list beneath. Enter your option in the “tear-off” ans sheet attached to the ques. paper, subsequent instructions therein. (1 x 10)

A. Laser B. Ctrl + X C. File
D. Hard E. Soft F. Scandisk
G. Password H. Assembly I. Dot Matrix
J. Title Bar K. CHKDSK L. Magnetic Tape
M. CLS N. Ctrl + C O. Virus
P. High Level

4.1 When WORD automatically begins a new page, this page break is called the ______________ page break.
4.2 The ______________ command can be used to accurate the file system.
4.3 For placing the prompt in the 1st 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.
4.8 A assembler translates ______________ language programs into machine language.
4.9 The ___________ shows the active document in WINDOWS.
4.10 _________ cuts the opted text and graphics and puts it in Clipboard.





















PART TWO
(Answer ALL questions)

5. Answer any 4 of the following:
a) What are the External commands in DOS? How are they various from internal commands? Name any 2 External DOS commands.
b) Describe the different operations that can be performed on a database in MS-EXCEL.
c) What is the significance of accessories in Window Operating System? define in short about WORD PAD.
d) How you can protect your documents in MS-WORD? discuss the procedure of protecting them.
e) Perform the subsequent Conversions:
i) Convert (18)10 to Binary Number
ii) Convert (110001)2 to Decimal Number
(5 x4)

6. Answer any 5 from the following:
a) How you can delete files and folders permanently in Window Operating System?
b) What is the use of AUTOEXEC.BAT file in DOS?
c) Name any 4 secondary storage devices.
d) Give 2 factors that make High Level Languages more advantageous than machine-level languages.
e) What are basic characteristics of Formulas in MS-Excel?
f) What is Animation? How is it various from Video?
(2 x 5)

7. Answer any 3 from the following:
a) What is the aim of any Presentation? How you can make your Presentation effective?
b) How you can check spellings in MS-WORD? elaborate the different choices available to accurate the wrong spellings?
c) What are non-impact printers? discuss briefly any 2 of them.
d) Describe the basic features of Functions in MS-Excel. Write functions for displaying Date and Time.
(5 x 3)

8. Answer any 3 from the following:
a) Distinguish between:
i) System software and Application software.
ii) Compiler and Interpreter
b) Explain the functions of an Operating System in a computer.
c) What are Headers and Footers in MS-WORD? elaborate the advantages of using them?
d) Describe in short about File Structure of LINUX.
(5 x 3)

Earning:   Approval pending.