DELHI PUBLIC SCHOOL

DELHI PUBLIC SCHOOL

MARUTI KUNJ, GURUGRAM
MARUTI KUNJ, GURUGRAM

INFORMATION TECHNOLOGY (402)

PRACTICAL FILE
INFORMATION 2024-2025
TECHNOLOGY (402)
PRACTICAL FILE
2024-2025

SUBMITTED
SUBMITTED BY BY: PASTE
NAME:
NAME: NAITIK KUMAR YOUR
CLASS & SECTION:
X
CLASS: PHOTGRAPH
ROLL NO: HERE
SECTION: E
1|Page
 INDEX
NO. AIM PAGE NO. SIGN
1) Create a Birthday Card in Writer using Pictures & 3
Styles
2) Create a template in Writer using pictures, styles, 4
borders, background, etc.
3) Create a table of contents for topics of any subject 5
of your choice.
4) Create an article on 10 safety rules at the workplace 6
and use pictures related to it. Arrange the inserted
pictures and crop them accordingly. You can use a
table to insert images in tabular order. Mention the
source of the information. Use Page Border.
5) Design a cover page for a practical file. 1
6) Create a consolidated sheet for the two data sheets 7
given in OpenOffice Calc.
7) Create and Rum Macro 9
8) Implement Scenario in LibreOffice Calc 11
9) Use goal seek to find the desired value. 13
10) Use a solver to do an advanced search for the 14
desired value.
11) Create a new database and table in LibreOffice 16
Base.
12) Create a Form to add new records and if required 18
manipulate records.
13) Create a query on the existing table in Query 21
Design View.
14) Create Forms and reports in LibreOffice Base 25
15) Write SQL commands/queries to create and 27
manipulate the records
16) Write SQL commands/queries to create and 28
manipulate the records

2|Page
 ACTIVITY 1

Objective: To create a birthday card for a friend.

Skills used: Inserting a picture, Page orientation and size, Using fonts and Style elements.
Steps:
1) Insert background/border image.
2) Add a textbox and write the heading ‘Happy Birthday’ and apply styles.
3) Give the text/quote/message as required.
4) Add pictures like cake, balloons any other element, etc.
5) Use picture formatting to add border, crop, and adjust transparency.

Screenshots of Card:

3|Page
 ACTIVITY 2

Objective: To create a Certificate.

Skills used: Inserting a picture, Templates, Page orientation and size, Using fonts and
Style elements, and Headings.
Steps:
1) Insert background/border image.
2) Add a textbox, write the heading ‘Certificate’ and apply styles.
3) Give the text as required.
4) Add pictures like awards, ribbons, any other element, etc.
5) Use the line tool to create blank fields. (or use space + underline)
6) Use picture formatting to add border, crop, and adjust transparency.

Screenshots of templates:

4|Page
 ACTIVITY 3

Objective: Create a Table of Contents in OO Writer

Task: Create a table of contents which should include Heading and sub headings of the page by using
the Insert menu and selecting the Table of contents and index option of LibreOffice writer.

5|Page
 ACTIVITY 4

Objective: Write an article on 10 safety rules

Task: Write an article on 10 safety rules at the workplace and use pictures related to it. Arrange the
inserted pictures and crop them accordingly. You can use a table to insert images in tabular order.
Mention the source of the information. Use Page Border.

6|Page
 ACTIVITY 6
Objective: Implement Consolidate in LibreOffice Calc.

Task: Create a consolidated sheet for the two data sheets given in LibreOffice Calc.
Steps for consolidate data on two sheets:
1. Create a new spreadsheet in OO Calc.

2. Enter the data for Sheet 1 and Sheet 2. Rename the sheet as Term-1 and Term-2.

Sheet -1 Sheet-2

3. Add one more worksheet to display the consolidation result and rename as Final Marks
Consolidated.

7|Page
4. Consolidate Sheet

8|Page
 ACTIVITY 7
Objective: Create and Run Macro
Task: Create a simple macro recorder for a document and use it in a similar document for repeated
formatting.
Create a desired document in the spreadsheet for which you want to record a macro for the
formatting and styling.

The steps to record Macro are: -

1. Go to Tools Macros Record Macro.

2. Do the required steps to be coded in the macro. Here, we do the formatting in the cellrange A1:G8.
Then click on stop recording.
9|Page
3. Write a suitable name for the Macro and Save.

4. To run the macro, Go to Tools Macros and Run Macro

5. Choose the desired Macro Click on Run.

10 | P a g e
 Activity 8
Objective: Implement Scenario in LibreOffice Calc.
Task: Create three different scenarios of data given in LibreOffice Calc

1. Create a Sheet in LibreOffice Calc as given below that contains marks scored by any of your 5 different
friends in the PT2 exam and create three different scenarios of it.

2. In the first scenario find the total marks in the second scenario find the average score and in the third
one find the maximum mark of the 6 subjects.

SCENARIO 1 - SUM OF MARKS

11 | P a g e
SCENARIO 2 - AVERAGE OF MARKS

SCENARIO 3 - MAX OF MARKS

12 | P a g e
 ACTIVITY 9
Objective: Implement the concept of Goal Seek in LibreOffice Calc.
Task: Find the required amount of sale using Goal Seek

In the above screenshot, the Rate and Quantity are given and the amount is computed accordingly. Now achieve
the target amount of 500, so what should be the rate or how many quantities are required for the same, Goal Seek
helps to do the same.

1. Select the cell where the formula is written. For example, the cursor needs to be placed in B6.
2. Click on Tools → Goal Seek option.
3. A Goal Seek dialog box appears, fill in the details for Formula Cell, Target Value Cell, and Variable
Cell.
Formula Cell: B6
Target Value: 380
Variable Cell: B4 (if changes required in Rate) else B5 (if changes required in Price)
4. Click on the OK Button, Result will be displayed.
5. Click on Yes button to insert the calculated result.
6. Take a screenshot and paste it.

13 | P a g e
 ACTIVITY 10

Objective: Implement the concept of Solver in LibreOffice Calc

Task: Find the required amount of sales using Solver

In the above screenshot, the Rate and Quantity are given and the amount is computed accordingly. Now achieve
the target amount of 900, so what should be the rate or how many quantities are required for the same, Solver
helps to do the same.
1. Select the cell where the formula is written. For example, the cursor needs to be placed in B6.
2. Click on Tools → Solver option.
3. A Solver dialog box appears, fill in the details for Target Cell, Value, By changing cells and limiting
conditions..
Target Cell: B6
Value: 500
By changing cells: B4 (if changes required in Rate) else B5 (if changes required in Price)
Limiting conditions: Cell reference B4, Operator: <=, Value : 10
4. Click on the Solve Button, Calculated result will be displayed.
5. Click on the Keep Result button to insert the calculated result else click on Restore Previous values
button.
6. Take a screenshot and paste it.

14 | P a g e
Solver Screenshot

15 | P a g e
 ACTIVITY 11

Objective: Create a new database and table in LibreOffice Base.

Task: Create the database named demo and make a table named Order in it. Use Table
Design View with the mentioned fields and do the following:

Field Name Datatype

Order_Id Integer (Primary Key)
Item_Name Text [Varchar]
Amount Float
Quantity Integer
Total_Amount Float

1. Enter 10 records in the table using Table Design View.

16 | P a g e
3. Remove the tenth record from the table.

4. Arrange the records in the descending order according to the Total_Amount field.

17 | P a g e
 ACTIVITY 12

Objective: Create a query on the existing table in Query Design View.

Task: Open an existing database named demo and use table Order. Create a query
based on the given criteria in LibreOffice Base.

1. Display all the records of the table in Query Design View.

2. Display all the item names and their amount.

18 | P a g e
3. Display all the items where Amount is more than 100.

4. Display all the items arranged according to the Total field in descending order.

19 | P a g e
5. Display all the item details those item name starts with ‘S’ letter.

6. Display all the item details whose quantity is in between 0 and 200.

20 | P a g e
 ACTIVITY 13

Objective: Create a table, add records, and perform SQL queries in LibreOffice Base.

Task: Create a table Employee and perform the below-given queries (using SQL):

Table- Employee
Field Name Data Type Size
Empno Text [Varchar] 6
Ename Text [Varchar] 15
Job Text [Varchar] 15
Hiredate Date
Salary Decimal 10,2
Mobile Text [Varchar] 10

1. Create a table Employee using SQL commands in LibreOffice Base.

Create table Employee
(Empno varchar(6) primary Key,
Ename varchar(15),
Job varchar(15),
Hiredate date,
Salary decimal(10,2),
Mobile varchar(10));

21 | P a g e
2. Insert records in the Employee table using SQL mode.

Insert into EMPLOYEE values('1', 'Harish', 'Salesman', '2022-02-15', 55000, '9000123456');

Insert into EMPLOYEE values('2', 'Hema', 'Clerk', '2022-03-15', 45000, '9000123414') ;
Insert into EMPLOYEE values('3', 'Vani', 'Accountant', '2023-04-15', 57000, '9000123413') ;
Insert into EMPLOYEE values('4', 'Vikram', 'Accountant', '2021-05-15', 47000, '9000123412') ;
Insert into EMPLOYEE values('5', 'Ankit', 'Programmer', '2021-06-15', 65000, '9000123411') ;
Insert into EMPLOYEE values('6', 'Sanchi', 'Programmer', '2021-05-15', 75000, '9000123410') ;
Insert into EMPLOYEE values('7', 'Vansh', 'Manager', '2022-04-15', 85000, '9000123459') ;
Insert into EMPLOYEE values('8', 'Nikita', 'Salesman', '2022-03-15', 42000, '9000123458') ;
Insert into EMPLOYEE values('9', 'Sachin', 'Analyst', '2023-02-15', 75000, '9000123457') ;
Insert into EMPLOYEE values('10', 'Jagriti', 'Designer', '2023-01-15', 65000, '9000123456');

3. Display all the records of the table named Employee. Also, display a screenshot of the SQL query in
“Create Query in SQL View”.

Select * from Employee;

22 | P a g e
4. Create query in SQL View to display all the Employee number, name, and their Job.

Select EMPNO, ENAME, JOB from EMPLOYEE;

5. Create a query in SQL View to display the maximum salary earned by the employee whose job is
‘Programmer’.

Select max(SALARY) from EMPLOYEE where JOB='Programmer';

6. Create a query in SQL View to display the records in ascending order of Job.
Select * from EMPLOYEE order by JOB;

7. Remove the first record of the table named Employee.

Delete from EMPLOYEE where EMPNO= ‘1’;

8. Add a new column Email in the Employee table using SQL mode.
Alter table EMPLOYEE add EMAIL varchar(15);

9. Increase the salary of the employee with 1000 whose employee number is 5;

23 | P a g e
24 | P a g e
 ACTIVITY 14
Objective: Create Forms and reports in LibreOffice Base.
Task: Create the table Book_List, which stores data about books in the demo database with the
following fields:
Table: Book_List
Field Name Data Type Description
Book_Id Integer, Primary Key Book Id
Date_of_Purchase Date Purchase date of the book
Book_Name Text [Varchar] Book Name
Author Text [Varchar] Author Name
Category Text [Varchar] Categories of books, like novels, textbooks, comics etc.

1. After creating the table, create a form (using Form Wizard) for data entry in the table Book_List. The
form must contain all the fields of the Book_List table. Enter 10 records in the table using the form and
save it. Take a screenshot of the form and paste it.

25 | P a g e
2. After creating the form and entering the record in the table, create a report using Report Wizard for the
table Book_List showing the following fields:
Book_Id Book_Name Author
3. Change the formatting of the report as per your need. Save the created report & take a screenshot of the
report and paste it.

26 | P a g e
 ACTIVITY 15
Objective: Use SQL queries to create and retrieve records from the table.
Task: Write SQL queries to manipulate the table named ‘Students’ with the following fields and
records:

ItemCode ItemName Qty Price

1031 Pizza 2 250
1014 Burger 8 120
1042 Sandwich 5 75
1036 Cake 1 350
1022 Juice 2 25

1. Create the above shown table ‘Inventory’ with given filed names and appropriate data types.
create table Inventory(ItemCode Numeric Primary Key,ItemName VarChar(20),Qty Integer,Price
Integer)

2. Add two new records to the table.

insert into Inventory(ItemCode, ItemName, Qty, Price) values(1065,'Donut',2,20) ;
insert into Inventory values(1067,'Pastry',3,40) ;

3. Change the price of Sandwich to Rs. 90.

update Inventory set Price = 90 where ItemName='Sandwich';

4. Display item code and item name of items whose price is more than Rs. 100.
select ItemCode, ItemName from Inventory where Price >100;

5. Sort the above given query in descending order.

select ItemCode, ItemName from Inventory where Price>100 order by Price desc;

6. Add another column ‘Stock’ with integer data type.

alter table Inventory add Stock integer;

7. Remove the records where quantity is less than 3.

Delete from Inventory where Qty<3;

27 | P a g e
 ACTIVITY 16
Objective: Use SQL queries to create and retrieve records from the table.
Task: Write SQL queries to manipulate the table named ‘Students’ with the following fields and
records:

Roll_No Name Class Marks

101 Anu X 100
102 Manu IX 54
103 Kriti X 90
104 Banu IX 67
105 Tanu X 9

a. Write SQL command to create the above-given table. Set appropriate datatypes for the fields.
create table Students
(Roll_No integer primary key,
Name varchar(20),
Class varchar(2),
Marks integer);

b. Write a query to display the details of all the students studying in class X.
select * from Students where Class = ‘X’;

c. Write the query to change the Marks of the student named Banu to 88.
update Students set Marks = 88 WHERE Name='Banu';

d. Write a query to delete the record where the value of Marks is 9.

Delete from Students where Marks = 9;

e. Write a query to display the details of all the students whose Roll_No is greater than 102.
select * from Students where Roll_No >102

f. Write a query to display the Name,Class and Marks of all the students whose Name ends with
anu.
select Name, Class, Marks from Students where Name like '%anu'

28 | P a g e