Happy Learning Academy

IT
Class 10 - Information Technology (402)
Time Allowed: 2 hours Maximum Marks: 50

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):

1. This section has 05 questions.

2. Marks allotted are mentioned against each question/part.

3. There is no negative marking.

4. Do as per the instructions given.

7. SECTION B - SUBJECTIVE TYPE QUESTIONS (26 MARKS):

1. This section has 16 questions.

2. A candidate has to do 10 questions.

3. Do as per the instructions given.

4. 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) [4]
(a) Which of the following technique help you to keep calm? [1]

a) All of these b) Meditation and Yoga

c) Playing mobile games d) Watching TV and Web Series

(b) The feeling of self-awareness enhances our [1]

a) self-monitoring b) all of these

c) self-confidence d) self-regulation
(c) Identify the input device. [1]

a) Mouse b) Printer

c) Speaker d) Monitor

1/5
 (d) Entrepreneurship skills helps ________ [1]

a) to develop ability to handle failure. b) All of these

c) in making difference to the society. d) to develop critical thinking.

(e) What is a phrase? [1]

a) A group of words which does not make b) A group of ideas that form a complete
complete sense in itself. paragraph.

c) A group of words that contains all the d) A group of words that communicate a
punctuation marks. complete thought.
(f) Which of the following form the important components of an ecosystem? [1]

a) Water and soil b) Energy and air

c) Land, air, and water d) Both (Energy and air) and (Water and
soil)
2. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]
(a) How can you update an existing style with new formatting? [1]

a) Use the Load Styles feature to overwrite b) Edit it in the Styles and Formatting
it. window.

c) Reformat text and use Update Style d) Create a new style and delete the old
from the context menu. one.
(b) What is the shortcut to apply a style to selected text? [1]

a) Drag the style to the text. b) Copy-paste the style formatting.

c) Double-click on the desired style in the d) Right-click on the style and choose
Styles and Formatting window. Apply.
(c) How do you align an image to the center of the page? [1]

a) Both Use the Alignment options under b) Drag the image to the center.
the Format menu and Select the image,
right-click, and choose Center on Page

c) Use the Alignment options under the d) Select the image, right-click, and
Format menu. choose Center on Page.
(d) How do you resize a drawing object proportionally? [1]

a) Use the Properties panel to lock the b) Drag the object using any side handle.
aspect ratio.

c) Drag a corner handle while holding the d) Right-click and choose Resize
Shift key. Proportionally.
(e) Where are user-created templates stored in LibreOffice Writer? [1]

a) In the system files directory. b) In the default templates folder.

c) In the user's document folder. d) They are stored online.

(f) How can you customize a Table of Contents? [1]

2/5
 a) By editing its source code. b) Through the Edit Index/Table dialog.

c) By manually retyping it. d) Using the Page Layout menu.

3. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]
(a) Which tool is best suited for "what-if" analysis with complex formulas and multiple constraints? [1]

a) Subtotals b) Consolidate

c) Solver d) Goal Seek

(b) How can you create a reference to another sheet in the same spreadsheet? [1]

a) Copy and paste the data b) Import data from another file

c) Use SheetName.CellAddress d) Use Insert > Hyperlink

(c) Which of the following feature is used to jump to a different spreadsheet from the current spreadsheet [1]
in LibreOffice Calc?

a) Macro b) Hyperlink

c) connect d) Copy
(d) What is the primary purpose of recording changes in a shared spreadsheet? [1]

a) Formatting data b) Tracking edits made by multiple users

c) Automating calculations d) Securing the file

(e) What action is required before merging spreadsheets? [1]

a) Enable Track Changes b) Disable sharing

c) Save the current spreadsheet d) Remove all comments

(f) Which of these tasks can be automated using a macro? [1]

a) Complex repetitive calculations b) Cell formatting

c) Sorting columns d) All of these

4. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]
(a) DBMS stands for ________. [1]

a) Data Management Multi System b) Data and Books Management System

c) Database Management System d) Duplicate Books Management System

(b) Which one of the following is not an example of DBMS? [1]

a) FoxPro b) SQLite

c) Impress d) PostgresSQL
(c) Which is the shortcut key to open an existing database? [1]

a) Ctrl+F b) Ctrl+ D

c) Ctrl+O d) Ctrl+E
(d) In the relationship design screen, the relationship between the two tables is done using ________ [1]
operation.

a) Drag and Drop b) Right click

3/5
 c) Double Click d) Click
(e) What is the purpose of a query in a database? [1]

a) To design a table b) To edit forms

c) To retrieve specific information d) To store data

(f) Which operation can be performed in Form View? [1]

a) Adding and deleting records b) Generating reports

c) Creating new tables d) Designing queries

5. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]
(a) What basic safety rules to follow at the workplace? [1]

a) All of these b) Electrical Safety

c) Falls and slips d) Fire Safety & Use of First aid

(b) Do not wear ________ when working with machines. [1]

a) safety glasses b) jewellery

c) gloves d) masks
(c) When do we use a fire extinguisher? [1]

a) In case of electric shock b) In case of fire

c) In case of burn injury d) In case of flood

(d) What are the steps necessary for operating a fire extinguisher? [1]

a) Break the seal and pull the safety pin b) Identify the safety pin of the fire
from the handle extinguisher which is generally present
in its handle

c) All of these d) Use the fire extinguisher by squeezing

the lever
(e) What is the general rule to follow for secure online transactions? [1]

a) Share personal information with the b) All of these

website

c) Use any antivirus and antispyware d) Use any website for such transactions
software
(f) Which symbol represents a digital certificate indicating a secure transaction in the web browser’s [1]
address bar?

a) Key b) Danger sign

c) Both Lock and Key d) Lock

SECTION B (Employability Skills)
Attempt any 3 questions
6. Identify the conjunctions and prepositions from the list below and write these in the different boxes. [2]
Over, Because, Under, And, Since, In, At, Although, Or, Up, On, Beside
7. Enlist the elements of Self- Motivation. [2]

4/5
 8. What is Storm in computer science? [2]
9. What is the main feature of a business to be successful in the market? [2]
10. Why do you think the United Nations has made the 17 Sustainable Development Goals? [2]
SECTION B (Subject Specific Skills) Short Answers
Attempt any 4 questions
11. How can you position an image relative to text in LibreOffice Writer? [2]
12. Write the commands to perform [2]
a. Sharing Spreadsheet
b. Record changes
13. State advantages of extracting data from a web page into spreadsheet. [2]
14. What is a database? [2]
15. What is occupational overuse syndrome? [2]
16. Briefly explain the concept of health, safety and security at workplace. [2]
SECTION B (Subject Specific Skills) Long Answers
Attempt any 3 questions
17. A graduate student is preparing a thesis and needs to ensure proper formatting. The student uses the Table of [4]
Contents (ToC) to organize chapters, sections, and subsections.
a) How can a Table of Contents assist in organizing a thesis?
b) What are the steps to create a Table of Contents in LibreOffice Writer?
c) How can you modify the Table of Contents format after it’s created?
d) How can you delete a Table of Contents in the document?
18. A financial advisor manages investment data for multiple clients. They need a macro to sort clients by portfolio [4]
size, calculate returns, and generate summaries for each client.
a) How can the advisor create and run a simple macro to automate calculations?
b) Why is it beneficial to pass arguments to macros in financial analysis?
c) How can macros simplify sorting by portfolio size?
d) What operations cannot be fully automated using the macro recorder in Calc?
19. A travel agency tracks customers, bookings, and payments in its database. They use queries to list customers [4]
traveling in a specific month, retrieve bookings for destinations above Rs.2000, and calculate total monthly
bookings.
a) What is the significance of applying criteria in queries?
b) How can the wizard simplify query creation?
c) How can numerical filters be used in queries?
d) Why is it important to edit queries for updated criteria?
20. A local library wants to digitize its membership records, including member names, IDs, contact information, and [4]
borrowing history. They lack database knowledge. Explain:
a) What are hierarchical and relational data models, and which one is more suited to their needs?
b) What are fields and records in the context of a membership database?
c) Suggest two software options to help them create and manage this database.
d) Identify the Primary Key for the membership table.
21. What are the key causes of workplace fires, and how can they be prevented? [4]

5/5