CBSE Sample Papers for Class 10 IT Set 1

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 05 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

Question 1.
Answer any 4 out of the given 6 questions on Employability Skills (1×4=4)
(i) Rahul moved to Japan from India for work. However, he struggles to adapt
because he is not familiar with Japanese customs and etiquette, which affects his
interactions with coworkers. This is an example of:
(a) Interpersonal barrier
(b) Cultural barrier
(c) Physical barrier
(d) Linguistic barrier
Answer:
(b) Cultural barrier
(ii) Amina studies diligently to improve her grades because she wants to feel proud
of her achievements and also earn a scholarship. What type of motivation is this?
(a) Internal
(b) External
(c) Both internal and external
(d) Not any specific type of motivation
Answer:
(c) Both internal and external

(iii) Rajesh launches a new app, but it fails to attract users and he faces financial
losses. He gathers his team to discuss the failure, takes accountability for the
oversight, and assures them that he will conduct thorough market research before
the next launch. He ………..
(a) takes responsibility for his mistakes
(b) thinks before making a decision
(c) does not give up
(d) is innovative
Answer:
(a) takes responsibility for his mistakes

(iv) Which of the following best describes self-management?

(a) The ability to ignore emotions and focus solely on tasks
(b) The ability to control one’s emotions, thoughts, and behavior in various situations
(c) The ability to manage time efficiently without considering feelings
(d) The ability to rely on others for emotional support
Answer:
(b) The ability to control one’s emotions, thoughts, and behavior in various situations

(v) A community initiates a tree-planting campaign to restore local forests, aiming to

enhance biodiversity, prevent soil erosion, and provide habitats for wildlife. This
initiative also includes educating residents about sustainable land use practices to
protect their natural environment. Which SDG can you relate this initiative to?
(a) Clean Water and Sanitation
(b) Life on Land
(c) Affordable and Clean Energy
(d) Climate Action
Answer:
(b) Life on land

Educational Programs

(vi) How can an anti-virus protect your device?

(a) It can protect it from over-heating
(b) It can increase its performance
(c) It can prevent data from getting corrupt
(d) It can backup data
Answer:
(c) It can prevent data from getting corrupt

Question 2.
Answer any 5 out of the given 6 questions (1×5=5)
(i) Which feature in Writer allows you to apply the same style to multiple words
scattered throughout the document?
(a) Format Painter
(b) Fill Format option
(c) Style Inspector
(d) Font Adjustment Tool
Answer:
(b) Fill Format option

(ii) Which feature allows you to jump to a different document, spreadsheet, or

website from within a document?
(a) Bookmark
(b) Page Break
(c) Hyperlink
(d) Format Painter
Answer:
(c) Hyperlink

(iii) How many levels of headings does LibreOffice Writer support?

(a) 5
(b) 8
(c) 10
(d) 12
Answer:
(c) 10

(iv) Which of the following is NOT true about templates?

(a) The styles and formatting features can be reused.
(b) Libre Office provides online templates
(c) Templates can have headings, text formats, styles, page numbers, headers and
footers
(d) We cannot create our own templates
Answer:
(d) We cannot create our own templates

(v) Radha is planning a school event and wants to decide how much money to
allocate for different activities, like games, food, and decorations. She creates
several different budget plans to see how changing the amount for each category
affects the total expenses.
How can Radha efficiently compare the different budget plans for her school event in
the same spreadsheet?
(a) By writing down each budget on paper
(b) By using the What-if scenario feature in the spreadsheet to create and analyze
different budget options
(c) By asking her friends to guess the costs
(d) By using the Filter function to look at one category at a time
Answer:
(b) By using the What-if scenario feature in the spreadsheet to create and analyse
different budget options

School supplies
(vi) What is the main goal of applying ergonomics in an office setting?
(a) To increase the amount of work done in a shorter time
(b) To design tasks that are more interesting for employees
(c) To ensure easy and safe use of equipment, reducing the risk of injury
(d) To promote social interactions among employees
Answer:
(c) To ensure easy and safe use of equipment, reducing the risk of injury

Question 3.
Answer any 5 out of the given 6 questions (1×5=5)
(i) The code of macro begins with → followed by the name of the macro and ends
with → .
(a) Function, End
(b) Sub, End Sub
(c) Sub, End Function
(d) Sup, End Sup
Answer:
(b) Sub, End Sub

(ii) What is the benefit of inserting an image as a link in a document?

(a) It reduces the document size by storing only the reference to the image.
(b) It enhances the image quality.
(c) It allows for automatic image editing within the document.
(d) It removes the need for image captions.
Answer:
(a) It reduces the document size by storing only the reference to the image.

(iii) After incorporating the reviews, Krishna mailed the document to his editor with
the Track Changes ON. He made certain changes in the document. Pradeep wants
to compare his original document with the reviewed document. What is the first step
Krishna should take to compare his edited document with the original document?
(a) Open the Manage Changes dialog box.
(b) Select Edit → Track Changes → Compare Documents option.
(c) Save the edited file.
(d) Accept or reject the desired changes.
Answer:
(b) Select Edit → Track Changes → Compare Documents option.

(iv) It allows the placement of image in relation to text

(a) Water mark
(b) Trade mark
(c) Copyright
(d) Text Wrapping
Answer:
(d) Text Wrapping

(v) What is the primary function of the Subtotal tool in Calc?

(a) It creates a chart for the data.
(b) It automatically groups data and applies common functions like sum and average.
(c) It highlights cells with conditional formatting.
(d) It removes duplicate data from the spreadsheet.
Answer:
(b) It automatically groups data and applies common functions like sum and average.

(vi) What is one way to mitigate hazards associated with prolonged computer use?
(a) Increasing screen brightness
(b) Stretching at regular intervals or doing simple yoga
(c) Using a smaller screen
(d) Sitting in a fixed position
Answer:
(b) Stretching at regular intervals or doing simple yoga

Question 4.
Answer any 5 out of the given 6 questions (1×5=5)
(i) A ………… hyperlink stores the location with respect to the current location in
LibreOffice Calc.
(a) Absolute
(b) Relative
(c) Mixed
(d) Reference
Answer:
(b) Relative

(ii) ………… is a text editor that allows you to create and edit macros.
(a) IDE
(b) Notepad
(c) Open Office Writer
(d) MS Word
Answer:
(a) IDE
(iii) Which of the following best defines “information”?
(a) Unprocessed raw facts such as names, marks, and addresses.
(b) Organized and processed data that provides meaningful insights.
(c) Audio, video, and graphics stored without any processing.
(d) A collection of unrelated raw facts.
Answer:
(b) Organized and processed data that provides meaningful insights.

(iv) What does referential integrity in a database ensure?

(a) All primary keys are unique across the database.
(b) All records in a table must have a value in every column.
(c) Every foreign key value must match a primary key in the referenced table or be
null.
(d) Data can be freely deleted from any table without constraints.
Answer:
(c) Every foreign key value must match a primary key in the referenced table or be
null.

(v) What should you do with the problem of dry eyes?

(a) Forget to blink
(b) Rest eyes periodically and do simple eye exercises
(c) Do exercise
(d) Blink the eyes
Answer:
(b) Rest eyes periodically and do simple eye exercises

(vi) Which of the following data models sets a relation between the two or more
tables?
(a) Relational Data Model
(b) Network Data Model
(c) Hierarchical Data Model
(d) Connection Data Model
Answer:
(a) Relational Data Model

Question 5.
Answer any 5 out of the given 6 questions (1×5=5)
(i) Which of the following statements are true about primary key in a database?
(a)It is a field that can have duplicate values.
(b) It uniquely identifies each record in a table.
(c) It can have null values
(d) It is an optional field in a database table.
Answer:
(b) It uniquely identifies each record in a table.

(ii) Which of the following dialog boxes appears when the Query Design window is
opened for the first time to design a query?
(a) Add Table
(b) Add Query
(c) Add Query or Report
(d) Add Table or Query
Answer:
(d) Add Table or Query

(iii) What feature in Open Office Base allows users to present retrieved data in a
user-friendly and formatted manner?
(a) Query
(b) Form
(c) Report
(d) Data view
Answer:
(c) Report

(iv) Which of the following is a recommended way to manage stress at work?

(a) Engage in aggressive conflicts with colleagues
(b) Work longer hours without breaks
(c) Seek conflict resolution strategies with colleagues
(d) Avoid hobbies that promote relaxation
Answer:
(c) Seek conflict resolution strategies with colleagues

(v) Which of the following can lead to musculoskeletal problems while working on a
computer?
(a) Using anti glare screen
(b) Sitting in a wrong posture and using an uncomfortable chair
(c) Using Air Conditioners
(d) Taking frequent breaks
Answer:
(b) Sitting in a wrong posture and using an uncomfortable chair

(vi) In a situation where a small fire breaks out in the office, what should you use to
address the emergency?
(a) A Blanket
(b) A Fire Extinguisher
(c) A Towel
(d) Baking Soda
Answer:
(b) A fire extinguisher

Section B
Subjective Type Questions
Answer any 3 out of the given 5 questions on Employability Skills. Answer each
question in 20-30 words. ( 2×3=6)

Question 6.
During a team meeting, Sarah is explaining a complex project idea to her colleagues.
She speaks too quickly, uses jargon, and doesn’t pause for questions. As a result,
her team seems confused, and the project isn’t fully understood. What can Sarah do
to improve her verbal communication skills?
Answer:
Think Before You Speak

 Think about your topic.

 Think about the most effective ways to make your listeners understand the
topic.
 Write or note down whatever you plan to say.

Concise and Clear

 Speak clearly, loudly and at moderate speed.

 Be sure the information you want to share is to the point.
 Do not repeat the same sentences.

Confidence and Body Language

 Be confident.
 Be friendly
 Maintain eye contact, stand straight and be attentive.

Question 7.
What are the functions of Entrepreneurs?
Answer:
Functions of an Entrepreneur are:

 Making Decisions Entrepreneurs make daily choices about what to produce or

sell, pricing, and market locations.
 Managing the Business They plan the business’s future, arrange for raw
materials, hire staff, and ensure plans are followed.
 Dividing Income Entrepreneurs allocate business funds for materials, rent, and
salaries.
 Taking Risks They face risks related to fires, theft, and lost items.
 Creating New Methods, Ideas, or Products Entrepreneurs innovate to enhance
their business’s significance and profitability.

Question 8.
List the various ways you can use to protect your data.
Answer:
To safeguard your data from theft and viruses, consider the following measures:

 Use Strong Passwords Create difficult-to-guess passwords using a mix of

lowercase and uppercase letters, numbers, and special characters. This
prevents unauthorized access to your computer.
 Install Anti-virus and Firewall These tools monitor incoming and outgoing data,
preventing viruses from entering and detecting any that may have already
accessed your system.
 Encrypt Data Important information can be encrypted using tools like BitLocker,
requiring a decryption password to access the hard disk, thus blocking
unauthorized usage.
 Secure Sites Only share credit card or bank information on secure sites,
indicated by “[Link] and a lock symbol in the browser’s address bar.

Question 9.
Riya, a Class X student, feels stressed with her exam preparation, extracurricular
activities, and family commitments. How can tracking time help her?
Answer:
Tracking time helps to:

 Identify time-wasting activities and unproductive habits

 Improve time management for studies and tasks
 Balance academics with extracurriculars and personal time
 Allocate time for relaxation and self-care
 Achieve academic goals more efficiently and reduce stress before exams

Question 10.
Why has United Nations has made the 17 Sustainable Development Goals?
Answer:
The 17 SDGs have been made with the aim of taking care of important issues facing
businesses, governments and society. Some of these issues are poverty, gender
equality, water use, energy, climate change and biodiversity. Countries are now
making policies and regulations that will promote sustainable systems needed in all
economic sectors to provide a secure, affordable and sustainable economy.

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

Question 11.
In OpenOffice Writer, what are the styles? List two OpenOffice Writer style options.
Answer:
A Style is a collection of all formatting information, which you want to save and then
apply on the document. Writer provides six Style categories – Page, Paragraph,
Character, Frame, List and Table.(Mention any two)
Question 12.
Differentiate between safety and security of an employee.
Answer:
Safety The work environment of the organisation must be safe. It must be free from
hazards and risks. A hazard is something that can cause harm to the people Security
Every employee working in an organisation must feel that they are secured in the
company campus. Security is a kind of freedom from any potential harm. Security
ensures the safety of the people working in the organisation. This include various
security such as personal safety, computer system safety, electrical safety, transport
safety and other equipment safety.

Question 13.
What are the benefits of sharing a spreadsheet?
Answer:
A shared spreadsheet is a same sheet that can be accessed by more than one user
and can allow them to make changes simultaneously on it. It saves the trouble of
keeping track of multiple copies of the same spreadsheet. Sharing allows working in
collaboration so that everyone can contribute, make changes and view it.

Question 14.
Guneet has completed his assessments in four subjects and received the following
marks: 75 in Math, 68 in Science, 82 in English, and 70 in History. The student
needs to achieve an overall aggregate of 75% across all five subjects to meet his
academic goals. He still has to take the exam in the fifth subject, which is
Geography. Which Calc tool and menu option he can use to check how many marks
he has to score in the 5 th subject to get the required percentage?
Answer:
Tools → Goal Seek

Question 15.
In a database, why is it important to create relationships between the tables?
Answer:
While working with multiple tables, you need to check the redundancy and
inconsistency of data. The record for a particular entity should neither be repeated
nor different data values should appear for a single entity in the database. This is
done by setting relationships between the tables of a database.

Question 16.
What is Occupational Overuse Syndrome? What are the causes for it?
Answer:
Occupational overuse syndrome, also known as repetitive strain injury (RSI), refers
to a range of conditions characterized by discomfort or persistent pain in muscles,
tendons, and other soft tissues, with or without visible physical symptoms. This
syndrome is typically caused or worsened by work-related factors, including
repetitive movements, sustained or awkward postures, and forceful actions.
Psychosocial factors, such as workplace stress, can also contribute to the
development of occupational overuse syndrome.
Answer any 3 out of the given 5 questions in 50-80 words each (4×3=12)

Question 17.
A team of writers is collaborating on a report using a word processing software with a
Track Changes feature. One writer creates the initial draft, which then needs to be
reviewed and edited by the rest of the team.
(a) Why is the Track Changes feature essential for collaborative document editing?
(b) Which menu option can be used to access this feature?
(c) Can reviewers add comments?
(d) Once the changes are made by all the reviewers, who can accept or reject them?
Answer:
(a) Track Changes is a powerful tool that makes the process of commenting, editing
and reviewing a document easy between multiple users.
A document created by one user needs to be reviewed and edited by self or other
users. If any modifications are made in the document directly, the original document
might get lost.
Instead, the Track Changes feature of Writer offers an alternative method to keep a
record of all the changes made in the original document. All the changes that are
recorded can be either accepted or rejected by the original author.
(b) View → Toolbars → Track Changes.
(c) Yes
(d) Original Author

Question 18.
A Class X student is participating in a school competition where they need to analyse
the performance of different sports teams based on match scores and statistics. The
student has collected data over several matches and needs to calculate averages,
determine rankings, and generate charts for a presentation.
(a) How are Macros in Calc helpful to him?
(b) How to enable Macro in Calc?
(c) Is solution word a valid macro name? Justify
(d) Mention any one operation which cannot be recorded by macro.
Answer:
(a) Repetitive tasks like calculating average scores, ranking teams based on
performance, and generating graphs could be done with macros. It will save time
and effort.
(b) Tools → Options → LibreOffice → Advanced. Observe the Optional Features.
Two options are not check marked. Put the checkmark on the option “Enable macro
recording”
(c) No, solution*word is not a valid macro name. Macro names cannot include
special characters such as asterisks (*) or spaces. Valid characters typically include
letters, numbers, and underscores.
(d) Opening or switching of windows

School supplies
Question 19.
A health clinic is developing a patient management system to streamline patient
intake, appointments, and medical records. They need to implement forms for
various purposes, including new patient registration, appointment scheduling, and
updating medical histories.
(a) What is the use of form in DBMS?
(b) What are the different ways to create forms in DBMS?
(c) Where can we find various tools to add or edit controls on the form?
(d) What is the use of the Records Toolbar in a form?
Answer:
(a) A form is an object of the database that has a user-friendly interface where data
can be entered and seen in an attractive and easy-to-read format. For any database,
it is the front end for data entry and data modification
(b) There are two ways to create a form:

 Using a wizard
 Using the Design View

(c) Forms Control Toolbar

(d) The Records toolbar contains the navigation control buttons in the extreme left.
With the help of these buttons, we can traverse and view the records in the file

Question 20.
What points should be included in Fire Prevention Plan in the office?
Answer:

 All employees must know where the fire extinguishers are located, and how to
properly use them.
 Fire extinguishers and First Aid Stations should be clearly marked with signs.
 Never block access to Exits, fire extinguishers, electric switches and panels.
 Do not block or stack material against doors, which would prevent them from
operating properly in event of a fire.
 Do not use flammable material near electrical panels, switches, lift trucks or
any electrical equipment.
 Make sure all equipment is properly grounded where needed.
 Fire extinguishers must be inspected regularly.
 Report to your supervisor of any defect in electrical, fire prevention or material
handling equipment.
 No flammable material are to be placed around an exit door way. (Any 4
points)

Question 21.
Your cousin runs a small bookstore and wants to maintain an inventory of books. He
needs to record information such as book titles, authors, ISBNs, publication dates,
prices, and stock levels. However, he is not familiar with database management
systems. Explain the following concepts to help him understand DBMS:
(a) What is DBMS?
(b) What are the advantages of using DBMS?
(c) Name any two database programs that can be used to create a table and store
the data according to his requirements.
(d) Which field can be set as a Primary Key?
Answer:
(a) A Database Management System (DBMS) is software that helps users create,
manage, and manipulate databases. It allows for efficient data storage, retrieval, and
organization.

Bookshelves
(b) Advantages of using DBMS

 Data Integrity Ensures accuracy and consistency of data.

 Data Security Provides access controls to protect sensitive information.
 Reduced Data Redundancy Minimizes duplication of data across the database.
 Data Management Simplifies data handling through structured query language
(SQL)

(c) Two database programs:

 MySQL
 Open Office Base

(d) The ISBN (International Standard Book Number) can be set as a primary key, as
it uniquely identifies each book in the inventory.