Students must start practicing the questions from CBSE Sample Papers for Class 10 Information Technology with Solutions Set 7 are designed as per the revised syllabus.
CBSE Sample Papers for Class 10 IT Set 7 with Solutions
Max. Time : 2 Hours
Max. Marks: 50
Section A
Objective Type Questions
Question 1.
Answer any 4 out of the given 6 questions on Employability Skills. (1 × 4 = 4 Marks)
(i) ……………… are a group of words that work together to communicate an element of speech.
(a) Sentence
(b) Pronoun
(c) Noun
(d) Phrases
Answer:
(d) Phrases
(ii) ………………create entirely new industries and opportunities for employment.
(a) Business
(b) Entrepreneur
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Entrepreneur
(iii) Having conscious knowledge of your own self, capabilities, feelings and one’s own character is called as ………………
(a) Self Management
(b) Self Regulation
(c) Self-Awareness
(d) All of these
Answer:
(c) Self-awareness
(iv) In ……………….. communication the person interacts through visual AIDS, posters, logos, hoardings, etc. making communication impressive as pictures communicate faster than words.
(a) Written
(b) Oral
(c) Visual
(d) Non Verbal
Answer:
(c) Visual
(v) An economy is called green economy when it is based on the principles of …………..
Answer:
Sustainability
(vi) ………….. stress if continues for a long duration turns into chronic stress.
(a) Bad
(b) Good
(c) Eustress
(d) None of these
Answer:
(a) Bad
Question 2.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) Autosum automatically selects the values around the cells …………….
(a) Horizontally
(h) Vertically
(c) Both (a) and (b)
(d) None of these
Answer:
(c) Both (a) and (b)
(ii) ………………. technology does not use any wire for data transfer between two or more device.
(a) Wired
(b) Wireless
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Wireless
(iii) ………………. formatting shows how individual characters in the document should look in appearance.
(a) Character
(b) Paragraph
(c) Table
(d) Cell
Answer:
(a) Character
(iv) ………….. are programs that are created on your local computer when you visit websites.
(a) Accounts
(b) Spam
(c) Cookies
(d) None of these
Answer:
(c) Cookies
(v) The first label on the page is termed as the …………….. and all other labels are linked to it.
(a) Master
(b) Main
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Master
(vi) Scenarios is one of the tool to test ………………. questions.
(a) Record Changes
(b) if else
(c) What if
(d) None of these
Answer:
(c) What if
Question 3.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) A set of rules or guidelines required for computers to communicate with each other over a network is called …………….
(a) Protocols
(b) Index
(c) Symbols
(d) Impress
Answer:
(a) Protocols
(ii) A ……………. file database can be okay if the database is only a small one with a few fields.
(a) Multiple
(b) Single
(c) Relational
(d) Flat
Answer:
(d) Flat
(iii) …………… helps to move, rotate or resize multiple objects in a presentation.
(a) Grouping
(b) Charts
(c) Table
(d) Movie clip
Answer:
(a) Grouping
(iv) The speed of network is measured in ………………..
(a) Mbps
(b) Kbps
(c) Gbps
(d) Tbps
Answer:
(a) Mbps
(v) ……………. keys stops the computer from processing brief for repeated keystrokes.
Answer:
Sticky
(vi) In RDBS data is stored in the form of ……………….
(a) Graphs
(b) Files
(c) Tables
(d) None of these
Answer:
(c) Tables
Question 4.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) The intersection point between a row and a column is called a ………………
(a) Range.
(b) Cell.
(c) Active Cell
(d) None of these.
Answer:
(b) Cell
(ii) To combine two or more cells …………… option is used
(a) Add Cell
(b) Split Cell
(c) Combine cell
(d) Merge cell
Answer:
(d) Merge cell
(iii) ………….. is one of the functions available in the spreadsheet to perform addition of selected numbers in the sheet.
(a) Add
(b) Sum
(c) Total
(d) None of these
Answer:
(b) Sum
(iv) Which of the following key identifies a record uniquely in a table.
(a) Foreign
(b) Primary
(c) Unique
(d) Candidate
Answer:
(b) Primary
(v) A column is a group of cells that run from ……………..
(a) Bottom
(b) Right side to left side
(c) Left side to right side
(d) Top to bottom.
Answer:
(d) Top to bottom.
(vi) Solver amounts to a more elaborate form of …………..
(a) Consolidation
(b) Macro
(c) Goal Seek
(d) None of these
Answer:
(c) Goal Seek
Question 5.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) Templates can be created in different ways like …………..
(a) From a document.
(b) Using a wizard.
(c) Both (a) and (b)
(d) None of these
Answer:
(c) Both (a) & (b)
(ii) Styles help to improve consistency in a ……………
Answer:
document
(iii) SUBTOTAL is a function listed under ……………… category.
(a) Mathematical
(b) The groups
(c) The columns
(d) None of these
Answer:
(a) Mathematical
(iv) Which website is used for online booking of train tickets?
(a) Amazon
(b) IRCTC
(c) Flipkart
(d) Trivago
Answer:
(b) IRCTC
(v) A form provides ………… to the user for working with the table.
(a) Graphical Interface
(b) Direct way of storing information
(c) Style
(d) None of these
Answer:
(a) Graphical Interface
(vi) WWW stand for …………….
(a) Wide Wide Web
(b) Whole World Web
(c) World Wide Web
(d) Web with Wi-Fi
Answer:
(c) World Wide Web
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.
Why is stress management vital?
Answer:
Being well versed with stress coping techniques, help people lead a healthy and happy life. Properly managed stress prevents mental and physical illness. Stress management is vital because it leads to following benefits
(1) Improves mood.
(2) Boosts immune system.
(3) Promotes long life.
(4) Leads to physical strength, which is vital for goal achievements.
(5) Complete mental and physical engagement for task accomplishment.
Question 7.
Explain four types of sentences in English. [CBSE 2020]
Answer:
Based on functionality sentences can be classified mainly into four types.
(1) Declarative Sentence : Declarative sentence is an assertive sentence which simply expresses an opinion/feeling or makes a statement, or describes things. This type of sentence ends with a period or a full stop(.). For example, I am very happy today.
(2) Imperative Sentence : An imperative sentence makes a request or gives a command. Imperative sentences usually end with a period or full stop. For example, please sit down.
(3) Interrogative Sentence : An interrogative sentence asks a question. Interrogative sentences always end with a note of interrogation mark (?) For example, where are you going?
(4) Exclamatory Sentence : An exclamatory sentence expresses overflow of emotions. These emotions can be happiness, wonder, sorry, anger, etc. For example, what a day it was!
Question 8.
Explain any 2 Qualities of an entrepreneur.
Answer:
An entrepreneur must have the following qualities:-
(1) Hard working – An entrepreneur must be very hard working to become successful. Successful entrepreneurs adapt to the habit of hard work from a very early stage. The ability of working hard makes it possible to move them to word the achievement of their objectives.
(2) Optimistic – Successful entrepreneur should have a positive approach student life as a whole. They should not be afraid of any adverse situation in business and should always think optimistically about the future of the business in order to succeed.
Question 9.
What is the importance of Sustainable Development?
Answer:
The importance of Sustainable Development are
(1) Fulfill human needs – With increase in population and thereby increase in the requirements of human beings, it becomes difficult to cater to human needs. The government along with its citizens should implement policies which emphasizes minimal use of renewable resources but at the same time using resources in a manner fulfills essential human needs. In addition the natural resources will be conserved for future generations also.
(2) Agricultural requirements – Population explosion also increases pressure on agriculture to meet increased demand of food. Sustainable development focuses on sustainable agricultural methods such as crop rotation, drip irrigation, organic farming promote high yields while maintaining the integrity of the soil for increased agricultural production.
Question 10.
Write any two general precautions for cleaning the computer components.
Answer:
As we know that computer is an electronic device we must take some precautions while cleaning it and its components which are as under-
(1) Turn off and unplug the power cables of your computer before starting the cleaning operation.
(2) Do not use any kind of spray cleaning fluid directly on the components of the computer instead first spray the liquid on the cloth and then wipe the components.
Answer any 4 out of the given 6 questions in 20-30 words each (2 × 4 = 8 Marks)
Question 11.
Give two terms that are associated with websites.
Answer:
The two terms associated with websites are-
(1) World Wide Web – W3 also known as web is a system of interlinked hypertext documents accessed via the internet. WWW contains millions of websites that provide information in the form of text, animations, pictures and videos.
(2) Web Browser – Web browser is a software, used to access information stored on web servers. It is used to view websites and acts as an interface between the user and the WWW.
Question 12.
List any three advantages of a DBMS?
Answer:
The three advantages of a DBMS are as under-
(1) Database and its components can be created and modified as per requirement
(2) Powerful queries to retrieve data depending on the condition given by the user.
(3) Facilitates sharing of data, i.e., different users can use the same database to extract data according to their needs.
Question 13.
Write down the steps to create a folder in C drive with your name?
Answer:
The steps to create a new folder on C Drive are-
(1) Double click the computer icon available on your desktop.
(2) Select the C:\ drive, in which you want to create a new folder.
(3) A Window will open up showing files and folders in Local Disk C:\
(4) Click new folder on the toolbar.
(5) A new folder is created with the name New Folder highlighted.
(6) Type a name for the folder and press enter key or click anywhere in the window.
Question 14.
Explain two types of languages used for creating and manipulating the data in databases. [CBSE 2020]
Answer:
The two types of languages used for creating and manipulating the data in databases are-
(1) Data Manipulation Language (DML) – Data Manipulation Language (DML) is a language that enables a user to access or manipulate data in a database. The DML commands help users to query and manipulate data in the existing database.
(2) Data Manipulation Language (DML) is a language that enables a user to access or manipulate data in a database. The DML commands help users to query and manipulate data in the existing database. For, eg., SELECT.
Question 15.
State the purpose of creating a blog?
Answer:
A blog can be used to convey messages about personal events, worldwide happenings, announcements, news, reviews etc. The topic of the blog can be anything from personal to ‘ professional. A blogger can frequently update information related to his or her interest or activities, express his ideas or opinions or share his knowledge by writing articles on specific topics.
Question 16.
How is paragraph formatting different from character formatting?
Answer:
Paragraph styles controls the total appearance of the paragraph such as text alignment, tabs, line spacing, borders and even character formatting. Whereas character styles affects only the selected text within a paragraph, font and size of the text, or Bold, Italic and Underline formats.
Answer any 3 out of the given 5 questions in 50-80 words each (4 × 3 = 12 Marks)
Question 17.
Write down the process for transferring data on the internet [CBSE 2019]
Answer:
The data to be sent over the network is first broken up into small same sized pieces called packets. Each and every packet along with data also contains sender’s address, receiver’s address and the packet number.
Each packet is sent from one computer to another, until it reaches its destination. Each computer on the network checks for the address and decides whether to keep it or let it go to other computer. All the packets of the data may not take the same route to reach the destination computer.
At the destination, the packets are examined and assembled so that it is in a readable form. If any packet is missing or damaged a message is sent to the sender asking for the packet to be resent. This process continues until all packets have been received intact.
Once all the packets are received intact, the packets are reassembled into their original form and becomes readable to the receiver. To your surprise, this all is done within seconds.
Question 18.
Explain Client-Server architecture and Peer-to-Peer Architecture. [CBSE 2020]
Answer:
(1) Peer to Peer (P2P) architecture – Network in which all the computers have an equal status is called peer to peer network. Generally, in such a network, each terminal has an equally competent CPU.
(2) Client Server (C/S) architecture – Networks in which there is a powerful Central computer with extra resources then the computers that are connected in the network. In such a network, the main Central computer is known as server and other computers connected to it in a network are called clients or nodes for workstations. Here the server is responsible for providing all the information and resources to the client as per the request made by the clients.
Question 19.
Write the SQL command to create a table EMPLOYEE with the given structure. [CBSE 2020]
EMPID | EMPNAME | DESIGN | SALARY |
Char(4) | Varchar(15) | Varchar(20) | Decimal |
(a) What is a primary key?
(b) Categorize the following commands as DDL and DML: SELECT, ALTER, INSERT, DROP
Answer:
(A) CREATE TABLE EMPLOYEE (EMPID CHAR(4), EMPNAME VARCHAR(15), DESIGN VARCHAR(20), SALARY DECIMAL)
(a) Primary Key uniquely identifies each row in a table.
(b) DDL commands – ALTER, DROP DML commands – SELECT, INSERT
Question 20.
Given the following Spreadsheet, Write the appropriate Formula/ Expression/ Function to be used for the following : –
(a) Write formula to calculate the Total Qty(C4:C7)) in cell C8.
(b) Write the feature used for arranging the Price from Highest to Lowest.
(c) To find the Maximum Price to be written in Cell DIO.
(d) To find the Average Qty to be written in cell C9.
(e) Write formula to calculate the Total Amount in cell E8.
Answer:
(a) =SUM(C4:C7)
(b) Sort (c) =MAX(D4:D7)
(d) =AVERAGE(C4:C7)
(e) For calculating Total price of all the products first we need to calculate Qty*Price per piece in E column using the formula =C4*D4. And this formula is to be applied for all the 5 fruits. Than to find out the total amount we will use the following formula in cell E8. =SUM(E4:E7)
Question 21.
Explain any four data types in OpenOffice base.
Answer:
The four data types available in OpenOffice base are:-
(a) Numeric Type – Numeric data types are used for describing numeric values for the field used in the table of a database. Numeric data types in a database can be used for storing information such as roll number, mobile number, etc.
(b) Alphanumeric Types – This data type allows to store alphanumeric values that is characters as well as numbers and special symbols.
(c) Binary Types – Binary data types are used for storing data in binary form. This data type can be used in a database for storing images, music files etc. In general, file of any format can be stored in the database using this data type.
(d) Date/Time – Date/Time data types are used for storing date and time values in the field who’s data type has been defined as Date/Time. This data type can be used in a database for storing information such as date of birth, date of admission etc.