SAMPLE PAPER
CLASS-X TIME : 2 HRS SUBJECT
: INFORMATION TECHNOLOGY (SET-B) M.M-50
NAME OF STUDENT : ……………………….. SECTION : ……….
ROLL NO. ………. General Instructions:
1. Please read the instructions carefully.
2. This Question Paper consists of 21 questions in two sections: Section A
& Section B.
3. Section A has Objective type questions whereas Section B contains
Subjective type questions.
4. 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.
5. All questions of a particular section must be attempted in the correct
order.
6. SECTION A - OBJECTIVE TYPE QUESTIONS (24 MARKS):
i. This section has 05 questions.
ii. Marks allotted are mentioned against each question/part.
iii. There is no negative marking.
iv. Do as per the instructions given.
7. SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS):
i. This section has 16 questions.
ii. A candidate has to do 10 questions.
iii. Do as per the instructions given.
iv. Marks allotted are mentioned against each question/part.
SECTION A: OBJECTIVE TYPE QUESTIONS
Q.1. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 =
4)
i. An American company invited Meera, an Indian executive, to present a
project. She began with a detailed background and slowly built up to the main
point. The American team seemed impatient and distracted. This situation
illustrates a:
a) Interpersonal barrier b) Cultural barrier
c) Physical barrier d) Linguistic barrier
1|Page
ii. Neha is part of a school project team. Her teammates often argue and
ignore her suggestions. She feels frustrated and avoids team meetings. This
is likely caused by prolonged:
a) Academic pressure b) Peer conflict
c) Financial issues d) Health problems
iii. A student downloads Libre Office for free and modifies its code. This is
possible because Libre Office is:
a) Proprietary Software b) Open Source Software
c) Utility Software d) Malware
iv. Sneha started a handmade jewelry business. In the first few months, she
faced losses but continued working hard. She motivated her team to stay
positive and kept experimenting with new designs. Which quality did Sneha
show when she continued despite losses?
a) Laziness b) Persistence c) Carelessness d) Overconfidence
v. Ananya is a student who cares deeply about the environment and social issues.
She started a school club called ―Green Future‖ to promote eco-friendly habits.
Her team organized tree plantation drives, taught students how to reduce plastic
use, and raised awareness about clean water and sanitation. They also collected
donations to support education for underprivileged children in their [Link]
organizing tree plantation and reducing plastic use, which Sustainable
Development Goal (SDG) is Ananya’s club supporting?
a) SDG 3 – Good Health and Well-being b) SDG 13 – Climate Action
c) SDG 5 – Gender Equality d) SDG 9 – Industry, Innova
vi. A student, Riya, sets a goal: 'I want to improve my grades in Science.' Her
friend suggests making it SMART. Riya rephrases it to: 'I will score at least
85% in my Science unit test next month.' Which two elements of the
SMART method did she primarily add to her original goal?
a) Specific and Measurable b) Relevant and Time-bound
c) Achievable and relevant d) Time-bound and Achievable
Q. 2 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. Priyanka needs to apply a custom 'Quote' paragraph style to ten different non-
consecutive paragraphs in her document. What is the correct sequence of steps
to use the Fill Format Mode for this task?
a) [Link] a paragraph with the 'Quote' style. 2. Click the Format Paintbrush
icon on the Standard toolbar. 3. Click each target paragraph once. 4. Click
the icon again to quit.
2|Page
b) 1. Select the 'Quote' style in the Styles deck. 2. Click the Fill Format Mode
icon. 3. Double-click each target paragraph. 4. Press Enter to exit.
c) [Link] the Styles deck (F11) and select the 'Quote' style. 2. Click
the Fill Format Mode icon. 3. Click each target paragraph once. 4.
Press the Esc key to quit.
d) [Link]-click the 'Quote' style in the Styles deck. 2. Click each target
paragraph once. 3. Press Ctrl+Esc to exit.
ii. After updating her custom 'Figure Caption' paragraph style, Jane notices
that a few existing captions in the document did not automatically change to
the new format. What is the most likely reason for this inconsistency?
a) The 'Figure Caption' style is a character style, which does not automatically
update.
b) The AutoUpdate property for the 'Figure Caption' style was turned off.
c) The paragraphs that did not update have direct formatting applied that
is overriding the style definition.
d) Jane forgot to save the document after updating the style.
iii. A teacher wants the TOC to only show the main chapter titles (styled as
'Heading 1') and the primary sections (styled as 'Heading 2'). Which setting in
the TOC dialog box must the teacher adjust to achieve this?
a) The 'Protect against manual changes' checkbox.
b) The 'Format' setting in the 'Type' tab. c)The 'Remove' button in the 'Entries' tab.
d)The 'Evaluate up to level' setting in the 'Type' tab.
v. When you create a new macro and save it to the "My Macros" location
without specifying a unique library name, what is the default library name
where the macro will be stored?
c) AutoExec b) Main c) Default d) Standard
iv. Rocsher is preparing a project report. He has sales data in two separate
Calc files: [Link] and [Link]. He wants to link the data from
[Link] into [Link] so that any changes in the first file
automatically reflect in the second. Which feature should he use?
a) Consolidate b) External References to other documents
c) Subtotals d) Pivot Table
v. Anabiya, the team lead, wants her two team members, Bent and Cyara, to
review a new budget spreadsheet. She needs to ensure that every addition,
deletion, or modification made by both reviewers is clearly visible and tracked
for her final [Link] is the first and most crucial step Anabiya must
take in the spreadsheet before sharing it with them. 3|Page
a) Go to Tools > Share Spreadsheet to enable collaboration mode.
b) Go to File > Properties > Security and set a password.
c) Select Edit > Track Changes > Record to start logging modifications.
d) Insert a comment in cell A1 explaining the instructions for review.
Q. 3 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. Ben created an automatic Table of Contents on page 3 of his document. He
then spent an hour inserting a new introduction chapter and several new
sections, which shifted his original chapters and their corresponding page
numbers. The TOC on page 3 is now completely outdated. What is the most
efficient single-action method Ben should use to instantly correct all the chapter
titles, page numbers, and links in the existing Table of Contents?
a) Delete the old TOC, place the cursor, and re-insert a new TOC using Insert
> Table of Contents and Index.
b) Select the entire document text and press the F9 key to refresh all fields.
c) Right-click anywhere on the existing Table of Contents and select
Update Index/Table.
d) Go to Tools > Update > All Indexes from the main menu.
ii. Which long-term health hazard is primarily associated with prolonged,
sedentary work (sitting for long hours) without adequate physical activity?
a) Increased risk of Cardiovascular Disease and Obesity
b) Respiratory Infections
c) Noise-Induced Hearing Loss d) Carpal Tunnel Syndrome
iii. While creating query in design view, is used to give meaningful names
of field in the output:
a) Alias b) Foreign Key c) Sort d) Column name
iv. If a database field is defined as CHAR(50) and the user enters 10
characters, how much storage is allocated?
a) 50 bytes b) 20 bytes c) 64,000 bytes d) 255 bytes
v. Ravi is creating a database for his small business that relies heavily on
structured data stored in rows and columns and linked via keys. What is the
fundamental name given to this type of database management system?Which
data model Ravi uses?
a) Relational Data Model b) Network Data Model
c) Hierarchical Data Model d) All of these
vi. Which specific area of the Query Design Window is used to drag-and-drop
the required tables and establish the relationships (joins) between them?4 | P a g e
a) The Top Pane b)The Table Row
c)The Bottom Pane (Design Grid). d)The Criteria Row of the Design Grid.
Q. 4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. Sarah has created a custom template named "My Business Letter" with her
company logo, margins, and styles. She wants all new documents she creates
in LibreOffice Writer to automatically use this [Link] is the correct
way to set this template as the default?
a) Right-click the template file in the file explorer and select Set as Default.
b) Open the template file, then use File > Save As and select Default Template,
c) Open the Templates dialog box, right-click on the "My Business
Letter" template, and select Set as Default.
d) Use Ctrl + D shortcut while the template is open.
ii. While consolidating data from multiple sheets, Arjun notices that the row
labels (student names) are not matching properly, and the summary sheet is
showing incorrect totals. What should he ensure before using Consolidate?
a) All sheets must have the same font size
b) All sheets must have identical row and column labels
c) All sheets must be in alphabetical order d) All sheets must be password
protected
iii. Ravi is creating a new record in the 'Students' table. He is using a Form
that is linked to this table. Where is the data Ravi enters actually stored?
a ) In the Forms object of the database.
b) In the underlying 'Students' Table.
c) In the Reports object for printing purposes.
d) Temporarily in the Form until the application is closed.
iv. A software team frequently misses deadlines because they are given
vague instructions and no clear division of tasks, leading to role ambiguity
and high stress among members. Which approach is most effective in
reducing this hazard?
a) Providing noise-cancelling headphones to reduce noise.
b) Clearly defining job descriptions, assigning specific roles, and
improving communication on project goals.
c) Installing advanced ventilation systems to improve air quality.
d) Mandating a 15-minute stretching routine every morning.
v. Mariyam has a formula in cell C10 that calculates the 'Total Marks' (e.g.,
5 | the
90/100) based on 'Assignment Weightage' in cell A1. The student wants Page
'Total Marks' in
C10 to be exactly 95 and needs to find out what 'Assignment Weightage' in A1 is
required to achieve this. Which feature of Calc should she use, and why?
a) Goal Seek – because it adjusts the input (value of cell A1) to reach the
exact target output (C10=95).
b) Scenario Manager – because it allows creating multiple possible
outcomes with different sets of inputs.
c) Consolidate – because it combines data from different sheets into one summary.
d) Data Validation – because it restricts the type of values that can be
entered into a cell.
vi. Materials in a workplace are classified by risk to prevent fires. Which of
the following correctly matches the material class with its description?
a) Class A – liquids, grease, and gas; Class B – wood, cloth, paper
b) Class C – electrical materials; Class D – volatile metals like magnesium
and sodium
c) Class B – electrical equipment; Class C – paper and cloth
d) Class D – liquids and gas; Class A – electrical materials
Q. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. A user wishes to share a professionally formatted job application letter with
colleagues who should maintain the layout but enter their individual
information. Which of the following is the best approach?
a) Save as .odt and email to everyone
b) Create a template with placeholders
c) Use default blank document for each
user d)Copy-paste the letter in every new
document
ii. In terms of Libre office Base which of the following statements is correct?
a) Only Report Builder Window open along with the Report Wizard.
b) Only Add Fields Window open along with the Report Wizard.
c) Both a and b d) Neither a nor b
iii. Rohi works as a floor manager in a Mall. As per her job profile she has to
conduct regular to ensure the safety of life in case of any disaster or
emergency by evacuating the place of danger.
a) Cultural assembly b) Open house events
c) Evacuation drill d) Trips and excursions
iv. A factory worker observes that a coworker has suffered a minor burn 6while
|Page
operating machinery. The coworker is in pain but the injury is not life-
threatening. Which sequence of actions is the most appropriate initial
response according to standard safety procedures?
a) Report incident to safety manager —-> Initiate first aid —> Document the
scene.
b) Stop the work immediately —>Administer first aid —>Inform the
supervisor.
c) Wait for end of the shift —> Ask the coworker if he want to report it —>
Continue work.
d) Attend to the injured person —>Clean up the area —> Inform the supervisor.
v. Employees are habitually leaving boxes, unused equipment, and coats piled
up in the main emergency exit passageway. What type of hazard is this
primarily creating, and what is the best collective solution?
a) Ergonomic Hazard; the solution is installing ergonomic chairs.
b) Chemical Hazard; the solution is implementing Material Safety Data Sheets.
c) Fire/Safety Hazard; the solution is routine clean-up protocols and clear
policies on keeping emergency routes clear.
d) Health Hazard; the solution is improving air conditioning and temperature
control.
vi. Priya and Amit are editing the same budget sheet. Priya enabled 'Record
Changes' before starting her work. Amit did not. When Amit sends his file to
Priya, and she uses 'Compare Document', whose changes will the final
document be able to systematically accept or reject?
a) Neither, as both must have recorded changes for comparison to work
b) Only Priya's changes, because she was the one who used the 'Record
Changes' feature in the master file.
c) Both Priya's and Amit's changes will be tracked and manageable.
d) Only Amit's changes, because he sent the updated file.
SECTION B: SUBJECTIVE TYPE QUESTIONS
Answer any 3 out of the given 5 questions on Employability Skills in 20 –
30 words. (2 x 3 = 6 marks)
Q. 6 Neha is preparing a notice for a school event. She writes: ―Join us for the
Annual Sports Day on 25th Jan at 9 AM. Venue: School Ground. Wear sports
uniform. Let’s make it a great day!‖ Which three Cs of effective communication
are shown in Neha’s notice? Justify your answer along with a brief explanation of
each one of them. (2) 7|Page
ANS: The notice shows Clarity (clear date, time, venue), Conciseness (short
and precise message), and Completeness (all necessary details are
included).
Q. 7 During a class discussion, Arjun got upset when his idea was rejected by
his classmates. He wanted to improve his ability to handle emotions and respond
calmly. Which steps can help him manage emotional intelligence effectively? (2)
ANS: Arjun should practice self-awareness, control his emotions, listen
actively, accept feedback positively, and respond calmly instead of
reacting impulsively.
Q. 8 Aman and Priya both completed a tailoring course. Aman joined a garment
factory as a stitching assistant, while Priya started her own boutique at home
and began designing clothes for clients. Compare Aman’s and Priya’s
employment types. Explain any 4 differences between Self-Employment and
Wage Employment using the story. (2)
ANS: Aman is in wage employment earning fixed salary, while Priya is
self-employed, owning her business, bearing risk, and earning profit
based on performance.
Q. 9 What are the major challenges in achieving sustainable development in
the area of energy and environment? (2)
ANS: Major challenges include overuse of fossil fuels, pollution, climate
change, lack of renewable energy adoption, and environmental
degradation.
Q. 10 Stela manages multiple important online accounts (social media, school
portal, and payment apps). She uses the same simple password for all of them
and hasn't changed it in over a year. She is worried about a potential data
breach. What three specific best practices should she implement immediately to
make her accounts significantly more secure? (2)
ANS:She should use strong unique passwords, enable two-factor
authentication, and regularly change passwords to prevent hacking
and data breaches.
Answer any 4 out of the given 6 questions in 20 – 30 words each (2 x 4 =
8)
8|Page
Q. 11 Hari is guiding his friend about format documents in LibreOffice Writer.
His friend asked him types of style categories along with one feature of each.
What should Hari explain to him, write in detail? (2)
ANS: Style categories include Paragraph (format paragraphs), Character
(text appearance), Page (page layout), Frame (object formatting), and
List (bullets/numbering).
Q. 12 In a Telecom Company for Madhya Pradesh region a team of five Team
Leads is collaboratively tracking daily attendance and project scores in a
single LibreOffice Calc file [Link]. To ensure all members can update
their specific columns simultaneously, they decide to activate the Shared
Spreadsheet Mode.
(a) Briefly describe the steps first Team Lead must take to enable the 'Shared'
mode for the [Link] file. (1)
(b) State major limitations of the Spreadsheet Sharing mode regarding the
features or actions that are disabled once sharing is activated. (1)
ANS: (a) Open file → Tools → Share Spreadsheet → Enable sharing → Save.
(b) Macros, pivot tables, and some formatting features are disabled.
Q. 13 Explain types of relationship between tables in a database with example.
(2)
ANS:Relationships are One-to-One, One-to-Many, and Many-to-Many.
Example: One customer can place many orders (One-to-Many).
Q. 14 Ramesh, an electrician at a small manufacturing unit, noticed a frayed
wire near a water cooler. He informed his supervisor, but the issue was ignored.
A few days later, while cleaning the area, a janitor accidentally touched the
exposed wire and received a severe electric shock. The incident led to an
investigation and highlighted several safety lapses.
a) Based on the incident, explain the causes of electrical hazards in the workplace.
(1)
b) What safety measures should be taken to prevent such accidents? (1)
ANS : (a) Causes: damaged wires, moisture, poor maintenance.
(b) Use insulation, regular checks, dry conditions, and proper earthing.
Q. 15 Define in brief the terms: Macro, LibreOffice Macro Library and My
Macro.(2) 9|Page
ANS:A Macro automates tasks. Macro Library stores macros. My Macros
contains user-created personal macros.
Q. 16 During a practical workshop, a student accidentally touches a bare wire
leading to an electrical short circuit and is unable to let go due to the electric
current flowing through them. Describe the three most critical and immediate
steps a nearby teacher or student should take to safely rescue the victim,
ensuring the rescuer's own safety is maintained throughout the process. (2)
ANS:Switch off power supply, use a dry non-conductive object to
separate victim, call emergency help and provide first aid.
Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 =
12)
Q. 17 Sana is designing a two-page digital newsletter. The first page features a main
article with an illustration, and the second page has a series of short news
snippets. She inserts a large illustration (Image A) into the main article on Page
1. She wants this image to move with the surrounding paragraph text as she
adds or deletes sentences above [Link] inserts a small logo (Image B) that must
always remain in the bottom-right corner of Page 2, regardless of how much text is
added or deleted on that page. She wants the text Superimposes Image A on the
text.
(a) For Image A, which Anchoring option should Sana select to ensure the image
moves with the surrounding text? Explain why this anchor type is suitable for
the main illustration. (1)
(b) For Image B, which Anchoring option should Sana use to fix the logo in the
bottom- right corner of Page 2? Give reason to support your answer.(1)
(c) For Image A, which Text Wrap option should Sana select to Superimpose
image on the text? (1)
(d) If Sana needs to temporarily place Image A behind a block of text without
hiding the text, which option of Arrangement tool must she use? (1)
ANS: (a) Image A should be Anchored to Paragraph so it
moves with text when content is added or deleted.
(b) Image B should be Anchored to Page to remain fixed at the
bottom-right corner of Page 2.
10 | P a g
e
(c) To superimpose image on text, use Wrap → Through.
(d) To place image behind text, use Arrange → Send to Back.
Q. 18 Consider the table given below and answer the questions that follow:
Order ID CustomerI Order Date Amount
D
201 101 22/11/25 1000
202 102 22/11/25 1000
203 101 06/12/25 400
(a) Which field should be made primary key? Justify your answer. (1)
(b) Explain Composite key and foreign key with example of each.(1)
(c) Write the steps to create a query in design view to display the records of
Customer having CutomerID 101. (2)
ANS:
(a) Order ID should be the primary key as it uniquely identifies each
record.
(b) A Composite key uses multiple fields together, e.g., OrderID +
CustomerID. A Foreign key links tables, e.g., CustomerID in Orders
table.
(c) Open Base → Queries → Create Query in Design View → Add table →
Select fields → Set criteria CustomerID = 101 → Run query.
Q. 19 Ravi, a 15-year-old student, trained rigorously for his school’s annual
marathon. Despite feeling pain in his knees during practice, he ignored it and
continued running. On the day of the marathon, halfway through the race, Ravi
collapsed due to severe pain and was rushed to the hospital. The doctor
diagnosed him with patellofemoral pain syndrome and early signs of osteoarthritis.
a) Based on Ravi’s story, explain the causes, symptoms, and preventive
measures of musculoskeletal problems. (3)
b) How can students maintain musculoskeletal health during physical
activities?(1)
Answer:
(a) Musculoskeletal problems are caused by overuse, ignoring pain,
poor posture, and lack of rest. Ravi ignored knee pain, causing
11 |injury.
Pag
e
Symptoms include pain, stiffness, swelling, and reduced movement.
Preventive measures include warm-up, rest, correct posture, proper
training, and avoiding overexertion.
(b) Students should exercise safely, take breaks, maintain posture, and
avoid overstraining muscles.
Q. 20 Fatima is managing a Customer–Order database in LibreOffice Base. She
has a master table called Customers and a transaction table called Orders as
follows:
Orders table
Order ID CustomerI Order Date Amount
D
201 101 22/11/25 1000
202 102 22/11/25 1000
203 101 06/12/25 400
Customers table
Customer Name Email
ID
101 Alice alice@[Link]
m
102 Alica alica@[Link]
m
(a) What is the referential integrity principle?Give suitable example from
Customer- Order data base. (1)
(b) Suppose a user tries to delete a record from the Customers table who
has an existing record in the Orders table. What will happen if referential
integrity is enforced in LibreOffice Base (NO ACTION CASCADE is set on
CustomerID in Order table)? (1)
(c) If a CustomerID 102 is changed in Customers table to 105, how does the
Update Cascade option affect Orders table? (1)
(d) If the Set NULL option is used and record with CustomerID 101 is
deleted fromCustomers table, what happens in the OrderID table? How is it
different from Set Default? (1)
12 | P a g
e
Answer:
(a) Referential integrity ensures foreign key values match
primary key values, e.g., CustomerID in Orders must exist
in Customers table.
(b) Deletion is blocked if related order records exist.
(c) Update Cascade automatically updates CustomerID in
Orders table.
(d) Set NULL removes CustomerID value, while Set Default
assigns a predefined default value.
Q. 21. Richie is creating a detailed financial report in LibreOffice Calc
([Link]) that links to a separate image file ([Link]) located in a folder
on her desktop. She successfully uses a hyperlink to display the image when
she clicks a cell in her report.
(a) Richie initially creates an Absolute Hyperlink to the image file. Explain in
detail why this absolute link will fail when she emails the ([Link]) file to her
teacher, who opens it on a different computer. (1)
(b) To solve the problem, Richie's friend suggests using a Relative Hyperlink.
Describe the essential condition Richie must fulfill regarding file location to
ensure the relative hyperlink works correctly on both her computer and the
teacher's computer. (1)
(c) If she wants to link to a different sheet (e.g., 'Summary') within the
same ([Link]) file, she would use the Target in Document option.
Write about the advantages of using this internal linking method over
simply switching sheets manually. (1)
(d) Richie wants to include the latest Stock Index value from a financial
website in a cell of her report and ensure it updates automatically. Explain
why using the Link to External Data feature is the correct choice instead of
simply using a standard hyperlink to the website. (1)
Answer:
(a) Absolute hyperlinks fail because file paths differ on
another computer.
(b) The image and spreadsheet must be kept in the same
13 | P a g
e
relative folder structure.
(c) Internal links improve navigation and save time.
(d) Link to External Data automatically updates values, unlike
normal hyperlinks.
14 | P a g
e