Students must start practicing the questions from CBSE Sample Papers for Class 10 Information Technology with Solutions Set 2 are designed as per the revised syllabus.
CBSE Sample Papers for Class 10 IT Set 2 with Solutions
Max. Time : 2 Hours
Max. Marks: 50
Section A
Objective Type Questions
Q.1. Answer any 4 out of the given 6 questions on Employability Skills. (1 × 4 = 4 Marks)
(i) 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
(ii) …………….. refers to systematic efforts to direct one’s thought feeling actions towards the attainment of one’s goals.
(a) Self motivation
(b) Self regulation
(c) Innovative
(d) None of these
Answer:
(b) Self regulation
(iii) …………….. are the programs that display unwanted ads to your computer in pop up form.
(a) Spam
(b) Adware
(c) Malware
(d) None of these
Answer:
(b) Adware
(iv) The right bottom of the desktop contains ……………..
(a) Notification area
(b) Start button
(c) Icons
(d) Taskbar
Answer:
(a) Notification area
(v) …………….. stress if continues for a long duration turns into chronic disease.
(a) Bad
(b) Good
(c) Both
(d) None of these
Answer:
(a) Bad
(vi) …………….. ability of a person to do things that need to be done without someone or something influencing us.
(a) Self-Discipline
(b) Self Awareness
(c) Self-motivation
(d) Self Regulation
Answer:
(c) Self-motivation
Question 2.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(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 the place in case of an emergency.
(a) Disaster
(b) Evacuation
(c) Accident
(d) Hazard
Answer:
(b) Evacuation
(iii) …………….. 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
(iv) In which of the following architecture the whole data is saved at centralised system and other computers will take the services from the centralised system.
(a) Client server
(b) Peer to peer
(c) Point to point
(d) Ring
Answer:
(a) Client server
(v) Which of the following is not an offline blog editor?
(a) Qumana
(b) Word press
(c) Blog Desk
(d) None of these
Answer:
(b) Word press
(vi) A/An …………….. software is a program that detects prevents from malicious programs such as viruses.
(a) Anti-virus
(b) Disc cleanup
(c) Spam
(d) Worm
Answer:
(a) Anti-virus
Question 3.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) The shortcut key to print a document is ……………..
(a) Ctrl + C
(b) Ctrl + V
(c) Ctrl + P
(d) None of these
Answer:
(c) Ctrl + P
(ii) …………….. refers to the relation of images to the surrounded text which may wrap around the graphic on one or both sides, be over printed behind or in front of the graphic or treat the graphic as a separate paragraph or character.
(a) Text wrapping
(b) Text alignment
(c) Text arrangement
(d) None of these
Answer:
(a) Text wrapping
(iii) Which menu carries Group > Group option in Writer?
(a) Edit
(b) Tools
(c) Format
(d) None of these
Answer:
(c) Format
(iv) A …………….. is a intersection point between row and column.
(a) Row
(b) Column
(c) Table
(d) Cell
Answer:
(d) Cell
(v) A Formula in a spreadsheet must begin with …………….. sign.
(a) $
(b) @
(c) #
(d) =
Answer:
(d) =
(vi) Krishna wants to make a flowchart for his programs in a document. Which option should he use to accomplish the task efficiently?
(a) Drawing/shapes
(b) Symbols
(c) Pictures
(d) All of these.
Answer:
(a) Drawing/shapes
Question 4.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) Cells hold the individual elements as ……………..
(a) Text
(b) Numbers
(c) Formulas
(d) All of these
Answer:
(d) All of these
(ii) …………….. is a mathematical expression to perform calculations on data in cells.
(a) Goal Seek
(b) Macro
(c) Formula
(d) None of these
Answer:
(c) Formula
(iii) …………….. tab is used to create a scenario.
(a) Tools
(b) View
(c) Format
(d) None of the above
Answer:
(a) Tools
(iv) To perform an online transaction you need is a ……………..
(a) Web browser
(b) Internet connection
(c) both (a) and (b)
(d) None of the above
Answer:
(c) both (a) and (b)
(v) …………….. is a set of data values of one type arranged in a vertical manner.
(a) Row
(b) Column
(c) Cell
(d) Table
Answer:
(b) Column
(vi) Types of DML commands are ……………..
(a) Procedural
(b) Non-Procedural
(c) Both (a) and (b)
(d) None of the above
Answer:
(c) Both (a) and (b)
Question 5.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) If a field uniquely identifies each row in a table, it is a
(a) Primary Key
(b) Composite key
(c) Foreign Key
(d) All of these
Answer:
(a) Primary Key
(ii) LAN stands for
(a) Low Area Network
(b) Local Area Network
(c) Level Area Network
(d) None of these
Answer:
(b) Local Area Network
(iii) What is the output of the query: select 1 * 4?
(a) 2
(b) 5
(c) 4
(d) None of these
Answer:
(c) 4
(iv) …………… are dedicated computers that store the actual databases and run only the DBMS related software.
(a) Data
(b) Web Server
(c) Spread sheet
(d) Database Servers
Answer:
(d) Database Servers
(v) How much space does the INTEGER data type hold in Base?
(a) 2 Bytes
(b) 4 Bytes
(c) 8 Bytes
(d) 10 Bytes
Answer:
(b) 4 Bytes
(vi) A column within a table that contains only one type of information is called
(a) Field
(b) Record
(c) Cells
(d) Both (a) and (b)
Answer:
(a) Field
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.
Communication skills are very important for any business. Explain any two elements of a communication process.
Answer:
The various elements of a communication cycle are:
Sender : the person beginning the communication.
Message : the information that the sender wants to convey.
Channel : the means by which the information is sent.
Receiver : the person to whom the message is sent.
Feedback : the receiver’s acknowledgement and response to the message.
Question 7.
Goal Setting is very essential factor in your personal life.List all the SMART methods to set a goal.
Answer:
Goal setting is a very essential factor in your life. The SMART GOALS are-
S – Specific
M – Measurable
A – Achievable (Breaking down big goals into smaller parts will make the goal achievable)
R – Realistic
T – Time bound
Question 8.
How can individual contribute to Sustainable Develoment Goals?
Answer:
Sustainable development can 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 efforts, who can help others to get quality education, by reducing inequalities in the society etc.
Question 9.
What is self motivation? How can you motivate yourself?
Answer:
Self motivation is a factor that develops an inner urge to do something, achieve goals without any external pressure in an individual. It is an inbuilt life skill and may be developed further as per requirement of an individual. Self motivation can be developed by-
(a) Being positive and having positive attitude towards life.
(b) Looking into past experiences where you have achieved success
Question 10.
How can we overcome barriers of cultural influence?
Answer:
Cultural barriers arise due to ethnic, religious and social differences which often create misunderstandings during the process of communication. These differences can also affect ones perception and create confusion while understanding the message. For overcoming cultural barriers both the parties involved in the communication must get familiar to each other’s culture and respect their culture, religion and ethics.
Answer any 4 out of the given 6 questions in 20-30 words each (2 × 4 = 8 Marks)
Question 11.
Differentiate between absolute and relative hyperlink.
Answer:
An absolute hyperlink will stop working only if the target is moved. A relative hyperlink will stop working only if the source and target locations change relative to each other. Suppose, if you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will not break a link.
Question 12.
What is online shopping? Explain its benefits.
Answer:
Online shopping is a form of e-commerce (Electronic commerce) where customers can buy or sell goods over the internet. Customers need to have an active internet connection for giving goods or services offered by seller, customers can pay online using a credit/ debit card or by internet banking. These transactions are called online transactions. Online shopping could be useful in situations when-
(1) Customer does not have sufficient time to visit the store.
(2) Visiting a store is more expensive than purchasing a product online.
(3) A product or service that is not available in the local market but is available online.
Question 13.
Following are the descriptions of some features in LibreOfficesuite, identify them and give their names-
(a) It is a predesigned document that you can use to create new documents with the same formatting effects.
(b) It is a tool that you can use to produce invitation letters to be sent to people altogether.
Answer:
(a) Document Template
(b) Mail Merge
Question 14.
Write short notes on-
(a) Web server (b) Dial-up
Answer:
(a) Web Server – It is a computer that stores websites and their related files and other computers connected to it through internet can access these files.
(b) Dial-up – This kind of internet access uses the facilities of the Public Switched Telephone Network (PSTN) to establish a connection to an ISP for accessing internet. Dial up connections are extremely slow so hardly used now a days.
Question 15.
State the preventions a workstation should provide to the employees.
Answer:
The workstation should-
(1) Provide sufficient space for the user to alter position comfortably.
(2) Provide adequate lighting.
(3) Have windows fitted with adjustable covering to alter the sunlight level.
(4) Be spacious enough when workstation is shared by more than one person.
Question 16.
How to insert an image in the file?
Answer:
To insert an image in the document follow the given steps-
- Click in the document where you want the image to appear.
- Choose Insert > Image from the Menu Bar.
- In the Insert Image dialogue box as shown in the figure given below, navigate to the file to be inserted then select it and click on Open.
- At the bottom of the dialogue box there is an option called Link. Select Link for inserting the image into your document as a link.
Answer any 3 out of the given 5 questions in 50-80 words each (4 × 3 = 12 Marks)
Question 17.
Divya was asked by her Class teacher, to make course for the subject Chemistry. For this she needs to insert a list of chapters done. Which feature she must use for doing this? Also write the steps to do this.
Answer:
She can use Table feature for making the course of the subject Chemistry. The steps to insert a table are as follows –
- Position the insertion point where you want the table to appear.
- Choose Table > Insert Table option. This will display the Insert Table dialogue box.
- Enter the number of rows and columns for the table in the Number of Columns and the Number of Rows boxes.
- Click on Insert, the table will be created with the columns and rows specified.
Question 18.
Define the following terms-
(a) Goal Seek (b) Scenarios
Answer:
(a) Goal Seek – Goal seek is one of the powerful feature of LibreOffice Calc. It is a feature which reverses the usual order for a formula that is we run a formula to get the result with certain arguments whereas with Goal seek we work with the output to see what values were used to get the result.
(b) Scenarios – Scenarios is a set of values that can be used within your calculations. You can assign a name to every scenario in your sheet. Several scenarios can be defined in a single sheet with different names and different cell values.
Scenarios are basically a tool to test “what if’ questions and a defined scenario is named, can be edited and formatted separately. Once defined, it can be chosen from a dropdown list in the Navigator or the Title bar of the Scenarios.
Question 19.
What is DBMS? Explain any two advantages of DBMS.
Answer:
DBMS – Database Management System is a computerized record keeping system that enables to create, store, modify, and extract information from a database. A database is a structured collection of data stored in computer memory using tables, records and fields so that users with the help of various applications can easily add, delete, edit, search and manipulate the data.
Advantages of DBMS are –
- Database and its components can be created and modified as per requirement.
- Minimal data repetition to increase data inconsistency.
Question 20.
Given the following Spreadsheet, Write the appropriate Formula/Expression/Function to be used for (a) to (d) :
(a) To calculate the Total Rainfall in cell F2
(b) To calculate the Average Rainfall in cell G2
(c) To find the Maximum Rainfall in the month of July in Cell C7
(d) To find the Minimum Rainfall in the month of Aug in Cell D7
Answer:
(a) =SUM(C2:E2)
(b) =AVERAGE(C2:E2)
(c) =MAX(C2:C6)
(d) =MIN(D2:D6)
Question 21.
Write the steps to share the spreadsheet.
Answer:
The steps to share the spreadsheet are as follows-
Open a spreadsheet to be shared and place it on network location so that multiple users can use it simultaneously.
- Click on Tools > Share Spreadsheet in the menu bar.
- A dialogue box will appear as shown in the figure.
- Check the option “Share this spreadsheet with other users” available at the top of the dialogue box.
- Click OK.