IT Project
IT Project
IT Project
NANGIARKULANGARA, ALAPPUZHA
INFORMATION TECHNOLOGY
(Subject Code: 402)
PRACTICAL FILE- 2022-2023
Name : ....................................................
Class : ....................................................
Roll No : .....................................................
BETHANY CENTRAL SCHOOL
SENIOR SECONDARY
NANGIARKULANGARA, ALAPPUZHA
CERTIFICATE
This is certified to be the bonafide work done in Information
Technology by Master/Miss ................................................................
of class X in Bethany Central School, Nangiarkulangara during the
academic year 2022-2023.
Internal Examiner
1. Create a new document (choose File > New > Text Document).
2. Type the words Heading 1 in the new document
3. Click the Styles and Formatting icon located on the Formatting Bar or press the F11 key.
This opens the Styles and Formatting window.
Double-click the Heading 1 entry of Styles and Formatting. This does two things:
Gives the line (actually, its entire paragraph) you typed the Heading 1 style.
Adds Heading 1 to the Apply Style menu.
1. Move the cursor to a new line or create a new line by pressing the Enter key at the end of the
previous line and type some text.
2. Keeping the cursor on the same paragraph, select Heading 1 in the Apply Styles list.
Page | 1
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
The text acquires the properties of the Heading 1 style.
Page | 2
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
2. INSERT AN IMAGE AND PERFORM THE FOLLOWING
IN OPENOFFICE WRITER:
MODIFY THE IMAGE, RESIZE THE IMAGE AND ROTATE
THE IMAGE.
Insert Picture
1. Click in the document where you want the image to appear.
2. Choose Insert > Picture > From File from the menu bar.
3. On the Insert Picture dialog, navigate to the file to be inserted, select it, and click Open.
Page | 3
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
4. Picture inserted.
Resizing a picture
Rotating a picture
1. Open the Drawing toolbar via the Show Draw Functions icon in the Standard toolbar.
2. Select the picture. Then the Rotate icon is active, select it.
3. Rotate the image as desired. Use the red handles at the corners of the picture and move the
mouse in the direction you wish to rotate
Page | 4
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
3.CREATE DRAWING OBJECTS AND PERFORM THE
FOLLOWING IN OPENOFFICE WRITER:
RESIZING AND COLOURING, GROUPING, APPLY ANY
3 GRAPHICAL PROPERTIES
To begin using the drawing tools, display the Drawing toolbar, by clicking View > Toolbars >
Drawing.
1. Click in the document where you want the drawing to be anchored. You can change the anchor
later, if necessary.
2. Select the tool from the Drawing toolbar. The mouse pointer changes to a drawing-functions
pointer .
3. Move the cross-hair pointer to the place in the document where you want the graphic to appear
and then click-and-drag to create the drawing object. Release the mouse button. The selected
drawing function remains active, so you can draw another object of the same type.
4. To cancel the selected drawing function, press the Esc key or click on the Select icon (the arrow)
on the Drawing toolbar.
5. Change the properties (fill color, line type and weight, anchoring, and others) of the drawing
object using either the Drawing Properties Toolbar or the choices and dialog boxes reached by
right-clicking on the drawing object.
Page | 5
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
Set or change properties for drawing objects
To set the properties for a drawing object before you draw it:
Use the Position and Size dialog box to set the width and height independently.
If the Keep ratio option is selected, then the two dimensions change so that the proportion is
maintained, allowing for a scaled resizing.
Page | 6
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
Grouping drawing objects
To group drawing objects:
1. Select one object, then hold down the Shift key and select the others you want to include in the
group. The bounding box expands to include all the selected objects.
2. With the objects selected, hover the mouse pointer over one of the objects and choose Format >
Group > Group from the menu bar or right-click and choose Group > Group from the pop-up
menu.
Page | 7
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
4.CREATE A NEW TEMPLATE IN OPENOFFICE
WRITER
FROM A DOCUMENT AND USING WIZARD
1. Open a new or existing document of the type you want to make into a template (text document,
spreadsheet, drawing, presentation).
2. Add the content and styles that you want.
3. From the main menu, choose File → Templates → Save. The Templates dialog opens.
4. In the New template field, type a name for the new template.
5. In the Categories list, click the category to which you want to assign the template
6. Click OK. saves the new template and the Templates dialog closes.
Page | 8
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
Creating a template using a wizard
We can use wizards to create these types of Writer templates:
Letter
Fax
Agenda
1. From the main menu, choose File → Wizards > type of template required.
2. Follow the instructions on the pages of the wizard.
3. Specify the name and location for saving the template.
4. Create a new document from your template
Page | 9
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
5. CREATE A TABLE AND PERFORM THE FOLLOWING
IN OPENOFFICE WRITER.
MERGE CELLS & ADD IMAGE AND COLOUR TO A
CELL
Creating and Customizing Tables
There are two ways to insert a table in a Writer document:
Page | 10
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
Merging cells
To merge a group of cells:
Page | 11
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
4. Inside the For section, choose to apply the background to the cell, row or table.
o Cell: The background will only apply to the cell selected. If you selected a group of cells, the
background will be applied individually to each cell.
o Row: the background will apply to the entire row where the cursor was placed, or the entire
row of any selected cells.
o Table: The background will apply to the entire tale, regardless of which cells were selected.
Page | 12
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
6. CREATE AND CUSTOMIZE TABLE OF CONTENTS AND
PERFORM THE FOLLOWING IN OPENOFFICE
WRITER.
Page | 13
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
CUSTOMIZING TABLE OF CONTENTS
The Insert Index/Table dialog box has five pages. Each of them covers a different aspect of the TOC
structure and appearance:
Use the Index/Table page to set the attributes of the TOC, most importantly the type of index.
Use the Entries and Styles pages to format the entries in the TOC.
Use the Columns page to put the TOC into more than one column.
Use the Background page to add color or a graphic to the background of the TOC.
Page | 14
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
7. PREPARE A BIRTHDAY INVITATION USING MAIL
MERGE FEATURE OF OPENOFFICE WRITER.
Step 1: Select starting document
The wizard gives various options to select your starting document:
Page | 15
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
Choose document type.
1. Tell the wizard which data source to use. The data source must be an existing file; in this
example it is the "Points" spreadsheet created earlier.
2. Select the address block to use in the document. This means choosing which fields appear and
how they look.
3. Make sure that the fields all match correctly. This is very important. For example, the wizard has
a field called <Last Name>.
Page | 16
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
Selecting the data source (address list)
1. If the current address is not the one you wish to use, click the button to open the Select
Address List dialog for choosing a data source.
2. If you have not already created the address list, you may click Create to do so now.
3. Select the address list and click OK to return to step 3 of the wizard.
4. The wizard can also exclude certain records; click Filter to choose them.
1. In step 3 of the wizard This is where you select the address block to appear on the
letter, and define its appearance and the fields it contains.
2. The Select Address Block dialog box offers six choices for the format of the addresss
block
3. If this is the case, select the address block that is closest to what you want and
click Edit, which opens the New Address Block dialog box.
Page | 17
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
4. In the New Address Block dialog, you can add or delete address elements using the
arrow buttons on the left..
Page | 18
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
Matching the fields
1. The box at the bottom displays one record at a time, using the address block format
you selected. Use the right and left arrow buttons below that address box to step
through the addresses, checking that they display correctly.
2. If the addresses do not display correctly ,click Match Fields. The Match Fields dialog
box opens.
o Address Elements are the terms the wizard uses for each field, such as <First
Name> and <Last Name>.
o The Matches to Field column allows you to select, for each address element, the
field from your data source that matches it.
o The Preview column shows what will be shown for this field from the selected
address block, so you can double-check that the match is correct.
3. Click OK to return to step 3 of the wizard. Click Next
Page | 19
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
Step 4: Create salutation
Page | 20
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
1. Click Edit Document in step 6 of the wizard.
2. Select Insert > Fields > Other. The Fields dialog box opens, as shown below.
Page | 21
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
5. Under Database selection find your data source (in this example, it is a spreadsheet).
Expand it to see the fields.
6. Click the field you want to insert, then click Insert to insert the field. You can insert any
number of fields any number of times into your mail merge document.
Page | 22
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
Step 8: Save, print or send
Select Save starting document to reveal the Save starting document section
containing the Save starting document button.
The merged document can now be saved by selection of Save merged document.
Page | 23
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
8. XYZ BANK HAS ITS DEPOSIT AND WITHDRAWAL
DETAIL OF CUSTOMERS FOR 3 MONTHS. HELP
THEM TO PREPARE A CONSOLIDATED DATA FOR
A YEAR USING OPENOFFICE CALC.
1. Open the document that contains the cell ranges to be consolidated.
2. Choose Data > Consolidate to open the Consolidate dialog. The figure shows this dialog
after making the changes described below.
The Source data range list contains any existing named ranges (created using Data > Define
Range). Click Add. The selected range is added to the Consolidation ranges list.
Select additional ranges and click Add after each selection.
Specify where you want to display the result by selecting a target range from the Copy results
to drop-down list.
Select a function from the Function list
Page | 24
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
9. RPS DISTRIBUTERS DISTRIBUTES PRODUCTS IN
DIFFERENT AREAS.
To insert subtotal values into a sheet:
3. In the Subtotals dialog, in the Group by list, select the column by which the subtotals need to be
grouped. A subtotal will be calculated for each distinct value in this column.
4. In the Calculate subtotals for box, select the columns containing the values that you want to
create subtotals for. If the contents of the selected columns change later, the subtotals are
automatically recalculated.
5. In the Use function box, select the function that you want to use to calculate the subtotals.
6. Click OK.
Page | 25
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
Subtotals created
Page | 26
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
10. PREPARE A SCENARIO TO CALCULATE SIMPLE
INTEREST FOR DIFFERENT PRINCIPAL AMOUNT,
RATE OF INTEREST AND YEAR.
Creating scenarios
Tools > Scenarios opens a dialog with options for creating a scenario. To create a new scenario:
1. Select the cells that contain the values that will change between scenarios. To select multiple
ranges, hold down the Ctrl key as you click. You must select at least two cells.
2. Choose Tools > Scenarios.
3. On the Create Scenario dialog, enter a name for the new scenario.
Page | 27
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
11. CALCULATE SIMPLE INTEREST USING ONE
VARIABLE AND TWO VARIABLES USING MULTIPLE
OPERATIONS IN OPENOFFICE CALC: INTEREST
FOR DIFFERENT AMOUNT. (ONE VARIABLE)
INTEREST FOR DIFFERENT AMOUNT AND YEAR
(TWO VARIABLES)
1. To calculate the profit, first enter any number as the quantity. Enter the formula.
2. In column D enter a variety of alternative annual sales figures.
3. Select the range D2:E11, and thus the values in column D and the empty cells (which will receive
the results of the calculations) alongside in column E.
4. Choose Data > Multiple Operations.
5. With the cursor in the Formulas field of the Multiple operations dialog, click cell B5.
6. Set the cursor in the Column input cell field and click cell B4.
Page | 28
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
Multiple Operations on Multiple variables
Page | 29
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
12. A STUDENT IS PLANNING HER GOALS ABOUT THE
MARKS SHE SHOULD ATTAIN IN THE FORTHCOMING
SEMESTER 4 EXAMINATIONS IN ORDER TO ACHIEVE A
DISTINCTION (75%). ASSUMING THAT EXAMINATION OF
EACH SUBJECT IS FOR 100 MARKS, HER MARKS OF THE
PREVIOUS SEMESTERS ARE GIVEN. (USE GOAL SEEK IN
OPENOFFICE CALC)
Goal Seek
3. Place the cursor in the formula cell, and choose Tools > Goal Seek.
4. On the Goal Seek dialog, the correct cell is already entered in the Formula cell field.
5. Place the cursor in the Variable cell field. In the sheet, click in the cell that contains the
value to be changed.
6. Enter the desired result of the formula in the Target value field.
Page | 30
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
13. USING SOLVER OPTION IN OPENOFFICE CALC,
PROJECT THE SIMPLE INTEREST AMOUNT BY
CHANGING PRINCIPAL AMOUNT AND RATE OF
INTEREST WHILE CALCULATING SIMPLE INTEREST.
Page | 31
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
5. Click in the Target cell field. In the sheet, click in the cell that contains the target value
6. Select Maximum or Minimum if the target cell value needs to be one of those extremes.
7. Click in the By changing cells field and click on cell C2 in the sheet.
8. Enter limiting conditions for the variables by selecting the Cell
reference, Operator and Value fields.
9. Click OK. A dialog appears informing you that the Solving successfully finished. Click Keep
Result to enter the result in the cell with the variable value. The result is shown below.
Page | 32
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
14. CREATE A MACRO TO PREPARE A MARKSHEET OF 10
STUDENTS FOR 5 SUBJECTS
Use Tools > Macros > Record Macro to start recording a macro. A small window is
displayed so you know that OpenOffice.org is recording.
Select the Standard library and click New Module to create a new module to contain the macro.
Page | 33
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
15. (A)CREATE A DATABASE IN OPENOFFICE
(B) CREATE FORM USING WIZARD
(C) CREATE REPORT USING WIZARD
TO CREATE A DATABASE
1. Open the Database Wizard using File > New > Database.
Page | 34
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
TO CREATE A FORM USING WIZARD
1. Click on the Forms tab from the Database Pane
2. Click on the Use Wizard to Create Form the Tasks window. The Form Wizard
dialog box opens up.
.
5. Click on the Next button.
Page | 35
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
6. Choose the form layout or arrangement. Click on Next button.
Page | 36
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
TO CREATE A REPORT USING WIZARD
2. Click on Use Wizard to Create Report in the Tasks window. The Report
Wizard dialog box.
3. Click on the Table or Queries drop down list to select the desired table.
4. The Available Fields list will show the fields of the table. Move all the
fields by clicking on the button to place them in the Selected Fields box
Page | 37
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
.
Page | 38
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23
8. When the next screen appears, make sure Default is selected in
the Layout of data section. Then click the button.
Page | 39
Bethany Central School, Nangiarkulangara Practical File- Class X Information Technology (402)-2022-23