CBSE Sample Paper 2024 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!
Topics Covered
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:
Part A – Employability Skills: 10 Marks
part B – Subject-Specific Skills : 40 Marks
There are five units in Part A – Employability Skills which are as follows:
Communication Skills
Self-Management skills
ICT Skills
Entrepreneurial Skills
Green Skills
There are four units in Part B – Subject Specific Skills which are as follows:
Digital Documentation (Advanced)
Electronic Spreadsheet (Advanced)
Database Management Systes
Web application and Security
Blueprint for Part A Employability Skills
UNIT NO.
NAME OF THE UNIT
OBJECTIVE
SHORT ANSWER
TOTALQUESTIONS
1 MARK EACH
2 MARKS EACH
1
Communication Skills
1
1
2
2
Self-Management Skills
2
1
3
3
ICT Skills
1
1
2
4
Entrepreneurial Skills
1
1
2
5
Green Skills
1
1
2
TOTAL QUESTIONS
6
5
11
NO. OF QUESTIONS TO BE ANSWERED
Any 4
Any 3
07
TOTAL MARKS
1 x 4 = 4
2 x 3 = 6
10 MARKS
Blueprint for Part B Subject Specific Skills
UNIT NO.
NAME OF THE UNIT
OBJECTIVE
SHORT ANSWER
DESCRIPTIVE/ LONG ANS. TYPEQUESTIONS
TOTALQUESTIONS
1 MARK
2 MARKS
4 MARKS EACH
1
Digital Documentation (Advance)
6
1
1
8
2
Electronic Spreadsheet (Advance)
6
2
1
9
3
Database Management System
6
1
2
9
4
Web Applications and Security
6
2
1
9
TOTAL QUESTIONS
24
6
5
35
QUESTIONSTO BE ANSWERED
20
Any 4
Any 3
27
TOTAL MARKS
1 x 20 = 20
2 x 4 = 8
4 x 3 = 12
40 MARKS
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
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): 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.
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 __________________
Ans.: b. Interpersonal Barrier
Barriers to interpersonal communication occur when the sender’s message is received differently from how
it was intended. It is also very difficult to communicate with someone who is not willing to talk or express their feelings and views. Stage fear, lack of will to communicate, personal differences can create interpersonal barriers
to communication.
Culture barrier
Cultural barriers is when people of different cultures are unable to understand each other’s customs, resulting in inconveniences and difficulties.People sometimes make stereotypical assumptions about others based on their cultural background, this leads to difference in opinions and can be a major barrier to effective communication.
Physical Barrier
Physical barrier is the environmental and natural condition that act as a barrier in communication in
sending message from sender to receiver. Not being able to see gestures, posture and general body language
can make communication less effective. For example, text messages are often less effective than face-to-face communication.
Langauge Barrier
The inability to communicate using a language is known as language barrier to communication. Language
barriers are the most common communication barriers, which cause misunderstandings and misinterpretations between people. For example, slang, professional jargon and regional colloquialisms can make communication difficult.
Reference: Employability Skills Class 10 – Unit 1 : Communication Skills – Page No.:22
[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
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?
Smooth – Softens the contrast of an image
Aging – Simulates the effects of time on a picture. Can be applied several times. A further dialog box opens to adjust the aging level.
Mosaic – Joins groups of pixels into a single area of one color.
Reference: Employability Skills Class 10 – Unit 1 – Digital Documentation (Advanced) – 13
[6] ___________ provide Internet access by transmitting digital data over wires of a local telephone network.
ISP – A company that provides an internet
Dial-up connection – Dial-up Internet access is a form of Internet access that uses the facilities of the public switched telephone network (PSTN) to establish a connection to an Internet service provider
Modem – Á modem is a device that converts digital computer signals into a form (analog signals) that can travel over phone lines. It also re-converts the analog signals back into digital signals. The word modem is derived from its function MOdulator/DEModulator.
Reference: Employability Skills Class 10 – Unit 1 – Digital Documentation (Advanced) – 172
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.
Ans.: c. Solver (Refer page 67 as given in regerence book)
Goal seek – using Goal Seek option under Tools menu, you can discover what values will produce the result that you want.
Scenario – Scenarios are a tool to test “what-if” questions. Each scenario is named, and can be edited and formatted separately. When you print the spreadsheet, only the content of the currently active scenario is printed.
Subtotal – SUBTOTAL is a function listed under the Mathematical category when you use the Function Wizard (Insert > Function). Because of its usefulness, the function has a graphical interface.
Reference: Employability Skills Class 10 – Unit 2 – Electronic Spreadsheet (Advanced) – 65,66, 67,63
[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?
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.
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?
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.
Guide – There is no such option in accessibility options.
StickyKeys – an accessibility feature to help computer users with physical disabilities, but it is also used by others as a means to reduce repetitive strain.
Home – There is no such option in accessibility options.
Reference: Employability Skills Class 10 – Unit 4: Web Applications and Security – Pg.No: 168
[2] Anaisha is a wildlife photographer. She wants to createher 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.
Reference: Employability Skills Class 10 – Unit 4: Web Applications and Security – Pg.No: 184
[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?
Ans.: Learning objectives of Effective communication are :
1. Sending, receiving and understanding
the message or information
2. Development of Interposal Skills
3. To express effectively with maximum efficiency
Reference: Employability Skills Class 10 – Unit 1 – Communication Skills – Pg.No: 1,2
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.
Ans.:The table of contents is a snapshot of the headings and page numbers in your document and does not automatically updates itself as you make changes. It acts as a map for the users.
A good table of content has the following characteristics:
1. It should be easy to read and simple to use.
2. It should be organised and formatted properly.
3. It must be accurate and easily accessible.
4. It should be given after the title and copyright page.
(Answer in Libre Office and Open Office both are acceptable.)
Reference: CBSE Study material Subject specific Skills Class 10 – Unit 1 – Digital Documentation- Pg.No:21
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
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?
Ans.: Referential Integrity is used to maintain the accuracy and consistency of data in a relationship. In Base, data can be linked between two or more tables with the help of primary key and foreign key constrains.
Referential Integrity is important in DBMS as:
1. It prevents the entry of duplicate data.
2. It prevents one table from pointing to a nonexistent field in another table.
3. It prevents consistency between “Partnered” tables.
4. It prevents the deletion of a record that contains a value referred to by a foreign key in another table.
5. It prevents the addition of a record to a table that contains a foreign key unless key unless there is primary key in the linked table.
Reference: CBSE Study material Subject specific Skills Class 10 – Unit 3 – Database Management System – Pg.No:135
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. 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
Ans.:
i) A database management system is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications. A database is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. Well known DBMSs include Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, FoxPro, and SQLite.
ii) Database servers are dedicated computers that hold the actual databases and run only the DBMS and related software. Typically databases available on the database servers are accessed through command line or graphic user interface tools referred to as Frontends; database servers are referred to as Back-ends. Such type of data access is referred to as a client-server model.
iii) Data integrity means that the data is accurate and consistent in the database. Data Integrity is very important as there are multiple databases in a DBMS. All of these databases contain data that is visible to multiple users.
iv) A record is a set of information (made up of fields) stored in your database about one of the items.
Reference: CBSE Study material Subject specific Skills Class 10 – Unit 3 – Database Management System – Pg.No:108,109,110
Download Sample Paper
Follow this link to Dowbload Sample Paper for CBSE Sample Paper for Information Technology Class 10.
