Sample Paper

Question 1.
Answer any 4 out of the given 6 questions based on Employability Skills. (4×1=4)

(i) The school wants to announce a change in the timetable to all teachers quickly and clearly. Which of the
following will be the most effective method of communication?
(a) Writing on the staff room whiteboard
(b) Sending a formal email to all teachers
(c) Waiting for a casual conversation
(d) Posting a note on the school gate
Answer:
(a) Writing on the staff room whiteboard

School supplies

(ii) Which of the following best describes the ability to stay calm, focused and productive even under
pressure?
(a) Avoiding responsibilities
(b) Ignoring emotions
(c) Self-discipline
(d) Reacting impulsively
Answer:
(c) Self-discipline

(iii) Neha prepares a to-do list every morning and prioritises her tasks based on importance and deadlines.
She avoids distractions and sticks to her schedule. This is an example of ……………
(a) lack of planning
(b) time management
(c) multitasking
(d) procrastination
Answer:
(b) time management

(iv) A ………… is a physical device that stores all the data in a computer, including the operating system,
applications and files.
(a) Monitor
(b) Keyboard
(c) SMPS
(d) Hard Disk
Answer:
(d) Hard Disk
(v) Which of the following is a myth about entrepreneurs?
(a) Entrepreneurs need to be problem-solvers.
(b) Entrepreneurs always need a lot of money to start.
(c) Entrepreneurs must be passionate about their work.
(d) Entrepreneurs need to understand market needs.
Answer:
(b) Entrepreneurs always need a lot of money to start.

(vi) Which of the following is not a solution for sustainable development?

(a) Education and awareness programmes
(b) Sustainable agriculture practices
(c) Deforestation and habitat destruction
(d) Green technology advancements
Answer:
(c) Deforestation and habitat destruction

Question 2.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) Aman wants to create a reusable document layout with predefined formatting, fonts and structure for
his project reports in OpenOffice Writer. He can use the ……….. feature for this purpose.
(a) Styles
(b) Mail Merge
(c) Template
(d) Table
Answer:
(c) Template

Note
Templates save time by providing predefined layout, fonts and structureideal for reports, letters or
presentations.

(ii) While working on her science project in Writer, Aditi inserted a photo of a plant. To make the image
appear softer and reduce harsh edges, which image filter should she apply?
(a) Invert
(b) Sharpen
(c) Smooth
(d) Charcoal Sketch
Answer:
(c) Smooth

(iii) Which of the following options in LibreOffice Writer allows you to align an image with the text?
(a) Wrap Text
(b) Align Object
(c) Insert Object
(d) Position Image
Answer:
(a) Wrap Text
(iv) Where are user-created templates stored by default in LibreOffice?
(a) Templates Gallery
(b) AutoText
(c) Navigator
(d) Clipboard
Answer:
(a) Templates Gallery

(v) ………….. is the default page style applied when a new document is created in Libre Office Writer.
(a) Landscape
(b) First Page
(c) Default Page Style
(d) Index Page
Answer:
(c) Default Page Style

(vi) Karan is designing his assignment in LibreOffice Writer and wants to quickly copy and apply the same
formatting from one paragraph to several others in the document. He should use the ………….. tool to do
this.
(a) Format Copy
(b) Format Brush
(c) Fill Format
(d) Clone Text
Answer:
(c) Fill Format

Question 3.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) To enable the feature that highlights modifications made in a Calc sheet, go to ……… →Track Changes →
Record.
(a) Edit
(b) View
(c) Tools
(d) Format
Answer:
(a) Edit

(ii) To rename an existing sheet in LibreOffice Calc, right-click on the sheet tab and select …………. from the
context menu.
(a) Rename Sheet
(b) Edit Name
(c) Modify Sheet
(d) Change Title
Answer:
(a) Rename Sheet

(iii) Which of the following allows you to reference data from another sheet in the same workbook?
(a) =Sheet1.A1
(b) =Sheet1!A1
(c) =A1:Sheet1
(d) =REF(Sheet1.A1)
Answer:
(a) -Sheet1.A1

(iv) If you want to remove or break an external link in Calc, which option should you use?
(a) Tools → Options
(b) Edit → Links to External Files → Break Link
(c) Data → Filter → Remove
(d) Format → Clear Direct Formatting
Answer:
(b) Edit → Links to External Files →Break Link

(v) When creating a hyperlink in Calc, if only the file name or path relative to the document’s location is
used, it is called a …………
(a) External hyperlink
(b) Absolute hyperlink
(c) Relative hyperlink
(d) Partial hyperlink
Answer:
(c) Relative hyperlink

(vi) In LibreOffice Calc, the tool that helps in summarising data by grouping it based on a common field and
applying functions like count or max is called the ……….. tool.
(a) AutoCalculate
(b) Summary
(c) Subtotal
(d) Cell Group
Answer:
(c) Subtotal

Question 4.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) The tool in LibreOffice used to extract specific information from a large dataset based on certain criteria
is called a ………….
(a) Form
(b) Table
(c) Query
(d) Relationship
Answer:
(c) Query
(ii) Which menu option allows you to define relationships between tables?
(a) Tools → SQL
(b) Edit → Connections
(c) Tools → Relationships
(d) File → Save As
Answer:
(c) Tools → Relationships

(iii) To avoid duplication of records and maintain data accuracy, which of the following should be used in a
table?
(a) Foreign Key
(b) Index
(c) Primary Key
(d) Filter
Answer:
(c) Primary Key

(iv) In LibreOffice Base, to visually enter and update data in a user-friendly way, we generally use a ……….
(a) Form
(b) Macro
(c) Table
(d) Report
Answer:
(a) Form

(v) While designing a form, to ensure users select only from given options, you should use a ………. control.
(a) List Box
(b) Text Box
(c) Date Field
(d) Numeric Field
Answer:
(a) List Box

(vi) While designing a form, it is recommended to get numerical input using the ………. control to ensure
only valid numbers are entered.
(a) Numeric Field
(b) Text Box
(c) Calendar
(d) Radio Button
Answer:
(a) Numeric Field

Question 5.
Answer any 5 out of the given 6 questions. (5×1=5)

(i) ………… is an example of a preventive measure to avoid slips and falls at the workplace.
(a) Wearing headphones
(b) Ignoring warning signs
(c) Using anti-skid mats
(d) Walking barefoot
Answer:
(c) Using anti-skid mats

(ii) Which of the following is classified as a Class C ignition material?

(a) Oil
(b) Plastic
(c) Electrical wiring
(d) Wood
Answer:
(c) Electrical wiring

(iii) The ………… is responsible for ensuring proper ventilation and lighting in a workplace to support
employee well-being.
(a) Maintenance team
(b) Pantry staff
(c) Transport team
(d) Visitor’s desk
Answer:
(a) Maintenance team

(iv) OHS stands for

(a) Occupational Health Standards
(b) Operational Hygiene and Safety
(c) Occupational Health and Safety
(d) Official Health Schedule
Answer:
(c) Occupational Health and Safety

(v) ………. is the process of adapting the workplace to fit the needs and comfort of the worker, improving
efficiency and safety.
(a) Biotechnology
(b) Physiology
(c) Ergonomics
(d) Mechanics
Answer:
(c) Ergonomics

(vi) Which of the following is not an ergonomic practice?

(a) Adjusting your chair to keep your feet flat on the floor
(b) Keeping your back straight and supported
(c) Working long hours without changing posture
(d) Positioning the monitor at eye level
Answer:
(c) Working long hours without changing posture
Section B
Subjective Type Questions [26 Marks]

Answer any 3 out of the given 5 questions on Employability Skills. Answer each question in 20-30 words.
(3×2=6)

Question 6.
Explain any two important principles from the 7 C’s of effective communication that help in delivering a
clear and respectful message.
Answer:
Two essential principles of effective communication are Clarity and Courtesy, Clarity means using simple
and precise language so the receiver can understand the message easily without confusion. Courtesy
involves being respectful and polite, which helps in maintaining good relationships. Together, these
principles ensure the message is understood correctly and received positively, making communication more
impactful and effective.

Question 7.
What do you mean by internal stress?
Answer:
Internal stress generates within the humans regarding unreasonable matters. This internal stress is one of
the most important kind of stress to understand and manage because it keeps on building up as time
passes. For example, some people become used to the kind of hurried, tense, lifestyle of persons living in
large cities.

Question 8.
What are some simple daily practices that can help increase the lifespan and performance of a computer
system?
Answer:
To ensure your computer works efficiently, follow these practices:

• Shut down the system properly instead of forcing power off.

• Clean the keyboard and screen regularly to prevent dust buildup.

• Do not eat or drink near the computer to avoid accidental spills.

• Run disk cleanup and antivirus scans weekly. These steps help in maintaining both hardware and
software health over time.

Question 9.
What are four essential qualities an entrepreneur must possess to be successful in business?
Answer:
Four essential qualities an entrepreneur must possess to succeed in business are:
Risk-taking ability Entrepreneurs must be ready to take calculated risks.
Innovative mindset They should think creatively and bring new ideas.
Self-confidence Belief in their vision and actions is crucial.
Leadership skills They must guide, motivate and manage their teams effectively to achieve business goals.

Question 10.
What are the challenges faced in achieving sustainable development in rapidly growing urban areas?
Answer:
Rapid urbanisation presents major challenges for sustainable development. First, overpopulation in cities
strains housing, water and sanitation systems, leading to poor living conditions. Second, increased pollution
from vehicles, industries and waste harms both human health and the environment. Without proper
planning and resource management, urban growth can become unsustainable, increasing the gap between
environmental protection and economic development goals.

Answer any 4 out of the given 6 questions in 20-30 words each.

Question 11.
Out of various style categories provided by Writer, briefly explain Page Style category.
Answer:
The Page Style category in LibreOffice Writer is used to define the layout and appearance of an entire page.
It controls elements such as page size, orientation, margins, headers, footers and background. By applying a
specific page style, users can maintain a consistent format throughout a document or section. This is
especially useful for creating professional documents like reports, books or newsletters with different
layout needs.

Question 12.
What is the purpose of using Macros in LibreOffice Calc? Mention any two operations that can be
automated using Macros.
Answer:
Macros in LibreOffice Calc are used to automate repetitive tasks by recording a sequence of actions that
can be executed with a single command. They help save time and reduce human error in spreadsheet
operations. Two common operations that can be automated using macros are:

• formatting a selected range of cells with specific styles.

• generating monthly reports with pre-defined calculations and layout.

Question 13.
How does the Goal Seek tool in LibreOffice Calc help in decision-making? Give one practical example of its
use in a real-life situation.
Answer:
The Goal Seek tool in Calc helps users find the required input value to reach a specific target output. It is
useful in situations where you know the result you want but not the value needed to achieve it. For
example, if a student wants an average of 80% across five subjects and knows four subject scores, Goal
Seek can determine the marks needed in the fifth subject.

Question 14.
Why is it important to set relationships between tables in LibreOffice Base? Mention any two key
prerequisites needed before creating a relationship.
Answer:
Setting relationships between tables in LibreOffice Base ensures data consistency and reduces redundancy
by linking related data across tables. This makes data retrieval more efficient and structured.
Two important prerequisites include:

• Each table must have at least one common field (usually with the same data type) to establish a
relationship.
 • The common field should preferably include unique values, such as a primary key, in at least one of
the tables.

Question 15.
What are two important health and safety guidelines to follow while using a computer monitor at the
workspace?
Answer:
To ensure safe and comfortable use of a monitor

• Monitor Height and Distance Position the top of the screen at or slightly below eye level and keep it
about an arm’s length away to reduce eye and neck strain.

• Glare Reduction Adjust lighting to prevent glare on the screen, and take short breaks to rest your
eyes, following the 20-20-20 rule.

Question 16.
What are two common physical problems that may occur due to poor sitting posture while working long
hours on a computer?
Answer:
Poor sitting posture while using a computer for long durations can lead to:

• Back Pain Slouching or not using proper back support strains the spine, especially the lower back.

• Neck and Shoulder Stiffness Incorrect monitor height or leaning forward often can result in tight
neck and shoulder muscles, reducing comfort and productivity. Proper ergonomic set-up is
essential.

Answer any 3 out of the given 5 questions in 50-80 words each. (3×4=12)

Question 17.
(a) What is the advantage of using Styles and Formatting in LibreOffice Writer?
(b) Differentiate between Page Break and Section Break in Writer.
Answer:
(a) The benefit of using Styles and Formatting in LibreOffice Writer is that it ensures consistency in
document design. By applying predefined styles for headings, paragraphs and lists, users can maintain
uniform formatting throughout the document. It also saves time, as changes to a style automatically update
all text linked to it, eliminating the need for manual adjustments.

(b) A Page Break forces content after it to start on a new page, useful for separating chapters or sections. A
Section Break divides the document into independent segments, allowing different formatting (like columns
or margins) within the same page.

Question 18.
Ms. Priya, Finance Head of XYZ Enterprises, has maintained quarterly expense reports for different
departments in separate worksheets of a LibreOffice Calc file. She now wants to consolidate and analyse
the data. Assist her by answering the following:
(a) Which feature in Calc can merge expense data from multiple sheets into one consolidated sheet?
(b) Specify the Menu and Sub-Menu option used to create a summary of all quarterly worksheets.
(c) Which function should she use to calculate the average expenditure across all departments?
(d) She wants to link a cell to an external budget document stored elsewhere. How can she achieve this
Answer:
(a) The Consolidate Data tool in Calc can combine data from multiple sheets into a summary sheet using
predefined functions like sum or average.
(b) Navigate to Data Menu → Consolidate to open the dialog box for generating a combined summary.
(c) The ==AVERAGE() function can compute the average expenditure by referencing the consolidated data
range.
(d) Use Insert → Hyperlink (or Ctrl+K) to link the cell text to the external document’s file path, enabling
one-click access.

Question 19.
As the newly appointed Workplace Safety Officer at a manufacturing unit, you need to educate employees
on accident prevention and emergency response. Answer the following:
(a) Suggest two preventive measures to avoid electrical accidents in the workplace.
(b) Outline two key steps to follow during an emergency evacuation due to a chemical spill.
Answer:
(a) Two Preventive Measures to Avoid Electrical Accidents:

• Regular Inspections Conduct scheduled checks of wiring and equipment to identify and fix faults like
frayed cords or exposed circuits.

• Safety Training Train employees to use insulated tools, avoid overloading outlets and follow
lockout/tagout procedures during repairs.

(b) Two Key Steps for Chemical Spill Evacuation:

• Sound Alarms and Evacuate Immediately activate emergency alerts and guide workers to follow
marked exit routes away from the spill.

• Avoid Exposure and Regroup Move upwind, use safety showers if contaminated and assemble at
designated points for headcount and further instructions.

Question 20.
(a) What are two key benefits of establishing relationships between tables in a database?
(b) Describe how a one-to-many relationship works between database tables.
Answer:
(a) Two key benefits are:

• It eliminates data redundancy by storing information in separate but related tables, reducing
storage needs and maintaining consistency.

• It ensures data integrity by enforcing referential constraints that prevent orphaned records and
maintain accurate relationships between data.

(b) A one-to-many relationship occurs when a single record in the primary table (like a customer) can be
associated with multiple records in a related table (like orders). This is implemented through a foreign key
in the ‘many’ table that references the primary key in the ‘one’ table.

Question 21.
Consider the following table:
 EmpID Name Department Salary Join_Date

E001 Rahul Sales 35000 12/05/2020

E002 Neha HR 42000 03/11/2019

E003 Rahul IT 38000 22/07/2021

Answer the following questions:

(a) While designing this employee database in LibreOffice Base, suggest appropriate data types for the
Emp_ID and Salary fields.
(b) As a database administrator, which field would you designate as the primary key in this table? Justify
your choice.
(c) Identify a field that could serve as an alternate key in this table. Explain your reasoning.
(d) How many attributes (fields) and records (rows) are present in this table?
Answer:
(a) Emp_ID VARCHAR or TEXT (to store alphanumeric employee codes)
Salary DECIMAL or INTEGER (to store numerical salary values with precision)

(b) Emp_ID should be the primary key because

• It uniquely identifies each employee (no duplicates exist).

• It remains constant (unlike names which may repeat).

(c) Join_Date + Name could serve as an alternate key because:

• The combination is likely to be unique for each employee.

• It can help identify employees when their ID isn’t known.

(d) Attributes (fields) 5 (Emp_ID, Name, Department, Salary, Join_Date) Records (rows) 3