Preparing for the CBSE Class 10 Information Technology (Code 402) examination becomes much easier and more effective with the help of sample question papers. The CBSE Class 10 IT 402 Sample Question Paper 2024-25 with Solution is specially designed according to the latest syllabus and exam pattern issued by CBSE. By practicing these sample papers, students get a clear idea about the types of questions that may appear in the actual board examination, including MCQs, short answer questions, and practical-based scenarios. It also helps in improving time management skills and building confidence before the final exam.
For teachers, sample question papers serve as an excellent teaching and assessment tool. They can use these papers to conduct mock tests, evaluate students’ preparation level, and identify weak areas that need more focus. The included solutions make it easier to explain concepts in a step-by-step manner, ensuring students understand the correct approach to answering questions. Overall, CBSE Class 10 IT 402 Sample Question Papers with solutions are a valuable resource for both students and teachers to enhance exam readiness, strengthen conceptual clarity, and achieve better performance in the CBSE board exams.
CBSE Class 10 IT 402 Sample QP 2024-25 with Solution
You can download the free PDF of this sample pre-board question paper from our website and start practicing today. Download Link available in last.
The Year-Wise CBSE Class 10 Information Technology (402) Pre-Board and Sample Question Papers with Solutions are provided at the bottom of this post.
CBSE Class 10 IT 402 Sample Question Paper Session (2024-25)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE - 402)
Sample Question Paper (SQP) Solution for Class X (Session 2024-2025)
Max. Time: 2 Hours
Max. Marks: 50
General 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
Q.1 Answer any 4 out of the given 6 questions on Employability Skills (1X4=4 marks)
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
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
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
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
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
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
Q.2 Answer any 5 out of the given 6 questions (1X5=5 marks)
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
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
iii. How many levels of headings does LibreOffice Writer support?
a) 5
b) 8
c) 10
d) 12
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
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
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
Q.3 Answer any 5 out of the given 6 questions (1X5=5 marks)
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
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.
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.
iv. It allows the placement of image in relation to text
a) Water mark
b) Trade mark
c) Copyright
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.
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
Q.4 Answer any 5 out of the given 6 questions (1X5=5 marks)
i. A _________ hyperlink stores the location with respect to the current location in LibreOffice Calc.
a) Absolute
b) Relative
c) Mixed
d) Reference
ii. _________ is a text editor that allows you to create and edit macros.
a) IDE (Integrated Development Environment)
b) Notepad
c) Open Office Writer
d) MS Word
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.
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.
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
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
Q.5 Answer any 5 out of the given 6 questions (1X5=5 marks)
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.
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
iii. What feature in OpenOffice Base allows users to present retrieved data in a user-friendly and formatted manner?
a) Query
b) Form
c) Report
d) Data view
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
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
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
SECTION B: SUBJECTIVE TYPE QUESTIONS
Answer any 3 out of the given 5 questions on Employability Skills (2X3=6 marks) Answer each question in 20 – 30 words.
Q.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?
Ans: (i) Sarah should speak slowly and clearly using simple language.
(ii) She should pause in between and allow her team to ask questions for better understanding.
Q.7 What are the functions of Entrepreneurs?
Ans: Functions of an Entrepreneur are:
(i) Making important business decisions
(ii) Managing and planning the business
(iii) Dividing income for expenses like rent, materials, and salaries
(iv) Taking business risks
(v) Creating new ideas or new products to improve the business
Q.8 List the various ways you can use to protect your data.
Ans: To safeguard your data from theft and viruses, consider the following measures:
(i) Use strong passwords with letters, numbers, and special characters
(ii) Install antivirus software and enable firewall protection
(iii) Encrypt important data to keep it safe from unauthorized access
(iv) Share personal or bank details only on secure websites (https)
Q.9 Riya, a Class X student, feels stressed with her exam preparation, extracurricular activities, and family commitments. How can tracking time help her?
Ans: Tracking time helps to:
(i) It helps her plan her study and activity schedule properly
(ii) She can manage time for exams, activities, and family work easily
(iii) It reduces stress by avoiding last-minute pressure
(iv) She can focus better and complete tasks on time
(v) It helps maintain a balance between study and rest
Q.10 Why has United Nations has made the 17 Sustainable Development Goals?
Ans: The United Nations made the 17 Sustainable Development Goals (SDGs) in 2015 to solve major problems faced by the world.
These goals focus on issues like poverty, gender equality, clean water, energy, climate change, and protecting nature. Countries are encouraged to make laws and plans to support sustainable development so that everyone can have a safe, affordable, and better future.
Answer any 4 out of the given 6 questions (2X4=8 marks) Answer each question in 20 – 30 words.
Q.11 In Open Office Writer, what are the styles? List two Open Office Writer style options.
Ans: In OpenOffice Writer, styles are pre-designed formatting sets used to make text look consistent and well-organized in a document. They help in quickly changing the appearance of text like font, size, color, and spacing.
Two style options in OpenOffice Writer are:
(i) Paragraph Style - used to format whole paragraphs
(ii) Character Style - used to format selected words or letters
Q.12 Differentiate between safety and security of an employee.
Ans: Safety of an employee means protection from accidents, injuries, and physical harm at the workplace, such as using safety equipment and following rules.
Security of an employee means protection from threats like theft, violence, job loss, or misuse of personal information.
Simply, safety protects the body, while security protects the job and personal well-being.
Q.13 What are the benefits of sharing a spreadsheet?
Ans: A shared spreadsheet is a single sheet that can be accessed by more than one user at the same time. It allows users to make changes simultaneously. It saves time and avoids confusion of maintaining multiple copies. Sharing also helps in collaboration where everyone can contribute, edit, and view the data easily.
Q.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 5th subject to get the required percentage?
Ans: Tools Menu > Goal Seek
Q.15 In a database, why is it important to create relationships between the tables?
Ans: It is important to create relationships between tables in a database to connect related data and keep it organized. Relationships help avoid data duplication and maintain accuracy. They also make it easier to retrieve, update, and manage information from different tables in a proper way.
Q.16 What is Occupational Overuse Syndrome? What are the causes for it?
Ans: Occupational Overuse Syndrome, also called Repetitive Strain Injury (RSI), is a group of problems that cause pain or discomfort in muscles, tendons, and soft tissues.
It usually happens due to repeated movements, working in the same position for a long time, or using too much force while working.
Answer any 3 out of the given 5 questions (4X3=12 marks) Answer each question in 50 – 80 words.
Q.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?
Ans: Track Changes is a useful feature that helps people edit and review a document easily. It keeps a record of all changes made by different users instead of replacing the original content.
With Track Changes, every edit is shown clearly and the original author can accept or reject the changes. This helps in safe editing without losing the original document.
b) Which menu option can be used to access this feature?
Ans: View > Toolbars > Track Changes
c) Can reviewers add comments?
Ans: Yes
d) Once the changes are made by all the reviewers, who can accept or reject them?
Ans: Original Author (Admin)
Q.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?
Ans: Repetitive tasks such as calculating average marks, ranking teams, and creating graphs can be done easily using macros. Macros help save time and reduce effort by doing the same work automatically.
b) How to enable Macro in Calc?
Ans: To enable Macro in Calc, go to Tools Menu → Options → LibreOffice → Advanced.
In the Optional Features section, tick the option “Enable macro recording” and click OK.
c) Is solution*word a valid macro name? Justify
Ans: 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) Mention any one operation which cannot be recorded by macro.
Ans: Some operations which cannot be recorded by a macro are:
(i) Changing window size or position
(ii) Opening or closing files
(iii) Actions done outside the spreadsheet area
Q.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?
Ans: A form is a database object that provides a simple and user-friendly way to enter and view data. It works as the front end of the database where users can easily add, edit, and see data in a neat format.
b) What are the different ways to create forms in DBMS?
Ans: There are two ways to create a form: (i) Using a wizard (ii) Using the Design View
c) Where can we find various tools to add or edit controls on the form?
Ans: Form Control Toolbar
d) What is the use of the Records Toolbar in a form?
Ans: 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.
Q.20 What points should be included in Fire Prevention Plan in the office?
Ans: (i) Employees should know where fire extinguishers are and how to use them
(ii) Fire extinguishers and first aid boxes should be clearly marked
(iii) Do not block exits, fire extinguishers, or electric panels
(iv) Keep doors clear so they can open easily during emergencies
(v) Do not keep flammable items near electrical equipment
(vi) Check fire extinguishers regularly for proper working
Q.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?
Ans: A Database Management System (DBMS) is software that helps users create, manage, and manipulate databases. It allows for efficient data storage, retrieval, and organization.
It also helps in maintaining data accuracy, security, and reducing data duplication. DBMS makes it easy to update, search, and handle large amounts of information quickly.
b) What are the advantages of using DBMS?
Ans: Advantages of using DBMS:
(i) Reduces Data Duplication - Same data is not stored again and again, which saves storage space.
(ii) Improves Data Accuracy - DBMS keeps data correct and updated in all places.
(iii) Provides Data Security - Only authorized users can access or change data.
(iv) Quick Data Retrieval - Data can be searched and found quickly using queries.
(v) Better Data Organization - Data is stored in a structured and neat way.
c) Name any two database programs that can be used to create a table and store the data according to his requirements.
Ans: MySQL, MS Access, Oracle, Open Office Base, PostgreSQL, SQLite, IBM DB2, FoxPro etc.
d) Which field can be set as a Primary Key?
Ans: The ISBN (International Standard Book Number) can be set as a primary key, as it uniquely identifies each book in the inventory.
Download Now - Class 10 IT 402 Sample Question Paper 2024-25 with Solution
