MS- WORD (Cycle - I)

INTRODUCTION TO WORD PROCESSING

AIM:
To study about the options or features of word processing.

PROCEDURE:

TO OPEN A NEW DOCUMENT

Open a new document using FILE->NEW or use CTRL+N option and type text.

TO SAVE

For saving the document, press CTRL+S or click on save button on standard tool bar or select
Save option from the File menu. Then it shows the Save As dialog box. Choose a suitable file name in File
Name Text Box, then click save button on save as Dialog Box. Now the document is saved under a given
name.

LINE SPACING

Select the paragraphs of the document using the left mouse button or choose select all option from
the Edit menu or by pressing CTRL+A. (OR)
Choose paragraph option from the Format menu selection. A paragraph dialog box appears, from
that choose appropriate line spacing from that menu.

ALIGNMENT

Select the text for alignment, then select the suitable alignment button from the Formatting tool bar
Otherwise select

CTRL+L --Left alignment

1
GE6161 - Computer Practice Laboratory
FOR ADDING BULLETS AND NUMBERING

Select the text where you want to add bullets and numbering. Then click the bullets button on the
formatting tool bar or choose Bullets and Numbering option from the format menu. It shows bullets and
numbering dialog box. From that choose the required bullet from the Bullet menu.

CHANGING FONT TYPES AND SIZES

Select the text you want to change for font types and sizes. Then Choose Font option from the
format menu.

TO ADD BOX
 Choose select all option from the Edit menu or by pressing CTRL+A
 Click Border icon from the Formatting tool bar, then click outside the text to de-select it.
TO INSERT SYMBOLS

 Type the text, then put the cursor where you want to add the symbol.
 Choose Symbol Option from the Insert menu. Then choose appropriate symbol from the
symbols dialog box.
TO EQUATIONS
Enter the equation in the document. Select the character, which you want to show as a subscript or
superscript
 FOR SUBSCRIPT
Choose the Font option from the Format menu, then enable the subscript check box from
the Font Dialog Box OR press CTRL+=
 FOR SUPERSCRIPT
Choose the Font option from the Format menu, then enable the superscript check box from
the Font Dialog Box or press CTRL+SHIFT++

CHANGING TEXT INTO DIFFERENT CASES

Choose the Change case option from the Format menu, then select the different cases for the
selected text from the Change Case Dialog Box

2
GE6161 - Computer Practice Laboratory
FOR TYPING FORMULAE

Click insert->object->Microsoft Equation 3.0 then click ok. Using Microsoft Equation Toolbar
we can type any equations

TO ADD ANIMATION

Format->font, choose text effects tab, then select the required font then click ok

RESULT:
Thus the features/options of word processing were studied successfully.

3
GE6161 - Computer Practice Laboratory
 CURRICULUM VITAE
Ex. No. 01a

AIM:
To create 2 pages of Curriculum Vitae of a B.E./B.Tech Graduate using MS-WORD.

PROCEDURE:
1. Choose File->page setup. Switch to margins tab if not displayed.
2. Type the desired dimensions on the margin dimension boxes as known in next page.
3. Change paper size and orientation by switching to paper size tab, then click ok
4. Choose insert ->break->continuous from the section break type in the break dialog box , then
click ok
5. Choose format->columns , it shows the columns dialog box , Choose two columns from the
presets box, then click ok.
6. Type the body of the curriculum vitae, such as name, address, etc.
7. Choose view->header and footer.
8. Now the cursor is switched to headers pane.
9. Enter your name in the header area at the top right side of the page.
10. Click the insert->page number.
11. The Page numbers dialog box is displayed.
12. Click on the position->bottom of page and alignment->right.
13. Now your curriculum vitae is ready to print.

RESULT:
Thus Curriculum Vitae of a B.E./B.Tech graduate is created using MS-Word.

4
GE6161 - Computer Practice Laboratory
 FORMATTING THE EQUATIONS
AND
SCIENTIFIC NOTATIONS
Ex. No. 01b
AIM:
To type the given equations and scientific notations in a document using MS-WORD.
i. Ca(HCO 3)2 -> CaCO3 + CO2 + H2O
ii. (A + B)2 = A2 + B2 + 2AB
b b 2  4ac
iii.
2a

m 
iv. Pr  X j  T 
 j 0 

v. HCO    H    H O  CO 
3
 
2 2

PROCEDURE:
To Scientific notations:
1. Enter the equation in a document.
2. Select the character, which you want to show as a subscript.
3. Choose the Font option from the Format Menu, then enable the subscript check box from the
Font dialog box.
4. For subscript, choose the font option from the format menu, then enable the superscript check
box from the Font dialog box.
5. Repeat this for the next equation.
To Equations:
1. Enter the equation in a document.
2. Choose insert->object->Microsoft equation 3.0 from the object dialog box. It display the
equation box.
3. Choose the appropriate notations from the equation dialog box

RESULT:
Thus the Equations and scientific notations are typed and formatted according to the specifications
in a document using MS-WORD

5
GE6161 - Computer Practice Laboratory
 TABLE CREATION
Ex. No. 01c
AIM:
To create a table with the following columns and display the result in the separate cells.
a. Employee Name
b. Basic Pay
c. DA
d. HRA
e. Total Salary

PROCEDURE:
1. Select Table menu bar, then choose Insert Table option.
2. It shows the Insert Table dialog box.
3. Set Number of columns to 5, Number of Rows to 4 and column width in the Insert Table dialog
box and click OK.
4. Now the table is inserted in the document with 5 columns and 4 rows.
5. Enter the text in the columns by pressing tab key leaving total salary Blank.
6. Place the cursor in the table and click table->sort.
7. It shows the Sort dialog box.
8. In the Sort by option select Employee Name from the drop down list and select ascending
option and click OK.
9. Place the cursor in the total salary of 2nd row. Click Table->Formula. It displays a Formula
dialog box with formula=SUM(LEFT). Click OK.
10. Now the total salary for the first employee is displayed at the Total Salary Column. In the same
way find total salary of the remaining rows.
11. Place the cursor in total salary of last row. Click Table->Insert->Rows below. This will create a
blank row.
12. Locate the cursor at the 5th row and 4th column. Type the Grand Salary, press tab once, then
choose Table->Formula, in the Formula dialog box type = SUM(ABOVE), now the Grand
Salary is displayed.

6
GE6161 - Computer Practice Laboratory
 13. Locate the cursor at the 6th row and 4th column, type Maximum, press tab once, then choose
Table->Formula, in the Formula dialog box type = MAX(ABOVE), now the Maximum Salary
is displayed.
14. Locate the cursor at the 7th row and 4th column, type the Minimum, press tab once, then choose
Table->Formula, in the Formula dialog box type = MIN(ABOVE), now the Minimum Salary is
displayed.

RESULT:

Thus a table with Employee details is created in MS-WORD.

7
GE6161 - Computer Practice Laboratory
 INVITATION LETTER USING MAIL MERGE
Ex. No. 01d
AIM:
To prepare an Invitation Letter for the workshop to be conducted in our College using Mail Merge.

PROCEDURE:

The three main components of the merging process are:

i. Main Document: It contains the main body of the letter, filed names and merge instructions.
The basic information in the main document remains the same.
ii. Data Sources: It stores the information to be brought into the main document. (Eg. List of
Addresses)
iii. Merged Document: It combines the information from Main documents and Data fields from
Data Source.

CREATION OF MAIL MERGE:

1. Type the content of the letter in the main document and save it.
2. Make the main document active.
3. Choose Mail Merge option from the Tools menu. Now the Mail Merge helper dialog box appears.
4. Click on Create Button and choose the option Form Letter.
5. Click on Form Letter to merge data source to document in active window.
6. Click Get Data button and create Data Source option.
7. Select the required fields for the data source (Eg. Address Fields) and click OK and then save the
data source with a file name.
8. Now, give data to the selected fields and then click OK. The data source is created.
9. The mail merge toolbar is automatically shown in the document.

8
GE6161 - Computer Practice Laboratory
INSERTION OF FIELD NAMES IN THE MAIN DOCUMENT:

1. Place the cursor where we want to insert, then click on the Insert Merge Field button.
2. Choose First Field from the list box to place the information from the first row of the data source
file in the form letter. The First merge Field is inserted in the document.
3. Similarly, insert the other fields at the required place.
4. Click Merge button on Mail Merge Helper dialog box. The resultant merged document will be
displayed.

RESULT:

Thus an Invitation letter for all the colleges is prepared with the help of Mail Merge using MS-
WORD.

9
GE6161 - Computer Practice Laboratory
 FLOW CHART PREPARATION
Ex. No. 03
AIM:
To draw the Flow Chart for the C program “Finding the factorial of a given number” using MS-
WORD.

PROCEDURE:
1. Choose Flowchart option in the Autoshapes menu of the Drawing Tool bar.
2. Choose the appropriate flowchart symbol, then drag the symbol in the document.
3. Type the text in the symbol by right click. Then choose add text.
4. Using the Arrow button, Line style button and Arrow style in the drawing tool bar draw the
lines connecting to the different flowchart symbols.
5. Select all the flowchart symbols and lines in the document using the select objects button
then right choose Grouping, then click on Group.
6. Now all the flowchart symbols are grouped into one.

RESULT:
Thus flowchart is prepared in MS-WORD.

10
GE6161 - Computer Practice Laboratory
 MS – EXCEL (Cycle – II)

CHART CREATION
Ex. No. 02a
AIM:
To create a Bar Chart, 3D and Pie Chart for the sales data of different products for 5 years of M/s.
ABC Corporation Ltd., India.

PROCEDURE:
1. Type the sales data of different products of 5 years in a Spread Sheet.
2. Click at Cell Address where year is typed. Click Insert-> Chart.
3. Excel will display the first dialog box of Chart Wizard.
4. Select Bar Graph and click on Next.
5. Click on Data Range from the Chart Wizard dialog Box.
6. Select all the data, then click Next.
7. Click in the Chart Title box, type – ABC Corporation Ltd.
8. Click on the category X- Axis, type – Years.
9. Click on the value Y-Axis type Products.
10. Click Next. then click FINISH.
11. Excel will display the created chart in the current worksheet.
12. In the same way, repeat the steps for creating 3D and Pie Chart.

RESULT:
Thus a Bar Chart, 3D and Pie Chart for the sales data of different products for 5 years of M/s. ABC
Corporation Ltd., India was created in MS-Excel.

11
GE6161 - Computer Practice Laboratory
 REPORTS ON STUDENT’S MARKS
Ex. No. 02b
AIM:
To create a Spread sheet to create reports on students’ marks.

PROCEDURE:
1. Enter Name, Department and Marks in 5 Subjects for 5 Students.
2. Find the Total by calling the function Sum. (Sum(data range))
3. Find the Average by calling the Function Average. (Average(data range))
4. Find the Class obtained by the students by following the criteria given below:
Marks < 35 FAIL
Marks >= 75 DISTINCTION
Marks >=60 FIRST CLASS
Marks >=50 and <60 THIRD CLASS
5. Copy the formulae to the remaining students.

CREATION OF CHART:
1. Select the Name and Marks Column.
2. Click on the Chart Wizard on the Formatting Toolbar.
3. It shows the Chart Wizard – Step 1 of 4 – Chart Type dialog box, choose the Chart Type and click
Next.
4. It shows the Chart Wizard – step 2 of 4 – Chart Source Data dialog box, choose the Chart Source
and click Next.
5. It shows the Chart Wizard – step 3 of 4 – Chart options dialog box, choose the Chart Title, X-Axis
and Y-Axis labels and click Next.
6. It shows the Chart Wizard – step 3 of 4 – Chart Location dialog box, choose the chart location and
click Next.
7. Click Finish. The Chart is displayed on the worksheet.

RESULT:
Thus Students’ marks are analyzed by drawing charts using MS-EXCEL.

12
GE6161 - Computer Practice Laboratory
 INSERTION OF OBJECTS, PICTURES AND PROTECTION OF SPREADSHEET
Ex. No. 02c

AIM:
To insert object, picture in a worksheet and protect the sheet in MS-Excel

PROCEDURE:
1. There are so many objects that can be inserted into the worksheet.
2. Choose objects option in the insert menu.
3. Choose pictures option from the insert menu.
4. Choose appropriate object from the auto shape menu of the drawing toolbar.
5. Choose pictures option from the insert menu.
6. Then choose from file option.
7. Now the insert picture dialog box.
8. Navigate and choose the picture to insert into the worksheet.
9. Then click on insert button.
10. Now the selected picture is inserted into the worksheet.
11. Click on cell, which you want to protect.
12. Choose Tools->protection, then choose protect sheet, it shows the protect sheet dialog
box asking the password to protect sheet.
13. Type the password click and ok. Then it asks for confirmation password box. Type the
same password again and click ok..
14. Now the sheet is under protection.
15.To remove protection, choose tools->protection ->unprotect sheet, then type the password
to unprotect.
16.Now the sheet can be unprotected.

RESULT:
Thus Picture, objects are created in the spreadsheet and the spread sheet is protected.

SORTING AND IMPORT/EXPORT FEATURES

13
GE6161 - Computer Practice Laboratory
Ex. No. 02d
AIM:
To create Worksheet contains details about the employees in an organization. Perform sort, import
and export features.

PROCEDURE:
1. Enter the following data into the worksheet using data->form command.
2. Sort the data by “salary” within the department using “sort “command.
3. Create transport reservation sheet with following description.

Passenger Name: Not to exceed 20 characters with a display of message if it exceeds. Use the
interactive display request “please enter name”.
Gender: Male/Female option to select one. Use the interactive display request “Select gender
please”.
Seat Numbers: >1 and <=200 with display message if out of range. Use the interactive display
request “enter seat number”.
Class: First or second or third to select as required. Use the interactive display request “please
select class”.
Amount: If the class is first .then the amount is Rs.500,if the class second ,Rs.400 and if the class
is third, Rs.300.

4. Find the sub total.

To import External Data:

RESULT:
Thus sorting, export and import operations are performed in the spreadsheet.

14
GE6161 - Computer Practice Laboratory