Information Technology(402)

Practical
File (2024-2025)

Submitted By: Submitted to:

Name : Geetali IT Faculty
Class :X
Section :
Maples

1
S. No. Topic Name Page No.
Unit-1 Digital Documentation(Using LibreOffice Writer)
1 Creating and applying styles in LO Writer
2 Insert and Use images -Creating a Poster
3 Insert and Use images –Creating a Greeting Card
4 Creating templates in LO Writer and saving for
distribution.
5 Creating a table of contents
Unit-2 Electronic Spreadsheet(Using LibreOffice Calc)
1 Consolidating Data in LibreOffice Calc
2 Sub Totals in LibreOffice Calc
3 Scenarios in LibreOffice Calc
4 What-if analysis Multiple Operations
5 Goal Seek in LibreOffice Calc.
Unit-3 DBMS(Using LibreOffice Base)
1 Creating a Library Database with Tables, Queries and
Forms
2 Creating a Stores Database with Tables, Queries, Forms
and Reports
3 Creating a Patient Database with Tables, Forms and
Reports
4 Creating an Employee Database with Tables, Queries,
Forms and Reports
5 Creating a Student Database with Tables, Queries and
Forms

2
Unit-1Digital Documentation(Using LibreOffice Writer)
Assignment1
Objective: Creating and applying styles in LO Writer document
Task:Write your resume/Bio Data and apply different styles on it.

Procedure:
Step 1-Open the document containing bio data.
Step 2 -Select the text to be formatted. The selected text may be a
collection of Characters, words, lines, paragraph, page, frame or table.

Step 3 -To format the selected text, choose appropriate style by

clicking the button from the top of the Styles bar.

3
Step 4 -A list of styles for that category appears. Double click on the
desired style to apply to the selected text.

Step5-Repeat the process to apply the number of headings.

*Your Desired Document Will Be Created*

4
Assignment 2
Objective: Insert and Use images
Task: Create a poster on “Health and Hygiene” by using image and
drawing tools.
Procedure:
Step1-Open LibreOffice Writer.
Step 2-Go to Format>Page>PageSetup>SelectA3>Click OK.
Step 3-Add a background Color.
Go to Format>Page Background ,Select the Color in the
Background dialog Box and Click 'OK'.
Step4 -Insert Title and Text.
Step5-Insert Picture Dialog.
#Choose Insert>Picture >From File from the menu bar.
#On the Insert Picture dialog navigate to the file to be inserted, select
it ,and click-open,

5
#At the bottom of the dialog are two options, Preview and Link. Select
Preview to view a thumbnail of the selected image on the right, so you
can verify that you have the correct file. See below for the use of Link.

Save the Document asa . Odt File.

*Poster is Created*

6
Assignment3
Objective: Insert and Use images
Task: Create a “New Year” greeting card by using image and drawing
tools.
Procedure:
Step1-Open LibreOffice Writer.
Step 2-Go to Format>Page>Page Setup>SelectA3>Click OK.
Step 3-Add a background Color.
Go to Format>Page Background, Select the Color in the
Background dialog Box and Click 'OK'.
Step4-Insert Title and Text.
Step 5-Drag and Drop
#Open a file browser window and locate the image you want to insert.
# Drag the image into the Writer document and drop it where you
want it to appear. A faint vertical line marks where the image will be
dropped. # To link the file instead of embedding it, hold down the
Control+Shift keys while dragging the image.

7
GREETING CARD IS CREATED-

8
Assignment4

Objective: Creating templates in LO Writer and saving for

distribution.
Task: Create a document that looks like a screenshot and save as a
template. Follow below-given instructions.

Procedure:
Step1-Select “Text Document”.Click Create.
Step2-Use the Text to add any text.
Use Insert to add Images.
Step 3-Go to File >Save As>Template.
To Use Template: File>New >Template.

TEMPLATE DIALOG:

Select the Template From My Template.

9
TEMPLATE IS CREATED:

1
Assignment5
Objective: Creating a table of contents
Task: Write a complete chapter from your text in LO writer. Choose
any one chapter. Use the proper level of headings in the document.
Add a blank page on top of the page. Now create a table of contents for
the document as shown below.
Procedure:
Step 1 -When you create your document, use the following
paragraph styles for different heading levels (such as chapter
and section headings): Heading 1, Heading 2, and Heading 3
These are what will appear in your table of contents. You can
use more levels of headings, but the default setting is to use
only the first three levels in the table of contents.
Step 2 -Place the cursor where you want the table of contents
to be inserted.
Step 3-Select Insert>Index and Tables

1
Step 4 -Change nothing in the Insert Index/Table dialog. Click
OK.

*TABLE OF CONTENTS IS CREATED.*

1
Unit-2 Electronic Spreadsheet (Using LibreOffice Calc)
Assignment 1
Objective: Using Consolidating Data in LibreOffice Calc.
Task: Take an example of two branches of a shop namely ABC and XYZ. We
have the Sales records for the month of January and February of both the
branches in two different sheets named ABC _ Branch and XYZ_ Branch. Now
we have to consolidate these two sheets to get the sum of both the sheets
monthly to get the insight about the sale as per product and branch. (Page
No.88Practical Activity from Text Book)
Sample Data Is given below:
Item January February Item January February
Chocolate 15000 10000 Chocolate 10000 5000
Cookies 16000 20000 Cookies 20000 6000
Pastries 10000 15000 Pastries 30000 7000

Data for Data for

ABC _ XYZ _
branch Branch

Procedure:
Step1 -Add a new sheet and rename it as Consolidate.
Step 2 -Click on Data > Consolidate or use the key board short
cut key Alt+D, the Consolidate dialog windows will open.

1
Step 3 - In the Function box, choose Sum function from the
drop down as we all the sheets. 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 ares 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.
Step 7 - Click on 'Copy to results to and then click on any of
the cell in the Consolidate sheet where you want to copy
the final result after Consolidation.

1
Step 8 -Click on OR' button. It will display the Consolidate
sheet with data after Consolidation.

1
Procedure:

Step 1 -Create a sheet as shown to take to the mark for

Students marks for students in a term for a class.

1
Step 2 -Now, to calculate the average mark scored by the
students of each class in each subject, i. e class wise and
subject analysis.
Step 3-To do so, Click on Data>Subtotal, the subtotal dialog
box will open.

Step 4 -Choose the column I..e class under Group by in the 1st
Group on which we need to group the Whole Data. Also, select
the subjects is English, Hindi, Math Science and social science
under calculate subtotals for. For each subject click on the
Average under Use function individually otherwise sum
function will be used by default.
Step5-Click OK and the sheet will book like be shown.

1
1
Assignment3

Objective: Using Scenarios in LibreOffice Calc

Task: Calculate the income tax by entering the salary using different
scenarios for two variables in come tax and slab and tax rate. The sheet
should look as shown in the below figure: (Page No.95 Practical
Activity from Text Book)

Procedure:
Scenarios - A scenario is a set of cell values that can be save
and used for calculations in an electronic spreadsheet.
Scenarios can be used to consider different variables and
view the results.
Steps to create a Scenario:
Step1 -Select cells which contains values in sheet that needs
to be changed. To select multiple cells, hold Ctrl key and click
on the cell to be selected.
Step 2-Choose Tools>Scenarios will open scenario dialog
window.
Step 3-Enter a name for the new scenario1 and leave other
fields unchanged.
Step 4-Click on OK button.
Step 5 -This will create a new scenario which is activated
automatically.

1
Steps to Create According to the Question:
Step 1 - Open the Document
Step2 -Enter the Data.

Step 3 - Select cells which contains values in sheet that needs

to be changed. To select multiple cells, hold Ctrl key and click
on the cell to be selected.(Incomes lab and Tax rate)
Step 4 -Choose Tools>Scenarios will open scenario dialog
window.

2
Step 5 -Enter a name for the new scenario and leave other
fields unchanged. Click on OK button. This will create a
new scenario which is activated automatically.

Step 6 -Again enter the data And repeat the same process
from step3 to step6 for3times..(Change the incomes lab and
tax rate according to the question)
Step 7 -We have Calculated the income tax by entering the
salary using different scenarios for two variables income tax
and slab and tax rate.

2
Procedure:
Step1-Create the sheet.

Step 2-In Cell B5 enter the formula =B4*(B1-B2)-B3.

Step 3-Select the Cell Range from D2:E11.

Step4-Click on Data> Multiple Operations will display the

Multiple operations dialog window.

2
Step 5 -We have to formula in cell 85, as we want to use the
same cell address to be copied together therefore, we have
use absolute cell referencing and weld written as it as $B$5.

Step 6 - In this example we have another variable as number

of items sold which is in the cell $854.

Step 7-Click on OK will generate a sheet.

2
Procedure:

Step 1- Create the mark sheet. Enter the average function in cell
B7as =Average(B2:B6)

2
Step 2 -Click on Tools > Good Seek will display the Goal Seek dialog
windows.

Step3 - Write the Cell address of the formula, i. e B7 in the Formula

Cell box.

Step 4 -Write the cell address of the cell which is to be generated by

the system in the Variable Cell Box. In this example, it is cell B6
which we want to be filled as per the average marks needed.
2
Step 5 -Enter the result in the Target value box. As per the question,
we have to get minimum 70 aggregate sown will write 70 in the target
value.

Step 6 - Clicking on OK will display an error as LibreOffice Calk will

not accept the variable cell to be empty. So, this error add dialog
box window will prompt to value in the variable cell.

Step 7-Click on Yes and then repeat the step 2 will display the dialog
windows, and prompts whether to change the cell with the calculated
value.
Step 8 - Click on Yes will change the value withe the calculated one in
the sheet.

2
UNIT-3 Database Management System Using LibreOffice Base
Steps to Create a Table

Step 1-Open the Document.

Step 2-Create the Library table.
Step3-Add Fields(Given according to the questions)

*Table is created *

2
Creating a Form to enter data into the table.
Step1-Click on the forms button under database menu and select
create using wizard option.

Step2-Form wizard appears.

2
Step3-Select the options from the wizard according to how
you want to make the document. Click finish.
Step4-Form is created Open it. It looks like this.
Step5-Fill the information in the form.

2
Procedure:
1) Tables:
Create table using steps given before unit 3
assignment number 1.
2) Forms :
Step 1 -Click on the forms button under database menu and
select create using wizard option. Form wizard appears.
Step2-Select the options from the wizard according to how
you want to make the document. Click finish.
Step3-Form is created Open it. It looks like this. Fill the
information in the form.
(Same Steps as of assignment1 of unit3.)

3
Steps to display Queries:
Step 1 -Click on the queries button under database menu
and select create using wizard option.

Step 2- Query wizard appears.

Step3-Select the options from the wizard according to how

you want to make the document. Click finish.
Step4- Query is created Open it. It looks like this.
3
3
Steps to Create a Report:
Step 1 - Click on the Reports button under database menu
and select create using wizard option. Report wizard appears.

Step2-Select the options from the wizard according to how

you want to make the document. Click finish.
Step3-Report is created Open it.

3
Procedure:
1) Tables :
Create table using steps given before unit3
assignment number.

2) Forms :
Step1-Click on the forms button under database menu and select
create using wizard option. Form wizard appears.
Step 2 -Select the options from the wizard according to how
you want to make the document. Click finish.

3
Step 3 -Form is created Open it . It looks like this. Fill the
information in the form.(Same Steps as of assignment1of
unit3)

Steps to Create a Report:

Step 1 - Click on the Reports button under database menu
and select create using wizard option. Report wizard appears.
Step2-Select the options from the wizard according to how
you want to make the document. Click finish.
Step3-Report is created Open it .

3
Procedure:
1) Tables:
Create table using steps given before unit3
assignment number1.
2) Forms :
Step1-Click on the forms button under database menu and select
create using wizard option. Form wizard appears.
3
Step 2 -Select the options from the wizard according to how
you want to make the document. Click finish.
Step3-Form is created Open it. It looks like this. Fill the
information in the form.

3
Steps to display Queries:
Step 1 -Click on the queries button under database menu
and select create using wizard option.
Step2- Query wizard appears.
Step3-Select the options from the wizard according to how
you want to make the document. Click finish.
Step4-Query is created Open it. It looks like this.

3
3
Assignment-4

Objective : Inserting Data in a table

Task: Open the database in which the table exists.

Procedure:

Step -1: Open the table in which the data has to be inserted. For example ,
double -click on the employees table and open it. Table data view opens.

Step 2- Start typing a record and press the Tab key to add next record. Add some
records in the table .