CBSE Sample Papers for Class 10 IT Set 10 with Solutions

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

CBSE Sample Papers for Class 10 IT Set 10 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.
(A) Reaction to stress depends upon the person’s. [1]
(a) Emotions
(b) Confidence
(q) Personality
(d) Health
Answer:
(c) Personality

Explanation:
According to psychologists, different personalities respond to stress differently. An individual with weak physical health will be more vulnerable than with those who possess good physical health. The personality traits like mental health, temperament are also relevant to the experience of stress.

(B) What is ‘R’ in the ‘SMART’ method of goal setting? [1]
(a) Realistic
(b) Relevant
(c) Restrict
(d) Recreate
Answer:
(a) Realistic

Explanation:
‘R’ in SMART means that your goal should be something that you want to achieve and can work towards it. The goal should be appropriate for what you are trying to accomplish. An unrealistic goal is hard to achieve.

Related Theory
SMART is an acronym which stands for Specific, Measurable, Achievable, Realistic and Time- bound.

(C) An antivirus protects your device by: [1]
(a) Protecting it from overheating.
(b) Increasing its performance.
(c) Preventing data from getting corrupt.
(d) Taking backup of data.
Answer:
(c) Preventing data from getting corrupt

Explanation:
An antivirus is an application program that protects our computer from virus attack. A virus is a malicious program that, if entered into the computer, corrupts the data stored in the computer. Thus, antivirus protects the data from getting corrupted and assigning them their roles or duties. It also includes making a check on the plan whether it is being followed or not.

(D) The shortcut key to move a file is: [1]
(a) Ctrl + X
(b) Ctrl + C
(c) Ctrl + M
(d) Ctrl + V
Answer:
(a) Ctrl + X

Explanation:
To move a file from one location to another you first have to cut the file from its location using Ctrl + X shortcut key and then paste it onto another location by using Ctrl + V.

(E) Rashmi has two people who work in her shop. At the end of the day, she enquires about what they have done that day. She: [1]
(a) Creates a new product
(b) Divides income
(c) Manages the business
(d) All of these
Answer:
(c) Manages the business

Explanation: Managing business is one of the functions performed an entrepreneur It includes the arrangement for row material hiring people fór work and assigning them their rotes or duties. It also includes making o check on the plan whether’ it is being followed or not

(F) Arachna has a great idea of building an app. She has one-third of the amount required for it. She is waiting for the rest of the amount and also saving for it, so that she can start her venture. What type of misconception is this? [1]
(a) Every business idea needs to be unique.
(b) A person needs a lot of money to start a business.
(c) Entrepreneurs are born, not made.
(d) Only a person having a big business is an entrepreneur.
Answer:
(b) A person needs a lot of money to start a business

Explanation:
It is a myth that to start a business you should have a lot of money. In fact every business does not need a large capital amount and moreover you can borrow money from your family or bank to start your own business.

Question 2.
Answer any 5 out of the given 6 questions.
(A) Windows OS is based on which user interface? [1]
(a) Graphical
(b) Character
(c) Command
(d) Menu
Answer:
(a) Graphical

Explanation:
Graphical User Interface (GUI) is a type of visual interface which allows the user to use a mouse to point and click objects on the screen. Instead of typing the commands, the user can click on menus and options to give instructions to the computer.

(B) _________ are dedicated computers that hold the databases and run only DBMS or related software. [1]
(a) Main server
(b) Database server
(c) Webserver
(d) Non database server
Answer:
(b) Database server

Explanation:
Database servers are dedicated computers that hold the actual databases and run only the DBMS and related software. It runs on a network database application and maintains database files, such as Microsoft SQL Server or Oracle.

(C) Data can be consolidated from sheets. [1]
(a) 1
(b) 2
(c) 3
(d) More than 3
Answer:
(d) More than 3

Explanation:
A user can use many sheets for consolidation. In Excel upto 255 sheets can be consolidated into a single worksheet.

(D) Which of the following tabs is not present in the Insert Index Table dialog box? [1]
(a) Styles
(b) Columns
(c) Rows
(d) Background
Answer:
(d) Background

Explanation:
The different tabs available in the insert indexes/ table dialog box are: Index/Table: This tab contains options for setting table’s properties.
Entries: This tab allows to set the structure of headings and set styles of headings. Styles: This tab allows us to change the heading styles and formatting.

(E) Which of these is a blogging portal? [1]
(a) Mentimeter
(b) Weebly
(c) Kahoot
(d) Youtube
Answer:
Weebly

Explanation:
Kahoot and Mentimeter are websites organized to make Quizzes. Youtube is a video streaming website.

(F) What do you mean by query with respect to the database system? [1]
(a) Command that is used to interact with a database.
(b) Form which is created but never used.
(c) The structure of DBMS.
(d) All of these
Answer:
(a) Command that is used to interact with a database

Explanation:
A query is a request for data results from your database. A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database.

Question 3.
Answer any 5 out of the given 6 questions.
(A) If you select _________ then any values modified in source range will automatically update the linked data. [1]
(a) Link to source data
(b) Link to target data
(c) Link to sheet data
(d) Link to source range.
Answer:
(a) Link to source data

Explanation:
Linking Data allows you to input data from one worksheet into another worksheet in such a way that target data changes if the original data is changed. This can be used to prevent your worksheet from holding multiple copies of the same data.

(B) Insert menu contains the option of inserting _________ in the word processor. [1]
(a) Images
(b) Table
(c) Word Art
(d) All of these
Answer:
(d) All of these

Explanation:
One can add images, tables and WordArt by clicking on the Insert tab from the menu. All these options are available on the Insert ribbon.

(C) Ramesh wants to calculate category- wise average of the sales of food items in his food court. Which of the following spreadsheet features will help him in this? [1]
(a) Scenario
(b) Sub-total
(c) Goal seek
(d) Average function
Answer:
(b) Subtotal

Explanation:
The SUBTOTAL function in Excel allows users to create groups of the same type of data and then perform various other Excel functions such as SUM, COUNT, AVERAGE etc. on the groups.

(D) A database frontend interface is run by which of the following? [1]
(a) Database server
(b) Database client
(c) DBMS
(d) Web server
Answer:
(b) Database client

Explanation:
A database front end refers to the user interface or application that allows users to access tabular, structured or raw data stored within it. The front end holds the entire application programming utility for data, requests input and sends it to the database back-end. In DBMS, the client manages the user interface and application logic.

(E) Google hangout, Facebook messenger and Whatsapp are _________ types of tools. [1]
(a) Instant messaging
(b) Blogging
(c) Online classes
(d) Email
Answer:
(a) Instant messaging

Explanation:
All the given application allows users to send and receive messages from other users, or which they both are required to be online at the same time.

(F) To set up a field as foreign key while designing a table, what should be done? [1]
(a) Right click on the desired field
(b) Use Format toolbar
(c) Both (a) and (b)
(d) None of these
Answer:
(d) None of these

Explanation:
To make a field a foreign key first open the tables. Now drag a field (primary key) from one table to the common field (foreign key) in the other table.

Question 4.
Answer any 5 out of the given 6 questions.
(A) In the formula, =sales_sheet!A5 * C5, the cell belonging to the current sheet is which of the following?
(a) A5
(b) C5
(c) Both (a) and (b)
(d) None of these
Answer:
(b) C5

Explanation:
In the address =sales_ sheet!A5 * C5, A5 cell is given with its complete path name which shows that it belongs to another sheet i.e. sales_sheet. But cell C5 is given without a path which means that it is from the current location.

(B) Users can add pictures in a document from : [1]
(a) A Stored on disk
(b) From online source
(c) Both (a) and (b)
(d) None of these
Answer:
(c) Both (a) and (b)

Explanation:
In a word processor user can add pictures from file, online source, clipart and direct from the scanner.

(C) _________ allows you to define the fields in the table before adding any data to the datasheet. [1]
(a) Data Sheet View
(b) Design view
(c) Form View
(d) Query View
Answer:
(b) Design view

Explanation:
In design view, you have to specify data types & column names. This is the most common way of creating a table.

(D) To make Online transactions safe we should verify that the website is indicated through a _________ in the web browser. [1]
(a) Golden lock
(b) Antivirus
(c) Password
(d) Bank Details
Answer:
(a) Golden Lock

Explanation:
A golden lock is a closed padlock sign which ensures that the website is safe for online transactions. The URL of the secured site begins with HTTPS.

(E) A _________ is used to apply a group of formatting effects together to the text, paragraph or a heading. [1]
(a) Labels
(b) Mail merge
(c) Style
(d) both b and c
Answer:
(c) Style

Explanation:
A style is a collection of formatting features that can be applied to a document for consistent formatting.

(F) The property allows the user to specify an alternative name for any field. [1]
(a) Default
(b) Alias
(c) Format
(d) Edit
Answer:
(b) Alias

Explanation:
Aliases are used to give a table, or a column in a table, a temporary name. Aliases are often used to make column names more readable. An alias only exists for the duration of a particular query.

Question 5.
Answer any 5 out of the given 6 questions.
(A) Which of the following operations can be performed on a group of cells using subtotal? [1]
(a) Add
(b) Average
(c) Product
(d) All of these
Answer:
(d) All of these

Explanation:
The SUBTOTAL is a feature of spreadsheets that allows users to create groups and then perform functions like SUM, COUNT, AVERAGE, PRODUCT, MAX, etc. Thus, the SUBTOTAL function in Excel helps in analyzing the data provided.

(B) ‘Table of Content’ feature in word processors needs in a document.
(a) Index
(b) Hierarchy of headings
(c) Tables
(d) Heading list
Answer:
(b) Hierarchy of headings

(C) How will you ensure security on internet? [1]
(i) Installing software from any source on internet
(ii) Secure Transactions
(iii) Using Firewalls
(iv) Checking Mails
(a) All of the above
(b) only (ii)
(c) Only (iii)
(d) (ii) and (iii)
Answer:
(d) (ii) and (iii)

Explanation:
Installing software from any source could be hazardous for a computer. It may give a way to malicious software that will damage the system. Checking mails cannot also ensure the security of the system. Rather if a firewall is not used then email can also become a source of virus.

(D) Which feature in a spreadsheet will you use to record a series of commands? [1]
(a) Subtotal
(b) Macros
(c) Goal seek
(d) Scenarios
Answer:
(b) Macros

Explanation:
Macros are the recorded key sequences that simplifies the repetitive tasks in a spreadsheet.

(E) The two areas of the Design view of the Table are Field Information and
(a) Held description
(b) Held properties
(c) Field name
(d) None of these
Answer:
(b) Field properties

Explanation:
The Field properties of a field describes the characteristics and behaviour of data added to that field.

(F) An accessibility feature that helps users who have repetitive strain : [1]
(a) Sticky keys
(b) Filter keys
(c) Toggle keys
(d) Sound Sentry
Answer:
(a) Sticky keys

Explanation:
Sticky Keys enables the user to enter key combinations by pressing keys in sequence rather than simultaneously. This will benefit users who are unable to press or have difficulty pressing shortcut key combinations.

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.
Aditya is waiting for his turn for the placement interview. He is tense and getting nervous. What is he experiencing at this moment? Write a short note on its management. [2]
Answer:
When a person is tense and feeling nervous or worried, he is said to be stressed. Stress is our emotional, mental, physical and social reaction to any perceived demands or threats. Stress Management is a technique to cope effectively with these kinds of stress. To deal with stress you have to follow the procedures of stress management so that it would not put hard pressure on you. Our main goal is to maintain a balance between life, work, relationships, relaxation and fun. By doing this, you are able to manage stress-related problems in your daily life.

Question 7.
An entrepreneur’s success lies in what goal he has set for himself. Elaborate how? [2]
Answer:
Goal setting is a process that helps a person to decide what he wants to achieve in life. This will help them to decide how much and where to put his efforts to achieve that goal. Once the goal has been decided then the only thing left is to go through the process of achieving it. This gives you the motivation to work hard and focus on your goals. An entrepreneur without goals can operate the business but cannot achieve anything.

Question 8.
Write the various steps to maintain a computer. [2]
Answer:
A computer requires regular maintenance. Following are the different steps performed in order to maintain a computer:
(A) Physical cleaning: It consists of the process of cleaning the physical parts of a computer such as monitor, keyboard, mouse, CPU and other parts. This process involves removing dust and debris from these parts.
(B) Internal cleaning: It consists of the process of cleaning the software part of the computer. It involves the deletion of unwanted files, removing VIRUSand other malicious programs from the computer.
(C) Update and backup: In this step the applications stored on the computer are updated and backup of important data is also taken. This improves the efficiency of the computer.

Question 9.
Write any two disadvantages of Entrepreneurship as a career? [2]
Answer:
Following are some of the disadvantages of Entrepreneurship as a career:
(A) No fixed working hours: Most of the people who are successful in their career of entrepreneurship, are working longer and harder than an average employee.
(B) Unstable earning: An average person, in the starting of their career as entrepreneurship, will not be able to make much money. The income will be unstable in view of unexpected profit and losses.
(C) Experiences more stress: An entrepreneur does not have a guaranteed and stable income. Being your own boss makes it difficult to take a right decision in adverse situations. This results in increased stress levels.
Note: write any two points.

Question 10.
Differentiate between Interests and Abilities? [2]
Answer:

Interests	Abilities
1. The things that you  like to perform in free time ore catted interests,	1. It is on acquired or natural ability of doing something.
2. It includes activities that you would Like to do yourself No one will ask you to do it	2. An ability is a skill that enables you to perform tasks up to a Level of proficiency.

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

Question 11.
Define the following terms:
(A) Tuple
(B) Foreign Key [2]
Answer:
(A) Tuple: A tuple in a database is a single row of a table, which contains a single record for that relation. For e.g. in a table Student the complete information about a single student is considered as a tuple.

(B) Foreign Key: A Foreign key is a field (or collection of fields) in one table, that refers to the Primary key in another table. For e.g. in Student table Roll number will be a primary key. The Roll number field in the Marks table is related to the roll number field of the Student table. In this case the Roll number field of the Marks table will be called foreign key.

Question 12.
What are the four types of networks? [2]
Answer:
The four types of networks are as follows:
(A) Local Area Network (LAN): It is a group of computers connected to each other in a small area such as a building, office etc. In this type of network two or more personal computers are connected through a communication medium for resource sharing.
(B) Personal Area Network (PAN): This type of network is arranged within an individual person, typically within a range
of 10 meters. It is used for connecting the computer devices of personal use. It can be wired or wireless.
(C) Metropolitan Area Network (MAN): This type of network covers a larger geographic area mostly a city. The purpose of MAN is to share resources among users.
(D) Wide Area Network (WAN): It is a network that extends over a large geographical area such as states or countries. It can even be a group of LANs spread across distant places and connected together by a one big network.

Question 13.
Define blogging. What are the two methods of writing a blog? [2]
Answer:
A blog is a publishing site used for creating and publishing personal web pages. Blogs are similar to an online personal diary and simple to use. A blog is a medium to convey messages about events, announcements, news, reviews, etc. There are two methods of creating blogs:
(A) Online blogs – These are usually managed using a web browser. For this an active internet connection is required.
(B) Offline blogs – These blogs are written using offline blog software. In such software content is first created and later published using an active internet connection. It requires internet connection only while posting the blog. Creation of a blog can be done offline.

Question 14.
What are the features of word processors? [2]
Answer:
Word processor is a software that is used to create, edit, and print documents. It has following features:
(A) It allows user to type, edit, cut, copy, insert, delete text.
(B) Images can also be added to the text using a word processor.
(C) Using the Style feature one can create documents with consistent formatting. It gives a professional and uniform look to the documents
(D) The mail merge feature of word processors lets you create personalized letters with very less effort.
(E) It has in-built preformatted templates that makes it easy to create a document.

Question 15.
Explain the use of multiple operations? How is it different from creating scenarios? [2]
Answer:
A multiple operation combines a series of formulas with a variable and a series of values. The results of each formula with each value are shown in the table. A scenario presents the alternate versions of values in the same cell whereas the Multiple Operation tool does not present the alternate versions in the same cells. Once the alternative values are created, you use the Multiple Operations tool to specify which formulas you are using, as well as the original values used by the formulas.

Question 16.
What-if analysis is found useful in following situations:
(A) To predict the EMI values for loan amount for different time periods.
(B) To estimate the profit value based on production costs and labour charges etc.
Answer:
What-if analysis is found useful in following situations:
(A) To predict the EMI values for loan amount for different time periods.
(B) To estimate the profit value based on production costs and labour charges etc.

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

Question 17.
Ritwik is a student of class 10. His teacher gave him an assignment He completed all his work except a few questions. Help him in writing the answers for these questions:
(A) Define data consolidation
(B) What are the various tools of What if Analysis?
(C) Explain Goal seek.
(D) Where can you find the tools of What if Analysis in Calc? [4]
Answer:
(A) Data consolidation is the process of collecting and integrating data from multiple worksheets into a single worksheet. unctions like Sum, Average, Count, Max, Min etc. are applied while integrating the data.
(B) A spreadsheet provides following tools for What if Analysis
Scenario Goal seek Solver
(C) Goal seek is a type of What-if analysis tool that calculates backward to obtain an input. The required output is given and it finds out the input value for it.
(D) The tools of What If analysis in Calc are available i ‘Tools’ menu.

Question 18.
Rashi is a president of student’s union in her college. She has to send personalized letters to some renowned citizens of the city as guests in her college function.
(A) How can she create such Letters?
(B) What other things can she do, using the same feature?
(C) What is required to use this feature?
(D) Name the application in which this feature is available. [4]
Answer:
(A) Personalized letters can be created using the Mail merge feature of the word processor. In this feature the letter is stored in one document and name and addresses in another document. Both the documents are then merged to generate a common text with different names and addresses.
(B) Using mail merge she can also create mailing labels, envelopes and bulk email and fax distributions.
(C) The requirement to perform mail merge are the main document containing letter and the data source from where the names and addresses of recipients are fetched.
(D) Mail merge is available in the word processors such as MS-Word, Writer etc.

Question 19.
Consider the following table named ‘Furniture’ showing a part of details about various furniture items in a showroom.

(A) Write the structure of the given table.
(B) Write SQL queries to:
(i) Display the price of the Dining Table.
(ii) Replace the name of F1203 from “Dining Table” to “Dining Chairs”
(iii) Display the details of all furniture in increasing order of price. [4]
Answer:
(A) The structure of the given table is as follows:

FID	CHAR(5)
Name	VARCHAR (20)
Price	Integer
Weight	Integer

(B) (a) SELECT Price FROM Furniture WHERE Name = “Dining Table”
(b) UPDATE Furniture SET Name = “Dining Chairs” WHERE FID = “F1203”
(c) SELECT * FROM Furniture ORDER BY Price

Question 20.
Shobhit is learning DBMS. Help him to complete his assignment by writing short notes on the following. [4]
(A) Basic features of Base
(B) Data inconsistency
(C) Data redundancy
(D) Group field
Answer:
(A) Basic features of Base are:
(i) Data can be divided into separate storage containers called tables.
(ii) Data can be viewed, edited and updated using forms.
(iii) Data can be searched and retrieved using queries.
(iv) It can be printed using reports.
(B) Data inconsistency is a situation where there are multiple tables within a database that deal with the mismatching copies of same data.
(C) Data redundancy occurs when the same piece of data is stored in two or more separate places and is a common occurrence in many tables.
(D) Sometimes a table has similar values in a field for various records. These multiple records having same values can be arranged in a group to organize them. Such fields when used for grouping are called group fields.

Question 21.
Pavitra and Kusum are two friends who want to share the pictures with messages of assignments assigned by their coaching teacher. They also want to interact by video conferencing. [4]
(A) Suggest any four good messaging apps that can help them.
(B) Suggest any two video conferencing apps.
(C) List the requirements for video conferencing.
(D) (i) Avoid using abbreviations unless very necessary.
(ii) Avoid the use of Caps Lock while typing a message.
(iii) End the message with proper closing such as Thank you, Take Cdre etc.
Answer:
(A) Messaging apps that can be used to send messages and pictures are: Google hangout, Yahoo! Messenger, Skype , Windows Live Messenger , RediffBol, etc.
(B) The video conferencing apps are Skype, Zoom, Google Meet etc.
(C) For video conferencing they would require a computer/ laptop, headphone, microphone, webcam, video conferencing application and internet connection.
(D) (i) Avoid using abbreviations unless very necessary.
(ii) Avoid the use of Caps Lock while typing a message.
(iii) End the message with proper closing such as Thank you, Take Care etc.