DAV PUBLIC SCHOOL, HCL, RUPNARAINPUR

Practice Paper 04/05 for Class X (Session 2023-24)

Sub: Information Technology [Subject Code: 402]
Max. Time: 2 Hours Max. Marks: 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 (24 MARKS):
i. This section has 05 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 QUESTIONS (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: OBJECTIVE TYPE QUESTIONS

Q.1 Answer any 4 out of the given 6 questions on Employability Skills.(1x4=4 Marks)
i. This form of communication is extremely private. 1
a) Intrapersonal c) Small group
b) Interpersonal d) Public Communication
ii. An economy is called Green economy when it is based on the principles of 1
_________.
a) Social Inclusion c) Sustainable Development
b) Ecological Scarcities d) Waste Management
iii. Entrepreneurship has a crucial role in the ____________ of the society. 1
a) Evolution c) Functioning
b) Planning d) None of these

iv. Which of this function is not performed by an Operating System? 1

a) Entering Data c) Job Scheduling
b) Error Detection d) Memory Management
v. Which among the following is antivirus software? 1
a) Calc c) Ariva
b) Impress d) McAfee

1
vi. Building sensitivity towards all cultures and celebrating diversity is called ____ 1
a) Economic growth c) Cultural diversity
b) Environmental protection d) Social inclusion

Q.2 Answer any 5 out of the given 6 questions. (1x5=5 Marks)

i. The process of increasing or decreasing the space between the left and right 1
margin of a paragraph is known as-
a) Alignment c) Spacing
b) Indentation d) None of these

ii. This tab contains the Close Header and Footer option.
a) Home c) Page Layout 1
b) Design d) Insert

iii. The ____________ feature creates a summarised outline of a data in a worksheet? 1

a) Subtotal c) Solver
b) Goal Seek d) Scenario
iv. The shortcut key to open a new page is …………… 1
a) Ctrl+o c)Ctrl+n
b) Ctrl+x d)Ctrl+f
v. …………………….. are known as “Dumb Switches”. 1
a) Repeater c) Router
b) Hub d) Bridge

vi. These instant messaging softwares are downloaded and installed on the 1
user’s devices.
a) Web based c) Both (a) & (b)
b) Application based d) None of these

Q.3 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

i. This is the standard file extension of database in MS Access 2010 1
a) .accdb c) .odt
b) .pdf d) None of these
ii. The field which is designated as the Primary key of a table cannot have ............ 1
a) Unique values c) Null values
b) Default values d) None of these
iii. The intersection point between a row and column is called ____________. 1
a) Row c) Table
b) Column d) Cell
iv. With this extension a template gets saved in Word. 1
a) .dotx c) Both (a) & (b)
b) .dott d) None of these
v. _______ feature is used to extract the data using some conditions on columns in 1
Excel.
a) Design c) Mailing
b) Reference d) Filter

2
vi. In this topology every computer is connected to other computers in network. 1
a) Star c) Ring
b) Mesh d) None of these

Q.4 Answer any 5 out of the given 6 questions. (1 x5=5 Marks)

i. Conditional Formatting is a format applied based on the .......................... of a cell. 1

a) Width c) Height
b) Size d) Range

ii. Which of this data type cannot hold any text data? 1
a) Text c) Hyperlink
b) Memo d) Byte
iii. ............................ is the default view of an Spreadsheet. 1
a) Print c)Normal
b) Default d) Reading
iv. _____________ is an example of RDBMS. 1
a) MongoDB c) Windows Registry
b) Publisher d) Oracle

v. To optimize the Accessibility settings, first we need to open the ........................... 1

a) Setting c) File
b) User account d) Security
vi. ______________ uses the keyboard as a pointing device instead of a mouse. 1
a) Mouse Key c) Filter Key
b) Toggle Key d) Sticky Key

Q.5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

i. A set of rules used for communication between computers is known 1

as................
a) Processes c) Laws
b) Protocols d) None of these
ii. Which of the following is not an appropriate tab to apply formatting effects to 1
a report?
a) Format c) Page Setup
b) Arrange d) Setup
iii. This view is used to enter or edit data in a form. 1
a) Form View c) Layout View
b) Datasheet View d) Design View
iv. A _____ is one which connects computers and devices in a limited geographical 1
area such as home, school, computer laboratory, office building, or closely
positioned group of buildings.
a) LAN c) MAN
b) WAN d) PAN

v. ................................. is a chart, which doesn’t have any axis. 1

a) Line c) Pie
3
 b) Bar d) Scatter

vi. Sorting means ......................... data in a worksheet. 1

a) Deleting c)Inserting
b) Arranging d) Updating

SECTION B: SUBJECTIVE TYPE QUESTIONS

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

Q.6 Define Effective Communication. 2

Q.7 What is Stress Management? 2

Q.8 List any four elements that keep a person motivated. 2

Q.9 Define GUI briefly. 2

Q.10 What are the two types of risks usually faced by an entrepreneur? 2

Answer any 4 out of the given 6 questions in 20 – 30 words each. (2 x 4=8 Marks)

Q.11 Write any two advantages of online shopping. 2

Q.12 What do you mean by data manipulation? 2

Q.13 Explain any two types of Internet Connections. 2

Reena wants to check different built in templates available in Word. How can
Q.14 2
she do it?
Q.15 What is a Router? 2
Q.16 Sandhya has recorded the temperature of the city over the month in the cell
range C3 to C33 in Excel and she wants to find the maximum and minimum
temperatures during the month. How does she quickly do these 2
calculations? Please suggest the steps.

Answer any 3 out of the given 5 questions in 50– 80 words each. (4x3=12 Marks)

Q.17 Explain Packet Switching along with advantages. 4

Q.18 Define Paragraph Spacing. 4

Q.19 What precautions must be taken to improve online security? 4

What is the difference between creating a form through Form Wizard and
Q.20 4
creating a form through the Design View?

4
Q.21 Consider the following table
Table : Student
St_Id S_Name S_Marks Location
S001 Ayush 89 Kolkata 4
S002 Barnali 92 Asansol
S003 Sweta 80 Durgapur
S004 Subham 90 Rupnarayanpur

Write queries to:

i) Display all the records of the table.
ii) Display the details of those students whose marks>=90 and <=100
iii) Display the details of those students who live in Asansol.
iv) Delete the records of those students whose marks is <33.