Information Technology (SUBJECT CODE - 402)

Sample Question Paper 1 for Class X (Session 2025-2026)

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.

©Kips Learning Pvt Ltd. 2025 1

 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. Mohan, who recently moved from Egypt to Canada, speaks little English and struggles 1
to communicate effectively with his colleagues. This language difficulty causes frequent
misunderstandings and affects his work performance. This situation is an example of a:
a) Interpersonal barrier
b) Cultural barrier
c) Physical barrier
d) Linguistic barrier
ii. James has been consistently following a strict routine at work, always ensuring that he 1
meets deadlines and sticks to his schedule. However, he is now feeling mentally
drained and overwhelmed due to the rigid structure and lack of flexibility in his
approach. This is likely caused by an overemphasis on:
a) Stress
b) Discipline
c) Timeliness
d) Goal – Setting
iii. Maya wants to access websites and browse the internet on her computer. She opens a 1
software that allows her to search for information, view web pages, and interact with
online content. What is this software called?
a) Web Browsers
b) Designing Software
c) Office Software
d) Operating System
iv. To build a successful business, an entrepreneur must focus on providing high- 1
quality __________ that meet the needs of their target market. These offerings
should cater to customer demands and help differentiate the business from
competitors.
a) Satisfying human need
b) Product and Service
c) Calculated Risk
d) Regular Production
v. The Sustainable Development Goals (SDGs) are designed to address a wide range of 1
global challenges. Which of the following is not one of the SDGs focused on improving
the world for future generations?
a) Gender Equality
b) Affordable and Clean Energy
c) Climate Action
d) Industrial Growth
vi. The SMART method helps in setting effective goals for career and personal growth. In 1
this method, what does the ‘R’ stand for?
a) Realistic
b) Resourceful
c) Responsible
d) Relevant

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

i. Frame Styles are commonly used to format graphic and text frames, including text 1
wrap, borders, backgrounds, and columns. Which of the following tools would help
Ria format and apply consistent styles to text and graphic frames in her document?

a) Use Format Painter; stop it by pressing Ctrl + Shift + F

b) Use Style Inspector; stop it by clicking on Close
c) Use Frame Styles; stop it by selecting a different frame style
d) Use AutoFormat; stop it by closing the document

©Kips Learning Pvt Ltd. 2025 2

 ii. Ravi is working on a report where he needs to apply the same style to several 1
scattered paragraphs and headings throughout the document. Instead of selecting
each section individually and applying the style, he wants a quicker way to apply the
style to multiple areas at once. Which feature should Ravi use to streamline this
process?
a) Create New Style
b) Update Selected Style
c) AutoFormat
d) Fill Format
iii. Aarti is working on a document that includes several references to external websites 1
and email addresses. She wants to make it easy for readers to click on these
references and open them directly in their browser or email client. Which feature
should Aarti use to achieve this?
a) Index of Keywords
b) Hyperlink Tool
c) Table of Contents
d) Bookmark

iv. Assertion (A): A macro is a single instruction that executes a set of instructions. 1
Reason (R): These set of instructions can be a sequence of commands or keystrokes
that can be used for any number of times later.
a) Both A and R are true, and R is the correct explanation of A
b) Both A and R are true, but R is NOT the correct explanation of A
c) A is true, but R is false
d) A is false, but R is true

v. A manager wants to determine the sales target required to reach a specific profit in 1
a financial model. She knows the current sales figures and desired profit, but needs
to calculate the exact target sales figure that will achieve this goal. Which feature of
LibreOffice Calc will help her calculate this?
a) Data Consolidate
b) External References to other documents
c) What-if Scenarios
d) Goal Seek
vi. Which option should you choose to start tracking changes in a spreadsheet in 1
LibreOffice Calc?
a) Tools > Review Changes > Manage
b) File > Options > Track Changes
c) Edit > Track Changes > Record
d) View > Track Changes > Review

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

i. Ravi is working on a report in LibreOffice Writer and wants to ensure that the Table 1
of Contents (ToC) he generates is clear, well-organised, and easily accessible. Which
of the following characteristics is most important for a good Table of Contents?
a) It should include decorative borders and stylish fonts to make it look attractive.
b) It should be given after the title and copyright page.
c) It must be accurate and easily accessible.
d) It should be formatted with colourful fonts and complex styles.
ii. During an office inspection, it is noted that there are exposed electrical wires, and 1
some employees have their desks too close to heating devices, creating a fire risk.
Additionally, heavy objects are stored in unsafe locations, posing a risk of physical
injury. Which type of hazards are most relevant in this situation?
a) Physical and Fire Hazards
b) Ergonomic and Health Hazards
c) Chemical and Safety Hazards
d) Biological and Health Hazards
©Kips Learning Pvt Ltd. 2025 3
 iii. Which key is used to uniquely identify each record in a database table, ensuring that 1
no two records have the same value in this field?
a) Primary Key
b) Foreign Key
c) Composite Key
d) Candidate Key
iv. Which of the following is true, if a database field is defined as float? 1
a) Only whole numbers
b) Numbers with decimals, length 7, 1 decimal
c) Stores text and numbers
d) Numbers up to 100 digits
v. John, a database designer, is tasked with creating a system where multiple records 1
are associated with the same master file. The structure of the database is similar to
an inverted tree, where the master file is at the base, and the branches hold
information linked to the master. Which data model should John use for this
design?
a) Relational Data Model
b) Network Data Model
c) Hierarchical Data Model
d) All of these
vi. In the Query Design View of a database, what does the window consist of? 1
a) Navigation Pane and Query Preview
b) Objects Relationship Pane and Design Grid
c) Report Pane and Data Grid
d) Form Design Grid and SQL Pane

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

i. What is the shortcut key to start recording changes in a document when Track 1
Changes is activated?
a) Ctrl + Shift + T
b) Ctrl + Alt + N
c) Ctrl + Shift + C
d) Ctrl + N
ii. Ravi wants to summarize and analyze a large dataset in LibreOffice Calc, grouping 1
data from multiple categories and finding key trends. He wants a flexible way to
create summaries and view different perspectives of the data. Which feature should
he use?
a) Use Pivot Table
b) Use Consolidate with the "Link to source data" option enabled
c) Use Data Validation with "Cell Range" enabled
d) Use Scenario Manager with "Copy Results To" option

iii. Which of the following best describes Minimal Data Redundancy in a database? 1
a) Redundancy causes data inconsistencies
b) DBMS keeps all data at one location
c) Redundancy is controlled and minimised
d) Redundancy improves data retrieval speed
iv. During office work, employees are concerned about safety hazards, including the 1
risk of fire. Which approach is most effective in reducing this workplace hazard?
a) Conflict resolution training and promoting hobbies
b) Only installing ergonomic chairs
c) Providing fire extinguishers to ensure safety
d) Routine electrical inspections

©Kips Learning Pvt Ltd. 2025 4

 v. Rahul is working on a spreadsheet to calculate the monthly savings required to reach 1
a target amount for a vacation fund. The savings amount depends on the monthly
contribution, interest rate, and investment duration (in years). He fixes the interest
rate and the investment duration but wants the monthly contribution to be exactly
₹5,000. Which feature of Calc should he use, and why?
a) Goal Seek –because it adjusts the input (monthly contribution) to reach the exact
target output (₹5,000).
b) Scenario Manager – because it allows creating multiple possible outcomes with
different sets of inputs.
c) Consolidate – because it combines data from different sheets into one summary.
d) Data Validation – because it restricts the type of values that can be entered into a
cell.
vi. To prevent fire hazards, materials in a workplace are categorized based on their 1
combustion properties. Which of the following correctly identifies a fire class and its
associated material type?
a) Class A – Electrical fires; Class B – Combustible metals
b) Class C – Electrical fires; Class D – Wood, paper, and cloth
c) Class B – Flammable liquids and gases; Class A – Wood, paper, and cloth
d) Class D – Paper and cloth; Class C – Electrical equipment

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

i. Sneha needs to create multiple project reports, all of which require the same 1
header, footer, and formatting. Instead of applying these elements individually for
each report, which feature of LibreOffice Writer would allow her to automate this
process?
a) Template
b) Style Inspector
c) AutoFormat
d) Track Changes
ii. Which feature in LibreOffice helps users generate structured reports by selecting 1
fields from a database and applying predefined layouts?
a) Report Wizard
b) AutoFormat
c) Both a and b
d) Neither a nor b
iii. The primary purpose of conducting an evacuation drill in the workplace is to ensure 1
that employees are familiar with __________ and __________ in case of an
emergency.
a) fire extinguishers, safety protocols
b) emergency exits, evacuation procedures
c) safety equipment, fire alarms
d) office layout, first aid kits

iv. Priya notices a chemical spill in the laboratory. Which sequence of actions 1
demonstrates the correct approach to handling the spill according to safety
protocols?
a) Evacuate area → inform supervisor → clean up spill
b) Inform supervisor → evacuate area → clean up spill
c) Clean up spill → inform supervisor → evacuate area
d) Ignore the spill → continue work → report at the end of the day

©Kips Learning Pvt Ltd. 2025 5

 v. Raj works in a manufacturing plant where machine malfunctions, exposed wires, and 1
sharp tools are common hazards. Which of the following actions should he prioritise
to maintain a safe workspace?

a) Fix workstation, report wires, leave machine issues for technicians

b) Report machine issues, clean surfaces, remove sharp tools, and ensure safety
guards
c) Focus on personal workspace, ignore common areas, wait for technicians
d) Clean common areas, ignore machine problems
vi. A company’s HR team is preparing an employee performance review document. Two 1
team members, Mr. Arun and Ms. Neha, work on the same file separately
(Review_Arun.ods and Review_Neha.ods). Before finalising the report, the team
needs to:
1. Compare the differences in both versions.
2. Merge the approved changes into one final document.
As the data entry operator, which steps should you follow in LibreOffice Calc?
a) Directly open Review_Arun.ods and overwrite it with Review_Neha.ods.
b) Open Review_Arun.ods, use Compare Document to review differences, then
use Merge Document to finalise.
c) Open Review_Neha.ods and delete conflicting data manually.
d) Use only Merge Document, since it automatically compares files too.

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 Explain the three main parts of communication and their importance in ensuring 2
effective communication.
Q. 7 Ravi finds it difficult to manage his emotions when facing criticism at work. He often 2
becomes defensive and reacts angrily, which affects his relationships with colleagues.
What steps can Ravi take to improve his emotional intelligence and handle criticism
more constructively?
Q. 8 What is the primary difference between the life of an entrepreneur and that of his 2
corporate counterpart?
Q. 9 What are the key challenges faced in achieving sustainable development in relation 2
to food security and water management?
Q. 10 Amit is concerned about his personal and work data being compromised or attacked 2
by malware. What measures can he take to safeguard his data effectively?

©Kips Learning Pvt Ltd. 2025 6

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

Q. 11 Ravi is exploring formatting options in LibreOffice Writer. His teacher asked him to 2
describe two types of paragraph styles and one feature of each. What should Ravi
write?
Q. 12 a) What steps must you take before activating the Track Changes feature in 2
LibreOffice Calc?
b) How can you check if the "Edit Document" option is disabled in a shared
LibreOffice Calc spreadsheet?

Q. 13 Differentiate between a One-to-One relationship and a Many-to-One relationship in 2

a database.
Q. 14 What are the common causes of slips, trips, and falls in the workplace? 2

Q. 15 What is the purpose of using macros in LibreOffice applications? Mention two 2

scenarios in which macros can automate tasks and improve efficiency.
Q. 16 During a routine inspection, Rina discovers that a co-worker has come into contact 2
with a live electrical wire. What immediate actions should she take to safely assist
the victim without putting herself at risk?

Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 = 12 marks)
Q. 17 Case Study: 4
A graphic design team is working on creating a brochure in LibreOffice Writer for a
new product launch. The designer wants to ensure that the document looks visually
appealing and the images are well-integrated with the text. While designing, the team
faces the following challenges:
• In one section, the image and text are not aligned properly, causing a misaligned
layout.
• On the front page, the logo needs to be placed at the top-left corner and remain
in the same position regardless of text changes.
• In a product description section, the designer wants the text to wrap neatly
around the image on the right side, with no overlapping or awkward gaps.
• For a special offer section, the product image needs to appear on top of the text
so that it's the focal point.
a) Which feature should the team use to fix the issue of misaligned image and
text in the section?
b) Which setting will help the designer fix the logo at the top-left corner of the
front page, ensuring it stays in place when text is added or removed?
c) Which option will allow the text to wrap smoothly around the image in the
product description section?
d) What arrangement tool should the team use to ensure the product image
appears on top of all other elements in the special offer section?

©Kips Learning Pvt Ltd. 2025 7

 Q. 18 Consider the table below and answer the questions that follow: 4
Employee Name Employee ID Department Salary Date of Joining
John 1001 HR 50000 01/01/2020
Jack 1002 IT 60000 15/03/2019
Emily 1003 Sales 55000 20/06/2018
Robin 1004 IT 65000 10/07/2017
a) Name all the fields in the given table.
b) Which field should be made the primary key?
c) Suggest a possible alternate key, if any.
d) Explain how a primary key differs from a foreign key with an example.
Q. 19 Musculoskeletal problems, such as pain in the back, neck, and shoulders, can occur 4
due to prolonged sitting or poor ergonomics while working at a computer. List four
ways to prevent musculoskeletal problems while working on a computer.

Q. 20 Aakash is managing a library database in LibreOffice Base. He has a master table 4

called Books and a transaction table called BorrowedBooks.
a) What is referential integrity?
b) Aakash wants to ensure that if a book is being borrowed, it cannot be deleted
from the Books table. Which option should he use to enforce this?
c) If a BookID is changed in the Books table, how does the Update Cascade option
affect the BorrowedBooks table? Provide an example.
d) If the Set NULL option is used and a book record is deleted from the Books table,
what happens in the BorrowedBooks table? How is it different from the Set
Default option?

Q. 21 Case Study: 4
Neha is working on a financial analysis report in LibreOffice Calc that contains data
from multiple sheets. She wants to include external links to reference market data
from an online source. Initially, she uses an absolute hyperlink to link to a specific
market data file on her computer, but when she shares the report with her colleague,
the hyperlink is broken because the file path is different on their computer. Neha
then decides to use a relative hyperlink. She also discovers the Target in Document
feature, which allows her to link directly to a specific cell in a spreadsheet, and the
Link to External Data feature, which fetches live data from a stock market website
into her sheet.
a) Why did the absolute hyperlink fail when Neha shared the file, and how does a
relative hyperlink fix this issue?
b) How does the Target in Document option improve navigation within large
spreadsheets?
c) Neha wants her report to automatically update with real-time stock market data
when opened. Which feature should she use, and how does it benefit her report?
d) If Neha needs to modify or remove a hyperlink, what steps should she follow?

©Kips Learning Pvt Ltd. 2025 8