CBSE Sample Paper for Information Technology Class 10 Everything You Need to Know About –

In this article, I will discuss the CBSE Sample Paper for Information Technology Class 10. Everything you need to know about the sample paper of the IT exam will be discussed here. So let’s begin!

CBSE Sample Paper for Information Technology Class 10

As per the assessment pattern of CBSE, Information Technology 402 subject will be assessed as 50 (Theory) + 50 (Practicals). Every year CBSE publishes a sample paper for the same. So here I am going to provide you with a comprehensive guide for the CBSE Sample Paper for Information Technology Class 10.

Here we go!

Let’s discuss the blueprint and paper pattern!

Blueprint CBSE Sample Paper for Information Technology Class 10

This subject is divided into two parts:

1. Part A – Employability Skills: 10 Marks
2. part B – Subject-Specific Skills : 40 Marks

There are five units in Part A – Employability Skills which are as follows:

1. Communication Skills
2. Self-Management skills
3. ICT Skills
4. Entrepreneurial Skills
5. Green Skills

There are four units in Part B – Subject Specific Skills which are as follows:

1. Digital Documentation (Advanced)
2. Electronic Spreadsheet (Advanced)
3. Database Management Systes
4. Web application and Security

Blueprint for Part A Employability Skills

Blueprint for Part B Subject Specific Skills

Let us talk about general instructions for Information Technology (SUBJECT CODE – 402) Sample Question Paper for Class X (Session 2023-2024). Here we go !

General Instructions

1. Please read the instructions carefully.
2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
3. Section A has Objective type questions whereas Section B contains Subjective type questions.
4. 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.
5. All questions of a particular section must be attempted in the correct order.
6. SECTION A – OBJECTIVE TYPE QUESTIONS (24 MARKS):
   i. This section has 05 questions.
   ii. Marks allotted are mentioned against each question/part.
   iii. There is no negative marking.
   iv. Do as per the instructions given.
7. SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS):
   i. This section has 16 questions.
   ii. A candidate has to do 10 questions.
   iii. Do as per the instructions given.
   iv. Marks allotted are mentioned against each question/part.

Let us begin now CBSE Sample Paper for Information Technology Class 10. Here we go!

SECTION A: OBJECTIVE TYPE QUESTIONS

Q. 1 Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)

[1] 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

[2] 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

Ans. b) Ishan: Install reliable antivirus software and update
Reference: Employability Skills Class 10 – Unit 3 : Basic ICT Skills – Page No.: 74

[3] ___________ 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

Ans. b. Stress Management
Reference: Employability Skills Class 10 – Unit 2 : Self Management Skills – Page No.: 41

[4] High expectations from self can leave with chronic anxiety and stress, thus leading to ___________ stress.

• a. Physical
• b. Emotional
• c. Mental
• d. Financial

Ans.: c. Mental
Reference: Employability Skills Class 10 – Unit 2 : Self Management Skills – Page No.: 50

[5] 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

Ans.: d. All of these
Reference: Employability Skills Class 10 – Unit 4 : Entrepreneurial Skills – Page No.: 105 to 108

[6] Name the organization that has the Sustainable Development Goals ?

• a. UNICEF
• b. League of Nations
• c. United Nations
• d. World Health Organization

Ans.: c. United Nations
Reference: Employability Skills Class 10 – Unit 5 : Green Skills – Page No.: 116

Q. 2 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

[1] Which one is not the tab of the insert/index Table window of Writer Document?

• Entries
• b. Background
• c. Style
• d. Row

Ans.:d. Row
Reference: Employability Skills Class 10 – Unit 5 : Green Skills – Page No.: 116

[2] 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

Ans.: a. Black
Reference: Employability Skills Class 10 – Unit 1 – Digital Documentation (Advanced) – The page no given in marking scheme is incorrect.

[3] 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

Ans.: a. Wrap text
Reference: Employability Skills Class 10 – Unit 1 – Digital Documentation (Advanced) – 21

[4] A _____________ is a collection of records that store data in Mail merge.

• a. Data Source
• b. Main Document
• c. Document
• d. Merge Field

Ans.: a. Data Source
Reference: Employability Skills Class 10 – Unit 1 – Digital Documentation (Advanced) – 41

[5] To increases the contrast of an image, ___________ option is used in a document.

• a. Smooth
• b. Sharpen
• c. Aging
• d. mosaic

[6] ___________ 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 (1 x 5 = 5 marks)

[1] ____________ 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

[2] 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

Ans.: b. Link Worksheet
Reference: Employability Skills Class 10 – Unit 2 – Electronic Spreadsheet – 74

[3] ‌‌‌‌‌‌‌‌‌‌______________ can help to clarify the relation between cells while using “Multiple Operations”.

• a. Detective
• b. Solver
• c. Navigation
• d. Hyperlink

Ans.: b. Solver
Reference: Employability Skills Class 10 – Unit 2 – Electronic Spreadsheet – 67,68

[4] 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

Ans.: b. Sheet tab
Reference: Employability Skills Class 10 – Unit 2 – Electronic Spreadsheet – Pg. No.:72

[5] Spreadsheet software can find the changes by ‌‌‌‌‌‌________ sheets.

• a. Changing
• b. Comparing
• c. Renaming
• d. Editing

Ans.: b. Comparing
Reference: Employability Skills Class 10 – Unit 2 – Electronic Spreadsheet – Pg. No.: 94

[6] 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

Ans.: c. Name
Reference: Employability Skills Class 10 – Unit 2 – Electronic Spreadsheet – 74

Q. 4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

[1] It enables users to view, enter, and change data directly in database objects.

• a. Report
• b. Query
• c. Form
• d. Database

Ans.: c. Form
Reference: Employability Skills Class 10 – Unit 3: Database Management System – 148

[2] There are _ types of Relationships in a table of a database.

Ans.:b. 3
Reference: Employability Skills Class 10 – Unit 3: Database Management System – 135

[3] 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

Ans.:c. SQL
Reference: Employability Skills Class 10 – Unit 3: Database Management System – Pg. NO. 114

[4] 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

Ans.: b. varchar
Numeric – Used for numbers
Binary – Used to store large objects
Boolean – Used to store True or False value
Reference: Employability Skills Class 10 – Unit 3: Database Management System – Pg.No: 125

[5] 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

[6] A table can have only _ primary key in a database.

Q. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

[1] ____ key is an accessibility feature that assists people having difficulty in using keyboard and mouse.

• a. Guide
• b. Sticky
• c. Serial
• d. Home

[2] 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

[3] Which of the following is not a web browser?

• a. Safari
• b. Internet Explorer
• c. Google
• d. Firefox

[4] Which out of the following is the best example of a strong password?

• a. 9412356789
• b. 14Hd{]$_Sb10
• c. HarryPotterSeries
• d. 14Oct2004

[5] 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

[6] 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 (2 x 3 = 6 marks)
Answer each question in 20 – 30 words.

Q. 6 What are the learning objectives of communication?

Q. 7 Why do we say that an entrepreneur should be open-minded ?

Ans.: The smartest and most successful people welcome new ideas and diverse perspectives, allowing them to see more opportunities ahead of them and better solutions to problems. Open-minded entrepreneurs are able to strategize better because they can listen to varying and look at a problem through multiple lenses.
Reference: Employability Skills Class 10 – Unit 4 – Entrepeneurial Skills – Pg.No: 43, 44

Q. 8 How is self-regulation connected to the ability to work independently?

Ans.: The smartest and most successful people welcome new ideas and diverse perspectives, allowing them to see more opportunities ahead of them and better solutions to problems. Open-minded entrepreneurs are able to strategize better because they can listen to varying and look at a problem through multiple lenses.
Reference: Employability Skills Class 10 – Unit 1 – Communication Skills – Pg.No: 43

Q. 9 How we can prevent computer against attack by viruses.

Ans.: We can prevent the computer against attack of viruses by installing proper antivirus, enabling the firewall, scan external devices before using on other computer, by avoiding emails that are suspicious or not known to us, should be very careful while downloading files or any programs from the internet etc.
Reference: Employability Skills Class 10 – Unit 1 – Communication Skills – Pg.No: 77

Q. 10 “Green economy promotes sustainable development”. Justify the statement.

Ans.: We can prevent the computer against attack of viruses by installing proper antivirus, enabling the firewall, scan external devices before using on other computer, by avoiding emails that are suspicious or not known to us, should be very careful while downloading files or any programs from the internet etc.
Reference: Employability Skills Class 10 – Unit 1 – Communication Skills – Pg.No: 104

Answer any 4 out of the given 6 questions in 20 – 30 words each (2 x 4 = 8 marks)
Q. 11 What do you understand by Anchoring in Word Processor?

Ans.:Anchoring refers to the reference point for the graphics. This point could be the page, or frame where the object is, paragraph, or even a character. An image always has an anchor point.
(Answer in Libre Office and Open Office both are acceptable.)
Reference: CBSE Study material Subject specific Skills Class 10 – Unit 1 – Diital Documentation- Pg.No:21

Q. 12 What do you mean by Sorting in a Spreadsheet?

Ans.:Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively. For example , you might want to arrange sales data by calendar month so that you can produce a graph of sales performance.
(Answer in Libre Office and Open Office both are acceptable.)
Reference: CBSE Study material Subject specific Skills Class 10 – Unit 3 – Database Management System- Pg.No:104

Q. 13 State any four etiquettes to be followed while chatting on the internet.

Ans.:The etiquettes to be followed while chatting on the internet are :
i. Message should be short and to the point.
ii. Always introduce yourself by name if your screen name doesn’t reflect it.
iii. Always ask if the other person has time to chat first, regardless of how important you think what you have to say is, it’s not going to be well received if the recipient is busy.
Reference: CBSE Study material Subject specific Skills Class 10 – Unit 4 – Web Applications and Security- Pg.No:130

Q. 14 How is Goal Seek different from Solver in a Spreadsheet?

Ans.:Goal seek determines what values needs to be input in a cell to achieve the described result in a formula cell as it allows varying the value for one cell whereas
Solver can solve equations that uses several variables, so it can be used to determine what values need to be entered in multiple-input cells to achieve the described result.
Reference: CBSE Study material Subject specific Skills Class 10 – Unit 2 – Eleceronic Spreadsheet- Pg.No:66

Q. 15 Differentiate between a Primary key and Foreign key.

Ans.:A primary key is a unique value that identifies a row in a table, whereas a foreign key identifies a column or set of columns in one (referencing) table that refers to a column or set of column in another (referenced. table. A table can have only Primary Key but a table can have multiple foreign keys.
Reference: CBSE Study material Subject specific Skills Class 10 – Unit 3 – Database Management System- Pg.No:113

Q. 16 What is the importance of healthy lifestyle? Give any four points related to it.

Ans.:A healthy lifestyle helps to keep and improve people’s health and well-being. A healthy lifestyle includes :
i. Healthy eating habits.
ii. Physical activities.
iii. Stress management
iv. Sound sleep
Reference: CBSE Study material Subject specific Skills Class 10 – Unit 4 – Web applications and security- Pg.No:211

Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 = 12 marks)

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.

Q. 18 Explain the term ‘Scenarios’ in relation to the Spreadsheets with example.

Ans.:Scenarios are a tool to test “What-if” questions. Each scenario is names and can be edited and formatted separately . When you print the spreadsheet, only the content of the currently active scenario is printed. A scenario is essentially a saved set of cell values for your calculations. You can easily switch between these sets using the navigator or a drop-down list which can be shown beside the changing cells. For example , if you wanted to calculate the effect of different interest rates on investment, you could add a scenario for each interest rate and quickly view the results. Formulas that rely on the values changed by your scenario are updated when the scenario is opened. If all your sources of income used scenarios, you could efficiently build a complex model of your possible income.
Reference: CBSE Study material Subject specific Skills Class 10 – Unit 2 – Electronic Spreadsheet – Pg.No:65

Q. 19 Explain different kinds of online threats.

Ans.:There are different kinds of online threads:
i. Phishing: Phishing attacks use fack communication, such as an email, to trick the receiver into opening it and carrying out the instructions inside, such as providing a credit card number.
ii. Malware: Malware is malicious software such as spyware, ransomware, viruses, and worms. Malware is activated when a user clicks on a malicious link or attachment, which leads to installing harmful software.
iii. Password Attacks: With the right password, a cyber attacker has access to a wealth of information. Social engineering is a type of password attack that data insider defines as “a strategy cyber attackers use that relies heavily on human interaction and often involves tricking people into breaking standard security practices.”
iv. Email spoofing: It is the forgery of an email header so that the message appears to have originated from someone or somewhere other than the actual source.
Reference: CBSE Study material Subject specific Skills Class 10 – Unit 4 – Web applications and Security- Pg.No:195

Q. 20 Explain the term “Referential Integrity”. Why is it important in a database?

Q. 21 Consider the following Vendor table and write the queries for the following:

Table: Datesheet

i. Write a SQL command to display the records in ascending order by date of exam.
ii. Write a query to display the above date sheet.
iii. Write a query to display the subject name and date of the exam held on ‘Monday’
iv. Write a SQL command to display the date of exam and Sub_Name of Science
subject.

Ans.:
i. Select*from Datesheet order by DateofExam
ii. Select*from Datesheet
iii. Select Sub_Name, DateofExam from Datesheet where Days= ‘Monday’
iv. Select Sub_Name, Date of Exam from Datesheet where Sub_Name = ‘Science’

For visually impaired candidates.
Write a short note on the following:
i) DBMS
ii) Database Server
iii)Data Integrity
iv)Record

Related