CBSE Sample Papers for Class 10 IT Set 4 with Solutions

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

CBSE Sample Papers for Class 10 IT Set 4 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) Self management skills refers to
(a) Controlling your happiness.
(b) Managing your belongings;
(c) Controlling your anger.
(d) Motivating oneself and setting goals.
Answer:
(d) Motivating oneself and setting goals.

Explanation:
Self management is a skill to that refers to stress management, self awareness, self regulation, self motivation and self confidence. By working on these skills one can find its own weaknesses and strengths which helps in setting and achieving goals for the person itself

Related Theory:
Visual forms of communication is done via pictures, logos, maps, posters etc.

(B) Which of the following is not a role of an entrepreneur?
(a) Team building
(b) Avoiding risks
(c) Cashflow management
(d) Decision making
Answer:
(b) Avoiding risks

Explanation:
There are certain risks involved in any entrepreneur venture. An entrepreneur should understand the risks and should be able to bear them too. Taking risks needs a farsightedness and planning in advance so that risks could be taken.

Related Theory:

Some of the roles of an entrepreneur are as follows:
An entrepreneur is a developer who creates a new product.
They have to play multiple roles for which time management has to be done.
They should be good decision makers.
Delegating tasks and getting output is based on people’s skills, which an entrepreneur must know.

(C) ………………….. is not a step of computer maintenance.
(a) Cleaning dust
(b) Copying files from hard drive to pen drive.
(c) Removing junk files
(d) Updating software
Answer:
(b) Copying files from hard drive to pen drive.

Explanation:
For internal cleaning one should remove junk files, empty recycle bin, use cleaning programs to remove unwanted files and folders. In addition to all this you can also run the defragmenter utility in a month or two.

(D) Punishment is a ………………….. type of self motivation.
(a) Extrinsic
(b) Intrinsic
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Extrinsic

Explanation:
Extrinsic motivation is one in which external factors are responsible for motivation. E.g. incentives, promotions, criticism etc.

Related Theory:
Intrinsic motivation depends upon internal factors such as joy, fear, love etc.

(E) Linux is an example of
(a) Operating system
(b) DBMS
(c) Antivirus
(d) Word processor
Answer:
(a) Operating system

Explanation:
Linux is an operating system. It is an open source software which is freely available on the Internet. Anyone can download and use it.

Related Theory:
Some other commonly used Operating systems are Windows, BOSS, Solaris.
Android and Apple iOS are popular mobile operating systems.

(F) Which of the following statement is incorrect about the impact of an entrepreneur in the society?
(a) Entrepreneurship creates jobs.
(b) The price of the product goes high.
(c) Contribute growth to overall economy.
(d) None of these
Answer:
(b) The price of the product goes high

Explanation:
More entrepreneurs sell same product and to make them at low cost they purchase local material. Thus, entrepreneurship lowers the rates of product.

Related Theory:
A communication barrier is a problem in communication that prevents us from receiving and understanding that the messages others use to convey their information, ideas and thoughts.

Question 2.
Answer any 5 out of the given 6 questions.
(A) ………………….. is not a type of style in word processor.
(a) Text style
(b) Character style
(c) Paragraph style
(d) Frame style
Answer:
(a) Text style

Explanation:
A word processor has following five types of styles:

Character style
Paragraph style
Frame style
Page style
List style

(B) Aradhya wants to invest some money. Her financial advisor has suggested some investment plans. She wants to check what return she would get from all the suggested plans. Which of the following What-lf analysis can help her to accomplish the task?
(a) Scenario
(b) Goal Seek
(c) Solver
(d) All of these
Answer:
(a) Scenario

Explanation:
A scenario in a spreadsheet is a tool of choice when you have multiple values and you want to see how these-./.&Hi*’- effect the final result. The scenario analysis is based on some formula using these values.

Explanation:
A field in a database is a set of data values, of the same data type, in a table. It is also referred to as a column or an attribute. Fields provide structure for a table. You can’t have a table without fields.

Related Theory:
A record is a set of data stored in a table. A record in a database is an object that can contain one or more values.
For example: in a student table Student ID and Name are the fields that are arranged in rows and the group of these fields relevant to a single student is a record. The records are arranged in rows.

(D) ………………….. configures the Windows 10 Accessibility options.
(a) Start menu
(b) Ease of Access
(c) Rle Explorer
(d) All Programs
Answer:
(b) Ease of Access

Explanation:
The Ease of Access in Windows 10 makes computer more accessible based on our needs. It offers lot of changes to make the PC work for the differently-abled people.

Related Theory:
To avail the Ease of Access options, click on Start – button → Settings → Ease of Access.

(E) Which of the following is not an advantage of a blog?
(a) It enables to write your thoughts.
(b) Available to everyone.
(c) Quick to add and update new posts.
(d) People can leave comments on blogs.
Answer:
(b) Available to everyone

Explanation:
The disadvantage of blog writing is that it is available for everyone to see. If someone writes a blog in a bad mood then he/she may regret later.

(F) Cropping means the area from an image.
(a) Adding
(b) Removing
(c) Enhancing
(d) Grouping
Answer:
(b) Removing

Explanation:
Cropping refers to the removing of unwanted area in an image. The cropping is done from the boundaries of the image.

Question 3.
Answer any 5 out of the given 6 questions.
(A) To create figure and shapes in a document ………………….. feature of word processor is used.
(a) Images
(b) Drawing objects
(c) WordArt
(d) ClipArt
Answer:
(b) Drawing objects

Explanation:
Drawing objects feature is used to add AutoShapes, Curves, Lines etc. into a document. A drawing toolbar is used to change and enhance the objects with colours, borders and other effects.

Related Theory:
WordArt, also known as TextArt, is a feature of word processor to create shadowed, skewed, rotated, and stretched text fitted into predefined shapes.

(B) In a spreadsheet the cell reference from B5 to E15 will be represented as
(a) B5-E15
(b) B5:E15
(c) B5;E15
(d) B5=E15
Answer:
(b) B5:E15

Explanation:
In a spreadsheet, the range of cells is a group of cells within a row or column. The notation for the range is defined by the reference of the upper left cell of the range and the reference of the lower right cell of the range with a colon sign between them. E.g., A1:C10

Related Theory:
The cell ranges are used within formulas, functions and other commands to refer the data oh which action is supposed to be performed.

(C) ………………….. is a shortcut key to create a new database.
(a) Ctrl + O
(b) Ctrl + N
(c) Ctrl + E
(d) Ctrl + D
Answer:
(b) Ctrl + N

Explanation:
To create a new database select the option ‘Create a New Database’ from the opening dialog box or press Ctrl + N from the keyboard.

(D) ………………….. helps to keep the Ctrl , Shift and Alt keys pressed until next key is pressed.
(a) Toggle keys
(b) Sticky keys
(c) Function keys
(d) Filter keys
Answer:
(b) Sticky Keys

Explanation:
Sticky keys is an accessibility feature of Windows that assists users having physical disabilities to reduce repetitive strain injury. It enables user to enter key combinations by pressing keys is sequence rather than simultaneously. It helps users who find difficulty in pressing shortcut key combinations.

Related Theory:
Toggle key are the keys on the keyboard that is operated in the same way but with opposite effect on successive occasions. E.g. Caps Lock is a toggle keys, pressed to switch between upper case and lower case alphabets.

(E) A query consists of …………………..
(a) Condition
(b) Reid
(c) Value
(d) All of these
Answer:
(d) All of these

Explanation:
A query in database consists of field name, condition and a value. For e.g. in the query ‘salary >= 35000’, salary is a name of the field, 35000 is the value and together with operator >= makes a condition or criteria.

(F) Digital order and digital receipt are a part of …………………..
(a) E-ticketing
(b) Online transaction
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Online transaction

Question 4.
Answer any 5 out of the given 6 questions.
(A) In Mail Merge, the main document consists of
(a) Letter only
(b) Letter and fields
(c) Addresses and fields
(d) Reids only
Answer:
(b) Letter and fields

Explanation:
The mail merge process consists of two main components: Main text document and Address data source.
The main document consists of letter, fields and merge instructions.

(B) Rajendra is an office assistant in a school He maintains the records of students in a spreadsheet He wants every class teacher to check the records of students their own class. He also wants to know the changes made by teachers. Which feature’ of the spreadsheet can help him to accomplish the task?
(a) Linking
(b) Macro
(c) Review changes
(d) Track Changes
Answer:
(d) Track changes

Explanation:
The Track Changes feature of spreadsheet is used to highlight changes as you work. The spreadsheet marks any revisions, such as changes, insertions, and deletions, with a highlighting color which can be reviewed later.

Related Theory:
Tracked changes are suggested changes. To make them permanent they have to be accepted or rejected by the author.

(C) key in a database is used to link tables together.
(a) Foreign
(b) Primary
(c) Short cut
(d) Relational
Answer:
(a) Foreign

Explanation:
A foreign key is a column or combination of columns that is used to establish a Link between the data in two tables via the primary key. It means the column of one table points to the primary key column of the other table. Thus, if any attribute is set as a primary key attribute, it will work in another table as a foreign key attribute.

Related Theory:
The Primary Key constraint uniquely identifies each record in a table.

(D) In Calc, the field for subtotal is specified through ………………….. option.
(a) Group By
(b) Subtotal
(c) Solver
(d) Scenario
Answer:
(b) Group By

Explanation:
The ‘Group By’ option in Subtotals dialog box allows to define the name of the field, which the subtotal command needs to be grouped.

Related Theory:
The subtotal dialog box opens by clicking Data → Subtotal

(E) Select the incorrect statement about Alternate key.
(a) It has unique value.
(b) It is not selected as Primary key.
(c) It is the other name given to the primary key.
(d) None of these
Answer:
(c) It is the other name given to the primary key.

Explanation:
An alternate key is a field which consists of unique records but is not declared as primary key. It is not the other name given to the primary key.

Related Theory:
The primary key and the alternate key together are called Candidate keys.

(F) A page hosted on Internet is called
(a) Website
(b) Web client
(c) Webpage
(d) Home page
Answer:
(a) Webpage

Explanation:
A webpage is a digital page or a document hosted on Internet. It is a document on WWW identified by a unique URL

Related Theory:
URL (Uniform Resource Locator) is the unique address of a webpage on the Internet

Question 5.
Answer any 5 out of the given 6 questions.
(A) Kavita wants to apply for a job. She needs a resume to submit in different companies. She knows what to write in a resume but does not know how to format it Which of the following features of a word processor can help her for the same?
(a) Style
(b) Template
(c) Table of contents
(d) None of these
Answer:
(b) Template

Explanation:
A template is a special type of empty document with all formatting features stored in it. Using a document template many documents can be created which will have same formatting features as defined in template.

(B) Which of the following is not an advantage of macros?
(a) Automates repetitive keystrokes.
(b) Reduces the possibility of human error.
(c) Reduces time spent in repetitive tasks.
(d) Makes tasks complex.
Answer:
(d) Makes tasks complex

Explanation:
Macros make complex computations easier to perform by storing them in a name, which can be re-run to perform the complex tasks repetitively.

(C) To specify a conditfon of Bal_Stock
between 25 and 50 the Criterion row in Query Design View should contain:
(a) >=25 and <=50
(b) >=50 and <=25
(c) >=25 and <=50 in the column BaL Stock
(d) Between 25 and 50 in the column Bal_Stock
Answer:
(c) >=25 and <=50 in the column BalStock

Explanation:
To specify multiple conditions with an AND condition all criteria must hold To join criteria for a single field with AND, type them into the Criteria line of the grid with AND between them. The above query will show records with values less than or equal to 50 as well as those greater than or equal to 25 in column BalStock.

(D) In the office of a finance company there are 7 computers. They all are connected to a network. These computers act as
server as per the need. Which type of network is established there?
(a) Peer-to-peer network
(b) Client Server Network
(c) Common Network
(d) Metropolitan Area Network
Answer:
(a) Peer-to-peer network

Explanation:
A Peer-to-peer network is created when two or more PCs are connected and share resources without going through a separate server computer. The computers in this network work independently and can switch role as and when required.

(E) Forms shows ………………….. records at a time.
(a) 1
(b) 2
(c) 3
(d) As many as you want.
Answer:
(a) 1

Explanation:
A form in database can display only one record at a time. They can display fields from multiple tables.

(F) State whether true or false.
In Calc, a sheet can be added only from Insert menu.
(a) True
(b) False
Answer:
(b) False

Explanation:
In Calc a sheet can be added by three different methods

Click Insert → Sheet Or
Right click on tab and select Insert Sheet, Or
Click on empty space at the end of Sheet tabs.

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 innovation as the characteristic of an Entrepreneur. [2]
Answer:
The production of any product should be according the needs of customers, which keeps on changing from time to time. Thus an entrepreneur has to be innovative. An entrepreneur always strives to fulfill the demands or needs of the customers by exploring new products, ideas and innovative creations.

Question 7.
What does ‘S’ stands for in SMART goals? Explain. [2]
Answer:
In SMART, ‘S’ stands for specific. It means that goals should be well defined, clear and unambiguous. It should clearly specify what is to be achieved and accomplished. The specific goals have greater chance of being achieved. To make a goal specific, The six “W” questions must be taken into consideration:

What: What do I want to accomplish?
Who: Who is involved to achieve goal?
When: When should the goal be achieved?
Why: Why do I want to achieve the goal?
Where: Where is this goal to be achieved?
Which: Which are the requirements to achieve the goal?

Question 8.
How can you manage emotional intelligence? [2]
Answer:
Emotional intelligence is managed by following the three steps:

Understand your emotions: This is done by observing oneself behaviour and by working on things that needs to be changed.
Rationalise: One s behaviour should be rationalised. One should take decisions reasonably.
Practice to keep oneself calm: Keeping the body and mind calm can be practised by yoga and meditation.

Question 9.
How does an entrepreneur benefit a society? [2]
Answer:
Entrepreneurs can change the way of living and work. Their ventures not only create jobs but also conditions,, for making a wealthy society. Given below are some of the contributions that entrepreneurs make for the society:

Entrepreneurship creates jobs.
They use their creativity and finances to introduce innovative ideas and technologies.
It helps in raising the standards of living by uplifting the earning power of people.
Successful entrepreneurs set up a role model and inspire many more for entrepreneurship. Thus, the cycle of economic upliftment continues.
Entrepreneurs invest in community projects and social causes like public health and education etc.

Question 10.
Write the steps that takes place when starting a computer. [2]
Answer:
After you switch ON the Power button, following steps are performed by the computer:
1. POST (Power On Self Test) starts- It is an operation initiated by the computer after it is turned ON but before the operating system is loaded into memory.

2. Operating system starts: After performing POST, the computer starts the process of booting up the operating system.

3. Welcome Screen appears: After the booting process is complete, the monitor shows the Welcome screen of the operating system in your computer.

4. Login screen appears: The login screen asks for the user name or ID and its password to login into the computer.

5. Desktop appears: After entering the correct ID and password, computer displays the desktop of the operating system and allows the user To work on the computer.

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

Question 11.
Explain the meaning of hierarchy of headings. [2]
Answer:
Headings are very important in any document. Headings organise the document and increase its readability. A document may have headings and its sub headings or a sub- sub heading i.e., a document can have various levels of headings called heading hierarchy. This hierarchy of headings specify the relationship between main heading and sub headings. It also describes the importance of information written under different levels of headings.

Question 12.
Why multiple sheets are used in a workbook? [2]
Answer:
In every spreadsheet, by default a workbook consists of at least one worksheet. You can add new worksheets in the same workbook. Multiple worksheets are required when you are working on large amount of data. Multiple worksheets help in organising your workbook and make it easier to find data.

Question 13.
Write some of the advantages of databases. [2]
Answer:
Advantages of databases are as follows:

Databases reduce data redundancy i.e. duplication of data.
It controls data inconsistency which means multiple mismatching copies of same data.
It facilitates sharing of data.
It ensures that the data stored should follow the applicable standards.
It ensures data security and privacy.

Question 14.
Define the following terms: [2]
(a) Web client
(b) web portal
Answer:
(A) Web Client – A web client is a program on the client side of the network. It requests and uses services provided by a web server. A web browser is an example of web client.
(B) Web Portal – A web portal is a specially designed website that provides information from the diverse sources such as email, online forums, search engines etc. MSN, Yahoo, India times are some examples of web portals.

Question 15.
List some of the disadvantages of blogs. [2]
Answer:
Disadvantages of blog are as follows:

Information given in personal blogs may be biased or inaccurate.
Blogs can be time consuming.
The comments written on blogs may be rude or inaccurate.
Whatever is published in blog is available to all.

Question 16.
Differentiate between goal seek and solver. [2]
Answer:

Goal Seek	Solver
Goal seek is used on single variable.	Solver can solve equations that use multiple variables.
It allows to vary the values only in one cell.	It allows values to vary in 200 cells.

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

Question 17.
Shanaya is a teacher in a school. She use to create marks lists of all the students in her diary. But this time she wants to create the marks lists in a spreadsheet. [4]
(A) How can Spreadsheet help her? Enlist any two points.
Answer:

It provides functions, which can be used to create formulas to perform complex calculations on data.
It has Macros, for recording and executing repetitive tasks.

(B) List any two disadvantages of Spreadsheet
Answer:

Spreadsheets are customisable so they are not user friendly and secure. Anyone can share the worksheet by sending a simple mail to any other person.
Data visualisation is difficult especially when there is large number of records then scrolling up and down makes the working diffcult and time consuming.

(C) She wants to rename the sheets with class name on them. Give her the easiest option to rename the sheets.
Answer:
To rename a sheet double click on the sheet tab and replace the existing name.

(D) She started teaching one more class. How can she add one more sheet for her new class?
Answer:
To add one more sheet right click on the sheet tab and click on Insert Sheet from the pop-up menu.

Question 18.
Priyanka works as an editor in leading magazine office. A magazine usually contains more than 100 pages. : to change the indentation and font size of all the paragraphs, fonts and colour of all headings in complete magazine. [4]
(A) Explain the feature of word processor she should use to get this work done easily?
Answer:
She can use Style feature of a word processor to make her work easy. A style is a named collection of various formatting options. It is a set of formats that can be applied to pages, text, frames and other elements of the document to quickly change their appearance.

(B) What are the various categories of this feature?
Answer:
Style can be categorised as follows:

Character style – formats a single character, word or a phrase.
Paragraph style – formats paragraphs including font type and size
Frame style – formats text and graphic frames
Page style – Organizes the structure of the document and adds page numbers
List syle – formats numbered or bulleted lists

It maintains consistent formatting in a document.
major formatting changes can be easily applied to multiple objects of same style.

(D) What is template?
Answer:
Template is a special type of document that contains formatting features like styles, headers, footers, etc. It is used to create new documents on the basis of these formatting features. It is like a blue print used to create new documents.

Question 19.
Following table displays a part of information of Menu items in a restaurant. [4]
Table: Items

Item-No	ItemName	Price
110	Cold Drink	45
112	Tea	25
115	Coffee	75

(A) Which of the given fields can be set as a Primary key and why?
Answer:
ItemNo field can be set as a primary key.
The reason is that the item number is a unique data for each item in the table and the items can be searched, viewed o the basis of the item number.

(B) Write SQL queries to:
(i) Display the price of Cold Drink
(ii) Add a new record with details (“116”, “Cold Coffee”, “115”)
(iii) Change the price of all items by adding Rs. 25 to each.
Answer:
SELECT price FROM items WHERE ItemName = “Cold Drink”
(i) INSERT INTO items VALUES (“116″, “Cold Coffee”, “115”)
(ii) UPDATE items SET price = price + 25
(iii) DELETE FROM items WHERE ItemName = “Tea”

Question 20.
Amit Kohli is an owner of a Call Center. He wants to store a huge amount of information about all his employees and clients in a database. [4]
(A) Which type of table organisation would be most suitable for this purpose?
Answer:
He can create either relational or Flat table.

(B) What is the difference between both types of data organisation?
Answer:
A flat file database stores data in a single table structure. A relational database uses multiple table structures, cross-referencing records between tables. Tables in both organise records in rows, with each column containing a single piece of data in the record.

It reduces data redundancy i.e. duplication of data.
It facilitates sharing of data among multiple users.

(D) Name the software used to work on databases.
Answer:
My SQL Oracle, MS SQL IBM DB2 are some of the commonly used database software.

Question 21.
Rajat and Saksham are friends from school time and they are still in contact with each other. They often message each other or chat whenever one finds the other one online. [4]
(A) What is instant messaging?
Answer:
Instant messaging technology is a type of online chat that allows its users to exchange messages over internet in real time. It is done with the help of some application programs specially developed for and known as instant messengers.

(B) Name of the commonly used applications used for instant messaging.
Answer:
Some popularly known instant messaging applications are Google Hangout, Snap Chat Skype, Facebook Messenger and WhatsApp.

It is available 24 × 7.
It can store and take backup of unlimited chat history.

(D) Write any one difference between email and instant messaging.
Answer:
In Instant messaging service the messages are delivered instantly and it needs the users to be logged on to the same server. In email the mails can be sent from one mail server to another and the users do not need to logged on same time. The mails are stored on the server and can be downloaded later.