Students must start practicing the questions from CBSE Sample Papers for Class 10 Information Technology with Solutions Set 9 are designed as per the revised syllabus.
CBSE Sample Papers for Class 10 IT Set 9 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) …………. apple a day keeps a doctor away. (A/An/The)
Answer:
An
(ii) Which of the following is not the step taken by an entrepreneur to build up an organization?
(a) Hiring Employees
(b) Organizing the factors of production
(c) Sourcing Finance
(d) None of these
Answer:
(d) None of these
(iii) Small pictures on the desktop are called …………
(a) Icons
(b) Wall paper
(c) Background
(d) None of these
Answer:
(a) Icons
(iv) Overgrazing may lead to ……………
(a) Deforestation
(b) Ecological imbalance
(c) Degradation of Lithosphere
(d) None of these
Answer:
(b) Ecological imbalance
(v) Working independently individuals become assets to ……………
(a) Organization
(b) Group
(c) Nation
(d) All of the above
Answer:
(d) All of these
(vi) ……………. are the activities which help in reducing the stress.
(a) Yoga
(b) Physical Exercise
(c) Healthy meals
(d) All of these
Answer:
(d) All of these
Question 2.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) Numbering styles apply …………….
(a) Similar alignment
(b) Numbering or bullet characters
(c) Fonts to numbered list
(d) All of these
Answer:
(b) Numbering or bullet characters
(ii) When you open a new spreadsheet, by default it has one sheet with the name as …………….
(a) New Sheet
(b) New workbook
(c) Sheet 1
(d) Sheet
Answer:
(c) Sheet 1
(iii) The ……………. is a type of network which spreads across a city.
(a) LAN
(b) MAN
(c) PAN
(d) WAN
Answer:
(b) MAN
(iv) Scenarios is one of the tool to test ……………. questions.
(a) Solver
(b) What-if
(c) Both (a) and (b)
(d) None of these
Answer:
(b) What-if
(v) “Worksheet can be added or removed as per requirement”. Choose the correct option.
(a) True
(b) False
(c) Can’t say
(d) None of these
Answer:
(a) True
(vi) The ……………. is an organisation which provides you with access to internet.
(a) ISP
(b) ASP
(c) TSP
(d) None of these
Answer:
(a) ISP
Question 3.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) The ……………. provides a convenient way to combine reusable objects.
(a) Combining
(b) Grouping
(c) Selecting
(d) None of these
Answer:
(b) Grouping
(ii) A ……………. is a graphical representation of data, in which the data is represented by symbols, such as bars.
(a) Chart
(b) Smart Art
(c) Shapes
(d) None of these
Answer:
(a) Chart
(iii) ……………. keys are also known as modifier keys.
(a) Shift
(b) Ctrl
(c) Alt
(d) All of the above
Answer:
(d) All of these
(iv) To enable Macro Recording feature go to Tools and then select …………….
(a) Macros
(b) Module
(c) Options
(d) Record Macro
Answer:
(d) Record Macro
(v) Symbol option is available under ……………. group in the Insert Tab in LibreOffice.
(a) Symbols
(b) Shape
(c) Media
(d) Illustrations
Answer:
(a) Symbols
(vi) The insert table option is in ……………. tab.
(a) Home
(b) Insert
(c) View
(d) Illustrations
Answer:
(b) Insert
Question 4.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) The ……………. style include margins, headers and footers, borders and background.
(a) Paragraph
(b) Page
(c) Table
(d) List
Answer:
(b) Page
(ii) Use the ……………. tab to format the entries in the table of content.
(a) Tools
(b) Entry
(c) Exit
(d) List
Answer:
(b) Entry
(iii) In which menu Goal Seek is available in LibreOffice Calc?
(a) Data
(b) Tools
(c) Window
(d) Sheet
Answer:
(b) Tools
(iv) Aksh have prepared 200 pages report and showed it to his senior. He suggested to replace the word ‘Board’ with the word ‘Board of Directors’. Suggest some features of Writer for doing this task.
Answer:
Find and Replace feature can be used to search and replace the text
(v) A ……………. database refers to the data file that contains records stored in a single file.
Answer:
Flat
(vi) MAN is a ……………. which spreads across a city.
Answer:
Network
Question 5.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) To combine two or more cells ……………. option is used.
(a) Merge Cells
(b) Split Cells
(c) Protect Cells
(d) None of these
Answer:
(a) Merge Cells
(ii) ……………. keys are also known as modifier keys.
(a) Shift
(b) Ctrl
(c) Alt
(d) All of these
Answer:
(d) All of these
(iii) ……………. menu has the Define Ranges option.
(a) Data
(b) Tools
(c) View
(d) None of these
Answer:
(a) Data
(iv) By adding a ……………. the argument of a formula can be changed quickly.
(a) Consolidate
(b) Scenario
(c) Macro
(d) None of these
Answer:
(b) Scenario
(v) The field which is designated as the Primary key of a table cannot have …………….
(a) Values
(b) Duplicate values
(c) Numbers
(d) Text
Answer:
(b) Duplicate values
(vi) A table is an arrangement of …………….
(a) Rows
(b) Columns
(c) Cells
(d) Both (a) and (b)
Answer:
(d) Both (a) and (b)
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.
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.
Question 7.
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¬Being positive and having positive attitude towards life.
Looking into past experiences where you have achieved success.
Question 8.
How does entrepreneurship help in promoting society growth?
Answer:
Entrepreneurship helps in promoting societal growth in the following manner-
- Increases economic growth
- Fosters creativity
- Stimulates innovation and efficiency
- Create jobs and gives employment opportunities
- Solves the problems of the society
- Encourages welfare of the society
- Fulfils ever growing and ever changing demands of the society
Question 9.
Enlist any two major causes of air pollution.
Answer:
Two major causes of air pollution are –
- Harmful gases emitted out mainly by factories and industries in the environment.
- The fumes generated because of burning of fossil fuels.
Question 10.
How human body does respond to a stressful situation.
Answer:
Stress refers to a physical mental or emotional strain or tension which is unavoidable part of one’s life. In fact, occasional and small amount of stress have a positive effect on one’s life. Such stress helps to stretch ourselves to a new level. Stress well-managed can help one view events and situations as challenges and contributes in the growth of an individual. But high levels of stress, over prolonged periods, needs to be managed. Unmanaged stress leads to anxiety and sorrow resulting in ill state of mental and physical health.
Answer any 4 out of the given 6 questions in 20-30 words each (2 × 4 = 8 Marks)
Question 11.
Differentiate between linking and embedding a document. Does embedding an object increase the size of the document? List any two websites that offer free clipart. [CBSE 2020]
Answer:
When the files are linked, then a change in the linked file gets updated in the destination file. In the case of embedding, changes in the embedded file do not propagate to the destination file. You need to manually make the changes in the destination file by double¬clicking the embedded file.
Yes embedding an object increases the size of the document.
Two websites that offer free clipart are-
- iCLIPART.com
- Openclipart.com
- GraphicsFactory.com
- Clker.com
Question 12.
What are electrical safety rules?
Answer:
The various Electrical Safety Rules are as under-
- Electrical equipments approved by a recognised organisation must only be used.
- Damage and hazardous electrical equipment should be immediately replaced.
- All old and workout and frayed switches and wires should be changed.
- Heat emanating equipment should be kept away from the electrical equipment.
- Take care that the outlets or circuits should not be overloaded.
Question 13.
Explain mail merge.
Answer:
Mail merge is a feature available within most data processing applications including writer. Mail merge enables users to send a similar letter for document to multiple recipients. Mail merge is basically a method of combining a list of recipients stored in a separate file called data source with a main document having common message to be sent all the recipients. Following are the steps involved in the process of mail merge- Creating a main document.
Creating the data source.
Merging the data source with main document.
Question 14.
What are document templates? State the purpose of using document template.
Answer:
A template is a model that is used to create documents. Templates can contain anything that regular document can contain, such as text, graphics a set of styles and user specified setup information like measurement units, language, the default printer, customized toolbar and menu bar.
All the documents in openoffice.org are based on templates. You can create a specific template for any document type like text, spreadsheet, drawing, presentation. If you do not specify template, when you create a new document, then that document is based on default template for that type of document. If you do not specify a template, the Writer uses the blank template for that type of document that is installed with OOo.
Question 15.
Explain the following with respect to Databases:
(a) Forms (b) Reports [CBSE 2020]
Answer:
(a) Form – A Form provides the user a systematic way of storing and modifying information into the database. It is a graphical interface that let users to view, enter and change data directly in the database objects like tables, views etc.
(b) Report – Report is a database object that helps to display the data in a summarised manner. In other words, it is used to generate the overall work outcome in a clear format.
Question 16.
What are the good practices for internet security?
Answer:
Good practices for internet security :
Do not share personal information:
Some websites require you to fill out forms containing field such as main gender wage email ID School college company ATC. Be cautious while filling out such forms the search and verify if it is a trustable website full stop your email id could be used by unauthorised users to send ID fake 100 unwanted emails to your friends or relatives by your name. Think twice or thrice before providing information to any website and decide if it is really necessary.
Keeping your username and password private:
Never save your username or password on your devices which are used in shared environment such as cyber cafe, offices, labs etc. Browsers can also save your personal data on the local computer that can be used by another person using the same computer
Registering with website:
Always read the privacy statement of policy whenever you register with outside, the statement of policy will include information about how the website use personal data.
Backup your data – always keep copy of your personal as well as important data in additional media such as CDs pen drive etc. This could be helpful in situation when there is a loss or corruption of data. Keep this copy of data away from unauthorised users.
Answer any 3 out of the given 5 questions in 50-80 words each (4 × 3 = 12 Marks)
Question 17.
What is a template? How can you create a template?
Answer:
A template is a model that is used to create documents. The steps for creating templates in a document are –
Open a new or existing document of the type you want to make into a template i.e. text document, spreadsheet, drawing, or presentation.
Add the content and style that you want.
From the Main Menu select File > Templates > Save as Template. The Save As Template dialogue box opens up.
In the Template Name field, type the name for the template.
Choose the Category to which you want to assign the template. The category you choose has no effect on the template itself, it is simply the folder in which you are saving the template. Choosing an appropriate category make it easier to find the template when you want to use it again.
For example, you might save a template under the Presentation category.
Click on Save button to save the template.
Question 18.
Write command to create table named ‘BOOK’ with following fields:
FIELDS | DATATYPES |
BOOK ID | Char(4) |
Bname | Varchar(15) |
Author | Varchar(20) |
Price | Decimal |
(a) Identify the primary key of the Book Table, also mention the suitable reason for choosing it as a Primary Key
(b) Differentiate between
(i) Char and varchar data type
(ii) DDL and DML
Answer:
CREATE TABLE BOOK(BOOK ID Char(4), BnameVarchar(15), Author Varchar(20), Price , Decimal(5,2));
(a) BOOK ID is the Primary key because it contains unique values.
(b) (i)
CHAR Data Type | VARCHAR Data Type |
Its full name is CHARACTER | Its full name is VARIABLE CHARACTER |
It stores values in fixed lengths and are padded with space characters to match the specified length | VARCHAR stores values in variable length along with 1 -byte or 2-byte length prefix and are not padded with any characters |
It can hold a maximum of 255 characters. | It can hold a maximum of 65,535 characters. |
It uses static memory allocation. | It uses dynamic memory allocation. |
(ii) DDL and DML
Data Definition Language (DDL) is a language that enables a user to create, modify and work with the structure of the database whereas 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.
Question 19.
Write the SQL commands to answer the queries based on Fabric table
(a) To insert the following record
(“F005”, ’’Kurta”, “Woollen”,5)
(b) To display only those fabric whose disc is more than 10
(c) To display those records whose type is ’’Woollen”
(d) To delete the record of fabric ‘F003’ from table
Answer:
(a) INSERT INTO FABRIC VALUES (“F005”, “Kurta”, “Woollen”,5);
(b) SELECT * FROM FABRIC where Disc>10;
(c) SELECT * FROM FABRIC where Type=”’Woollen”;
(d) DELETE FROM FABRIC where FabricID=”F003”;
Question 20.
Given the following Spreadsheet, Write the appropriate Formula/Expression/Function to be used for (a) to (d)
(a) To calculate the Total Qty in cell C8.
(b) To find the Maximum Price to be written in Cell DIO.
(c) To find the Average Qty to be written in cell C9.
(d) To calculate the Total Amount in cell E8.
Answer:
(a) =SUM(C4:C7)
(b) =MAX(D4:D7)
(c) =AVERAGE(C4:C7)
(d) =SUM(E4:E7)
Question 21.
Explain the following terms –
(a) Blog (b) Web Address
(c) Network (d) Web Browser
Answer:
(a) Blog – A blog is an easy to create website that allow users to share their thoughts with the world over the internet. The word blog comes from the combination of words web and log, where log is an official record of events or diary of information maintained on the web.
(b) Web Address – The web address is the information about the location of the webpage on the server. Web address is also known as URL of the webpage.
(c) Network – Computer network is a collection of computers and other hardware components interconnected through a communication channel which allows sharing of resources and information. Communication channel can be as simple as cables or as advanced as wireless and satellite.
(d) 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.