IT 402 Class 10 Sample Paper 2021 with Solution

IT 402 Class 10 Sample Paper 2021 – PAPER – 2 (Click for PAPER-1 )

---

IT 402 class 10 sample paper 2021

CBSE | DEPARTMENT OF SKILL EDUCATION

INFORMATION TECHNOLOGY (SUBJECT CODE-402)

IT 402 class 10 sample paper 2021

Max. Time: 2 Hours                                                                                                                   Max. Marks: 50

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):

• This section has 05 questions.
• Marks allotted are mentioned against each question/part.
• There is no negative marking.
• Do as per the instruction 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

IT 402 class 10 sample paper 2021 – Paper 2 (Click for PAPER-1 )

Q1	Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)
1	Ravi normally shares his thought with Ram in evening through mobile phone. Which form of communication is he using? a) Handwritten Communication b) Body Language Communication c) Verbal Communication d) Non-Verbal Communication	1
	Verbal Communication
2	Stress is the result of: a) Pressure b) Tension c) Problems d)All of the above	1
	All of the above
3	Advantage of short term stress is : a) Improves immunity b) Improves our efficiency to do work c) Encourage people to do work d) All of the above	1
	All of the above
4	Ravi’s customer comes to his store and starts shouting at him. He does not get angry. He listens to what his customer is saying. He is ______________. a) Hardworking b) Confident c) Patient d) Trying New Ideas	1
	Patient
5	___________ is software which can be installed in the computer without the knowledge of computer owner. a) Spyware b) Antivirus c) Adware d) None of the above	1
	Spyware
6	Which of the following is not the Sustainable Development Goal? a) Poverty b) Gender Inequality c) Water Use d) Energy	1
	Gender Inequality

IT 402 class 10 sample paper 2021 (Click for PAPER-1 )

Q2	Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1.	_____________________ is responsible for unwanted advertisements on screen. a) Adware b) Spyware c) Malware d) None of the above	1
	Adware
2.	Spam is unwanted __________ a) Messages b) Mail c) Phone Calls d) None of the above	1
	Mail
3.	Which of the following is a tool for Hacker? a) Keylogger b) Spyware c) Both a and b d) None of the above	1
	Both a and b
4	Any source of potential damage, harm or adverse health effects at workplace is called ____________? a) Accident b) Hazard c) Emergency d) None of the above	1
	Hazard
5	Which of the following is a condition for emergency? a) Earthquake b) Tornadoes c) Leakage of harmful gas in factory d) All of the above	1
	All of the above
6	Protocol is a set of ________________ used for communication.   a) blog b) rules c) system tools d) All of the above	1
	rules

IT 402 class 10 sample paper 2021 (Click for PAPER-1 )

Q3.	Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1.	Information is __________data? a) Raw b) Processed c) Simple d) All of the above	1
	Processed
2.	__________field uniquely identifies record in a table. a) Foreign Key b) Candidate Key c)Primary Key d) Both a and c	1
	Primary Key
3.	How many bytes are consumed by Date data type? a) 1 b) 2 c) 3 d) 4	1
	4
4.	Amit wants to create a new database named “mydb”. Help him to identify the correct Command.   a) Create mydb; b)Create data mydb; c) Create database mydb; d) Create New mydb;	1
	Create database mydb;
5.	Write the output of Select 6 + 8; a) 6 + 8 b) 6 c) 14 d) Error	1
	14
6.	Which command/clause is used to arrange records? a) Update b) Select c) Order by d) Delete	1
	Order by

IT 402 class 10 sample paper 2021

Q4	Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1.	In which of the following ways, image can be inserted in Writer? Drag & Drop From Gallery Using Scanner All of the above	1
	All of the above
2.	Shortcut key to paste text in a document is ____________ a) Ctrl + V b) Ctrl + C c) Ctrl + X d) None of the above	1
	Ctrl + V
3.	Sameer open a new document in Writer and found that his Company’s Logo is automatically coming on left top corner. Which of the following feature can help to do so? a) Styles b) Template c) Both of the above d) None of the above	1
	Templates
4.	By default Writer evaluates _________ levels of headings when we create table of contents. a) 6 b) 8 c) 10 d) 12	1
	10
5.	Smriti is celebrating inauguration ceremony of her new house.  She wants to invite her friends and family members to the party. Which feature will she use to send the same invite to many people with different addresses without typing it again and again? a) Wizard b) Documentation c) Mail Merge d) Letter Merge	1
	Mail Merge
6.	________ refers to the reference point of the graphic. a) Text Wrapping b) Alignment c) Anchoring d) Arrangement	1
	Anchoring

IT 402 class 10 sample paper 2021

Q5	Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1.	Solver option in Spreadsheet is available in _________ menu (in Calc)   a) Insert b) Format c) Tool d) Data	1
	Tool
2	Formula in spreadsheet begin with __________ sign a) = b) == c) >= d) None of the above	1
	=
3.	Suman wants to share her worksheet with others but she wants to protect her worksheet so that no one can make unnecessary changes. Help her to find such option a) Edit –> Check Document b) Edit –> Control Document c) Edit –> Protect Document d) None of the above	1
	Edit –> Protect Document
4.	Parth scored 130 in Term1 and 140 in Term2 (out of 150 ). How much will he score in Term3 so that the aggregate becomes 80%. Which option will help him to find? a) Solver b) Macro c) Scenario d) Goal Seek	1
	Goal Seek
5.	We can consolidate data by ________ a) Row Label b) Column Label c) Both a and b d) None of the above	1
	Both a and b
6.	We can shift from one scenario to another by _____________. a) Navigator b) Find and Replace c) Data Source d) None of the above	1
	Navigator

IT 402 class 10 sample paper 2021

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

Q6.	Write any four 7C’s of Communication.	2
Ans.	Four 7C’s of Communication are : 1. Completeness 2. Conciseness 3. Clarity 4. Courtesy
Q7.	Write four qualities of successful Entrepreneur	2
Ans.	Four qualities of successful Entrepreneur are :   a) They are confident.   b) They keep trying new ideas in their business.   c) They take responsibility for their actions.   d) They do not give up when they face a difficulty.
Q8.	Write the steps to create folder	2
Ans.	Steps to create folder are : 1. Right click on desktop. 2. Select New from short cut menu. 3. Click on Folder.
Q9.	What is Upcycle?	2
Ans.	Upcycle is a new concept wherein old, used material is modified and a new product is created to share with needy/interested people.
Q10.	What do you mean by Time management?	2
Ans.	Time management is the ability to plan and control how you spend your day well and do all that you want to do

IT 402 class 10 sample paper 2021

Answer any 4 out of the given 6 questions in 20 – 30 words each (2 x 4 = 8 marks)

Q11.	What are the rules to be followed while naming Macro?	2
Ans.	Rules for naming Macro are Name of Macro should begin with letter. Name should not contain spaces. Name of Macro should not contain special characters except underscore.
Q12.	Write two ways of creating templates.	2
Ans.	Two ways of creating templates are : Creating a template from a document.   Creating a template using wizard.
Q13.	How can you update table of content, if you delete, add or modify any heading?	2
Ans.	Steps to update table of content are :   1. Place the cursor within the table of contents.   2. Right-click and select Update Index/Table from the pop-up menu.
Q14.	Define the following field properties in reference to Open Office Base. 1. Default Value 2. Format	2
Ans.	1. Default Value: A value which automatically appears when we enter the new record.   2. Format: This property helps to set the format of the data entered in the field.
Q15.	Write four online threats	2
Ans.	Four online threats are :   Phishing Chat Spoofing Email Spoofing Spyware
Q16.	What is Qumana?
Ans.	Qumana is a free blog application that is simple and easy to use. Qumana can be downloaded from www.qumana.com

IT 402 class 10 sample paper 2021

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

Q17.	Explain any four styles supported by OpenOffice.org	4
Ans.	Four Styles supported by OpenOffice.org are.   1. Page styles include margins, headers and footers, borders and backgrounds.   2. Paragraph styles control all aspects of a paragraph’s appearance, such as text alignment, tab stops, line spacing, and borders.   3. Character styles affect selected text within a paragraph, such as the font and size of text, or bold and italic formats.   4. Numbering styles apply similar alignment, numbering or bullet.
Q18.	Differentiate between Relative and absolute hyperlinks.	4
Ans.	Hyperlinks can be used in Calc to jump to a different location from within a spreadsheet. An absolute link will stop working only if the target is moved. A relative link will stop working only if the start and target locations change relative to each other. For instance, if you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will not break.
Q19.	Define the following terms. a. Web Server b. Web Page c. Web Site d. Web Browser	4
Ans.	a. Web Server: Web server is a computer that stores web sites and their related files for viewing on the Internet.   b. Web Page: A single HTML document is called Web Page.   c. Web Site: A collection of Web pages is called Web Site.   d. Web Browser : A Web Browser is a software which is used to view Web site
Q20.	Define the following terms : 1. Data Redundancy 2. Data Integrity 3. Table 4. Primary Key	4
Ans.	1. Duplication of data is called data redundancy. 2. Data Integrity means that data is accurate and consistent in the database. 3. A table is a set of data elements that is organized in rows and columns. 4. A field which uniquely identifies each and every record in a table is called Primary Key

Q21.

Write the queries (i to iv) for the following table “Student”.

4

S_id	S_name	Fee	Class
101	Ashish	3250	10
103	Anuj	3150	12
104	Suman	3350	5

1. Display all the records of table.
2. Display the records of those students whose fees is more than 3000
3. Display Student  id of “Suman”
4. Delete the record whose student id is 103

Ans.

1. Select * from Student;
2. Select * from Student where Fee > 3000;
3. Select S_id from Student where S_name = “Suman”;
4. Delete from Student where S_id = 103;

(Click to view PAPER-1 )

IT 402 class 10 sample paper 2021