Information Technology Official 2024-2025 English Medium Class 10 Question Paper Solution

The school is organizing a Career Counselling Workshop. Which of the following will be the most effective method of communication to inform all students of the school?

Face-to-face informal communication

Notice / Poster

Phone call

Meet everyone in person

Which of the following is the most suitable term for the ability to regulate one’s own emotions and help others also to do the same?

Managing emotions

Harnessing emotions

Knowing emotions

Supressing emotions

Roshin studies in class X and is practising hard with a lot of sample papers to get good marks in her exams. She gets up early in the morning to study and completes her revision work. This is an example of?

Self-awareness

Self-motivation

Influential motivation

Emotional intelligence

A ______ is a location where a group of files can be stored in the computer.

Folder

SMPS

CMOS

UPS

Which of the following is a myth about entrepreneurs?

An entrepreneur should be confident and should be able to take decisions.

Every business idea must be unique or special.

An entrepreneur should keep trying new ideas.

An entrepreneur should be creative and should have different solutions to the problem.

Which one of the following is the most important factor for sustainable development and helps us become aware of our role as a responsible citizen?

Sports

Education

Business

Illiteracy

Ravi has to prepare a project report. He wants to save certain formatting features and then apply them on the project report. He can use the feature of OpenOffice Writer.

Styles

Image

Mail Merge

Preview

During a recent excursion, Roshni has taken some pictures for making a report in Writer. She wants to increase the contrast of the images. Which one of the following image filters should she use in Writer?

Aging

Mosnic

Sharpen

Smooth

Which one of the following image arrangement options in Writer sends the drawing object behind the text?

To background

To foreground

Behind the text

Back one

______ feature of Writer is based on different types of heading styles and is used to give the listing of the contents of the document.

Table of Heading

Index

Label of Contents

Table of Contents

______ is the default template for the files being created in Writer.

Resume template

Project Report

Blank document

Chapter

Shanta is creating a project report in Writer and wants to apply the same style on headings / titles in the entire document as she has done at the beginning of the document. She can use the feature of Writer to apply the same format on each line word, wherever needed.

Fill Style

Fill Format

Apply Feature

Apply Character

To add your own comments in Calc, select ______ → Track changes → Comment.

File

Edit

Insert

Data

To add a new sheet in the spreadsheet, click on the ______ sign located at the left bottom of the spreadsheet.

*

/

%

+

______ is a set of values that can be used within the calculations in the spreadsheet to explore and compare various alternatives depending on changing conditions.

Sort

Filter

What-if Scenarios

Comments

The recorded macros are actually stored as ______.

a set of instructions in a programming language.

a sequence of data cells.

a document.

a list of values.

Which creating a hyperlink in Calc, if the complete path along with filename is given, then it is an example of.

Relative hyperlink

Mixed hyperlink.

Absolute hyperlink

Folder hyperlink

This tool in Calc allows you to create a group of cells automatically and apply common functions like sum, average on the grouped data. It is known as ______ tool.

Sum

Subtotal

Function

Common

______ is the database software that is used to create, manipulate, and manage data.

Ingress

Writer

Paint

Windows

The process of arranging data in ascending or descending order is known as ______.

Filtering

Tracking

Purification

Sorting

With reference to LibreOffice Base, which of the following is a valid data type to indicate the monetary values?

Money

Currency

Rupee

Dollar

Data can be retrieved and displayed from one or more tables in a DBMS using a ______.

Referential integrity

Domain

Query

Field

While designing a form, it is suggested to get the date input by adding the ______ to the date field to prevent entering invalid dates.

Calendar

Text input

Timer

Number input

While designing a form, titles, headings, or subheadings may be added using ______ tool available on the Form Controls toolbox.

Textboх

Label

Title

Heading

______ is a state of physical, mental, and social wellbeing.

Richness

Popularity

Health

Activity

Which one of the following is a class B ignition material?

Paper

Gas

Electrical equipment

Potassium

The ______ has prepared the policy to provide employees with a healthy and safe work environment.

GoIT

DoIT

ToIT

SoIT

RSI stands for:

Recurring Syndrome Injury

Repetition Symptom Injury

Recessive Stress Injury

Repetitive Strain Injury

______ is the science that deals with designing and arranging the things at workplace so that people can use them easily and safely.

Health science

Ergonomics

Fixture science

Work Economics

Which one of the following is a wrong safety guideline?

Store all cleaning chemicals in tightly closed containers in separate cupboards.

Never distract the attention of people who are working near a fire or with some machinery, tools, or equipment.

Wear loose clothing or jewellery while working with machines.

Make sure all areas have proper lighting.

Explain 7 C’s of communication.

What is understood by stress management?

Give any four tips to keep the computer in perfect working condition.

Mention any four main functions of an entrepreneur.

Explain any two problems related to sustainable development.

Out of various style categories provided by Writer, briefly explain Frame style category in brief.

What is a Macro?

Give any two rules that should be followed while naming a Macro or module in Calc.

What is the main purpose of Goal Seek in Calc? Give an example to support your answer.

What are the important prerequisites for setting a relationship between two tables in LibreOffice Base? Mention any two.

For a computer workplace, give any two health and safety requirements while using a keyboard.

Excessive use of computers might have a bad impact on your vision. Give any two eye-related problems that might arise due to long hours spent on a computer.

What is the benefit of grouping drawing objects in Writer?

Differentiate between text wrapping and image alignment feature in Writer.

Mr. Amit, Sales Manager of ABC Sales Corporation, has created a spreadsheet in LibreOffice Calc that lists Sales for different years in different regions in different worksheets. He wants to summarize and make certain decisions based on it.

Help him by answering the following questions:

1. Which tool in Calc can be used to combine the sales data from multiple sheets into a single summary sheet?
2. Name the Menu Option and Sub-Menu Option that can be used to generate a combined summary of all the worksheets.
3. Name the function that can be used to display the total of all sales.
4. He wants to open a summary document stored at a different location from within the sheet by clicking on a text stored in a cell. How can it be done?

Imagine that you have been signed a contract of handling fire safety and emergency in a company. You need to spread awareness on fire safety and emergency handling to the employees.

Answer the following questions:

1. Give any two fire prevention measures at the workplace.
2. Give any two basic emergency handling procedures at the workplace.

Give any two advantages of relating two tables in a database.

Explain many-to-many relationship between the tables in a database.

Consider the following table:

Answer the following questions:

1. You are given the task to design the student database for your school in LibreOffice Base. Based on the given table structure, suggest the data type of student id and age field that would be suitable to store student’s-id and age, respectively.
2. As a database administrator, you need to ensure each student has a unique identifier. Which field in the table would you choose as the primary key, and why?
3. Identify the field that can serve as an alternate key. Justify your answer.
4. How many attributes and records are present in the above shown table?