CENTRAL BOARD OF SECONDARY EDUCATION

School Name

Address

PORTFOLIO IS SUBMITTED TO DEPARTMENT OF

INFORMATION TECHNOLOGY FOR THE PARTIAL
FULLFILLMENT OF AISSE EXAMINATION SESSION -
2024-25

SUBMITTED BY: [SHIVAM SINGH]

HOD(COMPUTER):[MRS. SHWETA GUPTA]

CLASS: [CLASS]

ROLL NO: [5406657]

 ACKNOWLEDGEMENT
I wish to express my deep sense of gratitude and

indebtedness to our learned teacher MRS.SHWETA GUPTA,

PGT COMPUTER SCIENCE, [NARAYANA E-TECHNO SCHOOL] for his

invaluable help, advice and guidance in the preparation of

this PORTFOLIO.

I am also greatly indebted to our principal [

] and school authorities for providing me with the

facilities and requisite laboratory conditions for making

this practical file.

I also extend my thanks to a number of teachers ,my

classmates and friends who helped me to complete this

practical file successfully.

[SHIVAM
SINGH]
 CERTIFICATE

This is to certify that Master [SHIVAM SINGH] of

class [10-B] has successfully completed the
Information Technology - 402 PORTFOLIO under
the guidance of [MRS. SHWETA GUPTA]
during the academic year 2024-25.

Internal Examiner Principal

Signature Seal and Signature
Creating a new style using New Style From
Selection option
To create a new style using New Style from Selection option, follow the given
steps:

[1] Type the required text and format as needed

Here I have created a chapter heading with the following formatting:

 Font : Arial rounded MT bold
 Font Size: 18
 Bold
 Color: Red
 Highlight Color=Yellow

[2] Now select the heading typed in the document

[3] Open the Styles window and Click on the option New Style From Selection
from Style Action button

[4] A new dialog box appears with a new style name prompt, enter new style
name. Click on OK
[5] The style is available in the style gallery.
2. Create a template named certificate
[1] Prepare certificate format for template certificate.

[2] Click on File –> Templates –> Save as Template option.

[3] Template save as dialog box will appear. Type name “Certificate” and
select category – “My Templates”. Then “Save” Button.
[4] The template is saved into selected category.

3.Creating table of contents

Before creating a table of contents you must ensure the proper level of
headings must be created. If headings are not inserted in the document, it just
creates an empty Table of Content.

Follow the below steps to create a Table of Contents in the document:

[1] Prepare a document using different levels of headings as per the

requirements.

[2] Now place a cursor where Table of Content is required.

[3] Now click on Insert –> Table of Contents and Index –> Table of
Contents, Index or Bibliography option.
[4] The table of contents, Index, or Bibliography dialog box appears as
displayed in this screenshot:
[5] Apply the desired options for a table of contents and click on the OK
button.

4.Insert Image using drag and drop option

Insert an image using drag and drop from desktop in the document “Applying
Styles in document.odt”.

[1] Open the document “Applying styles in document.odt”. Place the cursor
where the picture is required.

[2] Restore the Libre Office Writer window and adjust the size of window as
needed.
Now the files and folders are displayed on desktop. Select the file from
desktop to be inserted into the document.

[3] Now drag the selected image file into the document. Image will be inserted.
Insert an image using Cut or Copy, Paste
Copy and Paste images is a very easy task. Simply, copy the image from the
source and paste it into the document at the desired location.

The image can be also inserted using drag and drop. Follow these steps to
insert image using drag and drop.

1. Open the Libre Office Writer document in which the image is to be

inserted.
2. Open a folder where the image is saved.
3. Now drag the desired image into the document where you want to insert
the picture.
4. The image will be inserted.
5. Creating Drawings using drawing tools
1. Select a drawing object to make a drawing. The mouse pointer will be
changed into drawing functions.
2. Move the point as per the need and shape needs to be drawn.
3. Release the mouse pointer to finish drawing.
4. The drawing function remains active till. You can deactivate it by
pressing the Esc key from the keyboard or clicking on the select icon
from the drawing toolbar.

Changing the drawing object properties

The properties of drawing objects can be changed. When a shape or drawing
is drawn in Libre Office Writer another toolbar will appear. This toolbar is the
Drawing Objects Properties toolbar which can be used for customizing the
drawing toolbar and drawing objects.

The drawing properties toolbar allows you to move, resize, rotate, edit, and
configure for various purposes. The properties changed before creation are
known as setting default values. The properties can be modified by right-
clicking on the object.

Setting or Changing properties of drawing object

To set the properties before drawing object follow these steps:

1. Select the drawn object.

2. From the drawing object properties toolbar click on the icon of the
property to be modified.
3. Change the value of the parameter.
4. Repeat steps 2 and 3 to change all desired properties.

Grouping objects
Follow these steps to group objects.

1. Select the objects by clicking on them.

2. Select the group tool from Drawing Object Properties or
Choose Format –> Group –> Group or Right click on selection and
Select Group option.
There are four options under Group. They are:

1. Group
2. Group
3. Enter Group
4. Exit Group
 Unit 2: Electronic Spreadsheet (Advanced)
1. Consolidating Data
To consolidate data, the following things are necessary:

1. Prepare multiple sheets with common data entries

2. Data types provided in the different sheets must match with each other
3. All sheet labels should match
4. The first column must be a primary column for data consolidation

Steps to Consolidate Data

To consolidate data follow the given steps:

[1] Prepare worksheets as follows and rename them as PT 1, and PT 2

respectively:

[2] Now create a blank spreadsheet with matched labels to consolidate data
as follows and rename as consolidated:

[3] Place the cursor in C2 cell of the consolidated sheet as displayed below:
[4] Click on Data –> Consolidate

[5] The consolidation dialog box appears.

Options:

1. Function: This option provides functions to summarize records in a

consolidated sheet. The functions are as follows:
o Sum
o Count
o Average
o Max
o Min
o Product
o Count(numbers only)
o StDev(sample)
o StDevP(population)
o Var(sample)
o VarP(population)
2. Consolidation Ranges: Here the range of cells will be added. Ranges
can be created or selected randomly.
3. Source Data Ranges: This option contains name ranges defined
through the Data –> Define Ranges option. By default -undefined-
ranges are given.
4. Copy Results to: This option specifies the range of cells where the
result needs to be displayed.
5. Add: To add range of cells for data consolidation.
6. Delete: To delete range of cells from data consolidation.
 7. Options: The options button has the following options for consolidated
data:

 Consolidated by – Allows to consolidate data according to row or

columns
o Row Labels
o Column Labels
 Options – Link to source data allows to change the consolidated result
when changes are made to the original data,

[6] Choose the appropriate options as per requirement such as function, add
the ranges of cells, and choose an additional option then click on OK.

Add range to data consolidation:

[7] Click on the OK button, finally.

Result:

Steps to define range:

Spreadsheet allows to define a range of cells with a specific name. To define
range in Libre Office Calc follow these steps:

[1] Select the range of cells which is going to be defined.

[2] Click on Data –> Define Range option.
[3] Define Database Range dialog box appears as displayed below:
[4] Type the Range Name in the Name box and click on the Add button.
[5] Click on OK button.
 2. Creating Subtotals
Creating Subtotals
Observe the data given below and create subtotals for the same.

Here I am going to display sum of products in ascending order with subtotals.

So lets begin!

[1] Select the data and click on Data –> Subtotals option.

[2] The subtotals dialog box appears. Select the column on which grouping
option is required. Select the column against the option Group by as below
here I have selected Product column, Select column to Calculate subtotals for
and Sum function:
[3] Click on OK button and it will display the result as follows:

Here subtotals created for given data. On left of the results the outline is
created automatically. By clicking on + and – sign it can be expanded and
collapsed. This outline can be removed using Data –> Group and Outline –>
Remove Outline option.
 3. Creating a Scenario
Let’s create a scenario for a team’s net run rate in a cricket tournament. Net
run rate is calculated by the below-given inputs match by match:

1. Runs scored in each match

2. Overs faced in each match
3. Runs given in each match
4. Overs bowled in each match

The formula to calculate the net run rate is:

RR =(runs_scored/overs_faced)-(runs_given/overs_bowled)

For each match, I have created a different scenario and named them as
Match 1, Match 2 , Match 3 etc.

The screenshots are as follows:

Steps to create a scenario
Follow the below given steps to create a scenario:

[1] Select the cells that contain values.

[2] Click on the Tools –> Scenarios option. The Create Scenario dialog box
will appear as displayed below.
[3] Type the scenario name in the Name of Scenario box, Edit the comment in
the comment box, and Change the desired color from settings.
[4] Click on the OK button.

[5] Repeat steps 3 and 4 for each scenario, and change the date, name, and
desired options as per the requirements.
 4.Goal Seek

Goal Seek dialog box will appears.

[3] By default it shows the absolute cell reference on first box which contains a
formula. Type the target value in the target value box and choose the cell
reference to be changed to achieve the desired result.
[4] Click on OK button. This will open a message box to display the message
such as “Goal Seek succeeded. Result 22.5. Insert the result into the
variable cell?”

[5] Click on Yes button to keep the value otherwise No. The value is to be
displayed in the cell as below:
Solver in Libre Office Calc

[4] Click on Solve button. It will display a new message box with a message –

“Solving successfully finished.

Result: 95

Do you want to keep the result or do you want to restore previous values?”

As displayed in the above dialog box click on the relevant button to keep the
result in the sheet.
 5.Creating hyperlinks in spreadsheet
For example, C:\\ LibreOfficeCalc\Files\Hyperlink.ods is an absolute
hyperlink.

The relative hyperlink contains only the filename. The relative link file will be
saved in the same folder where the spreadsheet is saved.

For example, The spreadsheet is saved

in C:\\ LibreOfficeCalc\Files\Hyperlink.ods and LibreOfficeCalc\Files\Photo1.jpg

is relative link.

If the file is moved from the original location along with the directory then also the
relative link will work as it is.

Creating hyperlink

To create a hyperlink, follow these steps:

[1] Select the cell in which the hyper link is to be created.

[2] Click on Insert –> Hyperlink option.

[3] The hyperlink dialog box will appear. The hyperlink dialog box looks like as
follows:
The hyperlink dialog box has following options:
[4] Select appropriate option to link out of the above and apply desired settings.

[5] Click on OK button.

Editing Hyperlink
The steps to edit existing link are as follows:

[1] Place the cursor anywhere in the link and right click on it and choose the Edit

hyperlink option from the context menu.

[2] Hyperlink dialog box will appear.

[3] Apply the desired settings and click on OK.

Delete hyperlink

To delete hyperlink, follow the steps given below:

[1] Place the cursor anywhere in the hyperlink.

[2] Right click on the hyperlink and choose the remove hyperlink option from the
context menu.
[3] The hyper link will be removed.

Linking to external data

Internet is the big source of information. This information is stored in the websites
which is collection of different web pages. These web pages are crated through
HTML. The libre office calc allows to link these HTML pages in the form of external
data.

The external data allows to copy the tables present in the website into
the spreadsheet.

To open external data dialog box, follow the below given steps:

[1] Open the spreadsheet where external data is to be inserted.

[2] Select the cell to store the first cell of the table in the external data.

[3] Select Sheet –> External Links

[4] The External Data dialog box will appear as below:
The dialog box has following options:

1. URL or External Data Source: Type the URL of HTML source file.

2. Available Tables/Ranges: It shows the list of available tables or ranges from

source.

3. Update Every: Specify the time to update the source after a specific interval.

[5] Type the URL in URL or external data source box and press enter. It will ask for
import options. Click ok button.
[6] Select any table in the available tables/ranges. I have selected HTML_11 table.

[7] The data will be inserted.

Linking to registered data sources

Libre office calc allows to linking with databases to other data sources. Register

the database with libre office base. To register the database, follow the given

steps:

[1] Click on Tools > Options > LibreOffice Base > Databases option. It will open
this dialog box.
[2] Select the database or create new database by clicking on New button.

[3] I have created a new database. It will open dialog box to create a database link
and click on registered name.

[4] When the ok button is pressed the database will be added to registered database
Database Management System
1. Create and edit tables using SQL COMMANDS
Create following table empl in LIBREOFFICE Base and perform below
given queries:

MPNO NAME DOJ SALARY CITY

5001 BIJAL PATEL 2019-05-12 55000 AHEMDABAD

5002 MEHUL SOLANKI 2020-10-11 65000 SURAT

5003 ASHOK CHAUHAN 2018-09-07 80000 AHEMDABAD

5004 VIJAY CHANDERA 2017-08-02 60000 BHARUCH

5005 RAKESH SHAH 2016-05-23 72000 AHEMDABAD

1. Create the above table using the SQL command.

Create table command

create table empl(empno int (4) primary key, name varchar(20),doj date,
salary int(5), city varchar(20));

insert into empl values(5001,'BIJAL PATEL','2019-05-

12',55000,'AHMEDABAD'), (5002,'MEHUL SOLANKI','2020-10-
11',65000,'AHMEDABAD');
 2. Create the above table using the design view.

Steps to create table and insert data

1. Open LibreOffice Base and Click on the Tables button.

2. Now click on Create Table using Design View.

3. A table design window appears.

4. Enter desired field names, select desired data types, and set the

primary key.

5. Now save the table.

6. Insert data.
 3. Write Queries for the following:

1. Display the details of employees whose salary ranges from 60000 to

75000.

2. Display empno, ename, doj and salary of employees belongs to

Ahmedabad and Surat.

3. Display ename and salary of employees except 5001.

Queries:

1. select * from empl where salary between 60000 and 75000; OR select *
from empl where salary>=60000 and salary<=75000;

2. select empno, ename, doj, salary from empl where city =’AHMEDABAD’
or city=’SURAT’; OR select empno, ename, doj, salary from empl where
city in (‘AHMEDABAD’,’SURAT’);

3. select ename, salary from empl where empno!=5001;

 4. Create a form using wizard enter, delete and show data of

employee.

Steps to create forms:

1. Click on the forms button.

2. Click on Use Wizard to create a form. A form wizard dialog box

appears.

3. Choose the table from the tables or queries option.

4. Now select all fields to add to the form. and click on the Next button.

5. Again click on Next as we are not going to add a sub form.

6. Now arrange the controls in the main form. and Click on the Next

button.

7. Now click the form to display all data and click on the Next button.

8. Select the appropriate style for the form.

9. Name the form and select the option works with the form.

10. Click on the Finish button.

 5. Create a report showing data city wise.

Create reports:

1. Click on the Reports button.

2. Click on the option to use a wizard to Create a Report.

3. Select the table and fields to be used in the report. and Click on Next.

4. Choose the labels from the window and click on Next.

5. Select the grouping on the city column and click on Next.

6. Click on Next after the sorting option.

7. Choose the desired layout. and click on the next button.

8. Choose the title of the report and select the Create Report Now radio

button.

9. Click on the Finish button.