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 references 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. (1 × 5 = 5 Marks)
(i) ……………… controls all aspects of a paragraph’s appearance, such as text alignment, tab stops, line spacing, and borders, and can include character formatting.
(a) Page Style
(b) Character Style
(c) Cell Style
(d) Paragraph Style
Answer:
(d) Paragraph Style
(ii) How many levels of headings does Open Office Writer evaluate to build the Table of contents?
(a) 8
(b) 9
(c) 10
(d) 12
Answer:
(c) 10
(iii) Reema has created a pamphlet on ‘Tour to West India’. She has inserted many images to make it more presentable but the size of images is occupying a lot of space. Her friend has suggested her to reduce the size of images. Which of the following options will help her in doing the task without losing any content of the image?
(a) Recolor
(b) Docking
(c) Resize
(d) Rotate
Answer:
(c) Resize
(iv) ……………… is called as stress hormone.
(a) Adrenaline
(b) Endorphins
(c) Dopamine
(d) Serotonin
Answer:
(a) Adrenaline
(v) Macros are especially useful to ……………… the same way over and over again.
(a) repeat a task
(b) reject a task
(c) report a task
(d) comment a task
Answer:
(a) repeat a task
(vi) ……………… feature of Calc helps to track what data was changed, when the change was made, who made the change and in which cell the change has occurred.
(a) Record Changes
(b) Edit record
(c) Change record
(d) Macro
Answer:
(a) Record Changes
Question 3.
Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) Under Insert tab, __________ group contains the features like Shapes, ClipArt, etc. (1)
(a) Illustrations
(b) Shapes
(c) Paragraph
(d) Clipboard
Answer:
(a) Illustrations
(ii) __________ command is used to retrieve data from a database. (1)
(a) SELECT
(b) INSERT
(c) UPDATE
(d) None of these
Answer:
(a) SELECT
(iii) Instant messaging service accepts instant messages from __________ (1)
(a) external sites
(b) internal sites
(c) Both (a) and (b)
(d) None of these
Answer:
(a) external sites
(iv) Two other toolbars can be opened from the Picture Toolbar are: the __________ and __________ (1)
(a) Edit picture, Color picture
(b) Format, drawing
(c) Graphic Filter toolbar, Color toolbar
(d) Floating toolbar, Color toolbar
Answer:
(b) Format, drawing
(v) In the Subtotal dialog box, the __________ box is used to select the column to which you want to add the Subtotal to. (1)
(a) group by
(b) filter by
(c) consolidate by
(d) update by
Answer:
(a) group by
(vi) Commands are a set of instructions that are used to interact with the database. (1)
(a) SQL
(b) Java
(c) Mac
(d) DBMS
Answer:
(a) SQL
Question 4.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) Prateek has created a project report for his college assignment. After performing many changes in its formatting finally he is satisfied with the current one. Now he wants that every other project report should be based on this formatting by default. What should he do?
(a) Copy the styles of this document to every other document.
(b) Make the current document template as default template.
(c) Export styles in every document
(d) Create all other documents at the end of the existing document.
Answer:
(b) Make the current document template as default template
(ii) Aradhya wants to create a connection between the tables – Books and Members. Which option she should use to complete the task?
(a) Table
(b) Form
(c) Relationships
(d) Sorting
Answer:
(c) Relationships
(iii) Consider the following link: \users\Myfiles\data.xlsx Which type of link is this?
(a) Relative link
(b) Absolute link
(c) Hyperlink
(d) None of these
Answer:
(b) Absolute link
(iv) ……………… is the main building block of a database.
(a) Query
(b) Form
(c) Table
(d) All of these
Answer:
(c) Tables
(v) Which of the following should be avoided while doing instant messaging?
(a) Keep your message detailed
(b) Keep the conversation short
(c) Use proper punctuation
(d) Be aware of status message
Answer:
(a) Keep your message detailed
(vi) To make an online payment you must ensure that the URL must begin with
(a) HTTP
(b) FTP
(c) WWW
(d) HTTPS
Answer:
(d) HTTPS
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 the 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 do 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.
How can we self-motivate ourselves to complete a task that appears to be too large or too complex to be done by us? (2)
Answer:
For completing a task that appears to be too large or too complex to be done by us, we can break down the job into several smaller and easier tasks, each of which can be accomplished in a set period. This is possible only through self-motivating ourselves to find a workable solution to the task, as self-motivation is our ability to identify effective methods of thinking about something to taking action about it. Breaking down the job into smaller tasks comprises the thinking part, whereas accomplishing each small part of the task comprises the ‘taking action’ part.
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 to manage our behavior, thoughts, and emotions consciously and productively. Employees with strong self-management skills can achieve their goals within a timeline without going through stress.
Question 8.
Define the shortcut menu and its importance in Windows.
Answer:
A shortcut menu provides a quick way to access the commands that are used frequently. A shortcut menu can be invoked by right-clicking an object. These menus are context-sensitive, i.e., it depends on where your cursor is located. The shortcut menu is of great importance because all related commands are available at one click without having to search for them from different menus. It saves our time and effort.
Question 9.
Describe the following functions of an entrepreneur: (2)
(i) Innovation
(ii) Risk-Taking
Answer:
(i) Innovation It includes introducing new products, opening new markets, and new raw material sources, and new organizational structure.
(ii) Risk-Taking An entrepreneur has to take a risk by choosing one among various alternatives.
Question 10.
How does entrepreneurship contribute to a country’s economy?
Answer:
Entrepreneurship has a great role and contribution to a country’s economy. Some of them are listed below:
1. Generates Wealth: The entrepreneurs invest money and also attract funds from other investors. In this way the money is mobilized between investors, entrepreneurs, employees etc, and everyone is benefited.
2. Growth of Overall Economy: The growth of their business results in boosting other related sectors as well resulting in the growth of overall economy.
3. Increase in Per Capita Income: New startups will utilize more resources like labour, material and capital. In return they will produce new products and services thereby adding to national and per capita income.
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 theses, 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.
How to create the reference with the mouse in Calc? (2)
Answer:
Creating The Reference With The Mouse Look at the example below which shows a Marks Detail sheet with a blank Marks column. On the Marks detail sheet, set up a place for all five subject marks, so we know where to put the cell reference. We want to place the reference for the checking marks in cell B3. To make the cell reference in cell B3, select the cell and follow these steps.
- Click on the = icon next to the formula bar. The icon changes and an equals sign appears in the formula bars.
- Now, click on the sheet tab for the sheet containing the cell to be referenced. In this case, that is the Marks Detail sheet.
- Click on cell F3 in the Detail sheet.
- Click the green checkmark in the formula bar to finish.
Question 13.
What is a document hyperlink in a spreadsheet? [2]
Answer:
Document Hyperlink in a spreadsheet is defined as a reference to any location, webpage, or 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.
Databases can control data inconsistency. How?
Answer:
Data inconsistency means multiple mismatching copies of the same data. This happens when redundancy is not controlled. Redundancy refers to duplication of data, which can be controlled by assigning a primary key field. It keeps checking and does not allow duplicate data. By controlling redundancy, the inconsistency is also controlled.
Question 15.
Differentiate between wired and wireless access. Give one example for each type. (2)
Answer:
| Wired | Wireless |
| A wired setup uses physical cables or wires to transfer data between devices and computer systems. | A wireless setup does not use wires or cables to access the Internet. |
| Examples of wired access are Dial-up connection, DSL or Cable Internet Access. | Examples of wireless access are Wi-Fi and WiMAX. |
Question 16.
What is the significance of What-If analysis?
Answer:
What-if analysis allows users to explore multiple scenario options by comparing the outcomes of different alternative values on a single formula and ultimately make better decision. It can benefit managers to recognize options and impact from the changing values.
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.
Ram wants to compress a picture. Write the steps through which he can do so. (4)
Answer:
To resize an image:
- Click one time on the image to select it.
- From the Menu bar select: Format → Position and Size.
- Choose the Position & Size tab.
- Insert the desired image size and click the OK button.
Question 19.
The 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 the 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.
Garima has created a database for a Library that comprises two tables – Books and Members. Both the tables are related to each other. Explain some of the basic concepts of databases to Garima.
(A) What is the full form of DBMS and RDBMS?
(B) Differentiate between DBMS and RDBMS.
(C) Name the types of keys in a table.
(D) Differentiate between a primary key and a foreign key.
Answer:
(A) DBMS – Data Base Management System
RDBMS – Relational Data Base Management System
(B) A DBMS stores data in a file format and does not support distributed tables or databases, while an RDBMS data is stored in table format and it supports distributed tables or databases, i.e., the data is physically distributed across the network.
(C) A table can have the following types of keys – primary key, composite key, alternate key, candidate key, and foreign key.
(D) A primary key is a field that uniquely identifies the records in a table. A foreign key is a field in a relational database table that is the primary key in another table. A foreign key is used to establish the relation between data in two tables.
Question 21.
Reema has been appointed as an SME in an IT-based company. Tell her the following: (4)
(i) What is a workplace emergency?
(ii) Name the workplace emergencies that may happen.
Answer:
(i) A workplace emergency is an unforeseen situation that threatens your employees, customers, or the public; disrupts or shuts down workplace operations; or causes physical or environmental damage.
(ii) Emergencies may be natural or manmade and include the following:
- Floods
- Hurricanes
- Tornadoes
- Fires
- Toxic gas releases
- Chemical spills
- Radiological accidents
- Explosions
- Civil disturbances
- Workplace violence resulting in bodily harm and trauma.