CBSE Class 10 Information Technology Question Paper 2026 Solved Code 89

SECTION A

(Objective Type Questions) (24 Marks)

1. Answer any 4 out of the given 6 questions on Employability Skills. [4x1=4]

(i) Identify the imperative sentence : [1 Mark]
(A) Shut the front door.
(B) She is a talented artist.
(C) Are you feeling better ?
(D) You were amazing !

Answer: (A) Shut the front door.

Teacher's Note:
a) An imperative sentence gives a command, request or instruction and often begins with a verb.
b) Statements, questions and exclamations are not imperative sentences.

(ii) Breaking down big goals into smaller parts will make the goals ___________. [1 Mark]
(A) specific
(B) measurable
(C) achievable
(D) realistic

Answer: (C) achievable

Teacher's Note:
a) Breaking goals into small steps makes them easier to accomplish, which is the meaning of achievable.
b) Remember the SMART goal framework: Specific, Measurable, Achievable, Realistic, Time-bound.

(iii) Define the term 'Time Management'. [1 Mark]

Answer: Time management means planning and organising your time properly so that you can complete your work well within the available time without stress.

Teacher's Note:
a) Mention both planning and controlling time as key ideas.
b) Examples like making a timetable can be added for clarity.

(iv) What should a strong password consist of ? [1 Mark]
(A) Only letters
(B) Numbers and special characters
(C) Name of a person
(D) Letters, numbers and special characters

Answer: (D) Letters, numbers and special characters

Teacher's Note:
a) A strong password combines multiple character types to resist guessing.
b) Avoid using personal names or simple words as passwords.

(v) A misconception about an entrepreneur is : Entrepreneurs are __________, not __________. [1 Mark]

Answer: Entrepreneurs are born, not made (the marking scheme also accepts "rich, not poor").

Teacher's Note:
a) This is a common misconception; entrepreneurial skills can actually be learned.
b) Focus on the exact wording expected in the blank.

(vi) Choose the option which is not a Sustainable Development Goal according to the United Nations. [1 Mark]
(A) Population
(B) No Poverty
(C) Quality Education
(D) Reduced Inequalities

Answer: (A) Population

Teacher's Note:
a) The UN has 17 SDGs; "Population" is not one of the listed goals.
b) Learn the names of the 17 SDGs for such questions.

2. Answer any 5 out of the given 6 questions. [5x1=5]

(i) Ramesh wants to apply a specific paragraph style to multiple non-contiguous sections of his document. Which feature of LibreOffice Writer should he use to avoid manually applying the style each time ? [1 Mark]
(A) Update Style
(B) Fill Format
(C) Drag and Drop
(D) Load Styles

Answer: (B) Fill Format

Teacher's Note:
a) Fill Format lets you copy a style and apply it repeatedly like a paint brush.
b) Do not confuse it with Update Style, which changes the style definition itself.

(ii) While working with images in LibreOffice Writer, __________ acts as a reference point for image or drawing. [1 Mark]
(A) Alignment
(B) Grouping
(C) Anchoring
(D) Resizing

Answer: (C) Anchoring

Teacher's Note:
a) Anchoring fixes an image's reference point to a page, paragraph or character.
b) The anchor decides how the image moves when text changes.

(iii) Which of the following style categories in LibreOffice Writer is used to define layout elements such as margins, headers, and footers ? [1 Mark]
(A) Paragraph Style
(B) Page Style
(C) Frame Style
(D) Table Style

Answer: (B) Page Style

Teacher's Note:
a) Page Style controls the overall page layout including margins, headers and footers.
b) Paragraph Style only affects text formatting, not page layout.

(iv) LibreOffice Writer supports up to __________ levels of headings. [1 Mark]
(A) 9
(B) 10
(C) 11
(D) 12

Answer: (B) 10

Teacher's Note:
a) Remember this exact number as it is frequently asked.
b) Heading levels help build an automatic Table of Contents.

(v) Which of the following image tools is used to change the image to black and white, grayscale or a watermark ? [1 Mark]
(A) Image Crop
(B) Image Mode
(C) Image Align
(D) Image Size

Answer: (B) Image Mode

Teacher's Note:
a) Image Mode changes the colour appearance of an inserted image.
b) Crop and Size only change the visible portion or dimensions of an image.

(vi) A __________ is a preset layout that helps to create professional and/or formal documents easily. [1 Mark]
(A) Template
(B) Style
(C) ToC
(D) SoC

Answer: (A) Template

Teacher's Note:
a) A template stores a ready-made layout, formatting and structure for quick document creation.
b) Styles apply formatting to text, not the whole document layout.

3. Answer any 5 out of the given 6 questions. [5x1=5]

(i) Ravi is analysing monthly sales data in Calc. He wants to test how changing the discount rate affects total revenue. Which feature should he use to simulate different outcomes ? [1 Mark]
(A) Sort
(B) Indexing
(C) What-if Scenarios
(D) Filter

Answer: (C) What-if Scenarios

Teacher's Note:
a) What-if Scenarios let you test different input values and see their effect on results.
b) Sort and Filter only rearrange or hide data, they do not simulate outcomes.

(ii) While reviewing a shared spreadsheet, Priya notices that some cells have been modified, but she's unsure who made the changes. Which feature should she use to identify the editor ? [1 Mark]
(A) Data Validation
(B) Track Changes
(C) Observe Changes
(D) AutoFilter

Answer: (B) Track Changes

Teacher's Note:
a) Track Changes records who edited which cell and when.
b) "Observe Changes" is not an actual Calc feature, so it can be eliminated.

(iii) Which of the following is the correct way to record a macro in LibreOffice Calc ? [1 Mark]
(A) Tools → Macros → Record Macro
(B) File → Options → Record Macro
(C) Insert → Macro → Record
(D) View → Macros → Record

Answer: (A) Tools → Macros → Record Macro

Teacher's Note:
a) Macros are always accessed through the Tools menu in LibreOffice.
b) Recording a macro captures a sequence of actions for reuse.

(iv) Which one of the following is the default function when a Consolidate dialog box opens in LibreOffice Calc ? [1 Mark]
(A) Average
(B) Sum
(C) Max
(D) Var

Answer: (B) Sum

Teacher's Note:
a) Sum is the default consolidation function, though it can be changed.
b) Consolidation combines data from multiple ranges or sheets into one.

(v) Which Calc feature allows multiple users to suggest edits while preserving the original data ? [1 Mark]
(A) Data Validation
(B) Track Changes
(C) Observe Changes
(D) AutoFilter

Answer: (D) Insert Comments

Teacher's Note:
a) The marking scheme gives Insert Comments as the answer for this question.
b) Comments let reviewers suggest edits as notes without changing the actual cell data.

(vi) In Calc, which of the following types of hyperlink uses the complete location where the file to be linked is stored ? [1 Mark]
(A) Absolute hyperlink
(B) Mixed hyperlink
(C) Relative hyperlink
(D) Static hyperlink

Answer: (A) Absolute hyperlink

Teacher's Note:
a) Absolute hyperlinks store the full path of a file.
b) Relative hyperlinks store the path in relation to the current document's location.

4. Answer any 5 out of the given 6 questions. [5x1=5]

(i) In a database, a form is __________. [1 Mark]
(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

Answer: (B) an object with a user-friendly interface for data entry

Teacher's Note:
a) A form makes data entry easier and more user-friendly than direct table entry.
b) Forms are used to enter or view data, not to write queries.

(ii) Which of the following is an example of a DBMS ? [1 Mark]
(A) Ubuntu
(B) MySQL
(C) MS Word
(D) Canva

Answer: (B) MySQL

Teacher's Note:
a) MySQL is a database management system used to store and manage data.
b) Ubuntu is an operating system, MS Word and Canva are not DBMS software.

(iii) While forming a relationship between two tables in LibreOffice Base, the __________ of the common field must be __________. [1 Mark]
(A) same, data type
(B) data type, same
(C) data type, different
(D) primary key, same

Answer: (B) data type, same

Teacher's Note:
a) The common field's data type must match in both tables for a relationship to work.
b) Field names can differ, but data types must be compatible.

(iv) Which of the following advantages of DBMS ensures that changes in data are reflected across all tables ? [1 Mark]
(A) Data Sharing
(B) Organised Storage
(C) Data Consistency
(D) Minimal Data Redundancy

Answer: (C) Data Consistency

Teacher's Note:
a) Data Consistency means the same data value is reflected everywhere it is used.
b) This is different from Minimal Redundancy, which only avoids duplicate storage.

(v) Which of the following best explains the use of a query in LibreOffice Base ? [1 Mark]
(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

Answer: (B) To retrieve data from the database and display it in the desired format

Teacher's Note:
a) Queries fetch specific data based on set conditions.
b) Tables store data, while queries only retrieve and display it.

(vi) In __________ Data Model, the data is stored in the form of linked records, organised into a tree-like structure. [1 Mark]
(A) Network
(B) Relational
(C) Fictional
(D) Hierarchical

Answer: (D) Hierarchical

Teacher's Note:
a) Hierarchical model arranges data like a tree with parent-child relationships.
b) Network model uses a graph-like structure instead of a strict tree.

5. Answer any 5 out of the given 6 questions. [5x1=5]

(i) Arjun notices that his colleague frequently complains of neck pain and sore shoulders after long working hours. Which of the following is the most likely cause ? [1 Mark]
(A) Poor lighting and ventilation
(B) Improper ergonomic setup
(C) Good lighting and ventilation
(D) Using updated antivirus software

Answer: (B) Improper ergonomic setup

Teacher's Note:
a) Neck and shoulder pain are typical symptoms of poor ergonomic workstation design.
b) Good lighting or antivirus software has no link to musculoskeletal pain.

(ii) Which of the following types of fire extinguishers should not be used to extinguish an electrical fire ? [1 Mark]
(A) Carbon dioxide
(B) Mechanical foam
(C) Dry chemical powder
(D) ABC dry powder

Answer: (B) Mechanical foam

Teacher's Note:
a) Foam extinguishers conduct electricity and are unsafe for electrical fires.
b) CO2 and dry powder extinguishers are safe for electrical fires.

(iii) Which of the following is the correct typing posture ? [1 Mark]
(A) When your elbows are by your sides, fingers should be above the home position (asdf and jkl; keys) on the keyboard.
(B) Fingers below the space bar and elbows extended outward
(C) Keeping the wrist floating in the air
(D) Leaning back while typing

Answer: (A) When your elbows are by your sides, fingers should be above the home position (asdf and jkl; keys) on the keyboard.

Teacher's Note:
a) Correct posture keeps elbows close to the body and fingers on the home row.
b) Floating wrists or leaning back can cause strain and fatigue.

(iv) A company mandates regular breaks, provides adjustable desks, and encourages hydration for its employees. What is the primary objective of these policies ? [1 Mark]
(A) To reduce electricity bills
(B) To improve employees' attendance
(C) To promote employees' health and safety
(D) To increase Internet speed

Answer: (C) To promote employees' health and safety

Teacher's Note:
a) Breaks, adjustable desks and hydration all directly support employee wellbeing.
b) These measures are examples of ergonomic and health-focused workplace policies.

(v) Which type of hazards are most common in the manufacturing and pharmaceutical industries ? [1 Mark]
(A) Ergonomic hazards
(B) Biological and chemical hazards
(C) Noise hazards
(D) Magnetic field hazards

Answer: (B) Biological and chemical hazards

Teacher's Note:
a) These industries handle chemicals and biological materials regularly, raising this risk.
b) Noise and ergonomic hazards can occur but are not the most common here.

(vi) Materials are classified by risk of catching fire. Which of the following falls in the category of Class B materials ? [1 Mark]
(A) Wood
(B) Magnesium
(C) Grease
(D) Electrical equipment

Answer: (C) Grease

Teacher's Note:
a) Class B fires involve flammable liquids and greases.
b) Wood is Class A, metals like magnesium are Class D, and electrical equipment is Class C.

SECTION B

(Subjective Type Questions) (26 Marks)

Answer any 3 out of the given 5 questions on Employability Skills. Answer each question in 20 - 30 words. [3x2=6]

6. Write the 7 C's of Communication. [2 Marks]

Answer:
1. Clear
2. Concise
3. Concrete
4. Correct
5. Coherent
6. Complete
7. Courteous

Teacher's Note:
a) Remember the 7 C's using the mnemonic "3 C's, Correct, Coherent, Complete, Courteous".
b) Full marks are given even for stating any two correct C's.

7. (a) What is emotional intelligence ? [1 Mark]
(b) Name any two skills included in emotional intelligence. [1 Mark]

Answer:
1. Emotional intelligence is the ability to identify and manage one's own emotions as well as understand and respond to the emotions of others.
2. Two skills included in emotional intelligence are self-awareness and empathy.

Teacher's Note:
a) Mention both self-management and understanding others in the definition.
b) Other valid skills include motivation, managing emotions and social skills.

8. How do ICT skills help us in our day-to-day activities ? [2 Marks]

Answer:
1. ICT skills help us communicate easily, run our business and stay connected with family and friends.
2. They also help in education, online services like banking and shopping, and improve our overall work efficiency.

Teacher's Note:
a) Give real-life examples like online banking or video calls for clarity.
b) Link ICT skills to staying updated with the latest technology.

9. State the qualities to become a successful entrepreneur. [2 Marks]

Answer:
1. A successful entrepreneur should be confident and willing to take risks.
2. They should also be hardworking, creative and able to solve problems effectively.

Teacher's Note:
a) Any two relevant qualities such as patience, leadership or decision-making are also accepted.
b) Link each quality briefly to why it helps in business.

10. Define the term 'Sustainable Development'. [2 Marks]

Answer: Sustainable development means using resources wisely today, meeting present needs without compromising the ability of future generations to meet their own needs, while balancing economic growth, environment and social well-being.

Teacher's Note:
a) Mention the balance between economic, social and environmental factors.
b) You may also refer to the 17 SDGs as examples.

Answer any 4 out of the given 6 questions in 20 - 30 words each. [4x2=8]

11. What is the significance of the Table of Contents feature in LibreOffice Writer ? Discuss briefly. [2 Marks]

Answer:
1. Table of Contents automatically inserts an index of headings and sub-headings from the document.
2. Its entries are hyperlinked, allowing readers to click and navigate directly to any topic, saving time in long documents.

Teacher's Note:
a) Mention that it updates automatically when headings change.
b) Useful for large documents such as reports and projects.

12. Briefly explain the purpose of the Subtotal tool in the LibreOffice Calc software. [2 Marks]

Answer:
1. The Subtotal tool automatically groups data and calculates summary values like sum, average or count for each group.
2. It saves time by avoiding manual filtering, allowing easy analysis of grouped data.

Teacher's Note:
a) Mention that a category column is needed for grouping.
b) Different summary functions can be applied to different columns.

13. Give any two prerequisites before consolidating data in Calc. [2 Marks]

Answer:
1. The corresponding data types should match across all the sheets to be consolidated.
2. The labels and structure of the tables used for consolidation should be consistent across all sheets.

Teacher's Note:
a) The first column is usually used as the primary column for consolidation.
b) Mismatched labels or data types can cause errors in consolidation.

14. How are data and information different from each other ? Explain with an appropriate example. [2 Marks]

Answer:
1. Data are raw, unprocessed facts that are meaningless on their own, such as marks obtained and roll numbers of students.
2. Information is processed data that is meaningful and useful, such as a report card prepared from that data.

Teacher's Note:
a) Always give an example along with the definition for full marks.
b) Remember: Data + Processing = Information.

15. List two common causes of electrical accidents at the workplace. State any one measure to prevent them. [2 Marks]

Answer:
1. Exposed or worn-out wiring and overloading of electrical outlets are common causes of electrical accidents.
2. One preventive measure is to carry out routine inspection of wiring and replace damaged wires immediately.

Teacher's Note:
a) Other causes include wet hands or lack of proper earthing.
b) Preventive measures also include using ISI-marked equipment and avoiding overloaded sockets.

16. Briefly explain any two general emergency handling procedures at the workplace. [2 Marks]

Answer:
1. First Aid: Keeping accessible supplies to treat minor injuries such as cuts, burns and muscle cramps.
2. Evacuation: Safely leaving the premises during an emergency under proper guidance, using stairs instead of lifts.

Teacher's Note:
a) Other procedures include routine inspection of electrical devices and conducting mock drills.
b) Emphasise staying calm and not spreading rumours during an emergency.

Answer any 3 out of the given 5 questions in 50 - 80 words each. [3x4=12]

17. 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. [2 Marks]
(b) How do the "Wrap Off" and "Wrap Through" text wrapping options differ when placing images alongside text in Writer ? [2 Marks]

Answer:
1. An image file can be inserted using the Insert Image dialog.
2. It can also be inserted using the Drag and Drop option.
3. It can be inserted using the Cut, Copy and Paste option.
4. It can also be inserted by linking the file or using the Gallery option.
5. In "Wrap Off", the text is placed above and below the image, with no wrapping around it.
6. In "Wrap Through", the image is superimposed on the text, so the image floats over the text and hides it.

Teacher's Note:
a) List exactly four distinct methods for part (a) to score full marks.
b) For part (b), clearly contrast how each option treats the surrounding text.

18. Mr. Prasanna, a General Manager in a multinational company, has been given two spreadsheets : an original billing file Bill.ods and a reviewed version of the same spreadsheet Rev_Bill.ods. Both contain customer billing details prepared by different teams. Write the steps he should follow to compare these worksheets and identify the differences between them. [4 Marks]

Answer:
1. Open the spreadsheet file Bill.ods.
2. Click on Edit → Track Changes → Compare Document.
3. In the Compare to dialog window, select the spreadsheet file Rev_Bill.ods to be compared, then click the Open button.
4. The Manage Changes dialog window appears; after reviewing and accepting or rejecting the changes, click Close to finish.

Teacher's Note:
a) The Compare Document feature under Track Changes is the key step to remember.
b) Each correctly ordered step earns one mark, so sequence matters.

19. With reference to DBMS, answer the following questions :
(a) What is the purpose of using reports in DBMS ? [1 Mark]
(b) Can we generate a report from multiple tables in a database ? [1 Mark]
(c) What is a dynamic report ? [1 Mark]
(d) In LibreOffice Base, to insert the current date and time in a report, the steps to be followed are :
Step 1 : Page Header area को एक्टीवेट करने के लिए इसके अंदर क्लिक (click) कीजिए ।
Step 2 : Click ____________ > ____________
However, the correct menu item and option names are missing. Identify the correct menu item and option name needed to complete this task. [1 Mark]

(a) What is the purpose of using reports in DBMS ? [1 Mark]

Answer: A report is a useful feature of a DBMS used to present retrieved data in a well-organised, formatted and printable manner for analysis and decision-making.

Teacher's Note:
a) Emphasise that reports are for viewing/printing, not for editing data.
b) Mention their use in decision-making.

(b) Can we generate a report from multiple tables in a database ? [1 Mark]

Answer: Yes, a report can be generated from multiple tables in a database.

Teacher's Note:
a) This is possible using a query that joins multiple tables as the report's data source.
b) A one-word "Yes" with brief justification is sufficient.

(c) What is a dynamic report ? [1 Mark]

Answer: A dynamic report is one in which the report automatically changes whenever the field values in the underlying base table or query change.

Teacher's Note:
a) Contrast this with a static report, which does not update automatically.
b) Mention that refreshing or reloading shows the latest updates.

(d) In LibreOffice Base, to insert the current date and time in a report, the steps to be followed are : Step 1 : Click inside the Page Header area to activate it. Step 2 : Click ____________ > ____________. Identify the correct menu item and option name needed to complete this task. [1 Mark]

Answer: Click Insert > Date and Time.

Teacher's Note:
a) The Insert menu contains the Date and Time option for reports.
b) This must be inserted only after activating the Page Header area.

20. Answer the following questions in the context of Workplace Safety :
(a) Mention any two health hazards caused by a high contrast between the computer screen and its surroundings. [1 Mark]
(b) Suggest one way to avoid contrast problems caused by bright light sources behind the display screen. [1 Mark]
(c) How can poor sitting posture while using a computer, affect a person's health ? [1 Mark]
(d) Mention any one way to reduce stress at the workplace. [1 Mark]

(a) Mention any two health hazards caused by a high contrast between the computer screen and its surroundings. [1 Mark]

Answer: Two health hazards are eye strain and headaches.

Teacher's Note:
a) Other accepted answers include dry eyes, blurred vision and mental fatigue.
b) High contrast forces the eyes to adjust repeatedly, causing strain.

(b) Suggest one way to avoid contrast problems caused by bright light sources behind the display screen. [1 Mark]

Answer: Use blinds or drapes on windows to block bright light from behind the screen.

Teacher's Note:
a) Other valid answers include adjusting screen brightness or using an anti-glare filter.
b) The goal is to reduce the light difference between the screen and background.

(c) How can poor sitting posture while using a computer, affect a person's health ? [1 Mark]

Answer: Poor sitting posture can cause back pain, muscle stiffness and spinal problems over time.

Teacher's Note:
a) Other accepted effects include wrist strain and poor blood circulation.
b) Link this to the need for proper ergonomic seating.

(d) Mention any one way to reduce stress at the workplace. [1 Mark]

Answer: Taking short breaks between work is one effective way to reduce workplace stress.

Teacher's Note:
a) Other accepted answers include maintaining work-life balance or practising deep breathing.
b) Any one relevant, practical suggestion earns full marks.

21. An electronic gadget shop keeps records of its electronic products, such as mobile phones, laptops, etc., in a table named Gadgets, which has columns for ItemID (Primary key), ItemType (mobile, iPad, Laptop), Size, Quantity, Price and Supplier. It also stores the billing data in another table named Bill, which has columns as BillNo (Primary key), ItemID, Price, CustName and CustPhoneNo. Based on the above, answer the following questions :
(a) Name any two columns of the Gadgets table where duplicate values are allowed. [1 Mark]
(b) Assume that the table Gadgets already contains a product having value of ItemID as I001. Can we enter a new record with value of ItemID as I001 ? Justify. [1 Mark]
(c) Is it possible to store photos of the products in a new column of the table, Gadgets ? If yes, then suggest a suitable data type to store images. [1 Mark]
(d) Briefly explain the principle of referential integrity with respect to the tables, Gadgets and Bill. [1 Mark]

(a) Name any two columns of the Gadgets table where duplicate values are allowed. [1 Mark]

Answer: ItemType and Supplier are two columns of the Gadgets table where duplicate values are allowed.

Teacher's Note:
a) Any non-primary-key column such as Size, Quantity or Price is also acceptable.
b) Only the primary key column, ItemID, cannot have duplicate values.

(b) Assume that the table Gadgets already contains a product having value of ItemID as I001. Can we enter a new record with value of ItemID as I001 ? Justify. [1 Mark]

Answer: No, we cannot enter a new record with ItemID as I001, because ItemID is the primary key of the Gadgets table and primary key values must be unique.

Teacher's Note:
a) A primary key never allows duplicate or null values.
b) Always justify "No" answers by referring to the primary key rule.

(c) Is it possible to store photos of the products in a new column of the table, Gadgets ? If yes, then suggest a suitable data type to store images. [1 Mark]

Answer: Yes, it is possible; a suitable data type to store images is BINARY or LONGVARBINARY.

Teacher's Note:
a) Image data is stored as binary data, not as text or number types.
b) Different database software may name this data type slightly differently.

(d) Briefly explain the principle of referential integrity with respect to the tables, Gadgets and Bill. [1 Mark]

Answer: Referential integrity ensures that a foreign key value in one table must match a primary key value in another table, so if an ItemID does not exist in the Gadgets table, it should not appear in the Bill table either.

Teacher's Note:
a) Identify ItemID as the foreign key link between Gadgets and Bill.
b) Referential integrity prevents orphan records that reference non-existent data.

Please click the link below to download pdf file of CBSE Class 10 Information Technology Question Paper 2026 Solved Code 89