INFORMATION TECHNOLOGY
(402)
PRACTICAL FILE
2024-2025
Class & Section: __________
Roll number: _____________
Teacher Name: _________________
Teacher Sign: __________________
S.NO DATE TOPIC TEACHERS’ SIGN
1 Explain the styles given in the Styles and
Formatting Window for writer and paste the screen
shot of the window also
2 Write the steps to create new style in Open Office
Writer.
3 Write steps to create template
4. Write steps to do mail merge
5 Write the steps to consolidate data of two sheets in
Open Office Calc .
6 Write the steps to subtotal in Open Office Calc .
7 Write the steps to goal seek in Open Office Calc .
8 Write the steps to scenario in Open Office Calc .
9 Write the steps to record Macro in open office calc.
10 Write the steps to create table with minimum five
fields on an entity
"STUDENT" in design view
11 Write the command for the following table
Student
12 Write a query to create table and work with insertion,
deletion, and updating commands
13 Illustrate the use of various options under computer
Accessibility in Keyboard, Mouse,
Display tab
14 Write the steps to create instant messaging account for
Google Talk
Ex:no:1 USING STYLES
AIM:To . Explain the styles given in the Styles and Formatting Window for writer and paste the screen
shot of the window also.
PROCEDURE:
STEP1:Open the Libre Office Writer
STEP2: Use STYLES menu (OR) PRESS F11
1. Page styles
2. Paragraph styles
3. Character styles
4. Frame styles
5. Numbering styles
6. Cell styles
7. Graphics styles
8. Presentation Styles
Page styles: Include margins, headers and footers, borders and backgrounds. In Calc, page styles also
include the sequence for printing sheets.
Paragraph styles: control all aspects of a paragraph’s appearance, such as text alignment, tab stops, line
spacing, and borders, and can include character formatting.
Character styles: affect selected text within a paragraph, such as the font and size of text, or bold and
italic formats.
Frame styles: are used to format graphic and text frames, including wrapping type, borders, backgrounds,
and columns.
Numbering styles: apply similar alignment, numbering or bullet characters, and fonts to numbered or
bulleted lists.
OUTPUT:
RESULT:
Thus the styles and the styles and formatting window was explained with screen shot
EX:NO-2: CREATING A NEW STYLE
AIM: To create a style in Libre office writer
PROCEDURE:
STEP-1: Open the Styles and Formatting window and choose the type of style you want to create.
STEP-2: In the document, select the item you want to save as a style.
STEP-3: In the Styles and Formatting window, click on the New Style from Selection icon
STEP-4: After Clicking on New Style from Selection, create style dialog box appear.
STEP-5: Write the name for the new style and click on OK
OUTPUT:
RESULT: Thus the new style has been created in libre office writer and output was verified successfully.
EX:NO-3: CREATING A TEMPLATE
AIM: To create a template in open office writer
PROCEDURE:
STEP-1: open a new or existing document of the type you want to make into a template (text
document, spread sheet, drawing, presentation); STEP-2:Add the content and the styles that you
want.
STEP-3: From the main menu, choose. file->template->save
STEP-4:To make a template as a default choose”file->template->organize->set as default”
OUTPUT:
RESULT:
Thus the template was created in libre office writer and output was verified successfully.
EX.NO-4 : TO DO MAIL MERGE
AIM: To create letter and send to many recipient with the help of mail merge.
PROCEDURE:
STEP-1: open a new or existing document of the type you want to send to recipient. (presentation);
STEP-2:Add the content and the styles that you want.
STEP-3: From the main menu, choose. Tools->mail merge wizard
STEP-4:There were 8 steps to complete the mail merge
STEP-5:Select the starting document
STEP-6:Select the document type
STEP-7:Insert the address block
STEP-8:Adjust layout
STEP-9:Edit the document.
STEP-10: Personalize the document.
STEP-11: Save, print or send
OUTPUT:
RESULT: Thus the letter was typed and it was send to many people with the help of mail merge and the
output was verified successfully.
EX.NO-5: INSERT AND USE IMAGES IN DIGITAL DOCUMENT
AIM : To insert images and shapes and rearranging them in Libre Office Writer.
PROCEDURE:
1. Open LO Writer and Type the paragraph.
2. Click on Insert Picture From File.
3. Select the picture to insert.
4. Resize the picture according to the need.
5. Go to the picture properties and select Wrap Parallel option.
6. Insert shape and insert the desired text.
7. Right Click on the shape and choose Wrap Optimal Page Wrap option.
OUTPUT:
RESULT:
Thus the images and text were arranged in Writer and output was verified
successfully.
EX.NO-6: CREATE AND CUSTOMISE TABLE OF CONTENTS
AIM: To Prepare a document with different headings and apply a table of contents to it.
PROCEDURE:
1. Type the contents.
2. Apply appropriate level of headings from the Styles and Formatting window.
3. Click on Insert Indexes and Tables Indexes and Tables.
4. Select and apply the styles for the Table of Contents.
5. Click on OK.
OUTPUT:
RESULT:
Thus the Table of Content was created successfully
EX.NO-7: CONSOLIDATING DATA
AIM: To consolidate the data of two sheets in lLibre Office Calc.
PROCEDURE:
STEP-1: Open a new file in Libre Office Calc and write the following data :
STEP-2:Open another file in Libre Office Calc and write the following Data
STEP-3:Open the third sheet and click on Data → Consolidate. The Consolidate dialog box appear
STEP-4: Click to select Source data range of first sheet and then click on Add button.
STEP-5:After adding Source data range from both the sheets, click ok.
RESULT: Thus the consolidating of data was done and output was verified successfully.
EX.NO-8: CALCULATE SUBTOTAL
AIM: To do subtotal in Libre Office Calc .
PROCEDURE:
STEP-1: Open a new file in Libre Office Calc
STEP-2: Write the following data
STEP-3: Click on Data → subtotal.
STEP-4: Select Columns in the Group By options and also the required functions.
STEP-5: Click ok
RESULT: Thus the SUBTOTAL of data was done and output was verified successfully.
EX.NO-9: USING GOAL SEEK
AIM: To do goal seek in Libre Office Calc .
PROCEDURE:
STEP-1: Open a new file in Libre Office Calc
STEP-2: Write the following data and select the formula cell.
STEP-3: Click on Tool → Goal seek. Goal Seek dialog box will be opened.
STEP-4: Select the Formula cell and give target value in the Target value text box.
STEP-5: Type Variable cell address and click ok.
AFTER GOAL SEEK
RESULT: Thus the GOAL SEEK of data was done and output was verified successfully.
EX.NO-10: Write the steps to do Scenario in Libre Office Calc .
AIM: To do Scenario in Libre Office Calc .
PROCEDURE:
STEP-1: Open a new file in Libre Office Calc
STEP-2: Write the following data and select the cell.
STEP-3: click on Tool → Scenario.
STEP-4: Name your Scenario and select different color.
STEP-5: Click ok
STEP-6: Similarly create two more scenarios and name them.
SCENARIO-1 SCENARIO-2
RESULT: Thus the SCENARIO of data was done and output was verified successfully.
EX.NO-11: RECORD MACRO
AIM: To Write the steps to record Macro in Libre office calc.
PROCEDURE:
STEP-1:Open a new file in calc.
STEP-2: Enter the following data.
STEP-3 : Select cell A3, which contains the number 3, and copy the value to the clipboard.
STEP-4: Select the range A1:C3. 5. Use Tools > Macros > Record Macro to start the macro recorder.
STEP-5: The Record Macro dialog is displayed with a stop recording button.
STEP-6: Use Edit > Paste Special to open the Paste Special dialog.
STEP-7: Set the operation to Multiply and click OK. The cells are now multiplied by 3.
STEP-8: Click Stop Recording to stop the macro recorder. The Macros dialog opens and save the
macro at specified place with a particular name.
STEP-9: Now macro is ready to use.
RESULT: Thus the Macro was recorded and output was verified successfully.
EX.NO-12: CREATING TABLE
AIM: To Write the steps to create table with minimum five fields on an entity "STUDENT" in design
view
PROCEDURE:
STEP-1: Click on Create Table in Design View… option available under Tasks
STEP-2: Specify the field name and data type of the field to be created
STEP-3: 3. In the gray box at the left of the line, right-click and select Primary Key, bringing up a key
icon in the box
STEP-4: Save the table (File > Save)
RESULT:Thus the table was the created in the design view and the output was verified successfully
EX.NO-13: WRITING COMMANDS
AIM: To write the command for the following table “student”
COMMANDS:
1. Select * from student;
2. Insert into student values(5, 'XI' , 'Suman' , 6953245)
3. Select * from student where Rollno = 3;
4. Select * from student where class = 'X'
5. Select * from student where name = 'Anuj';
RESULT: Thus the command has been written and the output was verified successfully.
EX.NO-14: USING COMMANDS
AIM: To write a query to create table and work with insertion, deletion, and updating commands
COMMANDS:
CREATE:
create table “stinfo”(“roll no” tiny int primary key,”name” varchar(100));
INSERT:
insert into “stinfo”(“roll no”,”name”)values(‘1’,’reka’); insert into
“stinfo”(“roll no”,”name”)values(‘2’,’reshu’);
DELETE:
delete from “stinfo” where “roll no”=’1’;
UPADTE:
update “stinfo” set “roll no”=’3’ where “name”=’reshu’;
OUTPUT:
Roll no Name
1 Reka
3 reshu
RESULT:
thus the table was created and worked with insert, delete and update commands.
