CBSE Sample Papers for Class 10 IT Set 6 with Solutions

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

CBSE Sample Papers for Class 10 IT Set 6 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) Stress management prevents problems. [1]
(a) Behavioural
(b) Psychological
(c) Both (a) and (b)
(d) None of these
Answer:
(c) Both (a) and (b)

Explanation:
Stress can harm our emotional and physical health which limit our ability to function well at work and personal relationships. Stress management is about making a plan to be able to cope effectively with daily pressures. The ultimate goal is to make a balance between life, work, relationships, relaxation and fun. By doing this, you are able to deal with psychological and behavioural challenges.

(B) A person is said to be stressed if he is : [1]
(a) Tense
(b) Worried
(c) Relaxed
(d) Both (A) and (B)
Answer:
(d) Both (a) and (b)

Explanation:
A person who is stressed shows symptoms like tension and worry. Relaxing is not a symptom of stress.

(C) Shrikant is a hotel manager. A customer complained about delay in completing the order and started yelling at him. Shrikant did not said a word to him and listened to his complaint very calmly. Shrikant is [1]
(a) Patient
(b) Timid
(c) Feared
(d) Angry
Answer:
(a) Patient

Explanation:
Patience in an entrepreneur is a positive attitude towards his client. It rewards the entrepreneur with better sales, increased customer satisfaction and stronger profits.

Caution:
Answer for such questions will be given in context of entrepreneurial skills.

(D) Which of the following is an idea of self-employment? [1]
(a) Making a shoe in factory.
(b) Selling shoe in a showroom.
(c) Owning a shoe factory/ showroom
(d) Maintaining accounts of shoe factory/ showroom.
Answer:
(c) Owning a shoe factory/ showroom

Explanation:
Owning any kind of trade is a type of self-employment. Any salaried or paid job is a type of wage employment.

Related Theory:
A self-employed person does not work for a specific employer who pays them a consistent salary. Self-employed individuals earn income from a trade or business, directly.

(E) Shortcut keys used to paste a file is : [1]
(a) Ctrl + C
(b) Ctrl + P
(c) Ctrl + V
(d) Ctrl + X
Answer:
(c) Ctrl + V

Explanation:
To move or create a copy of file you select the file from file explorer and click on Cut or Copy respectively. In both cases you have to paste the file in a new location by clicking on the Paste option or by pressing the shortcut key Ctrl + V.

(F) The ……………………….. gives access to all active applications by showing the row of open application title boxes. [1]
(a) Start menu
(b) Task bar
(c) Title bar
(d) Control Panel
Answer:
(b) Task bar

Explanation:
The Taskbar is an element of Windows desktop and is located at the bottom of the screen. It is the access point for programs displayed on the desktop, even if it is minimized.

Question 2.
Answer any 5 out pf the given 6 questions.
(A) ……………………….. style affects numbering and bullet style. [1]
(a) Page
(b) Frame
(c) List
(d) Paragraph
Answer:
(c) List

Explanation:
A list style affects numbered and bulleted lists. These store formatting features like numbered/bullet style, margins of list line spacing and before and after spacing etc.

(B) Which of the following process is not a part of Mail Merge? [1]
(a) Creating main document
(b) Creating data source
(c) Linking with external source
(d) Merging the main document with data source
Answer:
(c) Linking with external source

Explanation:
The main document is linked with the data source through the fields defined in the main document.

Caution:
Mail merging does not require any kind of linking with external source.

(C) Consolidate options is available ……………………….. menu. [1]
(a) Tools
(b) View
(c) Insert
(d) Data
Answer:
(d) Data
Explanation: To perform consolidation, click on Data → Consolidate.

Related Theory:
Data consolidation refers to the process of collecting and integrating data from multiple sources into a single destination.

(D) Ankita has joined as a Personal Assistant to the General Manger of the company. She was told to create a workbook with three worksheets for the data of employees working in the offices of three different countries. This data is presently stored in three separate workbooks. What would you suggest Ankita to do? [1]
(a) Create a workbook and insert a link to the worksheets where data is presently stored.
(b) Create a workbook and copy all the data into it.
(c) Create a workbook with three worksheets and paste data of each offce into these sheets.
(d) Apply data consolidation on three workbooks.
Answer:
(c) Create a workbook with three worksheets . and paste data of each office into these sheets.

Explanation:
To add data from three different workbooks in separate worksheets one has to create a new workbook and add sheets if required. Then copy data from each workbook into separate sheets of new workbook.

(E) The Table Design view allows you to [1]
(a) Add fields
(b) Delete fields
(c) Change field properties
(d) All of these
Answer:
(d) All of these

Explanation:
The Table Design view is used to design a table. One can create a new table or modify a’ existing one using this view. It shows the structure of the table i.e. Field Name, Field Type and Description.

Related Theory:
Tables’ can be created through Wizard. It simplifies, the process, but limits the choices of designing the table structure, which a user gets in Table Design view. In this view user can even set the criteria or valid inputs for specific held to avoid discrepancies.

(F) tool is not an accessibility feature for speech. [1]
(a) Narrator tool
(b) Text-to-speech tool
(c) Visual Presentation tool
(d) Messaging tool
Answer:
(a) Narrator tool

Explanation:
The narrator tool is a screen reading app and is useful for blind or low vision users.

Related Theory:
Magnifier is another tool for blind or low-vision impairment people. This tool makes the part of entire computer screen bigger.

Question 3.
Answer any 5 out of the given 6 questions.
(A) Meeta is creating a sales report using Report Wizard. She wants that the sales of same Zonal Office should appear together, and for each Zonal office the sales data should be printed in descending order of the sales. What should Meeta do to perform the same? [1]
(a) She should create a table in the required order and then use it to generate report.
(b) She should add Group Field in the report as ZonalOflfice and sort the group on the basis of Sales in descending order.
(c) Both (a) and (b) can be done
(d) None of these
Answer:
(b) She should add Group Field in the report as ZonalOffice and sort the group on the basis of Sales in descending order.

Explanation:
A Group field is a technique to group together one or more fields on a page. The similar fields into a common category appear together. This helps in better organizing and understanding the data.

(B) SELECT command of SQL is a type of command. [1]
(a) DDL
(b) DML
(c) TCL
(d) All of the above
Answer:
(b)DML

Explanation:
DML stand for Data Manipulation Language. It is used to manipulate data which includes retrieval insertion, deletion, modification of data stored in the database. SELECT command is used to retrieve data from the table.

Related Theory:
DDL (Data Definition Language) commands allow you to create, modify and delete the structure of the table.

(C) The Product data base has details of products stored into it. The Quantity table stores the balance quality of each product in the Product table. Both the tables are linked via ProductID field. While making some changes in Quantity table the ProductID field was accidentally deleted. Now the report of Balance quantity cannot be created as the corresponding record in Quantity table could not be identified. In the given case ……………………….. rule of DBMS is not being followed. [1]
(a) Data Consistency
(b) Data Redundancy
(c) Referential Integrity
(d) Relationship
Answer:
(c) Referential Integrity

Explanation:
Referential Integrity is a system of rules that a DBMS uses to ensure that relationships between records in related tables are valid and the user cannot delete or change related data.

(D) ……………………….. feature is known to be disabled in a shared spreadsheet. [1]

(a) Protect document
(b) Consolidate
(c) Compare document
(d) All of these
Answer:
(d) All of these

Explanation:
A shared document does not allow the given features. In addition, Move, Copy or Delete options are also not allowed.

(E) Smriti has to create an official letter urgently. So she decided to use template to save he time in doing formatting. Which of the following commands should she use to perform the same? [1]
(a) File → New → Template
(b) File → Template → New
(c) File → Save → Template
(d) File → Template → Save
Answer:
(a) File → New → Template

Explanation:
In MS-Word clicking on File → New, provides a list of templates. You can select any one them.
In Writer one has to click on File → New → Templates and Documents to create a new file from the template.

(F) ……………………….. program monitors all communication on a network and traps all illicit packets. [1]
(a) Anti-Spyware
(b) Anti-Virus
(c) Anti-malware
(d) Firewall
Answer:
(d) Firewall

Explanation:
A Firewall is a network security feature that controls the incoming and outgoing network traffic. It creates a barrier between trusted network and an untrusted network and decides whether to allow or block specific traffic based on a set of security rules.

Question 4.
Answer any 5 out of the given 6 questions.
(A) Which of the following styles is not offered by a word processor? [1]
(a) Page style
(b) Presentation style
(c) Frame style
(d) Character style
Answer:
(b) Presentation style

Explanation:
A word processor only supports the following styles:

• Character
• Frame
• Page
• Paragraph
• List

(B) At Rekha’s school, there is one central computer that has all the resources, such as a printer and high-power processor. Which type of network architecture is being used there? [1]
(a) Point-to-point
(b) Peer-to-peer
(c) Client-Server
(d) Consumer-Provider
Answer:
(c) Client-Server

Explanation:
In the client-server architecture of network there is one dedicated server and all other computers connected to it are called clients. The server is responsible for providing hardware and software resources to all other clients.

(C) Which of the following functions can be applied while data consolidation? [1]
(a) Sum
(b) Min
(c) Average
(d) All of the above
Answer:
(d) All of the above

Explanation:
While consolidation, the data is collected and integrated using some . functions like Sum, Average, Count, Max, Min etc.

(D) ……………………….. is a fixed length data type and ……………………….. is a variable length data type. [1]
(a) Char, Varchar
(b) Varchar, Char
(c) Double, Real
(d) Integer, Double
Answer:
(a) Char, Varchar

Explanation:
CFIAR is a fixed length string data type, which means that remaining space in the field is padded with blanks. CHAR takes 1 byte per character. So, a CHAR(IO) field takes 10 bytes on disk, regardless of the string it holds.

VARCHAR is a variable length string data type which means that it holds only the characters you assign to it VARCHAR takes 1 byte per character, + 2 bytes to hold length information. For example, if you set a VARCHAR(IO) data type = ‘Jack’, then it would take 4 bytes (for J, A, C and K) plus 2 bytes, i.e. 6 bytes in all.

(E) Which of the following component is not a part of database? [1]
(a) Queries
(b) Forms
(c) Tables
(d) Tools
Answer:
(d) Tools

Explanation:
A database consists of tables, forms and queries. Tools of Database Management System help in creating and working on databases.

(F) ……………………….. is an application program that is stored on a remote server and delivered over the Internet. [1]
(a) Internet application
(b) Web application
(c) Server application
(d) Browser application
Answer:
(b) Web application

Explanation:
A web application is an application program that is stored on a remote server and delivered over the Internet through a browser interface. Web services are a type of Web apps.

Question 5.
Answer any 5 out of the given 6 questions.
(A) To make the picture as mirror placed at the bottom of the image ……………………….. tool is used. [1]
(a) Flip horizontal
(b) Flip vertical
(c) Rotate
(d) Crop
Answer:
(b) Flip vertical

Explanation:
Flip vertical tool will change the placement of image upside down, which looks like mirror placed at the bottom of the image.

Related Theory:
The Flip Horizontal tool will create the mirror – image to the left or.right of the image.

(B) What will be the output of =MAX(10, 18, -210,190)? [1]
(a) 190
(b) -210
(c) 18
(d) 10
Answer:
(a) 190

Explanation:
The MAX function in spreadsheet returns the largest value out of the given values.

(C) Scenarios are the tool to test ……………………….. type of questions. [1]
(a) If-else
(b) What-if
(c) What-then
(d) If-then
Answer:
(b) what if

Explanation:
There are three tools in a spreadsheet that are provided for What-if analysis: Scenario, Goal Seek and Solver

(D) A table has ……………………….. rows and ……………………….. columns. [1]
(a) Vertical, Horizontal
(b) Horizontal, Vertical
(c) Any of the above
(d) None of the above
Answer:
(b) Horizontal, Vertical

Explanation:
Rows in a database are arranged horizontally and are called records. The columns in a database are arranged vertically and are known as fields.

(E) A modem is connected between a computer and a ……………………….. . [1]
(a) Telephone line
(b) Router
(c) Switch
(d) Hub
Answer:
(a) Telephone line

Explanation:
A modem is a device that connects computer to internet via telephone lines. It converts the incoming analog signals to digital signals of a computer and vice-versa.

(F) ……………………….. is a software which can track and transmit every key that is pressed on a keyboard to unauthorized users, [1]
(a) Virus
(b) Malware
(c) Key logger
(d) Spyware
Answer:
(c) Key logger

Explanation:
A keylogger is a type of malware that can be installed on a computer to track and record every keystrokes. It takes the information and sends it to a hacker.

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.
What does T mean in SMART? [2]
Answer:
‘T’ in SMART goals stands for timely which means that the goal to be achieved must be time-bound. It must have a start and finish date. If the target date is decided for a goal then there must be a deadline to focus. This heLp is preventing other tasks from taking priority over the longer-term goals. If the goal is not time- constrained, there will be there will be no need of urgency and thus no motivation to achieve the goal.

Question 7.
Kritikq is an UPSC aspirant. She devotes minimum 6 to 7 hours to her studies. She also gives tuition to school students to earn her pocket money. In addition to this sometimes she has to help her father in his shop. What will be the consequences if she could not mange time for all her tasks? [2]
Answer:
Poor time management may lead to many problems that are listed below:
1. Missing the deadlines: Not knowing what to prioritize may Lead to missed deadlines. This would happen if time management is not done.

2. Problematic relationships and social life: When the tasks are not managed properly it takes over our time and energy. As a result we spend a very little time with our loved ones.

3. Mental health problems: People with poor time management skills could not complete their tasks in time due to which they are always stressed. And their physical and psychological well-being are at risk.

4. Sleep deprivation: People with lots of imbalance in their work and personal life may have physical problems too. This may lead to disturbed sleep which will further effect their efficiency of work.

Question 8.
According to you, what are the two most important qualities to become a successful entrepreneur? [2]
Answer:
The two most important qualities required to become a successful entrepreneur are:
(A) Motivation – Entrepreneurs are self- motivated. They do not depend on anyone else to push them towards their goal.
(B) Visionary – Entrepreneurs are high visionaries. They have a clear vision of their goals.
(C) Determined – An entrepreneur is determined and, does not get affected by defeats. He believes that there is nothing impossible.

Question 9.
Write steps to restore a deleted file in Windows. [2]
Answer:
To restore a deleted file in Windows, perform the following steps:

• Double-click the Recycle Bin icon on the Windows desktop screen.
• The Recycle Bin window will open. Now Locate the file you want to restore. –
• Select the file/ files to be restored.
• Under the Manage Tab, click on Recycle Bin Tools → Restore group → Restore the selected items command.
• This will undelete the selected file/ files and send them to the location from where they were deleted.

Question 10.
What points are to betaken into consideration before deciding the entrepreneurship as a career [2]
Answer:
Before deciding entrepreneurship as a career choice, one has to self-evaluate with the following questions: ,
1. The attitude towards work effort: In initial stages, entrepreneurship demands much intensity of work efforts. The entrepreneurs have to work hard and for Long hours.

2. Ready to take risk: The capital you invested is initially at risk and there is no certainty of income. The success of venture is also not guaranteed.

3. Attitude towards freedom of decision making: An entrepreneur should be a decision-making authority. Those who need to work on someone else’s guidelines cannot be an entrepreneur. They should not need any one to guide them or correct them.

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

Question 11.
List any four key features of instant messaging. [2]
Answer:
The key features of instant messaging are as follows

• 24 × 7 availability: The instant messengers are used on handy devices like mobile, so they are always available.
• Can be used on multiple platforms: Be it a laptop, PC or mobile device, instant messengers can be used on any one of them.
• Group chat is possible: You can create groups of people and chat with them simultaneously.
• Storage of Chat history: Your chat history can be stored for a long time and backups of important chat history can also be taken in your cloud drive.
• Multimedia sharing: It allows sharing of audio, video, images, documents, links, location and contact.
• Audio/ Video calling: Instant messengers also allows to make audio, video calls and video conferencing.

Question 12.
Write any two uses of online shopping. [2]
Answer:
Online shopping is a type of action or activity of buyihg goods or services over the internet. It is helpful in following cases:
(A) When a customer does not have enough time to visit stores. Online shopping gives an opportunity to shop from anywhere and anytime.

(B) Online shopping provides discount offers. At that time visiting a store is more expensive than purchasing a product online. A customer gets heavy discount offers at festival time.

Question 13.
How merging plays an important role in office documentation? [2]
Answer:
The mail merge feature is very helpful in automating the documentation process in an office. The reasons are as follows:

• Using mail merge same letter can be sent . to a number of people.
• You don’t have to type the name of each recipient separately in each letter.
• The main document can be checked and verified once. The changes made in the main letter will be reflected in the Letters of all recipients.
• It saves both time and effort and thus is economical
• Hundreds of personalized letters can be generated in very less time.

Question 14.
Sumit is Head Librarian in a college library. The library is too big and has many sections containing books on different subjects. Each section is headed by an Assistant Librarian. The records of all the books and members are kept in database which is shared between him Sumit all other assistant Librarians. What is the advantage of sharing data? [2]
Answer:
Sharing worksheet among multiple users offers following benefits:

• All users can work simultaneously on same data.
• No need to keep multiple copies of the data.
• Any changes made in data is available to all.
• No need of sending copies of files through emails etc.

Question 15.
What are the advantages of using primary key in a table? [2]
Answer:
The advantages of using primary key in a table are as follows:

• It uniquely identifies each row in a table.
• The unique index for each primary key column helps with faster access.
• The primary key ensures that update and deletion is done only on specific rows rather than on larger volumes of data.
• It helps to maintain referential integrity.

Question 16.
Sameer is analysing a shared sheet. His two other colleagues are a Isa doing the same on that sheet. Wherever they want to make changes, they mark comments on it. What is the purpose of adding comments in a worksheet? [2]
Answer:
Spreadsheet comments are used to add a message to a cell or to clarify a formula. These comments when given in shared sheets helps others to understand the values or changes that one has notified with comments. A spreadsheet gives users the ability to. edit, delete, and show or hide comments on a worksheet.

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

Question 17.
Jayesh as head of the family sets the monthly budget for household expenses. He has to bear some extra expenses this month. He has made a list of income and expenditure and now he wants to find out from where to do cost cutting to meet his all his needs in the decided budget. [4]
(A) In which application he would be working?
Answer:
He can use a spreadsheet package for this purpose. It allows the use to enter data in a sheet and perform calculations on numeric data, sort the data and also perform what if analysis.

(B) Name the tool that can help him to do the same.
Answer:
To check the output in different situations he can use Solver. It is a type of What if analysis tool used to perform calculations by working under some different conditions and then calculate the solution for all the given values. It works on the objective cell by changing the variable cells.

(C) What is the objective of the tool used?
Answer:
The objective of Solver is to show the results in the changing cells and certain output cells for various trial values in a data cell. For each trial value in the data cell, Solver is called on to re-solve the problem.

(D) Write the names of the tools other than used in (B).
Answer:
There are two more tools other than Solver to perform What-if analysis. These are Goal seek and Scenario.

Question 18.
Sharda has written a book on Child Psychology in a word processor. The book consists of many chapters, that are further divided into topics and sub topics [4]
(A) She wants to summarize all the chapter names and their topics with page numbers. How is this possible in word processor?
Answer:
To summarize the chapter names and headings with page numbers the Table of contents can be created in a word processor.

(B) What are the steps to perform this?
Answer:
The Table of Contents can be created by performing the given steps:

• Place the cursor in the document where Table of Contents is to be placed.
• Click command Insert → Indexes and Tables → Entry
• The Insert Table/Index dialog box is displayed. Simply click OK.

(C) What are the prerequisites to perform the function you have mentioned in (A)?
Answer:
In order to add Table of Contents in a document one has to create a hierarchy of headings. All the headings, sub headings, sub subheadings etc. should be created using Styles. The text for table of contents is taken from these headings in the order of their level.

(D) What would happen if she changes the name of any chapter or heading?
Answer:
Once the Table of Contents is created the user has to ensure that it must be well maintained. If any heading, sub heading etc. is changed then the Table of Contents should also be updated. To do this perform the following:

• Place the cursor within the Table of Contents.
• Right-click and select Update Index/ Table from the pop-up menu.

Question 19.
Following table displays a part of information of Train Bookings. [4]

(A) Which data type is used for column Travel Date?
Answer:
The ‘Date’ data type used for the column Travel Date.

(B) Write SQL queries to:
(i) Add a column TrainNo as Integer.
(ii) View data of passengers boarding from Delhi.
(iii) Delete the records of passengers who have cancelled their tickets.
Answer:
(i) UPDATE Booking SET Status = “Cancel” WHERE PassName = “Amit Sahni”
(ii) ALTER TABLE Booking ADD TrainNo Integer
(iii) DELETE FROM Booking WHERE Staus = “Cancel”

Question 20.
Aradhya works for a construction company. He job is to maintain records of their sites and customers. She wants to create a database but does not have sufficient knowledge. Help her by answering the following questions. [4]
(A) What is a Table?
Answer:
A table is a named collection of all occurrences of a given type of all records. In relational databases table is also known as Relation.

(B) What are the components of a Table?
Answer:
A table is a container that primarily consists of two components – records that are arranged in rows and fields which are arranged in columns.

(C) What is the difference between Attribute and Record?
Answer:
An attribute is also called field and it represents one type of information or data item, whereas a record is a collection of data items that represents complete information of one entity. A record in database is called as tuple.

(D) What is Primary key?
Answer:
A primary key is a field or column that consists of values that uniquely identifies the records of a table.

Question 21.
Soham wants to watch a movie after office hours but by the time he will reach, the booking window will be closed. He cannot leave the office early. [4]
(A) How can he book the ticket without going anywhere?
Answer:
He can book the ticket using e-ticketing facility. It is an online booking facility where ticket can be booked using the Internet.

(B) What would he require for that?
Answer:
The requirements of online ticket booking are listed below:

• Access to the Internet
• Online payment facility i.e. a credit/ debit card or an account number that facilitates net banking.

(C) What are the applications used for the purpose mentioned in (A)?
Answer:
To make an online booking for movie tickets he can use applications like BookMyShow, TicketNew, InoxMovies etc.

(D) Mention any two safety measures that should be taken for Online payment.
Answer:

• Never use public WiFi or network for money transfer.
• Use secured connection for making online payment. The URL that starts with https:\\ is regarded as secured connection.