Preparing for the CBSE board exams becomes much easier when students practice with CBSE Class 10 IT 402 previous year question papers with solutions. The CBSE Class 10 IT 402 Question Paper 2022-23 with Solution helps students understand the latest exam pattern, important topics, and marking scheme followed by the board. By solving past papers regularly, students can identify frequently asked questions and improve their time management skills. These question papers also boost confidence by giving real exam experience at home.
Another major advantage of practicing CBSE Class 10 IT 402 solved question papers PDF 2022-23 is that students can evaluate their performance using step-by-step answers. It makes concept clarification easier and helps in reducing mistakes. Previous year papers are especially useful for revision before exams as they cover the complete syllabus in an exam-oriented manner. If you want to score high marks in the CBSE IT 402 board exam, practicing Class 10 Information Technology previous year question papers with answers is one of the most effective study methods.
CBSE Class 10 IT 402 Question Paper 2022-23 with Solution
Series YZXW
Question Paper Code 89 Set 4
INFORMATION TECHNOLOGY (402) - PYQP 2023
(Session 2022-23)
Time allowed : 2 hours
Maximum Marks : 50
General Instructions :
- Read the following 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 alloted (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 5 questions.
- Marks alloted are mentioned against each question/part.
- There is no negative marking.
- Do as per instructions given.
- Section – B : Subjective Type Questions (26 Marks)
- This section has 16 questions.
- A candidate has to do 10 questions.
- Do as per instructions given.
- Marks alloted are mentioned against each question/part.
SECTION A (Objective Type Questions)
1. Answer any 4 questions out of the given 6 questions on Employability Skills : (1X4=4)
(i) _____________ 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
(ii) Which of the following is not the benefit of stress management?
a) Boosts Immunity
b) Reduces Efficiency
c) Improves Mood
d) Prevent Behavioral Problems
(iii) _____ 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
(iv) ____ is a horizontal bar present at bottom of the Windows desktop.
a) Status Bar
b) Menu Bar
c) Task Bar
d) Recycle Bin
(v) State whether the following statement is a myth or reality: "Entrepreneurs are born a certain way."
Ans: Myth
(vi) 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
2. Answer any 5 out of the given 6 questions (1X5=5)
(i) ____ 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
(ii) How many levels of headings does Open Office Writer evaluate to build the Table of contents?
a) 8
b) 9
c) 10
d) 12
(iii) 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
(iv) 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
(v) Which of the following is not used when creating a mail-merge document?
a) Spreadsheet
b) Document
c) Paint
d) Database
(vi) 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 / Fill format mode
3. Answer any 5 out of the given 6 questions (1X5=5)
(i) 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
(ii) ____ 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
(iii) 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 / cell address
d) cell data
(iv) ____ feature of Calc is used to test ‘what-if’ questions.
a) Solver
b) Goal Seek
c) Scenario
d) Styles
(v) 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
(vi) ____ 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
4. Answer any 5 out of the given 6 questions (1X5=5)
(i) Which of the following is not an example of DBMS?
a) PostgreSQL
b) SQLite
c) FoxPro
d) Imperss
(ii) 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
(iii) 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
(iv) ____ is usually suitable for less amount of data. (Relational/Flat File)
Ans: Flat File
(v) 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
(vi) ____ 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
5. Answer any 5 out of the given 6 questions (1X5=5)
(i) ____ 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
(ii) 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
(iii) ____ provides Internet access by transmitting digital data over wires of a local telephone network.
a) HSPDA
b) P2P
c) DSL (Digital Subscriber Line)
d) Modem
(iv) 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
(v) A ____ worker will always perform to the post to his ability.
a) fast working
b) highly educated
c) happy and healthy
d) stressed
(vi) _____ is the process of emptying a place in case of an emregency.
a) Emergency
b) Accident
c) Drill
d) Evacuation
SECTION B (Subjective Type Questions)
Answer any 3 out of the given 5 questions on Employability Skills in 20 – 30 words. (2X3=6)
6. What is self-awareness? Also give any two benefits of self-awareness.
Ans: Self-awareness means knowing yourself well. It is about understanding your strengths and weaknesses, your likes and dislikes, and how you think and feel. When you are aware of your emotions, abilities, and behavior, it helps you make better decisions and improve yourself.
Benefits of self-awareness:
(i) It helps us in converting our weakness into strength.
(ii) It helps us in converting our strength into an exceptional talent.
7. Give one example of each of the following stress causal agents for students:
a) Mental
Ans: Unable to handle their assignment, submission deadlines and examination grades
b) Social
Ans: Maintaining balance in relationships among friends/family
8. Differentiate between files and folders.
Ans: File - (i) Files take space in computer memory.
(ii) A file cannot contain another file/folder.
Folder - (i) Folders do not take space in computer memory.
(ii) A folder can contain any number of files/folders.
9. Given any two qualities of an entrepreneur.
Ans: (i) They believe in themselves and their abilities.
Ans: (i) They believe in themselves and their abilities.
(ii) They keep trying new ideas in their business.
(iii) They have leadership qualities.
(iv) They are creative and think differently about business ideas.
10. Give any two promotional functions of an entrepreneur.
Ans: (i) Idea Discovery/Idea generation/ Ideation
(ii) Determining the business objective
(iii) Detailed Investigation
(iv) Assembling the Requirements/procurement of Machines and Materials/ Resource acquisition
(v) Preparation of Business Plan
(vi) Financing
Answer any 4 out of the given 6 questions in 20 – 30 words each (2X4=8)
11. Difference between keep scale and keep image size options while cropping an image in a document.
Ans: Keep Scale - (i) When Keep scale is selected, cropping the image does not change the scale of the picture.
(ii) When Keep scale is selected, size of the image changes.
Keep image - (i) When Keep image size is selected, cropping produces enlargement, shrinking, or distortion of the image so that the image size remains constant.
(ii) When Keep image is selected, size of the image does not change.
12. Give any two characteristics of a template in Open Office Writer.
Ans: (i) A template is a pre-defined format/model that is used to create other documents.
(ii) Templates simplify the creation of documents.
13. Why do we need to merge worksheets?
Ans: Sometimes, it is faster to review many changes together instead of one by one. When multiple users make changes in different copies of the same worksheet, all those changes need to be combined into one sheet. Also, to bring data from different worksheets into a single worksheet, we use the merge worksheet feature in Calc.
14. What is primary key? How is it different from foreign key?
Ans: A primary key is a unique value that identifies a row/record in a table. Primary Key cannot contain duplicate values and it cannot be NULL.
Primary key is different from foreign key as:
Primary key focusses on uniqueness of values while foreign key is used for creating relationships between tables.
15. Expand and Explain the term WAN.
Ans: Wide Area Network
A network which connects computers and devices over a broad /large geographical area. eg. Internet.
16 a) Identify the following network/internet connectivity as wired or wireless:
i) Dial-Up - Wired
ii) WiMAX - Wireless
b) Give any one feature of Instant messaging.
Ans: Text Messages can be sent to one or more person instantly.
Answer any 3 out of the given 5 questions in 50– 80 words each (4X3=12)
17. Expand the following terms with respect to positioning the graphics in a document:
a) Arrangement
Ans: Arranging an image means to determine its position relative to other images, objects or text. Send to back, send backward, bring to front, bring forward are the various options available under this.
Ans: Arranging an image means to determine its position relative to other images, objects or text. Send to back, send backward, bring to front, bring forward are the various options available under this.
b) Text Wrapping
Ans: Text wrapping causes all the text to wrap around the image so that the image does not interfere with line spacing. Various text wrapping options are: before, after, parallel, through and optimal.
18. Distinguish between the following with respect to spreadsheets:
a) Relative and Absolute Hyperlinks
Ans:
| Relative Hyperlink | Absolute Hyperlink |
|---|---|
|
1. Works unless start and target locations change. 2. Contains address relative to destination file. 3. Files should be in the same folder. |
1. Stops working only if target is moved. 2. Contains full address of destination file or website. 3. Files can be stored anywhere in the system. |
b) Internet hyperlinks and document hyperlinks
Ans:
| Internet Hyperlink | Document Hyperlink |
|---|---|
|
1. Points to a web address starting with http:// or https:// 2. Connects to another webpage or website when clicked. 3. Requires internet connection. |
1. Points to a location within the same document or another document. 2. Takes us to another place in worksheet or file when clicked. 3. Does not require internet. |
19. Explain any four data types of DBMS.
Ans: In DBMS, data types define what kind of data can be stored in a database.
(i) Integer – It is used to store whole numbers like 10, 25, or 100.
(ii) Float/Decimal – It is used to store numbers with decimal points like 12.5 or 3.14.
(iii) Character/String – It is used to store text such as names, addresses, or words.
(iv) Date/Time – It is used to store dates and time like 2026-01-28 or 10:30 AM.
20. a) Structure of a table ‘Orders’ is given below. Suggest suitable data type of each column
Table: Orders
| Order_ID | Order_date | Customer_ID | Amount |
|---|---|---|---|
| A_101 | 12/12/19 | C3445 | 1200.00 |
| A_202 | 11/09/19 | C1245 | 3456.00 |
| A_402 | 09/07/19 | C2121 | 2312.00 |
(b) Consider the following table "Books".
| BkID | BkName | Author | Qty | Price |
|---|---|---|---|---|
| B_101 | Learning with Fun | Jacobins | 5 | 355.00 |
| B_103 | How I Live Now | Meg Rosoff | 4 | 400.00 |
| B_104 | I Capture the Castle | Dodie Smith | 5 | 520.00 |
| B_106 | Mortal Engines | Philip Reeve | 4 | 260.00 |
| B_110 | The Kite Rider | Geraldine McCaughrean | 3 | 270.00 |
Write SQL queries to
i) Display Data of all books whose quantity is more than 3.
Ans: SELECT * FROM Books WHERE Qty > 3 ;
ii) Display total amount of all books whose price is less than 500.
(Hint: amount=Qty*Price)
Ans: SELECT Qty * Price FROM Books WHERE Price < 500 ;
OR
SELECT Qty * Price AS Amount FROM Books WHERE Price < 500 ;
21. a) Give two best practices for internet safety.
Ans: Best practices for Internet safety are:
Ans: Best practices for Internet safety are:
(i) Use strong passwords and keep them private to protect your accounts.
(ii) Install updated antivirus software and avoid clicking on unknown links or downloading from unknown sources.
b) Give any two Falls and Slips Safety rules.
Ans: To prevent Falls and Slips the following safety rules can be followed:
(i) The area where people movement is very high should be cleaned and clutter-free.
(ii) The workplace should be properly ventilated and have good light area.