Students must start practicing the questions from CBSE Sample Papers for Class 10 Information Technology with Solutions Set 1 are designed as per the revised syllabus.
CBSE Sample Papers for Class 10 IT Set 1 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) Sustainable development requires judicious use of ……………
(a) natural resources
(b) human resources
(c) man-made resources
(d) none of these
Answer:
(a) natural resources
(ii) Vacationing helps in ……………… individuals.
(a) stressing
(b) de-stressing
(c) destroying
(d) none of these
Answer:
(b) de-stressing
(iii) Computer programs that can damage the data and software programs or steal the information stored on a computer.
(a) Spam
(b) Viruses
(c) Junk mail
(d) BIOS
Answer:
(b) Viruses
(iv) The small pictures on the desktop are called …………..
(a) Worm
(b) Wallpaper
(c) Icons
(d) None of these
Answer:
(c) Icons
(v) Good stress is knows as …………..
(a) Prestress
(b) Eustress
(c) Distress
(d) None of these
Answer:
(b) Eustress
(vi) ………… refers to your ability to identify effective methods of getting yourself to move from thoughts to action.
(a) Self-motivation
(b) Selflessness
(c) Self-dedication
(d) None of these
Answer:
(a) Self-motivation
Question 2.
Answer any 5 out of the given 6 questions: (1 × 5 = 5 Marks)
(i) A ………… is an application software that processes text and is used to create, modify, format and print documents.
(a) Open office Calc
(b) Open office impress
(c) Open office writer
(d) None of these
Answer:
(c) Open office writer
(ii) …………… is a horizontal bar present at the bottom of windows 7 desktop.
(a) Status bar
(b) menu bar
(c) taskbar
(d) recycle bin
Answer:
(c) taskbar
(iii) …………… serves as an interface between the user and computer.
(a) Hardware
(b) Software
(c) Internet
(d) Operating System
Answer:
(d) Operating System
(iv) Complete the assignment ………….. 1 hour.
(a) at
(b) in
(c) by
(d) under
Answer:
(b) in
(v) Sound sentry is designed to help users with ……………. impairments.
(a) vision
(b) auditory
(c) both (a) and (b)
(d) none of these
Answer:
(b) auditory
(vi) The term ISP stands for ……………
(a) Internet Security Protocol
(b) Internet Service Protocol
(c) Internet Service Provider
(d) Internet Security Provider
Answer:
(c) Internet Service Provider
Question 3.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) When a combination of hardware and software enables a person with a disability or impairment to use a computer, it is known as [CBSE 2020]
(a) Mechanical Assistance
(b) Assertiveness
(c) Assistive Technology
(d) Assistance and Communication
Answer:
(c) Assistive Technology
(ii) The intersection point between a row and a column is called a ………….
(a) Table
(b) Cell
(c) Row
(d) Active Cell
Answer:
(b) Cell
(iii) ………….. keys are also known as modifier keys.
(a) Shift
(b) Ctrl
(c) Alt
(d) All of these
Answer:
(d) All of these
(iv) A …………. is a graphical representation of data, in which the data is represented by symbols, such as bars.
(a) Picture
(b) Graph or Chart
(c) Smart Art
(d) None of these
Answer:
(b) Graph or Chart
(v) A ……………… is a model used to create other documents.
(a) Wizards
(b) Chart
(c) Styles
(d) Templates
Answer:
(d) Templates
(vi) Header& Footer option is available under …………. menu.
(a) Edit
(b) View
(c) Insert
(d) Format
Answer:
(c) Insert
Question 4.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) ………….. are generally prepared for presenting the data in hard copy by using printers.
(a) Form
(b) Query
(c) Report
(d) Table
Answer:
(c) Report
(ii) The extension of Libre Offices preadsheet file is ………….
(a) .ODS
(b) .ODT
(c) .ODP
(d) .ODD
Answer:
(a) .ODS
(iii) Data can be organized in a database in mainly ……………. types.
(a) Four
(b) Six
(c) Three
(d) Two
Answer:
(d) Two
(iv) Relational Database is a collection of ………………
(a) Tables
(b) Values
(c) Records
(d) None of the above
Answer:
(a) Tables
(v) Which website is used for online booking of train tickets?
(a) Amazon
(b) IRCTC
(c) Flipkart
(d) Trivago
Answer:
(b) IRCTC
(vi) In which menu Share Spreadsheet option is available?
(a) Tools
(b) Data
(c) Styles
(d) Format
Answer:
(a) Tools
Question 5.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) IMS include the option for ………….
(a) File transfer
(b) Audio Chat
(c) Video Calling & Conferencing
(d) All of these
Answer:
(d) All of these
(ii) ………….. is a set of data values of one type arranged in a vertical manner.
(a) Row
(b) Field
(c) Tuple
(d) All of these
Answer:
(b) Field
(iii) 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
(iv) key is used to select contiguous files and folders.
(a) Shift
(b) Ctrl
(c) Alt
(d) All of the above
Answer:
(a) Shift
(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
(c) Cells
(b) Columns
(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.
Explain any 2 Qualities of an entrepreneur.
Answer:
1. Determined
2. Confident
Question 7.
Differentiate between files and folders.
Answer:
A file is a named collection of information stored on a computer and can be a text document, an image, a video, or any other type of digital content. A folder, a directory, is a container for files and other folders to organize and manage digital content on a computer.
Question 8.
Rohan’s father told him that they need to attach a modem for internet connection on their computer explain the meaning and function of modem to Rohan.
Answer:
The word modem is derived from its function modulator/demodulator. Modem is a device that converts digital computer signals into analog signals that can travel over telephone lines. It also reconverts the analog signal to digital signals at the receiving end.
Question 9.
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 10.
What are the measures to increase the performance of a computer system?
Answer:
The performance of a computer can be increased by removing any extra files such as temporary files and images. We can use some disk cleaner software, which helps us clean up the unnecessary files.
Answer any 4 out of the given 6 questions in 20-30 words each (2×4 = 8 Marks)
Question 11.
What are document templates? State the purpose of using a document template.
Answer:
A template is a model document that is used to create other documents. All documents in LibreOffice are based on templates. If you do not specify a template when you start a new document, by default blank template is used.
Question 12.
Differentiate between data definition language (DDL) and data manipulation language ’ (DML).
Answer:
(1) Data Definition Language (DDL) is a language that enables a user to create, modify and work with the structure of the database. For, eg., CREATE TABLE.
(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 13.
Explain any three character formatting options in a word document.
Answer:
The character formatting options are –
(1) Font – To change the font of the Character selected we can use this formatting option.
(2) Size of the text – The size of the text can be increased or decreased as per the requirement.
(3) Bold – The Bold option can be applied to emphasize/highlight the selected character.
Question 14.
What is the use of consolidate data tool in calc?
Answer:
Data consolidation is a feature that allows you to collect data from different worksheets to one single sheet in the same workbook. This feature also allows the user to perform operations like sum, average, max, min, product, etc on the data to be consolidated.
Question 15.
What do you mean by grouping of objects?
Answer:
Grouping means to group multiple objects together to be treated as a single unit. Thus, grouping allows us to perform various operations like increasing or decreasing the size, changing the position of the grouped objects all at once.
Question 16.
Define the following terms.
(i) P2P (ii) DBMS
(iii) Primary Key (iv) Foreign Key
Answer:
(i) 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.
(ii) DBMS – Database Management System is a computerized record keeping system that enables to create, store, modify, and extract information from a database.
(iii) Primary Key – A primary key is a unique value that identifies a row in a table. A primary key is indexed in the database making it faster for the database to search for a record.
(iv) Foreign Key – The foreign key identifies a column or set of columns in one table that refers to a column in another table. In other words, we can say that the primary key field of one table is also often present in second table and so it becomes foreign key of the main table.
Answer any 3 out of the given 5 questions in 50-80 words each (4 x 3 = 12 Marks)
Question 17.
Elaborate the different types of styles which can be provided in word processor.
Answer:
The following types of Styles are supported by Writer-
(1) Page Styles – This includes margins, headers and footers, borders and backgrounds.
(2) Paragraph Styles – This controls the total appearance of the paragraph such as text alignment, tabs, line spacing, borders and even character formatting.
(3) Character Styles – This affects only the selected text within a paragraph, font and size of the text, or Bold, Italic and Underline formats.
(4) Frames Styles – These are used to format the frames around the graphics or text, it also includes wrapping text, borders, backgrounds and columns.
Question 18.
Write the SQL commands to answer the questions based on the “WORKER” table.
(a) Create “Worker” table with the following fields
FIELDS | DATA TYPES |
WID | Integer |
Wname | Varchar(20) |
WDesignation | Char(10) |
WCity | Varchar(30) |
WPhone | Char(10) |
(b) Display all the records in the Worker table
(c) Display the records where city is Delhi
(d) Define Primary Key
Answer:
(a) CREATE TABLE, WORKER (WID INTEGER, WNAME VARCHAR (20), WDESIG- NATION CHAR (10), WCITY VARCHAR (30), WPHONE CHAR (10));
(b) SELECT * FROM WORKER;
(c) SELECT * FROM WORKER WHERE WCITY=”DELHI”;
(d) Primary Key – A primary key is a unique value that identifies a row in a table. A primary key is indexed in the database making it faster for the database to search for a record. The primary key constraint can be applied on one or more than one columns together.
Question 19.
What precautions must be taken to improve the online security?
Answer:
The following precautions must be taken to improve online security-
(1) 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.
(2) 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.
(3) Do not Share Personal Information:
Some websites require you to fill out forms containing field such as name, gender, age, email ID School, college, company, etc. Be cautious while filling out such forms the search and verify if it is a trustable website as your information could be used by unauthorised users.
(4) Secured Transactions:
If you to do online shopping for transactions, website stores even your credit card or net banking details as well as your personal information your credit card number, account details, etc. This information can be tracked and used by unauthorised user known as hackers may misuse this information.
Question 20.
Given the following Spreadsheet, Write the appropriate Formula/Expression/Function to be used for the following- [CBSE 2020]
(a) Write the formula to calculate the Total Sales of North Zone.
(b) Write the feature used for arranging the sales from Lowest to the Highest
(c) Write the formula to find the Maximum Sales in East Zone in cell G5.
(d) Write the formula to find the Average Sales in Jan-Mar in cell C7.
(e) Write the formula to find the difference between the sales in East Zone and West Zone in Apr-Jun in cell H5.
Answer:
(a) =Sum(B3:E3)
(b) Sort
(c) =MAX(B5:E5)
(d) =AVERAGE(B3:B6)
(e) =C5-C4
Question 21.
Write down the steps for creating a table in OpenOffice application
Answer:
Follow the given steps for creating a table in LibreOffice-
- 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.