myCBSEguide

Class 10 - Information Technology (402)

Sample Paper - 02 (2024-25)

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)

1. Which of the following technique provide you with the strength to do your daily work efficiently?

a) Holiday with family or friends

b) Completing work on time
c) Sleep
d) Healthy Diet

2. How many categories are there in stress-causing agents existing in our lives?

a) 4
b) 7
c) 1
d) 3

3. Which of the following is not a computer maintenance activity?

a) Cables and chords should not be messed up

b) Always shut down the computer properly
c) Keep food items on the computer table

Copyright © [Link]. Mass distribution in any mode is strictly prohibited.

1 / 12
myCBSEguide
d) Take regular backup of data

4. How many functions are there for an Entrepreneur?

a) Marketing
b) Human resource management
c) All of these
d) Planning

5. Facial expression, posture, gesture/body language, touch, space etc are types of which method of communication?

a) Visual Communication
b) Non-verbal Communication
c) Verbal Communication
d) Non-Visual Communication

6. Which of the following consists of the living organisms that reciprocally take advantages and benefits from each
other?

a) Culture
b) Green skills
c) Natural resource
d) Ecosystem
2. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

1. Which of the following is not a style category in Writer?

a) Paragraph Styles
b) Frame Styles
c) Image Styles
d) Character Styles

2. Why is using styles advantageous in Writer?

a) It simplifies consistent formatting.

b) It eliminates the need for manual formatting.
c) Styles can be reused across documents.
d) All of these.

3. Which menu allows you to insert an image into a LibreOffice Writer document?

a) Edit > Insert Image

b) Insert > Picture
c) File > Insert Image
d) Tools > Media

4. What is the shortcut to group multiple drawing objects?

a) Right-click > Combine

b) Alt + G
c) Ctrl + G

Copyright © [Link]. Mass distribution in any mode is strictly prohibited.

2 / 12
myCBSEguide
d) Ctrl + Shift + G

5. How do you save a document as a template?

a) Use File > Templates > Save As Template.

b) Use File > Save As and select the Template format.
c) Right-click the document and choose Save as Template.
d) Use Tools > Options > Save as Template.

6. How can you use a custom template to create a new document?

a) Right-click on the template file and choose New Document.

b) Open the template and edit it directly.
c) Use File > New > Templates, select the custom template, and create the document.
d) Use File > Templates > Open Custom Template.
3. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

1. What is the main limitation of Goal Seek compared to Solver?

a) Goal Seek works with only one variable

b) Goal Seek doesn't allow data input
c) Goal Seek is not interactive
d) Goal Seek is only available for advanced users

2. How do you set up a hyperlink to a specific sheet within the same file?

a) Copy the sheet’s URL

b) Use Insert > Hyperlink and select the target sheet
c) Use Insert > Link to External Data
d) Type the sheet’s name manually

3. What does the Hyperlink function allow you to do?

a) Import external data

b) Create links to other sheets, files, or URLs
c) Format tables
d) Apply conditional formatting

4. Which feature lets you view all comments in a spreadsheet?

a) Data > Comments Overview

b) Insert > Comments Log
c) View > Comments
d) Tools > Track Comments

5. Where can you edit an existing comment in a cell?

a) Both Use Edit > Comment and Right-click the cell and select Edit Comment
b) Right-click the cell and select Edit Comment
c) Double-click the cell
d) Use Edit > Comment

Copyright © [Link]. Mass distribution in any mode is strictly prohibited.

3 / 12
myCBSEguide
6. Which file format is commonly used to save macros in Calc?

a) .xml
b) .xlsm
c) .bas
d) .ods
4. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

1. What is the main difference between data and information in a database context?

a) Both are identical.

b) Data is meaningful, information is raw facts.
c) Data is raw facts, information is processed and meaningful.
d) Information only exists in spreadsheets.

2. Which of the following is/are the advantage of database?

a) Recovery
b) Data security
c) Backup
d) All of these

3. What is the purpose of setting a primary key in a table?

a) To sort the data automatically

b) To remove duplicate records
c) To create a backup of the table
d) To ensure that each record has a unique identifier

4. What does referential integrity ensure in a database?

a) Automatic backups
b) Consistency between related tables
c) Faster query execution
d) Data encryption

5. What can you do in Design View while creating a query?

a) Select fields and apply criteria

b) Delete database records
c) Create new tables
d) Sort data only

6. How can data be entered into a database using forms?

a) By using Form View

b) By directly editing tables only
c) By creating a new report
d) By modifying database schema
5. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

Copyright © [Link]. Mass distribution in any mode is strictly prohibited.

4 / 12
myCBSEguide
1. If light is coming directly behind or in front of you then you may suffer from _________________.

a) dry eyes
b) eye strain
c) sore eyes
d) eye strain and sore eyes

2. What are the different electrical safety rules?

a) All of these
b) Electrical equipment should be approved by a recognized organization
c) Worker should be trained to handle the electric equipment safely
d) Damaged and hazardous electrical equipment should be immediately replaced

3. What are the steps necessary for operating a fire extinguisher?

a) Break the seal and pull the safety pin from the handle
b) Identify the safety pin of the fire extinguisher which is generally present in its handle
c) All of these
d) Use the fire extinguisher by squeezing the lever

4. In fire classification, material magnesium, potassium, and sodium comes under _______________.

a) Class D material
b) Class C material
c) Class B material
d) Class A material

5. What is the term for hazards that occur due to occupation?

a) Electrical hazards
b) All of these
c) Occupational hazards
d) Chemical hazards

6. What is the term for any unexpected situation that needs immediate attention and action?

a) Emergency
b) Accident
c) Unexpected
d) Occupational hazard
To practice more questions & prepare well for exams, download [Link] App. It provides complete
study material for CBSE, NCERT, JEE (main), NEET-UG and NDA exams. Teachers can use [Link] App
to create similar papers with their own name and logo
SECTION B (Employability Skills)

6. What are the measures to overcome communication barriers?

7. Give one example each of following stress causal agents for students:

a. Mental

Copyright © [Link]. Mass distribution in any mode is strictly prohibited.

5 / 12
myCBSEguide
b. Social

8. What do you mean by VIRUS in computer science?

9. Who is known as a manufacturing entrepreneur?

10. The most significant environmental problems are related to which type of resources?

SECTION B (Subject Specific Skills) Short Answers

11. What steps are involved in setting a custom template as the default?

12. How do you review changes in a shared spreadsheet?

13. What is the advantage of linking to external data in Calc?

14. What are the steps to create a table in LibreOffice Base using design view?

15. How do you develop an evacuation policy and procedures?

16. Compare the different types of fire extinguishers.

SECTION B (Subject Specific Skills) Long Answers

17. A project manager is finalizing a business report that needs multiple revisions. The team uses the Track Changes feature
to monitor and approve the changes.
a) What is the Track Changes feature in LibreOffice Writer used for?
b) How can you accept or reject changes made in the document?
c) Is it possible to add comments while using Track Changes?
d) Can changes be highlighted in the document automatically?

18. A business analyst is managing monthly sales data for multiple regions. They want to automate the calculation of total
sales, regional percentages, and generate summaries for monthly performance.
a) What are the benefits of using macros in such a scenario?
b) How can a macro recorder be used to automate repetitive calculations?
c) How can arguments be passed to customize the macro's behavior for specific regions?
d) What is the importance of organizing macros effectively?

19. A gym uses forms to manage membership and attendance records. Forms will track new member registrations,
subscription details, and daily attendance. Reports will summarize membership trends and attendance frequency for
operational insights.
a) Why are forms important for managing membership details?
b) How can you insert and delete records using Form View?
c) What is the purpose of adding a date field in a form?
d) How are reports useful for gym management?

20. An e-learning platform is creating a database to store course IDs, titles, instructors, and enrollment counts. The database
should allow adding new courses, updating enrollment data, and sorting records by course popularity.
a) How can the platform create a course table in LibreOffice Base using the wizard?
b) What is the process of assigning a primary key to the “Course ID” field?

Copyright © [Link]. Mass distribution in any mode is strictly prohibited.

6 / 12
myCBSEguide
c) How can enrollment counts for a course be updated in the table?
d) How can the table be sorted in descending order by enrollment counts?

21. What are the types of accidents in the workplace, and how can they be prevented?
To practice more questions & prepare well for exams, download [Link] App. It provides complete study
material for CBSE, NCERT, JEE (main), NEET-UG and NDA exams. Teachers can use [Link] App to create
similar papers with their own name and logo

Copyright © [Link]. Mass distribution in any mode is strictly prohibited.

7 / 12
myCBSEguide

Class 10 - Information Technology (402)

Sample Paper - 02 (2024-25)

Solution

SECTION A: OBJECTIVE TYPE QUESTIONS

1. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)
1. (d) Healthy Diet
Explanation:

Healthy Diet

2. (a) 4
Explanation:

3. (c) Keep food items on the computer table

Explanation:

Keep food items on the computer table

4. (c) All of these

Explanation:

All of these

5. (b) Non-verbal Communication

Explanation:

Non-verbal Communication

6. (d) Ecosystem
Explanation:

Ecosystem

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

1. (c) Image Styles
Explanation:

Writer includes categories such as Paragraph, Character, Frame, Page, and List styles, but there are no Image Styles.

2. (d) All of these.

Explanation:

Styles provide consistency, save time, and can be easily imported or reused, making them highly beneficial for
formatting.

3. (b) Insert > Picture

Explanation:

Copyright © [Link]. Mass distribution in any mode is strictly prohibited.

8 / 12
myCBSEguide
Images can be inserted through the Insert > Picture > From File menu option in Writer.

4. (c) Ctrl + G
Explanation:

You can group drawing objects by selecting them and pressing Ctrl + G.

5. (a) Use File > Templates > Save As Template.

Explanation:

The correct way to save a document as a template is to go to File > Templates > Save As Template.

6. (c) Use File > New > Templates, select the custom template, and create the document.
Explanation:

To use a custom template, go to File > New > Templates, select the desired template, and create a new document.

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

1. (a) Goal Seek works with only one variable
Explanation:

Goal Seek can only solve for one variable, unlike Solver, which handles multiple variables.

2. (b) Use Insert > Hyperlink and select the target sheet
Explanation:

The Hyperlink dialog allows you to select specific sheets or ranges within a file.

3. (b) Create links to other sheets, files, or URLs

Explanation:

The Hyperlink function creates clickable links to navigate within sheets, to external documents, or to URLs.

4. (c) View > Comments

Explanation:

The View > Comments option displays all comments within a spreadsheet.

5. (b) Right-click the cell and select Edit Comment

Explanation:

Right-clicking a cell and selecting Edit Comment lets you update comments.

6. (d) .ods
Explanation:

Macros are typically saved within Calc documents in the .ods file format.

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

1. (c) Data is raw facts, information is processed and meaningful.
Explanation:

Data is raw facts, information is processed and meaningful.

Copyright © [Link]. Mass distribution in any mode is strictly prohibited.

9 / 12
myCBSEguide
2. (d) All of these
Explanation:

All of these

3. (d) To ensure that each record has a unique identifier

Explanation:

To ensure that each record has a unique identifier

4. (b) Consistency between related tables

Explanation:

Consistency between related tables

5. (a) Select fields and apply criteria

Explanation:

Select fields and apply criteria

6. (a) By using Form View

Explanation:

By using Form View

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

1. (d) eye strain and sore eyes
Explanation:

eye strain and sore eyes

2. (a) All of these

Explanation:

All of these

3. (c) All of these

Explanation:

All of these

4. (a) Class D material

Explanation:

Class D material

5. (c) Occupational hazards

Explanation:

Occupational hazards

6. (a) Emergency
Explanation:

Copyright © [Link]. Mass distribution in any mode is strictly prohibited.

10 / 12
myCBSEguide
Emergency

SECTION B (Employability Skills)

6. Given below are some of the practices that help to overcome communication barriers:

i. By engaging face-to-face interaction.

ii. Avoiding ego and judgmental attitude.
iii. Never be overconfident.
iv. Work on language competency.
v. Be sympathetic.
vi. Give respect towards the receiver's message.
7. a. Mental stress causal agents for students include excessive academic pressure, complex coursework, and the fear of
failing exams or assignments. These factors can lead to mental stress as students grapple with high expectations and
challenging academic demands.
b. Social stress causal agents for students encompass issues like peer pressure, bullying, social isolation, and the need to
fit in. These social stressors can result in anxiety, depression, and a sense of inadequacy among students as they
navigate their social relationships and interactions.

8. A computer virus is defined as a piece of software code written to enter the computer system and infect files. It can
damage or even destroy precious data.

9. Manufacturing entrepreneur is an entrepreneur who manufactures goods, mobilises resources and supplies to sell those
products.

10. The most significant environmental problems are associated with resources that are renewable such as air and water.
They have a finite capacity to assimilate emissions and wastes but if pollution exceeds this capacity ecosystem will
deteriorate rapidly at a huge pace.

SECTION B (Subject Specific Skills) Short Answers

11. Go to File > Templates > Manage Templates, select your custom template, right-click, and choose Set as Default. This
action ensures all new documents use the custom template as the default layout.

12. Open the shared file and go to Tools > Track Changes > Manage Changes. This displays a list of edits, where you can
view, accept, or reject each change.

13. Linking to external data ensures that your spreadsheet reflects real-time updates from the source, providing dynamic and
up-to-date information for analysis.

14. To create a table using design view, open LibreOffice Base, select "Create Table in Design View," then define fields and
their data types. Assign a primary key to a field, and save the table when the structure is complete.

15. An evacuation policy includes designating emergency coordinators, identifying safe exits, and assigning roles for
employees during emergencies. Clear guidelines for assembly points and regular evacuation drills ensure preparedness.

16. Water extinguishers are effective for Class A fires but unsuitable for electrical or liquid fires. CO₂ extinguishers work for
Class B and C fires but not on Class A. Dry chemical extinguishers handle all fire classes but leave residue.

SECTION B (Subject Specific Skills) Long Answers

Copyright © [Link]. Mass distribution in any mode is strictly prohibited.

11 / 12
myCBSEguide
17. a) Track Changes is essential for collaborative document editing as it records all changes made by reviewers, ensuring
transparency in the editing process.
b) The Track Changes feature can be accessed via the "Tools" menu, by selecting "Track Changes" and then enabling
"Record" to start tracking edits.
c) Yes, reviewers can add comments by selecting the text, right-clicking, and choosing "Insert Comment," allowing for
feedback or suggestions.
d) The author or designated editor can accept or reject changes by right-clicking on the tracked change and choosing the
appropriate option from the context menu.

18. a) Macros automate repetitive calculations, streamline tasks like total sales computation, and improve accuracy. They
save time by standardizing processes across different datasets, ensuring consistency in analysis.

b) The macro recorder captures user actions, like calculations or formatting, and replays them for new data sets,
eliminating manual repetition and improving efficiency in repetitive tasks.

c) Arguments allow macros to adapt dynamically to specific inputs, such as regional percentages, enabling customized
operations for various regions without manually editing the macro code.

d) Organizing macros in categories or folders ensures ease of access, prevents duplication, and simplifies their
maintenance, particularly when working on multiple tasks or datasets.

19. a)Forms simplify tracking member registrations, subscriptions, and attendance, providing a structured interface for
updating and searching gym records.

b) In Form View, users can add new records using input fields or delete records by selecting them and using the delete
option in the Records Toolbar.

c) Date fields automatically log attendance or subscription updates, ensuring accurate tracking and helping manage
member activity efficiently.

d) Reports provide summaries of membership trends, attendance patterns, and subscription renewals, enabling better
decision-making and resource allocation.

20. a) In LibreOffice Base, select “Table Wizard” to create a course table. Add fields like “Course ID,” “Course Title,”
“Instructor,” and “Enrollment Count.” Define data types for each field and save the table when done.

b) Assign “Course ID” as the primary key by selecting the field and marking it as “Primary Key” in design view. This
ensures that each course record is unique and easily identifiable.

c) To update enrollment counts, open the table in “Data View,” locate the course, click the “Enrollment Count” field,
update the number, and save the changes to reflect the new enrollment data.

d) To sort the table by enrollment count in descending order, open the table, go to “Tools,” select “Sort,” and choose
“Enrollment Count.” Then select “Descending” to order the courses by the highest enrollment first.

21. Workplace accidents include trips and falls, injuries from escalators or elevators, and falling goods. Prevention involves
addressing hazards like loose wires, wet floors, and poorly stacked materials. Placing warning signs ("wet floor" or
"watch your step"), regular equipment maintenance, and proper storage of items ensure safety. Employee awareness and
adherence to safety protocols reduce accidents, creating a secure work environment.

Copyright © [Link]. Mass distribution in any mode is strictly prohibited.

12 / 12