CBSE Class 10 IT 402 Sample Practice Paper Set 1 (2026-27) with Marking Scheme
SAMPLE PRACTICE QUESTION PAPER -SET 1
SESSION: 2026-27
| CLASS: X | SUBJECT: INFORMATION TECHNOLOGY (402) |
| TIME: 2 HOURS | M.M: 50 |
General Instructions:
1. Please read the instructions carefully.
2. This question paper consists of 21 questions in two sections : Section A and Section B.
3. Section A has Objective Type Questions whereas Section B contains Subjective Type Questions.
4. 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.
5. All questions of a particular section must be attempted in the correct order.
6. Section A : Objective Type Questions (24 marks) :
i. This section has 5 questions.
ii. There is no negative marking.
iii. Do as per the instructions given.
iv. Marks allotted are mentioned against each question/part.
7. Section B : Subjective Type Questions (26 marks) :
i. This section has 16 questions.
ii. A candidate has to do 10 questions.
iii. Do as per the instructions given.
iv. Marks allotted are mentioned against each question/part.
SECTION A: OBJECTIVE TYPE QUESTIONS (24 Marks)
| Q 1. | Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks) | |
| i. | During a team meeting, the manager uses technical jargon and complex acronyms that the newly joined interns fail to understand, leading to task delays. Which barrier to effective communication is highlighted here? a) Physical barrier b) Linguistic barrier c) Cultural barrier d) Organisational barrier | 1 |
| ii. | Kabir wants to improve his spoken English before college admissions. He sets a goal: ‘I will practice speaking English for 30 minutes daily with my study partner for the next 3 months.’ Which two components of SMART goals are clearly evident in his deadline and daily routine? a) Specific and Achievable b) Measurable and Time-bound c) Realistic and Abrupt d) Accountable and Admirable | 1 |
| iii. | Ananya practices deep breathing and yoga every morning and breaks her exam syllabus into small daily targets so she stays calm and focused during board exams. Which self-management skill is she primarily demonstrating? a) Stress Management b) External Motivation c) Physical Strength d) Financial Planning | 1 |
| iv. | Meera notices her laptop running very slowly because of accumulated temporary files and unused programs. Which utility software should she run as part of monthly maintenance to free up disk space and improve performance? a) Disk Cleaner software b) Web Browser c) Word Processor d) Media Player | 1 |
| v. | Suresh runs a small bakery in his town. After noticing customers asking for sugar-free snacks, he introduces a new range of millet-based sugar-free biscuits using locally sourced grains. Which function of an entrepreneur is Suresh performing? a) Dividing income b) Creating a new product/idea c) Wage employment d) Avoiding calculated risks | 1 |
| vi. | The Ministry of Railways introduced clay pots (‘Kulhads’) at stations to replace plastic and paper cups. How does this initiative directly support Sustainable Development? a) It increases plastic manufacturing b) It reduces tree cutting for paper cups and cuts plastic waste c) It uses non-renewable fossil fuels d) It depletes soil nutrients | 1 |
| Q 2. | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | |
| i. | Neha has formatted a heading in her LibreOffice Writer document with a specific font, colour, and border. She wants to quickly apply this exact formatting to 15 other scattered sub-headings without selecting and formatting each one manually. Which feature in the Styles window should she use? a) Load Styles b) Fill Format c) Update Selected Style d) AutoCorrect | 1 |
| ii. | Which of the following Writer style categories is used to control page margins, page size, orientation, and placement of headers and footers? a) Paragraph Style b) Frame Style c) Page Style d) Character Style | 1 |
| iii. | When inserting an image in LibreOffice Writer via Insert > Image, what is the primary advantage of selecting the ‘Link’ checkbox in the Insert Image dialog box? a) It automatically applies a Charcoal Sketch filter to the image b) It stores only a reference to the image file, reducing the overall document size c) It converts the image into a drawing object d) It permanently locks the image so it cannot be resized | 1 |
| iv. | Rohan has drawn a flowchart in LibreOffice Writer using five separate rectangle and arrow shapes. He wants to move and resize all five shapes together as a single unit without disturbing their relative positions. Which feature should he use? a) Text Wrapping b) Anchoring c) Grouping d) Cropping | 1 |
| v. | Assertion (A): In LibreOffice Writer, a Table of Contents (ToC) does not update automatically when new headings or pages are added to the document. Reason (R): To reflect document edits in the ToC, the user must right-click on the ToC and select the ‘Update Index’ option. 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 | 1 |
| vi. | A writer saves a custom document layout containing the school letterhead, margins, and predefined heading styles as a template in LibreOffice Writer. What file extension will Writer assign to this saved template? a) .odt b) .ott c) .ods d) .odb | 1 |
| Q 3. | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | |
| i. | A school store maintains monthly sales records across three separate worksheets named ‘North_Wing’, ‘South_Wing’, and ‘Main_Block’. Which LibreOffice Calc tool allows the manager to combine these ranges into a single master summary sheet using functions like Sum or Average? a) Goal Seek b) Data Consolidate c) Multiple Operations d) Track Changes | 1 |
| ii. | Which LibreOffice Calc tool automatically groups data based on a selected column (such as ‘Department’ or ‘Class’) and inserts summary rows using functions like Sum, Count, or Average along with an outline bar on the left? a) Subtotals b) What-if Scenarios c) Solver d) Data Validity | 1 |
| iii. | Before recording a macro in LibreOffice Calc for the first time, the user notices that the ‘Record Macro’ option under Tools > Macros is missing. From which menu path can this feature be enabled? a) Edit > Track Changes > Record b) Tools > Options > LibreOffice > Advanced c) Data > Calculate > AutoCalculate d) Sheet > Macros > Enable | 1 |
| iv. | Which of the following is a VALID macro name according to LibreOffice Calc naming rules? a) 1st_Report b) Monthly Sales c) Calculate_Tax_2026 d) Sales*Summary | 1 |
| v. | In LibreOffice Calc, which syntax is used to reference cell D5 of a worksheet named ‘Term 1′ within the same workbook? a) $’Term 1′.D5 b) =’Term 1’#D5 c) $Term 1:D5 d) &’Term 1’.D5 | 1 |
| vi. | When a spreadsheet is opened in ‘Shared’ mode in LibreOffice Calc, what appears next to the file name in the Title Bar? a) Read-Only b) Protected c) Shared d) Linked | 1 |
| Q 4. | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | |
| i. | In a relational database, which RDBMS object is used to retrieve specific records from one or more tables based on defined search criteria? a) Form b) Report c) Query d) Macro | 1 |
| ii. | A school admission table has two fields, ‘Admission_No’ and ‘Aadhaar_No’, both of which contain unique, non-null values for every student. If ‘Admission_No’ is chosen as the Primary Key, what is ‘Aadhaar_No’ called? a) Foreign Key b) Alternate Key c) Composite Key d) Secondary Key | 1 |
| iii. | Which data type in LibreOffice Base is most suitable for storing a scanned photograph or audio clip of an employee as a long string of zeros and ones? a) Boolean b) Binary c) Memo (LONGVARCHAR) d) Timestamp | 1 |
| iv. | In a hospital database, one Doctor treats many Patients, and each Patient is assigned to only one Doctor. Which type of relationship exists between the ‘Doctors’ table and the ‘Patients’ table? a) One-to-One b) One-to-Many c) Many-to-Many d) Self-Referencing | 1 |
| v. | While creating a query in Design View in LibreOffice Base, which row in the lower design grid is used to specify conditions (such as ‘> 75’ or ‘= “Delhi”‘) to filter the records? a) Alias b) Sort c) Visible d) Criterion | 1 |
| vi. | Which LibreOffice Base object presents retrieved data from a table or query in a formal, structured, and printable layout with titles, headings, and page numbers? a) Form b) Report c) Table Wizard d) Relationship Window | 1 |
| Q 5. | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | |
| i. | While walking through an office corridor, an employee trips over a loose network cable running across the floor and sprains an ankle. Which category of workplace hazard does this represent? a) Biological hazard b) Physical / Slip and Trip hazard c) Chemical hazard d) Radiation hazard | 1 |
| ii. | Which of the following is a potential source of health hazards caused by poor working environment conditions in an IT office? a) Proper ventilation and natural daylight b) Glare on computer monitors and poor indoor air quality c) Ergonomically adjustable chairs d) Regular 15-minute eye breaks | 1 |
| iii. | Employees who spend hours typing without wrist support or proper chair height often develop pain and tingling in their wrists, fingers, and shoulders. What is this condition commonly known as? a) Occupational Overuse Syndrome (OOS) / Repetitive Strain Injury b) Computer Vision Syndrome c) Acute Respiratory Disorder d) Heat Exhaustion | 1 |
| iv. | To prevent eye strain and visual problems while working on a computer, what is the recommended viewing distance between the user’s eyes and the monitor screen? a) 10 to 15 cm b) 50 to 60 cm c) 150 to 200 cm d) Less than 20 cm | 1 |
| v. | A short circuit sparks a fire inside a server room containing live electrical panels and computers. Which class of fire does this belong to, and what type of extinguisher should be used? a) Class A fire; use a water extinguisher b) Class C fire; use a CO2 or dry chemical powder c) Class D fire; pour buckets of water d) Class B fire; use wet blankets | 1 |
| vi. | During a fire alarm evacuation in a multi-storey office building, which action is strictly prohibited according to general evacuation procedures? a) Using the marked emergency staircase b) Assisting differently-abled colleagues to the exit c) Using elevators/lifts to exit the building quickly d) Assembling at the designated assembly point | 1 |
SECTION B: SUBJECTIVE TYPE QUESTIONS (26 Marks)
Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 marks)
Answer each question in 20 – 30 words.
| Q 6. | What is feedback in a communication cycle? Mention any two characteristics of good feedback. | 2 |
| Q 7. | Rohan often postpones his school assignments and feels overwhelmed before deadlines. Suggest any four steps of effective time management that can help him. | 2 |
| Q 8. | Differentiate between a Worm and a Trojan Horse as threats to computer security. | 2 |
| Q 9. | State any two common myths (misconceptions) about entrepreneurship and write the reality behind each. | 2 |
| Q 10. | What is meant by Sustainable Development? Mention any two ways individuals can contribute to saving energy at home or school. | 2 |
Answer any 4 out of the given 6 questions in 20 – 30 words each (2 x 4 = 8 marks)
| Q 11. | Differentiate between Cropping and Resizing an image in LibreOffice Writer. | 2 |
| Q 12. | What is a What-if Scenario in LibreOffice Calc? Give one practical example of where it can be used. | 2 |
| Q 13. | Distinguish between Merging Documents and Comparing Documents in LibreOffice Calc. | 2 |
| Q 14. | Define Data Redundancy and Data Inconsistency in the context of a Database Management System. | 2 |
| Q 15. | State any two guidelines for maintaining clean air and clean water at a workplace. | 2 |
| Q 16. | List any two fire prevention measures that should be followed in an office or computer laboratory. | 2 |
Answer any 3 out of the given 5 questions in 50 – 80 words each (4 x 3 = 12 marks)
| Q 17. | Case Study: Ananya is the editor of her school’s annual magazine in LibreOffice Writer. Four teachers have reviewed her draft and made edits and suggestions. Before finalizing the magazine for printing, Ananya faces the following tasks: (a) She wants to ensure no reviewer can turn off the Track Changes feature without her permission. (b) While reviewing, she wants to see the author’s name, date, and time of a specific edit without opening any dialog box. (c) She wants to view all recorded changes in a single list so she can selectively accept or reject them. (d) One reviewer left a suggestion box in the margin that is no longer needed. How can Ananya remove only that specific comment? Suggest the exact LibreOffice Writer feature or step for each task (a) to (d). | 4 |
| Q 18. | Consider the table ‘Student_Activity’ given below and answer the questions that follow: Activity_ID Student_Name House Points ACT01 Aarav Verma Red 85 ACT02 Diya Nair Blue 92 ACT03 Kabir Khan Green 78 ACT04 Sneha Roy Red 90 (a) How many fields and records are present in the above table? (b) Suggest a suitable data type for the fields ‘Activity_ID’ and ‘Points’ in LibreOffice Base. (c) Which field should be set as the Primary Key, and why? (d) If the table is sorted in descending order of ‘Points’, which student’s record will appear first? | 4 |
| Q 19. | Raghav is preparing an annual sales workbook in LibreOffice Calc with separate sheets for Quarter 1, Quarter 2, Quarter 3, and Quarter 4. (a) He wants to calculate the target profit of ₹50,000 by finding out the exact number of units that need to be sold. Which Calc tool should he use, and what are its three main input parameters? (b) Explain how Raghav can use a Macro as a Function in LibreOffice Calc to automate a custom commission formula that is not available as a built-in function. | 4 |
| Q 20. | A library maintains two tables in LibreOffice Base: ‘Books’ (Book_ID, Title, Author, Category_ID) and ‘Categories’ (Category_ID, Category_Name). (a) Identify the Primary Key and Foreign Key in the ‘Books’ table. (b) State any two advantages of relating tables in a database. (c) What happens when ‘No Action’ is selected for delete operations under Referential Integrity, and a user tries to delete a Category_ID from ‘Categories’ that is already assigned to books in the ‘Books’ table? (d) Briefly explain the purpose of using a Form in LibreOffice Base. | 4 |
| Q 21. | Case Study: During a routine safety inspection at an IT-ITES BPO office, the safety officer observed the following issues: • Several employees complained of neck pain, lower backache, and dry eyes after 8-hour shifts. • Loose electrical wires were found near a water dispenser. • Exit doors were partially blocked by stacked cardboard boxes. (a) Identify two ergonomic measures the company should implement to prevent neck pain and backache. (b) Why is placing electrical wires near a water dispenser hazardous, and what immediate preventive action should be taken? (c) Which workplace safety rule is violated by blocking exit doors, and why is keeping exits clear critical? (d) State the first step an employee should take upon noticing a colleague who has suffered an electric shock from a faulty appliance. | 4 |
| Set Number | Title | Download Link |
|---|---|---|
| Set 1 | CBSE Class 10 IT 402 Sample Paper Set 1 (2026-27) with Marking Scheme | Sample Practice Paper 1 |
| Set 2 | CBSE Class 10 IT 402 Sample Paper Set 2 (2026-27) with Marking Scheme | Sample Practice Paper 2 |
| Set 3 | CBSE Class 10 IT 402 Sample Paper Set 3 (2026-27) with Marking Scheme | Sample Practice Paper 3 |
| Set 4 | CBSE Class 10 IT 402 Sample Paper Set 4 (2026-27) with Marking Scheme | Sample Practice Paper 4 |
| Set 5 | CBSE Class 10 IT 402 Sample Paper Set 5 (2026-27) with Marking Scheme | Sample Practice Paper 5 |
MARKING SCHEME – SAMPLE PRACTICE QUESTION PAPER (SET 1) SESSION: 2026-27
SECTION A: OBJECTIVE TYPE QUESTIONS (24 Marks)
Q. 1 Answer any 4 out of the given 6 questions (1 x 4 = 4 marks)
Q. 1 Answer any 4 out of the given 6 questions (1 x 4 = 4 marks)
| Q. No. | Answer | |
| (i) | b) Linguistic barrier | 1 |
| (ii) | b) Measurable and Time-bound | 1 |
| (iii) | a) Stress Management | 1 |
| (iv) | a) Disk Cleaner software | 1 |
| (v) | b) Creating a new product/idea | 1 |
| (vi) | b) It reduces tree cutting for paper cups and cuts plastic waste | 1 |
Q. 2 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
| Q. No. | Answer | |
| (i) | b) Fill Format | 1 |
| (ii) | c) Page Style | 1 |
| (iii) | b) It stores only a reference to the image file, reducing the overall document size | 1 |
| (iv) | c) Grouping | 1 |
| (v) | a) Both A and R are true, and R is the correct explanation of A | 1 |
| (vi) | b) .ott | 1 |
Q. 3 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
| Q. No. | Answer | |
| (i) | b) Data Consolidate | 1 |
| (ii) | a) Subtotals | 1 |
| (iii) | b) Tools > Options > LibreOffice > Advanced | 1 |
| (iv) | c) Calculate_Tax_2026 | 1 |
| (v) | a) $’Term 1′.D5 | 1 |
| (vi) | c) (shared) | 1 |
Q. 4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
| Q. No. | Answer | |
| (i) | c) Query | 1 |
| (ii) | b) Alternate Key | 1 |
| (iii) | b) Binary | 1 |
| (iv) | b) One-to-Many | 1 |
| (v) | d) Criterion | 1 |
| (vi) | b) Report | 1 |
Q. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
| Q. No. | Answer | |
| (i) | b) Physical / Slip and Trip hazard | 1 |
| (ii) | b) Glare on computer monitors and poor indoor air quality | 1 |
| (iii) | a) Occupational Overuse Syndrome (OOS) / Repetitive Strain Injury | 1 |
| (iv) | b) 50 to 60 cm (approx. arm’s length) | 1 |
| (v) | b) Class C fire; use a CO2 or dry chemical powder extinguisher | 1 |
| (vi) | c) Using elevators/lifts to exit the building quickly | 1 |
SECTION B: SUBJECTIVE TYPE QUESTIONS (26 Marks)
Employability Skills – Short Answer Questions (Any 3 out of 5) (2 x 3 = 6 marks)
| Q. No. | Answer | |
| Q 6. | Feedback is the receiver’s acknowledgement and response to the sender’s message, completing the communication cycle. (1 mark) Characteristics of good feedback (any two, ½ mark each): Specific, Timely, Polite, Offering continuing support, Helpful/Kind. | 2 |
| Q 7. | Four steps of effective time management (½ mark each): 1. Organise: Plan day-to-day activities and maintain a clean workspace/timetable. 2. Prioritise: Prepare a to-do list and rank tasks by importance. 3. Control: Avoid time-wasters (like excessive phone chatting) and stay focused. 4. Track: Note and analyse how time is spent to eliminate unproductive activities. | 2 |
| Q 8. | • Worm: A self-replicating virus that spreads automatically across files and networks once it infects a computer, making it difficult to remove. (1 mark) • Trojan Horse: A malicious program that disguises itself as useful/legitimate software, but destroys or steals data once installed. (1 mark) | 2 |
| Q 9. | Any two myths and their realities (1 mark each): 1. Myth: Every business idea needs to be unique or special. Reality: An entrepreneur can take an existing idea and innovate or improve it to meet customer demand. 2. Myth: A person needs a lot of money to start a business. Reality: Businesses can start with small capital and grow gradually by reinvesting profits. (Other valid textbook myths: Only big businesses are entrepreneurs; Entrepreneurs are born, not made.) | 2 |
| Q 10. | Sustainable Development is development that satisfies the needs of the present without compromising the capacity of future generations to meet their own needs. (1 mark) Ways to save energy (any two, ½ mark each): Switching off lights and fans when not in use; using natural daylight; using energy-efficient LED bulbs and appliances. | 2 |
Subject Specific – Short Answer Questions (Any 4 out of 6) (2 x 4 = 8 marks)
| Q. No. | Answer | |
| Q 11. | • Cropping cuts off unwanted outer parts of an image without changing the scale of the remaining part. (1 mark) • Resizing changes the overall dimensions (width and height) of the entire image by scaling it up or down without removing any part. (1 mark) | 2 |
| Q 12. | A What-if Scenario is a saved set of cell values used in spreadsheet calculations to explore and compare different outcomes under changing conditions. (1 mark) Example: Calculating monthly car loan EMIs for different combinations of loan amounts and tenure years. (1 mark) | 2 |
| Q 13. | • Merging Documents combines changes recorded by multiple reviewers in different copies of a shared spreadsheet into a single original spreadsheet (Edit > Track Changes > Merge Document). (1 mark) • Comparing Documents identifies differences between an original spreadsheet and an edited copy where Track Changes was not turned on (Edit > Track Changes > Compare Document). (1 mark) | 2 |
| Q 14. | • Data Redundancy: Unnecessary duplication/repetition of the same data field across multiple tables or files. (1 mark) • Data Inconsistency: When duplicate data stored in different tables is updated in one place but not in others, resulting in mismatched/conflicting values. (1 mark) | 2 |
| Q 15. | Any two guidelines (1 mark each): • Ensure dust-free surroundings, proper ventilation, and restrict vehicle/industrial smoke near the workplace for clean air. • Prevent sewage/chemical dumping into water bodies and regularly test/treat drinking water for clean water. | 2 |
| Q 16. | Any two fire prevention measures (1 mark each): • Keep all flammable materials away from ignition sources and electrical panels. • Regularly inspect electrical wiring/equipment to prevent overloading and short circuits (or install smoke detectors and fire extinguishers). | 2 |
Subject Specific – Long Answer Questions (Any 3 out of 5) (4 x 3 = 12 marks)
| Q. No. | Answer | |
| Q 17. | (a) Select Edit > Track Changes > Protect (or click Protect Track Changes on the Track Changes toolbar) and set a password. (1 mark) (b) Hover/place the mouse pointer over the tracked change to view the tooltip showing author, date, and time. (1 mark) (c) Click the ‘Manage Track Changes’ button on the Track Changes toolbar (or Edit > Track Changes > Manage) to open the Manage Changes dialog box. (1 mark) (d) Click the down arrow at the bottom-right of that comment box and select ‘Delete Comment’. (1 mark) | 4 |
| Q 18. | (a) Fields = 4; Records = 4 (½ + ½ = 1 mark) (b) Activity_ID: VARCHAR (or CHAR); Points: INTEGER (or SMALLINT / TINYINT / NUMERIC) (½ + ½ = 1 mark) (c) ‘Activity_ID’ should be the Primary Key because it uniquely identifies each record and contains no duplicate or null values. (1 mark) (d) Diya Nair (ACT02, 92 points) will appear first. (1 mark) | 4 |
| Q 19. | (a) Raghav should use the Goal Seek tool (Tools > Goal Seek). (1 mark) Three main input parameters: (i) Formula cell, (ii) Target value (50,000), and (iii) Variable cell (units sold). (1 mark) (b) Using Macro as a Function: Open Tools > Macros > Organize Macros > LibreOffice Basic, create/edit a module in the IDE, and write the custom calculation code between ‘Function <Name>(arguments)’ and ‘End Function’ statements, assigning the final result to the function name. It can then be called directly in any cell like a built-in function (e.g., =Commission(B2)). (2 marks) | 4 |
| Q 20. | (a) Primary Key: Book_ID; Foreign Key: Category_ID (½ + ½ = 1 mark) (b) Advantages of relating tables (any two, ½ mark each): Reduces data redundancy; prevents data inconsistency; ensures data accuracy and referential integrity. (c) With ‘No Action’ selected, LibreOffice Base prevents/blocks the deletion of the Category_ID record from the master ‘Categories’ table and displays an error/warning message because matching child records exist in ‘Books’. (1 mark) (d) A Form provides a user-friendly graphical interface (with labels, text boxes, etc.) to easily enter, view, modify, or delete records in a database table. (1 mark) | 4 |
| Q 21. | (a) Ergonomic measures (any two, ½ mark each): Use height-adjustable chairs with proper lumbar/back support; position the monitor top at or slightly below eye level; keep feet flat on the floor or a footrest. (b) Water conducts electricity, creating a severe risk of electrocution and short-circuit fire. Action: Immediately disconnect power/move loose wires away from the water dispenser and insulate/secure cables properly. (1 mark) (c) It violates emergency evacuation and housekeeping safety rules. Keeping exits unobstructed is critical so employees can evacuate quickly and safely without tripping or bottlenecks during a fire or emergency. (1 mark) (d) Switch off the main power supply immediately (or unplug the appliance) before touching the victim; if power cannot be turned off, separate the victim using a non-conductive dry wooden stick/plastic object. (1 mark) | 4 |

