Sample Question Paper for class 10th

Information Technology

(Pre Board Examination)

Pre Board Examination (2020-21)

Information Technology

Class – Xth

Time: 2HRS. M.M.: 50

General Instructions:

1. Please read the instructions carefully.

2. This Question paper consists of 21 questions in two sections: Section a & Section B. 3. Section A has Objective Type Questions whereas Section B contains Subjective Type Questions.

4. 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.

5. All questions of a particular section must be attempted in the correct order. 6. Section A: Objective Type Questions (24Marks)

(i) This section has 5 questions.

(ii) Marks allotted are mentioned against each question/part.

(iii) There is no negative marking

(iv) Do as per the instructions given.

7. Section B: Subjective Type Question (26 Marks)

(i) This section has 16 questions

(ii) A candidate has to do 10 questions.

(iii) Do as per the instructions given

(iv) Marks allotted are mentioned against each question/part

SECTION A

1. Answer any 4 out of the given 6 questions

(i) …………… is the person or organization originating the communication?

(a) Message (b) Channel

(ii) A/An ……… is a kind of adjective which is always used with a noun and gives some information above it.

(a) Article (b) Noun

(iii) ……… is an activity done to achieve physical fitness and overall health?

(a) Mentally Exercise (b) Physical Exercise

(iv) ………. Can be used in Excel to retain some particular records as visible on the excel sheet

(a) Sorting (b) Filter

(v) A/An ……. With rational planning and firm decisions bear the risks.

(a) Entrepreneur (b) Motivator

(vi) Proper balance ought to be maintained between ……… and …………. For the achievement of sustainable goals

(a) taxes, travel (b) taxes, fines

2. Answer any 5 out of the given 6 questions

(i) Which type of charts are used to compare trends over time?

(a) Line Charts (b) Column Charts

(ii) ……… page break will shift all the text to the right of the cursor to the top of the next even page

(a) Odd (b) Even

(c ) Both (a)and (b) (d) None of these

(iii) A database consists of many ………..

(a) data (b) values

(iv) The data is transmitted in small blocks, known as ……….

(a) frames (b) packets

(v) Blogging is the act of posting content on a ………..

(a) Server (b) Client

(vi) Which of the following is a spreadsheet software?

(a) Lotus 1-2-3 (b) VisiCalc

3. Answer any 5 out of the given 6 questions

(i) The general arrangement of the text in the document is

(a) Margin (b) Text alignment

(ii) Network formed between computers which are spread across the continents is called

(a) LAN (b) WAN

(iii) ……….. is required to preserve the contents for a long period or to be used as evidence

(a) Documentation (b) Page break

(iv) Which of the following is used for analyzing, sharing and managing information for accounting purpose?

(a) Cell (b) Spreadsheet

(v) …………language is use to create and modify the structure of database objects in database.

(a) Data manipulation (b) Transaction Control

(vi) …………. Acts as a centralized connections to several computers with the central node or server.

(a) Hub (b) Switch

4. Answer any 5 out of the given 6 questions

(i) ….. Allows to format the horizontal or vertical alignment of text in a document

(a) Scroll Bar (b) Ruler

(ii) In MS-Excel …….. Shortcut key is used to hide the selected columns.

(a) Ctrl+ N (b) Shift+ O

(iii) There are ……. Methods for creating a query in MS-Access.

(a) Three (b) Two

(iv) ………… is a form of communication over the Internet that offers an instantaneous transmission of text based messages from sender to receiver.

(a) Instant messaging (b) Messaging

(v) Which of the following best describes a form?

(a) Form enables people to enter or view data in a database easily

(b) Form summarises and prints data.

(d) All of the above

(vi) Modulation and demodulation are performed by ……..

(a) Microwave (b) Satellite

5. Answer any 5 out of the given 6 questions

(i) ………… contains panel of commands which are organized into a set of tabs

(a) Title bar (b) Status bar

(ii) The Themes group is presented on ……….tab

(a) Home (b) Page Layout

(iii) Which of the following is not an example of database?

(a) Cross knot game (b) Employee payroll management

(iv) A modem is connected in between a telephone line and a ……….

(a) Computer (b) Serial port

(v) In ……….. Referencing, the relative address of the cell gets adjusted with respect to the current cell.

(a) Mixed (b) Relative

(vi) Computer connected with LAN

(a) Work fast

(b) go online

(d) can share information or peripheral devices

SECTION B

Answer any 3 out of the given 5 questions in 20-30 words each

6. Explain the kinds of sentence

7. What are the necessary skills for independent working?

8. Describe the feature of MS-Excel as filter and sorting?

9. Explain some myths of entrepreneurship?

10. United Nations Sustainable Development Summit (2015) sets global development goals. What are these goals?

Answer any 4 out of the given 6 questions in 20-30 words each

11. Write the steps to make the header or footer different for odd and even pages. 12. What do you mean by cell referencing?

13. How to create a chart in MS-Excel?

14. What is alternate key? Also, give its example.

15. What is bridge as a network device?

16. Define the following:

(i) Title bar (ii) Status bar

Answer any 3 out of the given 5 questions in 50-80 words each

17. What is indentations? How many ways are there to indent a paragraph? Explain them

18. Define the following

(i) Instant messaging (ii) Circuit Switching

19. Write the steps to freeze both the rows and columns in worksheet. 20. What are the advantages of database?

21. (i) Create the table PERSONS with following details :

Column Name	Data Type
Pld	Varchar (5)
Sur Name	Char(30)
First Name	Char (20)
Gender	Char (3)
City	Char(10)
Salary	Int

(ii) Consider the following table Product and write queries (a) and (b) TABLE: PRODUCT

Product Code	Product Name	Date of Sale	Oty Sold	Customer Name	Amount
P001	Pencil	05.10.2011	5	Himanshu	25
P002	Eraser	04.01.2012	4	Ali	8
P003	Sharpner	19.12.2011	6	Deepak	12
P004	Whitener	25.04.2011	2	Ankit	30
P005	Blue Pen	20.07.2012	3	Ruchi	40