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

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

CBSE Sample Papers for Class 10 IT Set 9 with Solutions

Time : 2 Hrs
Max. 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 based on Employability Skills. (4×1=4)

(i) The school wants to announce a change in the timetable to all teachers quickly and clearly. Which of the following will be the most effective method of communication?
(a) Writing on the staff room whiteboard
(b) Sending a formal email to all teachers
(c) Waiting for a casual conversation
(d) Posting a note on the school gate
Answer:
(a) Writing on the staff room whiteboard

(ii) Which of the following best describes the ability to stay calm, focused and productive even under pressure?
(a) Avoiding responsibilities
(b) Ignoring emotions
(c) Self-discipline
(d) Reacting impulsively
Answer:
(c) Self-discipline

(iii) Neha prepares a to-do list every morning and prioritises her tasks based on importance and deadlines. She avoids distractions and sticks to her schedule. This is an example of ……………
(a) lack of planning
(b) time management
(c) multitasking
(d) procrastination
Answer:
(b) time management

(iv) A ………… is a physical device that stores all the data in a computer, including the operating system, applications and files.
(a) Monitor
(b) Keyboard
(c) SMPS
(d) Hard Disk
Answer:
(d) Hard Disk

(v) Which of the following is a myth about entrepreneurs?
(a) Entrepreneurs need to be problem-solvers.
(b) Entrepreneurs always need a lot of money to start.
(c) Entrepreneurs must be passionate about their work.
(d) Entrepreneurs need to understand market needs.
Answer:
(b) Entrepreneurs always need a lot of money to start.

(vi) Which of the following is not a solution for sustainable development?
(a) Education and awareness programmes
(b) Sustainable agriculture practices
(c) Deforestation and habitat destruction
(d) Green technology advancements
Answer:
(c) Deforestation and habitat destruction

Question 2.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) Aman wants to create a reusable document layout with predefined formatting, fonts and structure for his project reports in OpenOffice Writer. He can use the ……….. feature for this purpose.
(a) Styles
(b) Mail Merge
(c) Template
(d) Table
Answer:
(c) Template

Note
Templates save time by providing predefined layout, fonts and structureideal for reports, letters or presentations.

(ii) While working on her science project in Writer, Aditi inserted a photo of a plant. To make the image appear softer and reduce harsh edges, which image filter should she apply?
(a) Invert
(b) Sharpen
(c) Smooth
(d) Charcoal Sketch
Answer:
(c) Smooth

(iii) Which of the following options in LibreOffice Writer allows you to align an image with the text?
(a) Wrap Text
(b) Align Object
(c) Insert Object
(d) Position Image
Answer:
(a) Wrap Text

(iv) Where are user-created templates stored by default in LibreOffice?
(a) Templates Gallery
(b) AutoText
(c) Navigator
(d) Clipboard
Answer:
(a) Templates Gallery

(v) ………….. is the default page style applied when a new document is created in Libre Office Writer.
(a) Landscape
(b) First Page
(c) Default Page Style
(d) Index Page
Answer:
(c) Default Page Style

(vi) Karan is designing his assignment in LibreOffice Writer and wants to quickly copy and apply the same formatting from one paragraph to several others in the document. He should use the ………….. tool to do this.
(a) Format Copy
(b) Format Brush
(c) Fill Format
(d) Clone Text
Answer:
(c) Fill Format

Question 3.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) To enable the feature that highlights modifications made in a Calc sheet, go to ……… →Track Changes → Record.
(a) Edit
(b) View
(c) Tools
(d) Format
Answer:
(a) Edit

(ii) To rename an existing sheet in LibreOffice Calc, right-click on the sheet tab and select …………. from the context menu.
(a) Rename Sheet
(b) Edit Name
(c) Modify Sheet
(d) Change Title
Answer:
(a) Rename Sheet

(iii) Which of the following allows you to reference data from another sheet in the same workbook?
(a) =Sheet1.A1
(b) =Sheet1!A1
(c) =A1:Sheet1
(d) =REF(Sheet1.A1)
Answer:
(a) -Sheet1.A1

(iv) If you want to remove or break an external link in Calc, which option should you use?
(a) Tools → Options
(b) Edit → Links to External Files → Break Link
(c) Data → Filter → Remove
(d) Format → Clear Direct Formatting
Answer:
(b) Edit → Links to External Files →Break Link

(v) When creating a hyperlink in Calc, if only the file name or path relative to the document’s location is used, it is called a …………
(a) External hyperlink
(b) Absolute hyperlink
(c) Relative hyperlink
(d) Partial hyperlink
Answer:
(c) Relative hyperlink

(vi) In LibreOffice Calc, the tool that helps in summarising data by grouping it based on a common field and applying functions like count or max is called the ……….. tool.
(a) AutoCalculate
(b) Summary
(c) Subtotal
(d) Cell Group
Answer:
(c) Subtotal

Question 4.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) The tool in LibreOffice used to extract specific information from a large dataset based on certain criteria is called a ………….
(a) Form
(b) Table
(c) Query
(d) Relationship
Answer:
(c) Query

(ii) Which menu option allows you to define relationships between tables?
(a) Tools → SQL
(b) Edit → Connections
(c) Tools → Relationships
(d) File → Save As
Answer:
(c) Tools → Relationships

(iii) To avoid duplication of records and maintain data accuracy, which of the following should be used in a table?
(a) Foreign Key
(b) Index
(c) Primary Key
(d) Filter
Answer:
(c) Primary Key

(iv) In LibreOffice Base, to visually enter and update data in a user-friendly way, we generally use a ……….
(a) Form
(b) Macro
(c) Table
(d) Report
Answer:
(a) Form

(v) While designing a form, to ensure users select only from given options, you should use a ………. control.
(a) List Box
(b) Text Box
(c) Date Field
(d) Numeric Field
Answer:
(a) List Box

(vi) While designing a form, it is recommended to get numerical input using the ………. control to ensure only valid numbers are entered.
(a) Numeric Field
(b) Text Box
(c) Calendar
(d) Radio Button
Answer:
(a) Numeric Field

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

(i) ………… is an example of a preventive measure to avoid slips and falls at the workplace.
(a) Wearing headphones
(b) Ignoring warning signs
(c) Using anti-skid mats
(d) Walking barefoot
Answer:
(c) Using anti-skid mats

(ii) Which of the following is classified as a Class C ignition material?
(a) Oil
(b) Plastic
(c) Electrical wiring
(d) Wood
Answer:
(c) Electrical wiring

(iii) The ………… is responsible for ensuring proper ventilation and lighting in a workplace to support employee well-being.
(a) Maintenance team
(b) Pantry staff
(c) Transport team
(d) Visitor’s desk
Answer:
(a) Maintenance team

(iv) OHS stands for
(a) Occupational Health Standards
(b) Operational Hygiene and Safety
(c) Occupational Health and Safety
(d) Official Health Schedule
Answer:
(c) Occupational Health and Safety

(v) ………. is the process of adapting the workplace to fit the needs and comfort of the worker, improving efficiency and safety.
(a) Biotechnology
(b) Physiology
(c) Ergonomics
(d) Mechanics
Answer:
(c) Ergonomics

(vi) Which of the following is not an ergonomic practice?
(a) Adjusting your chair to keep your feet flat on the floor
(b) Keeping your back straight and supported
(c) Working long hours without changing posture
(d) Positioning the monitor at eye level
Answer:
(c) Working long hours without changing posture

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.
Explain any two important principles from the 7 C’s of effective communication that help in delivering a clear and respectful message.
Answer:
Two essential principles of effective communication are Clarity and Courtesy, Clarity means using simple and precise language so the receiver can understand the message easily without confusion. Courtesy involves being respectful and polite, which helps in maintaining good relationships. Together, these principles ensure the message is understood correctly and received positively, making communication more impactful and effective.

Question 7.
What do you mean by internal stress?
Answer:
Internal stress generates within the humans regarding unreasonable matters. This internal stress is one of the most important kind of stress to understand and manage because it keeps on building up as time passes. For example, some people become used to the kind of hurried, tense, lifestyle of persons living in large cities.

Question 8.
What are some simple daily practices that can help increase the lifespan and performance of a computer system?
Answer:
To ensure your computer works efficiently, follow these practices:

• Shut down the system properly instead of forcing power off.
• Clean the keyboard and screen regularly to prevent dust buildup.
• Do not eat or drink near the computer to avoid accidental spills.
• Run disk cleanup and antivirus scans weekly. These steps help in maintaining both hardware and software health over time.

Question 9.
What are four essential qualities an entrepreneur must possess to be successful in business?
Answer:
Four essential qualities an entrepreneur must possess to succeed in business are:
Risk-taking ability Entrepreneurs must be ready to take calculated risks.
Innovative mindset They should think creatively and bring new ideas.
Self-confidence Belief in their vision and actions is crucial.
Leadership skills They must guide, motivate and manage their teams effectively to achieve business goals.

Question 10.
What are the challenges faced in achieving sustainable development in rapidly growing urban areas?
Answer:
Rapid urbanisation presents major challenges for sustainable development. First, overpopulation in cities strains housing, water and sanitation systems, leading to poor living conditions. Second, increased pollution from vehicles, industries and waste harms both human health and the environment. Without proper planning and resource management, urban growth can become unsustainable, increasing the gap between environmental protection and economic development goals.

Answer any 4 out of the given 6 questions in 20-30 words each.

Question 11.
Out of various style categories provided by Writer, briefly explain Page Style category.
Answer:
The Page Style category in LibreOffice Writer is used to define the layout and appearance of an entire page. It controls elements such as page size, orientation, margins, headers, footers and background. By applying a specific page style, users can maintain a consistent format throughout a document or section. This is especially useful for creating professional documents like reports, books or newsletters with different layout needs.

Question 12.
What is the purpose of using Macros in LibreOffice Calc? Mention any two operations that can be automated using Macros.
Answer:
Macros in LibreOffice Calc are used to automate repetitive tasks by recording a sequence of actions that can be executed with a single command. They help save time and reduce human error in spreadsheet operations. Two common operations that can be automated using macros are:

• formatting a selected range of cells with specific styles.
• generating monthly reports with pre-defined calculations and layout.

Question 13.
How does the Goal Seek tool in LibreOffice Calc help in decision-making? Give one practical example of its use in a real-life situation.
Answer:
The Goal Seek tool in Calc helps users find the required input value to reach a specific target output. It is useful in situations where you know the result you want but not the value needed to achieve it. For example, if a student wants an average of 80% across five subjects and knows four subject scores, Goal Seek can determine the marks needed in the fifth subject.

Question 14.
Why is it important to set relationships between tables in LibreOffice Base? Mention any two key prerequisites needed before creating a relationship.
Answer:
Setting relationships between tables in LibreOffice Base ensures data consistency and reduces redundancy by linking related data across tables. This makes data retrieval more efficient and structured.
Two important prerequisites include:

• Each table must have at least one common field (usually with the same data type) to establish a relationship.
• The common field should preferably include unique values, such as a primary key, in at least one of the tables.

Question 15.
What are two important health and safety guidelines to follow while using a computer monitor at the workspace?
Answer:
To ensure safe and comfortable use of a monitor

• Monitor Height and Distance Position the top of the screen at or slightly below eye level and keep it about an arm’s length away to reduce eye and neck strain.
• Glare Reduction Adjust lighting to prevent glare on the screen, and take short breaks to rest your eyes, following the 20-20-20 rule.

Question 16.
What are two common physical problems that may occur due to poor sitting posture while working long hours on a computer?
Answer:
Poor sitting posture while using a computer for long durations can lead to:

• Back Pain Slouching or not using proper back support strains the spine, especially the lower back.
• Neck and Shoulder Stiffness Incorrect monitor height or leaning forward often can result in tight neck and shoulder muscles, reducing comfort and productivity. Proper ergonomic set-up is essential.

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

Question 17.
(a) What is the advantage of using Styles and Formatting in LibreOffice Writer?
(b) Differentiate between Page Break and Section Break in Writer.
Answer:
(a) The benefit of using Styles and Formatting in LibreOffice Writer is that it ensures consistency in document design. By applying predefined styles for headings, paragraphs and lists, users can maintain uniform formatting throughout the document. It also saves time, as changes to a style automatically update all text linked to it, eliminating the need for manual adjustments.

(b) A Page Break forces content after it to start on a new page, useful for separating chapters or sections. A Section Break divides the document into independent segments, allowing different formatting (like columns or margins) within the same page.

Question 18.
Ms. Priya, Finance Head of XYZ Enterprises, has maintained quarterly expense reports for different departments in separate worksheets of a LibreOffice Calc file. She now wants to consolidate and analyse the data. Assist her by answering the following:
(a) Which feature in Calc can merge expense data from multiple sheets into one consolidated sheet?
(b) Specify the Menu and Sub-Menu option used to create a summary of all quarterly worksheets.
(c) Which function should she use to calculate the average expenditure across all departments?
(d) She wants to link a cell to an external budget document stored elsewhere. How can she achieve this
Answer:
(a) The Consolidate Data tool in Calc can combine data from multiple sheets into a summary sheet using predefined functions like sum or average.
(b) Navigate to Data Menu → Consolidate to open the dialog box for generating a combined summary.
(c) The ==AVERAGE() function can compute the average expenditure by referencing the consolidated data range.
(d) Use Insert → Hyperlink (or Ctrl+K) to link the cell text to the external document’s file path, enabling one-click access.

Question 19.
As the newly appointed Workplace Safety Officer at a manufacturing unit, you need to educate employees on accident prevention and emergency response. Answer the following:
(a) Suggest two preventive measures to avoid electrical accidents in the workplace.
(b) Outline two key steps to follow during an emergency evacuation due to a chemical spill.
Answer:
(a) Two Preventive Measures to Avoid Electrical Accidents:

• Regular Inspections Conduct scheduled checks of wiring and equipment to identify and fix faults like frayed cords or exposed circuits.
• Safety Training Train employees to use insulated tools, avoid overloading outlets and follow lockout/tagout procedures during repairs.

(b) Two Key Steps for Chemical Spill Evacuation:

• Sound Alarms and Evacuate Immediately activate emergency alerts and guide workers to follow marked exit routes away from the spill.
• Avoid Exposure and Regroup Move upwind, use safety showers if contaminated and assemble at designated points for headcount and further instructions.

Question 20.
(a) What are two key benefits of establishing relationships between tables in a database?
(b) Describe how a one-to-many relationship works between database tables.
Answer:
(a) Two key benefits are:

• It eliminates data redundancy by storing information in separate but related tables, reducing storage needs and maintaining consistency.
• It ensures data integrity by enforcing referential constraints that prevent orphaned records and maintain accurate relationships between data.

(b) A one-to-many relationship occurs when a single record in the primary table (like a customer) can be associated with multiple records in a related table (like orders). This is implemented through a foreign key in the ‘many’ table that references the primary key in the ‘one’ table.

Question 21.
Consider the following table:

EmpID	Name	Department	Salary	Join_Date
E001	Rahul	Sales	35000	12/05/2020
E002	Neha	HR	42000	03/11/2019
E003	Rahul	IT	38000	22/07/2021

Answer the following questions:
(a) While designing this employee database in LibreOffice Base, suggest appropriate data types for the Emp_ID and Salary fields.
(b) As a database administrator, which field would you designate as the primary key in this table? Justify your choice.
(c) Identify a field that could serve as an alternate key in this table. Explain your reasoning.
(d) How many attributes (fields) and records (rows) are present in this table?
Answer:
(a) Emp_ID VARCHAR or TEXT (to store alphanumeric employee codes)
Salary DECIMAL or INTEGER (to store numerical salary values with precision)

(b) Emp_ID should be the primary key because

• It uniquely identifies each employee (no duplicates exist).
• It remains constant (unlike names which may repeat).

(c) Join_Date + Name could serve as an alternate key because:

• The combination is likely to be unique for each employee.
• It can help identify employees when their ID isn’t known.

(d) Attributes (fields) 5 (Emp_ID, Name, Department, Salary, Join_Date) Records (rows) 3

The post CBSE Sample Papers for Class 10 IT Set 9 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