SECTION – B (SUBJECTIVE TYPE QUESTIONS)

Answer any 3 out of the given 5 questions on Employability Skills (2

x 3 = 6 marks) Answer each question in 20 – 30

6. During a team meeting, Sarah is explaining a complex project idea to her colleagues. She speaks too
quickly, uses jargon, and doesn’t pause for questions. As a result, her team seems confused, and the project
isn’t fully understood. What can Sarah do to improve her verbal communication skills?

7. Why do we say that an entrepreneur should be open-minded?

8. List the various ways you can use to protect your data.
9. How is self-regulation connected to the ability to work independently?
10. Why has United Nations has made the 17 Sustainable Development Goals?

Answer any 4 out of the given 6 questions in 20 – 30 words each (2 x 4 = 8

11. In Open Office Writer, what are the styles? List two Open Office Writer style options.
12. What do you mean by Sorting in a Spreadsheet?
13. Differentiate between safety and security of an employee.
14. Differentiate between a Primary key and Foreign key.
15. What are the benefits of sharing a spreadsheet?
16. What is Occupational Overuse Syndrome? What are the causes for it?

Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 = 12

17. A team of writers is collaborating on a report using a word processing software with a Track
Changes feature. One writer creates the initial draft, which then needs to be reviewed and edited by the rest
of the team.
(a) Why is the Track Changes feature essential for collaborative document editing?
(b) Which menu option can be used to access this feature?
(c) Can reviewers add comments?
(d) Once the changes are made by all the reviewers, who can accept or reject them?

18. Explain the term ‘Scenarios’ in relation to the Spreadsheets with example.

19. What points should be included in Fire Prevention Plan in the office?

20. Explain the term “Referential Integrity”. Why is it important in a database?

21. A health clinic is developing a patient management system to streamline patient intake,
appointments, and medical records. They need to implement forms for various purposes, including new
patient registration, appointment scheduling, and updating medical histories.
a) What is the use of form in DBMS?
b) What are the different ways to create forms in DBMS?
c) Where can we find various tools to add or edit controls on the form?
d) What is the use of the Records Toolbar in a form?

4
 Information Technology (SUBJECT CODE - 402) A
CLASS X (PRE-BOARD EXAMINATION II 2024-25)

Max. Time: 2 Hours Max. Marks: 50

General Instruction:
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. When it is difficult to communicate with someone who is not willing to talk or express their
feelings and views it means there is a/an
a. Culture Barrier b. Interpersonal Barrier c. Physical Barrier d. Language Barrier

ii. Amina studies diligently to improve her grades because she wants to feel proud of her
achievements and also earn a scholarship. What type of motivation is this?
(a) Internal (b) External (c) Both internal and external (d) Not any specific type of
motivation

iii. refers to focusing human efforts for maintaining a healthy body and mind capable
of better withstanding stressful situations.
a. Self-Motivation b. Stress Management c. Self-Awareness d. Self-Regulation

iv. How can an anti-virus protect your device?

(a) It can protect it from over-heating (b) It can increase its performance
(c) It can prevent data from getting corrupt (d) It can backup data
v. Which of the following is/are a myth about Entrepreneurship?
a. Need a lot of Money b. Must have a great Idea c. Should know everything
about business d. All of these

vi. A community initiates a tree-planting campaign to restore local forests, aiming to

enhance biodiversity, prevent soil erosion, and provide habitats for wildlife. This
initiative also includes educating residents about sustainable land use practices to
protect their natural environment. Which SDG can you relate this initiative to?
(a) Clean Water and Sanitation (b) Life on Land (c) Affordable and Clean

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

i. Which feature in Writer allows you to apply the same style to multiple words scattered
throughout the document?
(a) Format Painter (b) Fill Format option (c) Style Inspector (d) Font Adjustment Tool

ii. In the custom styles, each field on the Structure line represents a blank space in a
document.
a. Black b. White c. Blue d. Yellow
iii. How many levels of headings does LibreOffice Writer support?
(a) 5 (b) 8 (c) 10 (d) 12

iv. You can a text selection into the Styles and Formatting window to
create a new style.
(a)Drag and drop (b)Cut and paste (c)Copy and paste (d) Update

v. Saurabh has made an advertisement in Digital Document. He is facing difficulty in positioning

the images within the text. Suggest him how he can adjust the image?
a. Wrap text b. Crop c. Alignment d. Layout

vi. To increases the contrast of an image, option is used in a document.

a. Smooth b. Sharpen c . Aging d. mosaic

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

i. is specifically designed to minimize the results according to a set rules that we

define in a spreadsheet.
a. Goal Seek b. Scenario c. solver d. Subtotal

ii. The code of macro begins with followed by the name of the macro and ends with
.
(a)Function, End (b)Sub, End Sub (c)Sub, End Function (d) Sup, End Sup

iii. can help to clarify the relation between cells while using “Multiple Operations”.
a. Detective b. Solver c. Navigation d. Hyperlink
iv. It allows the placement of image in relation to text
(a) Water mark (b) Trade mark (c) Copyright (d) Text Wrapping

v. Identify the part of a Spreadsheet using which a user can manage multiple sheets.
a. Status Bar b. Sheet Tab c. Formula Bar d. Worksheet Area

vi. What is one way to mitigate hazards associated with prolonged computer use?
(a) Increasing screen brightness (b) Stretching at regular intervals or doing simple yoga (c)
Using a smaller screen (d) Sitting in a fixed position

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

i. It enables users to view, enter, and change data directly in database objects.
a. Report b. Query c. Form d. Database
ii. A hyperlink stores the location with respect to the current location in
LibreOffice Calc.
(a) Absolute (b) Relative (c) Mixed (d) Reference
iii. There are types of Relationships in a table of a database.
a. One b. 3 c. 4 d. Many
2
 iv. is a text editor that allows you to create and edit macros.
(a) IDE (b) Notepad (c) Open Office Writer (d) MS Word

v. What does referential integrity in a database ensure?

(a) All primary keys are unique across the database. (b) All records in a table must have a
value in every column. (c) Every foreign key value must match a primary key in the
referenced table or be null. (d) Data can be freely deleted from any table without
constraints.

vi. What should you do with the problem of dry eyes?

(a) Forget to blink (b) Rest eyes periodically and do simple eye exercises (c) Do exercise (d)
Blink the eyes

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

i. Which of the following statements are true about primary key in a database?
(a) It is a field that can have duplicate values. (b) It uniquely identifies each record in a
table. (c) It can have null values (d) It is an optional field in a database table.

ii. A Relational database uses commands which is a standard user application

that provides an easy programming interface for database interaction.
a. Access b. Python c. SQL d. Protocol

iii. Which of the following dialog boxes appears when the Query Design window is
for the first time to design a query?
(a) Add Table (b) Add Query (c) Add Query or Report (d) Add Table or Query

iv. In a situation where a small fire breaks out in the office, what should you use to
address the emergency?
(a) A Blanket (b) A Fire Extinguisher (c) A Towel (d) Baking Soda

v. What feature in OpenOffice Base allows users to present retrieved data in a user-
friendly and formatted manner?
(a) Query (b) Form (c) Report (d) Data view

iv. Which of the following best defines "information"?

(a) Unprocessed raw facts such as names, marks, and addresses. (b) Organized and
processed data that provides meaningful insights. (c) Audio, video, and graphics stored
without any processing. (d) A collection of unrelated raw facts.