CBSE Sample Papers for Class 10 IT Set 5 with Solutions

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

CBSE Sample Papers for Class 10 IT Set 5 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) Wahida runs a boutique. She buys cloth material from a local market. But recently she came in contact with a cloth manufacturer and discovered that there was quite a big difference in rates of same cloth material if bought from the manufacturer. She decided to purchase the material from the manufacturer. Which of the following function of entrepreneurship is she performing? [1]
(a) Planning
(b) Controlling
(c) Production and operations
(d) Finance and accounting
Answer:
(c) Production and operations

Explanation:
Managing production and operations include sourcing of raw materials, checking functioning of machinery, utilizing maximum capacity etc.

(B) For self-motivation, self-awareness is a very important factor. The feeling of self-awareness enhances our [1]
(a) Self-confidence
(b) Self-monitoring
(c) Self-regulation
(d) Self-discipline
Answer:
(a) Self-confidence

Explanation:
Self-awareness is the ability to be aware of one’s own life, emotions, thoughts, behaviours, preferences, goals etc. It is a self-management skill which helps to become better decision-makers which build up self-confidence.

Related theory:
Self-management involves following skills:

Stress management
Self-awareness
Self-motivation
Set goals
Time management

Explanation:
Notepad is a simple text editor for Windows. It creates and edits plain text documents. The default extension given to files created in Notepad is txt.

Related Theory:
w Related theory: docx and doc are the extensions given to the document files created in word processor. Spreadsheets made in Excel are stored with extension xlsx.

(D) Which of the following practice will protect computer from security threats? [1]
(a) Using antivirus
(b) Using Firewall
(c) Use of strong passwords
(d) All of these
Answer:
(d) All of these

Explanation:

Antivirus are the type of software detects and removes viruses and other malicious software from the computer.
Firewall is a network security system that monitors and controls incoming and outgoing network traffic and permits or blocks data packets based on set of security rules.
Strong passwords are created using the mix of character types, including numbers and special symbols. It has a sufficient length. The purpose of strong password is to ensure that the access is permitted only to authorized users.

(E) Rashmi was doing well in her job and was getting a handsome salary. But suddenly she made up her mind for starting her own business. Which one of the following is an advantage of entrepreneurship? [1]
(a) Can work for their passion
(b) Can make money with less effort
(c) Working hours are long
(d) All of these
Answer:
(a) Can work for their passion

Explanation:
Entrepreneurship has some advantages which includes the choice of work. They can choose their passion as a work. E.g. if cooking is a passion of any person then he/ she can open his own food corner or restaurant.

Related theory:
Entrepreneurship also has some disadvantages that are listed below:

There are no fixed working hours.
Initially there will be very less or no income.
Finding investors that are interested in particular business, is very difficult
Risk factor is always there with any business.

(F) Physical exercise is technique to ……………….. . [1]
(a) Relieve stress
(b) Manage time
(c) Boost self confidence
(d) All of these
Answer:
(a) Relieve stress

Explanation:
Physical exercise is a technique of stress management to relieve stress. It also boosts the self esteem, stabilizes mood and induces good sleep.

Question 2.
Answer any 5 out of the given 6 questions.
(A) ………………. is not a component of Mail Merge. [1]
(a) Worksheet
(b) Data Source
(c) Main text document
(d) None of these
Answer:
(a) Worksheet

Explanation:
Mail merge consists of three main components: the Main document, the Data Source and the merged document. To create a data source click on File → New → Database. The Database Wizard will start up to create a table. This table is later used to merge with main document. Worksheet is not required at any. step in complete process of mail merging.

(B) A URL with HTTP symbol is considered as ………………. connection. [1]
(a) Secure
(b) Insecure
(c) Protected
(d) Virus free
Answer:
(b) Insecure

Explanation:
An insecure connection means that your private information may get leaked where as a secured connection ensures that your personal data is safe and no one can see it.

Related theory:
Any URL that contains HTTPS or a padlock sign is a secure connection.

Explanation:
A database report is a formatted way to present data from tables or queries. Reports help in decision making and analysis.

Caution:
Reports and Forms both represents data in formatted way, but both are used for different purposes. Forms are used to add, edit, delete and view data using interactive screen whereas reports are usually the printed form of data in formatted way.

(D) Which of the following is correct about query? [1]
(a) It is an unused table
(b) It is command that interacts with database
(c) It is table design
(d) None of these
Answer:
(b) It is command that interacts with database

Explanation:
Query is a command that interacts with database and gives you filtered data according to your conditions. You can specify fields, records and summaries that you want to fetch from the database.

(E) With every new change in headings of a document ………………. should be done immediately. [1]
(a) Create a new TOC
(b) Update TOC
(c) Delete old TOC
(d) None of these
Answer:
(b) Update TOC

Explanation:
On clicking Update Table the hierarchy of headings in Table of Contents is updated. This should be performed after every addition, modification or deletion of headings in the document.

(F) Which of the following device connects a computer to the Internet? [1]
(a) WiFi
(b) Broadband
(c) WiMax
(d) All of these
Answer:
(d) All of these

Explanation:
WiFi stands for Wireless Fidelity. It lets you connect your PC to the internet using a wireless router.
Wimax provides a broadband wireless access to fixed and mobile stations covering larger areas than WiFi.
Broadband Internet can be connected to the computer using conventional phone lines.

Question 3.
Answer any 5 out of the given 6 questions.
(A) ………………. controls the flow of text around an image. [1]
(a) Text Wrapping
(b) Drawing objects
(c) Text box
(d) Text Art
Answer:
(a) Text Wrapping

Explanation:
Text wrapping is a feature of word processor that refers to the placement ’ of text around images. The wrap settings determines the relation between the text and the graphic.

(B) Which of the following What-lf analysis tool deals with multiple unknown variables? [1]
(a) Goal Seek
(b) Solver
(c) Scenario
(d) None of these
Answer:
(b) Solver

Explanation:
The Solver is a advanced form of Goal Seek tool A solver deals with equations with multiple variables. It tries to find out maximum and minimum results from a multiple unknown variables.

Related theory:
Goal seek works on single variable where target is first determined and input value is calculated.

(C) A ………………. extracts data from a database as per a condition. [1]
(a) Forms
(b) Reports
(c) Queries
(d) Table
Answer:
(c) Query

Explanation:
A database query is a stored object that extracts data from a database as per a condition. Queries present the extracted data in formatted form.

(D) ………………. feature, of operating system help people with disabilities. [1]
(a) Accessibility
(b) Access
(c) Assist
(d) All of these
Answer:
(a) Accessibility

Explanation:
Every operating system provides Accessibility feature which helps people with disabilities to use the device. Eg., Magnifier, Narrator, Closed Captioning are some of the Accessibility features provided by Windows.

(E) ………………. is used for instant messaging. [1]
(a) Google Hangouts
(b) Google Chrome
(c) Gmail ,
(d) All of these
Answer:
(a) Google Hangouts

Explanation:
Google Hangouts is a IM application that allows you to chat from your computer’s desktop, make video calls and do group chats with other Gmail and Google Hangouts users.

Related theory:

Gmail is a free email service provided by Google.
Google chrome is a web browser developed by Google.

(F) 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) Price of book

Explanation:
The information stored in Price of Book field will not be unique. Thus, it is not an appropriate field to set as primary key.

Question 4.
Answer any 5 out of the given 6 questions.
(A) ………………. helps the website remember information about your visit. [1]
(a) Malware
(b) Information
(c) Cookies
(d) Virus
Answer:
(c) Cookies

Explanation:
Cookies are the small piece of text sent to your browser by a website you visit. They help that website remember information about your visit It becomes easier to visit the website again.

Related theory:
Cookies are not harmful as they cannot infect computer with viruses or other malware but these can be hijacked by cyber criminals and they can track your browsing history. Therefore ope should not allow cookies while browsing any webite.

(B) Veena is an office assistant. Her job is to create new documents according to the requirements. Sometimes she uses styles from her old documents to apply them on a new one. What can be the possible way to use the styles from her previous documents? [1]
(a) Copy and style document and then paste in new document
(b) Export the styles to new document
(c) Import styles from the old document to the new one
(d) Type the new document at the end of previous one and apply the styles
Answer:
(c) Import styles from the old document to the new one

Explanation:
The styles you create in a document are stored in it to use the same styles in another document follow the given steps:

Click the Home tab.
Open the Styles pane.
Click the Manage Styles button.
Click Import/Export. The Organizer window will open. Click on the Styles tab.
Select a style.
Click the Copy button. The style will be copied to the selected document
Click Close.

(C) State whether true or false:
“A field consists of large number records” [1]
(a) True
(b) False
(c) Can’t say
(d) True sometimes
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) ………………. is a rule that ensures relationship between records in related tables. [1]
(a) One to One relationship
(b) One to many relationship
(c) Referential integrity
(d) Data consistency
Answer:
(c) Referential integrity

Explanation:
Referential Integrity is a rule of DBMS which ensures that reference from a row in one table to another table must be valid. It makes sure that user does not accidently delete or change the related record.

(E) ………………. occurs when multiple users have made changes in same set of cells in a spreadsheet. [1]
(a) Changes conflict
(b) Name conflict
(c) Resolve conflict
(d) All of these
Answer:
(a) Changes conflict

Explanation:
It occurs when multiple users are working on a shared spreadsheet and the changes made by them affects same cells.

Related theory:
In such a case Resolve Conflicts dialog box is shown. User can decide which version of changes are to be kept

(F) A template can be used to create ……………….. documents. [1]
(a) As many
(b) Only one
(c) Only two
(d) Depends on application
Answer:
(a) As many

Explanation:
A template is a blueprint, containing formatting features like styles, alignments, colours etc., using which one can create as many documents as required.

Question 5.
Answer any 5 out of the given 6 questions.
(A) Which ofthe following is an example of data consolidation? [1]
(a) Collecting budget data from different departments and making overall company budget from them.
(b) Collecting marksheets of students and creating report card out of them
(c) Using sales data of different cities to find out overall sales of a company
(d) All of these
Answer:
(d) All of these

Explanation:
Data consolidation is a process of collecting or considering data of multiple worksheets and consolidate them into one single worksheet or summary report. It is used to combine similar types of data stored in different sheets of a workbook.

Related Theory:
Formulas like sum, count average. min, max are used while combining data and making a report.

(B) While recording a macro the keystrokes are converted into ………………. [1]
(a) Links
(b) Code
(c) Formula
(d) Function
Answer:
(C) Code

Explanation:
In a spreadsheet the keystrokes recorded for macro are converted into an internal code that can be used later to perform the same task multiple number of times.

Related theory:
Macros are the recorded sequence of keystrokes that are saved for later use

(C) Which of the following cannot be done using Table Design view? [1]
(a) Adding fields
(b) Moving fields
(c) Adding data
(d) Changing field properties
Answer:
(c) Adding data

Explanation:
The Table Design view allows to edit the table design. Following actions can be performed in this view:

Adding fields
Moving fields
Deleting fields
Changing field properties

Related theory:
The Table Design view shows the structure of a table. It shows the details of table such as Field name, Field type and description.

Caution:
To add records in a table, you can use Data sheet view and Form View.

(D) The ………………. constraint ensures that all values in a column satisfies certain condition. [1]
(a) Check
(b) Primary key
(c) Not null
(d) Default
Answer:
(a) Check

Explanation:
The CHECK constraint is used with CREATE TABLE command to verify that the value in a column satisfies certain condition. This constraint is totally optional.
e.g. CREATE TABLE student CHECK (Stuld>0), Name varchar (30)

Related theory:
By default a column left blank stores NULL value. The NOT NULL constraint ensures that column does not have NULL value.
The DEFAULT constraint provides a default value to a column.
The PRIMARY KEY is used to store unique values in a column.

(E) Which of the following feature are not helpful for people with hearing impairments? [1]
(a) Sound volume
(b) Closed captions
(c) Presentation tools
(d) None of these
Answer:
(c) Presentation tools

Explanation:
Presentation tools are helpful for the people with speech impairment Power Point is one such visual presentation tool.

Related theory:
Messaging tools and text-to- speech feature is also helpful for the people with speech impairment power point is one such visual presentation tool.

(F) Which of the following does not allows e-ticketing [1]
(a) For watching movies
(b) For travelling by air
(c) Travelling by train
(d) Booking a bed in hospital
Answer:
(d) Booking a bed in hospital

Explanation:
E-ticketing refers to the online booking of tickets. It is a digital form of ticket.

Related theory:
Following requirements are to be fulfilled for e-ticketing:

Access to the Internet
Online payment facility

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.
Explain the term self reliance. [2]
Answer:
Self-reliance refers to the ability of a person to do things independently and make decisions by themselves by not taking help from others. A self-reliant person is also emotionally and intellectually independent.

Question 7.
Suhas is ready with his startup plan of pearl farming. He has a big vision regarding his business but does not have enough money to give it a start. Help him by suggesting the financing options for his startup. [2]
Answer:
There are majorly three different ways to finance a startup. These are as follows:

Equity Financing: It means raising funds for startup against equity. The financer becomes co-owner of the startup with some percentage of share.
Debt Financing: It means the funds are raised through debts from different financial institutes. E.g. loan from bank.
Government grant and Support: If the owner is ready with maximum funds then he can go for grants and loans available through different government schemes. E.g. Startup India.

Question 8.
Shri has been facing problems with his PC for the last few months. Every time he goes to the technician, he suggests that he should maintain his PC properly. What are the tasks that are carried out for computer maintenance? [2]
Answer:
Computer maintenance refers to the tasks performed to keep the computer in a good working state. These tasks include:

Physical cleaning: All the dust and trash should be removed as these heat up the computer.
Internal Cleaning: It refers to the cleaning of temporary files, viruses, malicious software etc. to keep the applications and programs virus free.
Keeping backups and Update Software: This results in increased efficiency of applications and programs.

Question 9.
Explain the relationship between self regulation and goal setting. [2]
Answer:
Self-regulation is the ability to control one’s behavior, emotions, and thoughts to achieve some goals. Goal setting is the process of planning and taking active steps to achieve the desired outcome which is only possible through self regulation.

Question 10.
Discuss any two misconceptions and their realities about entrepreneurship. [2]
Answer:
1. Myth: The only requirement for entrepreneurship is a good idea.
Reality: Only idea is not important Other factors like planning, leadership, talent communication etc. also plays an important role for successful entrepreneurship.

2. Myth: To start a business lot of money is required.
Reality: A certain amount of money, depending upon the .business, is required to initiate it. Later a person can borrow money from family or bank. There are many financing options for startups.

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

Question 11.
Discuss the advantages of a template. [2]
Answer:
Templates are useful for the following reasons:

Templates simplify the process of document creation.
Templates can ease our workload and also increase efficiency.
Templates increase the attention of the audience.
They also help in saving time and money.
Templates improve clarity and ensures that all documents have the same layout.

Question 12.
Differentiate between Absolute and Relative hyperlinks. [2]
Answer:

Absolute Hyperlink	Reladve Hperlink
Absolute hyperlink defines the path to reach a document starting from the topmost folder.	Relative hyperlink defines the path of o document with respect to active location.

Question 13.
What do you understand by relationships in DBMS? How many types of relationships are there? [2]
Answer:
In a DBMS relationships are defined links that associate two tables through a common field. A relationship joins the two tables virtually forming one large table. There are three types of relationships:

One-to-one
One-to-many
Many-to-many

Question 14.
Explain Accessibility feature with at least two examples. [2]
Answer:
Accessibility refers to the hardware and software technologies that help people with different types of disabilities to use the computer. For example, the accessibility features in Windows for people with vision impairment are Narrator and Magnifier. The accessibility features for people with Mobility impairment are Sticky keys, Filter keys and Toggle keys.

Question 15.
Differentiate between MAN and WAN. [2]
Answer:

MAN	WAN
MAN stands for Metropolitan Area Network	WAN stands for Wide Area Network
This type of network is spread over a city. E.g. Cable TV network	This type of network is spread across countries. E.g. Internet, Intranet

Question 16.
What are the two ways to create reference to link sheets of another workbook? Explain any one of them. [2]
Answer:
The two ways to link sheets are:

By mouse
By keyboard

To create reference by keyboard one has to type complete address of the linked sheet. The reference consists of three parts: path or filename, sheet name and cell. General format of reference is:
= ‘file:///Path &File Name’#$SheetName.cell name.

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

Question 17.
Garima is a Mathematics teacher and she uses Spreadsheet to maintain the mark lists of her classes. She teaches five different sections and for each section she has a separate sheet. She has to perform similar functions in all the sheets. To save her time she wants to create a macro. [4]
(A) Write steps to create a macro.
Answer:
Steps to create a macro are as follows:

Click Tools → Macros → Record Macro.
Start recording of actions in a macro and display Record Macro toolbar with one icon on it to Stop Recording.
Now start performing the actions you want to include in a macro.
Click Stop Recording button after completing the actions.
Now type the name of the macro in the Macro Name box and click on Save.

(B) Write steps to run a macro.
Answer:
Steps to run a macro are as follows:

Open the worksheet in which you want to run a macro.
Click Tools → Macros → Run Macro
Select the name of the macro from the list of macros and click on Run button.

It automates the keystrokes and tasks that are done repeatedly.
It reduces the time spent on repetitive computing tasks.

(D) What is the extension of files in OpenOffice Calc and MS Excel?
Answer:
The extension of OpenOffice Calc file is, ODS and that of MS Excel is .XLSX

Question 18.
Yashika is creating a newsletter in a word processor for her school bulletin board. She wants to add some pictures on that newsletter. [4]
(A) What are the sources to add an image in a document?
Answer:
An image in a word processor can be inserted:

From file
From gallery

(B) Define text wrapping.
Answer:
Text wrapping means the placement of text around images. The wrap settings determines the relation between text and the graphic.

Before: The text flows before the image.
After: The text flows after the image.
Parallel: The text flows before and after the image.
Wrap Through: The image is superimposed over the text.
Optimal: The text flows around the image.

(D) What are the Arrangement options available in Writer?
Answer:
Writer provides two arrangement options:

Bring to Front: It brings selected graphic on the top of all the images.
Send to Back: It sends the selected graphic behind all the images.

Question 19.
Given below is the structure of a table namely Books: [4]

Book ID	Integer
Name	Varchar (40)
Author	Varchar (25)
Price	Decimal

(A) Explain the use of Varchar.
(B) Write SQL queries to:
(i) Create the table Books with Book ID as primary key.
(ii) Insert record with given details (‘12091’, “Panchtantra”, “Vishnu Sharma”, ‘250.00’)
(iii) Change the column Name to Book Name.
Answer:
(A) Varchar is a datatype in SQL which is used to store character strings of variable length in database. The size parameter specifies the maximum length of the string field.

(B) SQL Commands:
(i) CREATE TABLE BOOKS (Book ID Integer PRIMARY KEY,
Name Varchar (40),
Author Varchar (25),
Price Decimal);
(ii) INSERT INTO Books VALUES (12091, “Panchtantra”, “Vishnu Sharma”, 250.00);
(ii) ALTER TABLE Books RENAME Name TO Book Name;

Question 20.
Ashmit works in a hoteL He wants to store information of guests such as Serial number, Guest’s name, their room number, date of check-in, their address and phone number in database. Help hjm by solving some of his queries. [4]
(A) Which field should be set as Primary key?
Answer:
Serial number can be set as Primary key by defining it as AutoNumber field.

(B) What is the default format of date in OpenOffice Base?
Answer:
The default format of date in OpenOffice Base is DD/MON/YY.

(C) Define forms in database?
Answer:
A form is a database object which is used to create user interface. It is a front end for data entry and editing.

(D) How can you create a form in OpenOffice Base?
Answer:
The simplest way to create a form in OpenOffice Base is by using Form Wizard. To create a form through wizard click on’ ‘Forms’ in the left pane on the Database window and then click on ‘Use Wizard to Create Form’.

Question 21.
Shakti’s father works in a bank. One day Shakti visited bank to meet his father. There were no customers in the bank and all the employees were sitting. His father told him that the server was down and no banking operations could be performed. [4]
(A) What is a server?
Answer:
A server is a computer or system that provides resources, data, services, or programs to other computers over a network.

(B) What are other computers in the network called?
Answer:
Other computers in the network are called clients. A client is a computer that connects to and uses the resources of the server.

(C) Name the types of networking architecture.
Answer:
Based on component roles there are two types of networking architecture:

Client Server architecture
Peer to Peer architecture

(D) What type of networking technology, you think, is being used there?
Answer:
The networking technology used in this case is Client-Server Architecture.
In this type of network each computer is designated a role, either as server or as a client.