RELIANCE FOUNDATION SCHOOL

LODHIVALI (ENGLISH MEDIUM)

MADE BY – GAMAN K GOWDA

CLASS – IX A

ROLL NO. – 15

TOPIC
UNIT 1: Digital Documentation
UNIT 2: ELECTRONIC SPREADSHEET
UNIT 3: DIGITAL PRESENTATION
Practical 1
Getting Started with Open Office Writer
1. Title bar: shows the name of the document and the name of the
program.
2. Menu bar: has various menu options that will do all work in the writer.
3. Standard toolbar: has various shortcut icons that are recently used.
4. Formatting toolbar: has various shortcut icons for formatting the text.
5. Horizontal and vertical ruler: it makes easier to adjust your
document with precision.
6. Horizontal and vertical scroll bar: enables you to quickly move up
and down left and right in the document.
7.Status bar: contains information about your
document like, current page number.
8. Document or work area: blank area where
you type information into the document.
9.Side bar: frequently used tools grouped in
decks.
Start Openoffice writer, Change document views, Start a
new document, Open an existing document, Save a
document, Close a document

1. Click on the Start menu OpenOffice

OpenOffice Writer.
2. Click the FileNew option. New option sub menu appears
as follows.
3. From the sub menu click at Text Document
option or press ctrl+N.
4.A new document window is displayed.Type the following text in
the work area.

5.Click the File option from menu bar. A submenu appears.

6.Click the Save As option from the sub menu.
7. Type the name of the file in file name box as shown below.

8. Click the Save option to complete the process.

9. Click on the FileOpen to open already created document
 10. Select the location, name of file from the window appears.And
click on Open button.

11. Click on FileExit to close the document.

PRACTICAL 2
Apply Editing features
(a) Undo and Redo
• Open the existing file.(for example, abc.odt) and then start editing
in it.
• If, by mistake, you have made some changes and now you want
to earse the last chance done, then use the Undo option or
CTRL+Z.
• After Undo command, again if you want to repeat the last action
then use Redo option or CTRL+Y.
(b) Moving and copying text
Cut and paste: it is used to move a selected text from one place to another.
• Select the text and click on EditCut option or press CTRL+X.

• Place the cursor where the text has to be moved. Click on
EditPaste option or press CTRL+V.
(c) Copy and Paste
It is used to make a duplicate copy of selected text.
Step 1: select the text and click on Editcopy option or press CTRL+C.
Step 2: place the cursor where the text has to be duplicated. Click on EditPaste
option or press CTRL+V.
(d) Selecting text
The selected text will be Highlighted. For editing the text you must first
select the required text. The editing can be done on the selected text. It
can be done by CTRL+A to select whole document.
You can double click on a word to select the particular word or line.
(e) Selecting non-consecutive text items
The above process shows the selection of continuous text. But suppose if
the text is not continous and you been asked to select a part of the test
from a paragraph. Then select a word to select then press and hold CTRL
and then select the text you want to select.
(h) Find and Replace
1. Select EditFind & Replace or press CTRL+F, the
dialog box will open.
2. Type the text to find in the Find box.

3. To change the text with different text, enter the new text in the
Replace box.
(i) Non printing characters
Click on Viewnon printing characters. Or it can be done by pressing F10.

(j) Spelling and Grammar errror

1: Select the paragraph in which you want to check the spelling and
Grammar error.
2: Click on Tools Spelling & Grammar or press F7.
 3: Red zigzag line appear on spelling error and blue zigzag line on grammatical
mistakes.
(h) Synonyms and Thesaurus
1: Select the word or phrase you want to find alternatives for and select
Tools Language  Thesaurus or press CTRL+F7.

2: Click on a meaning to show alternative words and phrases for that

meaning of the word.

Practical 3

Apply Formatting features

(a) Apply various text formatting options for the text.

1. Select the text for which you want to change the font style,
font color, size, etc.
2. Select the Formatcharacter option from the menu bar.
Character window will appears as follows:

3. Click on the font then select the font, typeface and size that
you want in the text.
4. Now click on the font effects option.
5. Select the font color, effects, relief, overlining, strikethrough and
underlining that you want.

6. Click on the position option.

7. Select position, rotation and spacing how much you want.

8. Now select the background option.

9. Select the background colour of the text that you want .

10. Click on the OK button. And the formatting is done on the text.

(b) Demonstrate to format paragraphs – indent/align paragraphs, assign

font colour, highlighting, and background colour
1. Select the paragraph for which you want to change the
indentation, spacing, background color, borders etc.
2. Select the FormatParagraph option from the menu
bar. paragraph window will appears as follows:
3. Select the indentation, spacing, and line spacing that you want
for the paragraph.
4. Now select the alignment option and select the alignment that
you want.

5. Select the borders option and apply the color, border that you want.
6. Now select the background option and select the color that you
want in the paragraph.

7. Click on the ok button and the changes will appied in the paragraph.
8. Select the paragrapgh and text highlighter color from the formatting toolbar that
you want.
(c) Assign number or bullets to the lists items

1. Select the FormatBullets and Numbering option from the

menu bar. Bullets and numbering window will appears as follows:

2. Select the bullets or numbering type or outline or graphics option from the
window and select the bullets or numbering type that you want.

3. Now select the position and options from the window and selct the options from
the window.
4. Now click on the OK button and numbering is done.
(d)-Demonstrate the page formatting – set up basic page layout using styles
-Insert page break, Create header/footer and page numbers
-Define borders and backgrounds
-Divide page into columns
1. Select the FormatPage option from the menu bar. page window will appears as
follows:
2. Select the page option or background option and apply the changes that you want
in the page.

3. Now select the header or footer option to apply some heading and or something
at the end of the pages.
4. Select the columns option and the page will be divided in the number of columns
that you want.

5. Click on the OK option to apply the changes in the page. (e)Insert images, shapes,

special characters in a document Format the shape or image.

1. Click on the InsertPicturefrom file

2. Select the location from where you want to insert picture, and then select the
picture that you want.

3. Click on the open button and the image will be inserted.

4. Now select the FormatSpecial Character option from the menu bar.
5. Now select the special character that you want and click on the ok button.

6. Now to apply formatting to the image right click on the image and select the
picture option and apply the changes that you want in the image.

7. click View ToolbarsDrawing.

8. Select the shapes from the window that you want and draw in the
work area.
(e) Divide Page into columns.

1. Click on the FormatColumns...

2. Select the number of columns you want to insert in the page.
3. Click on OK button to apply columns.
 Practical 4
Create and work with tables And Use Print Options

(a) Create table

1. Click on TableInsertTable option.

2. Select the number of rows and columns you want and also write the name of the
table that you want.

(b) Insert and delete rows and column in a table

1. Click on the TableInsertrows/columns.
 2. Enter the Number of rows or columns that you want to insert.
3. Select the position to insert rows/columns and click on Ok button.

(c) Delete a table

1. Click on the TableDeleterows/columns.

2. Select the number of rows and columns that you want to delete.

3. It will delete the rows and columns that you want.

4. If you want to delete the complete table then click on TableDeleteTable.

5. The complete table will be deleted.

6. You can apply formatting to the table by clicking on the TableTable properties.

7. From here you can change the color border and other things in the table.

(d) Split and merge tables

1. Select the rows or column in which you want spliting.

2. Click on ViewToolbarsTable
3. Select the split cells option awindow will appear select the no. of splits you want.
And click on OK.

4.You can merge the same way you do spliting for merging click on Merge option in
Table window.

5. Select the rows or columns that you want to merge or combine.

(e) Copy or move from one location to another location of document

1. Select the complete table and select Copy or Cut option from File menu or by
mouse right click option select cut or copy.

2. Select the location where you want to copy and from file menu select Paste
option.

(f) Print a document

1. Click on the FilePage preview option to check how the page looks after printing.
2. Click on the Fileprint option.
3. Select the printer from the printer option.

4. Specify the number of copies and the range i.e how many pages you want to print.
5. Click print in reverse oredr if you want to print from last to first page.

6.Click on the start printing option.

7. The same way you can print the brochure by selecting print brochure option from
the menu.
Practical 5

Understand and apply mail merge

1. Type a letter. Click on Tools – Mail Merge wizard. A mail merge
dialog box appears.

2. Select the Use the current document option.

3. Select Letter option. And click on Next.

4. For inserting address list just click on the select different address list option,
select the address list you have prepared, click on Next.
5. click on Create option to add the address.

6. Create salutation click on desire salutation click on the next tab.

7. If you want to adjust your content you adjust you increase the left and
the top bar. Click on next button.
8. Edit document, Click the edit document option to edit you can apply to your
document, if necessary.

9. Click on next button.

10. Click on Edit individual document. If you want to edit or click on Next
button.
11. Click on Then, at last, you will get the final step to save, print or send the
merged document.

12. Click on save merged document. Then click on Save as individual

documents.
13. Click on the Finish option.
 Unit 2: Electronic Spreadsheet

Practical 6
Getting started with OpenOffice Calc

(a) Open a spreadsheet

i. Click on the Start menu.

ii. Choose the Open OfficeOpen Office Calc option as shown in
figure:

(b) Parts of calc

 (c) Identify the rows number, column number, cell address

• The columns are lettered A to Z and then continuing with AA,AB,AC

to AZ and then continuing with AAA, AAB,AAC and so on (total
columns are 1024).
• The rows are numbered 1 to 65,536.
• The intersection of row and column is called a cell. And the address
of a cell is cell address.
(d) Creating and Saving a spreadsheet

i. Click on the FileNewSpreadsheet option or press ctrl+N.

ii. A new spreadsheet window is displayed.
iii. Enter text, numbers or functions.
Save the file

i. Click the File option.

ii. Click Save option. Save As diaglog box appears as follows:
iii. Type the name of spreadsheet file in file name box. iv. Click
Save.
v. File will be saved.
(e) Identify row range, column range, row & column range A
range is a group of consecutive cells.
Selecting range using mouse

i. Click on the corner of the cell of the range to be selected e.g. if you
want to select range from B4:F12 then B4,F4,B12 and F12 are
corner cells. You can point to any corner cells.
ii. Now hold the mouse left button and drag the mouse pointer from
one corner range to diagonally opposite corner. i.e. if you had
started from B4 then drag the mouse pointer from B4 to F12 as
shown:
i. . ii. Release the shift button and selection is displayed as shown:
Selecting a range using keyboard iii. Point to the
corner cell i.e. B4 of the range to be selected.

iv. Hold the shift key and use the arrow keys to move to diagonally
opposite corner cellDefine the range of cell
i. Select the range of cells and click InsertNamesDefine to open
the define names window.

ii. Enter the name of the range in the name field.

iii. Click OK to close the window.
 Practical 7

Apply formula and functions in spreadsheet

(a) Demonstrate to enter the text, numeric data in a cell and

Identify the label, values and formula in the
cell Numbers/Value- are values that you want to
use in calculations,including date.
Text/Label- ia any entry that is not a number or formula. It is combination of
numbers, spaces and non-numerical characters.
Formulas- is a set of mathematical instructions that can be used in calc to perform
calculations. When formula uses text it is called text formula, when formula contain
airthmetic operators are called numeric formula and when formula contain
comparison operator are called logical formula.

(b) Demonstrate to enter formula in a cell

(i) Activate a cell where you want the resukt to appear.
(ii) Type =
(iii) Click the first cell i.e. F8 that you want to include the formula.
(iv) Type an operator i.e. *
(v) Click on the next cell i.e. F8 in the formula.
(vi) Finish the entry by pressing Enter or clicking the Enter button on the
formula bar.
(c) Construct the formula using mathematical operators
Suppose to add the values in two cells A1 and A2 and get the addition in cell in A3.
Write the general formula in cell A3 as =A1+A2.
(d) Use the basic functions to perform calculations on data.
Open Office Calc provides built in functions. SUM is the function to get the sum of
range of cells. So we can use the function, ‘Sum(D2:D7)’ in D8 cell to obtain the total
cost of all the items. In the function we need to include only the cell range (starting
and last cell address)

Practical 8

Format data in the spreadsheet

(a) Identify the formatting tool

 (b) Demonstrate to use of dialog boxes to format values
You can open this Format Cell dialog box by clicking
FormatCells

(c) Demonstrate to format range of cells with decimal places

• Select the range of cells.

• Open the ‘format cells dialog’ box

• Click the ‘Number’ tab

• Select the ‘Number’

• Change the decimal places as required

• Click ‘OK’

(c) Demonstrate to format a range of cells to labels

• Select the range of cells.

• Open the ‘format cells dialog’ box .

• Click the Number tab.

• Select Text.
• Click ‘OK’ .

• Enter numbers.

(d) Demonstrate to format of a cell range as

scientific
• Select the range of cells.
• Open the ‘Format cells dialog’ box .
• Click the ‘Number’ tab.
• Select the ‘Date’ category .
• Select the date format .
• Click ‘OK.

(e) Demonstrate to format a range of cells to

display time
• Select the cell range
• Open the ‘format cells dialog’ box
• Click the ‘Number’ tab
• Select the ‘Time’ category
• Select category Time should be displayed
• Click ‘Ok’

(f) Demonstrate to align cell data range

• Select the range of cells

• Open the ‘format cells dialog’ box
• Click the ‘Alignment’ tab
• Select left, right or center
• Click ‘OK’
(g) Demonstrate to create number series using fill handle
(i) Type the numbers 1, 2 in two consecutive cells and select them using a
mouse.
(ii) Click on the right down corner of the selected cells, hold down the
first button of mouse and drag downward till you want to continue as
shown in Figure.
(h) Copy formula by dragging the formula using fill handle

• Select the cell which contains the formula

• Click the small black square in the bottom-right corner of the selected
cell
• Drag the fill handle up to the required cell

PRACTICAL 9
PROCEDURE:-
• Click the File tab.This takes you to Backstage view.

• Select New.

• Select Blank presentation under Available Templates and Themes. It

will be highlighted by default.

• Click Create. A new blank presentation appears in the PowerPoint window.

• Create your own presentation .

❖ Transitions
• Select the slide you want to modify.

• Click the Transitions tab.

• Locate the Transition to This Slide group. By default, None is applied to each slide.

• Click the More drop-down arrow to display all of the transitions.

• Click a transition to apply it to the selected slide. This

will automatically preview the transition as well.
.
❖ ANIMATIONS
• Go to the Animation ribbon and click on the
Animation Pane to display the animation
sidebar.
• Select one of the objects in the slide and

click on the Add Animation menu • . Choose

from one of the Animation options