📋
IT 402 Question Paper 2026
Class 10 · Subject Code 402 · CBSE 2025–26
50Max Marks
2 HrsDuration
21Questions
2Sections A & B
NoNegative Marking
📌 General Instructions
- This paper has 21 questions in two sections: Section A and Section B.
- Section A — Objective Type Questions (24 marks): 5 questions.
- Section B — Subjective Type Questions (26 marks): 16 questions; attempt any 10.
- A candidate must answer (5 + 10) = 15 questions total in 2 hours.
- There is no negative marking.
- All questions of a section must be attempted in the correct order.
0
Attempted
0
Correct ✓
0
Wrong ✗
0%
Score
MCQ Progress0 / 0
Q14×1 = 4 MarksEmployability Skills
Answer any 4 out of the given 6 questions.
(i) Identify the imperative sentence:
- (A) Shut the front door.
- (B) She is a talented artist.
- (C) Are you feeling better?
- (D) You were amazing!
(ii) Breaking down big goals into smaller parts will make the goals ________.
- (A) Specific
- (B) Measurable
- (C) Achievable
- (D) Realistic
(iii) Define the term 'Time Management'.
(iv) What should a strong password consist of?
- (A) Only letters
- (B) Numbers and special characters
- (C) Name of a person
- (D) Letters, numbers and special characters
(v) A misconception about an entrepreneur is: Entrepreneurs are ________, not ________.
(vi) Choose the option which is NOT a Sustainable Development Goal according to the United Nations.
- (A) Population
- (B) No Poverty
- (C) Quality Education
- (D) Reduced Inequalities
Q25×1 = 5 MarksLibreOffice Writer
Answer any 5 out of the given 6 questions.
(i) Ramesh wants to apply a paragraph style to multiple non-contiguous sections. Which feature of LibreOffice Writer should he use?
- (A) Update Style
- (B) Fill Format
- (C) Drag and Drop
- (D) Load Styles
(ii) While working with images in LibreOffice Writer, ________ acts as a reference point for image or drawing.
- (A) Alignment
- (B) Grouping
- (C) Anchoring
- (D) Resizing
(iii) Which style category in LibreOffice Writer defines layout elements such as margins, headers, and footers?
- (A) Paragraph Style
- (B) Page Style
- (C) Frame Style
- (D) Table Style
(iv) LibreOffice Writer supports up to ________ levels of headings.
- (A) 9
- (B) 10
- (C) 11
- (D) 12
(v) Which image tool is used to change the image to black and white, grayscale or a watermark?
- (A) Image Crop
- (B) Image Mode
- (C) Image Align
- (D) Image Size
(vi) A ________ is a preset layout that helps to create professional and/or formal documents easily.
- (A) Template
- (B) Style
- (C) ToC
- (D) SoC
Q35×1 = 5 MarksLibreOffice Calc
Answer any 5 out of the given 6 questions.
(i) Ravi wants to test how changing the discount rate affects total revenue. Which feature should he use?
- (A) Sort
- (B) Indexing
- (C) What-if Scenarios
- (D) Filter
(ii) Priya notices some cells have been modified in a shared spreadsheet. Which feature helps identify the editor?
- (A) Data Validation
- (B) Track Changes
- (C) Observe Changes
- (D) AutoFilter
(iii) Which is the correct way to record a macro in LibreOffice Calc?
- (A) Tools → Macros → Record Macro
- (B) File → Options → Record Macro
- (C) Insert → Macro → Record
- (D) View → Macros → Record
(iv) Which is the default function when a Consolidate dialog box opens in LibreOffice Calc?
- (A) Average
- (B) Sum
- (C) Max
- (D) Var
(v) Which Calc feature allows multiple users to suggest edits while preserving original data?
- (A) Protect Sheet
- (B) Share Document
- (C) Track Changes
- (D) Insert Comments
(vi) In Calc, which type of hyperlink uses the complete location where the file is stored?
- (A) Absolute hyperlink
- (B) Mixed hyperlink
- (C) Relative hyperlink
- (D) Static hyperlink
Q45×1 = 5 MarksLibreOffice Base / DBMS
Answer any 5 out of the given 6 questions.
(i) In a database, a form is ________.
- (A) A tool used only for storing data in tables
- (B) An object with a user-friendly interface for data entry
- (C) A feature used to write queries
- (D) A chart to display statistical data
(ii) Which of the following is an example of a DBMS?
- (A) Ubuntu
- (B) MySQL
- (C) MS Word
- (D) Canva
(iii) While forming a relationship between two tables in LibreOffice Base, the ________ of the common field must be ________.
- (A) same, data type
- (B) data type, same
- (C) data type, different
- (D) primary key, same
(iv) Which advantage of DBMS ensures that changes in data are reflected across all tables?
- (A) Data Sharing
- (B) Organised Storage
- (C) Data Consistency
- (D) Minimal Data Redundancy
(v) Which best explains the use of a query in LibreOffice Base?
- (A) To store data in an organized format
- (B) To retrieve data from the database and display it in the desired format
- (C) To create tables
- (D) To design the layout of forms and reports
(vi) In ________ Data Model, data is stored in linked records organised into a tree-like structure.
- (A) Network
- (B) Relational
- (C) Fictional
- (D) Hierarchical
Q55×1 = 5 MarksWorkplace Safety & Health
Answer any 5 out of the given 6 questions.
(i) Arjun's colleague frequently complains of neck pain after long working hours. What is the most likely cause?
- (A) Poor lighting and ventilation
- (B) Improper ergonomic setup
- (C) Good lighting and ventilation
- (D) Using updated antivirus software
(ii) Which type of fire extinguisher should NOT be used to extinguish an electrical fire?
- (A) Carbon dioxide
- (B) Mechanical foam
- (C) Dry chemical powder
- (D) ABC dry powder
(iii) Which is the correct typing posture?
- (A) Fingers on home row keys (asdf/jkl), elbows by your sides
- (B) Fingers below spacebar and elbows extended outward
- (C) Keeping the wrist floating in the air
- (D) Leaning back while typing
(iv) A company provides adjustable desks and encourages hydration. What is the primary objective?
- (A) To reduce electricity bills
- (B) To improve employees' attendance
- (C) To promote employees' health and safety
- (D) To increase Internet speed
(v) Which type of hazards are most common in manufacturing and pharmaceutical industries?
- (A) Ergonomic hazards
- (B) Biological and chemical hazards
- (C) Noise hazards
- (D) Magnetic field hazards
(vi) Materials are classified by risk of catching fire. Which falls in Class B materials?
- (A) Wood
- (B) Magnesium
- (C) Grease
- (D) Electrical equipment
Instructions: Answer any 3 out of 5 questions on Employability Skills (Q6–Q10) — 3×2=6 marks. Then answer any 4 out of 6 questions from Q11–Q16 — 4×2=8 marks. Finally answer any 3 out of 5 questions from Q17–Q21 — 3×4=12 marks.
📚 Employability Skills — Q6 to Q10 (Answer any 3)
Q62 Marks
Write the 7 C's of Communication.
Q72 Marks
(a) What is emotional intelligence?
(b) Name any two skills included in emotional intelligence.
(b) Name any two skills included in emotional intelligence.
Q82 Marks
How do ICT skills help us in our day-to-day activities?
Q92 Marks
State the qualities to become a successful entrepreneur.
Q102 Marks
Define the term 'Sustainable Development'.
💻 IT Topics — Q11 to Q16 (Answer any 4)
Q112 Marks
What is the significance of the Table of Contents feature in LibreOffice Writer? Discuss briefly.
Q122 Marks
Briefly explain the purpose of the Subtotal tool in LibreOffice Calc.
Q132 Marks
Give any two prerequisites before consolidating data in Calc.
Q142 Marks
How are data and information different from each other? Explain with an appropriate example.
Q152 Marks
List two common causes of electrical accidents at the workplace. State any one measure to prevent them.
Q162 Marks
Briefly explain any two general emergency handling procedures at the workplace.
📝 Long Answer — Q17 to Q21 (Answer any 3, 50–80 words each)
Q174 Marks
You are designing a digital brochure for a school event in LibreOffice Writer.
(a) Mention any four ways by which an image file stored on the computer can be inserted into a document.
(b) How do "Wrap Off" and "Wrap Through" text wrapping options differ when placing images alongside text?
(a) Mention any four ways by which an image file stored on the computer can be inserted into a document.
(b) How do "Wrap Off" and "Wrap Through" text wrapping options differ when placing images alongside text?
Q184 Marks
Mr. Prasanna has two spreadsheets — Bill.ods (original) and Rev_Bill.ods (reviewed). Write the steps to compare these worksheets and identify the differences.
Q194 Marks
With reference to DBMS, answer the following questions:
(a) What is the purpose of using reports in DBMS?
(b) Can we generate a report from multiple tables?
(c) What is a dynamic report?
(d) In LibreOffice Base, to insert current date and time in a report header, what are the steps?
(a) What is the purpose of using reports in DBMS?
(b) Can we generate a report from multiple tables?
(c) What is a dynamic report?
(d) In LibreOffice Base, to insert current date and time in a report header, what are the steps?
Q204 Marks
Answer the following questions in the context of Workplace Safety:
(a) Mention any two health hazards caused by high contrast between computer screen and surroundings.
(b) Suggest one way to avoid contrast problems caused by bright light sources behind the display screen.
(c) How can poor sitting posture affect health?
(d) Mention any one way to reduce stress at the workplace.
(a) Mention any two health hazards caused by high contrast between computer screen and surroundings.
(b) Suggest one way to avoid contrast problems caused by bright light sources behind the display screen.
(c) How can poor sitting posture affect health?
(d) Mention any one way to reduce stress at the workplace.
Q214 Marks
An electronic gadget shop has a Gadgets table (ItemID-PK, ItemType, Size, Quantity, Price, Supplier) and a Bill table (BillNo-PK, ItemID, Price, CustName, CustPhoneNo). Answer:
(a) Name any two columns of Gadgets where duplicate values are allowed.
(b) Can we enter a new record with ItemID = I001 if it already exists? Justify.
(c) Can photos of products be stored? If yes, suggest a data type.
(d) Briefly explain referential integrity with respect to these tables.
(a) Name any two columns of Gadgets where duplicate values are allowed.
(b) Can we enter a new record with ItemID = I001 if it already exists? Justify.
(c) Can photos of products be stored? If yes, suggest a data type.
(d) Briefly explain referential integrity with respect to these tables.
✅
Section A — Quick MCQ Answer Key
All objective question answers at a glance
| Question | Answer | Topic |
|---|---|---|
| Q1(i) | A | Imperative sentence — gives a command |
| Q1(ii) | C | Breaking goals into parts → Achievable |
| Q1(iv) | D | Strong password = Letters + Numbers + Special chars |
| Q1(vi) | A | Population is NOT a UN SDG |
| Q2(i) | B | Fill Format — applies style to multiple sections |
| Q2(ii) | C | Anchoring — reference point for image/drawing |
| Q2(iii) | B | Page Style — controls margins, headers, footers |
| Q2(iv) | B | LibreOffice Writer supports 10 heading levels |
| Q2(v) | B | Image Mode — black & white / grayscale / watermark |
| Q2(vi) | A | Template — preset layout for formal documents |
| Q3(i) | C | What-if Scenarios — simulate different outcomes |
| Q3(ii) | B | Track Changes — identify who made edits |
| Q3(iii) | A | Tools → Macros → Record Macro |
| Q3(iv) | B | Sum is the default function in Consolidate |
| Q3(v) | C | Track Changes — multiple users suggest edits |
| Q3(vi) | A | Absolute hyperlink — stores complete file location |
| Q4(i) | B | Form — user-friendly interface for data entry |
| Q4(ii) | B | MySQL is an example of DBMS |
| Q4(iii) | B | Data type of common field must be same |
| Q4(iv) | C | Data Consistency — changes reflected across tables |
| Q4(v) | B | Query — retrieves data in desired format |
| Q4(vi) | D | Hierarchical model — tree-like structure |
| Q5(i) | B | Improper ergonomic setup causes neck/shoulder pain |
| Q5(ii) | B | Mechanical foam should NOT be used on electrical fire |
| Q5(iii) | A | Fingers on home row, elbows by sides = correct posture |
| Q5(iv) | C | Adjustable desks → promote health and safety |
| Q5(v) | C | Noise hazards — common in manufacturing/pharma |
| Q5(vi) | C | Grease = Class B material (flammable liquids) |
❓
Frequently Asked Questions
What is the paper pattern of CBSE IT 402 2026? ▼
IT 402 has 21 questions in two sections. Section A has 5 objective type questions worth 24 marks — each question has 6 sub-parts and you answer any 4 or 5. Section B has 16 subjective questions worth 26 marks — you answer any 10. Total marks: 50. Duration: 2 hours. No negative marking.
What are the 7 Cs of Communication? ▼
The 7 Cs of Communication are: Clear, Concise, Concrete, Correct, Coherent, Complete, and Courteous. These ensure that a message is effective, professional and well-understood by the receiver.
What is the difference between Wrap Off and Wrap Through in LibreOffice Writer? ▼
Wrap Off means the text does not flow around the image — text appears only above and below the image. Wrap Through means text flows directly over the image, passing through it. Wrap Through is useful for placing images as backgrounds or watermarks in a document.
What is referential integrity in DBMS? ▼
Referential integrity is a rule that ensures the foreign key in one table always refers to a valid existing record in the referenced (parent) table. For example, in a Bill table, the ItemID (foreign key) must always exist in the Gadgets table. You cannot add a billing record for an item that doesn't exist in Gadgets.
What is the CBSE Best of 5 rule and how does IT 402 help? ▼
CBSE's Best of 5 rule calculates your percentage using your 5 best-scoring subjects. IT 402 is a skill subject that many students find easy to score well in. If your IT 402 score is higher than your lowest-scoring main subject (like Maths or Science), IT 402 replaces it in the percentage calculation — potentially boosting your overall result significantly.
What is the correct way to record a macro in LibreOffice Calc? ▼
The correct path to record a macro in LibreOffice Calc is: Tools → Macros → Record Macro. This option allows you to record a series of actions which can then be replayed automatically. This is helpful for automating repetitive tasks.
🔗