Information Technology code 402 practice set with solution

Hi,
Practice set -2 with solution which help you in preparing CBSE board examination 2019-2020.

PART A: EMPLOYABILITY SKILLS (10 MARKS)

Answer any 4 questions out of the given 6 questions of 1 mark each:

1-        We really enjoyed ______________ on the trip to Manali last month.              (Ourselves)

2-        My house is a ______________ two-bedroom flat in Mayur Lok.             (Spacious)

3-        An economy is called Green economy when it is based on the principles of ______________.
(Sustainable Development)

4-        Physical exercise in the form of ______________, ______________ to relieve stress as they stabilize mood, improve self-esteem and induce sleep. (Walking, Skipping)

5-        ____________________ serves as an interface between the user and computer.
(Operating System)

6-        Define Story telling.

Answer any 3 questions out of the given 5 questions of 2 marks each:

7-        Jasmine lost her book, how she can describe the book which was lost? Mention at least four attributes to describe the book.

8-        A friend of yours has done a favor for you, now how would you express your appreciation for your friend?

9-        Write down the steps to create a folder in C drive with your name.
Answer - 1) Double-click the Computer icon.

2) Double click on C drive in which we have to create a folder.

3) Right-click anywhere in the blank area of the right column. A shortcut menu

 appears. Select New à Folder from the shortcut menu.

4) A new folder is created with name New Folder highlighted and then type a name

10-     List down any four factors causing ecological imbalance.
Answer - Following are the factors causing ecological imbalance

a. Destruction of forests

b. Industrialization

c. Urbanization

d. Large scale use of pesticides

e. Overgrazing

11-     Define the following

a) Paying guest

b) Landlord
Answer - a) Paying guest - Someone who lives on rent in the owner’s house.

E.g. Paying guest accommodations are easily available these days.

b) Landlord - A man who provides rooms for rent.
E.g. Our landlord allows us to stay out till 10 p.m. only.

PART B: SUBJECT SKILLS (40 MARKS)

Answer any 10 questions out of the given 12 questions:

12-     Symbol option is available under _________________ group in the Insert Tab in word document.

a. Illustrations       b. Symbols               c. Media        d. Text
(b. Symbols)

13-     Sound Sentry is designed to help user with ______________ impairments.            (Auditory

)

14-     ISP stands for ______________ ______________ ______________              (Internet Service Provider)

15-     ______________ can be used to break continuous text to one or more sentences.
(Paragraph)

16-     ______________ can be used for inserting information at the top of each page automatically.
(Headers)

17-     On selecting ______________ the first character in all the words of the selected sentences will be converted to Capital Letter. (Capitalize Each Word)

18-     Conditional formatting is available under ______________ group in home tab. (Styles)

19-     Chart option is available in ______________ group under the insert tab.            (Charts)

20-     Print option is available under ______________ menu.            (File)

21-     A ______________ is a graphical representation of data, in which the data is represented by symbols, such as bars. (Chart)

22-     ______________ helps to move, rotate or resize multiple objects in a presentation.

a. Grouping             b. Charts      c. Table                     d. Movie clip
(Grouping)

23-     Default tab stop position is ______________.            (0.5)

Answer any 4 questions out of the given 6 questions of 2 marks each:

24-     What do you mean by P2P?
Answer - Networks in which all computers have an equal status are called P2P or peer to peer  networks. Generally in such a network each terminal has an equally competent CPU.

25-     What do you understand by Documents Template?

Answer - Templates or document templates refer to a sample fill-in-the-blank document that can help in saving time. Usually templates are customized documents that may have sample content, themes, etc.

For example, if you want to create a resume you can use a resume template and modify only the sections that require changes.

To view sample templates available with your word processor

Go to File > New. You will be displayed with different types of templates

For example, if you would like to create a letter, you can select the Letters option under Office.com Templates section.

26-     What do you understand by Styles?

Answer - Styles or Style sets are pre-defined or customized options used for creating good looking professional documents with least efforts. You can find a number of styles available within word processor that can be applied to a document. In this exercise, you will learn to apply and manage styles.

To work with styles, open a new word document in word processor, to view list of styles, locate the Style group under Home tab

27-     What do you mean by Freeze in Spreadsheet?

Answer - Freezing rows and columns is helpful feature in a spreadsheet. When you are dealing with a huge amount of data that spans several rows or columns, you may want the headers to remain constant (frozen) while you scroll through the data so that you can see the identifying names of the rows/columns.

Open a new spreadsheet. To hide a row or column, do the following:

1. In order to hide any row or column you can either select the particular row or column that is to hidden or just one cell in the corresponding row or column

2. Click on Format option available under Cells group in the Home tab

3. A drop-down list appears as shown below.

4. Click on Hide & Unhide > Hide Rows.

28-     How can you insert audio clip in a presentation?
Answer - We can include audio clips to a presentation similar to that of videos. For example, you can play mild background music while making your presentation. In this exercise you will learn how to insert an audio clip in slides.

Open a new file using presentation software. Click on Sound option under Media clips group in the Insert tab, a drop down appears.

You can select the Sound from File option to insert the sound clip. A dialog box appears.

We can locate the audio clip and click OK to insert the same in the slide.

29-     What do you mean by grouping object?
Answer - Grouping can help when you want to move, rotate or re-size multiple objects in a presentation. We can group objects such as pictures, clip art, shapes and text box; once grouped they appear as a single object.

To group the objects select the Group option available under Arrange group in the Format tab.

Answer any 4 questions out of the given 6 questions of 3 marks each:

30-     Explain the following terms:

a. Internet

b. LAN

c. Instant Messaging

31-     What are Clip arts? List any two websites that offer free clipart.

32-     Differentiate between Animation and Transition in digital presentation.
33-     Write down the process for inserting Page Break?

34-     Write short notes on the following

a) Upper Case
b) Sentence Case
c) Strikethrough

35- What do you understand by Slide Transition?

Answer any 2 questions out of the given 4 questions of 5 marks each:

36- Write down the process for transferring data on the Internet.
37-     Write short notes on the following

a) Web server
b) Dial up
c) WiFi

38-     Explain different types of Charts.

39-     What is database server? Explain Primary and Foreign key.