Practicing the CBSE Sample Papers for Class 10 Information Technology Set 5 allows you to get rid of exam fear and be confident to appear for the exam.
CBSE Sample Papers for Class 10 Information Technology Set 5 with Solutions
Time: 2 hrs
Max. Marks: 50
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.
- Marks 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
(Objective Type Questions)
Question 1.
Answer any 4 out of the given 6 questions based on Employability Skills [1 × 4 = 4 Marks]
(i) ………….. is essential to complete the cycle of communication. [1]
(a) Encoding
(b) Decoding
(c) Feedback
(d) Sender
Answer:
(c) Feedback
(ii) The good stress is called ………… [1]
(a) eustress
(b) emstress
(c) Both (a) and (b)
(d) None of these
Answer:
(a) eustress
(iii) Windows 10 is an operating system developed by …………. [1]
(a) Microsoft™
(b) IBM
(c) Samsung
(d) Sony
Answer:
(a) Microsoft™
(iv) How can an entrepreneur get the work done from his/her team? [1]
(a) By creating a spirit of teamwork
(b) By motivation
(c) Using harsh words and actions
(d) Both (a) and (b)
Answer:
(d) Both (a) and (b)
(v) Sustainable development requires the judicious use of …………… [1]
(a) resources
(b) verbal resources
(c) natural resources
(d) None of these
Answer:
(c) natural resources
(vi) If sustainable development is neglected then [1]
(a) we shall have a safe and secure environment.
(b) it will destroy ecology and environment endangering the survival of future generation.
(c) mankind will continue to live and prosper.
(d) All of the above
Answer:
(b) it will destroy ecology and environment endangering the survival of future generation.
Question 2.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) After adding the data source, you need to specify the salutation. The selected salutation will be displayed in the pane. [1]
(a) salutation
(b) preview
(c) display
(d) None of these
Answer:
(b) preview
(ii) Cell referencing can be done by using a ……… as well ……….. [1]
(a) keyboard, windows menu
(b) keyboard, mouse
(c) windows menu, mouse
(d) None of these
Answer:
(b) keyboard, mouse
(iii) Full form of OLE is …………… [1]
(a) Object Linked and Embedded
(b) Option Linking and Embedding
(c) Open Linking and Embedding
(d) Object Linking and Embedding
Answer:
(d) Object Linking and Embedding
(iv) We can rename a new sheet in Calc. [1]
(a) After inserting a new sheet
(b) While inserting a new sheet
(c) Both (a) and (b)
(d) None of these
Answer:
(c) Both (a) and (b)
(v) To start the macro recorder, which of the following command is used? [11
(a) Tools → Macros →Record Macro
(b) Tools → Rccord → Record Macro
(c) Data → Macros → Record
(d) None of these
Answer:
(a) Tools → Macros →Record Macro
(vi) In case, another user is trying to save the shared worksheet and resolve conflicts, you see a message that the shared spreadsheet file is due to a merge in progress. [1]
(a) stopped
(b) locked
(c) Both (a) and (b)
(d) None of these
Answer:
(b) locked
Question 3.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) In a document, you can insert ………….. [1]
(a) Pictures
(b) ClipArts
(c) Shapes
(d) All of these
Answer:
(d) All of these
(ii) Which of the following is not the main building block of a database? [1]
(a) Lists
(b) Queries
(c) Reports
(d) Forms
Answer:
(a) Lists
(iii) ……………….. is a computer program that provides services to other computer programs. [1]
(a) Server
(b) Client
(c) Network
(d) None of these
Answer:
(a) Server
(iv) State True or False. [1]
ClipArt object includes effects such as shadows, outlines, colors, gradients and 3D effects.
(a) True
(b) False
Answer:
(b) False
(v) In order to group sheets, while holding the …………… key, click on the Sheets tab you want to group. [1]
(a) Alt
(b) Shift
(c) Ctrl
(d) Tab
Answer:
(c) Ctrl
(vi) If a table has to be created which tab and group should be used? [1]
(a) Insert tab → Tables group
(b) Home tab → Tables group
(c) Design tab →Tables group
(d) None of these
Answer:
(c) Design tab →Tables group
4. Answer any 5 out of the given 6 questions
(i) ……………… is a network architecture which separates the client from the server. [1]
(a) Client Server Network
(b) Peer – to – Peer Network
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Client Server Network
(ii) In the hierarchy of headings, the lower – level headings pertain t0 ……………. and …………… [1]
(a) section, sub-sections
(b) headings, sub-headings
(c) Both (a) and (b)
(d) None of these
Answer:
(a) section, sub-sections
(iii) TCL commands are used to manage ………… in database. [1]
(a) data
(b) values
(c) transactions
(d) None of these
Answer:
(c) transactions
(iv) …………… is used to begin text-to-speech utility that reads what is displayed on the screen. [1]
(a) Start Narrator
(b) Web page
(c) Website
(d) None of these
Answer:
(a) Start Narrator
(v) ………….. provides the physical connection between the network and computer workstation. [1]
(a) LIC
(b)NC
(c) NIC
(d) None of these
Answer:
(c) NIC
(vi) In Calc, you can insert the data from different databases and other data sources. One such format is [1]
(a) odd
(b) .dbms
(c) .odb
(d) .ods
Answer:
(c) .odb
Question 5.
Answer any 5 out of the given 6 questions [ 1 × 5 = 5 Marks]
(i) ………….. leads to data inconsistency.
(a) Data integrity
(b) Data sharing
(c) Data redundancy
(d) Data recovery
Answer:
(c) Data redundancy
(ii) Blog Desk is an offline blog editor which is used for ………….. operating system. [1]
(a) Linux
(b) Unix
(c) Windows
(d) None of these
Answer:
(c) Windows
(iii) To create the link from one document to another, both the documents should be [1]
(a) open
(b) closed
(c) Both (a) and (b)
(d) None of these
Answer:
(a) open
(iv) Which of the following is not true?
(a) More than one people can work simultaneously on a shared worksheet.
(b) Shared spreadsheet can be modified by other users.
(c) You cannot make changes in a sheet, if it is not shared with you.
(d) Other users can save the shared file while you resolving the conflicts.
Answer:
(d) Other users can save the shared file while you resolving the conflicts.
(v) Suhani has written an article on ‘Sustainable Development Goals’ in about 1000 words. She has given appropriate headings and subheadings in it. She has also created a table of contents using the hierarchy of headings. She also wants to customize the look of the table of contents by adding an image in its background. Which of the following option under the background tab she should select to add an image?
(a) Image
(b) Picture
(c) Bitmap
(d) Art
Answer:
(c) Bitmap
(vi) A web page is located using a
(a) Universal Record Linking
(b) Universal Record Locator
(c) Uniform Resource Locator
(d) Uniformly Reachable Links
Answer:
(c) Uniform Resource Locator
Section-B
(Subjective Type Questions)
Answer-any 3 out of the given 5 questions on Employability skills. [2 × 3 = 6 Marks]
Answer each question in 20-30 words.
Question 6.
Describe any two types of barriers to communication in one sentence each with examples. [2]
Answer:
The two types of barriers to communication are :
1. Physical These are environmental factors which prevent or reduce the sending and receiving of communications, such as physical distance, distracting noises and similar interferences.
2. Personal These cause a psychological distance between people similar to the physical distance, as they include judgements, emotions and social values of people, which change or distort the communication.
Queriess 7.
Why is self-regulation important in life? [2]
Answer:
Self-regulation is important in life due to the following reasons:
- Self-regulation allows you to keep a tab on your own emotions.
- Self-regulation enables to develop the idea about ‘what is appropriate behaviour’ and ‘what is inappropriate behaviour’ in a given social condition.
- It helps in controlling negative impulses and reciprocate emotions for actualising set goals.
Question 8.
Explain any two items of the Windows desktop. [2]
Answer:
Any two items of the Windows desktop are:
• Taskbar
It is present in the bottom area of the desktop. It contains Start button, Cortana, Task View button, Quick Launch Bar and Notification Area.
• Icons
The small pictures on the desktop which represent various programs/applications are called icons.
Question 9.
Explain the role and significance of entrepreneurs. [2]
Answer:
The role and significance of entrepreneurs are discussed below:
• Organiser of Society’s Productive Resources An entrepreneur is the organise of society’s productive resources. He is the person who assembles the unused natural, physical and human resources of the society, combines them properly, establishes effective coordination between them and makes the economic activities dynamic.
• Helpful in Capital Formation An entrepreneur is helpful in capital formation i;. we know that increase in the rate of capital formation is quite essential for the economic development ol any country.
• Increase in Employment Opportunities An entrepreneur creates maximum employment opportunities in the society by way of establishing new industries, developing and expanding the existing industries and by undertaking innovative activities.
Question 10.
Why is there a need for sustainable development? Give reasons. [2]
Answer:
Sustainable development is necessary for the maintenance of the environment.
There is a need of sustainable development because of the following reasons:
- Sustainable development teaches people to make use of means and resources for the maximum benefit without wastage.
- Sustainable development brings about changes in people’s knowledge, attitude and skill.
- Sustainable development aims at achieving the goal of economic and social development without destroying the Earth’s means and resources.
Answer any 4 out of the given 6 questions in 20-30 words each. [2 × 4 = 8 Marks]
Question 11.
What are objects in a word processing software? [2]
Answer:
The word processor object allows different formatting within the same object. However, word processor objects are printed as an image, so they require quite a bit more resources than a normal single or multiline text objects. Word processing objects includes text, graphical and embedded objects.
Question 12.
How to insert the copyright symbol into a Word document? [2]
Answer:
- Place the cursor in the location where you want the symbol to appear.
- On the Insert menu select Special Character.
- In the dialog that appears, choose Symbol from the Font list. The copyright symbol is available in a Serif font (character 212) or in a San-Serif font (character 228)….
- Click OK.
Question 13.
What is the use of Auto Sum in spreadsheet? [2]
Answer:
When working with large spreadsheets containing a considerable number of rows or columns with data, it is often needed autosum with a quick click of a menu or button instead of manually typing the SUM function. OpenOffice spreadsheet program Calc has this feature.
- Open any Calc workbook with numbers and data, or open your workbook.
- Select the cell where you would like to put the autosum of your data.
- Click on the sigma icon beside the formula bar and click Sum from the dropdown menu. You can see the Sum is calculated automatically.
Question 14.
A table named School (containing data of students of the entire school) is created, where each record consists of several fields including AdmissionNo (Admission Number), RollNo (Roll Number), Name. Which field out of these three should be set as the primary key and why? [2]
Answer:
AdmissionNo should be set as the primary key because admission numbers are unique for each and every student of the school, which is not possible in the case of RollNo and Name.
Question 15.
List any two advantages associated with networking. [2]
Answer:
Two advantages of networking are as follows :
- User Communication Network allows users to communicate using emails, social networking sites, video conferencing, etc.
- File Sharing By using networking data or information can be shared or transferred from one computer to another.
Question 16.
Explain the purpose of a blog. [2]
Answer:
The main purpose of a blog is to convey messages about events, announcements, need, review etc. Blogs are usually managed using a web browser and this requires active internet connection.
Answer any 3 out of the given 5 questions in 50-80 words each. [4 × 3 = 12 Marks]
Question 17.
Explain the Scenario tool of a spreadsheet software. [4]
Answer:
A Scenario is a set of values that Calc saves for a group of cells. Whenever we run a scenario Calc automatically substitutes the saved cell values into a connected formula to give us an output. By having different scenarios for a same group of cells we can get different results from the formula and compare these results to know which is the most suitable set of values for us. For example, if you wanted to calculate the effect of different interest rates on a car loan, you could add a scenario for each interest rate, and quickly view the results.
This will help you to easily find out the most desirable rate of interest for availing the loan. Clearly a Scenario is a tool to test “what-if’ questions (What happens if I replace THIS value by THAT value • •. ). Each scenario has a name, and can be edited and formatted separately. You can easily switch between different scenarios for a group of cells by using the scenario drop down list or scenario navigator.
Question 18.
Ojas had prepared a Table of Contents of the project work he had done in a word processor application. [4]
(a) Tell him the different steps to update the TOC
(b) Tell him the different steps to delete the TOC
Answer:
Writer does not update the table of contents automatically, so after any changes to the headings, you must update it manually.
1. To update a table of contents when changes are made to the document:
(i) Right-click anywhere in the TOC.
(ii) From the pop-up menu, choose Update Index/Table. Writer updates the table of contents to reflect the changes in the document.
You can also update the index from the Navigator by right-clicking on Indexes > Table of Contents 1 and choosing Index > Update from the pop-up menu.
2. To delete the table of contents from a document:
(i) Right-click anywhere in the TOC.
(ii) From the pop-up menu, choose Delete Index/Table. Writer deletes the table of contents.
Question 19.
Consider the following table: SummerCamp. [4]
Table: SummerCamp
| Child ID | First Name | Last Name | DOB | Gender | Group |
| 109 | Vedansh | Gupta | 30/06/10 | M | 2 A |
| 214 | Mack | Tyagi | 09/12/08 | M | 1 B |
| 115 | Aditi | Thakur | 13/04/09 | F | 1 A |
| 108 | Vikrant | Chauhan | 02/02/09 | M | 2 A |
| 141 | Swati | Saini | 06/05/10 | F | 2 B |
| 233 | Vishakha | Tyagi | 01/08/10 | F | 3 A |
| 274 | Madhur | Gupta | 06/03/10 | M | 3 B |
(i) How many fields and records are there in the table SummerCamp?
(ii) Write SQL queries for the following:
(a) Display all the record of table SummerCamp whose DOB is between 02/02/09 and 06/03/10.
(b) Display all the records having Gender F.
(c) Display all the records according to the First Name.
Answer:
(i) There are 6 fields and 7 records in the table SummerCamp.
(ii) (a) SELECT * FROM SummerCamp WHERE DOB BETWEEN 02/02/09 AND 06/03/10;
(b) SELECT * FROM SummerCamp WHERE Gender=’F’;
(c) SELECT * FROM SummerCamp ORDER BY First Name;
Question 20.
Lavish wants to know the following points about database. [4]
(a) Definition of a Database Management System.
(b) Any two advantages of using database management system for school.
Answer:
(a) Database Management System (DBMS) is a collection of programs that enable users to create, maintain database
and control all the access to the database. The primary goal of the DBMS is to provide an environment that is both convenient and efficient for user to retrieve and store information.
(b) The advantages of using DBMS for school are as follows:
(i) In school, DBMS is used to store the data about t udents, teachers and any other related things at a centralised location.
(ii) It provides security to the personal information of the school, stored in it.
Question 21.
Manya is studying about the different topologies available in networking. Tell her the difference between Star topology and Bus topology with the help of a suitable diagram. [4]
Answer:
| Star topology | Bus topology |
| (i) All the nodes are directly connected with the central node or server. | There is a single length of transmission medium, on which various nodes are attached and the server can be anywhere in the transmission cable. |
| (ii) Faults can be easily detected. | Faults cannot be easily detected. |
(iii) It has fast transmission speed. |
It becomes slow as the number of nodes increases. |