CBSE Class 10 Information Technology Question Paper 2025 Solved Code 89

SECTION - A (Objective Type Questions)

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

(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 conveys a command, request, or instruction.
b) Option (A) gives a direct instruction to close the door.

(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) Dividing large objectives into bite-sized tasks makes them less intimidating.
b) This strategy helps ensure the targets can be successfully accomplished.

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

Answer: Time management refers to the capacity to schedule and regulate how you utilize your daily hours effectively to accomplish all desired tasks.

Teacher's Note:
a) Time management involves proper scheduling and organization of daily activities.
b) It ensures timely completion of work without feeling overwhelmed.

(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) Robust passwords combine multiple character sets to resist guessing.
b) Using letters, digits, and symbols creates high complexity.

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

Answer: born not made OR rich not poor

Teacher's Note:
a) People often falsely believe that successful business founders are solely born with traits.
b) Entrepreneurial skills can actually be learned and developed over time.

(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) Global sustainable targets focus on poverty alleviation and education quality.
b) Population control is not listed directly as one of the core United Nations sustainable development goals.

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

(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 helps apply a chosen style across scattered parts of a file.
b) It prevents the repetitive manual selection of styles.

(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 ties a graphic object to a specific paragraph or character.
b) It establishes the position marker for the visual element.

(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 styles control overall document layout dimensions.
b) Margins, headers, and footers are configured under page styling settings.

(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) Document outlines can be structured hierarchically.
b) Writer provides up to ten distinct heading tiers for indexing.

(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 tools alter the color properties of graphics.
b) Users can switch pictures to grayscale or watermark filters easily.

(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) Templates provide pre-formatted structures for quick documentation.
b) They ensure consistency in professional reports and files.

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

(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) Scenario tools evaluate different variable inputs to check results.
b) It helps predict financial outcomes based on modified data values.

(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 modifications made by different users.
b) It assists in identifying editors and review timestamps.

(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) Macro recording tools automate repetitive spreadsheet tasks.
b) The menu option is accessed under the Tools dropdown menu.

(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) Data consolidation aggregates values from multiple ranges.
b) Addition is pre-selected as the default mathematical operation.

(v) Which Calc feature allows multiple users to suggest edits while preserving the original data ? [1 Mark]
(A) Protect Sheet
(B) Share Document
(C) Track Changes
(D) Insert Comments

Answer: (D) Insert Comments

Teacher's Note:
a) Comments let reviewers leave feedback without altering cell contents.
b) Original values remain untouched while notes are added.

(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 paths contain the full storage directory structure.
b) They remain valid regardless of where the calling file is moved.

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

(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) Forms provide structured layouts for inputting database records.
b) They simplify data manipulation for end users.

(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 popular relational database management system.
b) It handles structured data storage and querying.

(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) Linked fields across tables must share matching data specifications.
b) Incompatible types will prevent successful relationship creation.

(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) Consistency guarantees uniform information updates everywhere.
b) It prevents conflicting records in related database tables.

(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 filter and extract specific database records.
b) They answer specific questions regarding stored information.

(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 models organize records in parent-child node arrangements.
b) This creates a distinctive tree-like data structure.

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

(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) Incorrect workstation alignment strains physical muscles.
b) Poor ergonomics often results in chronic neck and shoulder discomfort.

(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) Mechanical foam extinguishers contain water which conducts electricity.
b) Using them on live circuits poses severe electrocution hazards.

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

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

Teacher's Note:
a) Proper posture requires hands to rest gently over home keys.
b) Elbows should remain close to the body while typing.

(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) Workplace wellness policies prioritize worker well-being.
b) Adjustable desks and hydration prevent physical strain.

(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) Production plants deal heavily with chemical substances.
b) Handling medicinal compounds introduces biological and chemical risks.

(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) Solid wood falls under Class A while electrical gear forms Class C.

SECTION - B (Subjective Type Questions)

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

Answer: The seven foundational principles of effective communication are Clarity, Conciseness, Concreteness, Correctness, Coherence, Completeness, and Courtesy.

Teacher's Note:
a) These C's ensure messages are clearly understood.
b) They prevent misunderstandings during information exchange.

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

Answer: (a) Emotional intelligence refers to the capacity to recognize, comprehend, and regulate one's personal emotions alongside the feelings of others.
(b) Two key competencies include self-awareness and empathy.

Teacher's Note:
a) Emotional intelligence governs interpersonal relationships.
b) Self-awareness and empathy help in managing social interactions.

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

Answer: Information and Communication Technology competencies assist individuals in communicating efficiently, conducting daily business operations, and staying connected with family members through digital tools and applications.

Teacher's Note:
a) ICT tools streamline routine tasks and communication.
b) They enhance productivity in education and professional environments.

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

Answer: Essential traits of a thriving business founder include high self-confidence, strong perseverance, creativity, resilience in problem-solving, and a willingness to take calculated risks.

Teacher's Note:
a) Successful business leaders exhibit strong decision-making abilities.
b) They remain persistent through challenges and market uncertainties.

10. Define the term ‘Sustainable Development’. [2 Marks]

Answer: Sustainable development is defined as growth that fulfills present requirements without compromising the capability of future generations to meet their own vital needs.

Teacher's Note:
a) This concept balances economic progress with environmental care.
b) It preserves natural resources for upcoming generations.

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

Answer: The Table of Contents tool automatically generates an indexed summary using document headings. It enhances navigation by providing clickable links that take readers directly to specific sections instantly.

Teacher's Note:
a) It organizes lengthy documents for better readability.
b) Page numbers and headings update automatically when changes occur.

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

Answer: The Subtotal feature in Calc automatically groups spreadsheet rows and applies summary functions like sum or average on each group, facilitating rapid data analysis without manual filtering.

Teacher's Note:
a) Subtotals help summarize large sets of worksheet data.
b) It automates calculations for categorized entries.

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

Answer: Two key prerequisites for data consolidation are that corresponding data types must match across all sheets, and table structures must remain consistent in layout and labeling.

Teacher's Note:
a) Consistent formats prevent merging errors in Calc.
b) Range labels must align properly across worksheets.

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

Answer: Data consists of raw, unprocessed facts that lack meaning on their own, whereas information is processed data structured in a useful context. For example, a set of unorganized student scores represents data, while a final report card serves as information.

Teacher's Note:
a) Data is the input while information is the organized output.
b) Context transforms raw facts into meaningful insights.

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

Answer: Two common causes of electrical hazards are exposed worn-out wiring and overloading electrical outlets. A key preventive measure is ensuring proper earthing of all electrical equipment and replacing damaged cables immediately.

Teacher's Note:
a) Faulty insulation and overloaded sockets frequently trigger shocks.
b) Regular equipment inspections prevent workplace electrical mishaps.

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

Answer: Two crucial emergency protocols include evacuation, which involves safely leaving the premises following guided routes, and administering first aid supplies to treat minor injuries like cuts or burns.

Teacher's Note:
a) Emergency procedures protect staff during unexpected crises.
b) Clear evacuation routes minimize panic and injuries.

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

Answer: (a) Four methods to insert local images include using the Insert Image dialog, dragging and dropping the file, utilizing copy-paste commands, or inserting via the Gallery.
(b) "Wrap Off" places text strictly above and below the graphic with no side wrapping, whereas "Superimpose" or "Wrap Through" floats the image directly over the text, obscuring whatever lies beneath it.

Teacher's Note:
a) Multiple image insertion options provide flexibility for users.
b) Text wrapping controls how paragraphs flow around inserted graphics.

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 original spreadsheet file named Bill.ods.
2. Navigate to the top menu and select Edit, followed by Track Changes, and then click on Compare Document.
3. In the file selection window that appears, choose the reviewed file Rev_Bill.ods and click Open.
4. Review all highlighted modifications inside the Manage Changes window, and accept or reject edits as needed before closing.

Teacher's Note:
a) Document comparison tools highlight cell-by-cell discrepancies.
b) Managers can review team modifications efficiently.

19. 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 in a database ?
(c) What is a dynamic report ?
(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 ____________ > ____________
However, the correct menu item and option names are missing. Identify the correct menu item and option name needed to complete this task. [4 Marks]

Answer: (a) Reports present extracted database records in an organized, printable, and professional format.
(b) Yes, reports can pull data from multiple related tables.
(c) A dynamic report updates its displayed contents automatically whenever underlying source table records change.
(d) Insert, Date and Time.

Teacher's Note:
a) Reports format raw database queries for presentation.
b) Dynamic reports reflect real-time database modifications.

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.
(b) Suggest one way to avoid contrast problems caused by bright light sources behind the display screen.
(c) How can poor sitting posture while using a computer, affect a person’s health ?
(d) Mention any one way to reduce stress at the workplace. [4 Marks]

Answer: (a) High contrast lighting can cause eye fatigue and blurred vision.
(b) Installing window blinds or drapes helps eliminate excessive background glare.
(c) Incorrect seating posture leads to chronic muscle stiffness, back pain, and spinal problems.
(d) Taking regular short breaks helps significantly in lowering workplace stress levels.

Teacher's Note:
a) Proper ergonomic practices prevent long-term occupational injuries.
b) Managing environmental lighting reduces eye strain.

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.
(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.
(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.
(d) Briefly explain the principle of referential integrity with respect to the tables, Gadgets and Bill. [4 Marks]

Answer: (a) ItemType and Supplier.
(b) No, because ItemID is designated as a primary key and must contain unique values.
(c) Yes, binary data types like BINARY or LONGVARBINARY can be used.
(d) Referential integrity ensures that foreign key values match valid primary keys in related tables, meaning no bill can reference an ItemID that does not exist in the Gadgets inventory table.

Teacher's Note:
a) Primary keys prohibit duplicate entry values.
b) Referential integrity maintains valid relationships between tables.

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