Class X – IT (402)

Board Practical File

SESSION: 2024-25

N.K.BAGRODIA GLOBAL SCHOOL

Dwarka sec-17 New Delhi

Submitted by : Parisha

Class & Section : XC

Roll number : 18

Teacher Name : Mr. Sandeep Gagan

Teacher Sign : __________________

 CERTIFICATE

This is to certify that this practical work is submitted by

__Parisha_____(18) to the Computer Department of
N.K.BAGRODIA GLOBAL SCHOOL, DWARKA,
carried out by her towards partial completion of
Practical Exam for class X during academic year 2024-
25.

___________ ____________
Examiner Principal
 INDEX
Sr.No. Topics Page No. Signature
.
Unit 1 : Digital Documentation (Advanced)

Create a document on the topic "India is a

1
developing nation".
Create a “Resume” or “Biodata” of your own and
2
add suitable title, subtitle and page style on it.

3 Creating templates in OpenOffice Writer.

Design a template for leave application and ask the

4.
employees to fill up the required details.

5. Implement mail merge.

Unit 2 : Electronic Spreadsheet (Advanced)

6. Subtotals in OpenOffice Calc.

7. Consolidate data in OpenOffice Calc.

8. Create scenario in OpenOffice Calc.

9. Multiple Operations in OpenOffice Calc.

10. Goal Seek in OpenOffice Calc.

 PRACTICAL 1
AIM: Create a document on the topic "India is a developing nation".
PROCEDURE:
 Add a suitable heading style to the title.
 Apply a paragraph style on the first paragraph as 'Text body indent.
 Apply formatting options to the rest of the paragraphs such as font style
"Baskerville Old Face", font colour "blue", text highlight colour as "red", and font
size as "18". Text should be written in "bold".
 Save this file with “Developing_nation”.

OUTPUT:
India is a developing nation
Yes, India is considered a developing nation. It's
also classified as an emerging and developing
country (EDC), which means it has some aspects
of a developed country but doesn't meet the
standards to be considered advanced.
 PRACTICAL 2
AIM: Create a “Resume” or “Biodata” of your own and add suitable
title, subtitle and page style on it.

PROCEDURE:

OUTPUT:
 PRACTICAL 3
AIM: Create a template on OpenOffice Writer looks like a screenshot
and save as a template. Follow below-given instructions:
PROCEDURE:
1. Apply page borders as displayed in
the screenshot. Apply border
colour as per your choice.
2. Page orientation must be
landscape.
3. Give your desired formatting for
school name, school address, and
text written in the certificate.
4. Save your file as a template and
give the name certificate template.

OUTPUT:

N.K. Bagrodia Global School

Sec-17 Dwarka New Delhi

This certificate is awarded to Ms. Parisha of class XC in honor of her securing the 1 st
position in the Tournament of chess conducted on 25th August 2024.

Principal Competition judge Master in-charge

 PRACTICAL 4
AIM: Design a template for leave application and ask the employees
to fill up the required details. (using OpenOffice Writer)

PROCEDURE:

OUTPUT:
 PRACTICAL 5
AIM: Write a letter to invite your parents and other guests to attend
the annual day function of your school and merge them. Create a
data source with at least 10 addresses. (Using Mail Merge.)
Procedure: Step 1 – Select Document Type
 Click Letters for the document type
 Click Next: Starting document
 Step 2 – Select Starting Document
 Click Use the current document under Select starting document
 Click Next: Select recipients
 Click Use an existing list under Select recipients
 Click Browse and Select the file
 Click Open
 Select the worksheet tab name that contains the data
 Click OK (Mail Merge Recipients opens showing the file data)
OUTPUT:
 PRACTICAL 6
AIM: Use the Subtotal command to calculate the number of ‘jerseys’
of different sizes required for players.

PROCEDURE:
 Select the range of cells with values for which subtotal function needs to be
implemented.
 Click on data menu and select subtotals option. Subtotals dialogue box appears on the
screen.
 In the “group by” box, select the column for which subtotal is required.
 In the calculate subtotals for box, select the columns containing the values to obtain a
subtotal.
 In ‘use function’ box, select the desired function to calculate the subtotals.
 Click on Ok.

OUTPUT:
 PRACTICAL 7
AIM: Create a ‘Consolidated Summary’ sheet which will display the
Month-wise Consumption of Drinks (in Liter) of District-A,B and C.

Procedure:
 Click on data menu.
 Select consolidate option
 Click on source data range area box. A blinking cursor will appear in the box
 Select a source cell range from the worksheet to consolidate with other areas.
 Click on add button to insert the selected range in the consolidation ranges field
 Select additional ranges from different worksheets and then click the add button for the each
selection
 Click on the copy results to area box. A blinking cursor will appear in the box.
 Select a target cell range in which all the data required to be consolidated
 Select desired function from the function box. The function specifies for the values of the
consolidation ranges are linked. The sum functions is the default setting.
 Click on the more option and then select the link to sources data check box.
 Click on Ok button to consolidate the ranges

District A

District B

District C

OUTPUT:
 PRACTICAL 8
AIM: Create multiple scenarios based on number of cars that you
will be able to sell for each of the car models.
Procedure:
 Select the cells that contain the values which will change between scenarios. To select
multiple cells, hold the control key and then click each cell.
 Click on tools menu and select scenario's option
 Type a name for the new scenario. This name will be displayed on the title bar of the
scenario on the worksheet itself.
 Click on the okay. It is also optional to select a d select the options in the setting section.
Following options are the setting section.
 Click ok to close the dialogue box. A new scenario is automatically Activated. Repeat the
steps to create another scenario.

OUTPUT:

PRACTICAL 9
AIM: Let’s say 'ABC' Publisher publishes a book whose selling price
is Rs. 100 (cell B1), manufacturing cost of each book is Rs. 35 (cell
B2), in addition to fixed cost of Rs. 50,000 per year (cell B3).
Calculate profit made by the Publisher in a year if they sell 2000
books and profit for different sale of quantities that are 1500, 2000,
2500, 3000, 3500 using multiple operations.

 Procedure: To calculate the profit enter the formula = b4* b1-b2)-b3 in cell B5
 In column D enter expected annual sale figure.
 Select the range D2:E6. This will select the values in column D and empty cells of column
e.
 Click on data menu and then select multiple operations option.
 Multiple operations dialogue box appears on the. Click on the formulas feel to open
multiple operations dialogue box then click on cell B5. This means that sell B5 contains
the result that is the formula of calculation of result
 Place the cursor in the colum input cell field and click cell B4. This means that the
content of cell B4 is variable in the formula.
 Click on okay button.

OUTPUT:

PRACTICAL 10
AIM: A student is currently scoring 67.5% aggregate and needs at
least 80% to quality for yearly scholarship. Fortunately, he has a
chance to use his computer subject's score to raise the aggregate.
Which option is used to estimate at least how much marks are to be
scored in Computer subject for availing that scholarship. (Hint:
using Goal Seek)

Procedure:
 Click on tools menu.
 Select goal see option. Dialogue box appear on the screen.
 The cell address containing the formula is already entered in the formula
cell field.
 Enter the desired result 80.
 Place the cursor in the variable cell field in the sheet click in the sell that
contains the value to be changed. In this example B7 is the cell.
 Click on Ok button.
 Click on yes button.
 Estimated marks of computer subject s 75 to get 80% aggregate.

OUTPUT: