INFORMATION TECHNOLOGY

PRACTICAL RECORD
CLASS- X

Name of the Student:

Roll No:
Batch : 2025 - 26
 CERTIFICATE
This is to certify that Mr/Ms.
Roll No of Class has
satisfactorily completed the term of the Subject,
Information Technology Lab.

Date: Signature of Teacher:

Head of the Department: Principal Sign:

 INDEX
Teacher
[Link] Name of the Practical Page No Checked On
Sign.

1. Writer Templates 1-2

2. Writer Styles 3-5

3. Image Cropping 6-7

4. Drawing Objects 8-9

5. Inserting Images 10

6. Consolidations 11-16

7. Subtotals 17-18

8. Multiple Operations 19-20

9. Scenarios 21-22

10. Solver 23-24

11. Goal Seek 25-26

12. Record Macros 27-28

13. Hyperlink 29-31

14 DBMS 31-35
  Writer Template
A template is a document type that creates a copy of itself when we open it.

For example, we can create a template for a certificate, and then use it again
and again instead of making it again from scratch every time.

To save it as a template, the steps are: -

1. Go to the File Menu Click on Save As option.

2. Browse to the desired place to save it and write the desired name for the file Choose the
file type as Template (.ott).
S......,,b

• o..li:!op lmb m
Dowm...i. C"""""""1F • l
,I. Da,,.,lu■d G,,

...., ..
Pict '°"
5(,t,OQII

\fidiHH.

_ IJAT,l(DII

,,
- fllll1P'•taor 1 .. J
j

(.doq
j

(Op nlin]lMm

.Ml- 1111)
l><mlll m (.ilu'[I
r tect ( UDlf
  Writer Styles
In this practical, we have to make a style in a file named
“File-1” and then import it in another file “File-2”.
To do so, the steps are: -
1. Firstly, open a new writer document and make the desired style you like. I have
taken my style to have font as Comic Sans MS, font size to be 18 and Italics.
2. Select the text with the formatting. Go to Styles and Formatting in side
bar Click on New Style from Selection.

3. Write the desired style name in the Style name textbox, here
My_Style Click OK.

4. The style gets added and is shown in the Style and Formatting
Menu.
5. Save this file and open another file to which we want to import the style.

6. In the Styles and Formatting sidebar, click on New Style fromSelection

drop down menu, then click on Load Styles.

[Link] on From File button on the bottom right side of the dialogbox.
8. Browse the file and then Click on Open.

The style will get added by these steps to the new file.
  Image Cropping

1. We make a new writer file, and insert the image.

2. Now we will crop the image by keeping scale. Right-click the image Click on Picture.

3. Under the crop tab, Click on Keep Scale radio button Set other specification
Click on OK.
  Drawing Objects
First, we will add many drawing objects-

Then we change the line style.

Now, we will change the object’s colour.

For grouping, we will select both of them while holdingshift. Right
Click on the selection Group Group.

Now, we can just drag the corner to increase or decreasethe size.

 Inserting Image
1. Insert image from Gallery. Go to Insert Picture From File.

2. Browse the image and click on Open.

3. Resize the image or rotate as per your need.

4. Apply the desired filter.
 Consolidation
There are four sheets with same structure – quarterly results of sales of a
stationery shop.

A total yearly sales sheet has been made. The steps are: -
1. Go to Data in menu bar Click on Consolidate.
2. The Consolidate dialog box appears. Here, we can select the
function we need to apply (Here, SUM).

3. Then we have to specify the ranges for consolidation. To do so,

choose the range while the Source data range text box in focus,
then click on Add.
4. Choose the desired cell for the results to copy in Copy results to
text box. Click on OK.
5. We will the final output as shown in the screenshot below.
[Link] get the consolidated data in the final sheet, named
 Subtotals

In this table, different accounts are recorded and otherimportant

fields (AcctType, Branch, Customer etc.) are present.

Here, we use Subtotal to find the total amount in different branches or

number of branches.

To perform subtotals, the steps are: -

1. Select the range of cells as shown below.

2. Go to Data menu choose subtotals.

3. Choose AcctType in Group by drop box menu Calculate
subtotals for Amount Use function Sum.

4. In the 2nd Group, Group by branch Calculate subtotals

foramount Use function count. Then press OK.
 Multiple Operations
Here, we have a dataset and want to calculate the profitvalue.

Now we use multiple operations to check the profit withchanging the

sale quantity and the price.

To perform Multiple Operations, the steps are: -

1. Select the data range with the input cells and space between them.
Do not select the data labels.
2. Go to Data Multiple Operations.

3. Choose the cell containing the formula in Formulae textbox.

4. Choose the Sale Quantity in Row Input Cell and Price per
Quantity cell in Column Input Cell OK.

By following these steps, we are able to perform Multiple Operations.

 Scenarios
Scenarios in OpenOffice Calc comes under what-if analysistools, where
we are able to get different values for output by changing the input cells.
Here, we have a table with cost price, selling price and profitpercentage.
Now we will perform scenarios, the steps are: -
1. Select the range of cells that are input and will be changed, here,
Cost Price and Selling Price. Go to Tools Scenarios.

2. Give the scenario desired name, check Prevent changes anduncheck Copy back.
Click on OK.
 1. Repeat step 2 to add more scenarios and we can see the outputchanging.

Practical – 10

Solver

Click on Tools - Solver and set the Cell to be optimized, the direction to go (minimization, maximization)
and the cells to be modified to reach the goal. Then you go to the Options and specify the solver to be used
and if necessary adjust the according parameters.
There is also a list of constraints you can use to restrict the possible range of solutions or to penalize certain
conditions.

Optimize results to
 Maximum: Try to solve the equation for a maximum value of the target cell.
 Minimum: Try to solve the equation for a minimum value of the target cell.
 Value of: Try to solve the equation to approach a given value of the target cell.
Enter the value or a cell reference in the text field.
By Changing Cells
Enter the cell range that can be changed. These are the variables of the equations.
Limiting Conditions
Add the set of constraints for the mathematical problem. Each constraint is represented by a cell reference
(a variable), an operator, and a value.
 Cell reference: Enter a cell reference of the variable.
Click the Shrink button to shrink or restore the dialog. You can click or select cells in the sheet. You can
enter a cell reference manually in the input box.
 Operator: Select an operator from the list. Use Binary operator to restrict your variable to 0 or 1.
Use the Integer operator to restrict your variable to take only integer values (no decimal part).
 Value: Enter a value or a cell reference. This field is ignored when the operator is Binary or Integer.
 Remove button: Click to remove the row from the list. Any rows from below this row move up.
 - - 1_3
nr 11btrat1 ,.., fl
!::
lomo
I B 1 U • 5-
El ·-
A
1 Name Son n
2

, Hindi 55
4 nglish 66
s Math -------------------;;-i
77
6 Sst 88 1Jmlfln9Condll.....
1 Science 33
8 It 44
Total 363
1
10

ll

l2
13
lA

Ii

EJI• ,iidit m IMffl F41nno1 Stxlft fft Qm !oolo W.r,do,, J:!dp

d I fll• J:iome Jn<
- -
,,t
- --,- qm'!
-

r .(. Clone [Link]-tion Son, B lD pl El --

-_---- ------_,-,...::;-- ---
_

P.
[Link]•
0
l@c.,py &,ere., I B I .U. • 5 Ffl •

E=-- J
::::11•111iiiiic -f.'_,--::====== :::.:::.:::.:::.:::.:::.:::.:::.:::.:::.:::.:::.:::.:::. :::.:::.:::. =-====-
2A_:
l Name Soh
2

3 Hindi 55
A English 66
, Math 77
6 Sst 88
1 Science 70
8 It: 44
Total 4001
10

ll

12

I
l3
li
 Goal Seek
This option is used to find the value of input cells by givingthe value of
the output cell.

In the other cases, the discount %age is given and we haveto find the
Selling Price. We can use Goal Seek in the following ways: -
1. Go to Tools Goal Seek.

2. Set the formula cell as Discount %age cell, target as specified,

here, and Variable Cell to be Selling Price.
 Record Macro
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 write the

formula in the cell B4 i.e., “=B1-B2”. Then click on stop
recording.
3. Write a suitable name for the Macro Save.

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

5. Choose the desired Macro Click on Run.

 Hyperlink
Here, we will add a hyperlink to a website. Steps are: -
1. Go to Insert Hyperlink.

2. Click on Internet Click on Web radio button Under Target

textbox, write the link of website.

3. Click on Apply. The link will be visible in the selected cell.

 Practical 14: DBMS
1. Define the followings:
(i) Primary Key

(ii) Composite Primary Key

(iii) Foreign Key

 Primary key

A primary key is a field in a table which uniquely iidentifies each row/record in a database table.
Primary keys must contain unique values. A primary key column cannot have NULL values.
A table can have only one primary key, whic::h may consist of slngle or multiple fields. When
multiple fields are used as a primal'y key, they a,re called a composite key.
If a table has a primary key defined on any field(s), then you cannot have two records having the
same value of that field(s).

Primary key

Composite primary key

When multiple fields are used as a primary key, they are called a composite key.
A primary key having two or more attributes is called composite key. It is a combination of two or
more columns.
An example can be -

Here our composite key

is OrderlD and
ProductlD.
 -
furdr,a

-
key
.In
ipl!Q
,,,_.
-
IYl!il
iDJDt 6tl;d

-
J'Qrelg11;Key;:

._ 110.
Pl'llll t.' k '
Th [Link] h!y of a parri ular tabl
1 is the, nftribu1e 1,v'hicb [Link])' The. for ign.k y 'al articular table i ,simply
llle prilllllcy key of somt [Link] k
[Link] evay record ood does nm
which i5 i1:sed as a reference -ey in tl1e . e ond
rum1i11 011_ nnil vaJu . nible.
[Link].I I k. y atb"[Link] in, , rabl.e '-"al.I
never CQlltain a mU v11]ue. A ft migu key anribme ma h.3 e rmn \ alue as \\[Link]
I mort! tlllm one piimmy key i
emtitte t in tabl-e. A rable Qll'I haw on or m t\e than [Link] forei._2;11 key fo
Duplicity t tr-i\;tly pr h:ibited in ille referential purp e .
priutmy key: 1bere [Link] be ,my Dtlplicii.y1-S JR•[Link] i11 the foreigu .ke lltl1ibme:
dnpli are alu , henc-e dt ti lie11', hie re ennitted.
_ mv. let m [Link]:r lhe mble reacher_ which recmrl
Exi1t11nple: l1l tea her in me .'rl!IJ ,!:

o ider !he tnble tiudem. whid1 keep He1 Tid 01· Jead1er id i th" mliqu primm-y key.
retcml of :!.l;1tderit. m ll [Link]: for e h rec-o-i-d in the table, Thi table l the ·•m
attribure whi is- the prim."!ly rey o the • mdei-u
Het--e. Id i the [Link] key whlcb niblt as its [Link] key or fo1-eigu key to r • to The
llliqu.e'l. id urifles ea h reicord 1n the sm&:m the pmticu 1: reacher re-ache . :
tab]e "srud m''
TID }\J,,,IE TAddr . ID
ID - AA1E Adlre-s 1 Priyil p 101
Hll ABC :{ Riya R 101
02 ,Ef y 3 Sam 10_
,o- GH1 z '1 Tom T lO
10..J JKL w
Si:ri one smdem [Link] tr b 1110te [Link] one te-ache-
i·_ 11l ID anribur wlticll iE th t<i :i!!J.I ki:y in
rlili r:iWe. oom:ifo duplicare values
1) Differentiate DDL and DML commands.

DDL is Data Definition Language which is used to define data structures. For
example: create table, altertable are instructions in SQL.

DML is Data Manipulation Language which is used to manipulate data itself. For
example: insert, update,delete are instructions in SQL.
aJ create the tallowing table items.
Column name Data type Size Constrain
ltemno Integer Primary key
Iname Varchar 15
Price Numeric 10, 2
Quantity Integer 3
a) Consider the following table Item and write the queries (i) and (ii).
Table: Item
ltemno lname Price Quantit:it
11 Soap 40 80
22 Powder 80 30
33 Face cream 250 25
44 Shampoo 120 100
55 Soap box 20 50
i. Write a command to insert a new record with the followi:ng values :
(66,{Gel', 1501 70).
ii. Write a query to disp[ay all the record of table Item whose price is in the range of
100 and 300.
or
Write a query to display all tlhe records of a table in descending order of
quantity.
ANISWER
a) Create table items(
ltemno integer Primary key1
lname varchar(15},
Price numeric(l0,2),
Quantity integer(3) );
b) , i. Insert into i1tem values(66,.'Gel', 150, 70j,;
ii. Select* from item where price between 100 and 300;
:[or Select *from item where price >=100 and price <=300;]
or
Select * from item order by quantity desc;