Preparing for the CBSE Class 10 Information Technology (Code 402) board examination requires smart practice along with a clear understanding of the syllabus. The CBSE Class 10 IT 402 Sample Question Paper 2025-26 with Solution is an essential resource for both students and teachers who aim to achieve better academic performance. Sample papers are designed according to the latest CBSE exam pattern, updated syllabus, and marking scheme, helping students become familiar with the real examination format. By solving these sample question papers regularly, students can improve their time management skills, boost confidence, and identify their strengths and weak areas before the final board exam.
For teachers, CBSE Class 10 IT 402 sample papers with solutions act as an excellent teaching aid to assess students’ preparation levels and guide them effectively. The detailed solutions help in explaining concepts clearly and making students understand the correct approach to answering different types of questions. These sample papers also help educators plan revision strategies, conduct mock tests, and provide focused practice sessions in the classroom. Overall, the CBSE Class 10 IT 402 Sample Question Paper 2025-26 with Solution is a valuable tool that bridges the gap between learning and exam performance, ensuring thorough preparation for success in the CBSE board exams.
CBSE Class 10 IT 402 Sample QP 2025-26 with Solution
You can download the free PDF of this sample pre-board question paper from our website and start practicing today. Download Link available in last.
CBSE Class 10 IT 402 Sample Question Paper Session (2025-26)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE - 402)
Sample Question Paper (SQP) Solution for Class X (Session 2025-2026)
Max. Time: 2 Hours
Max. Marks: 50
General Instructions:
- Please read the instructions carefully.
- This Question Paper consists of 21 questions in two sections: Section A & Section B.
- Section A has Objective type questions whereas Section B contains Subjective type questions.
- 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.
- All questions of a particular section must be attempted in the correct order.
- SECTION A - OBJECTIVE TYPE QUESTIONS (24 MARKS):
- This section has 05 questions.
- Marks allotted are mentioned against each question/part.
- There is no negative marking.
- Do as per the instructions given.
- SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS):
- This section has 16 questions.
- A candidate has to do 10 questions.
- Do as per the instructions given.
- 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) Aisha moved from Egypt to Germany for work but finds it difficult to adjust because she is not familiar with German customs and workplace etiquette, which affects her interactions with colleagues. This situation illustrates a:
a) Interpersonal barrier
b) Cultural barrier
c) Physical barrier
d) Linguistic barrier
ii) Rohan has been working long hours every day without a break. Over time, he starts experiencing headaches, anxiety, and fatigue. This is likely caused by prolonged:
a) Stress
b) Discipline
c) Timeliness
d) Goal – Setting
iii) When Ayaan switches on his computer, a particular software starts running automatically and manages all the hardware and other software. Which software is this?
a) Web Browsers
b) Designing Software
c) Office Software
d) Operating System
iv) An entrepreneur must be ready to take a _ and remain open to new ideas to grow their business.
a) Satisfying human need
b) Product and Service
c) Calculated Risk
d) Regular Production
v) The Sustainable Development Goals (SDGs) aim to tackle key challenges faced by businesses, governments, and society, such as:
a) Gender Equality
b) Energy & Climate Change
c) Biodiversity
d) All of the above
vi) The SMART method helps in setting effective goals for career and personal growth. In this method, what does the ‘A’ stand for?
a) Abrupt
b) Accountable
c) Achievable
d) Admirable
Q.2 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) Ria has a long document where she needs to apply the same paragraph style at multiple scattered locations. She wants to avoid the repetitive task of selecting each word/paragraph and applying the style separately. Which feature should she use, and how can she stop using it once she is done?
a) Use Fill Format option; stop it by clicking Fill Format button again or pressing Esc
b) Use AutoFormat; stop it by closing the document
c) Use Format Painter; stop it by pressing Ctrl+Shift+F
d) Use Style Inspector; stop it by clicking on Close
ii) Arjun wants to slightly change the formatting of a predefined paragraph style in his Writer document. He does not want to create a new style, but rather update the existing one so that the changes apply wherever that style is used. Which option should he choose after formatting the text?
a) Create New Style
b) Update Selected Style
c) AutoFormat
d) Fill Format
iii) Meena has prepared a project report with multiple headings and sub-headings. She wants to create a section at the beginning of the report that lists all topics in order and allows her to jump directly to any section by clicking on it. Which feature of Writer should she use?
a) Index of Keywords
b) Hyperlink Tool
c) Table of Contents
d) Bookmark
iv) Assertion (A): In LibreOffice Calc, a Macro can be created as a function to perform repetitive calculations for which no predefined function exists.
Reason (R): A function macro is written between Function and End Function statements, can accept arguments, perform operations, and return results.
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 teacher wants to prepare a summary report in LibreOffice Calc by calculating the average marks of students from two different spreadsheet files: X-A.ods and XB.ods. Which feature of Calc will help her achieve this?
a) Data Consolidate
b) External References to other documents
c) What-if Scenarios
d) Goal Seek
vi) Which menu path in LibreOffice Calc is used to accept or reject changes made in a shared spreadsheet?
a) Tools > Review Changes > Manage
b) File > Options > Track Changes
c) Edit > Track Changes > Manage
d) View > Track Changes > Review
Q.3 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) Rahul wants to generate a Table of Contents (ToC) in his LibreOffice Writer document. However, when he inserts the ToC, it appears empty. Which of the following is the MOST likely reason for this issue?
a) He did not protect the ToC against manual changes
b) He forgot to apply heading styles (Heading 1, Heading 2, etc.) to his document headings
c) He placed the cursor at the wrong location before inserting ToC
d) He did not rename the default title “Table of Contents” to “Contents”
ii) During an audit, it is observed that employees are sitting for long hours with poor posture, and the computer screens cause glare. Which hazards are most relevant here?
a) Physical and Fire Hazards
b) Ergonomic and Health Hazards
c) Chemical and Safety Hazards
d) Biological and Health Hazards
iii) In a database table, if more than one field is used together to uniquely identify a record, it is called:
a) Primary Key
b) Foreign Key
c) Composite Key
d) Candidate Key
iv) If a database field is defined as VARCHAR(50) and the user enters 20 characters, how much storage is allocated?
a) 50 bytes
b) 20 bytes
c) 64,000 bytes
d) 255 bytes
v) A database designer wants to create a system where multiple tables are connected, allowing retrieval of related data from these tables efficiently. Which data model should the designer use?
a) Relational Data Model
b) Network Data Model
c) Hierarchical Data Model
d) All of these
vi) The Query Design Window in LibreOffice Base is divided into how many parts?
a) One
b) Two
c) Three
d) Four
Q.4 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) Which keyboard shortcut is used to open the Templates dialog box in LibreOffice Writer to manage or set default templates?
a) Ctrl + Shift + T
b) Ctrl + Alt + N
c) Ctrl + Shift + N
d) Ctrl + N
ii) Rohit is analyzing sales data spread across four different sheets in LibreOffice Calc. He wants to combine the data into a single sheet to identify overall trends and relationships. He also wants any change in the source sheets to automatically update in the consolidated sheet. Which feature and option should he use?
a) Use Pivot Table with the “AutoFilter” option
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 statements about forms in a database is incorrect?
a) A form provides a user-friendly interface for entering and modifying data.
b) Each field control in a form consists of a label and a field value text box.
c) Forms can include graphics, titles, and additional text for better presentation.
d) Forms are used to permanently store data like tables.
iv) During office work, employees complain of stress due to long hours and conflicts with colleagues. Which approach is most effective in reducing this hazard?
a) Conflict resolution training and promoting hobbies
b) Only installing ergonomic chairs
c) Providing fire extinguishers
d) Routine electrical inspections
v) Ritika has created a spreadsheet to calculate the EMI for a car loan. The EMI depends on the loan amount, interest rate, and loan duration (years). She fixes the loan amount and interest rate, but wants the EMI to be exactly ₹12,000 per month. Which feature of Calc should she use, and why?
a) Goal Seek – because it adjusts the input (loan duration) to reach the exact target output (EMI = ₹12,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) Materials in a workplace are classified by risk to prevent fires. Which of the following correctly matches the material class with its description?
a) Class A – liquids, grease, and gas; Class B – wood, cloth, paper
b) Class C – electrical materials; Class D – volatile metals like magnesium and sodium
c) Class B – electrical equipment; Class C – paper and cloth
d) Class D – liquids and gas; Class A – electrical materials
Q.5 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) Sneha is preparing 10 different project reports for her company. Each report requires the same header with the company logo, a footer with the legal notice, and predefined formatting for headings and text. Instead of manually inserting and formatting these elements in each report, which feature of LibreOffice Writer should she use?
a) Styles
b) Macros
c) Templates
d) Table of Contents
ii) Which of the following components open along with the Report Wizard in LibreOffice Base?
a) Report Builder
b) Add Fields dialog box
c) Both a) and b)
d) Neither a) nor b)
iii) Rohini works as a floor manager. She has been assigned the task of conducting regular _____ to ensure the safety of life in case of any disaster or emergency by evacuating the place of danger.
a) Cultural assembly
b) Open house events
c) Evacuation drill
d) Trips and excursions
iv) Ramesh notices that a colleague has slipped and sustained a serious injury at work.
Which sequence of actions demonstrates the correct approach to handling the accident according to safety protocols?
a) Attend to injured person → inform supervisor → assist supervisor
b) Report to supervisor → attend to injured person → assist supervisor
c) Assist supervisor → attend to injured person → inform supervisor
d) Ignore minor injury → continue work → report at the end of the day
v) Sonia works in a busy office where spills, broken glass, and clutter are common. To maintain a safe and productive workplace, which combination of actions should she prioritize?
a) Clean her own workstation, report faulty lights, leave spills for cleaning staff
b) Clean her workstation, clear spaces around machines, immediately clean spills, report faulty lighting
c) Focus only on her own desk, ignore common areas, and wait for maintenance to fix lighting
d) Only clean common areas and ignore her personal workspace
vi) A company’s finance team is preparing the quarterly budget report. Two managers, Mr. Raj and Ms. Meera, work on the same spreadsheet file separately (Budget_Raj.ods and Budget_Meera.ods).
Now, before submitting the final report to the CEO, the team needs to:
1. Check the differences in both versions.
2. Merge the approved changes into one final file.
As the data entry operator, which steps will you follow in LibreOffice Calc?
a) Directly open Budget_Raj.ods and overwrite it with Budget_Meera.ods.
b) Open Budget_Raj.ods, use Compare Document to review differences, then use Merge Document to finalize.
c) Open Budget_Meera.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 (2X3=6 marks) Answer each question in 20 – 30 words.
Q. 6 Explain any two C’s of effective communication.
Ans: (i) Concise - Always use simple language and say only what is required.
(ii) Correct - Always use correct spelling and grammar in the sentences.
Q. 7 Maya often gets frustrated at work and reacts impulsively in stressful situations. She wants to improve her ability to handle emotions and respond calmly. Which steps can help her manage emotional intelligence effectively?
Ans: Maya can manage her emotional intelligence by following these steps:
- Understand her emotions - Reflect on her behavior and identify areas where she needs to improve, focusing on personal growth.
- Rationalize - Avoid quick reactions; analyze situations logically before responding.
- Practice - Stay calm through meditation, yoga, or other relaxation techniques.
Q. 8 Compare Self-Employment and Wage Employment.
Ans: Self-Employment: When a person works for themselves by starting a business or offering services (like shop owner, freelancer, tailor). They earn income from their own work.
Wage Employment: When a person works for someone else (company/organization) and gets a fixed salary or wages (like teacher, office worker, factory worker).
Q. 9 What are the major problems related to sustainable development concerning food and water?
Ans: Major Problems of Sustainable Development are:
Food: More land is being used for buildings and factories instead of farming, so less fertile land is left to grow crops like wheat and rice. Using too many chemical fertilizers damages the soil and reduces its natural nutrients.
Water: Rivers and ponds provide fresh water for drinking and daily use, but people throw garbage into them which pollutes the water. Polluted water can cause a shortage of clean and safe water in the future.
Q. 10 Sara is worried about her personal and work data being stolen or infected by viruses. What steps can she take to protect her data effectively?
Ans: Install antivirus and firewall - These tools help protect data from viruses and hackers.
Open only secure websites - Ensure website addresses start with https://, which indicates a secure site.
Answer any 4 out of the given 6 questions (2X4=8 marks) Answer each question in 20 – 30 words.
Q.11 Aarav is learning to format documents in LibreOffice Writer. His teacher asked him to explain any two style categories along with one feature of each. What should Aarav write?
Ans: Page Style - Controls overall page layout such as page size, margins, header, footer, footnote settings, borders, and background. A document can have multiple page styles.
Paragraph Style - Applies formatting to entire paragraphs. It includes alignment, line spacing, tab stops, borders, and may also include character attributes.
Q.12 (a) What must you do before enabling the Record Changes feature?
Ans: Disable Shared Spreadsheet mode.
(b) How can you confirm that sharing has been disabled in the spreadsheet?
Ans: The word (shared) disappears from the spreadsheet title bar.
Q.13 Differentiate between One-to-Many and Many-to-Many relationships in a database.
Ans: One-to-Many (1:N) Relationship: A one-to-many relationship occurs when one record in a table is related to multiple records in another table, but those multiple records are related to only one record in the first table.
Example: One teacher can teach multiple students.
Many-to-Many (M:N) Relationship: A many-to-many relationship occurs when multiple records in one table are related to multiple records in another table. This is usually implemented using a junction or bridge table.
Example: Students can enroll in multiple courses, and each course can have multiple students.
Q.14 What are the common causes of electrical hazards at the workplace? Suggest one safety measure to prevent them.
Ans: Causes: Exposed or worn-out wiring, overloading electrical outlets, ungrounded or faulty equipment, unsafe use of electrical devices.
Safety Measure: Provide basic training on electrical safety, keep water and food away from electrical equipment, and carry out routine inspections of wiring and equipment.
Q.15 What is a Macro? List any two real life situations where they can be used.
Ans: A macro is like an algorithm or a set of actions that we can use or run multiple times. A macro helps in automating or repeating tasks by recording or storing our input sequences like mouse strokes or keyboard presses.
Real-life uses:
1. Preparing a monthly sales report where the same formatting and calculations are applied every time.
2. Creating attendance sheets with repeated formatting and formulas.
Q.16 While inspecting a machine, Rohan notices a colleague stuck to a live wire. What steps should Rohan follow to safely rescue the victim?
Ans: Here are the safe steps Rohan should follow:
- Do not touch the victim directly or any conductive surfaces while they are energized.
- Switch off the electrical circuit if possible, or use non-conductive materials (like a wooden stick) to separate the victim from the conductor.
- Wear protective equipment such as gloves and shoes and ensure hands and feet are dry before attempting rescue.
- Call emergency services (108) immediately.
Answer any 3 out of the given 5 questions (4X3=12 marks) Answer each question in 50 – 80 words.
Q.17 Case Study
A publishing company is designing an e-magazine in LibreOffice Writer. The editor wants to insert images of articles and advertisements in such a way that the layout looks attractive and professional. While working, the team faces some challenges:
- In one article, two images overlap, and only part of the required picture is visible.
- For the cover page, the editor wants the main image to stay fixed in the center, no matter how much text is added or removed.
- In another section, the designer wants text to flow smoothly around the images so that the page looks balanced.
- For an advertisement, the client requests that the product image should appear above all other elements.
(a) Which feature should the team use to solve the problem of overlapping images?
Ans: Arrangement - It is used to manage overlapping images (e.g., Forward One, Back One, Send to Back, Bring to Front).
(b) Which setting will help the editor keep the main image fixed in the center of the cover page?
Ans: Anchoring & Alignment - Anchoring keeps the image fixed (to Page), and Alignment places it at the center.
(c) Which positioning option will make the text flow smoothly around the images in the article?
Ans: Text Wrapping - Options like Page Wrap or Optimal Page Wrap allow text to flow smoothly around the image.
(d) Which arrangement tool should be used to ensure the advertisement image appears above all other elements?
Ans: Bring to Front - This arrangement tool places the advertisement image above all other elements.
Q.18 Consider the table below and answer the questions that follow:
Student Name | Employee ID | Department | Salary |
|---|---|---|---|
Aryan Sharma | 101 | 10A | 450 |
Priya Singh | 102 | 10B | 470 |
Rohan Mehta | 103 | 10A | 480 |
Ananya Kapoor | 104 | 10C | 460 |
(a) Name all the fields in the given table.
Ans: Fields in the table are: Student Name, Roll Number, Class and Marks
(b) Which field should be made the primary key?
Ans: Roll Number - because each roll number in the table is unique and can identify a
record.
(c) Suggest a possible alternate key, if any.
Ans: Student Name could serve as an alternate key if no two students have the same name.
Ans: Student Name could serve as an alternate key if no two students have the same name.
(d) Explain how a primary key differs from a foreign key with an example.
Ans: Primary Key: It is a unique field in a table that identifies each record (no duplicate, no empty value). Example: StudentID in Student table.
Foreign Key: It is a field that links one table to the primary key of another table (can repeat). Example: StudentID in Marks table linking to Student table.
Q.19 Musculoskeletal problems affect different parts of the body like neck, back, chest, arms, shoulders, and feet. These problems happen due to wrong posture or uncomfortable chairs while working on a computer. List four ways to avoid this problem.
Ans: Ways to avoid musculoskeletal problems: (any 4)
- Keep the monitor at eye level and at arm’s length distance.
- Keep neck straight and monitor directly ahead.
- Sit with your back fully against the chair’s backrest.
- Adjust armrests so elbows are at 90° to110°.
- Keep hands slightly lower than elbows while typing.
- Avoid twisting your wrists
- Use a keyboard palm rest only when not typing.
Q.20 Ruhi is managing a Sports Day database in LibreOffice Base. She has a master table called EventCategory and a transaction table called Events.
(a) What is referential integrity? Give an example from Ruhi’s database.
Ans: It ensures that every foreign key in the transaction table matches a primary key in the master table. Example: If CategoryID C003 is in Events, it must exist in EventCategory.
(b) Ruhi wants to stop deletion of any category that is being used in the Events table. Which option should she use?
Ans: No Action: Prevents deletion of a master record if related records exist in the transaction table. This avoids breaking links or losing related data.
(c) If a CategoryID is changed in EventCategory, how does the Update Cascade option affect the Events table? Give an example.
Ans: Update Cascade: If a master record is updated, all related foreign key values in the transaction table are automatically updated. Example: If CategoryID C003 is changed to C010 in EventCategory, all Events records with C003 are updated to C010.
(d) If the Set NULL option is used and a master record is deleted, what happens in the Events table? How is it different from Set Default?
Ans: | Action | Description | Example Result |
|---|---|---|
| Set NULL | Related fields in the transaction table become NULL when master record is deleted or updated. | Events table CategoryID becomes NULL |
| Set Default | Related fields are set to a predefined default value when master record is deleted or updated. | Events table CategoryID becomes C001 (default value) |
Q.21 Arjun is preparing a project report in LibreOffice Calc that contains multiple spreadsheets. He wants smooth navigation between different sheets and also plans to include data from a government website. Initially, he uses an absolute hyperlink but later realizes it breaks when he shares the report with his teacher because the file path is different on another computer. His friend suggests trying a relative hyperlink instead. While inserting a hyperlink, Arjun notices the option Target in Document, which allows him to connect directly to a particular sheet. He also discovers the Link to External Data option to fetch live tables from a web page into his spreadsheet.
(a) Why did the absolute hyperlink fail when Arjun shared the file, and how does a relative hyperlink solve this problem?
Ans: The absolute hyperlink failed because it stored the complete path (specific to Arjun’s computer). On another system, the same path did not exist. A relative hyperlink solves this by linking relative to the folder where the spreadsheet is stored, so it works even if moved.
(b) How does the Target in Document option increase the usefulness of hyperlinks in large spreadsheets?
Ans: Target in Document helps by allowing navigation directly to a specific sheet, table, or section inside the document, saving time in large spreadsheets.
(c) Arjun wants to ensure that anyone viewing his report can update data directly from a government website. Which feature should he use, and why is it beneficial?
Ans: He should use Link to External Data, which imports live tables from a web page. This is beneficial because data stays updated automatically without manual entry.
(d) If Arjun wants to edit or remove a hyperlink later, what steps should he take?
Ans: Arjun should right-click the hyperlink → choose Edit Hyperlink to modify it or Remove Hyperlink to delete it.
Download Now - Class 10 IT 402 Sample Question Paper 2025-26 with Solution
