CBSE Sample Papers for Class 10 IT Set 2 with Solutions

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

CBSE Sample Papers for Class 10 IT Set 2 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) Which of the following is not a managerial function in Entrepreneurship? [1]
(a) Planning
(b) Financing
(c) Motivating
(d) Staffing
Answer:
(b) Financing

Explanation:
Financing is a promotional function in entrepreneurship. The managerial function includes – Planning, Organizing, Staffing, Supervising, Motivation, Co-ordination, Controlling, Negotiation etc.

(B) …………………….. operating system is used to control machinery, scientific instruments etc. [1]
(a) Real Time
(b) Distributed
(c) Single User
(d) Multi User
Answer:
(a) Real time

Explanation:
A real time operating system is a computing environment in which the computer manages the resources in a way that any particular operation is executed in the same amount of time, every time it is executed.

(C) Kartik is a Front Office Manager in a Hotel. He is also preparing for Banking exams. He gives 3 to 4 hours to his studies. Today he has been studying for more than an hour but he realizes that he is hungry and his phone is also buzzing with some message notifications. All this is distracting him from his studies. What do you suggest him to do now? [1]
(a) Take a small nap
(b) Go to kitchen and prepare something for him
(c) Take a quick break to get a snack and check the messages before going back to studying
(d) Both (a) and (b)
Answer:
(c) Take a quick break to get a snack and check the messages before going back to studying

Explanation:
To manage your time effectively some tips are as follows:

Stick to schedule.
Do one thing at a time.
Plan for unexpected.
Do not multitask

In the given case hunger and notifications are two unexpected hindrances in his studies. And if he checks phone while studying then also it will create distraction. So it would be better to stick to one task at a time and then focus on what he has planned.

Related Theory:
For effective time management one should follow the four steps given below:

Plan out your time in advance.
Prioritize your tasks as per urgency and importance.
Monitor how the tasks are carried out . as per the planning.
Track the time spent on tasks.

(D) In SMART goal setting method M stands for …………………….. [1]
(a) Must
(b) Measurable
(c) Monitoring
(d) Mindful
Answer:
(b) Measurable

Explanation: The term Measurable refers that goals should have specific criteria to measure the progress towards their accomplishments.

Related Theory:
SMART is an acronym that stands for Specif c. Measurable, Achievable, Realistic and Timely. It consists of all these criteria to help focus your efforts in achieving the goals.

(E) State whether true or false:
“Entrepreneurs who do not have an innovative idea cannot succeed”. [1]
(a) True
(b) False
Answer:
(a) True

Explanation:
An entrepreneur is also an innovator or creator. An entrepreneur without an innovative idea finds difficult to succeed. For a successful entrepreneurship a good idea with strong planning is required.

(F) To select the text, one has to press and hold the mouse button and move the cursor. Which of the given terms is most appropriate for this process? [1]
(a) Highlighting
(b) Selecting
(c) Moving
(d) Dragging
Answer:
(d) Dragging

Explanation:
Dragging refers to moving the mouse pointer while holding its button. Dragging helps in selecting and moving text. You can drag and drop the objects, files etc. to move them from one location to another.

Question 2.
Answer any 5 out of the given 6 questions.
(A) …………………….. is used to format a single character, or an entire word or a phrase. [1]
(a) Paragraph styles
(b) Page styles
(c) Character styles
(d) Frame styles
Answer:
(c) Character styles

Explanation:
Style is a collection of various formatting features that defines the appearance and behaviour of document components on which style is applied. Character styles are used to format a single character, or an entire word or a phrase.

Related Theory:
Paragraph style is used to format a paragraph, Frame style is used to format text and graphic frames. Page style organise structure of the document and List style is used to format the numbered and bulleted lists.

(B) Scenario in Calc is used to solve …………………….. type of questions. [1]
(a) Numeric
(b) Calculation
(c) Text
(d) What If
Answer:
(d) What If

Explanation:
A spreadsheet like Calc, MS Excel etc. can be used for What If analysis. In Calc, there are three types of What If analysis tool – Goal Seek, Scenario and Solver.

(C) When multiple users can view, edit and review the changes in a spreadsheet, it is called …………………….. . [1]
(a) Linking
(b) Sharing
(c) Reviewing
(d) Merging
Answer:
(b) Sharing

Explanation:
When a file is shared on a network, all users have access to that file. Any changes made to that file can be tracked and you can also authorise the access of file to Limited users on network.

Related Theory:
Multiple users working on same sheet are said to collaborate.

Caution:
Linking and Sharing sounds similar but linking is different from sharing. Linking is done when a user is working on multiple sheets and needs to use data kept in another sheet For this purpose, a link is created within a sheet or outside a sheet as required.

(D) Database server act as …………………….. software. [1]
(a) Front End
(b) Back End
(c) End
(d) Container
Answer:
(b) Back End

Explanation:
A back end is the server side of the database. It stores, manages and arranges data and also ensures that when required, plata is available at the client side of the database.

Related Theory:
The client side is the user side of the system.

(E) Which of the following is used for online shopping? [1]
(a) eBay
(b) Amazon
(c) Flipkart
(d) All of these
Answer:
(d) All of these

Explanation:
Online shopping is the term given to shopping over internet. Alt the sites given here are used for the same.

(F) …………………….. SQL command is used to delete a particular column in a table. [1]
(a) ALTER
(b) UPDATE
(c) DROP
(d) DELETE
Answer:
(a) ALTER

Explanation:
The syntax to drop a column in a table is:
ALTER TABLE table.name DROP COLUMN column_name
e.g. ALTER TABLE student DROP COLUMN Address
The above command will delete Address column from the table Student.

Related Theory:
DROP TABLE command is used to delete a table from the database.
E.g. DROP TABLE student

Question 3.
Answer any 5 out of the given 6 questions.
(A) Sahil is a general merchant and keeps all daily1 needed items in his shop, but to keep track manually on the inventory is a very time-consuming job for him. Therefore, he decided to maintain all the records on the computer. This type of record keeping system is called …………………….. . [1]
(a) Data Base Management System
(b) Computerised Record Update System
(c) Computerised Data Base System
(d) None of these
Answer:
(a) Data Base Management System

Explanation:
Database refers to the collection of interrelated data and Database Management System is a computer program that manages a database effectively and eflfciently.

Related Theory:
Relational Database is a collection of related multiple linked tables and the software handling relational database is called Relational Database Management System.

(B) Supriya is a book writer and she has completed writing her new book in Word. She wants to create a table of contents. The command sequence for this is …………………….. . [1]
(a) Insert → Table
(b) Insert → Table of contents
(c) References → Table of contents
(d) All of these
Answer:
(c) References → Table of contents

Explanation:
Table of Contents is a list of all the chapters or the section titles or headings along with their page numbers given in the beginning of the book. To create Table of Contents in MS Word you have to first create a hierarchy of headings.

Explanation:
Blog is a kind of website which is also termed as weblog. It is an online diary or journal wherd entries are posted in reverse chronological order.

Related Theory:
A person who writes blogs is called a blogger and the art of writing a blog is called blogging.

(D) The amount of data that a signal carries is called …………………….. [1]
(a) Bandwidth
(b) Frequency
(c) Gigabits
(d) Megabits
Answer:
(a) Bandwidth

Explanation:
Bandwidth the a maximum amount of data transmitted over an Internet connection in a given amount of time. It is measured in bits per second.

Caution:
Bandwidth is often mistaken by Internet speed. Bandwidth is how much data you receive every second while speed is how fast that information is received.

(E) Ashi is creating a poster for her father’s shop. She wants to add the name of the shop in the background of the poster in lighter shade to make the text and images in the foreground easily ,, readable. Which of the following is the right way to perform this task? [1]
(a) Insert the name of the shop in the background
(b) Insert the name of the shop in text box and set the transparency mode as required
(c) Insert the name of the shop as watermark.
(d) None of these
Answer:
(c) Insert the name of the shop as watermark

Explanation:
When an image is inserted as a watermark the image will be totally transparent and it becomes the background of the page and the other text and images are easily visible on it.

Related Theory:
Transparency is a property of image that allows the image to be transparent between 0 and 100%.

(F) Which of the following in not a type of What-lf Analysis? [1]
(a) Goal seek
(b) Scenario
(c) Consolidate
(d) Solver
Answer:
(c) Consolidate

Explanation:
Data consolidation is a process of collecting and integrating data from multiple sources into a single destination or workbook.

Question 4.
Answer any 5 out of the given 6 questions.
(A) Textual representations of an TV program is called …………………….. . [1]
(a) Narrator
(b) Closed captions
(c) Magnifier
(d) Ease of access
Answer:
(d) Closed captions

Explanation:
The closed caption is a feature that displays the spoken dialogue in a show. It also displays non-verbal information such as music and other types of sound effects. This feature is helpful for people with hearing impairments.

Related Theory:
Narrator is a screen reading app, helpful for the people with vision impairments.

(B) …………………….. is used to create forms in a Database. [1]
(a) Tables
(b) Tables and Queries
(c) Queries and Reports
(d) Reports
Answer:
(b) Tables and Queries

Explanation:
Forms are the objects in database that provides user interface to. collect data from the user in an interactive manner. The Forms are directly connected to a data source such as table or query and can be used to enter, edit and display data from the data source.

(C) Which of the following is not appropriate to set as primary key? [1]
(a) Employee’s Identification Number
(b) Price of book
(c) Product code
(d) Admission number of student
Answer:
(b) False

Explanation:
A field is a column that holds only specific information about complete record. A record is complete row and is a collection of group of fields.

(D) By default, the sheets tabs can be seen at the …………………….. of the Excel screen. [1]
(a) Top
(b) Left
(c) Right
(d) Bottom
Answer:
(d) Bottom

Explanation:
The sheets tab is at the bottom of the screen with ‘Sheet 1’ as default worksheet. You can add as many sheets as you can by clicking on + symbol given next to the sheet tab.

Related Theory:
The sheet can also be renamed. To rename a sheet take the pointer to the Sheet tab and right click on the name of the sheet which you want to rename. Now click on ‘Rename’ option from the resulting popup menu and give a new name to the sheet.

(E) …………………….. is a model that you use to create other documents. [1]
(a) Style
(b) Template
(c) Design
(d) Blueprint
Answer:
(b) Template

Explanation:
A template is a pre-formatted sample document that is used to create documents quickly. It is a blueprint that offers pre-defined formatting features like styles, headers, footers etc. based on which user can create an actual document All the features defined in the document are automatically applied on the actual document based on it.

(F) Aman is working on a table which was created by some other employee working earlier. He wants to see the structure of the table in the database. Which of the following commands would help him to do this? [1]
(a) SHOW database
(b) DESC tablename
(c) SHOW tables
(d) All of these
Answer:
(b) DESC tablename

Explanation:
The SQL commands to display the structure of a database table are DESC or DESCRIBE

Syntax:
DESC <table name>
Or
DESCRIBE ctable name>
E.g. DESC student will display the structure of the Student table.

Question 5.
Answer any 5 out of the given 6 questions.
(A) Which of the following toolbar offers the tools to draw shapes in MS Word? [1]
(a) Home
(b) 3D settings
(c) Drawing
(d) Standard
Answer:
(c) Drawing

Explanation:
The drawing toolbar in MS Word is a collection of many tools to draw and colour shapes, add text effects, create text boxes, and add graphics with colours within a document.

(B) Which of the following fields of Student database can act as primary key? [1]
(a) Admission_no
(b) Stu_name
(c) Phone_no
(d) Father_name
Answer:
(a) Admissiom_no

Explanation:
A primary key is a type of field which is unique for all the records in a table. A primary key field is also used to related data from one table to another.

(C) Sahil has a little knowledge of MS Access. He wants to create the table by typing the field names, their data types and some other settings. Which of the following methods you would suggest for him to create the table from scratch? [1]
(a) Create table using Table Wizard
(b) Create Table using Design view
(c) Create Table using Data Sheet view
(d) All of these
Answer:
(b) Create Table using Design view

Explanation:
The Design View displays the structure of a table by showing the details like Field name, Field type, Description etc. It also shows the settings for each field.
The user can create the structure of table by providing all the details of various fields of the table.

Related Theory:
You can also create tables using Table Wizard. It is a fast way to create tables. The wizard allows you to create a table automatically by asking you a series of questions about the types of fields you want to include in your table.

(D) Grouping the functions is also called …………………….. functions. [1]
(a) Aggregate
(b) Summary
(c) Both
(a) and (b)
(d) Queries
Answer:
(c) Both (a) and (b)

Explanation:
Aggregate functions are also known as Summary functions. These are used to aggregate the group of records. They produce a single value from the group of values.

Related Theory:
Most common aggregate functions in a DBMS are Count, Sum, Average, Minimum and Maximum.

(E) …………………….. is used to retrieve information from the web. [1]
(a) Server
(b) Windows
(c) Client
(d) Browser
Answer:
(d) Browser

Explanation:
A browser is a specialised program or software on a client computer that retrieves information from the web. E.g. Google Chrome, Mozilla Firefox etc.

Related Theory:
A server is a computer or system that provides resources, data, services, or programs to other computers, known as clients over a network.

(F) …………………….. ae the values passed to macros as functions. [1]
(a) Values
(b) Arguments
(c) Data
(d) Information
Answer:
(b) Arguments

Explanation:
An Excel macro is an action or a set of actions that can be recorded, named, saved and executed as many times as required and whenever desired. Macros can also be created to behave like functions. These macros accepts values or arguments to perform the function associated with them.

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.
Differentiate between Interests and Abilities? [2]
Answer:

Interests	Abilities
The things that you like to perform in free time are called interests.	It is an acquired or natural ability of doing something.
It includes activities that you would like to do yourself No one will ask you to do it.	An ability is a skill that enables you to perform tasks up to a level of proficiency.

Question 7.
Define any two stress management techniques. [2]
Answer:
Following are two most common stress management techniques:
(i) Meditation: Meditation calms our mind and body by clearing all the thoughts. It reduces our mental and physical stress.
(ii) Taking breaks and good sleep: taking break from usual routine lowers the stress. Sleep relaxes and recharges brain and makes it ready to work again next day.

Question 8.
What is time management and how can it be done? [2]
Answer:
Time management refers to planning of available time and allocating time for specific tasks in order to complete the tasks as per priority and importance. Following are some of the tips to manage time effciently:

Follow the schedule strictly and avoid delaying any work.
Always set the priority and start with urgent and important task.
Avoid multitasking and do one thing at a time.
Keep your work space free from clutter.

Question 9.
Describe any two qualities of a successful entrepreneur. [2]
Answer:
Entrepreneurship is possible only when a person has built-in or developed some specific qualities. Two of these qualities are as follows:

Passion: They are passionate for their work.
Creative and Open minded: They are creative and open to new ideas.

Question 10.
List the measures that can be taken for correct data collection. [2]
Answer:
To monitor any progress, correct and ample amount of data should be collected at regular intervals. Following measures can be taken for correct data collection:

Interviews.
Questionnaires and surveys.
Observations.
Documents and records.
Focus groups.
Oral histories.

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

Question 11.
What to you understand by cropping an image? [2]
Answer:
Cropping refers to removing or trimming an , unwanted area from an image starting from its edges. In a word processor cropping hides the unwanted part of an image.

Question 12.
While saving a shared document if you are resolving the conflicts, can any other user save the document at that time? [2]
Answer:
If another user is trying to save the shared spreadsheet and resolve conflicts, they see a message that the file is locked due to a merge in progress. They can cancel the Save command and retry saving later. When you successfully save a shared spreadsheet, the document shows the latest version of all changes saved by all users.

Question 13.
What is a form? Define the uses of forms? [2]
Answer:
A form is an object use to create a user interface for a database application. The uses of forms are as follows:

It provides user friendly interface to insert data.
Data can be modified and viewed using forms.
Forms are also helpful in searching and deleting records.

Question 14.
Define peer-to-peer network. [2]
Answer:
A peer-to-peer network is a networking technology in which two or more computers are connected to each other and there is no specific designated server. Every computer can work as a client or as a server depending upon the need. They can switch roles as and when required.

Question 15.
What is cyber safety? Discuss its importance. [2]
Answer:
Cyber safety refers to safety of computers and data over internet. It simply means being safe online from security issues such as hacking, data theft, spying, malicious software etc.

Cyber safety is important because it protects data from theft and damage. This includes sensitive data such as personal information, intellectual property, government data and industrial or commercial data.

Question 16.
Explain the significance of What-If analysis. [2]
Answer:
What-if analysis tool in a spreadsheet is used to analyse different types of input data and the results yielded from them. It helps is taking better decisions as per different inputs and their effects on output.

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

Question 17.
Anita is a receptionist in a hotel. Her job is to maintain the records of guests in a spreadsheet. To simplify her work, she has created macros. [4]
(A) What is a macro?
Answer:
A macro refers to a named and recorded sequence of commands or keystrokes that are saved in spreadsheet for Later use. These can be reused any number of times.

(B) How are they useful?
Answer:
Sometimes you have tasks in spread sheet that you do repeatedly or frequently. Macros can automate such common and repetitive tasks. By reducing the number of keystrokes, macros speed up the work and also reduce the time to complete the task.

(C) What is the command to record macro in Calc?
Answer:
To record a macro in Calc click command Tools → Macros → Record Macro.

(D) Name any two spreadsheet programs other than Calc.
Answer:
MS Excel Lotus Symphony are the examples of spreadsheet programs.

Question 18.
Happy Valley school is conducting an open workshop on cyber crime and security measures. Students from outside the school can also attend the workshop. For this, school wants to send an invitation letter to the Principals of different schools. [4]
(A) Name the Word processor tool to accomplish the above task.
Answer:
The word processor tool used for generating .multiple personalized letters is Mail Merge.

(B) Define the tool.
Answer:
Mail merge is a feature of word processor program that automatically merges a common text with a set of data from data source to generate personalized letters.

(C) Name the components required for the process.
Answer:
Components required for Mail Merge are data source and the main text document that contains the main body of the letter.

(D) Name any two applications that they should use for the purpose.
Answer:
Word processing programs that can do mail merge are OpenOffice Writer, LibreOffice Writer, MS Word etc.

Question 19.
Following table displays a part of information of student’s marks in different subjects. [4]

(A) Define the structure of the given table.
Answer:
The structure of the given table is:

StulD	Integer
StuName	Char (20)
Marks1	Integer
Marks2	Integer
Marks3	Integer

(B) Write commands of SQL to:
(a) Add a new record with given
details (“1009”, “Divya Sharma”, “77”, “56”, “67”).
(b) Modify the marks of Nidhi Singh as Marksl=97, Marks2=89, Marks3=84.
(C) Change the column names Marks1, Marks2, Marks3 with Eng, Math and IT respectively.
Answer:
SQL Commands:
(a) INSERT INTO marks VALUES (1009, “Divya Sharma”, 77, 56, 67):
(b) UPDATE marks SET marks1 = 97, marks2 = 89, marks3 = 84 WHERE StuName= “Nidhi Singh”;
(c) ALTER TABLE marks RENAME COLUMN marks1 TO Eng, RENAME COLUMN marks2 TO Math, RENAME COLUMN marks3 TO IT;

Question 20.
Aditya is an Office Manager and he manages the records of employees of that company. There are two tables in company’s database. The first table is Employee which holds personal information of employees such as their id’s, name, their department etc. Another table is Salary that holds information about their salaries and other perks. Both the tables are related to each
other. Answer the following questions based on the above information:
(A) Which is the most appropriate field in the employee table to relate the two tables?
Answer:
The most appropriate field that relates both the tables is employee id.

(B) Define foreign key?
Answer:
A foreign key is a field in one table that refers to the primary key field of another table.

(C) What is a composite key?
Answer:
A composite key is a combination of two or more fields that together uniquely identifies the records.

(D) Name the fields of salary table that can be a foreign key. [4]
Answer:
Employee Id can be a foreign key in salary table because it will relates with the primary key of employee id in Employee table.

Question 21.
Ankita owns a small soap manufacturing unit. She sells her products on internet. Help her by understanding some of the terms used while selling or purchasing over Internet. [4]
(A) What is online shopping?
Answer:
The buying and selling of products and services over the internet is called online shopping. Any thing from clothes to electronic goods and common house hold items to insurance policies can be sell and purchased online.

(B) Define digital order.
Answer:
Digital order means placing an order on a platform that is non-physical. It can be done using a mobile application’or website. It is sent by the customer or Payment client to the payment server. E.g placing an order for something on Amazon, Flipkart or any other e-shopping site.

(C) Define digital receipt.
Answer:
Digital receipt is sent from the Payment server to the customer or payment client. It is sent in form of email or message on customer’s mobile number.

(D) Name any two online shopping platforms where she can sell her products.
Answer:
She can sell her products on Amazon, Flipkart, Nykaa etc.