Students must start practicing the questions from CBSE Sample Papers for Class 10 IT with Solutions Set 11 are designed as per the revised syllabus.
CBSE Sample Papers for Class 10 IT Set 11 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) Distress is the term given to [1]
(a) Good stress
(b) Bad stress
(c) Eustress
(d) None of these
Answer:
(b) Bad Stress
Explanation:
The psychologists have given the term distress to the bad stress. It is a negative form of stress. It effects the immune system of your body and also hinders your progress.
Related Theory:
Some symptoms of bad stress are lack of sleep, heart problems, gain or loss in weight, gain or loss of appetite and depression.
(B) Self-awareness refers to awareness about one’s own [1]
(a) Strengths or weaknesses
(b) Interests or capabilities
(c) Values
(d) All of the above
Answer:
(d) All of the above
Explanation:
Self-awareness is the understanding of one’s own strengths, weaknesses, interests, abilities, attitudes, etc. with a knowledge of how one can utilize these.
(C) Susheela owns a manufacturing and packaging unit of Indian food items which she decides to sell in Dubai, Mexico and Russia. Due to some reasons the products did not sell and she had a loss. She apologises to the people who work for her and promised to plan better for next time. She is : [1]
(a) taking responsibility for her mistakes.
(b) thinking before making a decision
(c) not giving up
(d) being creative
Answer:
(a) taking responsibility for her mistakes
Explanation:
By taking responsibility for her mistakes, she is showing her courage and planning for not repeating her mistakes again. This is a positive mindset which is required by entrepreneurs to give growth to their business.
(D) ……………………… is the dashboard of your computer. [1]
(a) Taskbar
(b) Start menu
(c) Recycle bin
(d) File explorer
Answer:
(b) Start menu
Explanation:
The Start menu is also called dashboard of the computer as it consists of all the controls and list of all programs installed on your computer. It is launching menu from where you can start any of the installed program and perform any other utility tasks.
(E) Which of the following practices should be avoided for cleaning a computer? [1]
(a) Use lint free swabs to clean parts of computer
(b) Spray a liquid before wiping the parts with cloth
(c) Turn off computer before cleaning
(d) Use natural bristle brush to clean internal parts
Answer:
(b) Spray a liquid before wiping the parts with cloth
Explanation:
Never spray any liquid on computer parts. If needed then spray the liquid onto a cloth.
(F) Which of the following is not a disadvantage of entrepreneurship? [1]
(a) Risks involved with success of new venture ‘
(b) Working for long hours
(c) No regular income initially
(d) No higher authority
Answer:
(d) No higher authority
Explanation:
An entrepreneur does not work under anyone. They are their own bosses. They are themselves responsible for their decisions or repercussion caused due to the decision. They do not have to answer anyone.
Question 2.
Answer any 5 out of the given 6 questions.
(A) You can a ……………………… text selection into the Styles and Formatting window to create a new style. [1]
(a) Drag and drop
(b) Cut and paste
(c) Copy and paste
(d) Update
Answer:
(a) Drag and drop
Explanation:
The Drag and Drop method is used to create a style from the formatted document object. The style which is active in the selected piece of text, at the time of drag and drop, will be copied to the new document.
(B) Raghavendra is sending an invite to all his friends and colleagues for the celebration of 25 years of his anniversary. He is using mail merge to generate the invitation letters. Due to some reason he wants to change the venue given in the mail. Which of the following documents he has to change for the same? [1]
(a) Data Source.
(b) Main text document.
(c) Both given in (a) and (b).
(d) None of these
Answer:
(b) Main text document.
Explanation:
The main text document consists of main body of the letter. So, to change the venue in letter he has to change the main text document.
Related Theory:
The Data Source refers to the file consisting of names and addresses of the recipients to whom the letters are to be addressed or sent.
(C) ……………………… adds data arranged in an array that is a group of cells with labels for columns or rows. [1]
(a) Consolidate
(b) Group data
(c) Subtotal
(d) Query
Answer:
(c) Subtotal
Explanation:
Subtotal is a feature of spreadsheet to simplify the addition process when working with huge amount of data. It lets you do the addition of group wise data which makes it easy to understand the calculation and makes it more meaningful and presentable.
(D) A relational database is defined as: [1]
(a) Relation between numbers in two tables
(b) Relation between fields of tables
(c) Consisting of separate tables of related data
(d) Consisting of separate fields with common data
Answer:
(c) Consisting separate tables of related data
Explanation:
A relational database is defined as a database that consists of multiple tables which are combined via common fields.
(E) A stand-alone computer is a computer that is: [1]
(a) Connected to the network.
(b) Connected to the office network.
(c) Not connected to a network.
(d) Another name for a desktop PC.
Answer:
(c) Not connected to a network
Explanation:
A computer which is not connected to any type of network is called stand-alone computer.
Related Theory:
A computer which is connected to a network is known as workstation.
(F) WordPress is an example of ……………………… . [1]
(a) Blogging site
(b) Instant messenger
(c) E-shopping site
(d) None of these
Answer:
(a) Blogging site
Explanation:
A blogging site is a type of website that allows its user o publish their blogs, read blogs published by other bloggers and comment on blogs.
Question 3.
Answer any 5 out of the given 6 questions.
(A) In word processors the drag and drop method will ……………………… the image into a document. [1]
(a) Save
(b) Embed
(c) Delete
(d) Cut
Answer:
(b) Embed
Explanation:
Embed means to include or insert an object into a document. In a word processor, you can drag the image file from the file explorer window and drop it in the document widow. This will insert/ embed the image in the document.
(B) Kritika is creating an annual sales report for her company. She uses the articles and charts of all the branch offices to create the final report. Now she wants all the reports to be identical Which of the following word processor features would help her to create such identical documents? [1]
(a) Mail merge
(b) Graphics
(c) Template
(d) None of these
Answer:
(c) Template
Explanation:
A template is a blueprint document containing formatting features, using which you can create new documents with automatically having same formatting features as in template.
(C) Which of the following is not an advantage of a database? [1]
(a) It supports data redundancy
(b) Allows sharing of data
(c) Ensures data security
(d) None of these
Answer:
(a) It supports data redundancy
Explanation:
Data redundancy refers to the duplication of data. A database helps in reducing data redundancy by enforcing some standards for storing data in it.
Related Theory:
Declaring a specific field as primary key make sures that no duplicate data could be entered in the database.
(D) When all data is stored in one file, it is called ……………………… . [1]
(a) Flat database
(b) Relational database
(c) Table
(d) Report
Answer:
(a) Flat database
Explanation:
A flat database is a database when complete information is stored in one single table and has no relation with any other table in database.
Related Theory:
In contrast to flat database, there are relational databases in which there is one common field and data is stored in multiple tables linked via the common filed.
(E) Which of the following is not an option for Internet connectivity? [1]
(a) Dial-up
(b) Broadband
(c) WiMax
(d) USENET
Answer:
(d) USENET
Explanation:
USENET is a discussion group where users can discuss and share their opinion on specific subject.
(F) Which of the following is not an antivirus software? [1]
(a) McAfee
(b) Norton
(c) MSOffice
(d) Kaspersky
Answer:
(c) MS Office
Explanation:
MS Office is a collection of many applications such as MS Word, MS Excel, MS PowerPoint etc. It provides all the office documentation applications in one pack.
Related Theory:
An antivirus is a type of software that is used to scan, detect and remove viruses from the computer.
Question 4.
Answer any 5 out of the given 6 questions.
(A) You can add an image into a document from [1]
(a) Scanner
(b) Gallery
(c) Clipboard
(d) All of these
Answer:
(d) All of these
Explanation:
An image from all the given sources can be added in the document.
(B) Which of the following formula refers to cell B1 in sheet Sales? [1]
(a) =Sales.Bl
(b) =Sales.”Bl”
(c) $Sales$Bl
(d) None of the above
Answer:
(a) =Sales B1
Explanation:
To create a link to another sheet you have to mention the sheet name with the cell address to which you want to refer.
Related Theory:
The link which does not refer to the complete path is called relative hyperlink. It starts from the current location. The link which tells the complete path to reach the document, starting from top, is called absolute hyperlink.
(C) A company has its offices in four major cities in India. The data of all regional offices is stored on separate worksheets. The company wants to consolidate this data. To use data from another worksheet, which of the following is most appropriate? [1]
(a) Copying data from all the sheets into a new one
(b) Creating Links to the data from another sheet
(c) Copy data into same sheet and then create link
(d) All of these
Answer:
(c) Creating Links to the data from another sheet
Explanation:
You can create a link to another sheet without copying the data from one sheet to another.
(D) Primary key and alternate key together are called keys. [1]
(a) Foreign
(b) Candidate
(c) Non-primary
(d) Composite
Answer:
(b) Candidate
Explanation:
Primary and alternate keys together are called candidate key. In other words all fields or combination of fields that are eligible to be a primary key, are called candidate keys.
Related Theory:
In a table there may be more than one fields that contains unique values, but only one of them can be declared as primary key. Other such fields are called alternate keys.
(E) Which of the following is not an advantage of networking? [1]
(a) Resource sharing
(b) Cost effective
(c) Communication between computers
(d) Control over computers
Answer:
(d) Control over computers
Explanation:
A network of computers is not done for making control over computers. The prime objective of a network is data and resource sharing and communication between computers.
(F) Which of the following fields in the table “Book” can act as a primary key? [1]
(a) Book_number
(b) Subject
(c) Price
(d) Author_name
Answer:
(a) Book_number
Explanation:
A primary key is a field that holds unique values for each record in the database. Among the given fields only Book_number can be unique for each record. Thus, it can act as the primary key
Question 5.
Answer any 5 out of the given 6 questions.
(A) An absolute hyperlink contains the ……………………… of the linked sheet. [1]
(a) Full address
(b) Address from the current location
(c) Web address
(d) None of these
Answer:
(a) Full address
Explanation:
In a spreadsheet, sheets can be linked with one another. While linking the sheets address of the linked sheet is given. Address given from the top is called the full address known as absolute hyperlink and the address given from the current location is called relative hyperlink.
(B) ……………………… is not a DML command. [1]
(a) INSERT
(b) DELETE
(c) CREATE
(d) UPDATE
Answer:
(c) CREATE
Explanation:
CREATE is a DDL command. DDL stands for Data Definition Language. It provides commands for creation and deletion of database
Related Theory:
DML or Data Manipulation Language provides commands to insert, delete and modify records in the database.
(C) Which of the following defines a primary key? [1]
(a) The first field in the database
(b) The date field in the database
(c) The field which consists of numeric values
(d) The field which stores unique value for each record
Answer:
(d) The field which stores unique value for each record
Explanation:
A primary key field is a field which stores unique data for each record in a database. It is used to identify the record uniquely. The fields that contain information like Customer ID, Admission number, Book Number, Employee ID etc. can be declared as primary key.
(D) A query can be defined as a tool to ……………………… [1]
(a) Enable users to enter and view data.
(b) Filter data from the database based on some criteria.
(c) Summarize and print data.
(d) None of these
Answer:
(b) Filter data from database based on some criteria
Explanation:
A query is a statement or tool that is given to find and retrieve data from the database based on specific condition or criteria.
Related Theory:
The tool that enables users to enter and view data is called Form.
(E) A cell reference outside the worksheet is written as ……………………… [1]
(a) <col> <rbw>
(b) <row> <col>
(c) <sheetname> <row> <col>
(d) <sheetname> <col> <row>
Answer:
(d) <sheetname> <col> <row>
Explanation:
While creating a link between two sheets of same workbook, the reference is given with sheet name. The sheet name is the name written on the tab of the worksheet.
(F) Which of the following is not a use of Firewall? [1]
(a) Monitors all communications
(b) Traps the unauthorized access
(c) Prevents passage of unwanted contents
(d) Prevents viruses and malicious software
Answer:
(d) Prevents viruses and malicious software
Explanation:
A firewall is not capable of preventing viruses and malicious software. For this purpose anti-virus and anti malware software should be used.
Question 6.
What is the significance of self-awareness in achieving our goals? [2]
Answer:
Self-awareness refers to knowing about one’s self in terms of strengths, weaknesses, abilities, likes, dislikes, attitude etc. knowing about one’s self is essential to understand one’s own goals and areas of improvements regarding their weaknesses in achieving them. It helps in managing the challenges and opportunities and strengthening their attitude and abilities which increases confidence and finally helps you in making right decision.
Question 7.
What does ‘R’ mean in SMART goals? [2]
Answer:
SMART is an acronym in which ‘R’ stands for Realistic. It means that your goal should be something that you want to achieve and can work towards it. The goal should be appropriate for what you are trying to accomplish. An unrealistic goal is hard to achieve. Example of an unrealistic goal would be building a muscular body in just 15 days. Example of realistic goal would be – work out regularly and eat healthy to build a muscular body in next 4 to 6 months.
Question 8.
“Stress is like a gateway that provides a heap of diseases.” Explain. [2]
Answer:
Stress is a part of everyday life. It can be helpful in some situations e.g., it motivates you to finish the assignment on time. But when experienced in excess or for a long period of time, stress has the opposite effect. It can harm our emotional and physical health, and limit our ability to function well. The stress may cause diseases like heart problems, depression, sleeplessness, hypertension, ulcer, etc.
Question 9.
What is the use of File Explorer in windows? [2]
Answer:
The files that you create using different types of applications are stored at default or specified locations of your storage unit. Similarly, you can create folders to store your files in them. To perform various operations on these files and folders you require a File Explorer. So, a File Explorer is an application which is used to browse folders and files stored in the computer. It allows the user to perform operations like copying, moving, deleting and renaming these files and folders.
Question 10.
How do entrepreneurs help in creating more entrepreneurs? [2]
Answer:
Entrepreneurs come up with new ideas, concepts, and innovations and work on them for the benefit of themselves and society. A successful entrepreneur becomes a role model for the society and youngsters. Inspite of experiencing ups and downs, he develops his own solutions to overcome his company’s flaws. This guides his employees and followers towards the development of their start-ups under his supervision. As a result of their experiences and guidance, youth are coming up with fresh ideas and solutions. Thus, successful entrepreneur mentors and produces new entrepreneurs.
Answer any 4 out of the given 6 questions in 20-30 words each.
Question 11.
Discuss any four advantages of networking. [2]
Answer:
Advantages of networking are as follows:
- Data Sharing: Networking allows sharing of same data among multiple users connected to a common network.
- Files Transfer: Users can send text files, spread sheets, documents, presentations, audio files, video files, etc. to other users over the network.
- Hardware Sharing: Network also allows its users to share hardware components such as printers, scanners, hard disk etc. This helps in saving cost of resources.
- Internet Access Sharing: A network is capable of sharing the internet connection among other computers in a network. So instead of purchasing multiple Internet connection for each computer only one connection is required.
Question 12.
Define the following terms: [2]
(A) Toggle keys 15.
(B) Sticky keys
Answer:
(A) Toggle Keys: Toggle key are the keys on the keyboard that is operated in the same way but with opposite effect on successive occasions. E.g. Caps Lock is a toggle key, pressed to switch between upper case and lower case alphabets.
(B) Sticky Keys: Sticky keys is an accessibility feature of Windows that assists users having physical disabilities to reduce repetitive strain injury. It enables user to enter key combinations by pressing keys is sequence rather than simultaneously. It helps users who find difficulty in pressing shortcut key combinations.
Question 13.
What is referential integrity? Explain with an example. [2]
Answer:
Referential integrity refers to the relationship between two tables in a database. It means that there must be a valid reference from a row in one table to another table. It ensures that all data in a database remains consistent and up to date. It helps to prevent incorrect records from being added, deleted, or modified. Lets us consider an example of database with two tables, Customer and Orders. The Customer table consists of fields CustID and CustName. Another table Order consists of fields OrderID, CustID and OrderDate. The referential integrity states that the Customer ID (CustID) in the Order table must match a valid CustID in the Customer table.
Question 14.
In a finance company five users are working on the same shared document. Three of them are working on common overlapping data. What happens when they try to save the document? [2]
Answer:
The overlapping documents means that there are changes in common cells done by multiple users. This gives rise to conflicts. If you try to save a document with conflicting changes, the spreadsheet will show you a Resolve Conflicts dialog box. It allows you to resolve the conflict by deciding which version of changes you want to keep. After resolving all the conflicts you can save your document with decided changes.
Question 15.
What is the wrap setting? Mention the types of wrap settings available in Word processors. [2]
Answer:
A wrap setting is a feature of word processor that determines the relation between the text and the graphic in a document. It is also known as text wrapping. A word processor offers different types of text wrapping options. You can place the text around the graphic or an image in a way you want, using any one out of the given options.
Question 16.
You want to add a link to a table in HTML namely sales.html How would you do it in Calc? [2]
Answer:
To add a link to an HTML table perform the following steps:
- Open the sheet where you want to add a link.
- Click the command Insert → Link to External Data.
- Browse and select the file to be linked i.e. sales.html.
Answer any 3 out of the given 5 questions in 50 – 80 words each.
Question 17.
Jaskeerat is working in a renowned company that provides Network Solutions. The company has a worksheet that contains data of its valuable customers. This worksheet is available to all the employees that works for customer support. [4]
(A) Why the sharing of worksheet is required?
Answer:
The Sharing of worksheet is required when multiple users wants to work on same set of data. The users can view, edit or review the changes made in the shared worksheet.
(B) Jaskeerat has changed a value in the worksheet. Who else can see the changes?
Answer:
All the users who are authorised to work on shared worksheet can see the changes made in worksheet. They can also review and make comments on the changes done by any user.
(C) List the features that are disabled in sharing mode.
Answer:
Following features are not available in sharing mode:
(i) Edit > Compare Document
(ii) Edit > Sheet > Move/Copy & Delete
(iii) Insert > Cells Shift Cells Down & Shift Cells Right Tools > Protect Document
(iv) Data > Define Range
(v) Data > Sort
(vi) Data > Subtotals
(D) How is document opened in sharing mode?
Answer:
The document in shared mode is opened in the same way as any other document. To open a shared document click on File → Open.
Question 18.
Suhana is creating a brochure for a school fair. She added picture in the brochure which contains some unwanted part. [4]
(A) What can be done to remove that part from the picture? [4]
Answer:
She can use Crop feature of word processor to remove that unwanted part from the image.
(B) There are few drawing objects on that brochure on which she wants to perform some common actions. How can she do it easily and quickly?
Answer:
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 all of them.
(C) How can she keep the image between the text?
Answer:
Text Wrap feature can be used to keep the image between the text. The text is placed around the image.
(D) Is it possible to keep the image in the background of the text? How?
Answer:
Yes the image can be placed in the background of the text by applying the Color Mode as Watermark on it. The other way to make the image appear as watermark is by giving the image transparent effect by changing the Transparency value.
Question 19.
Consider the following table named ‘House’ with details about houses allotted to the students in a school. [4]
(A) Which column can be set as a primary key in the given table?
Answer:
The StuID column can be declared as a primary key because it has unique values for each record.
(B) Write SQL queries to:
(i) Display the name, house, class in ascending order of the name of the house.
(ii) Change the house name of Student with ID 11004 to Yellow.
(iii) Delete the record of the student whose ID is 11006.
Answer:
(i) SELECT Name, HName, Class FROM House ORDER BY HName ASC
(ii) UPDATE House SET HName = “Yellow” WHERE StuID = 11004
(iii) DELETE FROM House WHERE StuID= 11006
Question 20.
in a school the records of students are stored in a database that consists of two tables. The first table stores personal details of students which are recognized by roll number. Every student has a unique roll number. This roll number field is linked with another table which stores marks of students. Answer the following with explanation in support of your answer. [4]
(A) What type of field is the rolL number in the first table?
Answer:
The roll umber field holds a unique roll number for every student so it is a primary key field of the table. A primary key is a unique value that identifies a row in a table.
(B) What is the term used to describe it in the second table?
Answer:
It is called a foreign key. When two tables are related by a common field and it is declared as primary in one table then in another table it is known as foreign key. It identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table.
(C) What is composite primary key?
Answer:
The primary key that consists of a combination of two or more fields or attributes is known as composite key.
(D) Define alternate key.
Answer:
The field or a group of fields that have unique value for each record but is not selected as a primary key is called alternate key. There can be only one primary key in a table.
Question 21.
Gayatri’s parents are old and cannot manage their day-to-day routine on their own. Earlier Gayitri was staying with them and taking care of their needs. But now she has got transferred to another city so she hired Sunanda for their help. But some of the tasks like paying electricity and phone bills etc. are still on Gayitri’s part. [4]
(A) How can she manage to pay the bills from another city?
Answer:Bills can be paid using online transaction or e-transaction facility. For availing this facility, one would only need an internet connection and net banking facility which can be availed by credit/ debit card or UPI ID.
(B) Is it possible to purchase medicines for her parents from another city? How?
Answer:
Yes, she can also purchase medicines from another city by using online shopping facility. There are many applications available that offers online purchase of medicines on prescription basis.
(C) Name some of the applications that provide the facilities mentioned in (A) and (B)?
Answer:
Applications that provide facility of e-payment to pay your bills are: Paytm, Google Pay, PhonePe etc.
Applications used of e-shopping are Amazon, Flipkart, Myntra, eBay etc. The applications used specially for online purchasing of medicines are: PharmEasy, Netmeds, Truemeds etc.
(D) Define online shopping.
Answer:
Online shopping means the process of selling and buying goods and services on Internet platform. It is also known as e-shopping.