Practical file

Information technology
Subject code 402
Submitted by
Name :- Kabir
Roll no. :-
 unit :- 1 (digital
documentation)
Practical 1: using fill format mode
It may be difficult to make multiple selections first and then apply a style to the text. In
such a situation , you can use the fill format mode.
The fill format mode allows you to apply a style to many different areas quickly ,such
as you can format many scattered paragraphs, words, or other items with the same
style. In other words, the fill format mode copies a style and applies the same to the
other items

To apply the style using the fill format mode, follow these steps:
1. Open a document and select a heading in the document
2. Now, open the styles and formatting pane and double click on the style, for
example, heading 1 click on

practical 2 :- What is Fill Format Style, how it can

be applied.
Solution: This method is useful when a same style is to be applied at many places
scattered in the document. Fill Format can be used to style scattered – pages,
frames, tables, lists, paragraphs or characters. Follow the steps given below to
use it.
Step 1. Open the document to be styled.
Step 2. Open the Styles window and select the desired style category and then
desired style from drop down list.
Step 3. Select Fill Format button.
Step 4. To apply the selected style, take the mouse pointer to desired location and
click. Do take care to apply style on appropriate type of content.
Step 5. Repeat step 4 until all the changes have been made for that style in the
entire document.
Step 6. To quit Fill Format option, click the Fill Format button again or press the
Esc key
 practical 3 :- creating a template from a document
A template can be created in writer by saving a
document with .ott extension. To create a template of
your document follow these steps :-
1. open the document or create a new document
2. while creating a document add the content that
you want to use further for example company logo
,copyright statement
3. click on the file menu and select templates>save
4. The template dialog box appears all the existing
categories of templates are displayed here
5. enter a name for the template in new template text
box for example, new template
6. select the category in the categories list.
Click on the OK button. A new template of your
document will be saved in my templates folder.
practical 4 :- adding table of contents
To add Table of Contents, follow the steps given
below.
Step 1. Open the document in LibreOffice Writer.
Step 2. Select Insert > Table of Contents and Index >
Table of Contents, Index or Bibliography. The Table
of Contents, Index and Bibliography dialog box will
be displayed.
Step 3. In the Type the Titles text box, type op Table of
 Contents.
Step 4. Click OK. The Table of Contents will be
inserted in document
unit :- 2 (electronic
spreadsheet)
practical 1 :- consolidating database
Step 1. Add a new sheet and rename it as
Consolidate
Step 2. Click on Data > Consolidate or use the
keyboard shortcut key ALT+D, the Consolidate
dialog window will open
Step 3. In the Function box, choose Sum function
from the drop down as we want to add the data
from all the sheets.
Step 4. Click in the Source data ranges box and
then click on the worksheet ABC_Branch and select
the area to be consolidated and then click on the
Add button will add the copy reference in the
consolidation ranges.
Step 5. Click on the sheet XYZ_Branch and select the
area to be consolidated and then click on ADD will
add the next consolidation range.
Step 6. Click on the ‘+’ sign next to Options in the
Consolidate dialog window to change the settings.
‘Consolidate by’ has two options Row labels and
Column labels. Check row label or column label or
 both if you want to consolidate it by matching the
label. If Link to source data is checked, then it will
keep on updating the data of the Consolidate sheet
automatically if there is any change made in the
selected ranges.
Step 7. Click on ‘Copy results to’ and then click on
any of the cell in the Consolidate sheet where you
want to copy the final result after consolidation.
Step 8. Click on OK button. It will display the
Consolidate sheet with data after consolidation.

practical 2 :- creating scenarios

To create scenarios in Calc, follow these steps:
 Open the Calc worksheet and enter the data as shown
.
 Enter the Formula PMT (Interest Rate/12, NPER, Loan
Amount, 0, Type) in cell b5 as shown
 Press Enter to get the calculated value as shown in
Figure 6.16.
 Now, select the initial values in the worksheet as
shown
 Click on the Tools menu and then the Scenarios
option.
 The create scenarios dialog box will appear
 in the dialog box enter the name such as ABC bank
and add comments then click ok
 Deselect the Copy back checkbox. Otherwise, it will
inadvertently overwrite the values in the first scenario
 Click on OK to close the dialog as box. The new
scenario is automatically activated shown.
 Change the rate of interest in cell B2 as 0.09 and
create a scenario with the name BBC banks
 Now, you can compare the best price EMI by easily
switching between these four scenarios. You can switch
between these scenarios by using a drop down arrow,
which is available next to the scenario or the
Navigator.
 practical 3 :- using goal seek
follow the following steps after creating this data to
use Goal seek tool to change marks of S.St. from 30
to desired marks.
 Step 1. Enter the values in the worksheet.

 Step 2. Write the formula in the cell (B7) where

the calculation has to be used.

 Step 3. Place the cursor in the formula cell (B7),

choose Tools > Goal Seek.

 Step 4. The Goal seek dialog window will appear,

the Formula cell box will have the correct

formula.
 Step 5. Place the cursor on the Variable cell box

and click on the cell (B6) that contains the value

to be changed.
 Step 6. Enter the desired result in the Target value

box.
 Step 7. Click on OK button

practical 4 :- inserting new spreadsheet

You can insert as many sheets as you want in a

spreadsheet. You can follow the given methods to insert
new sheets in a spreadsheet
 Right-click on any of the sheet tabs and select the
Insert Sheet option from the shortcut menu
 the Insert Sheet dialog box appears as shown
 Select the Before current sheet or After current sheet
option from the Position section in the dialog box.
 Click ok
 your sheet is now created
 unit :- 3 (data base
management)
practical 1 :- creating table using design view
Step 1. Type the first field name (EventId) in the Field
Name column. Press Tab key. The cursor moves to
the second column i.e. Field Type.
Step 2. The Field Type column contains a list box. As
you click on the down arrow, it appears and we can
select the desired data type from the list box. Select
the datatype (Varchar).
Step 3. Observe that certain properties appear in the
Field Properties Pane as the data type is selected.
Some of the properties are Entry required, Length,
Default value, Format example. Set the desired
properties for the entered field.
Step 4. Press Tab key to move to the next column.
Add any description if you want in the third column.
Step 5. Once the properties for the field are set, press
Tab key to move to next row. Selecting data type
for field Fields entered using Creating Table in
Design View
Step 6. Enter the next field by repeating steps 1,2 and
 3. Repeat the process for adding all fields in the
table.
Steps 7. After creating the table you need to save it on
the disk. To save the table click on the save button
or follow menu option File > Save As. Enter the
name of table and click on OK button

practical 2 :-adding a new record

To add a new record, follow these steps:

 Click on the New Record button on the Form

Navigation toolbar.
 Enter the required information in blank fields.
 Click on the Save button on the Form Navigation
toolbar.
You can view the record that you have entered
through the form in the table by clicking on the
table name from the Database Objects pane. For
example, click on the Student_Info table. You can
see the new record entered in the table

practical 3 :-creating forms using wizard

To create a form using wizard, follow the following
steps.
Step 1. Open the Sports Day database created in
LibreOffice, and click the Form icon on the
Database Pane. Click the option Use Wizard to
 Create Form… on the Tasks Pane.
Step 2. The step 1 of the wizard is to select the tables
or queries for which the form has to be created. As
we are creating a form for Events table, select
Events table from “Tables and queries” list box.
Step 3. After selecting the Events table, all the fields of
the Events table will be listed in the Available Fields
list box.
Step 4. As we require all the fields to appear in the
Form, shift all the fields of Event table from
Available Fields list box to Fields in the Form list box
using >> button. Observe that, all the fields are
shifted to Fields in the Form list box. Click on Next
button to move forward.
Step 5. The second step consists of setting up a
subform, i.e. a form within a form. You need to
check the checkbox “Add Subform” to add the
subform. Since we do not want to set up any
subform, click Next button to proceed further.
Step 6. The wizard skips the next two steps that relate
to the subform and moves on to step 5. This step
arrange controls i.e. to set up the design of the form.
Observe that, by default, all controls will be left
aligned. Four layouts are given in this step of the
wizard to choose from: • Columnar display with
Labels on the left of the field value • Columnar
display with Labels on top of the field value •
 Display as datasheet • Block display with labels on
top Let us select Columnar Display with labels on the
left arrangement. Also note that as we choose the
Layout type, the fields are arranged in the Form
Design view also.
Step 7. Click Next button.
Step 8. The step 6 of the wizard asks whether the
form will be used for displaying data, entering data
or both. As we go with the default settings, so we
click Next button.
Step 9. The next step is to apply styles to the form
being created.
Step 10. Click Next button.
Step 11. The next step is to set the name of the form.
Say Events Form. Click Modify the form option.
Step 12. Click Finish button

practical 4 :-editing record in table

Sometimes, you need to correct or modify the records in a
table. To do so, follow the given steps:
 Open the table in which data is to be edited.

 Click on the Edit menu and choose the Edit Data

option.
 The table opens in the edit mode. Make changes in

the records as required.

Click on the Save button to save the changes.
Thanks you