CBSE Class 9 Computer Science Worksheet Set 01

Q1) Answer the following questions.

1. Name the type of printer to be used for printing text and graphics with high speed but at low cost.

2. Name the input device used to sense and read thick and thin black stripes present on the items usually sold at supermarkets.

3. Hari has used a word processor to write his history homework. Here is some of his homework. Quit India Speech by Mahatma Gandhi on August 8th 1942.

“Everybody will be his own master. It is to join a struggle for such democracy that I invite you today. Once you realize this you will forget all the differences, and think of yourselves as Indians only, engaged in the common struggle for Independence.”

a) Choose three features/tools from the box that Hari can use to make the title stand out. Spelling Checker, Print Preview, Cut Paste, Bold , Underline, Strikeout, Italics

b) Write one Word Processing tool that he can use to find the synonym of “struggle”

Q2) Tarini Fancy Inc. is planning in the Office Building to connect all computers each spread over within distance of 50 Metres.

a) Suggest the economical cable type having high speed data transfer which can be used to connect these computers.

b) Which type of network (out of LAN and MAN) will be formed by connecting these computers?

Q3) Multiple choice questions

1. Identify the device shown in the figure
a) Co-axial cable      
b) Ethernet Cable
c) Twisted pair cable  
d) None of the above

2. Suppose you have bought all hardware components required for assembling a Computer. After assembling the Computer System, which will be the very first software to be installed:
a) Hardware Drivers
b) Operating System
c) Anti Virus Software
d) Word Processing Software

3. Functions of an operating system include?
a) File system management
b) Memory Management
c) Processor Management
d) All of the above.

4. Members of ‘Nibbles & Bytes’, the computer club of a school wants to prepare and print Participation Certificate for all the participants in their annual interschool symposium using a spreadsheet, where the details of the participating students along with the events and schools are entered. Which of the following office techniques is most appropriate to get the desired results:
a) Cut and Paste    
b) Find and Replace
c) Copy and Paste  
d) Mail Merge

5. Which option would you use to display the digit 2 in the formula H20?
a) Lowered    
b) Superscript
c) Subscript    
d) Laid down

Q1. Explain the different types of storage devices.

Q2. Differentiate between Flash Drive and Memory Stick.

Q3 What is Software? Mention its types with example.

Q4. What is application software and why it is required?

Q5. Differentiate between Compiler and Interpreter.

Q6. What is an operating system? Explain utility software with example.

Q7. What is the role of transmission medium in a network? Explain the different types with suitable diagram.

Q8. What is networking? Write the different types of network with their ranges.

Q9. Define the followinga)

Wi-Fi

b) Interspace

c) Data & Information

Q10. Write the steps for inserting the image from the following a) Scanner b) Graphics c) File

Q1. What is the difference between slides pane and task pane?

Q2. What is slide layout? Write the different types of slide layout.

Q3. What is design template?

Q4. Define the followinga)

Watermark

b) Slide Transition

c) Rehearse Timings

Q5. What is spreadsheet? Write the features of spreadsheet.

Q6. Define the termsa)

Worksheet b) Cell c) Active cell d) Range

Q7. Write the steps to copying a range in spreadsheet.

Q8. What is cell reference? Explain their types.

Q9. Write the use of given functions with examplea)

SUM ( )

b) AVERAGE( )

c) COUNT( )

d) MAX( ) & MIN( )

e) IF( )

Q10. Write the steps for creating a chart in spreadsheet.

Students are required to work on the following areas using Word Processing software

• Editing and formatting text and paragraph

• Page and paragraph setup

• Inserting symbols and pictures

And create a IT report file on the following four Topics/Domains taking real life examples:

A. MCQ:

1. In a document , sachin has to change all the occurrence of the word

'Calcutta' with 'Kolkata' which one of the following options is most appropriate to do the task:

a) Copy & paste b) Find & replace c) Cut & paste d) All of the above

2. Rahul is typing his computer project on "Virus prevention" using word processing software. He wants to add the text at the top of each page.

Which option he should use:

a) Footer b) Header c) Watermark d) Bullets

3. Which of the following actions can be performed using the Page setup option of a word processor tool?

a) Margins b) Paper size c) Page Orientation d) All of the above

4. A bank cheque or draft generally contains a specially printed number in

it, which of the following technique is used to read the special characters

a) MICR b) OCR c) OMR d) Light Pen

5. Which of the following is GUI based operating system

a) MS DOS b) UNIX c) Windows 3.1 d) Windows Vista

B. True or false:

1. Permanent memory contents are not lost when power is lost.

2. WinZip is an encryption tool.

3. Disk defragmenter is a disk utility software.

4. Scanner is used to capture the digital copy of your certificates.

5. Database management is not one of the functions of the operating system.

C. Brief Answers:

1. What do you mean by previewing a document in Ms Word?

2. How are tables of Writer useful?

3. What do you mean by the term orientation?

D. Definition:

1. Formatting

2. Interspace