Part A
Unit 1: Communication Skills
1. How can cultural differences be a barrier to effective communication?
2. What are the learning objectives of communication?
3. During a team meeting, Sarah is explaining a complex project idea to her
colleagues. She speaks too quickly, uses jargon, and doesn’t pause for
questions. As a result, her team seems confused, and the project isn’t fully
understood. What can Sarah do to improve her verbal communication
skills?
4. Explain any two C’s of effective communication.
Unit 2: Self-management Skills
1. Briefly discuss the significance of time management skills in order to
succeed in life.
2. What is self-awareness? Also give any two benefits of self-awareness.
3. Give one example each of following stress causal agents for students: (a)
Mental b) Social
4. How is self-regulation connected to the ability to work independently?
5. What are the advantages of the ability to Work Independently?
6. Name the Stress causal agents.
7. Riya, a Class X student, feels stressed with her exam preparation,
extracurricular activities, and family commitments. How can tracking time
help her?
8. Maya often gets frustrated at work and reacts impulsively in stressful
situations. She wants to improve her ability to handle emotions and
respond calmly. Which steps can help her manage emotional intelligence
effectively?
Unit 3: ICT Skills
1. Differentiate between files and folders.
2. Sara is worried about her personal and work data being stolen or infected
by viruses. What steps can she take to protect her data effectively?
Unit 4: Entrepreneur Skills
1. Explain any two misconceptions about entrepreneurship.
2. Give any two qualities of a successful entrepreneur.
3. Give any two promotional functions of an entrepreneur.
4. Name the person who combines factors in a creative manner to generate
value for customers and create wealth. (1)
5. Name the skill that helps anyone to lead, guide and supervise people who
work for business.
6. Why do we say that an entrepreneur should be open-minded?
7. Explain any two Myths about Entrepreneurship.
8. Write any four roles of Entrepreneurs.
9. What are the functions of Entrepreneurs?
10. Compare Self-Employment and Wage Employment.
Unit 5: Green Skills
1. Mention any two ways to get clean and affordable energy.
2. Give any two methods that we can adopt to promote Sustainable
Development.
3. “Green economy promotes sustainable development”. Justify the
statement.
4. Why has United Nations has made the 17 Sustainable Development Goals?
5. What are the major problems related to sustainable development
concerning food and water?
Part B
Unit 1: Digital Documentation (Advanced)
1. Write the main steps to group drawing objects in Writer.
2. Give any two characteristics of a template in LibreOffice Writer.
3. Explain the following term with respect to positioning the graphics in a document:
(a) Arrangement
(b) Text wrapping (4)
4. What do you understand by the term Table of Contents? List the
characteristics of a good ‘Table of content’ in a Writer.
5. State any two purposes of using Templates in a word document.
6. In LibreOffice Writer, what are the styles? List two Open Office Writer style
options.
7. A team of writers is collaborating on a report using a word processing
software with a Track Changes feature. One writer creates the initial draft,
which then needs to be reviewed and edited by the rest of the team.
a) Why is the Track Changes feature essential for collaborative
document editing?
b) Which menu option can be used to access this feature?
c) Can reviewers add comments?
d) Once the changes are made by all the reviewers, who can accept or
reject them?
8. Aarav is learning to format documents in LibreOffice Writer. His teacher
asked him to explain any two style categories along with one feature of
each. What should Aarav write?
9. Case Study A publishing company is designing an e-magazine in LibreOffice
Writer. The editor wants to insert images of articles and advertisements in
such a way that the layout looks attractive and professional. While working,
the team faces some challenges:
In one article, two images overlap, and only part of the required
picture is visible.
For the cover page, the editor wants the main image to stay fixed in
the center, no matter how much text is added or removed.
In another section, the designer wants text to flow smoothly around
the images so that the page looks balanced.
For an advertisement, the client requests that the product image
should appear above all other elements.
(a) Which feature should the team use to solve the problem of
overlapping images?
(b) Which setting will help the editor keep the main image fixed in the
center of the cover page?
(c) Which positioning option will make the text flow smoothly around
the images in the article?
(d) Which arrangement tool should be used to ensure the advertisement
image appears above all other elements?
Unit 2: Electronic Spreadsheet (Advanced)
1. What is the purpose of consolidating data in spreadsheets? Discuss briefly.
2. What are the two parts of a cell reference while referencing data on other
sheets? Explain with an example.
3. Explain four types of hyperlinks that can be applied in spreadsheets. (4)
4. Why do we need to merge worksheets?
5. Distinguish between the following with respect to spreadsheets:
(a) Relative and absolute hyperlink
(b) Internet hyperlink and Document hyperlink (4)
6. A row that represent a single data items in a table is known as _________.
7. What do you mean by Sorting in a Spreadsheet?
8. How is Goal Seek different from Solver in a Spreadsheet?
9. Explain the term ‘Scenarios’ in relation to the Spreadsheets with example.
(4)
10. Mention any two operations that can be performed using Macros in a
spreadsheet.
11. What do you mean by Hyperlinks in Spreadsheets? Give the two different
types of Hyperlinks that can be used in Spreadsheets.
12. What are the benefits of sharing a spreadsheet?
13. Guneet has completed his assessments in four subjects and received the
following marks: 75 in Math, 68 in Science, 82 in English, and 70 in History.
The student needs to achieve an overall aggregate of 75% across all five
subjects to meet his academic goals. He still has to take the exam in the
fifth subject, which is Geography. Which Calc tool and menu option he can
use to check how many marks he has to score in the 5th subject to get the
required percentage?
14. A Class X student is participating in a school competition where they need
to analyse the performance of different sports teams based on match
scores and statistics. The student has collected data over several matches
and needs to calculate averages, determine rankings, and generate charts
for a presentation.
a) How are Macros in Calc helpful to him?
b) How to enable Macro in Calc?
c) Is solution*word a valid macro name? Justify
d) Mention any one operation which cannot be recorded by macro.
15. (a) What must you do before enabling the Record Changes feature?
(b) How can you confirm that sharing has been disabled in the
spreadsheet?
16. Arjun is preparing a project report in LibreOffice Calc that contains
multiple spreadsheets. He wants smooth navigation between different
sheets and also plans to include data from a government website. Initially,
he uses an absolute hyperlink but later realizes it breaks when he shares
the report with his teacher because the file path is different on another
computer. His friend suggests trying a relative hyperlink instead. While
inserting a hyperlink, Arjun notices the option Target in Document, which
allows him to connect directly to a particular sheet. He also discovers the
Link to External Data option to fetch live tables from a web page into his
spreadsheet.
(a) Why did the absolute hyperlink fail when Arjun shared the file, and
how does a relative hyperlink solve this problem?
(b) How does the Target in Document option increase the usefulness of
hyperlinks in large spreadsheets?
(c) Arjun wants to ensure that anyone viewing his report can update
data directly from a government website. Which feature should he
use, and why is it beneficial?
(d) If Arjun wants to edit or remove a hyperlink later, what steps should
he take?
17. What is a Macro? List any two real life situations where they can be used.
Unit 3: Database Management System
1. Give any two benefits of creating relationships between tables in a
database.
2. In context of LibreOffice Base, explain the concept and significance of the
following: (a) Forms (b) Reports. (4)
3. In the context of Database Management System, write a short note on the
following:
(i) Database (ii) Table (iii) Field (iv) Composite Primary Key (4)
4. Explain the term “Referential Integrity”. Why is it important in a database?
(4)
5. What is Primary key? How it is different from foreign key?
6. Explain any four datatypes of DBMS. (4)
7. (a) Structure of a table ‘Orders’ is given below. Suggest suitable datatype
for each column.
8. Explain various relationships that can be created between two tables in a
database.
9. When primary key constraint is applied on one or more columns then it is
known as ________.
10. Explain the term sorting.
11. Explain any two types of relationships that can be created in tables.
12. What is difference between forms and reports?
13. Identify any two Column name/ Attribute and their datatypes from a given
table: PLAYER
14. Consider the following Vendor table and write the queries for the
following:
(a) Write a query to display the above date sheet.
(b) Write a query to display the subject name and date of the exam held
on ‘Monday’
15. Define the following:
(a) Database Management System
(b) Primary key
(c) Numeric Data type
(d) Referential Integrity (4)
16. Differentiate between a Primary key and Foreign key.
17. Write a short note on the following: i) DBMS ii) Database Server iii)Data
Integrity iv)Record (4)
18. List Numeric and Alphanumeric Datatypes in LibreOffice Base.
19. Anshita is preparing spreadsheet notes for her Term Exam. Help her to
write short note on the following: i. Scenarios ii. Goal Seek iii. Solver iv.
Subtotal (4)
20. Consider the following table: Sales
How many fields and records are there in Sales table? Name them.
21. Your friend owns a chemist shop, he needs to keep records of the
medicines with their id’s, date of purchase, expiry date, price, etc. in a
database program. But he does not have any knowledge about the
database. Explain to him the following to get a better understanding of the
DBMS concepts.
1. What is DBMS? Explain in brief.
2. Name any two database programs which can be used to create a
table and store the data as per the requirement.
3. Which field can be set as a Primary Key?
4. Is it possible to make more than one field as a primary key in your
table? (Yes/No). Justify your answer.
(4)
22. Define the following: 1. Sorting (with respect to DBMS) 2. Referential
Integrity 3. Many-to-Many Relationship(with respect to DBMS) 4. Foreign
key (4)
23. In a database, why is it important to create relationships between the
tables?
24. A health clinic is developing a patient management system to streamline
patient intake, appointments, and medical records. They need to
implement forms for various purposes, including new patient registration,
appointment scheduling, and updating medical histories. a) What is the
use of form in DBMS? b) What are the different ways to create forms in
DBMS? c) Where can we find various tools to add or edit controls on the
form? d) What is the use of the Records Toolbar in a form?
25. Your cousin runs a small bookstore and wants to maintain an inventory of
books. He needs to record information such as book titles, authors, ISBNs,
publication dates, prices, and stock levels. However, he is not familiar with
database management systems. Explain the following concepts to help
him understand DBMS:
a) What is DBMS?
b) What are the advantages of using DBMS?
c) Name any two database programs that can be used to create a table
and store the data according to his requirements.
d) Which field can be set as a Primary Key?
26. Differentiate between One-to-Many and Many-to-Many relationships in a
database.
27. Ruhi is managing a Sports Day database in LibreOffice Base. She has a
master table called EventCategory and a transaction table called Events.
(a) What is referential integrity? Give an example from Ruhi’s database.
(b) Ruhi wants to stop deletion of any category that is being used in the
Events table. Which option should she use?
(c) If a CategoryID is changed in EventCategory, how does the Update
Cascade option affect the Events table? Give an example.
(d) If the Set NULL option is used and a master record is deleted, what
happens in the Events table? How is it different from Set Default?
28. Consider the table given below and answer the questions that follow:
(a) Name all the fields in the given table.
(b) Which field should be made the primary key?
(c) Suggest a possible alternate key, if any.
(d) Explain how a primary key differs from a foreign key with an
example.
Unit 4: Maintain Healthy, Safe and Secure Working Environment
1. Mention any two basic fire safety rules to be followed in any organization.
2. Give any two Falls and Slips safety rules.
3. __________ is the immediate assistance provided to the injured to save life
and minimize health loss till the proper medical aid/ facility is provided.
4. What is the importance of healthy lifestyle? Give any four points related to
it.
5. Differentiate between safety and security of an employee.
6. What is Occupational Overuse Syndrome? What are the causes for it?
7. What points should be included in Fire Prevention Plan in the office?
8. Musculoskeletal problems affect different parts of the body like neck, back,
chest, arms, shoulders, and feet. These problems happen due to wrong
posture or uncomfortable chairs while working on a computer. List four ways
to avoid this problem. (4)
9. What are the common causes of electrical hazards at the workplace?
Suggest one safety measure to prevent them.
10. While inspecting a machine, Rohan notices a colleague stuck to a live
wire. What steps should Rohan follow to safely rescue the victim?