Students must start practicing the questions from CBSE Sample Papers for Class 10 Information Technology with Solutions Set 6 are designed as per the revised syllabus.
CBSE Sample Papers for Class 10 IT Set 6 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) …………… refers to focusing human efforts for maintaining a healthy body and mind, capable of withstanding stressful situations.
(a) Artificial Intelligence
(b) Stress Management
(c) Motivation
(d) Emotional Intelligence
Answer:
(b) Stress management
(ii) Which of the following is not the benefit of stress management?
(a) Boosts immunity
(b) Reduces efficiency
(c) Improves mood
(d) Prevents behavioural problems
Answer:
(b) Reduces efficiency
(iii) ………………… are computer programs that can damage the data and software programs or steal the information stored on a computer.
(a) Spam
(b) Junk mail
(c) Viruses
(d) BIOS
Answer:
(c) Viruses
(iv) ……………… is a horizontal bar present at bottom of the Windows 7 desktop.
(a) Status Bar
(b) Menu Bar
(c) Task Bar
(d) Recycle bin
Answer:
(c) Task Bar
(v) State whether the following statement is a myth or reality:
Entrepreneurs are bom a certain way.
Answer:
The given statement is a myth. In fact, entrepreneurs are people who made a series of good decisions to chase success.
(vi) Which one of the following is not true for entrepreneurs?
(a) They create needs and demands.
(b) They provide raw materials.
(c) They do not create jobs.
(d) They help society by supporting infrastructure development.
Answer:
(c) They do not create jobs.
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. (1 × 5 = 5 Marks)
(i) Which one of the following is not an example of DBMS?
(a) PostgresSQL
(b) SQLite
(c) FoxPro
(d) Impress
Answer:
(d) Impress
(ii) A ……………… is an interface in a user specified layout that lets users to view, enter, and change data directly in, database objects such as tables.
(a) frame
(b) form
(c) relation
(d) report
Answer:
(b) form
(iii) Which of the following is expanded form of SQL?
(a) Systematic Query Language
(b) Structured Query Language
(c) Software Query Language
(d) Structural Query Language
Answer:
(d) Structural Query Language
(iv) ……………… is usually suitable for less amount of data.
(Relational/Flat file)
Answer:
Flat file
(v) Binary data types in a database can be used for storing
(a) photos, music files, etc.
(b) integer values
(c) only image files
(d) only video files
Answer:
(a) photos, music files, etc.
(vi) ……………… clause can be used with the SELECT statement in SQL to specify which rows to retrieve from the table.
(a) WHERE
(b) GROUP
(c) SAME
(d) SIMILAR
Answer:
(a) WHERE
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. (1 × 5 = 5 Marks)
(i) Aarti is experiencing abnormal behaviour of some applications in her computer. Some of her files have been converted to executable files with the extension ‘.exe’. What could be the possible reason for this?
(a) Phishing attack
(b) Spamming attack
(c) Virus attack
(d) Spyware attack
Answer:
(c) Virus attack
(ii) A password containing ………….. is not a good password.
(a) Date of birth
(b) Spouse’s or children’s name
(c) All lowercase or uppercase letters
(d) All of these
Answer:
(d) All of these
(iii) The SQL command UPDATE is used to modify ……………… in a table.
(a) Column name
(b) Data
(c) Column size
(d) Data type
Answer:
(b) Data
(iv) Which of the following is not specified while creating a report?
(a) Sorting
(b) Grouping
(c) Layout
(d) Form
Answer:
(d) Form
(v) Sharing of spreadsheets allows users to:
(a) Edit data in worksheet
(b) View data in worksheet
(c) Review changes in worksheet
(d) All of these
Answer:
(d) All of these
(vi) Applying ……………… means applying a group of formatting effects together.
(a) Template
(b) Style
(c) Group
(d) Font
Answer:
(b) Style
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.
What is self-management? Write any four self-management skills?
Answer:
Self-management skills are those characteristics that help a person to become more productive in the workplace. Such skills includes problem solving, resisting stress, communicating unambiguousLy, managing time, and exercising often are all key examples of self-management skills.
Question 7.
Goodies is a toy manufacturing company. The company has a policy to give a reward to their best employees in the annual meeting of the company. What kind of motivation is this? Also discuss another type of motivation you know about.
Answer:
Reward is a type of external motivation. It is also known as extrinsic motivation. Another type of motivation is internal or intrinsic motivation which comes from within oneself. Factors that are responsible for intrinsic motivation are love, joy, fear etc.
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 them from different menus. It saves our time and efforts.
Question 9.
What are the qualities that make an entrepreneur succeed?
Answer:
To become a successful entrepreneur, one must have following qualities:
An entrepreneur must have strong work ethics which means that they must always be focused towards growth of their business.
They should be passionate about their work. They must be self-motivated, self-disciplined and committed.
They must know the skill of meeting people whether they are clients, customers or employees.
Question 10.
How does entrepreneurship contribute to a country’s economy ?
Answer:
Entrepreneurship has a great role and contribution in 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 own business results in boosting other related sectors as well resulting in 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 (2 × 4 = 8 Marks)
Question 11.
Differentiate between blog and newsgroup.
Answer:
Blog | Newsgroup |
A blog is a frequently updated online personal journal or diary. | Newsgroups are internet discussion forums where group of people gather to discuss a common topic. |
Question 12.
To resize an image you use sizing handles.What are sizing handles?
Answer:
Sizing handles are the small black boxes Located at the borders and comers of an image. These boxes or handles allow the user to increase the size horizontally, vertically or diagonally. When the mouse pointer is placed on one of the sizing handles, the shape of the pointer changes to a double-headed arrow. You may then change the size by dragging the sizing handle.
Question 13.
Define the following terms:
(A) Data Consolidation (B) What-if analysis
Answer:
(A) Data Consolidation : It refers to the process of collecting the data from separate sources or worksheets and integrating them into a single worksheet by applying some formula or functions like sum, average, count etc.
(B) What – if Analysis : What-if analysis is the process of changing the values to see how the values will affect the results of formulas in the worksheet. There are three types of What-If analysis tools – Scenario, goal seek and solver.
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 check and does not allow duplicate data. By controlling redundancy, the inconsistency is also controlled.
Question 15.
The World Wide Web is different from other servers on the Internet. Explain how?
Answer:
The World Wide Web is a set of programs, standards and protocols that allows multimedia and hypertext files to be created, displayed and linked on the Internet. WWW is accessed though internet.
Internet is a computer-based worldwide communication network which is composed of a large number of smaller interconnected networks, it is an infrastructure.
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 (4 × 3 = 12 Marks)
Question 17.
Gaurav and his three more classmates are working on a school project in which they have to collect data of families and their income sources. They all want to work simultaneously to complete the project in time.
(A) Which option in the spreadsheet will help them to achieve their purpose?
(B) Gaurav himself is checking the changes done in the sheet by his friends. Which option should he use to check the changes done by them?
(C) Is it possible for Gaurav to decide which changes to apply or not in the sheet?
(D) Write a short note on the feature used in (B).
Answer:
(A) Multiple users can use a shared worksheet to work on it simultaneously.
(B) To check the changes done by other users he can enable the Track Changes option in the worksheet.
(C) yes, while reviewing the changes he can accept or reject the changes.
(D) Track changes is a feature that allows the spreadsheet users to keep track of the changes that they or other users make to a document. The users can also keep track on the comments of other users. All changes are recorded and are visualized for the purpose of review of a worksheet.
Question 18.
Sunita has to prepare a document in which she wants to add pictures with text.
(A) Name the feature that would help her add text with graphics.
(B) How can she resize an image?
(C) Name the sources from where she can add images to document.
(D) Define cropping.
Answer:
(A) To add text with graphics she can use the Text wrapping feature of the word processor. The text wrap feature refers to the placement of text along with an image.
(B) To resize an image, she can click on the image. It will show small black boxes called sizing handles on the borders of the image. Using one of the sizing handles drag the mouse pointer to resize it.
(C) Images in a document can be added from different sources. These sources can be any ’ image file stored in a folder, clipart, picture gallery and from online source.
(D) Cropping is the removal of unwanted area from an image. Cropping is done from the outer boundary of the image.
Question 19.
Consider the following table named ‘Items’ with details about stationery products being sold in the shop.
Item_Code | Item_Name | Brand | Price |
1001 | Pen | Dorns | 25.00 |
1002 | Pencil | Dorns | 10.00 |
1003 | Copy | Classmate | 50.00 |
(A) Which data type is used for the column Price?
(B) Write SQL Commands to:
(i) Display the name and price of products of Dorns brand
(ii) Add a new column Quantity.
(iii) Change the price by adding 10 to all the products of Classmate.
Answer:
(A) The Decimal data type is used for column Price column.
(B) (i) SELECT Name, Price FROM Items WHERE Brand = “Dorns”
(ii) ALTER TABLE Items ADD Quantity integer
(iii) UPDATE Items SET price = price + 10 WHERE brand = ”classmate”
Question 20.
Garima has created a database for a Library that comprises of 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 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 it 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 following types of keys – primary key, composite key, alternate key, candidate key and foreign key.
(D) A primary key is a field which uniquely identifies the records in a table. A foreign key is a field in relational database table that is primary key in another table. A foreign key is used to establish relation between data in two tables.
Question 21.
Sidharth wants to get an internet connection for his home. Explain the following types of internet connections.
(A) Dial Up connection
(B) Broadband
(C) WiMax
(D) WiFi
Answer:
(A) A dial up connection is a temporary connection setup between an ISP and a computer to provide internet to the connected computer. It is established using a telephone line and a modem device.
(B) The connection is established by dialling up the number provided by ISP. Broadband connections are established using cable, digital subscriber line or a satellite. It is faster than a dial up connection as the signal of a broadband connection can carry more data onto your computer.
(C) WiMax is a digital communication system that can provide broadband wireless access. For this it requires a WiMax base station which is a tower similar to a cell phone tower. Rather than using wires to establish a connection it uses microwave link for same.
(D) WiFi refers to the Wireless Fidelity, which lets you connect to the Internet without a direct line form an ISP to your PC. it requires a broadband internet connection, a wireless router and a computer with wireless internet card or adapter.