EDUSOFT IT SOLUTIONS PVT LTD.

SAMPLE QUESTION PAPER 3

INFORMATION TECHNOLOGY (402)
Class X (Session 2022-2023)
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 (1 x 4 = 4 marks)

i. Shivangini is a graduate in textile designing, she found an attractive idea to start a garment
manufacturing unit for infants. Which of the following she must not do to ensure the successful
running of this business idea?

a. Spend money on hiring talent.

b. Planning and predicting only the success of business.

c. Spend on sales and promotions.

d. Setup the unit near the resources and use local materials.

ii. Which of the following is correct regarding entrepreneurship?

a. Working on an idea that is already there in the market is not an entrepreneurship.

b. Anyone can start a business with that much money they have.
 EDUSOFT IT SOLUTIONS PVT LTD.
c. Only some class of people have the talent for doing business successfully.

d. People associated with the big business only are considered as an entrepreneur.

iii. A person works late hours in his business and is a habitual drinker. He sleeps late and rushes to
the office the next day, often skipping breakfast. – This is an example of which of the following
factors of stress?

a. Lifestyle b. Luxury

c. Too much wealth d. Human ego

iv. Vinita analyses her assignments and prepares well for her share of the tasks with proper plan and
then completes her tasks in time so that it helps team to complete the whole assignment. Here,
Vinita exhibits which of the following traits?

a. Working independently b. Team player

c. Both a) and b) d. All of these

v. Advantages of e – mail over traditional mailing system is/are?

a. Sending and receiving e - mail is very fast

b. It is more affordable

c. Files can be sent as an attachment through e – mail

d. All of these.

vi. Which of the following is /are correct about a Word processor?

a. Change the appearance of a document.

b. Do not mark or correct any spelling mistake.

c. Both a & d

d. Insert images, Headers, and Footers.

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

i. ______________ quickly apply a pre-designed set of font, font-size, colour, and other formatting
on the document at once to give a professional, formal look.

a. Labels b. Table of content

c. Styles d. Template

ii. Select the correct option that indicates the variable values inserted in the main document from
the data source.

a. Merged document b. Main document

c. Data d. Merged fields

iii. _____________ contain the addresses which can be printed for mailing purposes?

a. Merged Document b. Labels

 EDUSOFT IT SOLUTIONS PVT LTD.
c. Data source d. Merged field

iv. ____________ icon represents the chapter number.

a. E# b. LS

c. T d. E

v. Table of Content is based on _________________.

a. Page styles b. Document outline

c. Document templates d. Heading styles

vi. In order to save time you want to make a formatted document reusable multiple times,
___________ feature is best suited for it?

a. Apply themes b. Apply styles

c. Save it as Template d. Mail merge

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

i. Nikita runs a boutique; she wants to know how many salwar suit should be sold to get the total
profit of 2 lakh rupees. Which of the following features will help her?

a. Goal seek b. Subtotal

c. Data consolidation d. None of these

ii. _________ is the best way to decrease data redundancy and collaborative editing of a document?

a. Review document b. Sharing document

c. Relative hyperlinking d. Comments in the document

iii. A __________ used to keep the hyperlinks intact while distributing documents to others.

a. Relative hyperlinking b. Absolute hyperlinking

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

iv. _________ feature allows a user to bring together data from different spreadsheets or workbooks
and perform sum, average or other calculations on the data values.

a. What-if analysis b. Scenarios

c. Data consolidation d. Solver

v. Applying a set of values on a data set to analyse changes in the calculations and result is achieved
by using ___________ tool?

a. Goal seek b. Solver

c. Sub-total d. Scenario

vi. _________ feature of the electronic spreadsheet allows the user to record the steps and save in
the workbook by a unique name given by the user?
 EDUSOFT IT SOLUTIONS PVT LTD.
a. Arguments b. Macros

c. Merge sheets d. Loop

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

i. Ram is creating a table and wants that a field GENDER should not be left blank and default gender
is Female. Which of the following approaches should he take?

a. Set the property Entry required to Yes and Default Value to Female.

b. Set the property Entry required to Yes.

c. Set the property Default Value to Female.

d. Set the property Format Example to Fe*

ii. Which of the following is true about Dynamic Report?

a. It always shows updated data from the table.

b. It is created by default in Report Wizard,

c. It can be edited in Report Editor.

d. All of these

iii. Deleting records without any criteria given will lead to which of the following?

a. Deletion of the entire table. b. Blank table.

c. Deletion of no records. d. Error in command (criteria is necessary).

iv. Consider the following statement and identify the constraint in it.

CREATE TABLE STUDENT(age int default 18, check(age>=18))

a. default b. check

c. both a) and b) d. age>=18

v. If a form in Base is going to display data, then which of the following actions on it can be
prevented while creating the form using Form wizard

a. Insert of new data b. Deletion of data

c. Data modification d. All of these

vi. In SQL View, pressing F5 does which of the following?

a. Runs the SQL statement. b. Edits the SQL statement.

c. Erases the command panel. d. Refreshes the command panel.

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

i. Which of the following is a category of broadband internet access that uses the infrastructure of
cable TV networks to provide Internet services?

a. Dial-up b. Cable Internet Access

 EDUSOFT IT SOLUTIONS PVT LTD.
c. WAP d. WiMAX

ii. The device which modulates outgoing digital signals from a computer to analog signals through a
telephone line and demodulates the incoming signals is known as ____________.

a. Modulator b. Demodulator

c. Modem d. Dongle

iii. Which of the following best describes the cash on delivery facility?

a. It allows customers to pay on receiving the product.

b. It allows customers to use the product and then pay

c. Facility to pay the price in instalments.

d. It includes the dependency on payment cards.

iv. Which standard network protocol is used to communicate between web browser and web
server?

a. PSTN b. HTTP

c. WiMAX d. DSL

v. Choose the correct option to secure the data on the internet.

a. Use the same strong password for multiple sites to remember it.

b. Take regular backup data and Encrypt it.

c. To save time, allow browsers to automatically login.

d. All are correct except c

vi. Hari's grandmother has a low vision and she wants to use a computer without a display to
complete common tasks such as to read email and browse the internet. Which of the following
option helps her to do so?

a. Turn off Narrator b. Turn on Audio description

c. Turn on Narrator d. All of these

SECTION B: SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 marks)

Answer each question in 20 – 30 words.

Q. 6 What is fight-flight-freeze response?

Ans. Fight-flight-freeze is the response due to need of survival in sudden danger. One part of our
nervous system controls fight-or-flight response. In freeze response, body is unable to respond for
certain duration until the danger passes or the victim succumbs to the danger.

Q. 7 List any 2 healthy working or study habits that help reduce stress?

Ans. Following are the healthy working or study habits that help reduce stress are:
 EDUSOFT IT SOLUTIONS PVT LTD.
1. Do not try to please everyone. Leant to say no if you really cannot help something.

2. Plan to keep a balance between work and family. For scholars, keep a study-recreation balance.

Q. 8 List 3 major functions of operating system.

Ans. Three major functions of an operating system are:

1. Managing applications and giving them access to hardware services.

2. Managing data and system resources.

3. Providing user interface to work with the computer system.

Q. 9 What is social entrepreneurship?

Ans. Social entrepreneurship is the processes and operations conducted by social entrepreneurs to
curb the social problems such as low reach of quality education, health and sanitation,
unemployment, child labour etc.

Q. 10 What is innovation in entrepreneurship?

Ans. Entrepreneurs innovate by introducing new concepts, products, services, designs, ideas etc.
They may introduce something new and innovative in any branch of economic activity. An
entrepreneur foresees a potentially profitable opportunity and innovates in the effort to use it.

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

Q. 11 What do you mean by a template?

Ans. A template is a pre-designed and pre-formatted document which can be used to fill in the
content as you need. Template saves time and effort that otherwise goes in designing and
formatting the document manually.

Q. 12 How will you sort the data in a table in Datasheet View?

Ans. Double click on the desired table. It will open in the Datasheet View.

Click on the field header (field name) in the basis of which you need to sort the records.

In Table Data toolbar, click on Sort Ascending or Sort Descending button.

Q. 13 What are the advantages of sharing a file over a cloud location?

Ans. In a cloud drive, users can work on the same document through sharing feature. This saves
time and effort in maintaining and updating multiple copies and minimises errors. Another
advantage is the cost is minimised and work is done efficiently.

Q. 14 What do you mean by Formula cell and Variable cell in Goal Seek?

Ans. Formula cell is the address of that cell that contains the formula to perform desired
calculation. Variable cell is the address of the cell whose value should change to get expected
output value.

Q. 15 What do you understand by a WiFi connectivity?

Ans. Wi-Fi is a popular technology that allows an electronic device such as computers or mobile
phones to exchange data wirelessly over a network, including high-speed Internet connections.
 EDUSOFT IT SOLUTIONS PVT LTD.
Wi-Fi devices connect to a network resource such as Internet through a device called the Wireless
Access Point (WAP).

Q. 16 What is a MODEM?

Ans. MODEM stands for MOdulator/DEModulator. It is a hardware device that enables a

computer to send and receive information over telephone lines by converting the digital data used
by your computer into an analog signal used on telephone lines and the converting back once
received on the other end.

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

Q. 17 What are the various ways if inserting image in a document?

Ans. In Writer, images can be inserted in following ways:

i. Import graphics files using Insert menu > Picture > From File option. (higher versions: Insert >
Image)

ii. Link image by Insert menu > Picture > Link option or embed image by breaking the link as Edit
menu > Links option and click Break Link button in the Edit Links dialog box.

iii. Scan the image by Insert menu > Picture > Scan option > Select Source > OK. Then insert the
scanned image using Insert menu > Picture > Scan > Request option. (higher versions: Insert >
Media > Scan > Request)

iv. Insert any copied image from the clipboard by using Edit menu > Paste Special option.

v. Drag-dropping images in the document with Ctrl key (images are embedded in the document.)
or, Ctrl+Shift key (a link to the image is inserted in the document. Actual image is not inserted.)

Q. 18 Anuj has a worksheet in a particular format. A copy of same sheet is with his assistant. They
both made certain changes in their copies. How will Anuj keep his changes as well as accommodate
assistant’s changes also in his sheet? Write detailed steps.

Ans. If there are multiple copies of same worksheet modified by multiple users then all of them
need to be merged into the original sheet. In such a case, Anuj can compare his document and
assistant’s document.

To merge the worksheets, Anuj must first open his worksheet. Then, go to Edit menu > Track
Changes > Merge Document option.

In the Merge With dialog box, select the assistant’s file whose data needs to be merged and click
on Open button. Manage Changes dialog box will appear. Accept/Reject changes as you need and
click Close. The sheet will be merged.

Q. 19 Consider the sample data of a table Subscriber shown here and answer
the questions that follow:

a. Display maximum and minimum price.

b. Display Total and average price.

c. What is the maximum price of Jeans?

d. What is the average price of Jacket?

 EDUSOFT IT SOLUTIONS PVT LTD.
Ans. a. Select max(price), min(price) from Garment.

b. Select sum(price), avg(price) from Garment

c. Select max(price) from Garment where Item_Name= ‘JEANS’

d. Select avg(price) from Garment where Item_Name= ‘JACKET’

Q. 20 Consider table Book given here.

a. What are the prices of the books written by ‘Tom Clancy’?

b. List details of all the books in descending order of Price.

c. Display the names of the authors with book titles in ascending order of Price.

d. Display the names of the authors with book titles in ascending order of Price.

Ans. a. Select Title, Price from Book where Author= ‘Tom Clancy’

b. Select * from Book order by Price desc

c. Select Author, Title from Book order by Price

d. Select Author from Book where Publisher = ‘Rupa’

Q. 21 What are various types of workplace emergencies? Describe any 2.

Ans. Various workplace emergencies are Work-specific, equipment related, natural calamities civil
or behavioural and health related.

Health related emergencies are common at dangerous work environments like chemical plants,
mines, oil-rigs and medical research labs etc. Workers in factories may be exposed to smoke,
poisonous gases, extreme heat, extreme cold, radiations, intense lighting, high decibel noise and
extreme physical exertion. Careful, efficient, and regular safety measures can only protect workers
from the impending harm.

Equipment related emergencies like sudden injury, cuts, or bruises; body-part or cloth stuck in the
machinery, accidents related to turbines, boilers and chemical plants; crashes and accidents by
moving objects – vehicles, lifts, trolleys and carts etc.

For Visually Impaired Students

Q. 21 How will you set up visual feedbacks to appear on the screen instead of sound?

Ans. Following are the steps to setup visual feedbacks to appear on the screen instead of sound

1. Click on Start.
 EDUSOFT IT SOLUTIONS PVT LTD.
2. Click on Control Panel.

3. Click the Ease of Access link.

4. Click Ease of Access Center link.

5. Click on Use text or visual alternatives for sounds in Ease of Access Center.

Sound Sentry or Turn on visual notifications for sounds option replaces system sounds with visual
warnings like flashing caption bar of active window, flashing the active window itself and flash
desktop. Select the desired visual warning.

Any sound that reads the screen can be turned into text caption that appear on the screen by
checking Turn on text captions for spoken dialog checkbox