Preparing with the CBSE Class 10 IT 402 Sample QP 2023-24 with Solution is an excellent way for students to strengthen their board exam preparation. CBSE Class 10 IT 402 sample question papers are designed according to the latest syllabus and exam pattern issued by the Central Board of Secondary Education. By practicing these papers, students get a clear idea of important topics, question formats, and marking schemes, which helps reduce exam fear and improves overall performance.
The biggest benefit of using solved sample papers is that students can easily check their answers and understand the correct approach to each question. This helps in identifying mistakes and improving weak areas before the final examination. Regular practice also improves time management skills, making students more confident during the real exam.
CBSE Class 10 IT 402 Sample QP 2023-24 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 (2023-24)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE - 402)
Sample Question Paper (SQP) Solution for Class X (Session 2023-2024)
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. When it is difficult to communicate with someone who is not willing to talk or express their feelings and views it means there is a/an _________.
a) Culture Barrier
b) Interpersonal Barrier
c) Physical Barrier
d) Language Barrier
ii. Kartik’s Computer was running very slow, hangs and often restarts. He is very confused and tensed as he was working on a very important assignment. Kartik’s friend gave him the following suggestions. Identify who has given him a genuine suggestion.
a) Radha : Restart your machine
b) Ishan : Install reliable antivirus software and update
c) Amar : Don’t use Pendrive
d) Sam : Install free antivirus from net
iii. _________ refers to focusing human efforts for maintaining a healthy body and mind capable of better withstanding stressful situations.
a) Self-Motivation
b) Stress Management
c) Self-Awareness
d) Self-Regulation
iv. High expectations from self can leave with chronic anxiety and stress, thus leading to _________ stress.
a) Physical
b) Emotional
c) Mental
d) Financial
v. Which of the following is/are a myth about Entrepreneurship?
a) Need a lot of Money
b) Must have a great Idea
c) Should know everything about business
d) All of these
vi. Name the organization that has the Sustainable Development Goals?
a) UNICEF
b) League of Nations
c) United Nations
d) World Health Organization
Q.2 Answer any 5 out of the given 6 questions (1X5=5 marks)
i. Which one is not the tab of the insert/index Table window of Writer Document?
a) Entries
b) Background
c) Style
d) Row
ii. In the custom styles, each ______ field on the Structure line represents a blank space in a document.
a) Black
b) White
c) Blue
d) Yellow
iii. Saurabh has made an advertisement in Digital Document. He is facing difficulty in positioning the images within the text. Suggest him how he can adjust the image?
a) Wrap text
b) Crop
c) Alignment
d) Layout
iv. A ______ is a collection of records that store data in Mail merge.
a) Data Source
b) Main Document
c) Document
d) Merge Field
v. To increases the contrast of an image, ________ option is used in a document.
a) Smooth
b) Sharpen
c) Aging
d) mosaic
vi. _____ provide Internet access by transmitting digital data over wires of a local telephone network.
a) ISP
b) DSL
c) Dial-up connection
d) Modem
Q.3 Answer any 5 out of the given 6 questions (1X5=5 marks)
i. ______ is specifically designed to minimize the results according to a set rules that we define in a spreadsheet.
a) Goal Seek
b) Scenario
c) solver
d) Subtotal
ii. Sahil and his partners have created a list of their company employees in one of the spreadsheets in the office. Now the rest of the task they want to complete from home. Which option they should use to access the same Spreadsheet from home?
a) Consolidate Worksheet
b) Link Worksheet
c) Merge Worksheet
d) Lock Worksheet
iii. ______ can help to clarify the relation between cells while using “Multiple Operations”.
a) Detective
b) Solver
c) Navigation
d) Hyperlink
iv. Identify the part of a Spreadsheet using which a user can manage multiple sheets.
a) Status Bar
b) Sheet Tab
c) Formula Bar
d) Worksheet Area
v. Spreadsheet software can find the changes by ______ sheets.
a) Changing
b) Comparing
c) Renaming
d) Editing
vi. At the bottom of each worksheet, left tab indicates the ________ of the worksheet in a workbook.
a) Size
b) 3 Type
c) Name
d) Color
Q.4 Answer any 5 out of the given 6 questions (1X5=5 marks)
i. It enables users to view, enter, and change data directly in database objects.
a) Report
b) Query
c) Form
d) Database
ii. There are _______ types of Relationships in a table of a database.
a) One
b) 3
c) 4
d) Many
iii. A Relational database uses ________ commands which is a standard user application that provides an easy programming interface for database interaction.
a) Access
b) Python
c) SQL
d) Protocol
iv. Suraj wants to create a database for his clients. For this purpose, she needs to store the Email IDs of his clients. Which datatype should he use to accomplish this purpose?
a) Numeric
b) Varchar
c) Binary
d) Boolean
v. Geet has written a SQL query in SQL view. But he doesn’t know how to execute the query using keyboard keys. Suggest him the shortcut key to complete the task.
a) Enter
b) Ctrl + E
c) Space bar
d) F5
vi. A table can have only _______ primary key in a database.
a) 1
b) 2
c) 3
d) Many
Q.5 Answer any 5 out of the given 6 questions (1X5=5 marks)
i. __________ key is an accessibility feature that assists people having difficulty in using keyboard and mouse.
a) Guide
b) Sticky
c) Serial
d) Home
ii. Anaisha is a wildlife photographer. She wants to create her website where she can update the pictures and discuss about different events, reviews, announcements, news etc. Suggest her a suitable option to complete the task.
a) Blog
b) E-Mail
c) Instant Messaging
d) Mail Merge
iii. Which of the following is not a web browser?
a) Safari
b) Internet Explorer
c) Google
d) Firefox
iv. Which out of the following is the best example of a strong password?
a) 9412356789
b) 14Hd{]$_Sb10
c) HarryPotterSeries
d) 14Oct2004
v. Bharat has set up his company with 20 computers in a building. He wants to connect all the computers together. Which type of Network will be the best suitable for this purpose?
a) LAN
b) WAN
c) PAN
d) MAN
vi. IP stands for ________ .
a) International Protocol
b) Internet Protocol
c) Intranet Protocol
d) Interpersonal Protocol
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 What are the learning objectives of communication?
Ans: The learning objectives of effective communication are to properly send, receive, and understand messages or information. It also helps in developing interpersonal skills and enables a person to express ideas clearly and effectively with maximum efficiency.
Q.7 Why do we say that an entrepreneur should be open-minded?
Ans: We say that an entrepreneur should be open-minded because they need to accept new ideas, suggestions, and changes. Being open-minded helps them learn from others, solve problems better, and improve their business. It also allows them to adjust to new situations and make smart decisions for success.
Q.8 How is self-regulation connected to the ability to work independently?
Ans: The ability to work independently becomes better by being self-regulated. Self-regulation helps a person think about long-term results instead of temporary feelings. It encourages responsible and value-based behavior. It also teaches self-control and focused efforts to achieve goals. Being self-regulated includes discipline, which helps a person keep working consistently towards success.
Q.9 How we can prevent computer against attack by viruses.
Ans: We can prevent a computer from virus attacks in the following ways:
(i) Install proper antivirus software in the computer
(ii) Enable the firewall for protection
(iii) Scan external devices like pen drives before using them
(iv) Avoid opening suspicious or unknown emails
(v) Be careful while downloading files or programs from the internet
Q.10 “Green economy promotes sustainable development”. Justify the statement.
Ans: Because it focuses on using natural resources in a way that they can last for a long time. Green growth strategies aim to protect natural assets like air, water, and biodiversity while still supporting economic growth. Clean air and water help in maintaining good health, and a healthy environment supports food production. In this way, the green economy balances economic progress with environmental protection for the future.
Answer any 4 out of the given 6 questions (2X4=8 marks) Answer each question in 20 – 30 words.
Q.11 What do you understand by Anchoring in Word Processor?
Ans: Anchoring in a word processor means fixing an object like an image, shape, or text box to a specific part of the document (such as a paragraph, page, or character).
When an object is anchored, it moves along with the text it is attached to while editing. This helps in keeping the layout of the document neat and organized.
Q.12 What do you mean by Sorting in a Spreadsheet?
Ans: Sorting in a spreadsheet means arranging data in a particular order, such as in ascending (A to Z, smallest to largest) or descending (Z to A, largest to smallest) order.
It helps to organize information clearly and makes it easier to find and analyze data.
Q.13 State any four etiquettes to be followed while chatting on the internet.
Ans: Etiquettes to be followed while chatting on the internet:
(i) Be polite and respectful to others
(ii) Do not use rude or offensive language
(iii) Avoid typing in ALL CAPITAL letters (it feels like shouting)
(iv) Respect others’ privacy and do not share personal information
(v) Think before sending messages
(vi) Do not spam or send unnecessary messages
Q.14 How is Goal Seek different from Solver in a Spreadsheet?
Ans: Goal Seek changes only one input value to reach a specific result in a formula. It is simple and used when you know the answer you want and need to find the value that gives that answer.
Solver, on the other hand, can change multiple input values at the same time and also works with conditions or limits. It is more advanced or elaborated version of goal seek and is used for solving complex problems like maximizing profit or minimizing cost.
Q.15 Differentiate between a Primary key and Foreign key.
Ans: Primary Key is a field in a table that uniquely identifies each record and cannot have duplicate or empty values.
Foreign Key is a field in a table that refers to the primary key of another table and is used to create a relationship between the tables.
Q.16 What is the importance of healthy lifestyle? Give any four points related to it.
Ans: The importance of a healthy lifestyle is that it helps people stay fit, active, and free from many diseases. It improves both physical and mental well-being and increases energy for daily activities. A healthy lifestyle includes:
(i) Healthy eating habits to provide proper nutrition to the body
(ii) Regular physical activities to keep the body strong and active
(iii) Stress management to maintain mental peace and focus
(iv) Sound sleep to refresh the body and mind
Answer any 3 out of the given 5 questions (4X3=12 marks) Answer each question in 50 – 80 words.
Q.17 What do you understand by the term Table of Contents? List the characteristics of a good ‘Table of content’ in a word processor.
Ans: The table of contents is an organized listing of your document’s chapters, sections and, often, figures, clearly labelled by page number. Readers should be able to look at your table of contents page and understand immediately how your paper is organized, enabling them to skip to any relevant section or sub-section. The table of contents should list all front matter, main content and back matter, including the headings and page numbers of all chapters and the bibliography.
A good table of contents has the following characteristics:
It should be easy to read
It should be simple to use and understand
It should be organized and formatted properly
It must be accurate and easily accessible
It should be given after the title and copyright page
Q.18 Explain the term ‘Scenarios’ in relation to the Spreadsheets with example.
Ans: It is an important tool of MS Excel, that enables you to manage and view data from different input values. For example, if you want to calculate the effect of different interest rates on an investment, you could add a scenario for each interest rate, and quickly view the results.
What-if scenario is a set of values that can be used within the calculations in the spreadsheet to explore and compare various alternatives depending on changing conditions.
Q.19 Explain different kinds of online threats.
Ans: Different kinds of online threats are:
(i) Virus and Malware - These are harmful programs that can damage files, slow down the computer, or steal data.
(ii) Phishing - It is a fake message or email that tricks people into sharing personal information like passwords or bank details.
(iii) Hacking - When someone breaks into a computer system or account without permission to steal or misuse information.
(iv) Cyberbullying - Using the internet to hurt, threaten, or harass someone through messages or social media.
Q.20 Explain the term “Referential Integrity”. Why is it important in a database?
Ans: Referential Integrity means keeping the relationship between tables in a database correct and consistent. It ensures that a foreign key in one table always matches a valid primary key in another table.
It is important because it prevents wrong or missing data in the database. It also helps maintain accuracy, avoids errors, and keeps the data properly connected between related tables.
Q.21 Consider the following Vendor table and write the queries for the following:
Table Datesheet
| Sub_code | Sub_Name | DateofExam | Days |
|---|---|---|---|
| E001 | English | 11-03-2021 | Monday |
| H002 | Hindi | 15-03-2021 | Friday |
| S003 | Social Sci. | 18-03-2021 | Monday |
| S004 | Science | 21-03-2021 | Thursday |
i. Write a SQL command to display the records in ascending order by date of exam.
Ans: Select * from Datesheet order by DateofExam;
ii. Write a query to display the above date sheet.
Ans: Select * from Datesheet;
iii. Write a query to display the subject name and date of the exam held on ‘Monday’
Ans: Select Sub_Name, DateofExam from Datesheet where Days= ‘Monday’;
iv. Write a SQL command to display the date of exam and Sub_Name of Science subject.
Ans: Select Sub_Name, Date of Exam from Datesheet where Sub_Name = ‘Science’;
Download Now - Class 10 IT 402 Sample Question Paper 2023-24 with Solution
