ANSWER-KEY

SAMPLE QUESTION PAPER—1

SECTION—A OBJECTIVE TYPE QUESTIONS
Q. 1. Answer any 4 out of the given 6 questions on Employability Skills.
1. (c) Sender 2. (b) To improve overall well-being
3. (d) Show active programs, date and time 4. (c) Understanding the target audience
5. (c) Conservation and Biodiversity 6. (c) Creating, managing and developing a new venture
Q. 2. Answer any 5 out of the given 6 questions.
1. (c) The reference point used for determining the image’s placement
2. (c) Provide a pre-designed layout with sample content and themes
3. (a) Fill Format Mode 4. (b) Manual update 5. (a) To summarize a document’s content
6. (c) F11
Q. 3. Answer any 5 out of the given 6 questions.
1. (b) Sum 2. (c) Compare Document 3. (d) Page layout 4. (d) all of above
5. (a) Scenarios 6. (b) Absolute hyperlink
Q. 4. Answer any 5 out of the given 6 questions.
1. (c) Relational 2. (c) Wizard View 3. (c) CHAR
4. (b) Provide a user interface to interact with the database
5. (c) Data accuracy and consistency 6. (c) Grouped query
Q. 5. Answer any 5 out of the given 6 questions.
1. (b) Wet or slippery surfaces 2. (a) To provide immediate care and preserve life
3. (b) To identify potential fire hazards and vulnerabilities
4. (b) Adjustability for back and feet support 5. (b) Burn cream or gel
6. (c) Repetitive tasks and awkward postures

SECTION—B SUBJECTIVE TYPE QUESTIONS

6. Anything which disrupts or disturbs the flow of communication is considered as noise. Noise can be external or
internal, external noise includes background disturbances, distractions while internal noise includes individual
biases, language barriers or contrasting interpretations.
7. Mediation is a powerful stress management tool. It helps us to introspect, find out exactly what is causing us
problems and find a solution for the same. It is essentially a relaxation technique where you try to focus your
mind at one place and try to avoid distractions or other disturbing thoughts. This helps to improve your focus and
relieve stress.
8. Steps to create new file/ folder :
(i) Right click on blank area of the Desktop.
(ii) A Shortcut Menu appears.

Information Technology-X 1
 (iii) Select New option. A list of sub-options appears.
(iv) Click on the Folder option. A new Folder will be created and displayed on the Desktop.
(v) Type folder name and press Enter key.
9. Businesses can be unpredictable, there is a possibility of difficult situations, failures, losses, unfavourable conditions,
difficult clients and a lot more when things do not go the way you planned them to be. In such situations, it is
important that an entrepreneur has the quality of adaptability and flexibility to adjust as per the situation and
keep working.
10. 1. Resource Depletion : Depletion of natural resources like water, forests and minerals due to overexploitation
and unsustainable consumption patterns poses a significant threat to sustainability.
2. Biodiversity Loss : Human activities such as habitat destruction, pollution and invasive species are leading to
a rapid decline in biodiversity, affecting ecosystems and their ability to support life.
11. Hierarchy in a table of contents refers to the way in which the different headings and subheadings in the document
are organized. It’s a way to represent the different levels of content in a document or report, with each level
indicating a different degree of importance or significance.
In a Table of Contents, hierarchy is typically denoted by different formatting styles, such as font size, boldness,
indentation, or numbering. For example, a higher-level heading (e.g., a chapter title) might be formatted with a
larger font size and bold text, while lower-level headings (e.g., subsections within the chapter) might have a
smaller font size and regular text.
12. A function is like a small program that does something specific when you tell it to. When you use a function, it
gives you a result. To make a macro work like a function, you use the word “Function” in it. Each function has a
name and you can also give it some information to use when it runs, which is called parameters.
13. The changes done by you in the spreadsheet will be highlighted by a border around the cells with a dot in the
upper-left corner. When you point at the dot of the highlighted cell, you can see more detailed information, such
as the name of the author, the date and time of day for the change and the type of change in the Help Tip box,
Figure displays the recorded changes.
14. Field properties in a database table define various characteristics and behaviours of individual fields (columns)
within that table. These properties are important for defining the type of data a field can hold and controlling
how data is stored and displayed.
The properties for each field are set in the Table Design View using the ‘Field Properties’ pane. You can set the
properties of the fields according to their data type.
15. This function counts the number of records in the table. Using this function, empty fields can either be counted or
excluded.
COUNT (*) : If you pass an asterisk with the COUNT function, it will count all the records in a field.
16. 1. Wet or slippery surfaces : Wet or slippery surfaces are a major cause of falls and slips. This can be due to spills,
leaks, or weather conditions.
2. Uneven surfaces : Uneven surfaces can also cause falls. This can be due to potholes, cracks, or changes in
elevation.
3. Poor lighting : Poor lighting can make it difficult to see hazards, such as wet or uneven surfaces.
17. Following are the steps to group the drawing objects :
1. Draw four or five drawing objects.
2. Select the object by clicking over it.
3. Hold the Shift key and keep on selecting all other objects by clicking on it to be included in the group.

2 Information Technology-X
 4. Once all the objects are selected, click on Format > Group > Group. Or Click on the Group button on the
Drawing Object Properties toolbar. Or Right-click and select Group from the context menu.
5. All the selected objects will be grouped.
18. Solver represents a more comprehensive version of Goal Seek. While Goal Seek focuses on adjusting one input
value to reach a fixed outcome, Solver can deal with equations having multiple unknown variables. In Goal Seek,
you can manipulate one input cell after the outcome or target is fixed. However, in Solver, you can manipulate a
set of cells after knowing the desired output. It allows you to estimate the minimum or maximum values that can
be placed into these cells to achieve your objective. Solver is particularly designed where you want to either
minimize or maximize a result according to a set of limiting rules defined by the user. Each of these rules sets up
whether an argument in the formula should be greater than, lesser than, or equal to the entered value. If the
argument need not to be changed, set the rule so that the argument in the cell is equal to its current entry.
19. A cell reference refers to a single cell or a range of cells in the current worksheet, another worksheet, or within
the same spreadsheet. It allows you to access the values stored in those referenced cells and perform calculations
by applying formulas to them.
You can use a cell reference to refer to :
1. Data from one or more contiguous cells on the worksheet.
2. Data contained in different areas of a worksheet.
3. Data on other worksheets in the same spreadsheet.
20. 1. Reduction in Data Redundancy : Data redundancy occurs when the same data is duplicated in multiple places,
leading to inconsistencies and inefficiencies. DBMS helps eliminate redundancy by storing data in a centralized
manner. For example, in a non-DBMS system, if you have to update a customer’s address, you must do it in
multiple places. In contrast, DBMS maintains a single customer record, reducing errors and saving storage
space.
2. Reduction in Data Inconsistency : Data inconsistency arises when different copies of the same data don’t
match, causing confusion and errors. DBMS ensures data consistency by making sure all data instances reflect
the same information. For instance, imagine a company has different departments storing employee information.
Without DBMS, the same employee’s salary could be different in various records, leading to payroll discrepancies.
DBMS enforces consistency across departments.
3. Data Integrity : Data integrity means that data is accurate and reliable. DBMS checks and enforces data rules to
maintain integrity. For instance, you might have a rule that says “a person’s age can’t be negative.” If someone
tries to enter a negative age, the DBMS stops it from happening, ensuring data accuracy and trustworthiness.
21. (i) Identify Pollutants : Determine which air pollutants are most relevant to the work environment. Common
pollutants include carbon dioxide (CO2), carbon monoxide (CO), VOCs, particulate matter and humidity levels.
(ii) Choose Monitoring Equipment : Select appropriate devices to measure air quality. These can include air
sampling pumps, particulate counters, gas detectors and humidity meters. Some workplaces may also use
sensors that continuously monitor and provide real-time data on air quality.
(iii) Conduct Initial Assessments : Perform an initial assessment to establish baseline air quality levels. Monitoring
may be conducted at different times of the day and across various locations in the workplace to get an accurate
picture.
(iv) Set Thresholds and Standards : Establish acceptable thresholds based on health and safety regulations or
industry standards. For example, OSHA provides permissible exposure limits (PELs) for certain air contaminants.

Information Technology-X 3
 SAMPLE QUESTION PAPER—2
SECTION—A OBJECTIVE TYPE QUESTIONS

Q. 1. Answer any 4 out of the given 6 questions on Employability Skills.

1. (b) Decoding 2. (a) Intrinsic motivation 3. (a) Programs, files or folders
4. (c) Freelancer 5. (c) United Nations (UN) 6. (c) Process Management
Q. 2. Answer any 5 out of the given 6 questions.
1. (b) Image Styles
2. (c) Helps in creating a TOC with hierarchical headings
3. (c) Copies styles from a template or another document 4. (a) It has four tabs
5. (d) Create new documents based on a specific template by default
6. (d) Updates the selected style with new formatting effects
Q. 3. Answer any 5 out of the given 6 questions.
1. (c) Consolidate 2. (c) Document 3. (a) Tools > Macros
4. (b) Record Changes 5. (d) .ods 6. (a) Reducing errors
Q. 4. Answer any 5 out of the given 6 questions.
1. (b) Raw facts and figures 2. (b) Cannot be NULL 3. (c) To establish relationships between tables
4. (b) Counts the number of records in a table
5. (a) BOOLEAN 6. (b) To filter records based on conditions
Q. 5. Answer any 5 out of the given 6 questions.
1. (b) Ensuring water is free from contaminants 2. (b) To outline steps for safely leaving the building
3. (b) Immediately report it to supervisors 4. (c) Regularly clean HVAC systems
5. (c) Preventing accidents and ensuring well-being 6. (c) Personal Protective Equipment (PPE)

SECTION—B SUBJECTIVE TYPE QUESTIONS

6. Feedback is the response or the reaction given by the audience after receiving the message. It helps the sender to
analyse the effectiveness of the delivered message. Feedback can be verbal, written or non-verbal in form of
words, letters, emails, reactions, opinions or even expressions. Feedback is essential as it can impact decision
making or affect results in competitive situations. It is also valuable in its ability to help the speaker/performer to
find their weaker areas and improve upon them.
7. The ability to work independently refers to an individual’s capacity to perform tasks, make decisions, and complete
responsibilities without constant supervision or guidance from others. This skill encompasses the capacity to

4 Information Technology-X
 initiate and carry out tasks, solve problems, prioritize assignments, and make decisions without relying heavily
on external input. Name three key aspects of working independently.
8. Real-time operating systems are specially crafted for applications where immediate and predictable responses to
inputs are crucial. They are used in robotics, industrial automation, medical devices, or aerospace control systems.
RTOSs ensure that critical tasks happen within precise timeframes, making them ideal for situations where timing
is everything.
9. Entrepreneurship is the process of conceptualizing, creating, and managing a new business venture or enterprise.
It involves identifying opportunities, taking calculated risks, and organizing resources to transform innovative
ideas into viable products, services, or solutions that fulfill market needs or solve problems.
10. i. Promote Renewable Energy Sources : Utilize solar, wind, and hydroelectric power to generate clean energy,
reducing reliance on fossil fuels.
ii. Enhance Energy Efficiency : Implement energy-saving technologies like LED lighting, energy-efficient appliances,
and better insulation to minimize energy consumption.
11. Fill Format Mode feature proves particularly helpful when you need to apply a style to multiple scattered objects
in the document. Fill Format Mode is used to apply a style to many different areas quickly without having to go
back to the Styles and Formatting pane and double-click every time.
12. Consolidating data involves merging information from multiple worksheets into a single location. In Calc, you can
effortlessly achieve this using the Consolidate feature. It collects data from various worksheets and compiles it
into a master worksheet.
13. At times, when you receive multiple edited versions of a sheet from reviewers simultaneously, it can be challenging
to review them individually. To address this issue, Calc offers the Merge Document feature, which allows you to
combine these multiple files. This way, you can efficiently review all the changes in one consolidated document
instead of going through them one by one. It’s important to note that all the edited documents should have
recorded changes for this feature to work effectively.
14. Referential integrity is a critical concept in Relational Database Management Systems (RDBMS) that ensures the
accuracy, consistency, and integrity of data relationships between tables. It enforces rules and constraints to
maintain the integrity of data within a relational database.
15. 1. Objects Relationship Pane : Located at the top, this pane displays the tables selected for the query and the
relationships between them. These relationships are indicated by joined lines that link the key fields that share
the same field name.
2. Design Grid : Positioned at the bottom, this is where you build your query. You can add fields from the selected
tables to the Design Grid by either dragging and dropping them or double-clicking on the fields.
16. First aid is the immediate care and assistance provided to an injured or ill person before professional medical help
arrives. The primary goal of first aid is to provide immediate care that can make a significant difference in the
outcome of an injury or illness. Rapid response can prevent conditions from worsening and improve the chances
of a full recovery.

Information Technology-X 5
17. To customise the table of contents, follow these steps :
1. Right-click on the table of contents and select the Edit Index option.
2. The Table of Contents, Index or Bibliography dialog box appears.
3. The Table of Contents, Index or Bibliography dialog box consists of five tabs. You can use the options given
under each tab to customise the table of contents :
(a) The Type tab helps to set the attributes of the TOC, for example, the type of index.
(b) The Entries tab provides you with the ability to format and set exactly how each entry in the table of
contents will be displayed.
(c) The Styles tab provides options for applying paragraph styles to the table of contents. (d) The Columns
tab is used to arrange the TOC into more than one column.
(d) The Background tab has the options to add colour or a graphic to the background of the TOC.
4. After making all of your changes, click OK to save the table of contents.
18. 1. Create a spreadsheet and save it in a network location so that the other users can access it easily.
2. Click on the Tools menu.
3. Choose Share Spreadsheet… to activate the collaboration features for this file.
4. The Share Document dialog box opens. Select the Share this spreadsheet with other users checkbox to enable
sharing.
5. Click on OK.
6. A message appears ‘The spreadsheet must be saved now to activate sharing mode.’
7. Click on Yes to continue.
8. If the spreadsheet has not been saved previously, the Save As dialog box appears. Give an appropriate name
and save the spreadsheet.
9. The word (shared) is shown on the title bar next to the spreadsheet’s title.
10. Now, all the users can work together on the same spreadsheet.
19. Database objects are the basic building blocks of a database. They are used to store, organize, and manage data.
Some common database objects are as follows :
Tables : Tables are the core storage units in a database. They represent collections of related data organized into
rows and columns. Each row in a table is called a record or tuple, while each column is known as an attribute or
field. Tables store the actual data.
Queries : Queries are used to retrieve, manipulate, and analyze data from one or more tables. They can filter,
sort, aggregate, and join data, enabling users to extract meaningful information from the database.
Forms : Forms are user interfaces designed for data entry and manipulation. They provide a userfriendly way to
interact with the database by presenting data in a structured and visually appealing manner. They can be used to
create new records, update existing records, or delete records.
Reports : Reports are used to display data from a database in a formatted way. They can be used to generate
formatted documents for printing or for viewing on screen, based on the data stored in the database.

6 Information Technology-X
20. A numeric data type is a data type that is used to store and represent numbers. Numeric data types are used to
store and represent numbers, which can include phone numbers, admission numbers, house numbers, years of
birth, true or false statements, and statistical values. The different types of numeric data type are listed below :

Name Data Type Description Characteristics Range

INTEGER int Stores whole Most common numeric data -2,147,483,648 to

numbers without type in Libre Office Base. 2,147,483,647
decimal points.

SMALLINT smallint Stores small Used to store small whole -32,768 to 32,767
whole numbers numbers, such as the number
without decimal of items in a shopping cart or
points. the number of employees in a
department.

DECIMAL decimal Stores numbers Often used to store financial Precision up to 38 digits,
with a decimal data, such as prices, discounts, scale up to 38 digits
point. and taxes.

21. (i) Chemical Exposure : Contact with hazardous substances, such as cleaning agents, industrial chemicals,
pesticides or solvents, can cause respiratory problems, skin irritation or poisoning. Longterm exposure may
lead to chronic conditions like cancer or organ damage.
(ii) Biological Hazards : Exposure to bacteria, viruses, fungi or other pathogens, especially in industries like
healthcare, food processing or research, can lead to infections, allergies or serious illnesses.
(iii) Ergonomic Risks : Poorly designed workstations or repetitive tasks can lead to musculoskeletal disorders,
such as carpal tunnel syndrome, back pain or neck strain. Improper lifting techniques or prolonged sitting can
exacerbate these issues.
(iv) Air Quality Issues : Poor ventilation or exposure to dust, fumes or pollutants in the workplace can lead to
respiratory conditions.

Information Technology-X 7