CBSE Class 10 IT (402) Sample Paper 2022-23

Class 10 IT (402) Sample Paper 2022-23 has two parts. The first part of Information Technology (subject code 402) will have 10 marks and the section part of the class 10 Information Technology sample paper will carry 40 marks. These parts are:

• PART A – EMPLOYABILITY SKILLS (10 MARKS)
• PART B – SUBJECT-SPECIFIC SKILLS (40 MARKS)

Sample Paper of Information Technology Class 10 – in PDF

The model question paper of IT (code 402) is well structured. Both part A and part B have 4-5 chapters. CBSE has clearly mentioned chapter-wise marks too. So, you will find that the IT 402 sample paper is drafted in a very systematic way. Part A (Employability Skills) has the following chapters.

Employability Skills

• Communication Skills
• Self-Management Skills
• ICT Skills
• Entrepreneurial Skills
• Green Skills

Part B (Subject-Specific Skills) has chapters related to the main course contents. These are:

Subject-Specific Skills

• Digital Documentation (Advanced)
• Electronic Spreadsheet (Advanced)
• Database Management System
• Web Applications and Security

CBSE Class 10 IT (402) Sample Paper 2022-23 – with solution

Download as PDF

CBSE Sample Papers of IT 402 Class 10

CBSE Sample Papers Class 10 IT (Information Technology) subject code 402 are available on myCBSEguide app and our student dashboard with solutions in PDF format for free download. Class 10 IT code 402 new Sample Papers follow the blueprint of the session 2022 – 2023 as per the latest syllabus and marking scheme.

In IT 402, CBSE conducts the theory exam for 50 marks only. The remaining 50 marks are reserved for practical examination. Your school will conduct the practical examination of subject code 402 (Information Technology) as a home examination in your school itself.

CBSE Class 10 IT (402) Sample Paper 2022-23

CBSE Class 10
Information Technology (Code No. 402)
(Sample Paper 2022-23)

---

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):
   1. This section has 05 questions.
   2. Marks allotted are mentioned against each question/part.
   3. There is no negative marking.
   4. Do as per the instructions given.
7. SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS):
   1. This section has 16 questions.
   2. A candidate has to do 10 questions.
   3. Do as per the instructions given.
   4. Marks allotted are mentioned against each question/part.

---

SECTION A: OBJECTIVE TYPE QUESTIONS

1. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)
   1. ________ operating system enables multiple users to work on the same computer at different times or simultaneously.
      1. multi-programming.
      2. multi-processors.
      3. multi-user.
      4. multi-tasking.
   2. ________ is a series of postures and breathing exercises practiced to achieve control of body and mind.
      1. Meditation
      2. Nature Walk
      3. Yoga
      4. Physical Exercise
   3. From the following statements, which one is not correct about the Qualities of an entrepreneur
      1. Successful entrepreneurs adapt the habit of hard work from a very early stage.
      2. Entrepreneur should not think optimistically about the future of the business.
      3. Confident entrepreneur must not deviate from his/her decisions too early in case success is delayed.
      4. Entrepreneurs like to function at their own will and rules.
   4. To remove the files of temporary folder, we type ________ in Run dialog box after pressing “Windows button + R” on the keyboard.
      1. #temp#
      2. %temp%
      3. e$temp%
      4. &temp&
   5. ________ is not the quality of self-confident people.
      1. Dependent
      2. Positive Attitude
      3. Hard Working
      4. Commitment
   6. From the following statements, which one is not the positive impact of Entrepreneurship on society:
      1. Stimulates Innovation and Efficiency
      2. Creates Jobs and Employment Opportunities
      3. Solves the problems of the society
      4. Discourages welfare of the society
2. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
   1. ________ key is used to reduce repetitive strain.
      1. Sticky
      2. Serial
      3. Mouse
      4. Toggle
   2. ________ means that the query uses criteria you provide to hide some data and display only required data.
      1. Filtering
      2. Report
      3. Sorting
      4. Forms
   3. Which of the following application is not appropriate to store data about ABC Bank customers?
      1. Open Office Base
      2. MS Access
      3. Open Office Writer
      4. MS Excel
   4. When you open a new spreadsheet, by default, it has a sheet named ________ which is managed using tabs at the bottom of the spreadsheet.
      1. Sheet1
      2. Worksheet1
      3. Untitled1
      4. New Sheet
   5. In a word processor, ________ option is selected for a scaled resizing of an
      image.
      1. Original Size
      2. Image Size
      3. Keep ratio
      4. Relative
   6. Multiple copies of the same file leads to ________.
      1. Data Inconsistency
      2. Data Consistency
      3. Data Redundancy
      4. Foreign Key
3. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
   1. 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.
      1. Wrap Text
      2. Alignment
      3. Anchoring
      4. BookMark
   2. Identify the property which help to set the number of characters in text/varchar type field of a table in DBMS.
      1. Entry Required
      2. Default Value
      3. Size
      4. Length
   3. ________ is designed to help users with auditory impairments.
      1. Sound Sentry
      2. High Contrast
      3. Serial key
      4. Show Sounds
   4. State whether True or False:
      “It is not possible to create a default template in a Word processor”.
      1. True
      2. False
   5. Reviewers and authors can add their ________ to explain their changes in the cell of Spreadsheet.
      1. Comments
      2. Hyperlink
      3. Worksheet
      4. Macros
   6. In Calc, Arguments passed to a macro from Calc are always ________.
      1. Cell Reference
      2. Value
      3. Both a and b
      4. Sheet Reference
4. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
   1. Identify the website that offers offline blog service for free.
      1. Blogdesk
      2. Qumana
      3. WordPress
      4. both a and b
   2. 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.
      1. Tables
      2. Mail Merge
      3. Columns
      4. Table of Content
   3. The length of the field value of text data type is ________ characters by default in DBMS.
      1. 10
      2. 25
      3. 20
      4. 50
   4. A healthy lifestyle helps to keep and improve people’s health and well-being. It does not include:
      1. healthy eating habits
      2. stress management
      3. physical activities
      4. less sleep
   5. In a spreadsheet using to create a hyperlink to a web FTP or Telnet, click on the ________ icon available in Hyperlink dialog box.
      1. browser
      2. hyperlink
      3. Internet
      4. mail & news
   6. 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.
      1. Cell reference
      2. Sheet Reference
      3. Block
      4. Autofill
5. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
   1. Identify the mode, where we can modify in the structure of table?
      1. Datasheet view
      2. Structure view
      3. Design view
      4. All of the above
   2. BSNL stands for ________.
      1. Bihar Sanchar Nigam Limited
      2. Bharat Samachar Nigam Limited
      3. Bharat Sanchar Nigam Limited
      4. None of these
   3. ________ function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.
      1. Data Combination
      2. Data Merging Data
      3. Data Consolidation
      4. Concatenation
   4. ________ store data in a single table which is suitable to store less amount of Data.
      1. Flat File
      2. Relational
      3. Mini File
      4. Single File
   5. In a word processor, by default, evaluates ________ levels of headings when it builds the table of contents.
      1. 3
      2. 7
      3. 10
      4. 12
   6. In ________ Networks, all computers have an equal status and each terminal has an equally competent CPU.
      1. MAN
      2. WAN
      3. Client Server
      4. P2P

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.

6. What are the advantages of the ability to Work Independently?
7. Name the Stress causal agents.
8. What do you mean by Disk Defragmentation?
9. Explain any two Myths about Entrepreneurship.
10. Write any four roles of Entrepreneurs.

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

11. State any two purposes of using Templates in a word document.
12. Mention any two operations that can be performed using Macros in a spreadsheet.
13. What do you mean by Hyperlinks in Spreadsheets? Give the two different types of Hyperlinks that can be used in Spreadsheets.
14. List Numeric and Alphanumeric Datatypes in OpenOffice Base.
15. Differentiate between Filter keys and Toggle keys in Microsoft Windows.
16. In which situations Online shopping could be useful? Write any two popular ecommerce websites.

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

17. Anshita is preparing spreadsheet notes for her Term Exam. Help her to write short note on the following:
    1. Scenarios
    2. Goal Seek
    3. Solver
    4. Subtotal
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
    2. Data Source
    3. Main Document
    4. Mention two types of data on which mail merge can be applied.
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?
    2. Write SQL commands for the following:
       1. Display Sales ID and price of all products whose discount is more than 1000.
       2. Display the details alphabetically by product name.
       3. Display product name and sales price after deducting the discount from the price.
          Note: Sales price can be calculated as (price-discount)
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.
    2. Name any two database programs which can be used to create a table and store the data as per the requirement.
    3. Which field can be set as a Primary Key?
    4. Is it possible to make more than one field as a primary key in your table?
       (Yes/No). Justify your answer.
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.
    1. What do you mean by Internet Service Provider?
    2. Expand the following terms:
       1. WAP
       2. W3
    3. Mention any two advantages of Networking.
    4. What is a Blog? Name any two Online Blogs.

For Visually Impaired Students

21. Define the following:
    1. Sorting (with respect to DBMS)
    2. Referential Integrity
    3. Many-to-Many Relationship(with respect to DBMS)
    4. Foreign key

These are questions only. To view and download the complete question paper with solutions install the myCBSEguide App from the google play store or log in to our student dashboard.

Download myCBSEguide App

CBSE Sample Papers Class 10

• Mathematics
• Science
• Social Science
• English Language and Literature
• Hindi Course A
• Hindi Course B

To download sample papers for class 10 Science, Mathematics, Social Science, English Communicative, English Language and Literature, Hindi Course A  and Hindi course Bdo check myCBSEguide app or website. myCBSEguide provides sample papers with solutions, test papers for chapter-wise practice, NCERT solutions, NCERT Exemplar solutions, quick revision notes for ready reference, CBSE guess papers and CBSE important question papers. Sample papers all are made available through the best app for CBSE students and the myCBSEguide website.