Preparing for the CBSE board exams becomes much easier when students practice with the CBSE Class 10 IT 402 Sample Question Paper 2019-20 with Solution. This sample paper helps students understand the exam pattern, marking scheme, and important topics asked in the Information Technology (402) subject. By solving previous year sample question papers for Class 10 IT 402, students can improve time management skills and gain confidence before the final exam.
The solutions provided with the CBSE Class 10 IT 402 sample paper 2019-20 help students learn the correct way to answer questions and avoid common mistakes. Regular practice of IT 402 sample question papers with answers allows students to identify weak areas and strengthen their preparation. This makes sample papers an effective study resource for both students and teachers preparing for the CBSE Class 10 Information Technology board examination.
CBSE Class 10 IT 402 Sample QP 2019-20 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.
CBSE Class 10 IT 402 Sample Question Paper Session (2019-20)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE - 402)
Sample Question Paper (SQP) Solution for Class X (Session 2019-2020)
Max. Time: 2 Hours
Max. Marks: 50
General Instructions:
- This Question Paper consists of two parts viz. Part A: Employability Skills and Part B: Subject Skills.
- Part A: Employability Skills (10 Marks)
- Answer any 4 questions out of the given 6 questions of 1 mark each.
- Answer any 3 questions out of the given 5 questions of 2 marks each.
- Part B: Subject Skills (40 Marks):
- Answer any 10 questions out of the given 12 questions of 1 mark each.
- Answer any 4 questions from the given 6 questions of 2 marks each.
- Answer any 4 questions from the given 6 questions of 3 marks each.
- Answer any 2 questions from the given 4 questions of 5 marks each.
- This question paper contains 39 questions out of which 27 questions are to be answered.
- All questions of a particular part/section must be attempted in the correct order.
- The maximum time allowed is 2 hrs.
PART A: EMPLOYABILITY SKILLS (10 MARKS)
Answer any 4 questions out of the given 6 questions of 1 mark each:
1. Use of abbreviations in a communication leads to misinterpretation of messages is an example of ______ barriers.
Ans: Language
2. Vacationing helps in ________ individuals.
Ans: de-stressing
3. ________ serves as an interface between the user and computer.
Ans: Operating System
4. An ________ is a person who establishes a business or a venture that generates some value to the customer and proves to be profitable for him.
Ans: Entrepreneur
5. An economy is called Green economy when it is based on the principles of _______.
Ans: sustainable development
6. Physical exercise in the form of ____________, __________ to relieve stress as they stabilize mood, improve self-esteem and induce sleep.
Ans: walking, skipping
Answer any 3 questions out of the given 5 questions of 2 marks each:
7. Explain any two of 7Cs of Communication.
Ans: (i) Be concise: Make your message brief and to the point. To help make your communications more concise, avoid going over the same point several times, and avoid the use of filler words, sentences, and over wordy expressions.
(ii) Be Complete: Your message must contain all the necessary information to achieve the desired response.
8. How many origins can have stress causal?
Ans: Mental, Physical, Social, Financial.
9. Write down the steps to create a folder in C drive with your name.
Ans: Step 1: Double-click the Computer icon.
Step 2: Double click on C drive in which we have to create a folder.
Step 3: Right-click anywhere in the blank area of the right column. A shortcut menu appears. Select New Folder from the shortcut menu.
Step 4: A new folder is created with name New Folder highlighted and then type a name for the folder. Press Enter key.
10. What are the myths about Entrepreneurship? Explain any two.
Ans: The myths about Entrepreneurship are:
(i) Entrepreneurs are high risk takers. They are neither high nor low risk – takers. They always prefer situations which lead to generating profits.
(ii) Entrepreneurs become rich as they start a new business. Starting a business does not mean that person will become rich overnight. A new business always needs a span of year or two to become successful.
11. List down any four factors causing ecological imbalance.
Ans: (i) Destruction of forests
(ii) Industrialization
(iii) Urbanization
(iv) Large scale use of pesticides
(v) Overgrazing
PART B: SUBJECT SKILLS (40 MARKS)
Answer any 10 questions out of the given 12 questions of 1 mark each:
12. __________ is an accessibility function that tells the keyboard to ignore brief or repeated keystrokes, making typing easier for people with hand tremors.
Ans: FilterKeys
13. Define DSL.
Ans: Digital subscriber line (DSL) provide Internet access by transmitting digital data over wires of a local telephone network.
14. __________ are text or image included at the bottom of the page and may repeat in all pages of the document.
Ans: Footers
15. Symbol option is available under _________________ group in the Insert Tab in word document.
a) Illustrations
b) Symbols
c) Media
d) Text
16. _______ feature is used to extract the data using some conditions on columns.
Ans: Filter
17. A ________ is a graphical representation of data, in which the data is represented by symbols, such as bars.
Ans: Chart
18. A _______________ is the visual motion when one slide changes to the next during a presentation.
a) Slide transition
b) Animation
c) Sound
d) Movie Clip
19. __________ helps to move, rotate or resize multiple objects in a presentation.
a) Grouping
b) Charts
c) Table
d) Movie clip
20. ____________statement is used to retrieve records in a database.
a) Alter
b) Update
c) Select
d) Create
21. A ___________ represents a single, data item in a table.
a) Row
b) Column
c) Datatype
d) Primary Key
22. You can categorize appointments in time management software by giving specific __________ to appointments.
Ans: Colors
23. Define Journal Entry.
Ans: A Journal entry creates a timeline of transactions that can be linked to a contact. A transaction might be an email, task, appointment etc.
Answer any 4 questions out of the given 6 questions of 2 marks each:
24. State the purpose of creating a Blog.
Ans: A blog is a discussion style site used by non-technical (and technical users) users for creating personal web pages. Blog is used to convey messages about events, announcements, news, reviews, etc. Blogs are usually managed using a web browser and this requires active internet connection.
25. Differentiate between Page Break and Section Break options of a word document.
Ans: A page break can be inserted anywhere in a document to force the end of a page and the beginning of a new one.
A section break controls the formatting of the document content that precedes it, until it reaches another section break.
26. Explain Conditional formatting with a help of suitable example.
Ans: Conditional formatting allows to change the formatting (font color, border, shading) of the cells based on the values in it. One or more cells can be selected, and create rules (conditions) for when and how those cells are formatted. The conditions can be, based on the selected cell's contents, or based on the contents of another cell.
For example Highlight the marks of the students who got marks greater than 80 with green colored text.
27. List the activities recorded under Journal entry.
Ans: The following activities can be automatically recorded under Journal entry:
(i) Emails Sent & Received
(ii) Telephone calls
(iii) Meeting requests & responses
(iv) Office documents you manage
28. Differentiate between Flat File and Relational Database.
Ans: Flat File: Data is stored in a single table. Usually suitable for less amount of data.
Relational Database: Data is stored in multiple tables and the tables are linked using a common field. Relational is suitable for medium to large amount of data.
29. Mention two points stating the effective use of animation in a presentation.
Ans: (i) It helps focus audience attention on information.
(ii) It controls the flow of information especially while explaining a diagram.
Answer any 4 questions out of the given 6 questions of 3 marks each:
30. Sanya is working on Word document. She has inserted graphics and wants to use Wrap text with graphics.
(i) Under which tab she can find text wrapping?
Ans: Wrap Text option is available under Text section of the Insert Tab.
(ii) List any two text wrapping options available in a word processing software.
Ans: 1. In Line with text
2. Square
3. Through
4. Top and Bottom
5. Behind Text
6. In Front of text
31. Explain any three character formatting options in a word document.
Ans: (i) Change Case: It helps us to change the text case to capital letters or small letters. You can also capitalize each word in the sentence and capitalize the starting word of the sentence using Change Case under Font Group.
(ii) Font Face: It can be used to give Font Name in the Font group to select the particular font style from the fonts listed.
(iii) Text Highlight Colour: This option can be used to change the background colour.
32. State the purpose of creating Tables in a digital Presentation. Mention two ways to insert a table in a presentation.
Ans: To represent the statistical data meaningfully Tables .It can be used to present text and numerical data. Data is shown in the grid format.
Tables can be inserted in two ways:
(i) Using Insert tab
(ii) Using Title and Content Option
33. Define the following:
Table , Primary Key, Foreign Key
Ans: A table is a collection of related data held in a table format within a database. It consists of columns, and rows.
A primary key is a unique value that identifies a row in a table. For example, Student Table contains columns such as Admno, Name, DOB , Address, Phone and Admno can be considered as Primary Key.
A foreign key is a field or a column that is used to establish a link between two tables. In simple words you can say that, a foreign key in one table used to point primary key in another table.
34. Snehal works for an event management company. She has prepared a presentation and while setting up the Slide Show she is getting the following options, explain them briefly.
(i) Presented by a speaker
Ans: Presented by a speaker (full screen) option can be used if the presentation is to be made to an audience.
(ii) Browsed by an individual
Ans: Browsed by an individual is used when the presentation is to be made to an individual.
(iii) Browsed at a Kiosk
Ans: Browsed at a Kiosk is used when the presentation is to be given at Kiosk computer terminal.
35. What is Data Definition Language (DDL) and Data Manipulation Language (DML)? Give one example of each.
Ans: Data Definition Language (DDL): A data definition language or data description language (DDL) is a standard for commands that define the different structures in a database. DDL statements create, modify, and remove database objects such as tables, indexes, and users.
Example: CREATE, ALTER, and DROP.
Data Manipulation Language (DML): A data manipulation language (DML) is a language that enables users to access and manipulate data in a database. The goal is to provide efficient human interaction with the system.
Example: Insert, Update, Delete and Select
Answer any 2 questions out of the given 4 questions of 5 marks each:
36. Rohan’s Grandfather was wondering that how does Rohan chat on web with his father posted in California, Elaborate the steps involved while transferring data over internet.
Ans: Steps followed while transferring data are:
Step 1: Data is divided into small pieces called packets.
Step 2: A header is added to each packet with sender and receiver details.
Step 3: Packets are sent through different routes to the destination.
Step 4: The destination checks for missing or damaged packets and requests them again if needed.
Step 5: All packets are reassembled into the original data.
37. Elaborate the five types of Views available in a spreadsheet.
Ans: (i) Normal View: The default view of the spreadsheet application is the Normal. It's a collection of cells arranged in the work area.
(ii) Page Layout: It is to quickly fine tune a worksheet that contains many charts or huge amounts of data and achieve professional looking results.
(iii) Page Break Preview: This option is similar to the Page Layout option except you can set the area that is to be set as a page after inserting page break.
(iv) Custom Views: To view selected areas of a document the custom view option can be used.
(v) Full Screen: Selecting this option makes the workbook cover the entire screen. All tabs are hidden from view.
38. Write the points to be kept in mind to make an effective presentation for the audience (Mention any 5 Points).
Ans: 1. Do prior research, know the topic and collect the material of what you will talk about.
2. Highlight key points that are necessary for the audience to remember. Keep the points as short as possible.
3. Avoid too much text Summarize the content as bullet points. Use simple language and limit the number of bullets to three or four per slide.
4. Limit the number of slides - On average, one slide per minute is recommended.
5. Fancy fonts must be avoided.
39. (a) Write a Query to create a Table with the following structure
Table Product
| Field Name | Data Type |
|---|---|
| PID | CHAR(4) |
| Pname | VARCHAR(20) |
| Description | VARCHAR(40) |
| Price | DECIMAL |
Ans: Create table Product (PID Char(4), Pname Varchar(20), Description Varchar(40), Price Decimal);
(b) Consider the following Vendor table and write the queries
Table Vendor
VendorID | VName | DateofRegistration | Location |
|---|---|---|---|
V001 | Mother Dairy | 20-01-2009 | Delhi |
V002 | Havmor | 01-04-2015 | Gujrat |
V003 | Amul | 12-05-2012 | Kolkata |
V004 | Kwality Walls | 15-10-2013 | Mumbai |
(i) Write a Query to display all records
Ans: Select * from Vendor;
(ii) Write a Query to add a new row with the following details
(‘V005’, ‘Vadilal’, ‘2010-03-20’, ‘Pune’)
Ans: Insert into Vendor values ("V005", "Vadilal", "2010-03-20", "Pune");
(iii) Write a query to modify the location of V003 from Kolkata to Gujrat
Ans: Update Vendor Set location= "Gujrat" Where location= "Kolkata";
Download Now - Class 10 IT 402 Sample Question Paper 2025-26 with Solution
