SAMPLE QUESTION PAPER—1

Class X (Session 2024-2025)

Information Technology (SUBJECT CODE - 402)
Max. Time : 2 Hours Max. Marks : 50
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 marks)
i. Who is responsible for encoding the message in the communication cycle ? 1
(a) Receiver (b) Message
(c) Sender (d) Noise
ii. Why is stress management important ? 1
(a) To increase stress levels (b) To improve overall well-being
(c) To escalate health issues (d) To worsen relationships
iii. What is the function of the Taskbar in a Windows environment ? 1
(a) Display wallpaper (b) Organize files and folders
(c) Minimize all open programs (d) Show active programs, date and time
iv. What is a crucial function of an entrepreneur ? 1
(a) Excessive spending on marketing (b) Avoiding decision-making responsibilities
(c) Understanding the target audience (d) Limiting networking and public relations
Information Technology-X 1
 v. Which initiative involves protecting ecosystems and preserving biodiversity for the future ? 1
(a) Renewable Energy (b) Waste Reduction and Recycling
(c) Conservation and Biodiversity (d) Sustainable Agriculture
vi. What is entrepreneurship primarily about ? 1
(a) Creating problems
(b) Managing an established business
(c) Creating, managing and developing a new venture
(d) Learning from mistakes and failures
Q.2. Answer any 5 out of the given 6 questions. (1 x 5 = 5 marks)
i. What does the term “anchoring” refer to in relation to images in a document ? 1
(a) Controlling the brightness and contrast of an image
(b) Setting the alignment of the image
(c) The reference point used for determining the image’s placement
(d) Arranging the stacking order of images
ii. What is the purpose of a Template in a Word Processing software ? 1
(a) Create new styles for a document
(b) Generate new graphics and drawings
(c) Provide a pre-designed layout with sample content and themes
(d) Apply formatting to text and elements in a document
iii. Which feature in Writer allows for applying the same style to multiple scattered objects in a
document ? 1
(a) Fill Format Mode (b) Format Painter
(c) Template Styles (d) Global Styling
iv. What action does Writer perform when the TOC needs to reflect changes made in the document ?1
(a) Automatic update (b) Manual update
(c) Refresh content (d) Reprint the document
v. Which of the following describes the purpose of a Table of Contents (TOC) ? 1
(a) To summarize a document’s content (b) To organize text into columns
(c) To insert hyperlinks within text (d) To define document margins
vi. What is the shortcut key to open the Styles pane in LibreOffice Writer ? 1
(a) Ctrl + F (b) Alt + S
(c) F11 (d) Ctrl + Shift + S
Q. 3. Answer any 5 out of the given 6 questions. (1 x 5 = 5 marks)
i. The default function while using Consolidate is ............................ . 1
(a) Average (b) Sum
(c) Max (d) Count
ii. Which feature in Calc automates the task of comparing two spreadsheets to identify changes made
between them ? 1
(a) Record Changes (b) Accept or Reject Changes
(c) Compare Document (d) Merge Document

2 Information Technology-X
 iii. Which of the following features is not used for data analysis in spreadsheets ? 1
(a) Consolidating data (b) Goal Seek
(c) Subtotal (d) Page layout
iv. In Calc, the comments are added : 1
(a) automatically (b) by author
(c) by reviewer (d) all of above
v. Which tool in Calc allows you to explore different possibilities by creating and saving different sets of
input values ? 1
(a) Scenarios (b) Goal Seek
(c) Solver (d) Consolidate
vi. Which type of hyperlink contains the full address of the destination file or web page ? 1
(a) Relative hyperlink (b) Absolute hyperlink
(c) Static hyperlink (d) Dynamic hyperlink
Q. 4. Answer any 5 out of the given 6 questions. (1 x 5 = 5 marks)
i. Which type of database organization uses tables with well-defined relationships between them ? 1
(a) Hierarchical (b) Flat file
(c) Relational (d) Object-oriented
ii. Which view in LibreOffice Base is particularly user-friendly and recommended for beginners to create
queries ? 1
(a) SQL View (b) Design View
(c) Wizard View (d) Relationship View
iii. Which alphanumeric data type stores a fixed number of characters as a single byte ? 1
(a) VARCHAR (b) NCHAR
(c) CHAR (d) NVARCHAR
iv. The primary purpose of a form in a database is to : 1
(a) Store data permanently
(b) Provide a user interface to interact with the database
(c) Write complex SQL queries
(d) Manage database security
v. What does referential integrity ensure in a relational database ? 1
(a) Data redundancy (b) Data security
(c) Data accuracy and consistency (d) Data isolation
vi. Which type of query is used to organize query data according to selected field names ? 1
(a) Detailed query (b) Summary query
(c) Grouped query (d) Simple query
Q. 5. Answer any 5 out of the given 6 questions. (1 x 5 = 5 marks)
i. What is the primary cause of slips and falls in the workplace ? 1
(a) Ergonomic hazards (b) Wet or slippery surfaces
(c) Electrical wiring issues (d) Overloaded circuits

Information Technology-X 3
 ii. What is the main goal of first aid ? 1
(a) To provide immediate care and preserve life (b) To replace professional medical treatment
(c) To diagnose illnesses on-site (d) To delay medical attention
iii. What is the main purpose of fire risk assessments ? 1
(a) To train employees on fire safety protocols
(b) To identify potential fire hazards and vulnerabilities
(c) To purchase firefighting equipment (d) To create evacuation routes
iv. What is a key feature of an ergonomic chair ? 1
(a) Fixed height and armrests (b) Adjustability for back and feet support
(c) Lack of lumbar support (d) Reclining functionality
v. Which is an essential component of a first aid kit ? 1
(a) Office equipment (b) Burn cream or gel
(c) Heavy machinery (d) Hazardous materials
vi. What does Occupational Overuse Syndrome (OOS) commonly result from ? 1
(a) Poor air quality (b) Lack of natural lighting
(c) Repetitive tasks and awkward postures (d) Excessive hydration

SECTION B : SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions on Employability Skills. (2 x 3 = 6 marks)
Answer each question in 20 – 30 words.
Q. 6. What does the term ‘noise’ refer to in the context of communication ? 2
Q. 7. Define meditation and its role in stress relief. 2
Q. 8. How can you create a new folder on the desktop in Windows ? 2
Q. 9. Why is adaptability crucial for entrepreneurs ? 2
Q. 10. Identify two challenges related to sustainable development concerning natural resources. 2
Answer any 4 out of the given 6 questions in 20 – 30 words each. (2 x 4 = 8 marks)
Q. 11. How does hierarchy play a role in a table of contents, and how is it represented ? 2
Q. 12. What is the purpose of using a macro as a function in Calc ? 2
Q. 13. What information is displayed when you point at the dot in the upper-left corner of a cell with recorded
changes ? 2
Q. 14. Explain the significance of field properties in defining the characteristics of database fields. 2
Q. 15. What is the function of the COUNT function in a query, and how does it differ when used with ‘*’
versus a specific field name ? 2
Q. 16. What are the primary factors contributing to falls and slips in the workplace ? Explain any three. 2
Answer any 3 out of the given 5 questions in 50– 80 words each. (4 x 3 = 12 marks)
Q. 17. Describe the process of grouping drawing objects in Writer. 4
Q. 18. Explain how Solver differs from Goal Seek and when it’s more appropriate to use Solver in a scenario.
4
Q. 19. Explain what a cell reference is and its significance in spreadsheet applications like LibreOffice Calc.
4
Q. 20. Explain three benefits of using a Database Management System (DBMS) in handling data. 4
Q. 21. How should you monitor air quality ? 4
4 Information Technology-X
 SAMPLE QUESTION PAPER—2
Class X (Session 2024-2025)
Information Technology (SUBJECT CODE - 402)
Max. Time : 2 Hours Max. Marks : 50
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 marks)
i. What is the process of interpreting the message communicated in the communication cycle? 1
(a) Encoding (b) Decoding
(c) Feedback (d) Transmission
ii. Which type of motivation arises from personal interest and satisfaction ? 1
(a) Intrinsic motivation (b) Extrinsic motivation
(c) External motivation (d) Monetary motivation
iii. What do icons represent on the computer Desktop ? 1
(a) Programs, files or folders (b) Wallpaper designs
(c) Taskbar settings (d) System notifications
iv. Which career option in entrepreneurship involves specialized services offered on a project basis ? 1
(a) Content creator (b) E-commerce entrepreneur
(c) Freelancer (d) Social media influencer
Information Technology-X 5
 v. Which organization introduced the Sustainable Development Goals (SDGs) ? 1
(a) World Bank (b) International Monetary Fund (IMF)
(c) United Nations (UN) (d) World Trade Organization (WTO)
vi. Which function of an operating system ensures programs run efficiently without interfering with
each other ? 1
(a) Memory Management (b) Device Management
(c) Process Management (d) File System Management
Q.2. Answer any 5 out of the given 6 questions. (1 x 5 = 5 marks)
i. Which of the following is NOT a style category in LibreOffice Writer ? 1
(a) Paragraph Styles (b) Image Styles
(c) Page Styles (d) Character Styles
ii. What is the benefit of using paragraph styles like ‘Heading 1’ and ‘Heading 2’ while creating a document ? 1
(a) Enhances page layout (b) Defines font colors
(c) Helps in creating a TOC with hierarchical headings
(d) Allows inserting footnotes
iii. What is the purpose of the “Load Styles” function in LibreOffice Writer ? 1
(a) Deletes existing styles from the document
(b) Replaces existing styles with new ones
(c) Copies styles from a template or another document
(d) Disables all formatting within the document
iv. Which of the following is NOT true about Table of Contents, Index or Bibliography dialog box ? 1
(a) It has four tabs
(b) On the Type tab, by default, the checkbox for Protected against Manual Changes option will be selected.
(c) The Styles tab contains options to change the background colour.
(d) The Background color can be changed using the Background tab.
v. What does setting a default template in LibreOffice Writer allow you to do ? 1
(a) Change the font size of the document
(b) Set the document’s language preference
(c) Make modifications to the document’s layout
(d) Create new documents based on a specific template by default
vi. What is the purpose of the “Update Style” option in LibreOffice Writer ? 1
(a) Refreshes the document content
(b) Updates the application interface
(c) Applies new formatting to the document
(d) Updates the selected style with new formatting effects
Q. 3. Answer any 5 out of the given 6 questions. (1 x 5 = 5 marks)
i. Which feature in Calc is used for merging information from multiple worksheets into a single
location ? 1
(a) Sort (b) Merge Cells
(c) Consolidate (d) Subtotal

6 Information Technology-X
 ii. What type of hyperlink guides you to a particular location in the current or another existing
worksheet ? 1
(a) Internet (b) Mail and News
(c) Document (d) New Document
iii. Which menu option in Calc is used to record a series of user actions and automate repetitive tasks ? 1
(a) Tools > Macros (b) Edit > Automation
(c) Insert > Recording (d) Format > Macros
iv. Which feature in Calc allows you to track modifications like additions, deletions, and formatting
adjustments ? 1
(a) Track Edits (b) Record Changes
(c) Edit History (d) Revision Tracking
v. What is the extension of a spreadsheet file in Calc ? 1
(a) .odb (b) .odt
(c) .odg (d) .ods
vi. What is the primary advantage of linking data and spreadsheets in Calc ? 1
(a) Reducing errors (b) Making sheets look organized
(c) Increasing data complexity (d) Slowing down calculations
Q. 4. Answer any 5 out of the given 6 questions. (1 x 5 = 5 marks)
i. What does data refer to in the context of database management ? 1
(a) Processed information (b) Raw facts and figures
(c) Organized records (d) Meaningful insights
ii. The primary key in a table : 1
(a) Must contain NULL values (b) Cannot be NULL
(c) Can contain duplicate values (d) Is optional for each table
iii. What is the primary purpose of a foreign key in a database ? 1
(a) To ensure data consistency (b) To uniquely identify each row
(c) To establish relationships between tables (d) To enforce data standards
iv. What does the COUNT function in LibreOffice Base do ? 1
(a) Calculates the average of a field (b) Counts the number of records in a table
(c) Returns the maximum value from a field (d) Calculates the sum of the values of a field
v. Which numeric data type is used to store two values - TRUE and FALSE ? 1
(a) BOOLEAN (b) TINYINT
(c) REAL (d) DOUBLE
vi. What is the purpose of the Criterion row in the Query Design View of LibreOffice Base ? 1
(a) To specify field names (b) To filter records based on conditions
(c) To perform calculations (d) To group data
Q. 5. Answer any 5 out of the given 6 questions. (1 x 5 = 5 marks)
i. What is the main purpose of water quality monitoring ? 1
(a) Improving employee morale (b) Ensuring water is free from contaminants
(c) Reducing operational costs (d) Increasing water usage

Information Technology-X 7
 ii. What is the purpose of an emergency evacuation plan ? 1
(a) To train employees on equipment usage (b) To outline steps for safely leaving the building
(c) To prevent electrical accidents (d) To establish workstation ergonomics
iii. What should be done if a workplace hazard is identified ? 1
(a) Ignore it and continue working (b) Immediately report it to supervisors
(c) Use the equipment despite the risk (d) Create a new workstation
iv. What guideline helps maintain clean air in the workplace ? 1
(a) Limit ventilation to conserve energy (b) Avoid using plants indoors
(c) Regularly clean HVAC systems (d) Allow chemical fumes to disperse naturally
v. What is the primary goal of workplace health, safety and security ? 1
(a) Reducing employee salaries (b) Maximizing work hours
(c) Preventing accidents and ensuring well-being (d) Ignoring safety protocols
vi. What is the last line of defense in the hierarchy of hazard controls ? 1
(a) Engineering Controls (b) Administrative Controls
(c) Personal Protective Equipment (PPE) (d) Hazard Elimination

SECTION B : SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions on Employability Skills. (2 x 3 = 6 marks)
Answer each question in 20 – 30 words.
Q. 6. Why is seeking feedback considered an important principle in effective communication ? 2
Q. 7. What does the ability to work independently involve ? 2
Q. 8. Define Real-Time Operating Systems (RTOS) and state their application areas. 2
Q. 9. What is entrepreneurship ? 2
Q. 10. Mention any two ways to get clean and affordable energy. 2
Answer any 4 out of the given 6 questions in 20 – 30 words each. (2 x 4 = 8 marks)
Q. 11. Describe the Fill Format Mode in LibreOffice Writer and its significance in applying styles. 2
Q. 12. What is the purpose of the Consolidate data feature in LibreOffice Calc ? 2
Q. 13. When is the “Merge Document” feature in Calc useful, and how does it work ? 2
Q. 14. What is referential integrity, and why is it essential in relational databases ? 2
Q. 15. Explain the significance of the Objects Relationship Pane and the Design Grid in the Query Design
View of LibreOffice Base. 2
Q. 16. What is the primary goal of first aid in an emergency situation ? 2
Answer any 3 out of the given 5 questions in 50– 80 words each. (4 x 3 = 12 marks)
Q. 17. Explain the steps involved in customizing a table of contents in Writer. 4
Q. 18. How can you enable sharing mode in Calc for a spreadsheet ? 4
Q. 19. What are the essential database objects, and what roles do they play in managing data ? 4
Q. 20. Explain the purpose of numeric data types in a database and provide any three examples of their
usage. 4
Q. 21. What are the common Types of Health Hazards ? Mention any four. 4

8 Information Technology-X