Preparing for the board exams becomes much easier when students practice with the CBSE Class 10 IT 402 Sample QP 2022-23 with Solution. This sample question paper designed as per the updated syllabus of Central Board of Secondary Education help students understand the updated exam pattern, marking scheme, and important topics. By solving the Class 10 IT 402 sample paper regularly, students can improve their time management skills and gain confidence before the actual examination.
If you are looking for the latest CBSE Class 10 IT 402 Sample QP 2022-23 with answers, practicing them will surely boost your performance and help you score higher marks in the Information Technology board exam. Regular practice with sample papers is one of the smartest ways to succeed in CBSE exams.
CBSE Class 10 IT 402 Sample QP 2022-23 with Solution
You can download the free PDF of this sample pre-board question paper from our website and start practicing today. Download Link available in last.
The Year-Wise CBSE Class 10 Information Technology (402) Pre-Board and Sample Question Papers with Solutions are provided at the bottom of this post.
CBSE Class 10 IT 402 Sample Question Paper Session (2022-23)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE - 402)
Sample Question Paper (SQP) Solution for Class X (Session 2022-2023)
Max. Time: 2 Hours
Max. Marks: 50
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):
- This section has 05 questions.
- Marks allotted are mentioned against each question/part.
- There is no negative marking.
- Do as per the instructions given.
- SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS):
- This section has 16 questions.
- A candidate has to do 10 questions.
- Do as per the instructions given.
- Marks allotted are mentioned against each question/part
SECTION A: OBJECTIVE TYPE QUESTIONS
Q.1 Answer any 4 out of the given 6 questions on Employability Skills (1X4=4 marks)
i) ____ operating system enables multiple users to work on the same computer at different times or simultaneously.
a) multiprogramming
b) multiprocessors
c) multi-user
d) multi-tasking
ii) ____ is a series of postures and breathing exercises practiced to achieve control of body and mind.
a) Meditation
b) Nature Walk
c) Yoga
d) Physical Exercise
iii) From the following statements, which one is not correct about the Qualities of an entrepreneur.
a) Successful entrepreneurs adapt the habit of hard work from a very early stage.
b) Entrepreneur should not think optimistically about the future of the business.
c) Confident entrepreneur must not deviate from his/her decisions too early in case success is delayed.
d) Entrepreneurs like to function at their own will and rules.
iv) To remove the files of temporary folder, we type ____ in Run dialog box after pressing “Windows button + R” on the keyboard.
a) #temp#
b) %temp%
c) e $temp%
d) &temp&
v. ____ is not the quality of self-confident people.
a) Dependent
b) Hard Working
c) Positive Attitude
d) Commitment
vi) From the following statements, which one is not the positive impact of Entrepreneurship on society:
a) Stimulates Innovation and Efficiency
b) Creates Jobs and Employment Opportunities
c) Solves the problems of the society
d) Discourages welfare of the society
Q.2 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) ____ key is used to reduce repetitive strain.
a) Sticky
b) Serial
c) Mouse
d) Toggle
ii) ____ means that the query uses criteria you provide to hide some data and display only required data.
a) Filtering
b) Sorting
c) Report
d) Forms
iii) Which of the following application is not appropriate to store data about ABC Bank customers?
a) Open Office Base
b) MS Access
c) Open Office Writer
d) MS Excel
iv) When you open a new spreadsheet, by default, it has a sheet named ____ which is managed using tabs at the bottom of the spreadsheet.
a) Sheet1
b) Untitled1
c) Worksheet1
d) New Sheet
v) In a word processor, _ option is selected for a scaled resizing of an image.
a) Original Size
b) Keep ratio
c) Image Size
d) Relative
vi) Multiple copies of the same file leads to ____.
a) Data Inconsistency
b) Data Consistency
c) Data Redundancy
d) Foreign Key
Q.3 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) It is a reference point for the graphics which is created while positioning any image. This point could be the page, or frame where the object is either a paragraph, or even a character in a word processor.
a) Wrap Text
b) Alignment
c) Anchoring
d) Bookmark
ii) Identify the property which help to set the number of characters in text/ varchar type field of a table in DBMS.
a) Entry Required
b) Default Value
c) Size
d) Length
iii) ____ is designed to help users with auditory impairments.
a) Sound Sentry
b) High Contrast
c) Serial key
d) Show Sounds
iv) State whether True or False:
“It is not possible to create a default template in a Word processor”.
a) True
b) False
v) Reviewers and authors can add their ____ to explain their changes in the cell of Spreadsheet.
a) Comments
b) Hyperlink
c) Worksheet
d) Macros
vi) In Calc, Arguments passed to a macro from Calc are always ____.
a) Cell Reference
b) Value
c) Both a and b
d) Sheet Reference
Q.4 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) Identify the website that offers offline blog service for free.
a) Blogdesk
b) Qumana
c) WordPress
d) both a) and b)
ii) John has written a book consisting of fifteen chapters. He wanted to make the index of the book. Suggest him the option used to create the index automatically in a word processor.
a) Tables
b) Mail Merge
c) Columns
d) Table of Content
iii) The length of the field value of text data type is ____ characters by default in DBMS.
a) 10
b) 25
c) 20
d) 50
iv) A healthy lifestyle helps to keep and improve people’s health and well-being. It does not include:
a) healthy eating habits
b) stress management
c) physical activities
d) less sleep
v) In a spreadsheet using to create a hyperlink to a web FTP or Telnet, click on the ____ icon available in Hyperlink dialog box.
a) browser
b) hyperlink
c) Internet
d) mail & news
vi) A ____ refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate.
a) Cell reference
b) Block
c) Sheet Reference
d) Autofill
Q.5 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) Identify the mode, where we can modify in the structure of table?
a) Datasheet view
b) Structure view
c) Design view
d) All of the above
ii) BSNL stands for ____.
a) Bihar Sanchar Nigam Limited
b) Bharat Samachar Nigam Limited
c) Bharat Sanchar Nigam Limited
d) None of the above
iii) ____ function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.
a) Data Combination
b) Data Merging
c) Data Consolidation
d) Data Concatenation
iv) ____ store data in a single table which is suitable to store less amount of Data.
a) Flat File
b) Relational
c) Mini File
d) Single File
v) In a word processor, by default, evaluates ____ levels of headings when it builds the table of contents.
a) 3 (in MS Word)
b) 7
c) 10 (In Libre & Open Office Writer)
d) 12
vi) In ____ Networks, all computers have an equal status and each terminal has an equally competent CPU.
a) MAN
b) WAN
c) Client Server
d) P2P
SECTION B: SUBJECTIVE TYPE QUESTIONS
Answer any 3 out of the given 5 questions on Employability Skills (2X3=6 marks) Answer each question in 20 – 30 words.
Q.6 What are the advantages of the ability to Work Independently?
Ans: (i) Increases Productivity: When a person works independently, they can focus better without unnecessary interruptions, leading to faster and more efficient completion of tasks.
(ii) Builds Confidence and Decision-Making Skills: Working alone helps individuals make their own decisions, which improves confidence and strengthens problem-solving abilities.
Q.7 Name the Stress causal agents.
Ans: Stress causal agents (Stressors):
Physical factors - illness, injury, lack of sleep, fatigue
Work/Study-related factors - deadlines, workload, exams
Q.8 What do you mean by Disk Defragmentation?
Ans: Disk Defragmentation is the process of arranging scattered pieces of files on a disk into one continuous place. When we use a computer, files often get broken into small parts and stored in different locations on the disk. Defragmentation joins these parts together so that each file is stored properly in one place. This helps the computer work faster and allows files to open more quickly.
Q.9 Explain any two Myths about Entrepreneurship.
Ans: (i) Entrepreneurs are born, not made
(ii) Entrepreneurs must have a lot of money to start
(iii) Entrepreneurs take huge risks
(iv) Entrepreneurs work alone
Q.10 Write any four roles of Entrepreneurs.
Ans: (i) Innovator - Introduces new ideas, products, or services.
(ii) Risk Bearer - Takes calculated risks in business.
(iii) Decision Maker - Makes important business decisions.
(iv) Organizer - Arranges resources like money, labor, and materials.
(v) Leader - Guides and motivates the team.
(vi) Manager - Manages day-to-day business activities.
Answer any 4 out of the given 6 questions (2X4=8 marks) Answer each question in 20 – 30 words.
Q.11 State any two purposes of using Templates in a word document.
Ans: (i) Saves Time - Provides a ready-made format so you don’t have to create documents from scratch.
(ii) Maintains Consistency - Ensures the same layout, style, and formatting across multiple documents.
(iii) Gives Professional Look - Pre-designed templates help create neat and well-structured documents.
Q.12 Mention any two operations that can be performed using Macros in a spreadsheet.
Ans: (i) Automating repetitive tasks - such as formatting cells, copying data, or applying formulas.
(ii) Performing calculations - running complex or repeated calculations automatically.
Q.13 What do you mean by Hyperlinks in Spreadsheets? Give the two different types of Hyperlinks that can be used in Spreadsheets.
Ans: Hyperlinks in Spreadsheets are links that allow you to quickly open another file, webpage, or a location within the same or another spreadsheet by clicking on them. They make navigation easy and save time.
Types of Hyperlinks:
(i) Absolute Hyperlink
The Absolute Hyperlink is a hyperlink that contains the full address of the destination file or webpage.
Example: https://www.learncse.in/p/contact-us.html
or D:\Entrance\New Folder\winter.jpg
(ii) Relative Hyperlink
The Relative Hyperlink contains a partial address, which is relative to the address of the destination file.
Example: If you have saved a worksheet/workbook "abc.xlsx" and an image file "winter.jpg" in D: drive, then the relative path will be "\winter.jpg".
Q.14 List Numeric and Alphanumeric Datatypes in OpenOffice Base.
Ans: Numeric Datatypes in OpenOffice Base: Integer, Decimal, Float, Real, Double
Alphanumeric Datatypes in OpenOffice Base: Text (VARCHAR), Memo (LONGVARCHAR), Char (CHAR)
Q.15 Differentiate between Filter keys and Toggle keys in Microsoft Windows.
Ans:
| Filter Keys | Toggle Keys |
|---|---|
| Ignores brief or repeated keystrokes | Gives sound when special keys are pressed |
| Helps users who have difficulty pressing keys accurately | Helps users know when keys like Caps Lock are on/off |
| Controls keyboard sensitivity and prevents accidental key presses | Produces a beep sound when keys are activated |
| Works for all keyboard keys | Works for Caps Lock, Num Lock, Scroll Lock |
Q.16 In which situations Online shopping could be useful? Write any two popular ecommerce websites.
Ans: Situations where Online Shopping is useful:
- When you don’t have time to visit physical stores
- When products are not available locally
- For easy price comparison and better deals
- During emergencies or lockdown situations
Two popular e-commerce websites are: Amazon, Flipkart
Answer any 3 out of the given 5 questions (4X3=12 marks) Answer each question in 50 – 80 words.
Q.17 Anshita is preparing spreadsheet notes for her Term Exam. Help her to write short note on the following:
i. Scenarios: Scenarios are used to create and compare different sets of values in a spreadsheet. They help in analyzing “what-if” situations by saving multiple possibilities and viewing their results.
ii. Goal Seek: Goal Seek is a tool used to find the required input value when the desired output is already known. It automatically changes one value to achieve a specific result.
iii. Solver: Solver is an advanced tool used to find the best possible solution for a problem by changing multiple values based on given conditions or constraints.
iv. Subtotal: Subtotal is used to calculate summary values like sum, average, count, etc., for grouped data in a spreadsheet. It helps in organizing and analyzing large data easily.
Q.18 Tanmay is a Class X student. He has learnt Mail Merge option of a Word Processor in his computer period. But he is confused with few terms used to merge documents.
Explain the following briefly, which will help Tanmay better understand the Mail Merge options.
1. Merge Field - A Merge Field is a placeholder in the main document that is replaced with actual data (like name, address) from the data source during mail merge.
2. Data Source - Data Source is the file that contains the actual information (such as names, addresses, phone numbers) that will be inserted into the main document.
3. Main Document - Main Document is the document that contains the common content (same for all recipients) along with merge fields.
4. Mention two types of data on which mail merge can be applied.
Ans: Letters, Labels
Q.19 Consider the following table: Sales
| Sale_Id | Prod_Name | Price | Discount |
|---|---|---|---|
| 1101 | Laptop | 65000 | 2500 |
| 1103 | Pen tab | 29500 | 1000 |
| 1105 | Desktop | 50000 | 1550 |
| 1106 | Printer | 12000 | 2000 |
1. How many fields and records are there in Sales table?
Ans: Four fields and four records are there in table Sales.
2. Write SQL commands for the following:
Note: Sales price can be calculated as (price-discount)
i. Display Sales ID and price of all products whose discount is more than 1000.
Ans: SELECT Sale_Id, Price FROM Sales WHERE Discount > 1000;
ii. Display the details alphabetically by product name.
Ans: SELECT * FROM Sales ORDER BY Prod_Name;
iii. Display product name and sales price after deducting the discount from the price.
Ans: SELECT Prod_Name, (Price - Discount) AS Sales_Price FROM Sales;
Q.20 Your friend owns a chemist shop, he needs to keep records of the medicines with their id’s, date of purchase, expiry date, price, etc. in a database program. But he does not have any knowledge about the database. Explain to him the following to get a better understanding of the DBMS concepts.
1. What is DBMS? Explain in brief.
Ans: 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.
2. Name any two database programs which can be used to create a table and store the data as per the requirement.
Ans: Two databases are:
(i) Microsoft Access (ii) MySQL (iii) OpenOffice Base
3. Which field can be set as a Primary Key?
Ans: Id field will be suitable for Primary Key.
4. Is it possible to make more than one field as a primary key in your table?
(Yes/No). Justify your answer.
Ans: Yes, we can make more than one column as a primary key in a table and it is known as Composite Primary Key.
Q.21 Vicky is a student of class X. He used to get the work based on internet surfing, But he is not aware of the internet and its terminology. Being a friend of Vicky, help him in finding the answers of the following questions.
a. What do you mean by Internet Service Provider?
Ans: In a peer-to-peer network, all computers are equal and can share resources with each other. In a client-server network, some computers (servers) provide services, while other computers (clients) use those services.
b. Expand the following terms:
i. WAP - Wireless Access Protocol
ii. W3 - World Wide Web (www)
c. Mention any two advantages of Networking.
Ans: Advantages of Networking are:
(i) Data Sharing: One of the most important uses of networking is to allow the sharing of data.
(ii) Files Transfer : Users can send text files, spread sheets, documents, presentations, audio files, video files, etc. to other users.
(iii) Hardware Sharing: Hardware components such as printers, scanners, etc. can also be shared. For example, instead of purchasing 10 printers for each user, one printer can be purchased and shared among multiple users thus saving cost.
d. What is a Blog? Name any two Online Blogs.
Ans: A blog is a discussion-style website where users (technical or non-technical) can create and share content like articles, opinions, or personal experiences. It is similar to an online diary and is easy to use.
It can be created without an internet connection and published later when internet access is available.
Two online blogs: WordPress, Blogger
👉 Microsoft Office vs Apache OpenOffice / Libre Office Features / Steps
In this post, a comparison of step-based questions for MS Office and OpenOffice is provided, including MS Word vs OpenOffice Writer, MS Excel vs OpenOffice Calc, and MS Access vs OpenOffice Base. So, make sure to revise this for OpenOffice preparation.
Download Now - Class 10 IT 402 Sample Question Paper 2022-23 with Solution
