Students must start practicing the questions from CBSE Sample Papers for Class 10 IT with Solutions Set 8 are designed as per the revised syllabus.
CBSE Sample Papers for Class 10 IT Set 8 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) Eustress is the term given to ……………………………. . [1]
(a) Good stress
(b) Bad stress
(c) Distress
(d) None of these
Answer:
(a) Good stress
Explanation:
Good stress is referred to as Eustress by psychologists. It is the type of stress we feel when we are excited e.g., while riding a roller coaster, competing in a game etc. it brings positive effects on over all well being of a person.
(B) ……………………………. refers to the ability to understand feelings and emotions. [1]
(a) Understanding emotions
(b) Emotional intelligence
(c) Emotional IQ
(d) Managing emotions
Answer:
(b) Emotional intelligence
Explanation:
Emotional understanding is an ability to identify and manage one’s own emotions, as well as the emotions of others.
(C) What is a clipboard in Windows? [1]
(a) Board with a clip where you can keep your files.
(b) Type of file where you copy your file
(c) Location on your disc where you temporary keep files
(d) Temporary memory buffer to store data for short term
Answer:
(d) Temporary memory buffer to store data for short term
Explanation:
A clipboard is a temporary memory buffer in Random Access Memory used to store data for short term in a computer application. It is provided by the operating system and is used to hold copied or cut data temporarily while transferring or pasting within and between application programs.
Caution:
The data deleted from any application program is not stored in clipboard.
(D) Which of the following damages is not caused by Virus? [1]
(a) Delete files
(b) Slow down computer
(c) UPS failure
(d) Invade your email program
Answer:
(c) UPS failure
Explanation:
UPS failure cannot be caused due to VIRUSvirus. Virus only damages the applications or software in the computer. It cannot physically damage computer hardware.
Related Theory:
Computer virus is a malicious program that cause damage to files or data on a system.
(E) The main aim of entrepreneurship is to create ……………………………. for society’s welfare. [1]
(a) Leaders
(b) Jobs
(c) Products
(d) Solutions
Answer:
(d) Solutions
Explanation:
Entrepreneurship ventures provides innovative products.
(F) Taking risks and mitigation refers to ……………………………. [1]
(a) Planning in advance for calculated risks
(b) Taking right decision at right time
(c) Balancing the time between different roles
(d) Delegating tasks and authority
Answer:
(a) Planning in advance for calculated risks
Explanation:
It is a role of an entrepreneur to plan in advance so that the calculated or assumed risks are taken for the betterment of the business.
Question 2.
Answer any 5 out of the given 6 questions.
(A) Kavya has created a document containing many paragraphs. She has formatted, the document very professionally using styles. Now she wants to format a block of text differently in between some of the paragraphs. Which of the following style she should use for this? [1]
(a) Paragraph style
(b) Frame style
(c) Character style
(d) Page style
Answer:
(c) Character style
Explanation:
A character style helps in formatting a block of text, i.e. a single character, word or a phrase.
(B) Text wrapping means [1]
(a) Placing text inside an image
(b) Placing text around an image
(c) Placing text behind an image
(d) Placing text adjacent to the image
Answer:
(b) Placing text around an image
Explanation:
The positioning of an image with text can be controlled by text wrapping feature. Using this feature you can place the text around an image. The Wrap setting determines how the text will appear with an image or any other graphics.
(C) To perform subtotals in a worksheet, the field on which you want to perform subtotal is defined by ………………….. option. [1]
(a) Data → Consolidate
(b) Data → Subtotal
(c) Home → AutoSum
(d) Data → Group
Answer:
(b) Data → Subtotal
Explanation:
While working with a large amount of data the ‘Subtotal’ command lets you calculate the subtotal for the given data. It allows users to create groups and perform functions like Sum, Average, Min, Max.
Caution:
The data on which you want to perform subtotal should be arranged on the basis of the field that you are using to group for subtotal.
(D) Shreya is buying a new car from her own salary. She wants to find out what monthly installment she has to pay to repay the car Loan. She is checking the amount by varying the number of installments. What type of analysis is she doing? [1]
(a) Goal Seek
(b) Scenario
(c) Solver
(d) Consolidation
Answer:
(b) Scenario
Explanation:
A scenario is a type of What- If analysis in which you can store multiple values of data in the same cells. This helps in comparing the results of varying input values.
(E) Clicking on ……………………………. opens the linked document or sheet. [1]
(a) Path
(b) Sheet tab
(c) Hyperlink
(d) All of these
Answer:
(c) Hyperlink
Explanation:
A hyperlink is a link, clicking on which takes the user to another location in the current workbook or opens the linked document, worksheet or an image file.
Related Theory:
There are two types of hyperlinks in Excel : Relative hyperlink and absolute hyperlink.
(F) ……………………………. is an interactive way to create tables in a database. [1]
(a) Tables Tab
(b) Design view
(c) Datasheet view
(d) Table wizard
Answer:
(d) Table wizard
Explanation:
Table wizard is a simplest way to create tables in a new or existing database. It is a database utility designed to simplify the execution of complicated tasks.
Question 3.
Answer any 5 out of the given 6 questions.
(A) Duplication of data is called : [1]
(a) Redundancy
(b) Inconsistency
(c) Consistency
(d) Foreign key
Answer:
(a) Redundancy
Explanation:
Data duplication in DBMS is called data redundancy, it can be controlled by declaring a field of every table of the database as a primary key.
(B) The posts in a blog are arranged in ……………………………. order. [1]
(a) Chronological
(b) Reverse chronological
(c) Alphabetical
(d) Numerical
Answer:
(b) Reverse chronological
Explanation:
Reverse chronological order means that the latest or the most recent content is shown at the top of the page.
Related Theory:
A blog post is any article, news piece, or guide that is published on any blogging site such as WordPress, Blogger etc A blog post may cover a specific topic which is educational or informative in nature It may include images, videos, interactive charts etc.
(C) Which of the following cannot be done using Forms in database? [1]
(a) Adding records
(b) Deleting records
(c) Editing records
(d) Modify table design
Answer:
(d) Modify table design
Explanation:
A Form in database is an interactive tool used to get data from the user. It is a user-friendly interface also used to edit, delete and search records in databases.
Related Theory:
Table Design view in a database is used to change the structure of the table.
(D) Saumya has created a macro in her worksheet to simplify some of the tasks that she has to perform very frequently. To execute that macro she has to use the Run Macro command. How can she use macro directly without giving the command? [1]
(a) By saving macro in the worksheet
(b) By making function of the macro
(c) By recording the macro
(d) All of these
Answer:
(b) By making function of the macro
Explanation:
Macros can also be used as any other function in a spreadsheet. For making a macro behave like a function you have to make little changes in the code of the macro. Enclose the code of macro between Function <function name> and End Function commands.
(E) Which of the following are the uses of mail merge? [1]
(a) Creating letters
(b) Creating Labels
(c) Creating bulk email
(d) All of these
Answer:
(d) All of these
Explanation:
Mail merge is a tool of word processor that is used to merge and create personalized letters. The other uses of mail merge are creating mailing labels, envelopes and bulk email and fax distributions.
(F) The device that converts signals travelling over phone lines to be used by a computer is : [1]
(a) Switch
(b) Modem
(c) Hub
(d) Wifi
Answer:
(b) Modem
Explanation:
The term modem is a combination of “modulate” and “demodulate”. A modem is a network device that converts analog signals travelling in phone lines to digital signal for computer and vice versa.
Question 4.
Answer any 5 out of the given 6 questions.
(A) 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? [1]
(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
Explanation:
Every word processor has a default template based on which you can create your new document. You can also set your own template as a default template which will create every document based on the styles used in that template.
(B) Aradhya wants to create a connection between the tables – Books and Members. Which option she should use to complete the task? [1]
(a) Table
(b) Form
(c) Relationships
(d) Sorting
Answer:
(c) Relationships
Explanation:
In a database, a relationship is a situation that exists between two relational database tables having one field in common. This field is declared as the primary key in one table and a foreign key in another table. Relationships allow relational databases to split and store data in different tables.
(C) Consider the following link: \users\Myfiles\data.xlsx
Which type of link is this? [1]
(a) Relative link
(b) Absolute link
(c) Hyperlink(d) None of these
Answer:
(b) Absolute link
Explanation:
An absolute hyperlink is a type of link which tells the path of the document starting from the topmost folder.
Related Theory:
A relative hyperlink is a type of link which tells the path of the document starting from the current location.
(D) ………………………. is the main building block of a database. [1]
(a) Query
(b) Form
(c) Table
(d) All of these
Answer:
(c) Tables
Explanation:
Database is a collection of information that is related to a particular subject. It is a collection of tables.
Related Theory:
A table is a storage container where actual data is stored; Forms are the interface used to interact with data; Queries lets you filter the data according to some criteria; and the data can be printed in the form of reports.Forms, queries and reports all use data from these tables.
(E) Which of the following should be avoided while doing instant messaging? [1]
(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
Explanation:
Detailed messages while using instant messaging should be avoided. messages should be kept short and polite.
(F) To make an online payment you must ensure that the URL must begin with [1]
(a) HTTP
(b) FTP
(c) WWW
(d) HTTPS
Answer:
(d) HTTPS
Explanation:
The URL that begins with HTTPS is safe for online payments. These offers secure connections and no one can see your private information. Secured sites also have a closed padlock sign.
Question 5.
Answer any 5 out of the given 6 questions.
(A) 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? [1]
(a) Phishing attack
(b) Spamming attack
(c) Virus attack
(d) Spyware attack
Answer:
(c) Virus attack
Explanation:
Virus is a malicious software that when entered into the computer damages the files and applications. The system starts showing abnormal behaviour and also performs some activities other than normal. The files are corrupted and they may also change their type.
(B) A password containing ……………………….. is not a good password. [1]
(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
Explanation:
A good and strong password should not consist of personal information. It should be made with a mix of uppercase, Letters, Lowercase Letters, digits and symbols.
Related Theory:
A password should not be repeated on different websites.
(C) The SQL command UPDATE is used to modify …………………….. in a table. [1]
(a) Column name
(b) Data
(c) Column size
(d) Data type
Answer:
(b) Data
Explanation:
The UPDATE command is a DML command that Lets you modify data in a table. To specify the row where data is to be changed you can use WHERE clause. E.g. UPDATE student SET course = “BBA” WHERE course = “BOOM”
Related Theory:
The SET keyword is used to define the new data in place of the existing one.
(D) Which of the following is not specified while creating a report? [1]
(a) Sorting
(b) Grouping
(c) Layout
(d) Form
Answer:
(d) Form
Explanation:
Form is an interface to enter, edit and search record. These are not used to see or print reports.
(E) Sharing of spreadsheets allows users to: [1]
(a) Edit data in worksheet
(b) View data in worksheet
(c) Review changes in worksheet
(d) All of these
Answer:
(d) All of these
Explanation:
When a spreadsheet is shared, multiple users are allowed to view, edit and review changes in the document. The changes made in the document by multiple users are recorded and can be reviewed for final acceptance of the changes done in it.
(F) Applying ……………………… means applying a group of formatting effects together, [1]
(a) Template
(b) Style
(c) Group
(d) Font
Answer:
(b) Style
Explanation:
Style is a collection of formatting information and settings for the text in a document. It is saved by a name and can be used anywhere in the document for consistent formatting.
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.
What is self-management? Write any four self-management skills? [2]
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. [2]
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. [2]
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? [2]
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 ? [2]
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.
Question 11.
Differentiate between blog and newsgroup. [2]
Answer:
| Blog | Blog |
| 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? [2]
Answer:
Sizing handles are the small black boxes Located at the borders and corners 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 [2]
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? [2]
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? [2]
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? [2]
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.
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. [4]
(A) Which option in the spreadsheet will help them to achieve their purpose?
Answer:
Multiple users can use a shared worksheet to work on it simultaneously.
(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?
Answer:
To check the changes done by other users he can enable the Track Changes option in the worksheet.
(C) Is it possible for Gaurav to decide which changes to apply or not in the sheet?
Answer:
yes, while reviewing the changes he can accept or reject the changes.
(D) Write a short note on the feature used in (B).
Answer:
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. [4]
(A) Name the feature that would help her add text with graphics.
Answer:
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) How can she resize an image?
Answer:
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) Name the sources from where she can add images to document.
Answer:
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) Define cropping.
Answer:
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.
(A) Which data type is used for the column Price.
Answer:
The Decimal data type is used for column Price column.
(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:
(i) SELECT Name, Price FROM Items WHERE Brand = “Doms”
(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. [4]
(A) What is the full form of DBMS and RDBMS?
Answer:
DBMS – Data Base Management System
RDBMS – Relational Data Base Management System
(B) Differentiate between DBMS and RDBMS.
Answer:
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) Name the types of keys in a table.
Answer:
A table can have following types of keys – primary key, composite key, alternate key, candidate key and foreign key.
(D) Differentiate between a primary key and foreign key.
Answer:
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. [4]
(A) Dial Up connection
Answer:
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) Broadband
Answer:
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
Answer:
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
Answer:
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.