EDUSOFT IT SOLUTIONS PVT LTD.

SAMPLE QUESTION PAPER 4

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. Which of the following stands for ‘C’ in the ABC of stress?

a. Confidence b. Consequences

c. Critical d. Counter

ii. Rashmi able to adapt the changing situations and managing time accordingly, deliver with short

time lines and know how to utilise time effectively. Which of the following skills she have?

a. Communication and negotiation b. Handling failure

c. Knowing oneself d. Agility

iii. _____________ installs itself on the computer without the user’s knowledge and monitors

confidential information and forward it to the malicious owner of such program.

 EDUSOFT IT SOLUTIONS PVT LTD.
a. Spam b. Pharming

c. Spyware d. Firewall

iv. __________ virus reduces its actual file size so that anti-virus does not get suspicious.

a. Macro b. Boot sector

c. File d. Stealth

v. Rajat is an entrepreneur and he used to track the utilisation of resources, corrects subordinates
when required and get the required work done as directed to run the business smoothly. Which of
the following  functions does he perform?

a. Supervision b. Controlling

c. Co-ordination d. Staffing

vi. Everyone who becomes an entrepreneur goes through a career process. Identify the correct
process.

a. Assembling requirements> business idea> conducts research & investigation> capital for business

b. Capital for business> conducts research & investigation> business idea> assembling requirements

c. Capital for business> conducts research & investigation> assembling requirements > business idea

d. Business idea > conducts research & investigation > assembling requirements> capital for
business

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

i. _________ page wrap prevents text from being placed to the side of the image if the spacing
between the image and the margin is less than 2 cm.

a. Optimal b. Through

c. Parallel d. Before

ii. Which of the following icons represents the start of a hyperlink?

a. LE b. LT

c. LV d. LS

iii. A computer programmer wants to create a graphical representation of his program logic. Which
shape category is most useful for him?

a. Basic shapes b. Flowchart

c. Callouts d. Block arrow

iv. __________ contains the variable data such as names of the recipients, address, city, state, etc.

a. Data Source b. Merged document

c. Main document d. Table of content

v. Cut link to a template means ____________________________.

 EDUSOFT IT SOLUTIONS PVT LTD.
a. Changes in template will not be applied to the document.

b. Changes in template will not be applied to a section of the document.

c. Document does not remain to be based on any template.

d. Deactivated link to the template cannot be undone.

vi. Which of the following components help in installing online templates?

a. Extensions b. Online Template

c. Update Templates d. All of these

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

i. While editing a shared sheet, if tracking of changes is not on, then which of the following is useful
to examine which changes have been done?

a. Merge sheets b. Review sheets

c. Compare sheets d. Any of these

ii. If certain values are stored in a collection, then the position of the first value in that collection will
be denoted by which of the following?

a. 1 b. 0

c. Total number of values - 1 d. None of these

iii. In the statement: for z = 10 to 100, z is a ______________.

a. Loop counter b. Variable

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

iv. In the formula: rep1:A3*rep5*A5+D5, the cell D5 belongs to ________________.

a. Different workbook b. Current sheet

c. Different sheet d. Current workbook

v. Nikita is a science teacher; she has science marks of class IX and X students. She wants to calculate
the average marks class wise. Which of the following is best suited for this?

a. Goal seek b. Solver

c. Sub-total d. User defined formula

vi. 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. Sub-total

c. Solver d. Scenario
 EDUSOFT IT SOLUTIONS PVT LTD.
Q. 4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

i. The requirement for an E-Commerce website is that, while details of any new visitor are captured,
the unique visitor number is automatically generated. How will we achieve this?

a. We must set the desired field to primary key.

b. We must keep the data type of the field numeric.

c. We must keep the data type of the field numeric and property AutoValue set to Yes.

d. We must set the property Default Value to Yes.

ii. Milind has created two tables - Student_Master which has a unique record of each student and
Student_Marks to store data of all the exams conducted for students in the fields Exam_Name and
Marks_Obtained for each student. Both the tables are related on common field Admission_No which
is primary key in Student_Master. He wants that marks for any non-existent student must not be
entered in the Student_Marks table. What should he do to achieve this?

a. Write a program to check if the record entered is valid or not.

b. Apply a constraint on the field Admission_No.

c. Set up a relationship between the two tables on the field Admission_No.

d. Apply suitable validation on the fields that store marks.

iii. In Datasheet View, which of the following is the correct way of sorting the data in descending
order?

a. Select the desired column in the table and click on sort button A>Z in the toolbar.

b. Right click on the desired column in the table and select sort A>Z.

c. Select the desired column in the table and click on sort button Z>A in the toolbar.

d. Right click on the desired column in the table and select sort Z>A.

iv. Consider the tables STUDENT and HOUSE shown here. If the two tables are related to Adm_No
and House_No then which type of relationship would it be?

a. One-to-one b. Many-to-one

c. Many-to-many d. None of these

v. Consider the table structure of a table BOOKING given here. Which of the following statements
will insert a new record in this table?
 EDUSOFT IT SOLUTIONS PVT LTD.

a. Insert Booking(100, 101, ‘2022-10-26', 301)

b. Insert into Booking(100, 101, ‘2022-10-26', 301)

c. Insert into Booking values(100, 101, ‘2022-10-26', 301)

d. Insert into Booking values(100, 101, 2022-10-26, 301)

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

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

i. If a person has limited movement of hands, but he frequently uses a computer and controls the
computer cursor. It is possible by using ______.

a. A good quality wireless mouse b. Voice recognition technology

c. A Laser Pointer d. None of these

ii. Dinesh is troubled by hearing the alert sound again and again when his computer's caps lock and
num lock are turned on and off. What should he do to turn off the alert sound?

a. Turn off Filter keys b. Click on mouse checkbox

c. Turn off Toggle keys d. Press left shift + left alt keys

iii. The process of purchasing goods & services and paying money using the net banking, debit/credit
card, UPI transfer is_________________.

a. Paying debt b. Money transfer

c. Online transaction d. All of these

iv. Select the correct option which best describes the workplace safety.

a. First aid kit includes fire extinguishing equipment and alarm.

b. While using the mouse, upper arm and elbow should make an obtuse angle.

c. The main purpose of first aid is to keep the patient alive until health care arrives.

d. Proper lightning leads to visual health and low productivity

 EDUSOFT IT SOLUTIONS PVT LTD.
v. Which type of network consists of computers acting as clients, servers or both at the same time
and equipped with similar processing power and sharing information and resources with each other?

a. Peer- to- peer b. PAN

c. Client server d. MAN

vi. Jasleen and Sushmita want to chat on Instant messaging software. Jasleen has a valid account on
Google Hangout and Sushmita has a valid account on Skype. They were trying to send an invitation
to each other, but not able to send. Which of the following best describes the reason for it?

a. Inviting is not possible on Instant messaging.

b. Both of them are using different types of internet connection.

c. Both of them are using different Instant messaging software.

d. None 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 List any 4 common symptoms of physical and psychological stress.

Ans. Common physical effects of distress: Headache, Muscular tension, fatigue, chest pain.

Common psychological effects of distress: Anxiety, loss of attention, depression and frustration,
angry outbursts.

Q. 7 What are internal and external self-awareness?

Ans. Internal self-awareness: This is built on our value and belief system. Our values determine
our passions and standards.

External self-awareness: When we can successfully assess how other people view us is called
external self-awareness.

Q. 8 What is the use of Computer Icon and Recycle Bin?

Ans. Computer icon is found in the desktop. It opens the Computer window which shows the
drives, files and folders on the computer system. Recycle Bin icon is also found on the Desktop
which opens Recycle Bin window. Deleted files are found in Recycle Bin from where either they
can be permanently deleted or restored back.

Q. 9 How entrepreneurs positively contribute to society?

Ans. Entrepreneurs do a lot of good to the society. They earn money with great struggle and pay
taxes thereby returning back to the economy. They take green initiatives for sustainable
development and use resource efficiently for the sake of society.
 EDUSOFT IT SOLUTIONS PVT LTD.
Q. 10 Is it a myth that every start-up should begin with a new product or service?

Ans. Entrepreneurs do the things differently or innovatively. As an entrepreneur if you have a new
product to offer, it is good but most start-ups have found innovative and creative ways in offering
the same products and services. This is called disruption. Paytm, Uber, Ola etc. are disruptions.

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

Q. 11 What is the significance of ToC?

Ans. A table of contents (ToC) contains the numbered list of topics in a document and the page
number on which they are located. In the soft copy of the document, each entry in the ToC
functions as an internal hyperlink to the topic content for easily jumping to the topics.

Q. 12 What is sub-total feature in a spreadsheet?

Ans. Subtotals feature is a quick way to calculate automatic subtotals, averages and other numeric
summary on a group of data. Subtotals works better on the sorted data. Some examples are: class-
wise total marks, depart-wise average salary, city-wise population count etc.

Q. 13 Anu has two sets of 10 marks each which she wants to apply on a dataset to analyse the
output to improve students’ performance in next exam. Write steps to help Anu apply these 2 sets
of scenarios one by one.

Ans. First, select all the marks in first data. Go to Tools menu > Scenarios option. In the Create
Scenarios dialog box, mention the name of the scenario (e.g., MARKLIST1) and click OK. Repeat the
same for MARKLIST2. Now she can select different scenarios form the drop-down to observe and
analyse the changing values.

Q. 14 List any 2 advantages of a database.

Ans. i. Security: To prevent unauthorized access to the database, DBMS uses features like
encryption, authentication, authorization and views to provide security to the database.

ii. Data Integrity: Data integrity is a set of rules that DBMS provides to see that data incorrect or
inconsistent data is not stored.

Q. 15 What is the role of ISP in accessing the internet?

Ans. Company or organisation that provides the access to internet. Access is provided through a
modem that connects your computer with the service providers internet server. Modem can be
wired (Digital Subscriber Line, dial-up, cables) or wireless (Wi-Fi, 3G/4G etc.)

Q. 16 What is Buddy system for workplace safety?

Ans. Buddy system is a risk control measure in workplace safety wherein two co-workers are
paired as part of safety management practice. Each member of the work group is observed by at
least one other employee in the work group.

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

Q. 17 What is a style? How is it different from a template? Discuss any 2 types of styles.

Ans. Styles are a pre-designed set of font, font-size, colour and other formatting which can be
applied on the document at once without having to format various parts of the content
 EDUSOFT IT SOLUTIONS PVT LTD.
individually. A standard word processor provides a library of pre-defined styles to apply on the
document in order to give it a professional look with least efforts.

Styles bring uniformity and consistency in the design of the document. They save time and effort
as we can create and save our own defined styles.

Styles keep the look and design of the text within a document. Templates are used to apply
consistent styles and

formatting across different document. Every new document can be based on a template. With
templates, we can reuse the settings of a document.

i. Paragraph styles affect an entire paragraph. They include various styles such as Appendix,
Bibliography etc.

ii. Page styles affect page formatting such as page size, page margins etc.

Q. 18 A worksheet has some values with font colour blue and cell fill colour yellow. Write steps to
create a macro to copy-paste only the values of these cells to another location in the same sheet.
(Hint: Use paste-special while pasting the data).

Ans. The required steps to create a macro to copy-paste only the values of these cells to another
location in the same sheet:

1. Go to Tools menu > Options option > In Options dialog box, LibreOffice > Advanced and select
Enable macro recording (may be limited) checkbox. Then, click OK.

Now, go to Tools menu > Macros > Record Macro option. The macro will begin recording with a
popup containing Stop Recording button.

2. Select the desired cells and press Ctrl+C.

3. Go to the target cell, right click and select Paste Special > Text.

4. Click on the Stop Recording button in the popup

Q. 19 Consider the table Game and answer the questions that follow:

a. Which player has the wins more than one and in which game?

b. What is the average best time of player P003?

c. Which games took min 3 and max 8 or attempts?

d. How many times has player P003 won game G004 and in how many attempts?

Ans. a. Select PlayerID, GameID from Game where Wins>1

b. Select average(BestTime) as “Average Best Time” from Game where PlayerID= ‘P003'
 EDUSOFT IT SOLUTIONS PVT LTD.
c. Select GameID from Game where Attempts between 3 and 8

d. Select Wins, Attempts from Game where PlayerID= ‘P003' and GameID= ‘G004'

Q. 20 How will you ensure that documents hyperlinked with the sheet are linked relatively?

Ans. To set up and insert relative hyperlinks, go to the Tools menu > Options option.

In the Options dialog box, go to Load/Save > General and check “Save URLs relative to file system”
and “Save URLs relative to internet” check boxes. Click OK.

To insert a hyperlink into the spreadsheet, do any of these:

Go to the desired cell or select the desired text. Then, Insert menu > Hyperlink option, or,

Click the Insert Hyperlink button on the Standard toolbar, or,

Drag-drop an item from the Navigator to the desired cell, or,

Type the target web address or URL or path to the target document at the point where you want
to insert the hyperlink.

Q. 21 Consider the following tables related with each other and answer the questions that follow:

The Query Design Grid is given here for your reference. For each of the
following question mention the part of grid and fill it with appropriate
value.

a. What is the rate per hour of the coders working on Project 1001?

b. How many hours has Coder with ID 9 has worked on the project
“Library”?

c. Display the names of coders worked on ProjectID 1002 and 1005 for
more than 10 hours.

Ans. a. Field: CoderID, CoderName, RatePerHour

Table: Coder for all fields

Field: ProjectID

Criterion below ProjectID: 1001

b. Field: CoderID, Hours_Worked

Table: Timesheet for all fields

Field: Project_Name
 EDUSOFT IT SOLUTIONS PVT LTD.
Table: Project

Criterion below CoderID: 9

Criterion below Project_Name: ‘Library’

c. Field: CoderName

Table: Coder

Field: ProjectID, Hours_Worked

Table: Timesheet

Criterion below ProjectID: 1002

Or condition below ProjectID: 1005

Criterion below Hours_Worked: >10

For Visually Impaired Students

Q. 21 List the general steps that to book a train ticket on IRCTC. Mention only main steps in brief.

Ans. 1. Open the browser and go to IRCTC website: https://www.irctc.co.in and login to your
account.

2. Fill in the details of your journey like cities to travel from and to, date of journey etc. Click on
Find trains.

3. The trains will be listed. Click on Check Availability to check the seats available and click on Book
Now.

4. Fill the passenger details, mobile number, captcha and click Continue Booking.

5. On payments page, select the suitable payment option and click on Make Payment.