IT 402 Sample Paper Class 10 Set 3

IT 402 Sample Paper Class 10 Set 3

Time: 2 hrs

Maximum Marks: 50

General Instructions

1. This Question Paper consists of 21 questions in two sections: Section A & Section B.
2. Section A has Objective Type Questions whereas Section B contains Subjective Type Questions.
3. Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions in the allotted (maximum) time of 2 hours.
4. All questions of a particular section must be attempted in the correct order.
5. Section A : Objective Type Questions (24 Marks)
6. Section B : Subjective Type Questions (26 Marks).This section has 16 questions.A candidate has to do 10 questions.

SECTION A: Objective Type Questions

1- Answer any 4 out of the given 6 questions based on Employability Skills.(4)

(i) ______ is essential to complete the cycle of communication.

(a) Encoding

(b) Decoding

(c) Feedback

(d) Sender

(ii) The good stress is called _______

(a) Eustress

(b) emstress

(c) Both (a) and (b)

(d) None of these

(iii) _______ means to make a duplicate of a file.

(a) Deleting

(b) Editing

(c) Pasting

(d) Copying

(iv) _____ describes entrepreneurs as innovators.

(a) Howard W. Johnson

(b) Joseph Schumpter

(c) Both (a) and (b)

(d) None of these

(v) Sustainable development requires the judicious use of ________

(a) resources

(b) natural resources

(c) verbal resources

(d) None of these

(vi) _______ conveys a statement, question, exclamation or command.

(a) Sentence

(b) Equation

(c) Formula

(d) None of these

2- Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) If you want to locate a range of cells by its name, then you will enter its name in _______

(a) formula bar

(b) name box

(c) cell

(d) None of these

(ii) We can italic the text by ______

(a) Ctrl + IT

(b) Shift + I

(c) Ctrl + I

(d) Alt + I

(iii) _______ command is used to restore database to original since the last COMMIT.

(a) REVIEW

(b) SELECT

(c) ROLLBACK

(d) None of these

(iv) ______ provides the physical connection between the network and computer workstation.

(a) LIC

(b) NIC

(c) NC

(d) None of these

(v) URL is the ______ for a website or a web page.

(a) web address

(b) website

(c) web page

(d) Both (a) and (c)

(vi) How many types of views are available in the spreadsheet?

(a) 3

(b) 4

(c) 5

(d) 2

3- Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) Which tab of MS-Word contains the Shapes option?

(a) Home

(b) Review

(c) Insert

(d) Mailings

(ii) Digital information is converted into analog information by the modem at

(a) destination computer

(b) source computer

(c) Both (a) and (b)

(d) None of these

(iii) ______ is the indent, the paragraph except first line.

(a) Left indent

(b) Hanging indent

(c) Right indent

(d) None of these

(iv) The default page orientation in spreadsheet is _______

(a) landscape

(b) horizontal

(c) portrait

(d) None of these

(v) The key field is a unique identifier for _______

(a) each column

(b) each record

(c) Both (a) and (b)

(d) None of these

(vi) Every computer is protected by a ________

(a) firewall

(b) software

(c) server

(d) network

4- Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) ______ is a GUI based software used in the windows environment.

(a) Word processor

(b) DOS

(c) Both (a) and (b)

(d) None of these

(ii) ______ is referenced by a combination of row number and column letter.

(a) Data

(b) Work cell

(c) Cell

(d) Document

(iii) ______ leads to data inconsistency.

(a) Data integrity

(b) Data redundancy

(c) Data sharing

(d) Data recovery

(iv) _______ is a computer program that provides services to other computer programs.

(a) Server

(b) Client

(c) Network

(d) None of these

(v) Which of the following is not the main building block of a database?

(a) Lists

(b) Queries

(c) Reports

(d) Forms

(vi) Blog Desk is an offline blog editor which is used for _______ operating system.

(a) Linux

(b) Unix

(c) Windows

(d) None of these

5- Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) _______ preview displays the page breaks as blue line.

(a) Break

(b) Page break

(c) Page

(d) None of these

(ii) The ________ alignment makes sure that none of the edges of text appear ragged.

(a) left

(b) right

(c) center

(d) justify

(iii) Key field is a unique identifier for each record. It is defined in the form of

(a) rows

(b) columns

(c) tree

(d) query

(iv) [email protected] represents an ________

(a) MAC address

(b) URL

(c) E-mail address

(d) None of these

(v) The bar located at the top of the application window is called ________

(a) title bar

(b) status bar

(c) menu bar

(d) None of these

(vi) A web page is located using a

(a) Universal Record Linking

(b) Uniform Resource Locator

(c) Universal Record Locator

(d) Uniformly Reachable Links

SECTION B: Subjective Type Questions

Answer any 3 out of the given 5 questions based on Employability Skills. Answer each question in 20-30 words (2 × 3 = 6)

6- What are the basic principles of an effective communication?

7- How nature walk does help to manage stress?

8- Write the steps to insert header and footer.

9- Define the following functions of an entrepreneur:

(i) Establishing relations with Government

(ii) Establishing contacts with Competitors

10- What are the long term solutions for sustainable development?

Answer any 4 out of the given 6 questions in 20-30 words each (2 × 4 = 8)

11- How to change the prefilled information?

12- What do you mean by chart?

13- Write the steps to format the font size.

14- How to change the type of chart?

15- Explain the term modulator/demodulator.

16- Define the following:

(i) Text data type

(ii) Memo data type

Answer any 3 out of the given 5 questions in 50-80 words each (4 × 3 = 12)

17- How to apply a picture style in a document?

18- Define the following:

(i) Star topology

(ii) Web browser

19- Write the steps to sort more than one columns.

20- What are the disadvantages of DBMS?

21(i) Create a table CUSTOMER with following details:

Column Name  Data Type

CustNo     Varchar(5)

Name        Char(20)

Address    Char(50)

(ii) Consider the following table SummerCamp and write the queries (a) and (b).

Table: SummerCamp

(a) Write a command to insert a new record with the following values:

(105, ‘Shyam’, ‘Sharma’, 07/09/10, ‘M’, ‘1A’)

(b) Write a query to display all the record of table SummerCamp whose DOB between 02/02/09 and 06/03/10.