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) After submitting a report, Neha received comments like “Your analysis in Section 2 is
very clear and well-supported by data.”
What kind of feedback did Neha receive?
(a) Specific and descriptive
(b) Non-verbal and general
(c) Vague and indirect
(d) Verbal and emotional
Answer:
(a) Specific and descriptive
(ii) What is the first step in managing time effectively?
(a) Avoiding planning
(b) Identifying and prioritising tasks
(c) Ignoring deadlines
(d) Doing everything at once
Answer:
(b) Identifying and prioritising tasks
(iii) Ananya takes deep breaths and practices meditation for 10 minutes before every
exam to calm her mind. This is an example of
(a) self-motivation
(b) emotional intelligence
(c) stress management technique
(d) time management
Answer:
(c) stress management technique
(iv) The Recycle Bin allows users to
(a) permanently delete files
(b) restore deleted files
(c) increase memory
(d) access internet settings
Answer:
(b) Restore deleted files
(v) Which of the following is a myth about entrepreneurship?
(a) Entrepreneurs never fail in business
(b) Entrepreneurs take risks
(c) Entrepreneurs create jobs
(d) Entrepreneurs bring innovation
Answer:
(a) Entrepreneurs never fail in business
(vi) Which of the following is a responsible way to protect cultural heritage and
indigenous knowledge?
(a) Ignoring traditional farming practices
(b) Promoting local crafts and customs
(c) Destroying old monuments
(d) Avoiding folk tales and oral history
Answer:
(b) Promoting local crafts and customs
Question 2.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) Ansh inserted several images but now wants to resize them to maintain uniformity.
Which method is best?
(a) Resize using comer handles
(b) Use save as
(c) Use replace image
(d) Use hyperlink
Answer:
(a) Resize using comer handles
(ii) Rohit added a comment while reviewing a document. How can he remove it later?
(a) Go to Insert → Delete
(b) Right-click the comment and select Delete
(c) Remove from Format tab
(d) Clear all contents
Answer:
(b) Right-dick the comment and select Delete
(iii) Which category of styles applies to table formatting?
(a) Frame
(b) Paragraph
(c) Table
(d) List
Answer:
(c) Table
(iv) What does anchoring an object mean in Writer?
(a) Locking the object
(b) Changing the file format
(c) Setting its fixed position relative to text or page
(d) Exporting it to another app
Answer:
(c) Setting its fixed position relative to text or page
(v) What is the default wrapping mode when inserting an image?
(a) In Background
(b) Page Wrap
(c) No Wrap
(d) Optimal Page Wrap
Answer:
(d) Optimal Page Wrap
(vi) Shivani created a new style using formatting from selected text. Which method did
she use?
(a) From Template
(b) From Selection
(c) Fill Style
(d) Style Updater
Answer:
(b) From Selection
Question 3.
Answer any 5 out of the given 6 questions. (5×1=5 )
(i) Which of the following lets you test different values in formulas without changing the
original data?
(a) Filters
(b) Scenarios
(c) Cell formatting
(d) Autofill
Answer:
(b) Scenarios
(ii) A macro created in Libre Office is saved in
(a) txt format
(b) As part of the document
(c) ods settings
(d) Clipboard
Answer:
(b) As part of the document
(iii) What is the purpose of absolute hyperlinks?
(a) Link to undefined cells
(b) Link to external documents with full path
(c) Move sheets
(d) Format cells
Answer:
(b) Link to external documents with full path
(iv) After enabling ‘Track Changes’, what does Calc display to indicate changes made?
(a) Highlighted cells with details of the change
(b) Hidden comments
(c) Password prompts
(d) Automatically saves the document
Answer:
(a) Highlighted cells with details of the change
(v) Which feature allows adding input from other spreadsheets into one?
(a) Chart
(b) Consolidate
(c) Sort
(d) Scenario
Answer:
(b) Consolidate
(vi) Where can you find the Scenario Manager in Calc?
(a) Data → Scenarios
(b) Tools → Macro
(c) Edit → Scenario
(d) Insert → Object
Answer:
(a) Data — Scenarios
Question 4.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) In a One-to-Many relationship
(a) one record in the first table matches only one record in the second table.
(b) one record in the first table matches many records in the second table.
(c) many records in the first table match many records in the second table.
(d) both tables have the same number of records.
Answer:
(b) one record in the first table matches many records in the second table.
(ii) Which data model organises data in a tree-like structure?
(a) Relational
(b) Network
(c) Hierarchical
(d) Structural
Answer:
(c) Hierarchical
(iii) Which type of field is used to store whole numbers?
(a) Boolean
(b) Integer
(c) Float
(d) Text
Answer:
(b) Integer
(iv) What is the default extension of a LibreOffice Base file?
(a) .odb
(b) .ods
(c) .odt
(d) .odg
Answer:
(a) .odb
(v) Which view allows manual design of queries?
(a) Wizard
(b) Design View
(c) Report View
(d) Table View
Answer:
(b) Design View
(vi) A query that uses mathematical calculations is a
(a) Text Query
(b) SQL Query
(c) Numerical Query
(d) Mathematical Query
Answer:
(c) Numerical Query
Question 5.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) If someone collapses due to cardiac arrest, the first action should be
(a) try to revive them yourself.
(b) move them to comfort.
(c) call emergency services.
(d) look for ID card.
Answer:
(c) call emergency services
(ii) In ergonomics, the chair used at the computer workstation should have
(a) Fixed backrest
(b) Wheels only
(c) Lumbar support
(d) Wooden seat
Answer:
(c) Lumbar support
(iii) One of the key causes of poor air quality at the workplace is
(a) Excessive lighting
(b) Blocked ventilation
(c) Cold weather
(d) Empty bins
Answer:
(b) Blocked ventilation
(iv) First-aid for burns includes
(a) applying ice directly.
(b) covering with dirty cloth.
(c) running cool water over the burn.
(d) scrubbing the burn area.
Answer:
(c) running cool water over the bum
(v) A warning sign near electrical panels is an example of
(a) safety hazard
(b) risk management tool ……..
(c) office design
(d) equipment layout
Answer:
(b) risk management tool
(vi) In the event of fire, one must
(a) hide in a room
(b) collect belongings
(c) use the lift
(d) evacuate immediately
Answer:
(d) evacuate immediately
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 is the importance of feedback in the communication cycle?
Answer:
Feedback is essential in the communication cycle because it confirms whether the
message was understood correctly. It allows the sender to know if the communication
was effective or needs clarification. Feedback ensures the message is complete. helps
avoid confusion and improves mutual understanding.
Question 7.
Describe the qualities required to complete a task independently.
Answer:
To work independently, a person must be self-disciplined, [Link] and
responsible. They should know how to plan activities, manage time and complete tasks
without help. Confidence, focus, and problem-solving skills are also necessary to
overcome challenges and complete the task efficiently within the given time frame.
Question 8.
What is a file and how is it organised in a computer system?
Answer:
A file is a digital document used to store data, such as text, images or programs, Files
are organised in folders (directories) and subfolders in a tree-like structure. This helps
manage, access and store files efficiently on a storage device.
Question 9.
Why is entrepreneurship a good career option?
Answer:
Entrepreneurship is a rewarding career because it offers independence, flexibility and
the opportunity to pursue one’s passion. It allows individuals to create value, generate
income and make a social impact while achieving personal growth and financial success.
Question 10.
How can rainwater harvesting promote sustainable development?
Answer:
Rainwater harvesting collects and stores rainwater for future use. It reduces
dependence on groundwater, prevents water wastage and ensures water availability
during dry seasons. This eco-friendlv method helps in conserving water — a crucial step
toward sustainable living.
nswer any 4 out of the given 6 questions in 20-30 words each. (4×2=8)
Question 11.
How can a new style be created using the ‘From Selection’ method in Writer?
Answer:
To create a new style from the selection, first format a paragraph, text, or object as
desired. Then open the Styles and Formatting window, click on the drop-down menu,
and select New Style from Selection. This saves the selected formatting as a new style
that can be applied elsewhere in the document easily.
Question 12.
What is the use of creating references between multiple sheets in Calc?
Answer:
Creating references between sheets allows data from one sheet to be used in formulas
in another. For example, you can total expenses from “Sheeti” and show the result in
“Sheet2.” This method helps keep data organised. avoids duplication, and maintains
dynamic connections—so when data in the original sheet changes, the referenced sheet
updates automatically.
Question 13.
What is the process of accepting or rejecting changes in a shared spreadsheet?
Answer:
After recording changes in a shared CaIc file, users or reviewers can go to Edit — Track
Changes — Manage Changes to see the list of modifications. Each change can be
reviewed individually and either accepted or rejected. This feature ensures that only
approved edits are finalised, maintaining control over collaborative document editing.
Question 14.
Explain the process of creating a table in LibreOffice Base using the Wizard.
Answer:
To create a table using the wizard in LibreOffice Base, follow these steps:
Open your database and select ‘Tables’ from the left pane.
Click “Use Wizard to Create Table.”
Choose a categmy and a predefined sample table,
Select the fields you want to include, rename them if needed and set data types.
Choose a primary key and dick ‘Create’.
This method is beginner-friendly and helps build tables quickly.
Question 15.
What are the key steps to follow during a fire emergency in the workplace?
Answer:
During a lire emergency. activate the alarm immediately and evacuate the premises
calmly through designated exits. Avoid using elevators. Follow the fire safety plan and
assist others if needed. Do not re-enter the building until it is declared safe by the fire
department- Fire drills and awareness training ensure everyone knows how to respond
promptly and safely.
Question 16.
What safety measures should be taken while handling office equipment?
Answer:
Use equipment only after proper training and follow manufacturer guidelines. Ensure
machines are turned off after use and report any malfunctions. Avoid wearing loose
clothing or accessories that may get caught in equipment Regular maintenance and
keeping emergency shut-off switches accessible are vital for preventing accidents.
Answer any 3 out of the given 5 questions in 50-80 words each. (3×4=12)
Question 17.
(a) What is the purpose of using templates in LibreOffice Writer?
Answer:
Templates in Libre office Writer provide a predefined layout and formatting for new
documents. They include styles head ings.
logos, and default text placeholders. Using templates ensures consistency across
documents and saves time by eLiminating
repetitive formatting. They are especially useful in workplaces for creating standardised
letters. reports and forms. Writer offers both in-built and user-created templates to suit
different needs.
(b) Describe how you can modify a form in LibreOffice Writer.
Answer:
Modifying a form in Wnter Involves accessing the Form Design toolbar. You can select
form controls like test boxes, labels, or combo boxes and adjust properties such as size,
name, and default value. You may also add new controls or remove existing ones. This
allows customisation of user interaction within the document, particularly useful for
creating interactive forms, surveys or data entry sheets.
Question 18.
Mr. Rajiv, a school administrator, manages monthly expenses in different sheets for
departments like Sports, Library, and IT. He wants to summarise all expenses, create
quick calculations and share the spreadsheet with department heads for feedback.
(a) What feature should Mr. Rajiv use to combine department expenses into one sheet?
(b) How can he simplify entering monthly budget headings across all department
sheets?
(c) Rajiv wants to test if reducing Library funds by 10% affects total expenses. Which tool
should he use?
(d) How can Mr. Rajiv ensure all changes by department heads are visible for review?
Answer:
(a) Mr. Rajiv can use the Consolidate feature from the Data menu. It helps him merge
values from multiple sheets into one summaty sheet using functions like Sum, Average,
etc.
(b) He can record a macro to enter headers such as 7anuar” “February” etc., once and
then run the macro on each sheet. This saves time and ensures consistency.
(c) He can use the What-U Scenario tool to create two versions: original and reduced
Library budget. Switching between them shows the difference in total expenses.
(d) The should enable Track Changes from the Edil Track Changes -s Record menu. This
logs all edits, which he can later review, accept or reject.
Question 19.
You are conducting a workshop for new recruits who spend 6 – 8 hours daily on
computers. You must explain good ergonomic practices and health tips.
(a) What are two ergonomic tips to follow while using a computer?
Answer:
Proper ergonomies involve maintaining an upright posture with feet flat on the floor
and the monitor at eye level. The keyboard and mouse should be pesutioned so elbows
stay bent at about 90 degrees. Use a chair with lumbar support to prevent back pain.
Also, take short breaks every hour to stretch or walk. These practices reduce the risk of
musculoskeletal disorders, fatigue and eye strain among computer users.
(b) Name two health issues caused by prolonged computer use.
Answer:
Long hours on a computer can cause eye strain. resulting in blurry vision, dryness and
headaches. Additionally, poor posture may lead to chronic necic back and shoulder pain.
These issues, collectively called Computer Vision Syndrome or occupational Overuse
Syndrome. can impact work productivity and personal well-bein Preventive measures
such as ergonomic setups. adequate lighting, and scheduled breaks help reduce these
risks and maintain physical health during extended computer use.
Question 20.
(a) What are the main advantages of using a Database Management System (DBMS)
compared to traditional file-based systems? Explain briefly.
Answer:
A DUMS reduces data redundancy by storing information centrally rather than In
separate hies.
It maintains data integrity through constraints like pnmarv and foreign keys,
Security features including user authentication and encryption protect sensitive
information.
Multiple users can access and modify data simultaneously without conflicts.
Automated backup and recovery systems prevent permanent data baa.
All applications access the same updated information. ensuring consistency.
(b) What is a Relational Database Model and why is it widely used?
Answer:
The Relational Database Model organises data into tables (relations) consisting of rows
and columns. Each table has a unique key and is related to other tables through foreign
keys. It is widely used due to its simplicity flexibility and ease of understanding. Users
can query data using SQI. and normalisation reduces redundance making it suitable for
various applications like banking, education and inventory management.
Question 21.
Consider the following table:
(a) Suggest suitable data types for the Roll_No and Marks fields
Answer:
(a) Roll_No Integer (since it stores numeric student mil numbers)
Marks Integer (to store whole number marks, but Decimal Numeric could also be used it
fractional marts are possible).
(b) Which field should be set as the primary key and why?
Answer:
(b) Field Roll_No
Roll_No uniquely identifies each student record (no duplicates), is non-null, and remains
constant (unlike names or subjects, which may repeat).
c) Identify a possible alternate key and justify.
Answer:
Field Name + Subject + Marks combination While names and subjects may repeat (e.g.,
“Neha” in “English”), the combination with Marks ensures uniqueness, as no two
students share the same name, subject and marks.
(d) How many attributes and records are present?
Answer:
Attributes (Columns) 4 (Roll_No, Name, Subject, Marks)
Tuples (Records) 3 (Rows for Roll No 101, 102, 103)