Students can access the IT Sample Papers Class 10 CBSE with Solutions and marking scheme Set 3 will help students in understanding the difficulty level of the exam.

Computer IT Sample Paper Class 10 Set 3 with Solutions

Time: 2 hrs
Max. Marks: 50

General Instructions

  1. Please read the instructions carefully.
  2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
  3. Section A has Objective Type Questions whereas Section B contains Subjective Type Questions.
  4. 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.
  5. All questions of a particular section must be attempted in the correct order.
  6. Section A : Objective Type Questions (24 Marks)
    1. This section has 5 questions.
    2. Marks allotted are mentioned against each question/part.
    3. There is no negative marking.
    4. Do as per the instructions given.
  7. Section B : Subjective Type Questions (26 Marks)
    1. This section has 16 questions.
    2. A candidate has to do 10 questions.
    3. Do as per the instructions given.
    4. Marks allotted are mentioned against each question/part.

SECTION A: Objective Type Questions

1. Answer any 4 out of the given 6 questions based on Employability Skills (1 × 4 = 4)

(i) Karan lives at a hostel in Shimla. He calls his mother who lives in Delhi, to get her approval for the robotics class which is going to start in his school next week onwards. However, due to disruption in the phone line, his mother could not understand and reply to him. He got very upset. Which another medium can he use to get immediate approval of his mother?
(a) E-mail
(b) Letter
(c) Message through friend
(d) Fax
Answer:
(a) E-mail

(ii) Trisha is always tense during exam time. She is a sincere and studious student, but the thought of exams creates anxiety in her. Which stress management technique that you would suggest to help her?
(a) Yoga
(b) Exercise
(c) Vacation with family
(d) All of these
Answer:
(d) All of these

(iii) …. ability of a person to do the things that need to be done without someone or something influencing us.
(a) Self-motivation
(b) Self-discipline
(c) Self-awareness
(d) Self-regulation
Answer:
(a) Self-motivation

(iv) According to the concept of sustainable development, the environment and development are issues.
(a) inseparable
(b) separate
(c) independent
(d) None of these
Answer:
(a) inseparable

(v) The cleaning of software installed in the computer cannot be achieved by
(a) disk cleanup
(b) backup
(c) cleaning CPU cabinet
(d) installing antivirus software
Answer:
(c) cleaning CPU cabinet

(vi) Entrepreneurship has a crucial role in the of the society.
(a) evolution
(b) planning
(c) functioning
(d) None of these
Answer:
(c) functioning

2. Answer any 5 out of the given 6 questions

(i) …… is not an instant messaging service.
(a) Skype
(b) Yahoo! Messenger
(c) Firefox
(d) Whatsapp
Answer:
(c) Firefox

(ii) …… is the process of emptying a place in case of an emergency, disaster.
(a) Accident
(b) Evacuation
(c) Hazards
(d) Exiting
Answer:
(b) Evacuation

(iii) Richard needs to set up a network for his office where he wants to save all the data in a centralized system and other computers will take the services from the centralized system. Which architecture will be the best suitable for him?
(a) Peer-to-Peer
(b) Client-Server
(c) Point-to-Point
(d) Ring
Answer:
(b) Client-Server

(iv) A …… is a device that converts digital computer signals into a form (analog signals) that can travel over phone lines and vice-versa.
(a) repeater
(b) switch
(c) router
(d) modem
Answer:
(d) modem

(v) ….. is specifically designed to minimize or maximize the result according to a set of rules that you define in a spreadsheet.
(a) Goal Seek
(b) Scenario
(c) Solver
(d) Subtotal
Answer:
(c) Solver

(vi) ……. refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point.
(a) Alignment
(b) Footer
(c) Margin
(d) Headings
Answer:
(a) Alignment

3. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) Krishna wants to make a flowchart for his programs in a Word document. Which option should he use to accomplish this task efficiently?
(a) Drawing / Shapes
(b) Symbols
(c) Pictures
(d) All of these
Answer:
(a) Drawing / Shapes

(ii) Fatima has inserted a picture in a document. But she wants to cut-off a part of the picture. Which option she should use to accomplish the task?
(a) Cut
(b) Copy
(c) Crop
(d) Layout
Answer:
(c) Crop

(iii) The intersection point between a row and column is called ….
(a) row
(b) column
(c) table
(d) cell
Answer:
(d) cell

(iv) Amrita is celebrating her 14th birthday. She wants to invite her friends and family members to the party. Which feature will she use to send the same invite to many people with different addresses without typing it again and again?
(a) Mail Merge
(b) Letter Wizard
(c) Document Type
(d) None of these
Answer:
(a) Mail Merge

(v) A …… is a model that you use to create other documents.
(a) Styles
(b) Template
(c) Wizard
(d) Sample
Answer:
(b) Template

(vi) Formulas in a spreadsheet must begin with a ….. sign.
(a) $
(b) @
(c) #
(d) =
Answer:
(d) =

4. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) …… is a tool to test “what-if” questions.
(a) Scenario
(b) Solver
(c) Macro
(d) Average
Answer:
(a) Scenario

(ii) Rohit scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculate the score in IT he needs to achieve 85 percent in aggregate. Suggest him the suitable option out of the following to do so.
(a) Macro
(b) Solver
(c) Goal Seek
(d) Sub Total
Answer:
(c) Goal Seek

(iii) …. can be used in a spreadsheet software to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to websites.
(a) Illustrations
(b) Hyperlinks
(c) Links
(d) Filter
Answer:
(b) Hyperlinks

(iv) ….. uses the keyboard as a pointing device instead of a mouse.
(a) Mouse key
(b) Toggle key
(c) Filter key
(d) Sticky key
Answer:
(a) Mouse key

(v) Krish and Kritika have done a survey of age wise literacy rates of their locality as a school project, which they have created in a spreadsheet. They both want to work simultaneously to complete it on time. Which option they should use to access the same spreadsheet to speed up their work.
(a) Consolidate worksheet
(b) Shared worksheet
(c) Link worksheet
(d) Lock worksheet
Answer:
(b) Shared worksheet

(vi) database is a type of database that stores data in several tables.
(a) Flat
(b) Relational
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Relational

5. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) In database …. helps us to retrieve the filtered data based upon some conditions.
(a) forms
(b) reports
(c) queries
(d) table
Answer:
(c) queries

(ii) A ….. is one which connects computers and devices in a limited geographical area such as home, school, computer laboratory, office building, or closely positioned group of buildings.
(a) LAN
(b) WAN
(c) MAN
(d) PAN
Answer:
(a) LAN

(iii) Rudrakshh wants that the name column of a table must not be left blank. Help him to identify the field property for this purpose.
(a) Length
(b) Default
(c) Entry required
(d) Format
Answer:
(b) Default

(iv) …. can be set for a field if the user doesn’t provide any value while entering the values in the table.
(a) Required
(b) Default
(c) Primary key
(d) Format
Answer:
(b) Default

(v) Aadya wants to create a connection between two or more tables. Suggest her the option to accomplish the task.
(a) Table
(b) Form
(c) Relationships
(d) Sorting
Answer:
(c) Relationships

(vi) data type takes the values in the form of 0 and 1 in the database.
(a) Integer
(b) Text
(c) Boolean
(d) Memo
Answer:
(c) Boolean

SECTION B: Subjective Type Questions

Answer any 3 out of the given 5 questions based on Employability Skills. Answer each question in 20-30 words (2 × 3 = 6)

Question 6.
Communication skills are very important for any business. Explain any two elements of a communication process.
Answer:

  1. Sender The person beginning the communication.
  2. Message The information that the sender wants to convey.

Queries 7.
Mention any two misconceptions about the entrepreneurship.
Answer:

  1. The misconception is that every business idea needs to be unique or special
  2. A misconception we have is that only a person having a big business is an entrepreneur.

Question 8.
Goal setting is a very essential factor in your personal life. List all the SMART methods to set the goals. Explain A’ in brief.
Answer:
SMART goals are:
S – Specific
M – Measurable
A – Achievable
R – Realistic
T – Time bound
Achievable breaking down big goals into smaller parts will make the goal achievable.

Question 9.
What are the measures to increase the performance of a computer system?
Answer:
The performance of a computer system can be increased by removing any extra files such as temporary files and images. We can use some disk cleaner software, which helps us clean up the unnecessay files.

Question 10.
How can an individual contribute to Sustainable Development Goals?
Answer:
Sustainable development can actually happen only when each one of us works towards it. One has to become a responsible environment citizen who can protect the environment through our own efforts, who can help others to get quality education by reducing inequalities in the society etc.

Answer any 4 out of the given 6 questions in 20-30 words each (2 × 4 = 8)

Question 11.
Differentiate between relative and absolute hyperlinks with the help of an example.
Answer:
Differences between relative hyperlink and absolute hyperlink are as follows:
• Relative hyperlink/URL The relative URL, on the other hand, does not use the full web address and only contains the location following the domain. It assumes that the link you add is on the same site and is part of the same root domain. The relative path starts with the forward slash and leads the browser to stay within the current site.
e.g. <a href=“/xyz.html””>
• Absolute hyperlink/URL An absolute URL is the entire address from the protocol to the domain name and includes the location within your websites in your folder system names within the URL. Basically, it is the full URL of the page that you link to.
e.g. <a href=//www.example.com/xyz.html””>

Question 12.
What is the utility of text wrapping in a document?
Answer:
Text wrapping refers to the relation of graphics to the surrounding text, which may wrap around the graphics on one or both sides, be overprinted behind or in front of the graphics, as separate paragraph or character.

Question 13.
What is the use of macros in a spreadsheet?
Answer:
Macros help in saving time in cases when the same set of tasks are to be dew repeatedly like formatting or applying a similar formula in a similar range of data. It can be used to name and record a set of actions.

Question 14.
Write any two advantages of online shopping.
Answer:

  1. Customers can purchase items from the comfort of their own homes or work place.
  2. Customers do not have to stand in queues in cash counters to pay for the products that have been purchased by them.

Question 15.
Differentiate between primary key and foreign key.
Answer:

Primary key Foreign key
It is used to uniquely identify data in the table. It is used to maintain relationship between tables.
Two or more rows can’t have same primary key. It can carry duplicate value for a foreign key attribute.

Question 16.
Define the following Hotspots:

  1. WiMAX
  2. Wi-Fi

Answer:

  1. WiMAX It is a wireless communications standard designed for creating Metropolitan Area Networks (MANs). It is similar to the wi-fi standard, but supports for greater range of coverage.
  2. Wi-FI It stands for wireless fidelity. It is a wireless networking technology that allows devices such as computers, mobile devices and other equipment to interface with the Internet.

Answer any 3 out of the given 5 questions in 50-80 words each (4 × 3 = 12)

Question 17.
Elaborate four different types of styles which can be provided in a Word Processor.
Answer:
Different types of styles in Word Processor are:

  1. Paragraph The paragraph style contains both paragraph and text formatting attributes: indents, tabs, font, text size.
  2. Character The character style formats only characters, not paragraph.
  3. Linked The linked style is a combination style that can be applied to both paragraphs and individual characters. The difference depends on which text is selected, when you apply the style.
  4. Table The table style is applied to tables, to add lines and shading to the table cells contents.
  5. List The list style is customized for presenting lists of information. The styles can include bullets, numbers, indentation and other formats typical for the parts of a document that present lists of information.

Question 18.
Define the following:

  1. Subtotals
  2. Consolidating Data

Answer:

  1. Subtotals This function returns the subtotal of the number in a column in a list or database. The subtotal function is a built-in function in Excel, that is categorized as a Math function. It can be used as a worksheet function in Excel. As a worksheet function, the SUBTOTAL function can be entered as part of a formula in a cell of a worksheet.
  2. Consolidating data It provides a graphical interface for copying data from one range of cells to another, then running one of a dozen functions on the data. During consolidating, the contents of cells from several streets can be combined in one place.

Question 19.
What precautions must be taken to improve online security?
Answer:

  1. Antivirus and antispyware programs offer real time protection monitoring your computer for any
    changes by malware software.
  2. Use strong passwords a combination of alphanumeric and special characters could be used for creating a password that is not a easy to crack or guessed by other users.
  3. Secure transactions because information, such as credit card details or personal information is sent over the network.
  4. Use encryption software to protect your data from unauthorized users.

Question 20.
What is DBMS? Explain any two advantages of DBMS.
Answer:
Database Management System (DBMS) It is a collection of programs that enables users to create, maintain database and control all the access to the database. It is a computer based record keeping system. The primary goal of the DBMS is to provide an environment that is convenient and efficient for user to retrieve and store information. It acts as an interface between the application program and the data stored in the database. DBMS is a software package that manages database, e.g. MySQL, INGRES, MS-ACCESS etc.
DBMS is actually a tool that is used to perform any kind of operation on data in database. It also maintains data consistency in case of multiple users. The purpose of a DBMS is to bridge the gap between information and data.
Advantages of DBMS are as follows:

  1. The DBMS helps create an environment in which end users have better access to more and better managed data.
  2. Such access makes it possible for end users to respond quickly to changes in their environment.

Question 21.
(i) The structure of a table “ITEM” is given below. Suggest suitable data type and size of each column.

Column Name Data Type Size
Itemno …….. …………
Iname …….. …………
Price …….. …………
Quantity …….. …………

(ii) Consider the following table “ITEM”.

Itemno Iname Price Quantity
11 Soap 40 80
22 Powder 80 80
33 Face Cream 250 25
44 Shampoo 120 100
55 Soap Box 20 50

Write queries to
(a) Display the total amount of each item. The amount must be calculated as the Price multiplied by Quantity for each item.
(b) Display the details of items whose Price is less than 50.
Answer:

Column Name

 Data Type

Size
Itemno Integer 2
Iname Varchar 15
Price Integer 3
Quantity Integer 3