Instructions:
Please read the instructions carefully.
This Question Paper consists of 21 questions in two sections: Section A & Section
B.
Section A has Objective Type Questions whereas Section B contains Subjective
Type Questions.
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.
All questions of a particular section must be attempted in the correct order.
Section A: Objective Type Questions (24 Marks)
This section has 05 questions.
Marks allotted are mentioned against each question/part.
There is no negative marking.
Do as per the instructions given.
Section B: Subjective Type Questions (26 Marks)
This section has 16 questions.
A candidate has to do 10 questions.
Do as per the instructions given.
Marks allotted are mentioned against each question/part.
Section A
Objective Type Questions
Question 1.
Answer any 4 out of the given 6 questions on Employability Skills. (4×1=4)
(i) Samar wrote a notice full of difficult words and unclear instructions. Many students
ignored it. Which principle of communication was violated?
(a) Concreteness
(b) Conciseness
(c) Clarity
(d) Completeness
Answer:
(c) Clarity
(ii) Which of the following is the most suitable term for managing stress through regular
walking in a natural environment?
(a) Physical fitness
(b) Nature walk
(c) Morning exercise
(d) Forest workout
Answer:
(b) Nature walk
(iii) Arjun studies regularly, stays focused on his goals, and encourages himself even
when results aren’t immediate. This shows:
(a) carelessness
(b) laziness
(c) self-motivation
(d) distraction
Answer:
(c) self-motivation
(iv) A good way to protect your system from viruses is to
(a) ignore software updates.
(b) open all email attachments.
(c) use antivirus software and scan regularly.
(d) keep the computer always turned off.
Answer:
(c) use antivirus software and scan regularly.
(v) One of the key roles of an entrepreneur in society is to
(a) avoid competition
(b) reduce employment opportunities
(c) promote social and economic development
(d) work in a bank
Answer:
(c) promote social and economic development.
(vi) Which one of these models best supports sustainable living?
(a) Diesel generator
(b) Solar cooker
(c) Plastic incinerator
(d) Coal heater
Answer:
(b) Solar cooker
Question 2.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) Preeti wants to apply the same formatting from one paragraph to another quickly.
Which feature should she use?
(a) Format Paint
(b) Fill Format
(c) Clone Formatting
(d) Copy-Paste
Answer:
(b) Fill Format
(ii) Rahul inserted an image in his document but wants to wrap text tightly around it.
Which option should he use?
(a) In Background
(b) Page Wrap
(c) Optimal Page Wrap
(d) Through
Answer:
(c) Optimal Page Wrap
(iii) Which of the following is a category of style in Writer?
(a) Shape Style
(b) Image Style
(c) Frame Style
(d) Caption Style
Answer:
(c) Frame Style
(iv) Which menu is used to insert a Table of Contents in Writer?
(a) Insert → Indexes and Tables
(b) View → Navigator
(c) Tools → AutoText
(d) Format → Table of Contents
Answer:
(a) Insert → Indexes and Tables
(v) What is the use of a template in LibreOffice Writer?
(a) To save passwords
(b) To create identical charts
(c) To reuse predefined document formats
(d) To organise menus
Answer:
(c) To reuse predefined document formats
vi) Jyoti is preparing a school magazine using a template. She wants to apply a different
template to a blank document. Which option should she use?
(a) Import Template
(b) Export Template
(c) Apply Template
(d) Insert Template
Answer:
(c) Apply Template
Question 3.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) In Calc, which tool lets you test formulas under different scenarios?
(a) Goal Seek
(b) Solver
(c) Scenario Manager
(d) Filter
Answer:
(c) Scenario Manager
(ii) In a shared spreadsheet, which action shows all previous edits?
(a) Accept Change
(b) Show Changes
(c) Update Sheet
(d) Sort Data
Answer:
(b) Show Changes
(iii) A macro can be created using
(a) Tools → Macros → Record Macro
(b) Edit → Macros
(c) Data → Macro Tool
(d) Insert → Record
Answer:
(a) Tools → Macros → Record Macro
(iv) Which hyperlink allows connection to a data source?
(a) Web link
(b) Document link
(c) Registered data source link
(d) Text link
Answer:
(c) Registered data source link
(v) Which Calc feature consolidates data from multiple ranges?
(a) Group
(b) Chart
(c) Consolidate
(d) Solver
Answer:
(c) Consolidate
(vi) Which menu lets you create a scenario in Calc?
(a) Data → Scenario
(b) Insert → Scenario
(c) Tools → Scenario
(d) Format → Scenario
Answer:
(a) Data → Scenario
Question 4.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) Priya is designing a database of student details. She wants to ensure each record is
uniquely identified. Which action should she take while creating the table in design
view?
(a) Sort the records
(b) Set a primary key
(c) Hide duplicate fields
(d) Apply referential integrity
Answer:
(b) Set a primary key
(ii) Which tool in LibreOffice Base is used to display selected data from one or more
tables based on specific conditions?
(a) Report
(b) Query
(c) Form
(d) Filter Wizard
Answer:
(b) Query
(iii) What does referential integrity ensure in relational databases?
(a) Data is sorted alphabetically.
(b) All linked tables are deleted.
(c) Consistent and valid relationships between tables.
(d) All data is converted to text.
Answer:
(c) Consistent and valid relationships between tables
(iii) What does referential integrity ensure in relational databases?
(a) Data is sorted alphabetically.
(b) All linked tables are deleted.
(c) Consistent and valid relationships between tables.
(d) All data is converted to text.
Answer:
(c) Consistent and valid relationships between tables
(v) Which of the following is not an object of LibreOffice Base?
(a) Table
(b) Form
(c) Slide
(d) Query
Answer:
(c) Slide
(vi) While editing a form in LibreOffice Base, Meena wants to display a fixed text title at
the top of the form. Which form control should she insert?
(a) Date Field
(b) Label
(c) Text Box
(d) Numeric Field
Answer:
(b) Label
Question 5.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) Priya works long hours on a computer without adjusting screen brightness or taking
breaks. She starts experiencing blurry vision and eye strain. Which safety measure could
reduce this?
(a) Use a dark background wallpaper
(b) Lower the monitor below eye level
(c) Take frequent eye breaks and adjust monitor brightness
(d) Increase screen resolution to maximum
Answer:
(c) Take frequent eye breaks and adjust monitor brightness
(ii) ………. is the science that focuses on designing tools and workspaces to fit human
needs and prevent strain.
(a) Physiology
(b) Ergonomics
(c) Kinesiology
(d) Automation
Answer:
(b) Ergonomics
(iii) Which of the following is not a physical hazard in the workplace?
(a) Poor ventilation
(b) Loud noise
(c) Bright lighting
(d) Delayed email response
Answer:
(d) Delayed email response
(iv) The purpose of workplace safety policies is to
(a) increase workload
(b) reduce worker rights
(c) prevent accidents and injuries
(d) promote overtime
Answer:
(c) prevent accidents and injuries
(v) A slippery floor, uncovered wires, and poor lighting are examples of
(a) Chemical hazards
(b) Biological hazards
(c) Physical hazards
(d) Visual hazards
Answer:
(c) Physical hazards
(vi) Which of the following should not be done while working on electrical equipment?
(a) Wear dry gloves
(b) Work with wet hands
(c) Use insulated tools
(d) Switch off power before repairing
Answer:
(b) Work with wet hands
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.
What are two ways to overcome communication barriers?
Answer:
One way to overcome communication barriers is by using simple and clear language that
is easy to understand. Another way is through active listening, which means paying full
attention to the speaker without interrupting. Both methods help reduce
misunderstandings and improve effective communication.
Question 7.
What is stress management and why is it important?
Answer:
Stress management involves techniques and practices that help a person cope with
stress in a healthy way. It is important because unmanaged stress can lead to physical
and mental health issues. Managing stress effectively improves concentration,
productivity, emotional balance and overall well-being in personal and professional life
Question 8.
What is the purpose of installing antivirus software on a computer?
Answer:
Antivirus software protects a computer from maiware, viruses, spyware and other
malicious threats. It scans files and programs, prevents unauthorjsed access and alerts
the user to suspicious activity. Regularly updated antivirus ensures data security and
helps maintain the computer’s smooth arid safe operation.
Question 9.
What is the role of entrepreneurship in society?
Answer:
Entrepreneurship promotes economic development. creates jobs and introduces
innovations that improve the quality of life. Entrepreneurs solve local problems with
creative solutions and contribute to community welfare by supporting infrastructure,
education and sustainability.
Question 10.
Explain any two problems related to sustainable development.
Answer:
Two major problems are:
Overuse of natural resources, which leads to deforestation, soil erosion and
depletion of minerals;
Pollution, including air, water, and land pollution, which harms health and
biodiversity making it harder to maintain ecological balance.
Answer any 4 out of the given 6 questions in 20-30 words each (4×2=8)
Question 11.
What is meant by the ‘Track Changes’ feature in Writer and when is it useful?
Answer:
Track Changes in Writer is a feature that records all modifications made to a document.
such as deletions, insertions and formatting updates. It is especially useful during
document reviews or collaborations. Reviewers can suggest changes, and the author can
later accept Or reject them, ensuring controlled and transparent editing.
Question 12.
Explain the function of the What-if Analysis tool in Calc.
Answer:
The What-if Analysis tool in Caic allows users to see how changes in input values affect
the outcome of formulas. For example, if you’re calculating profit based on selling price
and quantity, you can test different prices to see how profits change. This tool is useful
for decision-making, budgeting and forecasting.
Question 13.
How can you edit a hyperlink in Calc?
Answer:
To edit a hyperlink in Calc, tight-click the hyperlink and choose Edit Hyperlink. A dialog
box appears where you can change the link’s
target, text or type (e.g., IJRL document, email). Editing hyperlinks helps ensure accuracy
and maintain relevance if file locations or linked documents change.
Question 14.
Define Relational Database Management System (RDBMS). Give two examples of its
objects.
Answer:
A Relational Database Management System (RDBMS) stores data in related tables. It
uses structured relationships based on keys (primary and foreign) to manage data
efficiently and eliminate redundancy. Examples of objects in an RDBMS include tables
(which store the data), queries (used to retrieve specific information), forms (used for
user-friendly data entry) and reports (used Ior’formatted output and printing purposes).
Question 15.
What are two common physical hazards found in office environments?
Answer:
Slipping on wet floors and tripping over cables or loose carpeting are common physical
hazards in offices. These hazards can lead to injuries like sprains, fractures or even head
trauma. Ensuring clean, dry floors and properly managed wires can significantly reduce
these risks, Regular inspections and proper signage also help maintain a safe work
setting.
Question 16.
What are the basic guidelines for maintaining good air and water quality in the
workplace?
Answer:
Air quality can be maintained by ensuring proper ventilation, using air purifiers and
keeping the workspace dust-free. Avoiding chemical pollutants and regular HVAC
maintenance is essential. For clean water, ensure regular testing, proper filtration and
accessible sanitation facilities. Promoting a clean, hygienic environment supports the
overall health and safely of employees.
Answer any 3 out of the given 5 questions in 50-80 words each. (3×4=12)
Question 17.
(a) What is the benefit of using the Fill Format mode in Styles and Formatting?
Answer:
The Fill Format mode in LibreOffice Writer allows users to apply a selected style to
multiple sections of the document quickly. Once the mode is activated, the chosen style
can be “painted” onto different text blocks or elements simply by clicking. This is
particularly useful for maintaining consistency in formatting, especially when editing
large documents. It saves time and ensures that the formatting stays uniform
throughout the file.
(b) How does anchoring help in positioning images within text in Writer?
Answer:
Anchoring in LibreOffìce Writer determines how an image is connected to a particular
part of the document. You can anchor an image to a paragraph. character, or page. This
setting ensures that the image moves appropriately when the text is edited. For
example, anchoring to a paragraph keeps the image with that paragraph. while
anchoring to the page keeps the image fixed in one location. It helps maintain the layout
and flow of the document.
Question 18.
Mrs. Reema, the Head of the Academic Department at Sunrise School, is preparing the
annual academic performance report. Each subject teacher has maintained their own
spreadsheet for student marks in different worksheets. Mrs. Reema now wants to
combine all subject-wise data, automate repetitive entries, analyse results using
scenarios, and collaborate with teachers by tracking their feedback and suggestions.
(a) Which feature should Mrs. Reema use to combine student marks from different
subject worksheets into one final result sheet?
(b) To automate the task of entering common remarks like ‘Passed’ or ‘Needs
Improvement’ for multiple students, which tool should she use?
(c) Mrs. Reema wants to evaluate how the overall class result changes if passing criteria
are modified from 35 to 40 marks. Which tool will help her simulate and compare this?
(d) Since the final report is shared among subject teachers for review, how can Mrs.
Reema ensure all edits and suggestions made by them are tracked?
Answer:
(a) Mrs. Reema should use the ‘Consolidate’ feature found under Data →Consolidate.
This allows her to select each subject sheet as a data source and apply functions like
Sum or Average to summarise student marks in one central location.
(b) She can record a Macro using Tools → Macros → Record Macro, where she enters
the remark once. Later, she can run this macro repeatedly, saving time and avoiding
manual errors while adding feedback across rows.
(c) She should use the What-if Scenarios feature available under Tools → Scenarios. By
creating different scenarios like “Pass at 35 marks” and “Pass at 40 marks,” she can
instantly switch views and analyse the impact on the overall class result.
(d) She can enable Track Changes from Edit → Track Changes → Record. This records all
changes made by teachers. Later, she can review them under Edit → Track Changes →
Manage Changes, where she can Accept or Reject each change.
Question 19.
A worker accidentally drops a heavy object on his foot. As a safety officer, you need to
educate others on how to handle such emergencies and the importance of reporting.
(a) What two actions should you take when an accident occurs at work?
Answer:
When an accident happens, immediately help the injured employee and ensure their
safety. If the inlury is serious, call for medical help without delay, Next, report the
incident to the supervisor with complete details, including how and where it happened.
If possible, isolate the accident area to prevent others from being hurt harm and
ensures proper care and investigation of the event.
(b) Why is it important to follow accident-reporting procedures?
Answer:
Following accident-reporting procedures helps identify workplace hazards and prevent
them in the future. It ensures the injured person receives proper care and support.
Timely reporting is also essential for legal compliance and helps the organisation
maintain a safe working environment. Proper documentation helps with insurance
claims and future safety training. Ignoring accidents or delaying reports can lead to
serious consequences for both employees and employers.
Question 20.
(a) What are queries in LibreOffice Base? Why are they used?
Answer:
Queries are used to extract specific information from a database by applying criteria and
filters. The alois’ users to view. update. or surnmarise data across one or more tables.
For instance, a user can create a query to find ‘tudents scoring above 90%. Queries are
essential tools in data analysis and reporting, making large data sets easier to manage
and interpret.
(b) How can you create a query using the design view in Base?
Answer:
In design vie users manually select tables and fields to include in the quer then specify
conditions, sorting and grouping. This method
gives greater control and flexibility compared to the wizard. It is especially useful for
complex queries involving multiple tables, calculated fields and logical expressions. The
design grid allows visual arrangement of fields and conditions, making it efficient for
precise data retrieval.
Question 21.
Consider the following table:
(a) Suggest a suitable data type for the Reg_No and Room_No.
Answer:
Data Trpes
Reg_No → Text (e.g.. “HS101” – alphanumeric, no calculations needed).
Room_No → Number (e.g., 12 — numeric, allows sorting/range queries).
(b) Which field should be set as the primary key and why?
Answer:
Primary Key
Reg_No
Each Reg…No is unique (no duplicates), ensuring no two students share the same
ID.
(c) Identify a possible alternate key and justify.
Answer:
Alternate Key
Contact
Contad numbers are unique in this table (no duplicates)
(d) How many attributes and records are present?
Answer:
Attributes and Records
4 Attributes (columns) [Link]. Name, Rom_No, Contact.
3 Records (rows) Entries for HS101, HS102, H5103.