Students can access the CBSE Sample Papers for Class 10 IT with Solutions and marking scheme Set 6 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 10 IT Set 6 With Solutions
Time Allowed: 2 Hours
Maximum Marks: 50
General 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.
- Maries 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 (24 marks)
Question 1.
Answer any 4 out of the given 6 questions on Employability Skills.
(A) Yoga is one of the popular stress management techniques because ___________ [1]
(a) It keeps mind and body healthy
(b) Improves personality
(c) Make us feel fit
(d) All of the above
Answer:
(d) All of the above
Explanation:
Physical exercise is one ofthe stress management techniques. It helps in proper blood circulation and relaxes the body. This will help us in becoming more active stress free.
Some other stress management techniques are: Time management, mediation, going out for vacations. Ail these techniques help you in releasing stress.
(B) Kritika has participated in Inter School Debate Competition. The topic of debate will be given 30 minutes before the competition. She is tensed and worried. Which of the following best describes these emotions? [1]
(a) Stress
(b) Harassment
(c) Demotivation
(d) All of above
Answer:
(a) Stress
Explanation:
Stress is a physical, emotional, mental and social reaction to any perceived demands or threats. For example, you are about to give viva but feel unprepared.
(C) Surya Pratap works as Office Manager in a leading construction company. He manages all the documentation of the office. He is creating a tender for a contract. For writing quotations, he is taking reference from an old file. He wants to copy text from that file. Which of the following shortcut keys should he use? [1]
(a) Ctrl + X
(b) Ctrl + V
(c) Ctrl + C
(d) Ctrl + Y
Answer:
(c) Ctrl + C
Explanation:
Ctrl + C is the shortcut key to copy the selected text.
Copying text Lets you make a duplicate copy of the selected text. This copy can be used elsewhere in the same or another document. A copy of the text is placed in the Clipboard which can be pasted at a new location using Ctrl + V. The keyboard shortcut key for cut is Ctrl + X and that for paste is Ctrl + V.
(D) Rohit works as an App developer for an IT company but now he wants to work for himself. He has created a team to achieve his goals. Help him by suggesting which of the following India to encourage such entrepreneurship? [1]
(a) Jan Dhan Yojna
(b) Make in India
(c) Digital India
(d) Startup India
Answer:
(d) Startup India
Explanation:
Startup India is an initiative of Govt, of India to support the startup culture by building a strong and inclusive ecosystem for innovation and entrepreneurship in India.
Make in India is another initiative of the Indian Government to make and encourage companies to develop, manufacture and assemble products made in India. This campaign is intended to boost the domestic manufacturing industry.
(E) GUI stands for_________ [1]
(a) Graphic User Interface
(b) Graphical User Interface
(c) Graphic User Interaction
(d) Graphical User Interaction
Answer:
(b) Graphical User Interface
Explanation:
Graphical User Interface is a type of user interface through, which a . user interacts with the computer. It is user friendly interface in which commands can be entered with mouse clicks. Windows is a GUI based operating system.
(F) Which of the following is an idea of self-employment? [1]
(a) Teaching in a school
(b) Owning a shoe business
(c) Cooking in a restaurant
(d) Marketing of a product
Answer:
(b) Owning a shoe business
Explanation:
Teaching, cooking and marketing are all wage types of employment where a person works for someone and gets salary or wages in return.
A self-employed person is an entrepreneur who runs a business and tries new ideas. A person wno becomes an entrepreneur goes through a career process.
Question 2.
Answer any 5 out of the given 6 questions.
(A) ‘App Solutions’, an IT based company, wants to conduct an interview for the position of System Analyst. For this purpose, the company has already received a number of resumes. Now the company wants to send interview letters to all the candidates with different names and addresses. To accomplish the task company should use_______feature of Word Processor. [1]
(a) E-mail
(b) Tables
(c) Mail Merge
(d) All of the above
Answer:
(c) Mail Merge
Explanation:
Mail merge is a technique in Word Processor which is used to merge text with addresses to create personalized letters. In mail merge, the main text document contains the main body of the letter, field names and instructions for merging. The Address database stores the information to be merged with the main document. It usually keeps names and addresses of recipients.
(b)________ allows you to test out various scenarios and determine a range of possible outcomes. [1]
(a) Data consolidation
(b) Goal seek
(c) Track Changes
(d) What-lf Analysis
Answer:
(d) What-lf Analysis
Explanation:
What-lf Analysis is the process of changing values in cells to see how those changes will affect the outcome of formulas on the worksheet.
(C) Sahil is designing a database for storing records of students in a school. He has created two tables – one for the personal details of students and another to store their fee records. He wants to keep a common field in both the tables to identify the records uniquely. That filed should be declared as________ [1]
(a) Composite primary
(b) Primary
(c) Alternate
(d) Foreign
Answer:
(b) Primary
Explanation:
A primary key is a field that uniquely identifies the records in a table.
Example:
Student ID or Roll Number can be a primary key for records of students, Product ID can be a primary key for a table having records of products etc.
(D) Data consolidation allows you to combine data from__________ worksheet to single worksheet. [1]
(a) 2
(b) 3
(c) 4
(d) Multiple
Answer:
(d) Multiple
Explanation:
Data consolidation allows the user to collect data from multiple worksheets and store them into a single master worksheet.
(E) Which of the following sign or symbol is used in secured sites? [1]
(a) HTTP
(b) Padlock sign
(c) FTP
(d) Cross sign
Answer:
(b) Padlock sign
Explanation:
The lock symbol and the URL containing “HTTPS” means that the connection between your web browser and the website server is encrypted and cannot be intercepted.
(F) Commands that allow you to make permanent changes in the database are called _________ [1]
(a) DDL commands
(b) TCL commands
(c) DML commands
(d) All of these
Answer:
(b) TCL commands
Explanation:
TCL stands for Transactional Control Language. These commands manage transactions within the database. These are used to manage the changes made by DML (Data Manipulation Language) statements.
Question 3.
Answer any 5 out of the given 6 questions.
(A)__________is a named collection of various formatting features. [1]
(a) Group
(b) Ribbon
(c) Style
(d) Tab
Answer:
(c) Style
Explanation:
A Style is a feature of Word Processor. It is a named collection of various formatting features that defines the look and behaviour of various components of a document.
(B) Collecting and integrating data from multiple resources into a single destination is called__________ [1]
(a) Grouping
(b) Sorting
(c) Consolidating
(d) Merging
Answer:
(c) Consolidating
Explanation:
Data consolidation is a process in which similar type of data, existing in multiple sheets of a workbook, is combined together. The consolidated data is stored at a different place.
(C) Kavita has been working on a Project. She is creating a Project report in a word processor. The report consists of various headings and sub headings. The report is quite a large document with more than 100 pages in it. She wants that there should be a way to reach to a particular heading or sub heading directly. Which of the following features of Word processor can be used to accomplish the task? [1]
(a) Table of Contents
(b) Macros
(c) Lists
(d) Styles
Answer:
(a) Table of Contents
Explanation:
The Table of contents is a list or a table Listing all chapters or section titles or headings along with their page numbers. It is a hierarchy of headings.
Note: If you want to add an automatic table of contents in your document, then you need to apply heading and sub heading styles to all the titles in your document.
(D) Database servers are referred to as____________ [1]
(a) Data-ends
(b) Front-ends
(c) Data-models
(d) Back-ends
Answer:
(d) Back-ends
Explanation:
A back-end is a place to store data that users access through a separate application. It consists of a database stored on a server which provides data on request.
The user-interface through which a user interacts with an application to store, retrieve and manipulate data is called front-end.
Example:
When a customer browses any product on a website, they are interacting with the front end. But when they put the product into the shopping cart and order it, the information is kept in a database which acts as a back end to that website.
(E) Which of the following software is appropriate to store records of employees? [1]
(a) OpenOffice Calc
(b) OpenOffice Base
(c) OpenOffice Writer
(d) OpenOffice Impress
Answer:
(b) OpenOffice Base
Explanation:
OpenOffice Base is an open source database management system which is used to work on databases. You can add, modify, delete records in it.
(F) Sukanya works in Bangalore and her mother lives all alone in Jaipur. During office hours she talks to her mother via texting using an Instant messenger. Which of the following applications you would not suggest for Instant messaging? [1]
(a) Google hangouts
(b) Facebook
(c) Skype
(d) Telegram
Answer:
(b) Facebook
Explanation:
Instant Messaging is an online communication method used to connect two or more people in real-time for back-and-forth communication. Facebook is a social media website that allows its users to connect online with their friends, relatives, colleagues etc. who are staying geographically apart. It allows users to share pictures, music, videos and their thoughts with whom they are connected with. But Facebook does not work on real-time technology. Thus it is not an instant messaging app.
Question 4.
Answer any 5 out of the given 6 questions.
(A) Technique used to remove an unwanted area from an image is called ____________ [1]
(a) Grouping
(b) Ungrouping
(c) Cropping
(d) Deleting
Answer:
(c) Cropping
Explanation:
Cropping an image refers to deleting or removing the part of an image. Cropping is helpful when you are working with a big image and you want to focus on some specific part of that image.
(B) The amount of data that a signal can carry is called _____________ [1]
(a) WiFi
(b) Bandwidth
(c) Megabits
(d) Gigabits
Answer:
(b) Bandwidth
Explanation:
Bandwidth refers to the amount of data that a signal or circuit can carry, it is measured in Mbps (Megabits per second) or Gbps (Gigabits per second).
(C) Satya Tripathi has started a travel agency which offers train and flight bookings along with hotel reservations. He has 4 employees each having a PC to do the task. He wants to create a network which should have a server. Which of the following network should he set up? [1]
(a) Peer-to-Peer
(b) MAN
(c) WAN
(d) Client/Server
Answer:
(a) Peer-to-Peer
Explanation:
In a peer-to-peer network a group of computers are connected to each other with equal permissions and responsibilities for processing data. In this type of network no devices are designated as a client or server.
(D) Kamal has created a worksheet where he has added the details of all products in his grocery shop. He told his accountant to go through the worksheet and make necessary changes if required. In addition he also wants to know the changes done by his accountant. Which of the following features of spreadsheet should he use to see the changes made by his accountant? [1]
(a) Review changes
(b) Macros
(c) Track changes
(d) Find and replace
Answer:
(c) Track changes
Explanation:
When the Track Changes’ feature is enabled, the spreadsheet highlights the changes such as insertions and deletions.
(E) The arrangement of records is called _________ [1]
(a) Sorting
(b) Indexing
(c) Ritering
(d) Query
Answer:
(a) Sorting
Explanation:
Sorting information in a database refers to the process of arranging data on the basis of one or more than one fields. Sorting can be done in ascending and descending order.
(F) In Excel ___________ can be used to create a hyperlink inside a worksheet. [1]
(a) Insert -> Link
(b) File -> New -> Link
(c) Home -> Insert -> Link
(d) All of these
Answer:
(a) Insert -> Link
Explanation:
In MS Excel, you can create hyperlinks in any cell. This hyperlink can be used to go to any specified location with one click. To create a hyperlink in Excel follow the given steps:
- Click in the cell where you want to create a Link.
- On the Insert tab, in the Links group, click on Link.
- Under Link To, you can specify the desired file, email address or any other location to be linked.
Question 5.
Answer any 5 out of the given 6 questions.
(A) Krishna wants to make a flowchart for his programs in a Word document. Which option should he use to accomplish the task efficiently? [1]
(a) Drawing/Shapes
(b) Symbols
(c) Pictures
(d) All of these
Answer:
(a) Shapes
Explanation:
The Shapes gallery, which can be accessed by clicking on Insert -> Shapes, provides a number of different shape categories. These categories include Lines, Rectangles, Basic Shapes, Flowchart, Callouts etc.
(B) Which of the following device is used in network to convert digital signals of computer to analog signals and vice versa? [1]
(a) Router
(b) Modem
(c) Switch
(d) Hub
Answer:
(b) Modem
Explanation:
Modem is a modulation and Demodulation device connected with a computer. It converts incoming analog signals from telephone lines to digital signals of a computer and outgoing digital signals to analog, so that the data could travel via telephone lines over the communication network.
(C) Hardik works as an accountant in a company. He maintains account in a spreadsheet. On everyday basis he has to follow certain actions on the worksheet. Which of the following feature of spreadsheet you would suggest him, through which he can perform these steps quickly and without repeating them? [1]
(a) Macro
(b) Linking
(c) Sharing
(d) Function
Answer:
(a) Macro
Explanation:
Macro is a named and recorded sequence of commands or keystrokes that are saved to be reused anytime. These are helpful in situations where similar sets of actions are to be performed repeatedly on different sets of data.
(D) Which of the following is/are function(s) of report? [1]
(a) It summarizes and prints data.
(b) It enables user to enter, view and edit data.
(c) It filters data on basis of criteria.
(d) All of these.
Answer:
(a) It summarizes and prints data
Explanation:
A Report is a summarized and printed form of data. It Lists data in a formal, presentable and formatted form.
(E) Maria International School has created a database of students. The tables Student consists of fields like AdmissionNo, RollNo, Name, Address, PhoneNo. Another table namely Marks consists of academic records of students in the fields RollNo, Marksl, Marks2, Marks3, Marks4, Marks5. To print the report card, data will be taken from both the tables as the records in both the tables are related to RollNo. What type of relationship exist between the tables Student and Marks? [1]
(a) One to One.
(b) One to Many.
(c) Many to One.
(d) Many to Many.
Answer:
(a) One to One
Explanation:
In a one-to-one relationship each record in one table is associated with .exactly one record in another table.
A relationship in databases is a link that associates two tables through a common field. Three types of relationships can be formed in databases. These are:
- One to one
- One to many
- Many to one
(F) In today’s world, we cannot think of our lives without the internet for a single day. We provide our sensitive information like personal and financial information to many of the sites. Which of the following measures should be taken to ensure security? [1]
(a) Keep a strong password.
(b) Ensure the confidentiality of information.
(c) Practice safety measures online.
(d) All of these
Answer:
(d) All of these
Explanation:
Password provides an entry to an online account so you should keep your password secure. For this you can create a strong password and keep it confidential.
Confidentiality of information refers to the authorization of sensitive and protected data. To ensure confidentiality of data you should keep your computer safe by using firewall and browser settings. Also ensure that you should not share your sensitive information on wireless and public networks.
To keep your system protected use anti-virus and anti-spyware software and download updates regularly.
Section – B (26 Marks)
Answer any 3 out of the given 5 questions on Employability Skills
Answer each question in 20 – 30 words.
Question 6.
Define the term entrepreneurship. [2]
Answer:
Two principles of effective communication are as follows:
- Consistency: The communication should always be planned and consistent with a clear objective of the message being conveyed.
- Feedback: The feedback provides confirmation from the recipient whether the message is understood in the same sense as it was delivered or not.
Question 7.
Self-Management plays a decisive role in personal and professional life. What do you understand by self-management? [2]
Answer:
Self-management refers to the ability of managing . our behaviour, thoughts and emotions in a conscious and productive way. Employees with strong self-management skills can achieve their goals within a timeline without going through stress.
Question 8.
How is entrepreneurship important in creating jobs? [2]
Answer:
Entrepreneurs provide a large number of employment opportunities. An entrepreneur, even at the. most basic scale, employs people to manage their business activities. They generate direct as well as indirect employment by setting up new units at small and large scale levels.
Question 9.
What are the general things to be taken care of while physical cleaning of the computer? [2]
Answer:
The physical cleaning of computer is very . important so as to remove dust from it. Dust makes the computer overheated resulting in damage of its parts. While cleaning a computer following things should be taken care of:
- Always use a lint-free cotton cloth to clean its components.
- Never spray any liquid onto any computer component. You can spray the liquid onto a cloth.
- Always use a vacuum cleaner for sucking the dust from the computer parts. The
Question 10.
Goal setting is a very essential factor in your personal life. List all the SMART methods to set the goals. Explain ‘A’ in brief. [2]
Answer:
SMART is an acronym that stands for Specific, Measurable, Achievable, Realistic and Timely. It incorporates all these criteria to help focus your efforts in achieving the goals.
A stands for Achievable which means that goals should be attainable and not impossible to achieve. For achieving the goals, they can be broken into small steps for short term.
Other terms of SMART are:
- Specific – Goals should be specific, clear, and unambiguous.
- Measurable – Goals should have specific criteria to measure the progress towards their accomplishments.
- Realistic – Goals should be realistic, within reach and most importantly you should be willing and able to work to achieve them.
- Timely – For achieving the goals there should be a clearly defined timeline with both starting and target dates.
Answer any 4 out of the given 6 questions in 20 – 30 words each.
Question 11.
Why Styles are important in Word processors? [2]
Answer:
Style in a word processor provides a consistent appearance to the document. These are helpful in long documents such as thesis, manuscripts etc. Using Styles you can format your document by quickly applying multiple formatting settings to portions of the document. It also helps in building a table of contents.
Question 12.
Differentiate between field and record in a table. [2]
Answer:
Field | Record |
A field contains only one type of informations. | A record is a combination of related fields. |
It contains information about one aspect of a complete record. | It represents a complete unit of information. |
Question 13.
What is document hyperlink in a spreadsheet? [2]
Answer:
Document Hyperlink in a spreadsheet is defined as a reference to any location, webpage, or a document that we can access by clicking the link. Using these links you can combine text as well as other spreadsheet objects such as charts, sheets, images etc.
Question 14.
How is LAN different from WAN? [2]
Answer:
LAN | WAN |
LAN stands for Local Area Network. | WAN stands for Wide Area Network. |
It is a small computer network confined to a local area such as one office or a building etc. | It is a network of computers that are geographically apart such as cities, countries, etc. |
Question 15.
Discuss is the purpose of adding comments in a worksheet. [2]
Answer:
The comments in a worksheet are added when you are sharing a worksheet with multiple users. They add an extra information to a figure in a cell, use to note trends or add an action note. These comments only show the suggested changes in a worksheet which the user can accept or reject as required. The comments are temporary and can be edited or deleted from the sheet. These refrain the user from making any kind of permanent changes in sheet.
Question 16.
Define online transaction. What is the other name given to it? [2]
Answer:
Online transaction is a payment method in which money is transferred electronically over the Internet. It is also known as e-payment.
Answer any 3 out of the given 5 questions in 50 – 80 words each.
Question 17.
How can multiple sheets be combined into one in Calc, and what is the default number of worksheets provided in a workbook in Calc? [4]
Answer:
After reviewing, the sheets can be brought together by merging them.
To merge the sheets, click on Edit -> Changes -> Merge’Document.
The merging of sheets is useful in situations when data is split into multiple sheets or multiple reviewers have given edited documents. The data from these sheets are then required to put together into a single worksheet which is accomplished by merging the sheets.
By default, Calc provides three worksheets in a workbook.
Question 18.
How can unwanted parts be removed from an image, common actions performed on multiple drawing objects, and images positioned between text while defining the concept of an anchor point in graphic design or document editing? [4]
Answer:
One can use Crop feature of word processor to remove that unwanted part from the image.
The drawing objects can be combined together by grouping. This feature will treat all the separate objects as one and whatever functions are performed will be applied on aU. of them.
Text Wrap feature can be used to keep the image between the text. The text is placed around the image.
An anchor is a symbol that appears when image or any other object is inserted in the document. It is a reference point for the vertical and horizontal placement of images.
Question 19.
Following table displays part of the information of items kept in a grocery store. [4]
Table: Items
ItemCode | ItemName | Price | Quantity |
101246 | Tomato Puree | 50.55 | 20 |
105462 | Sweet Corn | 120.75 | 35 |
110645 | Cashew | 250.00 | 15 |
149032 | Noodles | 15.00 | 30 |
(A) How many fields and records are there in items table?
(B) Write SQL commands to:
- Display the names of those items whose quantity is less than 30.
- Update the price of all items in the given table by 5%.
- Add a new item in the table with given details (“1290456”, “Glucose Biscuit”, “15.00”, “40”)
Answer:
(A) There are four fields and four records in the table.
(B) SQL Commands:
- SELECT ITEMNAME FROM ITEMS WHERE QUANTITY < 30.
- UPDATE ITEMS SET PRICE = PRICE * 0.5 + PRICE.
- INSERT INTO ITEMS VALUES (1290456, Glucose Biscuit, 15.00, 40).
Question 20.
What are different methods that are used to create tables in Base? Write any one difference between a Table and a Database. [4]
Answer:
There are three methods to create table in OpenOffice Base These are:
- Using Table wizard.
- Using Datasheet view.
- Using Design view.
A database is a collection of interrelated tables whereas a table is a component of database that consists of all the information and data organized in rows and columns.
Question 21.
Discuss chat etiquette, suggest instant messaging software, list video conferencing hardware, and recommend an online service for messaging and file sharing.
Answer:
1. While chatting with people using any instant messenger, one should follow some basic rules and etiquette for chatting. Some of them are as follows:
-
- Start your conversation with small greeting.
- Keep your messages short and sweet.
- Use of Caps Lock should be avoided as it is equivalent to shouting.
- Always end your conversation with short closing message.
Example: Bye, take care etc.
2. Instant messaging apps that can be used by them are WhatsApp, Facebook Messenger, Google Hangouts, and Slack.
3. Apart from computers they would require a webcam, microphone, speaker and headphone for Video Conferencing.
4. Email can be used to send messages and files in form of attachments, over the Internet.