Class X
IT PRACTICAL
Prepared by Ms. Catherine,TGT CS
S.NO DATE TOPIC PAGE NO: TEACHERS SIGNATURE
Unit 1 Digital Documentation
1 Create and update a new style from a
selection.
2 Insert and Crop an Image
3 Load styles from template and another
document
Create Template and Set a Template
4. as Default Template
5 Table Of Contents
Unit 2: Electronic Spreadsheet
6 Data Consolidation
7 Subtotal
8 Scenario
9 Goal Seek
10 Macro
Unit 3: Electronic Spreadsheet(Advanced)
11 Table creation using wizard
12 Create table using design view
13 Operations of Tables
14 Create query using wizard
15 Create Form using Form Wizard
Prepared by Ms. Catherine,TGT CS
TYPE OF STYLES AND CREATE A NEW STYLE FROM SELECTION
Ex No.1:
DATE:
AIM: To Explain the types of styles and create new styles from selection.
.
PROCEDURE:
STEP 1: open the Libre office writer
STEP 2: GO to VIEW -> STYLES (OR) Styles ------> MANAGE STYLES OR PRESS F11
1. Page style
2. Paragraph style
3. Character style
4. Frame style
5. List style
6. Table style
Page style: used for storing formatting information for a page , such as its layout ,
size , margins, placement of header & footer , borders , background ,etc.
Paragraph style: It contain formatting information for the entire paragraph such as
text body, heading , header & footer , caption , etc. It is also used for compiling a table
of content.
Character style: Used for formatting a block text inside a paragraph such as
text colour , text size , highlight , emphasize , etc.
Frame style: Frame style allows to format frames and images, by specifying its
size , position , border , placement of text and pictures,etc.
List style: Used to store formatting information for numbered or bulleted
list(s), such as indentation , numbering style , punctuation after number , etc.
Table Style : Used to store formatting information for table of data , such as
aligning text inside table , text or border colour , etc.
STEP 3: Select one of the icons at the top left of the Styles deck to display a list of styles in
that category.
STEP 4: To apply an existing style, position the cursor in the paragraph, frame, page, word,
or cell, and then double-click the name of the style in one of these lists. To apply a character
style to more than one word, select the characters first.
RESULT:
Thus the styles and the styles and formatting window was explained, the new style has been
created in open office writer and output verified successfully.
Prepared by Ms. Catherine,TGT CS
INSERT AND ROTATE AN IMAGE
Ex No.2:
DATE:
AIM: To insert and rotate an image using Libre office writer
PROCEDURE:
INSERT PICTURE
STEP 1: Click in the LibreOffice document where you want the image to appear
STEP 2: Choose Insert ------> Image on the Menu bar or click the Insert Image icon on
the Standard toolbar.
STEP 3: On the Insert Image dialog, navigate to the file to be inserted, and select it and
click Open.
ROTATE AN IMAGE
STEP 1: Select the image to be rotated.
STEP 2: Click Rotate tool on image toolbar, the shape of selection handle changes to
circle of pink color.
STEP 3: Move mouse over one of the pink handles at corner of the image. Mouse turns
to round two headed arrow.
STEP 4: Now left click and move mouse up or
down to rotate image.
STEP 5: Release left click once image is rotated.
RESULT: Thus, the images inserted and rotated using Libre office writer and output
was verified successfully.
Prepared by Ms. Catherine,TGT CS
LOAD STYLES FROM TEMPLATE AND ANOTHER DOCUMENT
Ex No.3:
DATE:
AIM:
To load styles from template and another document in libre office writer
PROCEDURE:
(i) LOAD STYLES FROM TEMPLATE
STEP 1: Open the document to be formatted by copying styles.
STEP 2 : Goto styles deck on sidebar and click on styles action
STEP 3: Click on load styles from Templates to open a dialogue box – load styles from
template
STEP 4: Choose the category and then select the template
STEP 5: Select the options for the type of styles to be copied – paragraph and Character
, frame , pages ,List.
STEP 6: Click ok to copy the style
(ii) LOAD STYLES FROM ANOTHER DOCUMENT
STEP 1: Open the document to format by copying styles.
STEP 2 : Goto styles deck on sidebar and click on styles action icon
STEP 3: Click on load styles from Templates to open a dialogue box – Load styles from
template
STEP 4: Click on the From file button at the bottom of the dialogue box
STEP 5: This will open a file browser to select the file.
STEP 6: Select the options for the type of styles to be copied – paragraph & Character,
frame , pages ,List.
STEP 7: Click ok to copy the style
RESULT: Thus, the styles was loaded from template and another document using Libre
office writer and output was verified successfully
Prepared by Ms. Catherine,TGT CS
CREATING A TEMPLATE FROM DOCUMENT AND SET A TEMPLATE AS
DEFAULT TEMPLATE
Ex No.4:
DATE:
AIM:
To create a template and set as default template in Libre office writer
PROCEDURE:
(i) CREATING A TEMPLATE FROM DOCUMENT
STEP 1: open the text document, set its layout , style , etc as required in template.
STEP 2: Go to File -> Templates -> save as Template on Menu bar , to open
window for saving templates..
STEP 3: Choose the Category , for the template , in “select template category”
STEP 4: click on save
(ii) SET A TEMPLATE AS DEFAULT TEMPLATE
STEP 1: open templates dialogue box
STEP 2: Open the category, containing the template that is to be set default and select
the category
STEP 3: Right click on the selected template to open context menu.
STEP 4: Select set as default from the menu. An icon marks the template as default.
RESULT:
Thus the template was created and set as default template in libre office writer and output
was verified successfully.
Prepared by Ms. Catherine,TGT CS
TABLE OF CONTENTS
Ex No.5:
DATE:
AIM:
To create table of contents using open office writer
PROCEDURE:
STEP 1: Create a document, use the following paragraph styles for different heading levels
(such as chapter and section headings): Heading 1, Heading 2, and Heading 3
STEP 2: Place the cursor where we want the table of contents to be inserted.
STEP 3: Select Insert ------> Indexes and Tables----- > Indexes and Tables.
STEP 4: Change nothing in the Insert Index/Table dialog. Click OK.
RESULT:
Thus the Table of content was created in open office writer and output was verified
successfully
Prepared by Ms. Catherine,TGT CS
DATA CONSOLIDATION
Ex No.6:
DATE:
AIM: To consolidate the 3 months deposit withdrawal data using Open Office Calc.
PROCEDURE:
STEP 1: Enter details of deposit and withdrawal of each customer.
STEP 2: Choose the Consolidate option under the Data Menu.
STEP 3: The consolidated dialog box appears. Select the source range and click on add.
STEP 4: Click More in the consolidate dialog to display additionally settings. Select link to
source data to insert the formulas. This generates the results in the target range instead of the
actual results.
STEP 5: Click Ok to consolidate the ranges.
RESULT: Thus, the data consolidation was done and output verified successfully.
Prepared by Ms. Catherine,TGT CS
SUBTOTAL
Ex No.7
DATE:
AIM: To Calculate the seller wise distribution of products using SUBTOTAL option in Open
Office Calc.
PROCEDURE:
STEP 1: Enter the required data in the Spreadsheet.
STEP 2: Select the range of cells that you want to calculate subtotals for, and then choose
Data----->Subtotals.
STEP 3: Subtotal dialog box, in the Group by box select the column Seller and select Qty
with Sum as function.
STEP 4: Click on OK.
RESULT:
Thus, the SUBTOTAL of data was done and output was verified successfully.
Prepared by Ms. Catherine,TGT CS
SCENARIO
Ex No.8
DATE:
AIM:
To prepare a SCENARIO to calculate Profit and Profit % for different Selling and Cost
Price using Open Office Calc .
PROCEDURE:
STEP 1: Enter the values of SP and CP and calculate the Profit and Profit %.
STEP 2: Select the cells that contain the values that will change between Scenarios.
STEP 3: Choose Tools>Scenarios.
STEP 4: Click OK to close the dialog. The new scenario is automatically activated.
STEP 5: We can create several scenarios for any given range of the cells.
RESULT:
Thus, the SCENARIO created and output was verified successfully.
Prepared by Ms. Catherine,TGT CS
GOAL SEEK
Ex No.9
DATE:
AIM:
To find the value of Price, if the value of Profit is known, using GOAL SEEK operation.
PROCEDURE:
STEP 1: Enter the values of Selling price and Cost price and calculate the value of profit
by applying the formula
STEP 2: Place the cursor in the formula cell and choose Tools>Goal Seek.
STEP 3: Dialog box appears, cell is already entered.
STEP 4: Set the target value,ex. Profit will be 200..
STEP 5: Place the cursor in the variable cell field, and then select the cell of SP.,
STEP 6: Click ok.
STEP 7: Goal seek successful, insert value in to the current cell message will come
STEP 8: Click yes.
RESULT:
Thus the GOAL SEEK of data was done and output was verified successfully.
Prepared by Ms. Catherine,TGT CS
MACROS
Ex No 10.
DATE:
AIM :
To create a Marksheet using MACROS in OpenOffice Calc.
PROCEDURE:
STEP 1: Open a new Spreadsheet.
STEP 2: Prepare sample data of 3 students for marksheet
STEP 3: Use Tools----->Macros----->Record Macros to start the macro recorder.
The recorder Macro dialog box is displayed with a stop recording button.
STEP 4: Apply all the formatting options and calculate total and percentage of a student in
Sheet 1
STEP 5: Save the Macro in My Macros Standard Library. Click on Save button.
STEP 6: To run the Macro, Click on Run Macro. Macro Selector dialog box appears. Select
the Macro which you want to run from the Standard Library.
STEP 7:The Macro executed successfully. Same formatting and Functions applied on that
particular sheet as well on which we run our Macro.
RESULT:
Thus the MACROS was recorded and output was verified successfully.
Prepared by Ms. Catherine,TGT CS
TABLE CREATION USING WIZARD
Ex No.11:
DATE:
AIM: To Create the sample table in any category using wizard
PROCEDURE:
STEP 1: Click on tables icon under the database section and click on use wizard to create
Table
STEP 2: Select fields. On the left hand side click on sample tables dropdown menu and
select category
STEP 3: Once required fields are selected, set types and formats and primary key
STEP 4: Upon completion, provide the table name and select Insert data immediately.
Click on Finish button
RESULT:
Thus, table is being created using table wizard and output was verified successfully
Prepared by Ms. Catherine,TGT CS
CREATE TABLE USING DESIGN VIEW
Ex No.12:
DATE:
AIM: To Create table using design view
PROCEDURE:
STEP 1: Click on Create table in Design View and define name of fields , their types and
description
STEP 2: Click on Field type for each field name and then provide field properties.
STEP 3: Once you have filled the details for the table .Click on File menu , then click on
Save AS option to provide table name.
STEP 4:Click on File and click on SAVE option
RESULT:
Thus, table is being created using design view and output was verified successfully
Prepared by Ms. Catherine,TGT CS
OPERATIONS OF TABLES
Ex No.13:
DATE:
AIM:
To demonstrate the following: Insert data in the table, Edit records in the table, Delete
records from table, and Sort data in the table.
PROCEDURE:
EDIT RECORDS:
STEP 1: Once table is created, select the record to be edited and click on EDIT data
button on the cell you want to edit.
STEP 2 : Click on Save the record
DELETING RECORDS FROM A TABLE:
STEP 1: Select the data you want to delete by double clicking on the cell.
STEP 2: Then right click on it. Select delete option
SORT DATA:
STEP 1: Select the column and click on any one of sorting buttons
RESULT:
Thus, the operations on tables were executed using Libre office base and output was
verified successfully
Prepared by Ms. Catherine,TGT CS
CREATE QUERY USING WIZARD
Ex No.14:
DATE:
AIM: To demonstrate create query using wizard
PROCEDURE:
STEP 1: Click on Queries under Database section and then click on use wizard to create
Query…
STEP 2: Under the tables, select the required table and chose the field and move the fields to
fields in the Query.
STEP 3: The next step Sorting order and click Next button
STEP 4: Provide the necessary condition and click FINSH button
RESULT:
Thus, the query was created using wizard in Libre office base and output was verified
successfully
Prepared by Ms. Catherine,TGT CS
CREATE FORM USING FORM WIZARD
Ex No.15:
DATE:
AIM: To illustrate the various steps to create Form using Form Wizard
PROCEDURE:
STEP 1: Click on forms option under database section. Click on Use Wizard to create form
STEP 2: Select categories table and click on >> to over all the fields under filed in the form.
Click on Next
STEP 3: Select main form and subform from ARRANGE Controls and click on next.
STEP 4: Set Data entry and exercise the option.
STEP 5: Apply styles and click on Finish
RESULT:
Thus, the form was created using form wizard in Libre office base and output was verified
successfully
Prepared by Ms. Catherine,TGT CS
