Class 10 - Information Technology (402)

Sample Paper - 01 (2023-24)

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.

1. SECTION A: OBJECTIVE TYPE QUESTIONS

2. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4
= 4 marks)
1. Which of the following is/are the symptoms of stress?

a) All of these

b) Body aches

c) Fatigue

d) Social isolation

2. Prevent others from using your computer by ________.

 a) using internet

b) using anti-virus

c) using username and password

d) using UPS

3. How many steps are involved in an entrepreneurial process?

a) Six

b) Ten

c) Three

d) Two

4. Which of the following are effective components of good

feedback?
i. Detailed and time-consuming
ii. Direct and honest
iii. Specific
iv. Opinion-based

a) (ii) and (iv)

b) (ii) and (iii)

c) (i) and (iii)

d) (i) and (ii)

5. WCED represents:

a) None of these

b) World Committee on Environment and Development

c) World Commission on Environment and Development

d) Weird Commission on Environmental Detoxification

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

1. Which of the following Graphic filter is used to increase the
contrast of an image in a document?

a) Smooth

b) Remove Noise
 c) Invert

d) Sharpen

2. It is a section of the document that appears at the bottom margin

of the page:

a) Tail

b) Footer

c) Header

d) Head

3. The status of your document like current page number and

number of pages are given by________.

a) Formatting toolbar

b) Status bar

c) Standard toolbar

d) None of these

4. The Insert tab symbol option from the Symbols group is used to

a) insert the footer

b) insert symbols

c) insert the header

d) format document

5. A new text document can be created by

a) File → New → Blank Document → Create

b) Open → New → Create

c) None of these

d) File → Open

6. What is the shortcut to see non-printing characters in Writer?

a) Ctrl + F10

b) Ctrl + F1
 c) Ctrl + F11

d) Ctrl + F12

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

1. AutoSum option is available in

a) Home tab

b) Insert tab

c) Layout tab

d) View tab

2. It refers to a cell or a range of cells on a worksheet and can be

used to find the values or data that you want formula to calculate.

a) Autosum

b) Cell reference

c) Row

d) Column

3. Which of the following is not a way to complete a cell entry?

a) Clicking the Enter button on the formula bar

b) Pressing enter

c) Pressing spacebar

d) Pressing any arrow key on the keyboard

4. Linked data is stored in the ________.

a) web file

b) destination file

c) source file

d) domain file

5. In which group of Insert tab, various charts are available?

a) Charts group

b) None of these
 c) Type group

d) Shape styles group

6. ________ feature adds data arranged in a group of cells in Calc,

with labels for columns and/or rows.

a) Goal seek

b) Subtotal

c) Solver

d) Average

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

1. The complete information about an entity in a database is called:

a) Data

b) Information

c) Field

d) Record

2. ________ is a rule in RDBMS that ensures the accuracy and

consistency of data within the relationship and prevents the users
to enter the inconsistent data.

a) None of these

b) Data concurrency

c) Referential integrity

d) Data integrity

3. Which of the following will occupy more space in computer

memory?

a) Bigint

b) Boolean

c) Smallint

d) Integer

4. Which field is suitable for storing records of employees?

 a) EmpNo

b) Salary

c) All of these

d) Empname

5. Which command is used to display the salary of all the employees

after incrementing by 1000.

a) Select

b) Update

c) Modify

d) Change

6. Which of the following is not an example of the database?

a) Customer management system

b) Cross knot game

c) Numeric calculator

d) Employee payroll management

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

1. How can you reduce the risks over the internet?

a) Using Antivirus Software

b) Strong Password

c) All of these

d) Fire walls

2. What are the types of occupational hazards?

a) Ergonomic hazards

b) Physical hazards

c) All of these

d) Biological hazards

3. Do not keep password names such as ________.

 a) All of these

b) Don’t use mobile number as password

c) Name of your friends & Relatives

d) Favorite color

4. Customers can pay for online purchases using:

a) Credit Card

b) Debit Card

c) All of these

d) Internet Banking

5. What is the name of the portal that is commonly used for booking
train tickets?

a) Redbus

b) IRCTC

c) EBay

d) Flipkart

6. What are some of the measures to prevent electrical hazards and

accidents?

a) All of these

b) Use only electrical equipment approved by a recognized

organization.

c) Train workers to handle electric equipment safely.

d) Avoid overloading circuits.

7. SECTION B (Employability Skills)

8. What are the factors responsible for causing barriers?
9. What are the tips for Practicing for Effective Time Management?
Explain.
10. What is Trojan?
11. What are the myth of entrepreneur?
12. Enlist five ways for enhancing sustainable development.
13. SECTION B (Subject Specific Skills) Short Answers
14. Differentiate between Keep scale and Keep image size options
while cropping an image in a document.
 15. What do you mean by Page Break?
16. What is the use of Consolidate option in Calc?
17. What is DBMS?
18. What are the main types of computer networks.
19. Explain use of Antivirus and Anti Spyware.
20. SECTION B (Subject Specific Skills) Long Answers
21. List any five items that can be added to the header area.
22. How do you link the data of spreadsheets?
23. Describe the use of forms, list the various views used in MS
Access in which the form can be displayed.
24. Consider the following table

Employee

EmpNO EmpName Designation

1 Shail A
2 Anup B
3 Mansi A
4 Pooja B

i.
Which of the above field can be selected as a primary key?
ii.
EmpName field also has unique values for all the records. Can it
be made primary key? Give answer with reason.
2. How can anyone book the ticket online?

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.

Class 10 - Information Technology (402)

Sample Paper - 01 (2023-24)

Solution

1. SECTION A: OBJECTIVE TYPE QUESTIONS

2. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4
= 4 marks)
1. (a) All of these
Explanation: All of these
2. (c) using username and password
Explanation: using username and password
3. (a) Six
Explanation: Six
4. (b) (ii) and (iii)
Explanation: (Direct and honest) and (Specific)
 5. (c) World Commission on Environment and Development
Explanation: World Commission on Environment and
Development
3. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1. (d) Sharpen
Explanation: Sharpen
2. (b) Footer
Explanation: Footer is a section of the document that appears at
the bottom margin of the page.
3. (b) Status bar
Explanation: Status bar
4. (b) insert symbols
Explanation: Insert tab symbol option from Symbols group is
used to insert symbols in a document.
5. (a) File → New → Blank Document → Create
Explanation: New text document can be created by
File → New → Blank Document → Create
6. (a) Ctrl + F10
Explanation: Ctrl + F10
4. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1. (a) Home tab
Explanation: AutoSum option is available in the Editing group of
Home tab.
2. (b) Cell reference
Explanation: Cell reference
3. (c) Pressing spacebar
Explanation: Pressing spacebar
4. (c) source file
Explanation: source file
5. (a) Charts group
Explanation: Various charts are available in the Charts group of
the Insert tab.
6. (b) Subtotal
Explanation: Subtotal
5. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1. (d) Record
Explanation: Record
2. (c) Referential integrity
Explanation: Referential integrity
3. (a) Bigint
Explanation: Bigint
4. (c) All of these
Explanation: All of these
5. (a) Select
Explanation: Select
6. (c) Numeric calculator
Explanation: Numeric calculator because it is used to calculate
the numeric numbers only as it is unable to store data.
6. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
 1. (c) All of these
Explanation: All of these
2. (c) All of these
Explanation: All of these
3. (a) All of these
Explanation: All of these
4. (c) All of these
Explanation: All of these
5. (b) IRCTC
Explanation: IRCTC
6. (a) All of these
Explanation: All of these
7. SECTION B (Employability Skills)
8. The factors that cause barriers related to the message being conveyed
include lengthy messages, language problems, intonation issues, or the
non-verbal communication used.
9. The following tips may be used for effective time management:

i. Avoid delay or postponing any planned activity.

ii. Organise your work, room and school desk.
iii. Develop a ‘NO DISTURBANCE ZONE’ to sit and complete
important tasks.
iv. Use waiting time productively.
v. Prepare a ‘To-do’ list and prioritise the tasks at hand.
vi. Replace useless activities by the productive activities.
2. Trojan (Trojan horse) is any malicious PC program that misdirects
clients of its actual goal. The term is taken from the Ancient Greek
story of the tricky wooden steed that prompted id the fall of the city of
Troy.
3.

 Entrepreneurs are born that way

 All entrepreneurs have great ideas
 The only requirement is a good idea
 Entrepreneurs take lots of risk
 One must know everything before starting a business
 Lot of money is required to start any business
4. Five methods for enhancing sustainable development are as follows:

i. Tree plantation to prevent soil erosion

ii. Use of solar energy, wind energy, and other alternative sources of
energy
iii. Rainwater harvesting
iv. Use of bio-fuels
v. Recycling of wastes
2. SECTION B (Subject Specific Skills) Short Answers
3. When Keep scale is selected (default), cropping the image does not
change the scale of the picture.
When Keep image size is selected, cropping produces enlargement (for
 positive cropping values), shrinking (for negative cropping values), or
distortion of the image so that the image size remains constant.
4. A Page Break is used to determine where the printed page ends and
begins the next one, so the content before the page break will be
printed on one page and after the page break on another.
5. Data > Consolidate provides a way to combine data from two or more
ranges of cells into a new range while running one of the several
functions (such as Sum or Average) on the data. During consolidation,
the contents of cells from several sheets can be combined into one
place. The effect is that copies of the identified ranges are stacked with
their top left corners at the specified result position, and the selected
operation is used in each cell to calculate the result value.
6. DBMS stands for the database management system. It is a
computerized Record-Keeping system or software that enables you to
create, store, modify and extract information from a database. The
main function of DBMS is to provide efficient and reliable methods to
the users for data retrieval. In addition, it saves your time efforts and
reduces the chances of errors creeping into the database to a great
extent.
7. Following are the three main types of computer networks, based upon
the geographical area as follows:

i. Local Area Network (LAN)

ii. Metropolitan Area Network (MAN)
iii. Wide Area Network (WAN)
8. Antivirus and Antispyware programs offer real-time protection
monitoring your computer for any changes by malware software. Keep
your Antivirus and Antispyware software always up to date, this can
help in protecting your computer from any threats.
9. SECTION B (Subject Specific Skills) Long Answers
10. Five items that can be added to the header section of a document
can be

i. The title of the document

ii. Name of the document
iii. Pic/logo for the document
iv. Menu (that contain home, about, services, etc.)
v. Date and time
11. To link data from one spreadsheet to another in Excel, you can:

1. Open the source and destination spreadsheets.

2. Click on the cell you want to link the source to and type "=" in
your destination.
3. Navigate to the spreadsheet you wish to use as the source.
4. Click on the cell you wish to link to the destination and press
enter.

You can also link data by:

 o Copying it from the source file and then pasting it as links.
o Typing in the “=” sign (plus optionally a function name) and then
jumping to another worksheet and highlighting the arguments.

When you link a cell to another sheet, the data in this cell will be
automatically synchronized and updated whenever the data in your
source cell changes.
Linking data is especially important when multiple people are working
on the same spreadsheet.

12. A form is a printed or typed document with blank spaces for

insertion of the required or requested information. Likewise, Access
provides forms that prompt the user to provide information that can be
fed into the database. They allow you to add and update data in one
record at a time in a table.
Access provides the three main view in which a form is displayed:
Form view: this view is used to enter or edit data.
Design view: this view is used to adjust the design of your form it gives
you a more detailed view of the structure of forms like header, detail
and footer sections.
Layout view: this view is used to change the look and feel of a form it is
useful for setting the size of controls and changing their appearance.
13.

i. EmpNo can be selected as a primary key.

ii. EmpName is having unique values, but there is no guarantee that
if more employees are included then there would not be multiple
people with similar names.
So, in future its values may be duplicate. Thus, it cannot be made
as a primary key.
2. E-Ticket or electronic ticket is the digital ticket equivalent of a paper
ticket. IRCTC (Indian Railway Catering and Tourism Corporation) is used
to book and cancel rail tickets.
To book the ticket on IRCTC, follow the given steps:
Step 1: Open the IRCTC site by www.irctc.co.in address. The home
page of IRCTC will appear on the screen.
Step 2: Enter in From and To fields, class type and click on Find
Trains option.
Step 3: Search the train and click on Check Availability and Fare to
find the availability of train and book now.
Step 4: The following page will display. If you have an account on
IRCTC then enter login name and password otherwise click
on REGISTER button.
Step 5: Individual Registration page will appear, fill the details and
click on Register button.
Step 6: After this, a window will appear as shown below
Step 7: Enter the required fields and click on Continue Booking.
Step 8: Travelling Passengers page will be appear as shown below.
Step 9: Click on Continue Booking. Payment options page will be
display on the screen. Select the appropriate option and enter details.
Step 10: Payment Page will be appear as shown below. Fill your bank
details and click on Proceed button.

Step 11: E-ticket will be generated on screen as well as sent to your

registered e-mail id.