Class 10 Information Technology Code 402 – Second Board Marking Scheme 2026

Information Technology (Code 402/89) – Second Board Marking Scheme (Paper Code: 89)

Maximum Marks: 50

SECTION A: Objective Type Questions (24 Marks)

1. Answer any 4 out of the given 6 questions on Employability Skills. (4 × 1 = 4)

(i) (C) Set a SMART goal

(ii) (C) A customer is asking a question and the cashier responding.

(iii) (C) Increase in use of fuel for making tea.

(iv) (D) Google Android

(v) (D) Patient

(vi) (C) 17

2. Answer any 5 out of the given 6 questions. (5 × 1 = 5)

(i) (C) Chart

(ii) (A) Solarisation

(iii) (B) Six

(iv) (D) Automatically generate a list of headings along with their page numbers.

(v) (C) Graphics file formats

(vi) (D) On the right side of the window

3. Answer any 5 out of the given 6 questions. (5 × 1 = 5)

(i) (A) $

(ii) (B) Trends and relationships

(iii) (A) Scenario

(iv) (B) Tools

(v) (D) .ods

(vi) (C) Use the shared spreadsheet feature for collaborative editing.

4. Answer any 5 out of the given 6 questions. (5 × 1 = 5)

(i) (C) Record

(ii) (B) Data redundancy

(iii) (C) It is owned by Microsoft company

(iv) (D) In Datasheet View

(v) (B) tool-tip

(vi) (C) No Action

5. Answer any 5 out of the given 6 questions. (5 × 1 = 5)

(i) (B) Quickly accessible with items for cuts, burns, headaches, cramps.

(ii) (A) Exposure to toxic cleaning agents

(iii) (D) Increasing screen glare to make the display brighter

(iv) (B) A probability of causing harm to people

(v) (C) Cardio

(vi) (B) Checked regularly for safe functioning

SECTION B: Subjective Type Questions (26 Marks)

Answer any 3 out of the given 5 questions on Employability Skills in 20–30 words each. (3 × 2 = 6)

6. Write any one communication barrier and suggest one way to overcome it.
Ans:

• (a) Linguistic barriers – Use simple language or
• (b) Cultural barriers – Be respectful of cultural differences or
• (c) Physical barriers – Communicate in person when possible or
• (d) Interpersonal barrier – Use visuals to aid communication

(1 mark for correct barrier and 1 mark for explanation)

7. Rajan has the habit of keeping his device plugged in even if it is fully charged. Is this habit advisable for good maintenance of the device? Yes or No. Justify your answer with explanation.
Ans: No, this is not advisable. If we leave the device plugged in for a long time, it can overheat the battery, which reduces the battery life.
(1 mark for correct Yes/No, 1 mark for justification)

8. Write any two misconceptions about entrepreneurship.
Ans:

• Misconception 1: Every business idea needs to be unique.
• Misconception 2: Need lots of money to start a business.
• Misconception 3: Only a person having a big business is an entrepreneur.
• Misconception 4: An entrepreneur is born not made.

(Any two; 1 mark for each correct answer)

9. Write four steps for effective time management.
Ans:

• (a) Organize: Plan daily activities and make a timetable.
• (b) Prioritize: Rank tasks in order of importance.
• (c) Control: Avoid time wasters and focus on important things.
• (d) Track: Monitor how time is spent to identify improvements.

(1/2 mark for each correct step)

10. For sustainable development, we have to become responsible consumers and producers. List any four ways that will help us become responsible.
Ans:

• (a) Reuse Paper, Glass, Plastic, Water.
• (b) Take cloth bags for shopping.
• (c) Donate unused items like clothes, books, furniture.
• (d) Buy and eat seasonal fruits and vegetables from local growers.
• (e) Repair leaking pipes and taps to avoid wastages of water.
• (f) Sort and treat garbage before disposing.

(1/2 mark for each correct way — any four)

Answer any 4 out of the given 6 questions in 20–30 words each. (4 × 2 = 8)

11. Riya inserted a photograph in her LibreOffice Writer document. The image looks too large and also has unwanted background on the sides. Which two features of LibreOffice writer should she use to adjust the image size and remove the unwanted parts?
Ans: Riya should use the:

• Resize option to adjust the image’s size.
• Crop option to remove the unwanted background.

12. Suppose you are watching a movie in a cinema hall and suddenly thick smoke starts coming out due to a short circuit. The management announces evacuation. Mention any two general evacuation steps you would follow in this situation.
Ans:

• Leave the premises immediately and start moving towards the nearest emergency exit.
• Guide everybody in the cinema hall to the emergency exits.
• If possible, assist any person with a disability to move towards the emergency exit.
• You may carry your handheld belongings as you move towards the emergency exit. Do not come back to pick up your belongings unless the area is declared safe.
• Do not use the escalators or elevators (lifts) to avoid overcrowding and getting trapped in case of power failure; use the stairs instead.
• Go to the emergency assembly area, check if any colleagues/companions are missing, and immediately inform the person concerned.

(Any two)

13. What is the role of the External Data Dialog box in LibreOffice Calc? Briefly discuss.
Ans: The External Data Dialog box in LibreOffice Calc is used to import or link tables from external sources, such as HTML documents or web pages, into a spreadsheet. It allows the user to select the specific table or data range from the external document and insert it into Calc, making it easy to work with up-to-date information without manually copying and pasting data.

14. List two important features of the Network Data Model in a Database.
Ans:

• Multiple records are linked to the same master file.
• It is also considered as an inverted tree where the master is present at the bottom of the tree and the branches contain information linked to the master.

15. Briefly discuss the significance of using a Macro as a function in LibreOffice Calc.
Ans: The significance of using a Macro as a function in LibreOffice Calc is that it allows users to perform repetitive and complex calculations efficiently when no predefined function is available. It helps save time and effort by eliminating the need to repeatedly type and remember formulas. A macro function can accept arguments, perform calculations on different data across multiple sheets, and return results, making data processing more flexible, consistent, and accurate.

16. List any two reasons for Health, Safety and Security Programs or Policies in workplace.
Ans:

• It clearly indicates the company’s commitment to employee health and safety.
• It shows that business performance and safety performance are compatible with each other.
• It clearly states that the company is not only doing business for profits but is taking care of all stakeholders.
• The accountability of everyone working for the company is outlined for workplace health, safety, and security.
• Companies can comply with national policies on Occupational Health and Safety (OH&S) of the Government of India.
• Injuries and illness of employees are prevented through such policies.

(Any two)

Answer any 3 out of the given 5 questions in 50–80 words each. (3 × 4 = 12)

17. (a) What is meant by exporting a template? How is it different from moving a template from one category folder to another?
(b) Describe the step-by-step procedure to export a template using the Templates dialog box.
Ans:

• (a) Exporting a template means saving a template file to any desired folder or location on the computer using the Export template feature. It allows the template to be shared easily with other users or stored outside the default template categories. Exporting differs from moving because moving only changes the category of the template within LibreOffice, whereas exporting creates a copy of the template at a selected location on the computer.
• (b) Step-by-step procedure to export a template:
  1. Open the Templates dialog box and select the template that you want to export.
  2. Click on the export button located at the bottom right of the dialog box.
  3. The Select Path dialog box appears. Choose the folder where you want to export the template.
  4. Click the OK button. The template is exported to the selected folder, and a confirmation dialog box is displayed.

18. Mr. Rakesh owns a small grocery shop. One of his friends suggested that he should use LibreOffice Calc, which includes What-if Analysis tools such as Multiple Operations. Help him understand these by answering the following questions:
(a) What is the use of What-if Analysis tools?
(b) What is the use of the Multiple Operations tool in LibreOffice Calc?
(c) Select the ______ menu → Multiple Operations to use this tool.
(d) This tool uses ______ (one/two/three) arrays of cells.
Ans:

• (a) What-if Analysis tool is very helpful when we want to know how much profit we earn for a particular product for a series of selling units (predicting output by changing inputs).
• (b) The Multiple Operations tool creates a formula array to display a list of results applying the formula on a list of alternative values used in the formula.
• (c) Data
• (d) Two

19. Sheena wanted to maintain the details of her boutique’s customers in a DBMS named LibreOffice Base. Help her understand it by answering the following questions:
(a) What is the full form of DBMS?
(b) Why should she choose a database to maintain the details? Mention any two points to support your answer.
(c) What is the difference between Char and Varchar datatypes in LibreOffice Base?
(d) She wants to enter data into a table in an easy and user-friendly manner using a form object. Mention any two control names that can be used with it.
Ans:

• (a) Database Management System
• (b)
  • Organised Storage: Data in the database is stored in an organized manner so that retrieval of required data is fast and accurate.
  • Data Analysis: A database helps in analysis of data based on certain criteria (e.g., finding maximum/minimum values or averages).
  • Data Sharing: If the same data set is required for different applications, the database can be shared.
• (c)
  • Char: Stores exactly the fixed length specified by the user (padded with spaces if shorter).
  • Varchar: Stores variable-length data up to the specified maximum length; bytes allocated depend on the actual number of characters entered.
• (d) Text Box, Label (or any other two valid controls).

20. Proper guidelines must be followed by an organisation to keep the surrounding air and water clean. Mention any four such guidelines.
Ans: Guidelines for clean air and clean water are as follows:

• 1. Air pollution is mostly caused by dust production, solid particles, and gases. Avoid excessive dust and gas generation in the air.
• 2. Extensive use of automobile vehicles in the campus leads to air pollution. Organizations should limit vehicle use (e.g., practice a “no vehicles day” every week).
• 3. Keep the generation of ozone gas/smog at a low level.
• 4. Take care that sewage or waste water is properly treated and not directly mixed with surrounding water sources.
• 5. Avoid extensive use of fertilizers and pesticides to prevent groundwater pollution.

(Any four)

21. Consider the table CUSTOMERS given below and answer the questions that follow:

(a) What is an entity? Name the entity shown above.
(b) How many data values are present in the above shown table CUSTOMERS?
(c) List two different ways of creating the CUSTOMERS table in LibreOffice Base.
(d) A new column, bill_datetime, needs to be added to the table shown above to store the billing date and time in a single field. Suggest a suitable datatype and provide justification for your choice.
Ans:

• (a) Entity: It is a real-world object about which information is to be stored in a database.
  Entity Name: CUSTOMERS
• (b) There are 12 data values present in the table.
• (c) Two ways to create the table:
  • Creating Table in Design View
  • Using Wizard to Create Table
• (d) Datatype: Timestamp
  Justification: Timestamp is a date-time datatype that stores both date and time information simultaneously in a single field.