CBSE Sample Papers for Class 10 IT Set 9 with Solutions

Students must start practicing the questions from CBSE Sample Papers for Class 10 IT with Solutions Set 9 are designed as per the revised syllabus.

CBSE Sample Papers for Class 10 IT Set 9 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) There are many shoe and leather wear stores in Agra. Ankit also owns one. He has offered discounts to attract his customers and increase his sales. What could be his objective? [1]
(a) Growing
(b) Surviving
(c) Expanding
(d) All of these
Answer:
(b) Surviving

Explanation:
The objective of business survival refers to keeping the business operating in view of crisis or competition with other business owners. For the survival of business one can make plans and differentiate from others in the same business.

(B) Maria buys Stationery for her business from Ghaziabad. She learns that the stationery items are cheaper in Sadar Bazar in Delhi. So, she decides to start buying products from there. What type of entrepreneurial function she is doing? [1]
(a) Making decisions
(b) Divides income
(c) Takes risk
(d) All of the above
Answer:
(b) Divides income

Explanation:
The entrepreneur divides the business money to many groups. This includes spending money to buy material, pays rent of the building and salaries to people.

(C) …………………… is not a symptom of stress. [1]
(a) Increased sweating
(b) Cold hands or feet
(c) Dry mouth
(d) All of these
Answer:
(c) Dry mouth

Explanation:
Dry mouth is not a symptom of stress but the increased sweating and cold hands and feet are the symptoms of bad stress.

Related Theory:
Bad stress is a stress that is ongoing and does not lower down. Bad stress, or distress, can lead to anxiety, confusion, poor concentration and decreased performance.

(D) Which of the following is not a GUI operating system? [1]
(a) Windows
(b) Unix
(c) DOS
(d) Solaris
Answer:
(c)DOS

Explanation:
DOS is an operating system that is based on CUI i.e. Character User Interface.

Related Theory:
A CUI is an interface which works on commands that are typed in by the user. It does not shows widows, menus, icons etc on its interface.

(E) …………………… is called as stress hormone. [1]
(a) Adrenaline
(b) Endorphins
(c) Dopamine
(d) Serotonin
Answer:
(a) Adrenaline

Explanation:
Adrenaline is a hormone that is released in our body when there are increased stress levels. Another such hormone is Cortisol

Related Theory:
Endorphin, Dopamine and Serotonin are feel good hormones that are released in brain and help to cope up with stress.

(F) Which of the following is not required to keep a device cool? [1]
(a) Unplug the device when in use.
(b) Do not cover a laptop in blanket
(c) The computer’s CPU fan should properly work.
(d) The device should not be kept in direct heat.
Answer:
(a) Unplug the device when in use

Explanation:
A system does not get heated due to plugging in while working. The reason of it getting heated is due to the processing going on while working on the device. To keep your device cool the CPU fan should be working properly.

Question 2.
Answer any 5 out of the given 6 questions.
(A) …………………… help improve consistency in a document [1]
(a) Style
(b) Template
(c) Table of content
(d) Images
Answer:
(a) Style

Explanation:
A style is a predefined combination of font style, color, and size that can be applied to chapter headings, topic , headings and sub headings, paragraphs etc. It gives a similar formatting effects to the text with same type of style.

(B) Consider the hyperlink,.\datalist.mdb. [1]
It is a …………………… type of link.
(a) Relative
(b) Absolute
(c) Mixed
(d) None of these
Answer:
(a) Relative

Explanation:
The relative hyperlink refers to the path of the document from the current position. It does not shows the path from the topmost folder.

Related Theory:
The path that gives the complete address of the file beginning from the topmost folder, is called absolute hyperlink

(C) Which of the following is not an advantage of Computer network? [1]
(a) Sharing of Computer Hardwar
(b) Sharing of Computer Software
(c) Sharing messages
(d) Security issues
Answer:
(d) Security issues

Explanation:
Security issues is a disadvantage of computer network. There are many types of issues like malware, virus, data leakage etc. while working on a network.

(D) …………………… is used to send text messages online. [1]
(a) Email
(b) Instant messaging
(c) Blog
(d) Web server
Answer:
(b) Instant messaging

Explanation:
Instant messaging is a type of online chat allowing real-time text transmission over the Internet or another x computer network.

Caution:
Email is also used to send message to someone over the Internet but an email s transmitted from the sender’s computer to server and from there to the recipients server from where it can either be viewed or downloaded. Users are not required to be online for receiving a mail whereas Instant Messaging needs the users to be logged in to the same server for messaging to each other.

(E) To cancel the last edit, we use ……………… as shortcut key. [1]
(a) Ctrl + Y
(b) Ctrl + U
(c) Ctrl + E
(d) Ctrl + Z
Answer:
(d) Ctrl + Z

Explanation:
To cancel the last edit press Ctrl + Z which is a shortcut key to undo the previous action.

(F) ALTER TABLE command is used to [1]
(a) Add new columns in table
(b) Modify existing columns in table
(c) Change the name of existing column
(d) All of the above
Answer:
(d) All of the above

Explanation:
The syntax to add a new column is:
ALTER TABLE <tablename> ADD <columnnamexdatatype>[<constraint n ame>]
The syntax to modify an existing column is:
ALTER TABLE <tablename> MODIFY (columnname new datatype (new size)) [FIRST | AFTER column]
The syntax to change the name of column is:
ALTER TABLE <tablename> CHANGE [COLUMN] old_column_name new, column_name column_definition

Question 3.
Answer any 5 out of the given 6 questions.
(A) To add an image into a document you can use …………………… method. [1]
(a) Drag and Drop
(b) Insert picture
(c) Both (a) and (b)
(d) None of these
Answer:
(c) Both (a) and (b)

Explanation:
Using drag and drop method you can drag the image from the file browser window into the document The other method is by clicking Insert → Picture from the toolbar. Using this method ‘ you can insert image from the device and from the online source as well.

(B) In a spreadsheet, changes can also be made temporarily. This working mode is called …………………… . [1]
(a) Shared mode
(b) Formatting mode
(c) Record changes mode
(d) View mode
Answer:
(c) Record changes mode

Explanation:
The Record Changes mode or Tracking changes makes it possible to see which edits and changes occurred and when. This feature is helpful in reviewing a spreadsheet when multiple users has suggested changes in it

(C) …………………… connection uses public switched telephone network. [1]
(a) WiFi
(b) Dial up
(c) Cable internet
(d) WiMax
Answer:
(b) Dial up

Explanation:
Dial-up Internet access is a form of Internet access that uses the facilities of the public switched telephone network to establish a connection to an Internet service provider.

Caution:
Cable Internet Access is similar to DSL but it uses the cable television infrastructure. Cable Internet Access is provided through existing cable TV networks.

(D) …………………… are the numeric data types of a table field in a database. [1]
(a) Integer
(b) Decimal
(c) Both (a) and (b)
(d) None of these
Answer:
(c) Both (a) and (b)

Explanation:
In database Integer and Decimal both are numeric data types. Integer is used to store non decimal numbers and Decimal data type is used to store decimal type of numbers.

(E) …………………… command of SQL shows the table structure. [1]
(a) SELECT
(b) CREATE
(c) DROP
(d) DESC
Answer:
(d) DESC

Explanation:
DESC or DESCRIBE command allows to view the structure of an existing table.
Syntax
DESQ[RIBE] <tablename>

(F) Which of the following is not a component of Open Office Suite? [1]
(a) Writer
(b) Calc
(c) Excel
(d) Base
Answer:
(c) Excel

Explanation:
Excel is a spreadsheet application and is a part of MS Offce Suite.

Related Theory:
Open Office Suite consist of Write – a word processor. Base – database management system. Calc – spreadsheet and Impress – presentation application.

Question 4.
Answer any 5 out of the given 6 questions.
(A) In a word processor, scale refers to the …………………… of an image. [1]
(a) Angle
(b) Size
(c) Both (a) and (b)
(d) None of these
Answer:
(c) Both (a) and (b)

Explanation:
The scale in word processor refers to the height and width of the image. You can specify the scale at the time cT resizing and cropping the image.

Related Theory:
Angle is mentioned when you want to rotate the image upto a specific degree.

(B) Which of the following is an advantage of a macro? [1]
(a) They automate the repetitive key strokes
(b) Reduces possibility of human error
(c) Saves time
(d) All of the above
Answer:
(d) All of the above

Explanation:
Macros are very useful in spreadsheet as they reduces the efforts of user by automating the keystrokes. The combination of keystrokes in a specific order are stored and called macro.

(C) …………………… is an example of wired internet connectivity. [1]
(a) Dial up
(b) DSL
(c) Cable Internet Access
(d) All of these
Answer:
(d) All of these

Explanation:
All the given examples provides wired internet connectivity. Other type of connectivity is based on wireless technology.

Related Theory:
WiFi and WiMax are the examples of Wireless internet connectivity.

(D) In a spreadsheet, by default, the data is entered in …………………… form. [1]
(a) Forms
(b) Queries
(c) Macro
(d) Tabular
Answer:
(d) Table

Explanation:
In a spreadsheet every sheet is made up of rows and columns. So, the data is entered in rows and columns i.e., in tabular format.

(E) A pamphlet for school fare has to be designed. Which out of the following Office Suite components will help to complete the task? [1]
(a) Spreadsheet
(b) Digital Documentation
(c) Database Management
(d) Mail Merge
Answer:
(b) Digital Documentation

Explanation:
The Digital Documentation package has all the features by which one can design a pamphlet. It allows users to format text, add images and shapes and work on objects.

(F) The use of Caps Lock in chatting means …………………… . [1]
(a) Smiling while chatting
(b) Shouting
(c) Being afraid
(d) Complaining
Answer:
(b) Shouting

Explanation:
Use of Caps Lock should be avoided as it is equivalent to shouting.

Question 5.
Answer any 5 out of the given 6 questions.
(A) An existing table of contents can be changed. Which of the following changes can be applied on an existing table of contents? [1]
(a) The attributes of a TOC can be set.
(b) The TOC can be arranged in multiple columns.
(c) Character styles can be applied to individual level of headings.
(d) All of these
Answer:
(d) All of these

Explanation:
An existing table of contents can be changed or updated automatically or manually. You can delete any entry or change the page number of any topic in TOC.

(B) The interface is also called as …………………… . [1]
(a) Back-ends
(b) Front-ends
(c) Client
(d) None of these
Answer:
(b) Front-end

Explanation:
The interface with which user works is called the front-end. It is a screen which interacts with user to work upon records in database.

Related Theory:
The actual work is done by the database server which is also known as back-end. It works as per user instructions.

(C) ISP stands for …………………… . [1]
(a) Internet Special Provider
(b) Internet Service Provider
(c) Internet Sales Provider
(d) International Service Provider
Answer:
(b) Internet Service Provider

Explanation:
ISP or Internet Service provider provides an Internet connection and the services that you use on your computer for various internet services.

(D) Shalini wants to set the value for the roll number which is going to be incremented itself when a new row will be inserted. Which of the following field types should she use for this purpose? [1]
(a) Integer
(b) AutoNumber or AutoValue
(c) Decimal
(d) Primary
Answer:
(b) AutoNumber or AutoValue

Explanation:
In this type of field, the value gets automatically incremented. It is by default used as the primary key.

(D) The toolbar to format picture does not consists of …………………… option. [1]
(a) Grayscale
(b) Original
(c) Solver
(d) Watermark
Answer:
(c) Solver

Explanation:
Solver is a spreadsheet tool that can be used to determine how the desired outcome can be achieved by changing the assumptions in a model It is a type of what-if anaLysis and is useful when trying to determine the best outcome on a given set of more than two assumptions.

(F) The default date format in database is …………………… . [1]
(a) YYYY/MM/DD
(b) YYYY-MM-DD
(c) YYYY-DD-MM
(d) YYYY/DD/MM
Answer:
(b) YYYY-MM-DD

Explanation:
The default format of date is YYYY-MM-DD where first four digits depicts year, followed by a hyphen, followed by 2 digits of month, followed by a hyphen and last 2 digits day.

Related Theory:
The datatype used to make a field date type is DATE.

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.
Which are your favourite stress management techniques? Elaborate any two. [2]
Answer:
The stress management techniques are:
(A) Time Management: Time management has an important role in stress management If we manage time properly then all our tasks will complete on time and there will be no pressure of pending work on us.

(B) Physical exercises and meditation: Doing yoga, meditation and deep breathing exercises help in proper blood circulation and relaxes the body. This will help us in becoming more active.

(C) Sleep: Adequate amount of sleep at night is required to give rest to our mind and body. It helps the brain and body to get recharged to function better the next day.

(D) Recreational Activity: Going to meet a friend or visiting a new place during a vacation or holiday can help to break from the normal routine and come back fresh.
Note: write any two points.

Question 7.
What is the ABC of stress management? [2]
Answer:
The ABC model is an approach or strategy to deal with stress. The ABC refers to:
(A) Adversity or the stressful event: You should be aware of stress. Look out for signs of stress and the factors that push you to this point.
(B) Beliefs or the way you respond to the event: it is very important how you respond to and handle the stressful events.
(C) Consequences or actions and outcomes of the event: Find out what can be done to combat with negative causes of stress. Use time management and self-awareness tools to manage your time and work well.

Question 8.
Mention any four tips for the success of startup? [2]
Answer:
Success of a startup depends upon many factors. Some of them are listed below:
1. Alignment: The idea of startup should align with your passion or interests. You are more likely to sustain the effort required if you love the work what you are doing.

2. Desirability: The idea or startup should be researched first before starting it. The research would let you know what customer needs and accordingly you can plan the startup.

3. Flexibility: You cannot predict everything in advance. So, the business should be flexible enough to survive in most adverse situation that come across surprisingly.

4. Viability: The price or charges of services/ products provided by your startup should be in reach of your customer, so that they can pay adequate amount and the business may become self-sustainable.

Question 9.
What differences do you find between entrepreneurship and wage employment? [2]
Answer:

Entrepreneurship	Wage Employment
An entrepreneur works for himself by starting his own business.	Wage employed people work for a person or an organisation.
They do not get a salary get salary. Their income also is unstable.	They get a fixed payment or salary in return for theirof their work.
An entrepreneur has many roles to perform. His tasks depends upon his goals.	A waged employee just completes the given task.
They are always trying to make their business better by taking risks and trying new ideas.	They never take any risks and do not innovate in their work.

Question 10.
Differentiate between CUI and GUI. [2]
Answer:

CUI	GUI
CUI stands for Character User Interface also called Command Line Interface	GUI stands for Graphical User Interface.
Interaction between user and computer takes place in form of Commands.	Interaction takes place using graphics
Keyboard is used to provide input to the computer.	Input can be given using mouse or any other pointing device.
The Operating system with this interface shows a prompt on the screen where user can type in the desired command.	The GUI operating systems provides Windows, Icons, Menus and Pointers (WIMP) to accept command from the user.

Answer any 4 out of the given 6 questions in 20 – 30 words each.

Question 11.
Differentiate between styles and template. [2]
Answer:

Style	Template
A style is a set of formats that you can apply to selected pages, text, frames, and other elements in your document to quickLy change their appearance.	Templates ore the pre-formatted files that help you design interesting. convincing, and professional looking documents.

Question 12.
Differentiate between styles and template. [2]
Answer:
In mail merge, data source is the file that keeps records of all the recipients to whom letter is to be sent/ addressed, after merging it with the main document. To create data source, you can use any make use of any one of the following:

Spreadsheet e.g. Calc, Excel etc.,
Any specific type of address book such as contact list of Outlook,
Database e.g. Access, mySQL

Question 13.
Mention the two ways of referencing cells in other worksheets. [2]
Answer:
In a spreadsheet there are two different methods of referencing cells in other sheet
1. By creating the reference with the mouse: To create this type of reference both the spreadsheets must be open in order to construct the reference with the mouse. Click the = icon in the cell where the formula is to be entered. Now switch to the other spreadsheet and click on the reference cell. After this switch back to the original spreadsheet and click on the green check mark on the formula bar.

2. By entering the formula directly using the keyboard: To directly type the reference address you need three sections of the address: complete path to the file, Sheet name and cell address to which reference has to be made.
The format for the reference is –
=’file:///Path &File Name’#$SheetName.
CellName

Question 14.
List any two websites that allow online transactions. Also explain the benefits of online transactions. [2]
Answer:
Websites or web applications that permit online payment are PayPal, Google page, Google Pay etc.
Benefits of online transaction are as follows:

Online payments are faster than traditional payment methods such as cash or cheque.
There are multiple measures to ensure the security of online payments.
Online payments save time because you don’t have to stay for change especially when it is related to smaller denominations of money.
Payments can be done from anywhere and anytime.

Question 15.
To create a form or report in database you need some prerequisites. What are these? [2]
Answer:
Forms and reports in database are the formatted way to present data on screen or in printed form. To create both form and report you would need a source from where data can be taken. This source can be a table or a query in the database. Query will provide filtered data to the forms and reports whereas table will provide all the data stored in the table. You can also include selected fields from the table, to show in your form or report.

Question 16.
What do you understand by the term packet with reference to data transfer. [2]
Answer:
A packet, in networking, is a small amount of data sent over a network, such as LAN or the Internet. Thus, complete information or message is transferred in form of small packets. Each packet includes a source and destination as well as the content i.e„ data which is being transferred. After reaching their destination, these packets are reassembled into a single message or information same as sent from the sender’s end.

Answer any 3 out of the given 5 questions in 50 – 80 words each.

Question 17.
Shrawani has applied for a new job whose requirement is knowledge of Spreadsheet. So, she has joined an online course to Learn working on a Spreadsheet. Help her in understanding the concepts by writing a short note on the following. [4]
(A) Absolute hyperlink
Answer:
An absolute hyperlink is a type of document hyperlink in a worksheet which defines the complete path to reach the linked document, .i.e. from the top most folder. For e.g. \Users\Company\Sales.ods

(B) Relative hyperlink
Answer:
A relative hyperlink is a type of document hyperlink which defines the path of the linked document with respect to the active location. For e.g. \Sales.ods
The single and double dots before the files name denotes the current and parent folders respectively. For e.g. .\Sales. ods means that Sales.ods in same folder whereas ..\Salesods means the file is in parent folder.

(C) Data consolidation
Answer:
Data consolidation refers to the process of collecting data from separate worksheets into a master worksheet. In this process some specific formulas are also applied such as Sum,. Average, Count etc.

(D) What-if Analysis
Answer:
What -if analysis is the process of changing the values in a cell to know how those values will affect the outcome of the formulas used in the worksheet.

Question 18.
Ankit is creating flowcharts in word processor by using symbols provided in it. [4]
(A) Which feature of word processor can help him to accomplish the task?
Answer:
To place a text inside the symbols he can insert a ‘Text Box’ in the symbol.

(B) Write a short note on that feature.
Answer:
A text box is an object you can add to your document that lets you put and type the text anywhere in your document Text boxes can be useful for emphasizing a specific text and can also be helpful when you need to reposition the text anywhere in the document.

(C) The flowchart consists of many symbols and text along with the symbols. Ankit wants to change the size of the symbols but selecting each of them together is very difficult. What can he do to select them together on a single click?
Answer:
To select all the objects together in a single click you can group them together. By grouping several objects together, you can format multiple objects at once rather than formatting each object individually. To select multiple objects, hold the Shift (or Ctrl) key and click the objects. Now click on Format → Group command.

(D) He wants to change one or two symbols. How can he revert the changes made by him previous step?
Answer:
To revert the changes select the group of objects and then click on Format → Ungroup. The selected group of objects will break apart

Question 19.
Consider the following table named ‘Product’ with details about baby products being sold in the showroom.

(A) How many fields and records are in the given table?
(B) Write SQL Commands to:
(i) To create the above table.
(ii) Display the name and price of products available for both boys and girls.
(iii) Display the name, colour and price of all products.
(iv) Change the colour to Blue of the item whose product code is 1093.
Answer:
(B) (i) CREATE TABLE Product
{ Pro_code integer PRIMARY KEY Pro_Name varchar (20)
Colour varchar(15)
Price decimal
Gender varchar(lO)}
(ii) SELECT Name, Price FROM Product WHERE Gender = “Uni”
(iii) SLELECT Name, Price, Colour FROM Product

Question 20.
Gaurav is a Marketing Head in Swift Technologies Pvt. Ltd. He asked his office assistant, Snaina, to prepare the monthly sales report of all sales executives in Delhi, Noida, Gurugram and Ghaziabad. [4]
(A) Which database feature she can use to present the records?
Answer:
She can use Report feature of database to present the records. A report is a database object that is used to present the information, kept in table, in a summarized form. The outcome of report is useful for decision-making and analysis. A report can be created using Report Wizard.

(B) She prepared the report in the order the records were originally stored in the database. But Gaurav told her that the records should be listed in such a way that the highest sale should be shown on the top followed by the second highest and so on. What should Sunaina do to get the records as toLd by Gaurav?
Answer:
To arrange the records from highest to lowest order, she can use the Sort feature while creating report using wizard.

(C) Write a short note on the feature used by Sunaina in (B).
Answer:
The Sort feature will present the records in arranged manner as desired. The sorting in Report Wizard is done by providing the name of the field in ‘Sort By’ box.
Also mention the order i.e. Ascending or Descending to get the desired result.

(D) Again Gaurav told him to arrange records of same city together and the sales of each city, as told previously, should be shown in descending order. Which feature of report can help Sunaina to generate report like this?
Answer:
This can be done by grouping feature of Report Wizard. She can organize the report by selecting the fields into which she wants to group data. The Report Wizard asks for Grouping the data. The field, according to which you want to group the data, is given in the ‘Group By’ text box. The report will be organized by grouping the information together.

Question 21.
Shridhar is a story writer. He has written many books but now the people has lost their interest in reading novels and story books. He wants to follow his passion of writing blogging. Help him by solving his queries regarding blog. [4]
(A) What is a blogging?
Answer:
Blogging is an act of writing and self publishing the posts online. It also includes self publishing of photos and other media.

(B) What is a blog and a blogger?
Answer:
A website that consists of personal writings, comments, photographs, other media contents for other people to read or view is called a blog. It is like an online diary or journal.
The person who writes or posts blogs is called a blogger.

(D) What is offline blog editor?
Answer:
An offline blog editor is an editor that allows the blogger to create new posts without an Internet connection. These posts can be uploaded later using Internet connection. Some popular offline blog editors are MS Word, Writer, Blog Jet etc.