In this article, I will discuss Answer key IT 402 Class 10 Board Paper 2023. IT 402 or Information Technology 402 Class 10 examination was held on 13.03.2023. So here we go!
This answer key is prepared after discussion with subject experts and according to their suggestions, answers are given.
This is not a final or official marking scheme or answer key by CBSE. Students’ answers will be evaluated by the CBSE board’s official answer key. All answers are suggested answers. So let us begin.
Topics Covered
Answer key IT 402 Class 10 Board Paper 2023
Let us begin to Answer key IT 402 Class 10 Board Paper 2023. Many questions have been asked as similar as I have uploaded my Sample Papers and Mock Test. Here we go!
SECTION A: OBJECTIVE-TYPE QUESTIONS – Mock Test Information Technology Class 10
Q. 1 Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)
[1] _____________ refers to focusing human efforts for maintaining a healthy body and mind., capable of withstanding stressful situations.
a) Artificial Intelligence
b) Stress Management
c) Motivation
d) Emotional Intelligence
Ans. : b) Stress Management
Answer Reference: CBSE X_EMPLoyability_SKills_Combined_Book Page No. 17
[2] Which of the following is not the benefit of stress management?
a) Boosts Immunity
b) Reduces Efficiency
c) Improves Mood
d) Prevent Behavioral Problems
Ans.: b) Reduces Efficiency
Answer Reference: CBSE X_EMPLoyability_SKills_Combined_Book Page No. 18
[3] ____________ are computer programs that can damage the data and software programs or steal the information stored on a computer.
a) Spam
b) Viruses
c) Junk Mail
d) BIOS
Ans.: b) Viruses
Answer Reference: EMPLoyability_SKills_10 Page No. 90
[4] _____________ is a horizontal bar present at bottom of the Windows desktop.
a) Status Bar
b) Menu Bar
c) Task Bar
d) Recycle Bin
Ans.: c) Task Bar
Answer Reference: CBSE X_EMPLoyability_SKills_Combined_Book Page No. 23
[5] State whether the following statement is a myth or reality:
Entrepreneurs are born a certain way.
Ans.: Myth
Answer Reference: CBSE X_EMPLoyability_SKills_Combined_Book Page No. 55
[6] Which of the following is not true for entrepreneurs?
a) They create needs and demands
b) They provide raw materials
c) They do not create jobs
d) They help society by supporting infrastructure development
Ans.: c) They do not create jobs
Answer Reference: CBSE X_EMPLoyability_SKills_Combined_Book Page No. 46
Q. 2 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
[1] _______________ controls all aspects of a paragraph’s appearance, such as text alignment, tab stops, line spacing, and borders, and can include character formatting.
a) Page Style
b) Character Style
c) Cell Style
d) Paragraph Style
Ans.: d) Paragraph Style
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 3
[2] How many levels of headings does LibreOffice Writer evaluate to build the Table of contents?
a) 8
b) 9
c) 10
d) 12
Ans.: c) 10
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 31
[3] Reema has created a pamphlet on ‘Tour to West India’. She has inserted mani images to make it more presentable but the size of the images is occupying a lot of space. Her friend has suggested her to reduce the size of the images. Which of the following options will help her in doing the task without losing any content of the images?
a) Recolor
b) Docking
c) Resize
d) Rotate
Ans.: c) Resize
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 15
[4] Which of the graphic filter is used to increase the contrast of an image in a document?
a) Smooth
b) Sharpen
c) Remove Noise
d) Invert
Ans.: b) Sharpen
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 13
[5] Which of the following is not used when creating a mail-merge document?
a) Spreadsheet
b) Document
c) Paint
d) Database
Ans.: c) Paint
[6] Which mode is used to apply a style to many different areas of a document quickly without going back and formatting window in a writer?
Ans.: Using Fill Format
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 5
Q. 3 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
[1] A colored border, with _________, appears around a cell where changes are made in a shared worksheet.
a) a dot in the upper left-hand corner
b) a dot in the lower left-hand corner
c) a cross in the upper left-hand corner
d) a cross in the upper right-hand corner
Ans.: a) a dot in the upper left-hand corner
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 94
[2] ____________ feature adds data arranged in a group of cells in Calc with labels for columns and/or rows.
a) Average
b) Subtotal
c) Goal Seek
d) Solver
Ans.: b) Subtotal
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 64
[3] A _________ refers to a cell or range of cells on a worksheet whose data values can be used in a formula.
a) sheet
b) cell
c) cell reference
d) cell data
Ans.: c) cell reference
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 75
[4] ______________ feature of Calc is used to test ‘what-if’ questions.
a) Solver
b) Goal Seek
c) Scenario
d) Styles
Ans.: c) Scenario
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 65
[5] Macros are especially useful to ___________ the same way over and over again.
a) repeat a task
b) reject a task
c) report a task
d) comment a task
Ans.: a) repeat a task
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 95
[6] ____________ feature of Calc helps to track what data was changed, when the change was made, who made the change and in which cell the change occured.
a) Record Changes
b) Edit Record
c) Change Record
d) Macro
Ans.: a) Record Changes
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 88
Q. 4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
[1] Which of the following is not an example of DBMS?
a) PostgreSQL
b) SQLite
c) FoxPro
d) Imperss
Ans.: d) Impress
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 108
[2] A ___________ is an interface in a user-specified layout that lets users to view, enter, and changes data directly in database objects such as tables.
a) frame
b) form
c) relation
d) report
Ans.: b) form
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 148
[3] Which of the following is expanded form of SQL?
a) Systematic Query Language
b) Structured Query Language
c) Software Query Language
d) Structural Query Language
Ans.: b) Structured Query Language
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 115
[4] ___________ is usually suitable for less amount of data. (Relational/Flat File)
Ans.: Flat File
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 108
[5] Binary data types in a database can be using for storing _________________
a) photos, music files, etc.
b) integer values,
c) only images files
d) only video files
Ans.: d) photos, music files, etc.
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 127
[6] ____________ clause can be used with the SELECT statement in SQL to specify which rows to retrieve from the table.
a) WHERE
b) GROUP
c) SAME
d) SIMILAR
Ans.: a) WHERE
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 146
Q. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
[1] ________ is an accessibility function which is designed for people who have vision impairment or cognitive disabilities.
a) Filter Keys
b) Sound Key
c) Toggle Keys
d) Sticky Keys
Ans.: c) Toggle Keys
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 164
[2] Networks in which certain computers have special dedicated tasks providing services to other computers (in the network) are called ___________
a) hierarchical
b) dedicated server
c) peer to peer
d) client server
Ans.:d) client-server
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 169
[3] ______________ provides Internet access by transmitting digital data over wires of a local telephone network.
a) HSPDA
b) P2P
c) DSL
d) Modem
Ans.: c) DSL
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 172
[4] A __________ is an unplanned event that may happen all of a sudden and may lead to unwanted or unprecedented results/outcomes.
a) emergency
b) hazard
c) accident
d) illness
Ans.: c) accident
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 206
[5] A _____________ worker will always perform to the post to his ability.
a) fast working
b) highly educated
c) happy and healthy
d) stressed
Ans.: c) happy and healthy
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 211
[6] _________________ is the process of emptying a place in case of an emregency.
a) Emergency
b) Accident
c) Drill
d) Evacuation
Ans.: d) Evacuation
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 210
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 is self-awareness? Also give any two benefits of self-awareness.
Ans.:
Having conscious knowledge of your own self, capabilities, feelings and one’s own character is called as self-awareness.
Benefits:
1. It helps individuals to chart their ways for working independently.
2. They become aware of their strengths and weak points and work accordingly.
3. They try to focus on strengths to become successful in various arenas of life.
Answer Reference: CBSE X_EMPLoyability_SKills_Combined_Book Page No. 20
Q – 7 Give one example of each of the following stress causal agents for students:
a) Mental
b) Social
Ans.:
a) Mental – Students can be left overwhelmed, if they are unable to handle their assignment submission deadlines and examinations grades. High expectations from self can leave one with chronic anxiety and stress.
b) Social – Discord amongst family members, peer pressure for doing things which children would generally avoid , maintaining balance in relationships amongst friends, status show off may lead to stress at times.
Answer Reference: CBSE X_EMPLoyability_SKills_Combined_Book Page No. 17
Q – 8 Differentiate between files and folders.
| Factor | File | Folder |
|---|---|---|
| Extension | Files may or may not have extensions. | Folders do not have extensions. |
| Container | A file cannot contain another file/folder. | A folder can contain any number of file/folders. |
| Memory size | A file has certain size and memory consumption. | A folder has no size of its own. It derives the size from the files it contains. |
| Attributes | Name, Extension, Date, Time, Length and Protection (Read-Only, hidden etc.) | Name, Date, Time and Protection (Read-Only, hidden etc.) |
| Supported operations | Open, save, rename, print, email and modify file content. | Move, rename, delete and share. |
| Sharing | Files cannot be shared on network on their own. | Folders can be shared on network. |
Click here for Reference Website
Q – 9 Given any two qualities of an entrepreneur.
Ans.:
Hard work: Without working hard, no entrepreneur can be successful. On an average, successful entrepreneurs are found to be working anywhere between 60 to 90 hours per week, which is much higher than 40 hours per week. Entrepreneurs use a lot of trial and error and keep putting in work till they succeed.
Optimism: Positivity and belief in what they do is what takes entrepreneurs far in their journey. Entrepreneurs should get think negatively or be afraid of adverse situations. For an entrepreneur, part of being optimistic is about learning from mistakes and failures and finding alternative ways to do things.
Answer Reference: CBSE X_EMPLoyability_SKills_Combined_Book Page No. 48
Q – 10 Give any two promotional functions of an entrepreneur.
Ans.:
Idea Discovery: The first step towards entrepreneurship is discovery of a business idea. An entrepreneur comes up with a business idea and thinks about ways to implement it. It is about seeking opportunities for a specific type of business and finding ways to commercialize on it. Usually, entrepreneurs work around the process of idea discovery by exploiting natural resources, finding a market need or calculating the profit potential.
Detailed Investigation: While coming up with ideas can seem like an easy process, the challenge is to understand if the idea has the potential to turn into a viable business venture. For this, an entrepreneur conducts research, investigates and evaluates an idea considering various factors and estimates the total demand for a new product or service.
Answer Reference: CBSE X_EMPLoyability_SKills_Combined_Book Page No. 49
Answer any 4 out of the given 6 questions in 20 – 30 words each (2 x 4 = 8 marks)
Q – 11 Difference between keep scale and keep image size options while cropping an image in a document.
Ans.:
When Keep scale is selected (default), cropping the image does not change the scale of the picture.
When Keep image size is selected, cropping produces enlargement (for positive cropping values), shrinking (for negative cropping values), or distortion of the image so that the image size remains constant.
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 15
Q -12 Give any two characteristics of a template in LibreOffice Writer.
Ans.: Templates can contain anything that regular documents can contain, such as text, graphics, a set of styles, and user-specific setup information such as measurement units, language, the default printer, and toolbar and menu customization.
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 23
Q – 13 Why do we need to merge worksheets?
Ans.: Sometimes, multiple reviewers return edited versions of a worksheet at the same time. In this case, it may be quicker to review all of these changes at once, rather than one review at a time. For this purpose, Calc provides the feature of merging worksheets.
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 93
Q – 14 What is primary key? How is it different from foreign key?
Ans.: A primary key is a unique value that identifies a row in a table. The foreign key identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table.
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 113
Q – 15 Expand and Explain the term WAN.
Ans.:
WAN stands for Wide Area Network that covers a broad area (i.e., any network that links across metropolitan, regional, or national boundaries). The Internet is the most popular WAN, and is used by businesses, governments, non-profit organizations, individual consumers, artists, entertainers, and many others.
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 170
Q – 16 a) Identify the following network/internet connectivities as wired or wireless:
i) Dial-Up
ii) WiMAX
b) Give any one feature of Instant messaging.
Ans.:
a)
i) Dial Up – Wired
ii) WiMAX – Wireless
Most instant messaging software include the option for performing file transfers, audio chat, video calling and conferencing, sharing desktops, etc. apart from standard text chat
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 172,173,176
Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 = 12 marks)
Q – 17 Expand the following terms with resepct to positioning the graphics in a document:
a) Arrangement
b) Text Wrapping
Ans.:
a) Arrangement refers to the placement of a graphic on an imaginary vertical axis. Arrangement controls how graphics are stacked upon each other or relative to the text.
b) Textwrapping refer to to the relation of graphics to the surrounding text, which may wrap around the graphic on one or both sides, be overprinted behind or in front of the graphic, or treat the graphic as a separate paragraph or character.
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 21
Q – 18 Distinguish between the following with respect to spreadsheets:
a) Relative and Absolute Hyperlinks
b) Internet hyperlinks and document hyperlinks
Ans.:
a) Relative and Absolute Hyperlinks: 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.
b) Internet and Document Hyperlinks: The hyperlink points to a web address, normally starting with http:// or https:// is known as internet hyperlink whereas the hyperlink points to a place in either the current worksheet or another existing worksheet document hyperlink.
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 80
Q – 19 Explain any four data types of DBMS.
Ans.:
Numeric Data Type: Numeric Types:
Numeric data types are used for describing numeric values for the field used in the table of a database. Numeric data types in a database can be used for storing information such as mobile number, roll number, door number, year of school admission, true or false statements, statistical values, etc.
Alphanumeric Types: Various data types are char, varchar, long varchar etc. They are used to store the text.
Binary Types:
Binary data types are used for storing data in binary formats. Binary data types in a database can be using for storing photos, music files, etc.
DATE TIME:
Date time data types are used for describing date and time values for the field used in the table of a database. Date time data types in a database can be used for storing information such as date of birth, date of admission, date of product sale, etc.
Answer Rerefence: 402-IT_ClassX.pdf Page No.: 126 to 128
Q – 20 a) Structure of a table ‘Orders’ is given below. Suggest suitable data type of each column:
b) Consider the following table “Books”:
Write SQL queries to
i) Display Data of all books whose quantity is more than 3.
ii) Display total amount of all books whose price is less than 500.
(Hint: amount=Qty*Price)
Ans.:
a) Order_ID – Char
BkName – Varchar
Customer_ID – Char
Amount – Float
b)
i) select * from books where qty>3
ii) select qty*price “Total Amount” from books price < 500
Q – 21 a) Give two best practices for internet safety.
b) Give any two Falls and Slips Safety rules.
Ans.:
a) User strog passwords
b) Change the password frequently
c) Do not share personal information on unsecured sites
d) Clear coockies frequently
b)
– Keep the moving area clean and clutter free.
– Workplace must be proper ventilated receive light.
– Wear non slippery footwear.
– Floors must be clean and dry
– Oil spills, dust must be immediately cleaned.
i)
Watch this video:
Download the Question Paper PDF from here: