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

Computer IT Sample Paper Class 10 Set 2 with Solutions

Time: 2 hrs
Maximum 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) _________ is the means by which message is sent.
(a) Data
(b) Channel
(c) Receiver
(d) None of these
Answer:
(b) Channel

(ii) _______ stress is a result of unexpressed worries.
(a) Internal
(b) Environmental
(c) External
(d) Survival
Answer:
(a) Internal

You are advised to attempt this sample paper without referring the answers given here. However, cross check your answers once you complete the paper.

(iii) ______ can be used for adding pictures in the presentation.
(a) Gallery
(b) Slide
(c) ClipArt Gallery
(d) None of these
Answer:
(c) ClipArt Gallery

(iv) An entrepreneur must form contacts with the ______ to analyse the market.
(a) Planning
(b) Competitors
(c) Self-confident
(d) None of these
Answer:
(b) competitors

(v) ______ brings about changes in people’s knowledge, attitude and skills.
(a) Sustainable development
(b) Natural resources
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Sustainable development

(vi) ______ plays a major role in reaction to stress.
(a) Personality
(b) Positive attitude
(c) Behaviour
(d) None of these
Answer:
(a) Personality

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

(i) Page margins are the ________
(a) cell
(b) horizontal space
(c) blank spaces
(d) Vertical space
Answer:
(c) blank spaces

(ii) _______ is the rectangular area of the document window, where you can type the text.
(a) Work area
(b) Notes area
(c) Data area
(d) None of these
Answer:
(a) Work area

(iii) The default data type for a field is _______
(a) char
(b) int
(c) text
(d) None of these
Answer:
(c) text

(iv) The term _______ is derived from the words interconnection and networks.
(a) connection
(b) Internet
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Internet

(v) A/An _______ that identifies a specific computer on the Internet.
(a) user name
(b) domain name
(c) E-mail
(d) None of these
Answer:
(b) domain name

(vi) AutoSum option is available in ________
(a) Home tab
(b) View tab
(c) Insert tab
(d) Layout tab
Answer:
(a) Home tab

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

(i) The status of your document like current page number and number of pages are given by ______
(a) formatting toolbar
(b) status bar
(c) standard toolbar
(d) None of these
Answer:
(b) status bar

(ii) The first network was ______
(a) ARPANET
(b) Internet
(c)NSFnet
(d) NET
Answer:
(a) ARPANET

(iii) _______ object includes effects such as shadows, outlines, colors, gradients and 3D effects.
(a) WordArt
(b) ClipArt
(c) DataArt
(d) Clip
Answer:
(b) ClipArt

(iv) A worksheet is a _______
(a) collection of workbooks
(b) processing software
(c) combination of rows and columns
(d) None of these
Answer:
(c) combination of rows and columns

(v) ________ is a set of programs that lies between the stored data and the users of database.
(a) Software
(b) Hardware
(c) Network
(d) All of these
Answer:
(a) Software

(vi) Satellite which are orbiting around the ______, provide necessary links for telephone and television service.
(a) wire
(b) earth
(c) station
(d) All of these
Answer:
(b) earth

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

(i) Linked data is stored in the ________
(a) destination file
(b) web file
(c) source file
(d) domain file
Answer:
(c) source file

(ii) _______ shortcut key is used to enter current time in a cell.
(a) Ctrl + Shift +;
(b) Ctrl + Shift + :
(c) Shift + Ctrl + :
(d) Ctrl + ;
Answer:
(a) Ctrl + Shift + ;

(iii) Field is the individual sub component of one _______
(a) record
(b) column
(c) data
(d) None of these
Answer:
(a) record

(iv) In www, a client is called _______
(a) web server
(b) webpage
(c) web browser
(d) None of these
Answer:
(c) web browser

(v) Duplication of data is known as _______
(a) data security
(b) data incomplete
(c) data redundancy
(d) None of these
Answer:
(c) data redundancy

(iv) Internet is a network of _______
(a) networks
(b) value
(c) data
(d) pages
Answer:
(a) networks

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

(i) The workbook views options allow user to view or see the _______ differently.
(a) data
(b) cell
(c) spreadsheet
(d) None of these
Answer:
(c) spreadsheet

(ii) Template includes _______ text that is surrounded by brackets.
(a) margin
(b) placeholder
(c) data source
(d) track changes
Answer:
(b) placeholder

(iii) For what, memo data type is used?
(a) To add table
(b) To store objects created in other programs
(c) For long text entries
(d) For short text entries
Answer:
(c) For long text entries

(iv) A router passes data packets from one network to another network based on their ______ not MAC address.
(a) IP address
(b) URL
(c) Web address
(d) None of these
Answer:
(a) IP address

(v) _______ is the main region of the chart in which your data is plotted.
(a) Chart area
(b) Plot area
(c) Data label
(d) Data series
Answer:
(b) Plot area

(vi) The LAN stands for _______
(a) Large Area Network
(b) Local Area Network
(c) Local Area Networking
(d) None of these
Answer:
(b) Local Area Network

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.
What do you mean by verbal communication?
Answer:
Verbal communication means communication through spoken oral and written words. It implies use of words which make up a language. It is the ability to communicate using words in understandable language i.e. English, Hindi, French, Urdu etc. Language play a significant role in verbal communication. The effectiveness of the verbal communication depends on the tone of the speaker, clarity of speech, volume, speed, body language and the quality of words used in conversation.

Question 7.
Explain the term fatigue related stress.
Answer:
Fatigue related kind of stress builds up over a long time like by working too long or too hard at our job, school or home. It can also be caused by exercising too much or too long.

If you do not know how to manage your time well or how to take time out for rest and relaxation, you will become a victim of fatigue related stress. This can be one of the hardest kinds of stresses to avoid because many people feel that it is out of their control.

Question 8.
What is Auto Correct feature in document? How to use it?
Answer:
AutoCorrect is an automatic data validation function commonly found in Word processors and text editing interfaces. It is a useful tool in Word for applying specific formatting or spelling for certain phrases often in your text. This feature will quickly fix the mis-spelling words and punctuation marks. To use AutoCorrect, follow the below steps:

  • Click on Review tab -> Proofing group.
  • Click on Spelling & Grammar option. Spelling and Grammar dialog box will appear.
  • When a possible spelling error is encountered, the spell check dialog opens and Word processor offers some suggested corrections.
  • Select any one of the suggested word and click on Auto Correct button.

Question 9.
What are the disadvantages of entrepreneurship?
Answer:
Some of the disadvantages of entrepreneurship are as follows :

  • Huge Amount of Time You have to dedicate a huge amount of time to your own business. Entrepreneurship is not easy and for it to be successful, you have to take a level of time commitment.
  • Risk An entrepreneurship involves high risk of loss. If the business fails then it will wipe away all the personal savings.
  • Hard Work An entrepreneur has to work very hard to make the new business very successful.
  • Uncertain Income There is no regular or fixed income available to an entrepreneur. So, there is uncertain kind of income received by an entrepreneur.

Question 10.
Describe any two problems related to sustainable development.
Answer:
Two problems related to sustainable development are as follows:

  • Poor management of natural resources combined with growing economic activities will continue to pose serious challenges to environment.
  • The most significant environmental problems are associated with resources that are renewable such as air and water. They have finite capacity to assimilate emissions and wastes but if pollution exceeds this capacity ecosystem can deteriorate rapidly.

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

Question 11.
Write the steps to insert text wrapping.
Answer:
To insert text wrapping, follow the given steps:

  • Click where you want to text wrapping.
  • Click Page Layout tab -> Page Setup group -4 Breaks. A drop-down menu will appear.
  • Select Text Wrapping from Page Breaks section.

Question 12.
What do you mean by conditional formatting in Excel?
Answer:
Conditional formatting is a feature in Excel and other spreadsheet programs that allows to change the appearance (font, color, border, shading) of a cell, depending on certain conditions. When a conditional format is applied on a cell, it means the formatting of the cell is based on a condition.

Question 13.
Describe the term wireless fidelity.
Answer:
Wireless Fidelity (Wi-Fi) is a universal wireless networking technology that utilises radio frequencies to transfer data. Wi-Fi allows high speed Internet connections without the use of cables or wires. Wi-Fi networks can be designed for private access within a home or business. It can be used for public Internet access at ‘hotspots’ that offers Wi-Fi access such as restaurants, coffee shops, hotels, airports, convention centres and city parks.

Question 14.
How to remove header or footer from the document?
Answer:
Steps to remove header or footer are as follows:

  • Click Insert tab.
  • Select Header or Footer option from the Header & Footer group.
  • Click Remove Header or Remove Footer.
    Now, header or footer gets removed from the document.

Question 15.
How to apply a custom view in workbook?
Answer:
To apply a custom view, follow the given steps:

  • On the View tab, in the Workbook Views group, select the Custom Views.
  • The Custom Views dialog box will appear, in the Views box, select the name of the view that you want to apply and then click Show button.

Question 16.
Define the following:
(i) Delete command
(ii) DCL command
Answer:
(i) Delete Command To discard unwanted data from a database, the delete command is used,

(ii) DCL Command These commands are used to assign security levels in database which involves multiple user setups. They are used to grant defined role and access privileges to the users.

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

Question 17.
Write the steps to wrap text around a picture in a document.
Answer:
Steps to wrap text around a picture in a document are as follows:

  • Select the picture.
  • Select the Picture Tools Format tab. (This tab appears only after insertion of a picture).
  • Click the Text Wrapping in the Arrange group.
  • Select any one option from the drop-down list. In this example, we will select Tight.
  • Move the picture around to see how the text wraps for each setting.
  • The Position button has pre-defined text wrapping settings. The Position button is placed to the left of the Text Wrapping button.
  • Click the Position button and a drop-down list of Text Wrapping options will appear. Move your cursor over the various text wrapping styles. A live preview of text wrapping will appear in the document.
  • If you cannot get your text wrapped the way you wish, select More Layout Options… from the Position menu. You can make more precise changes from the Advanced Layout dialog box that appears.

Question 18.
Define the following:
(i) Web address
(ii) Benefit of networking
Answer:
(i) Web is a collection of documents (web pages) stored on computers around the world. Each
web page has an address describing where it can be found. This address is known as Web Address or URL (Uniform Resource Locator).
A web address identifies the location of a specific web page on the Internet, such as http://www.1earnyoga.com
On the web, web addresses are called URLs. It is the web address for a website or a web page. The URL specifies the internet address of a file stored on a host computer connected to the internet.

(ii) Computer network is very useful in modern environment, so some of the benefits of networking are discussed here:

  • File Sharing Networking of computers helps the users to share data files.
  • Hardware Sharing Users can share devices such as printers, scanners, CD-ROM drives, hard drives, etc.
  • Application Sharing Applications can be shared over the network and this allows to implement client/server applications.
  • User Communication This allows users to communicate using e-mail, newsgroups, video conferencing within the network.
  • Access to Remote Database By networking, we are able to access to the remote database. It is easy for any person using his PC to make reservations for aeroplanes, trains, hotels, etc., anywhere in the world with instant confirmation within the network.

Question 19.
How to save the workbook in MS-Excel?
Answer:
Steps to save the workbook are as follows:

  • Click at Microsoft Office button.
  • Do one of the following:
  • Choose Save As, if you would like to save the file for the first time or save the file by different name.
  • Choose Save, if the file has already been named.
  • Press Ctrl+S from keyboard.
  • Save As dialog box will appear.
  • Type the file name in File name box and choose Excel Workbook from the Save As type list box.
  • Click at Save button.
    The default extension of excel workbook is .xlsx.

Question 20.
How to open existing table in a database? Give two ways to do this.
Answer:
Existing table can be opened by two ways which are as follows:

  1. In Datasheet View To open a table in a Datasheet View, follow these steps:
    • Find a table in the All Access Objects list (the left hand window).
    • Right click on a table and select Datasheet View. Datasheet View represents the data in a table.

or
Select Home tab and click the View drop-down arrow from Views and select the Datasheet View.

2. In Design View To open a table in a Design View, follow these steps:

  • Find a table in the All Access Objects list (the left hand window).
  • Right click on the table and select Design View. Design View represents the structure of the table.

or
Select the Home tab and click the View drop-down arrow from Views group and select the Design View.

Question 21.
(i) Create a table SHOP with the following fields:

Column Name Data Type
Code Varchar(5)
Name Char(50)
Type Varchar(3)
Cost Int
Margin Float
Qty Int

(ii) Consider the following table EmployeeSalary and write the queries (a) and (b).
Table: Employee Salary

LastName FirstName Dept PayrollNumber Salary (?) Job Title
Shen James Finance A621 19500 Payroll Clerk
Gupta Shruthi Finance M502 35000 Accountant
Bedi Reeta Fluman Resource M421 18500 Secretary
Walker Tia Sales W815 24000 Sales Represen-tative
Shafia Ahmed Factory H219 39000 Factory Manager
Mittal Chavi Purchasing M134 20000 Purchasing Clerk

(a) Write a command to update the salary of the employee to 25000, whose job title is secretary.
(b) List all data of table EmployeeSalary.
Answer:
(i) CREATE TABLE SHOP (Code Varchar(5), Name Char(50), Type Varchar(3), Cost Int,
Margin Float, Qty Int);

(ii) (a) UPDATE EmployeeSalary SET Salary = 25000 WHERE JobTitle = ‘Secretary’;
(b) SELECT * FROM EmployeeSalary;