CBSE Sample Papers for Class 10 IT Set 2 with Solutions - #NCSOLVE 📚

Students must start practicing the questions from CBSE Sample Papers for Class 10 IT with Solutions Set 2 are designed as per the revised syllabus.

CBSE Sample Papers for Class 10 IT Set 2 with Solutions

Time: 2 Hours
Maximum Marks: 50

Instructions:

• Please read the instructions carefully.
• This Question Paper consists of 21 questions in two sections: Section A & Section B.
• Section A has Objective Type Questions whereas Section B contains Subjective Type Questions.
• 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.
• All questions of a particular section must be attempted in the correct order.
• Section A: Objective Type Questions (24 Marks)
  • This section has 5 questions.
  • Marks allotted are mentioned against each question/part.
  • There is no negative marking.
  • Do as per the instructions given.
• Section B: Subjective Type Questions (26 Marks)
  • This section has 16 questions.
  • A candidate has to do 10 questions.
  • Do as per the instructions given.
  • Marks allotted are mentioned against each question/part.

Section A
Objective Type Questions [24 Marks]

Question 1.
Answer any 4 out of the given 6 questions on Employability Skills. (4×1=4)

(i) Samar wrote a notice full of difficult words and unclear instructions. Many students ignored it. Which principle of communication was violated?
(a) Concreteness
(b) Conciseness
(c) Clarity
(d) Completeness
Answer:
(c) Clarity

(ii) Which of the following is the most suitable term for managing stress through regular walking in a natural environment?
(a) Physical fitness
(b) Nature walk
(c) Morning exercise
(d) Forest workout
Answer:
(b) Nature walk

(iii) Arjun studies regularly, stays focused on his goals, and encourages himself even when results aren’t immediate. This shows:
(a) carelessness
(b) laziness
(c) self-motivation
(d) distraction
Answer:
(c) self-motivation

(iv) A good way to protect your system from viruses is to
(a) ignore software updates.
(b) open all email attachments.
(c) use antivirus software and scan regularly.
(d) keep the computer always turned off.
Answer:
(c) use antivirus software and scan regularly.

(v) One of the key roles of an entrepreneur in society is to
(a) avoid competition
(b) reduce employment opportunities
(c) promote social and economic development
(d) work in a bank
Answer:
(c) promote social and economic development.

(vi) Which one of these models best supports sustainable living?
(a) Diesel generator
(b) Solar cooker
(c) Plastic incinerator
(d) Coal heater
Answer:
(b) Solar cooker

A Mistake Alert
Students may confuse with “Plastic incinerator” or “Diesel generator” due to their wide use, but these are non-sustainable.

Question 2.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) Preeti wants to apply the same formatting from one paragraph to another quickly. Which feature should she use?
(a) Format Paint
(b) Fill Format
(c) Clone Formatting
(d) Copy-Paste
Answer:
(b) Fill Format

(ii) Rahul inserted an image in his document but wants to wrap text tightly around it. Which option should he use?
(a) In Background
(b) Page Wrap
(c) Optimal Page Wrap
(d) Through
Answer:
(c) Optimal Page Wrap

(iii) Which of the following is a category of style in Writer?
(a) Shape Style
(b) Image Style
(c) Frame Style
(d) Caption Style
Answer:
(c) Frame Style

(iv) Which menu is used to insert a Table of Contents in Writer?
(a) Insert → Indexes and Tables
(b) View → Navigator
(c) Tools → AutoText
(d) Format → Table of Contents
Answer:
(a) Insert → Indexes and Tables

(v) What is the use of a template in LibreOffice Writer?
(a) To save passwords
(b) To create identical charts
(c) To reuse predefined document formats
(d) To organise menus
Answer:
(c) To reuse predefined document formats

(vi) Jyoti is preparing a school magazine using a template. She wants to apply a different template to a blank document. Which option should she use?
(a) Import Template
(b) Export Template
(c) Apply Template
(d) Insert Template
Answer:
(c) Apply Template

Question 3.
Answer any 5 out of the given 6 questions. (5×1=5)

(i) In Calc, which tool lets you test formulas under different scenarios?
(a) Goal Seek
(b) Solver
(c) Scenario Manager
(d) Filter
Answer:
(c) Scenario Manager

(ii) In a shared spreadsheet, which action shows all previous edits?
(a) Accept Change
(b) Show Changes
(c) Update Sheet
(d) Sort Data
Answer:
(b) Show Changes

(iii) A macro can be created using
(a) Tools → Macros → Record Macro
(b) Edit → Macros
(c) Data → Macro Tool
(d) Insert → Record
Answer:
(a) Tools → Macros → Record Macro

(iv) Which hyperlink allows connection to a data source?
(a) Web link
(b) Document link
(c) Registered data source link
(d) Text link
Answer:
(c) Registered data source link

(v) Which Calc feature consolidates data from multiple ranges?
(a) Group
(b) Chart
(c) Consolidate
(d) Solver
Answer:
(c) Consolidate

(vi) Which menu lets you create a scenario in Calc?
(a) Data → Scenario
(b) Insert → Scenario
(c) Tools → Scenario
(d) Format → Scenario
Answer:
(a) Data → Scenario

Question 4.
Answer any 5 out of the given 6 questions. (5×1=5)

(i) Priya is designing a database of student details. She wants to ensure each record is uniquely identified. Which action should she take while creating the table in design view?
(a) Sort the records
(b) Set a primary key
(c) Hide duplicate fields
(d) Apply referential integrity
Answer:
(b) Set a primary key

(ii) Which tool in LibreOffice Base is used to display selected data from one or more tables based on specific conditions?
(a) Report
(b) Query
(c) Form
(d) Filter Wizard
Answer:
(b) Query

(iii) What does referential integrity ensure in relational databases?
(a) Data is sorted alphabetically.
(b) All linked tables are deleted.
(c) Consistent and valid relationships between tables.
(d) All data is converted to text.
Answer:
(c) Consistent and valid relationships between tables

(iv) In LibreOffice Base, which object is used to display the final formatted output for printing?
(a) Query
(b) Table
(c) Form
(d) Report
Answer:
(d) Report

(v) Which of the following is not an object of LibreOffice Base?
(a) Table
(b) Form
(c) Slide
(d) Query
Answer:
(c) Slide

(vi) While editing a form in LibreOffice Base, Meena wants to display a fixed text title at the top of the form. Which form control should she insert?
(a) Date Field
(b) Label
(c) Text Box
(d) Numeric Field
Answer:
(b) Label

Question 5.
Answer any 5 out of the given 6 questions. (5×1=5)

(i) Priya works long hours on a computer without adjusting screen brightness or taking breaks. She starts experiencing blurry vision and eye strain. Which safety measure could reduce this?
(a) Use a dark background wallpaper
(b) Lower the monitor below eye level
(c) Take frequent eye breaks and adjust monitor brightness
(d) Increase screen resolution to maximum
Answer:
(c) Take frequent eye breaks and adjust monitor brightness

(ii) ………. is the science that focuses on designing tools and workspaces to fit human needs and prevent strain.
(a) Physiology
(b) Ergonomics
(c) Kinesiology
(d) Automation
Answer:
(b) Ergonomics

(iii) Which of the following is not a physical hazard in the workplace?
(a) Poor ventilation
(b) Loud noise
(c) Bright lighting
(d) Delayed email response
Answer:
(d) Delayed email response

(iv) The purpose of workplace safety policies is to
(a) increase workload
(b) reduce worker rights
(c) prevent accidents and injuries
(d) promote overtime
Answer:
(c) prevent accidents and injuries

(v) A slippery floor, uncovered wires, and poor lighting are examples of
(a) Chemical hazards
(b) Biological hazards
(c) Physical hazards
(d) Visual hazards
Answer:
(c) Physical hazards

(vi) Which of the following should not be done while working on electrical equipment?
(a) Wear dry gloves
(b) Work with wet hands
(c) Use insulated tools
(d) Switch off power before repairing
Answer:
(b) Work with wet hands

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. (3×2=6)

Question 6.
What are two ways to overcome communication barriers?
Answer:
One way to overcome communication barriers is by using simple and clear language that is easy to understand. Another way is through active listening, which means paying full attention to the speaker without interrupting. Both methods help reduce misunderstandings and improve effective communication.

Question 7.
What is stress management and why is it important?
Answer:
Stress management involves techniques and practices that help a person cope with stress in a healthy way. It is important because unmanaged stress can lead to physical and mental health issues. Managing stress effectively improves concentration, productivity, emotional balance and overall well-being in personal and professional life

Question 8.
What is the purpose of installing antivirus software on a computer?
Answer:
Antivirus software protects a computer from maiware, viruses, spyware and other malicious threats. It scans files and programs, prevents unauthorjsed access and alerts the user to suspicious activity. Regularly updated antivirus ensures data security and helps maintain the computer’s smooth arid safe operation.

Question 9.
What is the role of entrepreneurship in society?
Answer:
Entrepreneurship promotes economic development. creates jobs and introduces innovations that improve the quality of life. Entrepreneurs solve local problems with creative solutions and contribute to community welfare by supporting infrastructure, education and sustainability.

Question 10.
Explain any two problems related to sustainable development.
Answer:
Two major problems are:

• Overuse of natural resources, which leads to deforestation, soil erosion and depletion of minerals;
• Pollution, including air, water, and land pollution, which harms health and biodiversity making it harder to maintain ecological balance.

Answer any 4 out of the given 6 questions in 20-30 words each (4×2=8)

Question 11.
What is meant by the ‘Track Changes’ feature in Writer and when is it useful?
Answer:
Track Changes in Writer is a feature that records all modifications made to a document. such as deletions, insertions and formatting updates. It is especially useful during document reviews or collaborations. Reviewers can suggest changes, and the author can later accept Or reject them, ensuring controlled and transparent editing.

Question 12.
Explain the function of the What-if Analysis tool in Calc.
Answer:
The What-if Analysis tool in Caic allows users to see how changes in input values affect the outcome of formulas. For example, if you’re calculating profit based on selling price and quantity, you can test different prices to see how profits change. This tool is useful for decision-making, budgeting and forecasting.

Question 13.
How can you edit a hyperlink in Calc?
Answer:
To edit a hyperlink in Calc, tight-click the hyperlink and choose Edit Hyperlink. A dialog box appears where you can change the link’s
target, text or type (e.g., IJRL document, email). Editing hyperlinks helps ensure accuracy and maintain relevance if file locations or linked documents change.

Question 14.
Define Relational Database Management System (RDBMS). Give two examples of its objects.
Answer:
A Relational Database Management System (RDBMS) stores data in related tables. It uses structured relationships based on keys (primary and foreign) to manage data efficiently and eliminate redundancy. Examples of objects in an RDBMS include tables (which store the data), queries (used to retrieve specific information), forms (used for user-friendly data entry) and reports (used Ior’formatted output and printing purposes).

Question 15.
What are two common physical hazards found in office environments?
Answer:
Slipping on wet floors and tripping over cables or loose carpeting are common physical hazards in offices. These hazards can lead to injuries like sprains, fractures or even head trauma. Ensuring clean, dry floors and properly managed wires can significantly reduce these risks, Regular inspections and proper signage also help maintain a safe work setting.

Question 16.
What are the basic guidelines for maintaining good air and water quality in the workplace?
Answer:
Air quality can be maintained by ensuring proper ventilation, using air purifiers and keeping the workspace dust-free. Avoiding chemical pollutants and regular HVAC maintenance is essential. For clean water, ensure regular testing, proper filtration and accessible sanitation facilities. Promoting a clean, hygienic environment supports the overall health and safely of employees.

Answer any 3 out of the given 5 questions in 50-80 words each. (3×4=12)

Question 17.
(a) What is the benefit of using the Fill Format mode in Styles and Formatting?
Answer:
The Fill Format mode in LibreOffice Writer allows users to apply a selected style to multiple sections of the document quickly. Once the mode is activated, the chosen style can be “painted” onto different text blocks or elements simply by clicking. This is particularly useful for maintaining consistency in formatting, especially when editing large documents. It saves time and ensures that the formatting stays uniform throughout the file.

(b) How does anchoring help in positioning images within text in Writer?
Answer:
Anchoring in LibreOffìce Writer determines how an image is connected to a particular part of the document. You can anchor an image to a paragraph. character, or page. This setting ensures that the image moves appropriately when the text is edited. For example, anchoring to a paragraph keeps the image with that paragraph. while anchoring to the page keeps the image fixed in one location. It helps maintain the layout and flow of the document.

Question 18.
Mrs. Reema, the Head of the Academic Department at Sunrise School, is preparing the annual academic performance report. Each subject teacher has maintained their own spreadsheet for student marks in different worksheets. Mrs. Reema now wants to combine all subject-wise data, automate repetitive entries, analyse results using scenarios, and collaborate with teachers by tracking their feedback and suggestions.
(a) Which feature should Mrs. Reema use to combine student marks from different subject worksheets into one final result sheet?
(b) To automate the task of entering common remarks like ‘Passed’ or ‘Needs Improvement’ for multiple students, which tool should she use?
(c) Mrs. Reema wants to evaluate how the overall class result changes if passing criteria are modified from 35 to 40 marks. Which tool will help her simulate and compare this?
(d) Since the final report is shared among subject teachers for review, how can Mrs. Reema ensure all edits and suggestions made by them are tracked?
Answer:
(a) Mrs. Reema should use the ‘Consolidate’ feature found under Data →Consolidate. This allows her to select each subject sheet as a data source and apply functions like Sum or Average to summarise student marks in one central location.

(b) She can record a Macro using Tools → Macros → Record Macro, where she enters the remark once. Later, she can run this macro repeatedly, saving time and avoiding manual errors while adding feedback across rows.

(c) She should use the What-if Scenarios feature available under Tools → Scenarios. By creating different scenarios like “Pass at 35 marks” and “Pass at 40 marks,” she can instantly switch views and analyse the impact on the overall class result.

(d) She can enable Track Changes from Edit → Track Changes → Record. This records all changes made by teachers. Later, she can review them under Edit → Track Changes → Manage Changes, where she can Accept or Reject each change.

Question 19.
A worker accidentally drops a heavy object on his foot. As a safety officer, you need to educate others on how to handle such emergencies and the importance of reporting.
(a) What two actions should you take when an accident occurs at work?
Answer:
When an accident happens, immediately help the injured employee and ensure their safety. If the inlury is serious, call for medical help without delay, Next, report the incident to the supervisor with complete details, including how and where it happened. If possible, isolate the accident area to prevent others from being hurt harm and ensures proper care and investigation of the event.

(b) Why is it important to follow accident-reporting procedures?
Answer:
Following accident-reporting procedures helps identify workplace hazards and prevent them in the future. It ensures the injured person receives proper care and support. Timely reporting is also essential for legal compliance and helps the organisation maintain a safe working environment. Proper documentation helps with insurance claims and future safety training. Ignoring accidents or delaying reports can lead to serious consequences for both employees and employers.

Question 20.
(a) What are queries in LibreOffice Base? Why are they used?
Answer:
Queries are used to extract specific information from a database by applying criteria and filters. The alois’ users to view. update. or surnmarise data across one or more tables. For instance, a user can create a query to find ‘tudents scoring above 90%. Queries are essential tools in data analysis and reporting, making large data sets easier to manage and interpret.

(b) How can you create a query using the design view in Base?
Answer:
In design vie users manually select tables and fields to include in the quer then specify conditions, sorting and grouping. This method
gives greater control and flexibility compared to the wizard. It is especially useful for complex queries involving multiple tables, calculated fields and logical expressions. The design grid allows visual arrangement of fields and conditions, making it efficient for precise data retrieval.

Question 21.
Consider the following table:

Reg_No	Name	Room_No	Contact
HS101 HS102 HS103	Rohit Meena Rohit	12 14 12	9123456780 9234567890 9345678901

(a) Suggest a suitable data type for the Reg_No and Room_No.
Answer:
Data Trpes

• Reg_No → Text (e.g.. “HS101” – alphanumeric, no calculations needed).
• Room_No → Number (e.g., 12 — numeric, allows sorting/range queries).

(b) Which field should be set as the primary key and why?
Answer:
Primary Key

• Reg_No
• Each Reg…No is unique (no duplicates), ensuring no two students share the same ID.

(c) Identify a possible alternate key and justify.
Answer:
Alternate Key

• Contact
• Contad numbers are unique in this table (no duplicates)

(d) How many attributes and records are present?
Answer:
Attributes and Records

• 4 Attributes (columns) Reg.No. Name, Rom_No, Contact.
• 3 Records (rows) Entries for HS101, HS102, H5103.

The post CBSE Sample Papers for Class 10 IT Set 2 with Solutions appeared first on Learn CBSE.

📚 NCsolve - Your Global Education Partner 🌍

Empowering Students with AI-Driven Learning Solutions

Welcome to NCsolve — your trusted educational platform designed to support students worldwide. Whether you're preparing for Class 10, Class 11, or Class 12, NCsolve offers a wide range of learning resources powered by AI Education.

Our platform is committed to providing detailed solutions, effective study techniques, and reliable content to help you achieve academic success. With our AI-driven tools, you can now access personalized study guides, practice tests, and interactive learning experiences from anywhere in the world.

🔎 Why Choose NCsolve?

At NCsolve, we believe in smart learning. Our platform offers:

• ✅ AI-powered solutions for faster and accurate learning.
• ✅ Step-by-step NCERT Solutions for all subjects.
• ✅ Access to Sample Papers and Previous Year Questions.
• ✅ Detailed explanations to strengthen your concepts.
• ✅ Regular updates on exams, syllabus changes, and study tips.
• ✅ Support for students worldwide with multi-language content.

🌐 Explore Our Websites:

🔹 ncsolve.blogspot.com
🔹 ncsolve-global.blogspot.com
🔹 edu-ai.blogspot.com

📲 Connect With Us:

👍 Facebook: NCsolve
📧 Email: ncsolve@yopmail.com

#NCsolve #EducationForAll #AIeducation #WorldWideLearning #Class10 #Class11 #Class12 #BoardExams #StudySmart #CBSE #ICSE #SamplePapers #NCERTSolutions #ExamTips #SuccessWithNCsolve #GlobalEducation