myCBSEguide

Class 10 - Information Technology (402)

Sample Paper - 06 (2022-23)

Maximum Marks: 50

Time Allowed: : 2 hours

General Instructions:

1. Please read the instructions carefully.

2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
3. Section A has Objective type questions whereas Section B contains Subjective type questions.
4. 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.
5. All questions of a particular section must be attempted in the correct order.
6. SECTION A - OBJECTIVE-TYPE QUESTIONS (24 MARKS):
i. This section has 05 questions.
ii. Marks allotted are mentioned against each question/part.
iii. There is no negative marking.
iv. Do as per the instructions given.
7. SECTION B - SUBJECTIVE TYPE QUESTIONS (26 MARKS):
i. This section has 16 questions.
ii. A candidate has to do 10 questions.
iii. Do as per the instructions given.
iv. Marks allotted are mentioned against each question/part.

SECTION A: OBJECTIVE TYPE QUESTIONS

1. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)
i. ________ is the ability to plan and control how you spend the hours of your day well and do all that you want to do.
a) Time management
b) None of these
c) Goal management
d) Self management
ii. ________ stress makes a person worried some, less productive and may lead to various disorders.
a) Negative
b) Positive
c) None of these
d) Both negative and positive
iii. Which of the following is not essential to shut down your computer?
a) Switch off monitor
b) Close all running applications
c) Save all opened files
d) Cut off the power supply
iv. Windows displays various options to shut down. Which is suitable at the end of the day?
a) Sleep
b) Restart

Copyright © myCBSEguide.com. Mass distribution in any mode is strictly prohibited.

1/9
myCBSEguide
c) Hibernate
d) Shut down
v. Which of the following is a disadvantage of entrepreneurship as a career?
a) Ambition fulfilment
b) Independence
c) Uncertainty
d) None of these
vi. Innovation of an entrepreneur includes
a) introducing new products
b) opening new markets
c) division of work
d) both opening new markets and introducing new products
To practice more questions & prepare well for exams, download myCBSEguide App. It provides complete study material
for CBSE, NCERT, JEE (main), NEET-UG and NDA exams. Teachers can use Examin8 App to create similar papers with
their own name and logo.
2. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. The Wrap text option is present under the ________ tab in the Arrange group.
a) Design/format
b) Review/Page layout
c) Format/Page layout
d) View/Page Layout
ii. Document (in mail merge) which contain the common data is called ________.
a) None of these
b) Main Document
c) Common Document
d) Data source
iii. What is the shortcut to see non-printing characters in Writer?
a) Ctrl + F10
b) Ctrl + F1
c) Ctrl + F11
d) Ctrl + F12
iv. ________ menu have the option to group drawing object in Writer.
a) Format
b) View
c) Edit
d) Insert
v. You can insert ________ file formats within a Word processor document.
a) PDF file
b) Excel spreadsheet
c) All of these
d) Power point presentation
vi. Which option is available in crop page?
a) Both Keep Scale and Keep image size
b) Keep Scale
c) Keep image size
d) None of these

Copyright © myCBSEguide.com. Mass distribution in any mode is strictly prohibited.

2/9
myCBSEguide
3. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. In Subtotals, we can select up to ________ groups of arrays.
a) 2
b) 4
c) infinite
d) 3
ii. A ________ is a saved sequence of commands or keystrokes that are stored for later use.
a) Consolidate
b) Macro
c) Autosum
d) Solver
iii. By default sheets tab are present at the ________ of the spreadsheet.
a) Bottom
b) Top
c) None of these
d) Both top and bottom
iv. Which of the following formulas is not entered correctly?
a) 10+50
b) = B7*B1
c) = 10+50
d) = B7+14
v. Which command will you choose to convert a column of data into row?
a) Edit >> Paste Special >> Transpose
b) Cut and Paste
c) None of these
d) Both Cut, Paste and Edit >> Paste Special >> Transpose
vi. Which types of charts can excel produce?
a) Only line graphs
b) Bar charts, line graphs and pie charts
c) Bar charts and line graphs only
d) line graphs and pie charts only
4. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. ________ data types are used for storing photos, music files etc.
a) Binary
b) Numeric
c) Alphanumeric
d) Special
ii. Computer-based record-keeping system is known as
a) Computerised Record Keeping System
b) Data Manipulation System
c) Computerised Data System
d) DBMS
iii. All the values in ________ are of same type.
a) Fields
b) Records
c) Database

Copyright © myCBSEguide.com. Mass distribution in any mode is strictly prohibited.

3/9
myCBSEguide
d) Table
iv. There are ________ types of relationship which can be created between tables.
a) three
b) two
c) four
d) infinite
v. ________ represent a single data item in a table.
a) All of these
b) Tuples
c) Attributes
d) Relation
vi. Auto Value is a property of ________ data type.
a) Date
b) Binary
c) Character
d) Numeric
5. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. Home page helps viewers to find out what they can find on the particular site? Home page is the
a) None of these
b) index page
c) first page of a website
d) about page
ii. Computer connected with LAN
a) can share information or peripheral devices
b) can e-mail
c) go online
d) work fast
iii. To join the Internet, the computer has to be connected to a
a) Internet architecture board
b) none of these
c) Internet Service Provider
d) Internet society
iv. A group of computers connected together with the help of cables within an office building is called
a) LAN
b) PAN
c) MAN
d) WAN
v. Which of the following is not a transmission medium?
a) Microwave
b) Co-axial cable
c) Modem
d) Telephone line
vi. What can you do with the Internet?
a) Exchange inform ation with friends and colleagues
b) Find diverse perspective on issues from a global audience
c) Internet exchange information, access pictures, find diverse perspectives on issues from a global audience.

Copyright © myCBSEguide.com. Mass distribution in any mode is strictly prohibited.

4/9
 myCBSEguide
d) Access pictures, sounds, video clips and other media elements
SECTION B (Employability Skills)
6. What is environmental stress?
7. How stress can be caused by both good and bad experiences?
8. What do you mean by sorting?
9. Define an entrepreneur.
10. What are the myths of entrepreneurship? Explain.
SECTION B (Subject Specific Skills) Short Answers
11. Distinguish between odd page break and even page break.
12. Define MS-Word 2007.
13. Define the meaning of the formula.
14. Define the following data types
i. AutoNumber
ii. Currency
iii. Text
15. Damini is a programmer in an institute and is asked to handle the records containing information of students. Suggest any
5 fields name and their data type of students database.
16. Write down any three points of differences between LAN, MAN and WAN.
SECTION B (Subject Specific Skills) Long Answers
17. Sona wants to add her pictures in a Word document.
i. Which tab she should use?
ii. Which command she should use to open Insert Picture dialog box?
iii. Can she resize the image?
iv. Is it possible to wrap text around an image?
To practice more questions & prepare well for exams, download myCBSEguide App. It provides complete study material
for CBSE, NCERT, JEE (main), NEET-UG and NDA exams.
18. How can conditional formatting be used to identify duplicates in excel? Write the steps.
19. Write the steps to save a query in MS Access.
20. Write SQL queries for the questions from (i) to (v) on the basis of table class.
No Name Stipend Subject AvgMark Grade
01 Vikas 1200 Medical 67 B
02 Boby 1400 Humanities 78.4 B
03 Tarun 1000 Medical 64.8 C
04 Varun 1600 Non-medical 84 A
05 Atul 1800 Non-medical 92 A
i. Select all the non-medical stream students from the class table.
ii. List the names that have grade A sorted by stipend.
iii. Arrange the records of class name wise.
iv. List the records whose grade is B or C.
v. Insert the new row with the following data. (06, 'Jack', 2800, 'Humanities', 98, 'A')
21. Pawan is working in a private company in New Delhi. He has to visit his hometown in Madhya Pradesh. He went to New
Delhi Railway Station and stood up in a queue at the reservation counter but could not get the ticket as time was over. His
friend suggested that he should use an online ticketing website. 
i. How is Online shopping useful?
ii. List any one website that Pawan can use for his online ticket bookings.

Copyright © myCBSEguide.com. Mass distribution in any mode is strictly prohibited.

5/9
myCBSEguide

Class 10 - Information Technology (402)

Sample Paper - 06 (2022-23)

Solution

SECTION A: OBJECTIVE TYPE QUESTIONS

1. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)
i. (a) Time management

Explanation: Time management

ii. (b) Positive

Explanation: Positive
iii. (a) Switch off monitor

Explanation: Switch off monitor

iv. (d) Shut down

Explanation: Shut down

v. (c) Uncertainty

Explanation: Uncertainty
vi. (d) both opening new markets and introducing new products

Explanation: both opening new markets and introducing new products

To practice more questions & prepare well for exams, download myCBSEguide App. It provides complete study
material for CBSE, NCERT, JEE (main), NEET-UG and NDA exams. Teachers can use Examin8 App to create similar
papers with their own name and logo.
2. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. (a) Design/format

Explanation: Design/format
ii. (b) Main Document

Explanation: Main Document

iii. (a) Ctrl + F10

Explanation: Ctrl + F10

iv. (a) Format

Explanation: Format
v. (c) All of these

Explanation: All of these

vi. (a) Both Keep Scale and Keep image size

Explanation: Both Keep Scale and Keep image size

3. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. (d) 3

Explanation: 3
ii. (b) Macro

Explanation: Macro
iii. (a) Bottom

Explanation: Bottom
iv. (a) 10+50

Explanation: 10+50
v. (a) Edit >> Paste Special >> Transpose

Explanation: Edit >> Paste Special >> Transpose

Copyright © myCBSEguide.com. Mass distribution in any mode is strictly prohibited.

6/9
myCBSEguide
vi. (b) Bar charts, line graphs and pie charts

Explanation: Bar charts, line graphs and pie charts

4. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. (a) Binary

Explanation: Binary
ii. (d) DBMS

Explanation: DBMS is a collection of programs that enable users to create and maintain databases. Also, it is a
computer-based record-keeping system.
iii. (a) Fields

Explanation: Fields
iv. (a) three

Explanation: three
v. (b) Tuples

Explanation: Tuples
vi. (d) Numeric

Explanation: Numeric
5. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. (c) first page of a website

Explanation: The home page refers to the initial or main or first web page of a website, sometimes called the front
page. It can help the viewers to find out what they can find on a particular site.
ii. (a) can share information or peripheral devices

Explanation: A computer connected with LAN can share information or peripheral devices.
iii. (c) Internet Service Provider

Explanation: Internet Service Provider is used to join the Internet.

iv. (a) LAN

Explanation: Using LAN, we can connect computers within a building only.

v. (c) Modem

Explanation: Telephone lines, co-axial cable and microwave are transmission medium but modem is a network
device that converts analog signal to digital signal and vice-versa.
vi. (c) Internet exchange information, access pictures, find diverse perspectives on issues from a global audience.

Explanation: Internet exchange information, access pictures, find diverse perspective on issues from a global
audience.
SECTION B (Employability Skills)
6. It is a response to happenings around us that cause stress such as noise, pollution, crowding, the pressure of work, family
tensions, etc.
7. Stress can be caused by both good and bad experiences like when people feel stressed by something going on around
them, their bodies react by releasing chemicals into the blood. These chemicals give more energy and strength, which
can be a good thing if their stress is caused by physical danger but it can also be a bad thing if the stress is in response to
something emotional and there is no outlet for this extra energy and strength. Good stress is called eustress, whereas bad
stress is termed distress.
8. Sorting basically helps in the arrangement of data in the correct order.
9. An entrepreneur is someone who perceives opportunity, organizes resources needed for exploiting that opportunity, and
exploits it.
10. The common set of myths of entrepreneurship are explained below:
Starting a Business is Easy: In reality, it is a very difficult and challenging process to start a successful business.
The rate of failure is high but small entrepreneurship is comparatively easier to start.

Copyright © myCBSEguide.com. Mass distribution in any mode is strictly prohibited.

7/9
myCBSEguide
A lot of Money to Finance New Business: Successful entrepreneurs design their business with little cash also.
Start-ups can’t be Financed: Under a scheme like MUDRA, entrepreneurs can raise loans from banks.
Talent is More Important than Industry: This is not true as the nature of the industry an entrepreneur chooses
greatly effects the success and growth of the business.
Most Start up’s are Successful: Mostly in developing countries start-up's fail as they could not manage to earn
high profits.
SECTION B (Subject Specific Skills) Short Answers
11. The difference between odd page break and even page break is that odd page break will insert a section break into your
Word document that will break to the next odd page in the Word document while even page break will insert a section
break into your Word document that happens on every even page of your Word document.
12. MS-Word 2007 is a Word processing software package, which allows you to easily create a variety of professional-
looking documents like letters, reports, and other documents using features such as Themes, Styles, SmartArt and more.
It is a powerful tool that you can use to create effective documents.
13. Formulas in Excel are used to perform calculations on data entered into the formula cell. Formulas begin with an equal
(=) sign and are entered into the worksheet cell(s) where you want the results to appear.
14. i. AutoNumber: It allows to store numbers that are automatically generated for each record. It increases the number
automatically.
ii. Currency: It allows to store monetary values that can be used in calculations accurate upto 15 digits on L.H.S and 4
digits on R.H.S of decimal points.
iii. Text: It allows to store text or combination of text and numbers, as well as numbers that don’t require calculations
such as phone numbers.

15. Field Name Data Type

RollNo Number
Name Text
Class Text

Section Text
Gender Text
16. Three major points of differences among LAN, MAN and WAN are as follows:
Basis LAN MAN WAN
Geographic Generally within a building Within a city Across the continents

Distance Upto 5 km Upto 160 km Unlimited

Speed 11 to 54 Mbps 11 to 100+ Mbps 10 + 384 Kbps, 1.83 to 7.2 Mbps
SECTION B (Subject Specific Skills) Long Answers
17. i. Insert tab
ii. Picture command in the Illustrations group
iii. Yes
iv. Yes
18. Conditional formatting is one of the most simple powerful feature in excel spreadsheets. You can use conditional
formatting when you want to highlight cells that meet a specified condition. Conditional formatting in excel can be used
to identify duplicates in a datasheet.
i. Select the dataset in which you want to highlight duplicates.
ii. Go to Home tab → Conditional Formatting → Highlight Cells Rules → Duplicate Values.

Copyright © myCBSEguide.com. Mass distribution in any mode is strictly prohibited.

8/9
myCBSEguide
iii. Duplicate values dialog box will appear in the Duplicate Values dialog box, make sure duplicate is selected in the left
drop-down. You can specify the format to be applied by using the right drop-down. There are some existing formats
that you can use, or specify your own format using the Custom Format option.
iv. Click OK button.
19. Following are the steps to save query:
Save the query using the save button located on the quick access toolbar.
The save as dialogue box appears.
Enter a suitable name for the query in the query name textbox.
Click on the OK button.
To practice more questions & prepare well for exams, download myCBSEguide App. It provides complete study
material for CBSE, NCERT, JEE (main), NEET-UG and NDA exams. Teachers can use Examin8 App to create similar
papers with their own name and logo.
20. i. mysql > SELECT * FROM Class WHERE Subject = 'Non-medical';
ii. mysql > SELECT Name FROM Class WHERE Grade = 'A' ORDER BY Stipend:
iii. mysql > SELECT * FROM Class ORDER BY Name:
iv. mysql > SELECT * FROM Class WHERE Grade IN('B', 'C');
v. mysql > INSERT INTO Class VALUES (06, 'Jack', 2800, 'Humanities', 98, 'A'):
21. i. Customer can place orders anywhere anytime. Customer does not need to move out to visit stores. There are more
choices available. Products or services that is not available in the local market are available online.
ii. IRCTC: an online portal for booking flight and train tickets.

Copyright © myCBSEguide.com. Mass distribution in any mode is strictly prohibited.

9/9