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
Answer any 4 out of the given 6 questions on Employability Skills. (4×1=4)
(i) While speaking to a teacher, Arun kept slouching and checking his watch
repeatedly. What does Arun’s body language likely communicate?
(a) He is respectful and attentive.
(b) He is nervous but interested.
(c) He is uninterested or impatient.
(d) He is excited and ready.
Answer:
(c) He is uninterested or impatient.
(ii) What does the SMART acronym stand for in goal setting?
(a) Simple, Manageable, Accurate, Reliable, Timely
(b) Specific, Measurable, Achievable, Relevant, Time-bound
(c) Small, Medium, Achievable, Realistic, Trackable
(d) Strong, Meaningful, Applicable, Reasonable, Time-efficient
Answer:
(b) Specific, Measurable, Achievable, Relevant, Time-bound
(iii) Zara enjoys long walks in the park after a hectic day at school to feel refreshed.
This is an example of
(a) nature walk as a stress buster.
(b) peer pressure.
(c) poor time management.
(d) emotional dependence.
Answer:
(a) nature walk as a stress buster.
(iv) In the Windows OS, right-clicking on a file and selecting ‘Rename’ allows a user to
(a) Delete the tile
(b) move the file to another folder
(c) change the file name
(d) copy the file
Answer:
(c) Change the file name(v) Which of the following statements about
entrepreneurship as a career is correct?
(a) It has no scope.
(b) It only suits rich people.
(c) It offers independence and opportunities.
(d) It is always easier than jobs.
Answer:
(c) It offers independence and opportunities
(vi) Which of these actions best reflects environmental citizenship?
(a) Throwing waste in rivers
(b) Conserving energy and water
(c) Ignoring pollution rules
(d) Wasting food and electricity
Answer:
(b) Conserving energy and water
Question 2.
Answer any 5 out of the given 6 questions. (5 x 1 = 5)
(i) Varun created a business letter template and now wants to reuse it for another
letter. What should he do?
(a) Save as draft
(b) Use in-built template
(c) Open Template and save as new document
(d) Print directly
Answer:
(c) Open Template and save as new document
(ii) Priya added a watermark but it’s covering the text. What can she change?
(a) Wrap setting
(b) Layer order
(c) Transparency
(d) Paragraph style
Answer:
(c) Transparency
(iii) Which of the following is a style category for bullet points’
(a) Table
(b) Character
(c) List
(d) Frame
Answer:
(c) List
(iv) What does the term ‘Anchoring’ refer to in Writer?
(a) Creating links
(b) Fixing objects to a part of the document
(c) Making styles
(d) Writing formulas
Answer:
(b) Fixing objects to a part of the document
(v) Which menu helps in recording changes in a document?
(a) Edit
(b) View
(c) Tools
(d) File
Answer:
(c) Tools
(vi) Rajat deleted a Table of Contents by mistake, What is the best way to restore it?
(a) Ctrl+Z
(b) Reinsert using Insert → Table of Contents
(c) Rebuild the whole document
(d) Use Templates
Answer:
(b) Reinsert using Insert → Table of Contents
Question 3.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) Which feature helps compare changes made by different users in a spreadsheet?
(a) Coal Seek
(b) Merge Document
(c) Format Cells
(d) Autofilt
Answer:
(b) Merge Document
(ii) The Subtotal feature is found under
(a) Format
(b) Tools
(c) Data
(d) View
Answer:
(c) Data
(iii) After reviewing the changes, how can you stop others from editing the document
further?
(a) Disable sharing by unchecking ‘Share Document’ in Tools
(b) Turn off the computer
(c) Remove Track Changes only
(d) Save itas a [Link] document
Answer:
(a) Disable sharing by unchecking ‘Share Document’ in Tools
(iv) A hyperlink in Caic can be used to
(a) add borders
(b) insert comments
(c) navigate to another document
(d) calculate totals
Answer:
(c) Navigate to another document
(v) The shortcut to add a new comment in a Cale cell is
(a) Ctrl + M
(b) Ctrl + Alt + C
(c) Ctrl + Shift + C
(d) Ctrl + F2
Answer:
(b) Ctrl+Alt+C
(vi) In Calc, which feature lets you see what others have edited in a shared
document?
(a) Scenario Manager
(b) Consolidate
(c) Track Changes
(d) Paste Special
Answer:
(c) Track Changes
Question 4.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) Which feature in Base allows you to create structured output for printing data
from tables or queries?
(a) Report
(b) Form
(c) Table
(d) Query
Answer:
(a) Report
(ii) Which one of the following data types stores decimal numbers?
(a) Integer
(b) Text
(c) Numeric (Decimal)
(d) Boolean
Answer:
(c) Numeric (Decimal)
(iii) What is the purpose of using a wizard in Base?
(a) To enter data
(b) To automate database tasks
(c) To create database objects step-by-step
(d) To write queries in SQL
Answer:
(c) To create database objects step-by-step
(iv) Which control is used to show static text on a form in Base?
(a) Text Box
(b) Label
(c) Combo Box
(d) List Box
Answer:
(b) Label
(v) A query that retrieves data based on specific criteria is known as
(a) Static query
(b) Conditional query
(c) Filter query
(d) Select query
Answer:
(d) Select query
(vi) What ensures consistency and prevents orphaned records when tables are
related?
(a) Primary key
(b) Foreign key
(c) Referential integrity
(d) Data type
Answer:
(c) Referential integrity
Question 5.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) Which of the following is a correct safety practice while using a paper shredder?
(a) Push papers in with your fingers
(b) Turn it on before plugging in
(c) Keep hands away from the opening
(d) Shred one large pile at once
Answer:
(c) Keep hands away from the opening
(ii) What should you avoid doing during a fire emergency?
(a) Use the stairs
(b) Help others evacuate
(c) Use the elevator
(d) Follow the fire escape plan
Answer:
(c) Use the elevator
(iii) What does Refer to MSDS mean when working with chemicals?
(a) Maximum safe data score
(b) Material Safety Data Sheet
(c) Monthly supply demand system
(d) Machine safety and disposal sheet
Answer:
(b) Material Safety Data Sheet
(iv) Which of the following is a symptom of computer vision syndrome?
(a) Knee pain
(b) Dry eyes
(c) Chest pain
(d) Neck rash
Answer:
(b) Dry eyes
(v) Which one of these is considered an ergonomic device?
(a) Adjustable chair
(b) Paper file
(c) Loudspeakers
(d) Mirror
Answer:
(a) Adjustable chair
(vi) What should be done immediately after any workplace accident?
(a) Ignore it
(b) Inform your supervisor
(c) Wait till end of shift
(d) Cover it up
Answer:
(b) Inform your supervisor
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 descriptive feedback? Give an example.
Answer:
Descriptive feedback is detailed and specific, explaining what was done well and
what needs improvement. It helps learners grow. For example, “Your report was
well-organized, but adding more data to support your argument would make it
stronger” is an example of descriptive feedback.
Question 7.
Why is the ability to work independently important?
Answer:
The ability to work independently builds self-confidence, responsibility-and time
management skills. It allows individuals to set and achieve goals without needing
constant supervision. This quality is valuable in both academics and the workplace,
as it encourages problem-solving and increases productivity.
Question 8.
Describe how to create, rename and delete a folder in a computer.
Answer:
To create a folder Right-click → New xFolder.
To rename Right-click the folder → Rename → Type new name.
To delete Right-click → Delete or press Del key.
Question 9.
How can students prepare themselves to become future entrepreneurs?
Answer:
Students can prepare by developing skills like communication, decision-making and
problem-solving. Participating in business clubs, reading about entrepreneurs,
attending workshops and working on small projects can build confidence. Learning
from failures and being open to feedback also helps in building a strong
entrepreneurial mindset.
Question 10.
What are the benefits of respecting indigenous knowledge in sustainability?
Answer:
Indigenous knowledge includes traditional farming, water conservation and natural
medicine practices. Respecting it helps protect biodiversity, preserve cultural
heritage and promote eco-friendly practices. It offers valuable solutions for
sustainable resource management and environmental conservation.
Answer any 4 out of the given 6 questions in 20-30 words each. (4×2=8)
Question 11.
What does the Fill Format mode do in Writer?
Answer:
Fill Format mode in LibreOffice Writer lets users quickly apply an existing style to
different parts of the document. By selecting the Fill Format tool in the Styles and
Formatting window, and then clicking on text or objects, the selected style is applied
instantly. This saves time and ensures uniform formatting across the document.
Question 12.
What are subtotals in Calc and how are they applied?
Answer:
Subtotals in Calc are used to calculate group-wise totals for large data sets. When
you have a sorted list of items like sales by region, applying the Subtotal feature lets
you see totals per region automatically. Calc inserts rows for each group showing the
sum, average or other functions, making data analysis easier and faster.
Question 13.
What do you mean by recording changes in a spreadsheet?
Answer:
Recording changes in spreadsheet allows users to track modifications made to a
shared spreadsheet. When this feature is turned on, Calc highlights added, deleted
or edited content, along with the user’s name and timestamp. This is useful for
document review and collaboration, especially when multiple users are editing the
same file.
Question 14.
Describe any two data types used in LibreOffice Base.
Answer:
Two common data types in LibreOffice Base are:
Text (VARCHAR) Used for storing alphanumeric data such as names, addresses,
etc.
Number (INTEGER, DECIMAL) Used for storing numeric values. For example,
INTEGER for age and DECIMAL for salary.
Selecting the appropriate data type ensures proper storage, validation and
operations on the data, such as calculations or sorting.
Question 15.
What is the importance of regular cleaning and hygiene at the workplace?
Answer:
Maintaining cleanliness at the workplace helps prevent the spread of germs and
reduces health risks such as respiratory infections or allergies. It also improves air
quality and creates a pleasant, professional environment. Clean surfaces, sanitized
washrooms and waste disposal systems are essential. Regular cleaning promotes
employee health and enhances productivity.
Question 16.
What precautions should be taken when working near electrical equipment?
Answer:
Always ensure electrical devices are grounded properly and turned off when not in
use. Avoid handling them with wet hands or near water. Use surge protectors and
inspect cords for wear or damage. In case of an electrical emergency, shut off the
power and seek professional help immediately. These practices help prevent shocks,
fires and equipment damage.
Question 17.
(a) What is the function of the Alignment option in positioning images?
Answer:
The Alignment option in Writer helps position images in relation to the page or
paragraph. You can align an image to the left, center, right, top or bottom. This
ensures the image is placed exactly where desired, improving visual appeal and
readability. Proper alignment is essential when combining images and text, especially
in professional documents or presentations.
(b) How does the ‘Accept or Reject Changes’ feature help during document review?
Answer:
The ‘Accept or Reject Changes’ feature in Writer allows you to review edits made by
others during collaboration. It highlights insertions, deletions and formatting
changes. You can go through each change and decide whether to keep or discard it.
This ensures the final document is accurate, consistent and reviewed thoroughly. It is
a vital tool for editors and collaborative writing tasks.
Question 18.
An accountant, Mr. Suresh, maintains annual sales records. He wants to automate
tax calculation, apply different tax rates and allow colleagues to comment on the file.
(a) How can he automate tax calculations for all rows?
Answer:
He can create a macro that applies a formula to calculate tax. Running this macro
across all rows will quickly apply the calculation to every entry.
(b) To apply two tax slabs ( 5% and 12% ) and see which benefits the company more,
what tool should he use?
Answer:
He can use the Scenario Manager to create and switch between the two tax slabs.
This helps him analyse which tax rate yields better financial results.
(c) A colleague wants to suggest corrections. How can he add that in the file?
Answer:
The colleague can use Insert ? Comment to add notes on any cell. Mr. Suresh will be
able to read and act on the suggestion later.
(d) How can Mr. Suresh identify who made changes in the spreadsheet?
Answer:
By enabling Track Changes and using Edit ? Track Changes → Manage, he can view,
accept or reject the changes made by others, along with their names.
Question 19.
Your company has recently experienced minor electric shocks in a few departments.
You’ve been asked to create a report and educate employees about the importance
of electrical safety and how to respond during electrical emergencies.
(a) What are two key electrical safety tips employees should follow?
Answer:
To ensure electrical safety, employees should never operate electrical equipment
with wet hands, as it increases the risk of electric shock. Also, damaged plugs or
exposed wires should never be used. These items must be reported immediately to a
qualified technician for repair. Plug points should not be overloaded. Following these
precautions can significantly minimise electrical hazards and protect both employees
and office equipment from accidents or short circuits.
Value Points
Focus on common workplace risks:
Never use devices with wet hands.
Never use damaged plugs or wires.
(b) Mention two first aid measures to be taken during an electrical emergency.
Answer:
In an electrical emergency, the first step is to switch off the power source before
touching the affected person to avoid further shocks. Next, use a non-conductive
item like a wooden stick to separate the person from the electric source. If the victim
is unconscious, check for breathing and pulse. Administer CPR if trained and call
emergency services immediately. Always follow safety protocols and act quickly to
prevent severe injury or death.
Question 20.
(a) What are reports in Base and how are they different from queries?
Answer:
Reports are formatted presentations of data retrieved from tables or queries,
suitable for printing and sharing. While queries extract and filter data, reports are
used to display this data attractively with headers, footers, page numbers, and
formatting. They are useful for summarising information like monthly sales or
student results, providing a clear and professional view for decision-making.
(b) How can you insert date and time in a Base report?
Answer:
To insert date and time, open the report in edit mode and use the ‘Insert’ menu to
add a date/time field. You can place it in the header, footer, or any section of the
report. This feature is useful for indicating when the report was generated and helps
in record keeping and validation of printed data.
Question 21.
Consider the following table:
(a) Suggest a suitable data type for the Route_ID and Driver_Name.
Answer:
Suggested Data Types
Route_ID Character/Varchar (to store alphanumeric route IDs like “R01”)
Driver_Name Varchar (to store names of variable length)
(b) Which field should be set as the primary key and why?
Answer:
Primary Key Selection
Field Route_ID
Justification Route_ID uniquely identifies each bus route (no duplicates), is non-
null, and remains constant (unlike start/end points or driver names, which may
repeat).
(c) Identify a possible alternate key and justify.
Answer:
Candidate Key
Field Start_Point + End_Point + Driver_Name combination
Reason While start and end points may repeat (e.g., “Sector 1” to “School”),
the combination with Driver_Name ensures uniqueness, as no two routes share
the same start, end and driver.
(d) How many attributes and records are present?
Answer:
Table Structure Analysis
Attributes (Columns) 4 (Route_ID, Start_Point, End_Point, Driver_Name)
Tuples (Records) 3 (Rows for R01, R02, R03)