CBSE Sample Papers for Class 10 IT Set 3 with Solutions

Students must start practicing the questions from CBSE Sample Papers for Class 10 IT with Solutions Set 3 are designed as per the revised syllabus.

CBSE Sample Papers for Class 10 IT Set 3 with Solutions

Time Allowed: 2 Hours
Maximum 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.
- Maries 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 (24 marks)

Question 1.
Answer any 4 out of the given 6 questions on Employability Skills. [1]
(A) Yoga is one of the popular stress management techniques because
(a) It keeps mind and body healthy
(b) Improves personality
(c) Make us feel fit
(d) All of the above
Answer:
(d) All of the above

Explanation:
Physical exercise is one of the stress management techniques. It helps in proper blood circulation and relaxes the body. This will help us in becoming more active stress free.

Related Theory:
Some other stress management techniques are: time management mediation, going out for vacations. All these techniques help you in releasing stress.

(B) Kritika has participated in Inter School Debate Competition. The topic of debate will be given 30 minutes before the competition. She is tensed and worried. Which of the following best describes these emotions? [1]
(a) Stress
(b) Harassment
(c) Demotivation
(d) All of above
Answer:
(a) Stress

Explanation:
Stress is a physical, emotional mental and social reaction to any perceived demands or threats. For example, you are about to give viva but feel unprepared.

(C) Surya Pratap works as Office Manager in a leading construction company. He manages all the documentation of the office. He is creating a tender for a contract For writing quotations, he is taking reference from an old file. He wants to copy text from that file. Which of the following shortcut keys should he use? [1]
(a) Ctrl + X
(b) Ctrl + V
(c) Ctrl + C
(d) Ctrl + Y
Answer:
(c) Ctrl + C

Explanation:
Ctrl + C is the shortcut key to copy the selected text.

Related Theory:
Copying text lets you make a duplicate copy of the selected text This copy can be used elsewhere in the same or another document A copy of the text is placed in the Clipboard which can be pasted at a new location using Ctrl + V. The keyboard shortcut key for cut is Ctrl + X and that for paste is Ctrl + V.

(D) Rohit works as an App developer for an IT company but now he wants to work for himself. He has created a team to achieve his goals. Help him by suggesting which of the following initiatives have been taken by the Govt of India to encourage such entrepreneurships? [1]
(a) Jan Dhan Yojna
(b) Make in India
(c) Digital India
(d) Startup Indial
Answer:
(d) Startup India

Explanation:
Startup India is an initiative of Govt, of India to support the startup culture by building a strong and inclusive ecosystem for innovation and entrepreneurship in India.

Related Theory:
Make in India is another initiative of the Indian Government to make and encourage companies to develop, manufacture and assemble products made in India. This campaign is intended to boost the domestic manufacturing industry.

(E) GUI stands for [1]
(a) Graphic User Interface
(b) Graphical User Interface
(c) Graphic User Interaction
(d) Graphical User Interaction
Answer:
(b) Graphical User Interface

Explanation:
Graphical User Interface is a type of user interface through which a user interacts with the computer. It is user friendly interface in which commands can be entered with mouse clicks. Windows is a GUI based operating system.

(F) Which of the following is an idea of self-employment? [1]
(a) Teaching in a school
(b) Owning a shoe business
(c) Cooking in a restaurant
(d) Marketing of a product
Answer:
(b) Owning a shoe business

Explanation:
Teaching, cooking and marketing are all wage types of employment where a person works for someone and gets salary or wages in return.

Related Theory:
A self-employed person is an entrepreneur who runs a business and tries new ideas. A person who becomes an entrepreneur goes through a career process.

Question 2.
Answer any 5 out of the given 6 questions.
(A) ‘App Solutions’, an IT based company, wants to conduct an interview for the position of System Analyst. For this purpose, the company has already received a number of resumes. Now the company wants to send interview letters to all the candidates with different names and addresses. To accomplish the task company should use …………………… feature of Word Processor. [1]
(a) E-mail
(b) Tables
(c) Mail Merge
(d) All of the above
Answer:
(c) Mail Merge

Explanation:
Mail merge is a technique in Word Processor which is used to merge text with addresses to create personalized letters. In mail merge, the main text document contains the main body of the letter, field names and instructions for merging. The Address database stores the information to be merged with the main document. It usually keeps names and addresses of recipients.

(B) ………………….. allows you to test out various scenarios and determine a range of possible outcomes. [1]
(a) Data consolidation
(b) Goal seek
(c) Track Changes
(d) What-lf Analysis
Answer:
(d) What-lf Analysis

Explanation:
What-lf Analysis is the process of changing values in cells to see how those changes will affect the outcome of formulas on the worksheet.

Caution:
A student may get confused with What if Analysis and Goal Seek. A what if analysis is used to check what happens when different values are entered into a situation whereas goal seek allows you to find a specific value that will make a calculation give a particular result.

(C) Sahil is designing a database for storing records of students in a school He has created two tables one for the personal details of students and another to store their fee records. He wants to keep a common field in both the tables to identify the records uniquely. That filed should be declared as [1]
(a) Composite primary
(b) Primary
(c) Alternate
(d) Foreign
Answer:
(b) Primary

Explanation:
A primary key is a field that uniquely identifies the records in a table. E.g. Student ID or Roll Number can be a primary key for records of students. Product ID can be a primary key for a table having records of products etc.

(D) Data consolidation allows you to combine data from …………………. worksheet to single worksheet. [1]
(a) 2
(b) 3
(c) 4
(d) Multiple
Answer:
(d) Multiple

Explanation:
Data consolidation allows the user to collect data from multiple worksheets and store them into a single master worksheet.

(E) Which of the following sign or symbol is used in secured sites? [1]
(a) HTTP
(b) Padlock sign
(c) FTP
(d) Cross sign
Answer:
(b) Padlock sign

Explanation:
The lock symbol and the URL containing “HTTPS” means that the connection between your web browser and the website server is encrypted and cannot be intercepted.

(F) Commands that allow you to make permanent changes in the database are called …………………….. [1]
(a) DDL commands
(b) TCL commands
(c) DML commands
(d) All of these
Answer:
(b) TCL commands

Explanation:
TCL stands for Transactional Control Language. These commands manage transactions within the database. These are used to manage the changes made by DML (Data Manipulation Language) statements.

Question 3.
Answer any 5 out of the given 6 questions.
(A) …………………. is a named collection of various formatting features. [1]
(a) Group
(b) Ribbon
(c) Style
(d) Tab
Answer:
(c) Style

Explanation:
A Style is a feature of Word Processor. It is a named collection of various formatting features that defines the look and behaviour of various components of a document

(B) Collecting and integrating data from multiple resources into a single destination is called ………………….. [1]
(a) Grouping
(b) Sorting
(c) Consolidating
(d) Merging
Answer:
(c) Consolidating

Explanation:
Data consolidation is a process in which similar type of data, existing in multiple sheets of a workbook, is combined together. The consolidated data is stored at a different place.

(C) Kavita has been working on a Project. She is creating a Project report in a word processor. The report consists of various headings and sub headings. The report is quite a large document with more than 100 pages in it. She wants that there should be a way to reach to a particular heading or sub heading directly. Which of the following features of Word processor can be used to accomplish the task? [1]
(a) Table of Contents
(b) Macros
(c) Lists
(d) Styles
Answer:
(a) Table of Contents

Explanation:
The Table of contents is a list or a table listing all chapters or section titles or headings along with their page numbers. It is a hierarchy of headings.

Note: If you want to add an automatic table of contents in your document, then you need to apply heading and sub heading styles to all the titles in your document.

(D) Database servers are referred to as ………………….. [1]
(a) Data-ends
(b) Front-ends
(c) Data-models
(d) Back-ends
Answer:
(d) Back-ends

Explanation:
A back-end is a place to store data that users access through a separate application. It consists of a database stored on a server which provides data on request.

Related Theory:
The user-interface through which a user interacts with an application to store, retrieve and manipulate data is called front-end.
E.g. When a customer browses any product on a website, they are interacting with the front end. But when they put the product into the shopping cart and order it, the information is kept in a database which acts as a back end to that website.

(E) Which of the following software is appropriate to store records of employees? [1]
(a) OpenOffce Calc
(b) OpenOffce Base
(c) OpenOffce Writer
(d) OpenOffice Impress
Answer:
(c) OpenOffice Base

Explanation:
OpenOffice Base is an open source database management system which is used to work on databases. You can add, modify, delete records in it.

(F) Sukanya works in Bangalore and her mother lives all alone in Jaipur. During office hours she talks to her mother via texting using an Instant messenger. Which of the following applications you would not suggest for Instant messaging? [1]
(a) Google hangouts
(b) Facebook
(c) Skype
(d) Telegram
Answer:
(b) Facebook

Explanation:
Instant Messaging is an online communication method used to connect two or more people in real-time for back-and-forth communication.

Facebook is a social media website that allows its users to connect online with their friends, relatives, colleagues etc. who are staying geographically apart. It allows users to share pictures, music, videos and their thoughts with whom they are connected with. But Facebook does not work on real-time technology. Thus it is not an instant messaging app.

Caution:
Facebook Messenger is an instant messaging app that enables chat, voice and video communications.

Question 4.
Answer any 5 out of the given 6 questions.
(A) Technique used to remove an unwanted area from an image is called ……………………… . [1]
(a) Grouping
(b) Ungrouping
(c) Cropping
(d) Deleting
Answer:
(c) Cropping

Explanation:
Cropping an image refers to deleting or removing the part of an image. Cropping is helpful when you are working with a big imacje and you want to focus on some specific part of that image.

(B) The amount of data that a signal can carry is called ……………………………. [1]
(a) WiFi
(b) Bandwidth
(c) Megabits
(d) Gigabits
Answer:
(b) Bandwidth

Explanation:
Bandwidth refers to the amoynt of data that a signal or circuit can carry. It is measured in Mbps (Megabits per second) or Gbps (Gigabits per second).

(C) Satya Tripathi has started a travel agency which offers train and flight bookings along with hotel reservations. He has 4 employees each having a PC to do the task. He wants to create a network which should have a server. Which of the following network should he set up? [1]
(a) Peer-to-Peer
(b) MAN
(c) WAN
(d) Client/Server
Answer:
(a) Peer-to-Peer

Explanation:
In a peer-to-peer network a group of computers are connected to each other with equal permissions and responsibilities for processing data. In this type of network no devices are designated as a client or server.

(D) Kamal has created a worksheet where he has added the details of all products in his grocery shop. He told his accountant to go through the worksheet and make necessary changes if required. In addition he also wants to know the changes done by his accountant. Which of the following features of spreadsheet should he use to see the changes made by his accountant? [1]
(a) Review changes
(b) Macros
(c) Track changes
(d) Find and replace
Answer:
(c) Track changes

Explanation:
When the Track Changes’ feature is enabled, the spreadsheet highlights the changes such as insertions and deletions.

(E) The arrangement of records is called ………………… [1]
(a) Sorting
(b) Indexing
(c) Filtering
(d) Query
Answer:
(a) Sorting

Explanation:
Sorting information in a database refers to the process of arranging data on the basis of one or more than one fields. Sorting can be done in ascending and descending order.

(F) In Excel …………………… can be used to create a hyperlink inside a worksheet. [1]
(a) Insert → Link
(b) File → New → Link
(c) Home → Insert → Link
(d) All of these
Answer:
(a) Insert → Link

Explanation:
In MS Excel you can create hyperlinks in any cell. This hyperlink can be used to go to any specified location with one click.,.To create a hyperlink in Excel follow the given steps:

Click in the cell where you want to create a link.
On the Insert tab, in the Links group, click on Link.
Under Link To, you can specify the desired file, email address or any other location to be linked.

Question 5.
Answer any 5 out of the given 6 questions.
(A) Krishna wants to make a flowchart for his programs in a Word document. Which option should he use to accomplish the task efficiently? [1]
(a) Drawing/Shapes
(b) Symbols
(c) Pictures
(d) All of these
Answer:
(a) Shapes

Explanation:
The Shapes gallery, which can be accessed by clicking on Insert → Shapes, provides a number of different shape categories. These categories include Lines, Rectangles, Basic Shapes, Flowchart, Callouts etc.

(B) Which of the following device is used in network to convert digital signals of computer to analog signals and vice versa? [1]
(a) Router
(b) Modem
(c) Switch
(d) Hub
Answer:
(b) Modem

Explanation:
Modem is a modulation and Demodulation device connected with a computer. It converts incoming analog signals from telephone lines to digital signals of a computer and outgoing digital signals to analog, so that the data could travel via telephone lines over the communication network.

(C) Hardik works as an accountant in a company. He maintains account in a spreadsheet. On everyday basis he has to follow certain actions on the worksheet. Which of the following feature of spreadsheet you would suggest him, through which he can perform these steps quickly and without repeating them? [1]
(a) Macro
(b) Linking
(c) Sharing
(d) Function
Answer:
(a) Macro

Explanation:
Macro is a named and recorded sequence of commands or keystrokes that are saved to be reused anytime. These are helpful in situations where similar sets of actions are to be performed repeatedly on different sets of data.

(D) Which of the following is/are functions) of report? [1]
(a) It summarizes and prints data.
(b) It enables user to enter, view and edit data.
(c) It filters data on basis of criteria
(d) All of these
Answer:
(a) It summarizes and prints data

Explanation:
A Report is a summarized and printed form of data. It lists data in a formal, presentable and formatted form.

(E) Maria International School has created a database of students. The tables Student consists of fields like AdmissionNo, RollNo, Name, Address, PhoneNo. Another table namely Marks consists of academic records of students in the fields RollNo, Marks1, Marks2, Marks3, Marks4, Marks5. To print the report card, data will be taken from both the tables as the records in both the tables are related to RollNo. What type of relationship exist between the tables Student and Marks? [1]
(a) One to One
(b) One to Many
(c) Many to One
(d) Many to Many
Answer:
(a) One to One

Explanation:
In a one-to-one relationship each record in one table is associated with exactly one record in another table.

Related Theory:
A relationship in databases is a link that associates two tables through a common field. Three types of relationships can be formed in databases. These are:

One to one
One to many
Many to one

(F) In today’s World, we cannot think of our lives without the internet for a single day. We provide our sensitive information like personal and financial information to many of the sites. Which of the following measures should be taken to ensure security? [1]
(a) Keep a strong password
(b) Ensure the confidentiality of information
(c) Practice safety measures online
(d) All of these
Answer:
(d) All of these

Explanation: Password provides an entry to an online account so you should keep your password secure. For this you can create a strong password and keep it confidential.

Confidentiality of information refers to the authorization of sensitive and protected data. To ensure confidentiality of data you should keep your computer safe by using firewall and browser settings. Also ensure that you should not share your sensitive information on wireless and public networks.
To keep your system protected use anti-virus and anti-spyware software and download updates regularly.

Section – B (26 Marks)
Answer any 3 out of the given 5 questions on Employability Skills
Answer each question in 20 – 30 words.

Question 6.
Define the term entrepreneurship. [2]
Answer:
Two principles of effective communication are as follows:
(i) Consistency: The communication should always be planned and consistent with a clear objective of the message being conveyed.
(ii) Feedback: The feedback provides confirmation from the recipient whether the message is understood in the same sense as it was delivered or not

Question 7.
Self-Management plays a decisive role in personal and professional life. What do you understand by self-management? [2]
Answer:
Self-management refers to the ability of managing our behaviour, thoughts and emotions in a conscious and productive way. Employees with strong self-management skills can achieve their goals within a time line without going through stress.

Question 8.
How is entrepreneurship important in creating jobs? [2]
Answer:
Entrepreneurs provide a large number of employment opportunities. An entrepreneur, even at the most basic scale, employs people to manage their business activities. They generate direct as well as indirect employment by setting up new units at small and large scale levels.

Question 9.
What are the general things to be taken care of while physical cleaning of the computer? [2]
Answer:
The physical cleaning of computer is very important so as to remove dust from it. Dust makes the computer over heated resulting in damage of its parts. While cleaning a computer following things should be taken care of

Always use a lint-free cotton cloth to clean its components.
Never spray any liquid onto any computer component. You can spray the liquid onto a cloth.
Always use a vacuum cleaner for sucking the dust from the computer parts. The vacuum cleaner that plugs into the wall should not be used.
Never use any harsh object such as wire brush etc. for cleaning. Always use a cleaning brush with soft bristles.
Avoid keeping eatables around the computer.

Question 10.
Goal setting is a very essential factor in your personal life. List all the SMART methods to set the goals. Explain ‘A’ in brief. [2]
Answer:
SMART is an acronym that stands for Specific, Measurable, Achievable, Realistic and Timely. It incorporates all these criteria to help focus your efforts in achieving the goals.

A stands for Achievable which means that goals should be attainable and not impossible to achieve. For achieving the goals, they can be broken into small steps for short term.

Related Theory:
Other terms of SMART are:

Specific – Coats should be specific, clear and unambiguous.
Measurable – Goals should have specific criteria to measure the progress towards their accomplishments.
Realistic – Goals should be realistic within reach and most importantly you should be willing and able to work to achieve them.
Timely – For achieving the goals there should be a clearly defined timeline with both starting and target dates.

Answer any 4 out of the given 6 questions in 20 – 30 words each.

Question 11.
Why Styles are important in Word processors? [2]
Answer:
Style in a word processor provides a consistent appearance to the document. These are helpful in long documents such as thesis, manuscripts, etc. Using Styles you can format your document by quickly applying multiple formatting settings to portions of the document It also helps in building a table of contents.

Question 12.
Differentiate between field and record in a table. [2]
Answer:

Field	Record
A field contains only one type of informations.	A record is a combination of related fields.
It contains information about one aspect of a complete record.	It represents a complete unit of information

Question 13.
What is document hyperlink in a spreadsheet? [2]
Answer:
Document Hyperlink in a spreadsheet is defined as a reference to any location, webpage or a document that we can access by clicking the link. Using these links you can combine text as well as other spreadsheet objects such as charts, sheets, images etc.

Question 14.
How is LAN different from WAN? [2]
Answer:

LAN	WAN
LAN stands for Local Area Network	WAN stands for Wide Area Network Area Network
It is a small computer network confined to a local area such as one office or a building etc.	It is a network of computers that are geographically apart such as cities. countries etc.

Question 15.
Discuss is the purpose of adding comments in a worksheet. [2]
Answer:
The comments in a worksheet are added when you are sharing a worksheet with multiple users. They add an extra information to a figure in a cell use to note trends, or add an action note. These comments only show the suggested changes in a worksheet which the user can accept or reject as required. The comments are temporary and can be edited or deleted from the sheet. These refrain the user from making any kind of permanent changes in sheet.

Question 16.
Define online transaction. What is the other name given to it? [2]
Answer:
Online transaction is a payment method in which money is transferred electronically over the Internet. It is also known as e-payment.

Answer any 3 out of the given 5 questions in 50 – 80 words each.

Question 17.
Rohit works for a Shoe company. He manages their sale and purchase records on a spreadsheet. He wants his team to review the records. As the file was too large he split it into parts and assigned each part of the sheet to his team members. [4]
(A) How can Rohit bring these sheets together?
Answer:
After reviewing, the sheets can be brought together by merging them.

(B) Which command in Calc will he use for that?
Answer:
To merge the sheets, click on Edit → Changes → Merge Document.

(C) How is the feature used by Rohit useful?
Answer:
The merging of sheets is useful in situations when data is split into multiple sheets or multiple reviewers have given edited documents. The data from these sheets are then required to put together into a single worksheet which is accomplished by merging the sheets.

(D) How many worksheets by default are provided in a workbook in Calc? [4]
Answer:
By default, Calc provides three worksheets in a workbook.

Question 18.
Suhana is creating a brochure for a school fair. She added picture in the brochure which contains some unwanted part. [4]
(A) What can be done to remove that part from the picture?
Answer:
She can use Crop feature of word processor to remove that unwanted part from the image.

(B) There are few drawing objects on that brochure on which she wants to perform some common actions. How can she do it easily and quickly?
Answer:
The drawing objects can be combined together by grouping. This feature will treat all the separate objects as one and whatever functions are performed will be applied on all of them.

(C) How can she keep the image between the text?
Answer:
Text Wrap feature can be used to keep the image between the text. The text is placed around the image.

(D) What is anchor point?
Answer:
An anchor is a symbol that appears when image or any other object is inserted in the document. It is a reference point for the vertical and horizontal placement of images.

Question 19.
Following table displays part of the information of items kept in a grocery store.

(A) How many fields and records are there in Items table?
Answer:
There are four fields and four records in the table.

(B) Write SQL commands to:
(i) Display the names of those items whose quantity is less than 30 .
(ii) Update the price of all items in the given table by 5%.
(iii) Add a new item in the table with given details (“1290456”, “Glucose Biscuit”, “15.00”, “40”) [4]
Answer:
SQL Commands:
(i) SELECT ITEMNAME FROM ITEMS WHERE QUANTITY < 30;
(ii) UPDATE ITEMS SET PRICE = PRICE 0.5 + PRICE;
(iii) INSERT INTO ITEMS VALUES (1290456, Glucose Biscuit, 15.00, 40);

Question 20.
‘Bookomenia’ is a public library. The librarian there wants to keep records of books with their Id’s, names, publishing house, price etc. in a database program. Solve the following queries to help them understand the concept of databases. [4]
(A) What are the different methods that are used to create tables in Base.
Answer:
There are three methods to create table in OpenOffice Base These are
(a) Using Table wizard
(b) Using Datasheet view
(c) Using Design view.

(B) Write any one difference between a Table and a Database.
Answer:
Database is a collection of interrelated tables whereas a table is a component of database that consists of all the information and data organized in rows and columns.

(D) Explain primary key. [4]
Answer:
A field which uniquely identifies each record in a table is called a primary key. For e.g. BookJD, Product_No, etc.

Question 21.
Rahul and Amit are working on a school project assigned to them by their teacher. They have to send instant messages to each other and also do video conferencing after school hours in order to complete the project on time. [4]
(A) Discuss any two rules or etiquettes for chatting.
Answer:
While chatting with people using any instant messenger, one should follow some basic rules and etiquettes for chatting. Some of them are as follows:

Start your conversation with small greeting.
Keep your messages short and sweet
Use of Caps Lock should be avoided as it is equivalent to shouting.
Always end your conversation with short closing message e.g. bye, take care etc.
[Note: Write any 2 points]

(B) Suggest any 4 good instant messaging software that they can use.
Answer:
Instant messaging apps that can be used by them are WhatsApp, Facebook Messenger, Google Hangouts, Slack.

(C) Apart from computers, list 4 hardwares that Rahul and Amit need for videoconferencing.
Answer:
Apart from computers they would require a webcam, microphone, speaker and headphone for Video Conferencing.

(D) Which other online service they can use to send messages and files both? [4]
Answer:
Email can be used to send messages and files in form of attachments, over the Internet.