CBSE CLASS 10th – INFORMATION TECHNOLOGY (402) | PRACTICE PAPER (Syllabus: 2025-26 | Based on 2024-25 Analysis)

SECTION A: OBJECTIVE TYPE QUESTIONS (24 Marks)

Q1. Answer any 4 out of 6 questions (1 x 4 = 4)

1. Identifying your strengths and weaknesses is a part of __________.
   (a) Self-awareness
   (b) Self-motivation
   (c) Self-regulation
   (d) Assertiveness.
2. Which of the following is an environment-friendly method of power generation?
   (a) Coal
   (b) Solar
   (c) Diesel
   (d) Natural Gas.
3. Name the shortcut key to help users with physical disabilities to use a keyboard.
4. A __________ type of communication involves the use of body language and facial expressions.
5. What is the shortcut for ‘Undo’ in most ICT applications?
6. Mention one role of an entrepreneur in society.

Q2. Answer any 5 out of 6 questions (1 x 5 = 5)

1. In LibreOffice Writer, which style affects the selected text within a paragraph, such as font size or bold properties?
   (a) Character Style
   (b) Frame Style
   (c) Page Style
   (d) List Style.
2. The __________ feature is used to apply styles to different areas of a document quickly by clicking.
3. To insert an image from a scanner, you use the __________ option under the Insert menu.
4. Which wrapping option allows the text to flow around the image?
5. You can create a new style by dragging and dropping a selection into the __________ window.
6. Anchoring an image to a __________ ensures that the image moves along with that specific text block.

Q3. Answer any 5 out of 6 questions (1 x 5 = 5)

1. Which tool is used to reach a specific target value by changing an input value?
   (a) Solver
   (b) Subtotals
   (c) Goal Seek
   (d) Scenarios.
2. To combine data from multiple worksheets into a single master sheet, we use __________.
3. A __________ hyperlink contains the full path to a file, starting from the root directory.
4. Which feature is used to record a sequence of keystrokes to automate a repetitive task?
5. The ‘Link to External Data’ option is used to fetch data from __________.
6. To see who made what changes in a shared spreadsheet, use the __________ feature.

Q4. Answer any 5 out of 6 questions (1 x 5 = 5)

1. In an RDBMS, a ‘Tuple’ refers to a __________.
   (a) Column
   (b) Row
   (c) Field
   (d) Data Type.
2. Which key uniquely identifies a record in a table?
3. What is the full form of SQL?
4. In LibreOffice Base, which view is used to define the structure of a table?
5. Which relationship is most common where a ‘Customer’ has many ‘Orders’?
   (a) 1:1
   (b) 1:N
   (c) N:N.
6. Name the object used to display data in a formatted, printable layout.

---

SECTION B: SUBJECTIVE TYPE QUESTIONS (26 Marks)

Q5. Answer any 3 out of 5 questions (Employability Skills) (2 x 3 = 6)

1. Give two examples of ‘Linguistic Barriers’ in communication.
2. List two benefits of ‘Working Independently’.
3. Explain the term ‘Sustainable Development’.
4. Differentiate between a ‘File’ and a ‘Folder’.
5. What do you mean by ‘Stress Management’?

Q6. Answer any 4 out of 6 questions (Short Answer Type) (2 x 4 = 8)

1. List any four categories of Styles available in LibreOffice Writer.
2. Explain ‘Grouping’ of drawing objects. Why is it useful?
3. Differentiate between ‘Consolidating Data’ and ‘Subtotals’ in a spreadsheet.
4. What is a ‘Foreign Key’? Explain with an example.
5. Mention any two common workplace hazards.
6. What is ‘Carpal Tunnel Syndrome’ and how can it be prevented?

Q7. Answer any 3 out of 5 questions (Long Answer/Case Study) (4 x 3 = 12)

1. Case Study (Documentation): Amrita is preparing a 100-page book. She needs to create a Table of Contents (ToC).
   (a) What is the prerequisite for generating a ToC automatically?
   (b) How can she update the ToC if she adds a new chapter later?
   (c) Mention any two wrapping options available for images.
2. Case Study: Sohan wants to analyze his business profits by changing different price points.
   (a) Which feature should he use: Scenarios or Goal Seek?
   (b) Explain the difference between Absolute and Relative Hyperlinks.
   (c) What is the advantage of using ‘Macros’ in a spreadsheet?
3. Database: Consider the table LIBRARY (BookID, Title, Author, Price, Qty). Write SQL queries for:
   (a) Display all books whose Price is greater than 500.
   (b) List all unique Authors available in the table.
   (c) Delete the record where BookID is ‘B101’.
   (d) Update the price of all books by adding a 10% discount.
4. Workplace Health : Rajesh spends 8 hours a day typing and suffers from wrist pain and eye strain.
   (a) Define the term ‘Ergonomics’.
   (b) Suggest two measures to avoid eye strain.
   (c) What are the immediate steps to be taken in case of an electrical fire at the workplace?
   (d) Why is it important to have an ‘Evacuation Policy’ in an organization?

---

Revision Tips:

Unit 4 (Health & Safety) is easy scoring. Make sure to learn the specific terms like “Occupational Overuse Syndrome” and “Ergonomics.”

Unit 3 (DBMS) carries the maximum weightage (12 marks). Focus on SQL commands and Relationships.