MICROSOFT WORD

1
Ex No:1 DOCUMENT CREATION,TEXT MANIPULATION
Date: WITH SCIENTIFIC NOTATION

AIM:
To create a document for letter writing and to perform text
manipulation using Microsoft word.
PROCEDURE:
 To enter Microsoft word, Click “start” button then click “program”
from “programs” menu then click “Microsoft word”.
 For opening a word document do the following. Click “file” menu
from the menu bar. From this file menu click “new” option. This will
display the new document.
 Then for the letter format t write to address and from address at the
left side of the document.
 To change the “font size” to big size , click “B” button on formatting
tool bar so that the header appears bold.
 Then enter the body of the letter. Do justification by selecting the
justification tool from the tool bar.
 Do the right alignment or left alignment if necessary by selecting the
corresponding boxes from tool bar.
 After adding the text to the document, save the document by clicking
the “file” from the menu bar and click ”save” .When we save the
document for the first time name is to be entered and click “save”.

2
 Letter

From
K.Nithesh,
I Sem BE,
A Section,
Vel tech Multitech Dr Rangarajan Dr Sakunthala Engg College,
Avadi.

To
The Principal,
Vel tech Multitech Dr Rangarajan Dr Sakunthala Engg College,
Avadi.

Respected Sir,
Sub : Applying for Leave
As I am going to attend my sister’s marriage on 10-9-10 in Trichy ,
I kindly request you to grant me leave for one day.
Thanking you,

Yours obediently,
K.Nithesh

3
 MATHEMATICAL FORMULA AND EQUATION

1 . Ca(HCO3)2  CaCO3+Co2+H2O

2.(a+b)2  a2+b2+2ab

3.D= -b±√b2-4ac
2a

4. Pr(∑mj=0,xj>T)

4
RESULT:

Thus the word document has been created for letter and text
manipulation with scientific notation has been performed successfully.

5
Ex No : 2 TABLE CREATION ,TABLE FORMATTING AND
Date: CONVERSION

AIM :

To create the table, format the table and do table conversion.

PROCEDURE:

1)Create the Time Table of your class

To create a table, choose Table option. Choose insert option.

Specify the number of rows and Columns.
Choose table autoformat option and specify the table style.
 Now the Specified format is applied to the table.
 Type the time table.

2)Create a table with the following Columns and display the results in
separate cells for the following

1.Student Name
2.VM Number
3.Marks of 3 subjects.
4.Total of the three subject Marks.

To create a table, choose Table option. Choose insert option.

Specify the number of rows and Columns.
Choose table auto format option and specify the table style.
 Now the Specified format is applied to the table.

Sorting:

Select the contents to sort.

 Choose the sort option from Table Menu.
Specify the column and ascending or descending order.
The contents will be in sorted order.

6
Convert Table to text.

1. Select the table from the document.

2.Choose the convert table to text option from table menu.
3.Now it shows convert table to text dialog box.
4.Choose the separator of the text and click ok.
5.Now the table information is converted into text in the document.

Convert Text to table.

1.Select the text in the document.

2.Choose the convert text to table option from table menu.
3.Now it shows convert text to table dialog box.
4.Choose the table size and separate the text option and click ok.
5.Now the text information is converted into table in the document.

AutoFit Option

The AutoFit option is the table menu Is used to specify to automatic row and
Column width and is also useful for distributing the rows and columns
evenly.

Splitting the Table

1) Select the Row from which the table is to be divided.

2) Choose Split table option from the table menu.
3) Now the Table is split into two Tables.

7
TABLE CREATION AND SORTING FOR STUDENT DETAILS

NAME VM NO PHYSICS CHEMISTRY MATHS TOTAL

P.R.Rajesh 2455 75 87 89 251

S.Sumathi 2423 89 83 90 262

M.Victor 2441 69 56 81 206

N.Senthil 2433 93 89 87 269

Before Sorting

After Sorting

NAME VM NO PHYSICS CHEMISTRY MATHS TOTAL

Rajesh.P.R 2455 75 87 89 251

Senthil.N 2433 93 89 87 269

Sumathi.S 2423 89 83 90 262

Victor.M 2441 69 56 81 206

8
 TABLE CONVERTED TO TEXT

NAME VM NO PHYSICS CHEMISTRY MATHS TOTAL

Rajesh.P.R 2455 75 87 89 251
Senthil.N 2433 93 89 87 269
Sumathi.S 2423 89 83 90 262
Victor.M 2441 69 56 81 206

TEXT CONVERTED TO TABLE

NAME VM PHYSICS CHEMISTRY MATHS TOTAL
NO
Rajesh.P.R 2455 75 87 89 251
Senthil.N 2433 93 89 87 269
Sumathi.S 2423 89 83 90 262
Victor.M 2441 69 56 81 206

9
 TABLE AUTOFIT CONTENTS

NAME VM NO PHYSICS CHEMISTRY MATHS TOTAL

NAME VM NO PHYSICS CHEMISTRY MATHS TOTAL
P.R.Rajesh 2455 75 87 89 251
Rajesh.P.R 2455 75 87 89 251
S.Sumathi 2423 89 83 90 262
Senthil.N 2433 93 89 87 269
M.Victor 2441 69 56 81 206

N.Senthil
Sumathi.S 2433
2423 93
89 89 83 87 90 269 262

Victor.M 2441 69 56 81 206

HOUR/ 1 2 3 4 5 6 7 8
ORDER

I Chem Comp practice Lab Maths Phy Foc EG

II Maths Foc Maths Lib EG Eng Phy chem

10
III Foc Phy Eng chem Maths Chem/Physics Lab

IV Maths Chem Foc Eng Phy Engineering Graphics

V EG Phy Maths Foc Eng Net Maths Chem

TABLE AUTO FORMATTING

11
RESULT:

Thus the table has been created , formatted and converted to text
successfully.
Ex No: 3 MAIL MERGE AND LETTER
Date: PREPARATION

AIM:
To create a letter and to merge the letter to multiple recipients using
Microsoft word.
PROCEDURE:
 To enter Microsoft word, Click “start” button then click “program”
from “programs” menu then click “Microsoft word”
12
  Click “Tools” from the menu and choose “Letters and mailings”, then
click “mail merge” from it.
 Then proceed with the following six steps to create a merged
document.
1. From the list of document types available choose “letters”
2. Select current document as the starting document
3. Then select the recipients from the list. If the list is already
available choose “Use an existing list” otherwise choose “Type
a new list” and type the names & addresses of recipients
4. Write the content of the letter. To add recipient information to
the letter, click a location in the document and then click
“Address block”
5. One of the merged letter will be previewed and to preview
another letter click one of the following:
<<Recipient: 1>>
6. On clicking “complete the mail merge” mail merge is ready to
produce the letters
 Now the document has been created successfully.
MAIL MERGE AND LETTER PREPARATION

From
IBM,
Thipasandra road,
Bangalore-56.

To

13
R.Ganesh,
39,B.R.Ambedkar Road,
Poonamalee,Chennai 600056

Sir,
Sub : Interview Call Letter for the post of Software Engineer.
It gives us immense pleasure to inform you that you have been
chosen for the interview Session for the post of Software Engineer in our
Corporation. So you are requested to attend the interview session on 11 th
October in our campus at 10 AM.

Regards,
Ravi Krishna,
HR Manager,
IBM Corporation.

14
 MAIL MERGE AND LETTER PREPARATION

From
IBM
Thipasandra road,
Bangalore-56.

To
Naithik.M
19,St George Street,
Kozhikode, Kerala 52

Sir,
Sub : Interview Call Letter for the post of Software Engineer.
It gives us immense pleasure to inform you that you have been chosen
for the interview Session for the post of Software Engineer in our
Corporation.So you are requested to attend the interview session on 11 th
October in our campus at 10 AM.

Regards,
Ravi Krishna,
HR Manager,
IBM Corporation.

15
RESULT:
Thus the letter has been created and mailed to multiple
recipients successfully.

16
Ex No : 4 DRAWING FLOWCHART
Date:

AIM:
To create a flowchart for addition of two numbers using Microsoft
word.
PROCEDURE:
 To enter Microsoft word, Click “start” button then click “program” from
“programs” menu then click “Microsoft word”
 For opening a word document do the following. Click “file” menu from
the menu bar. From this file menu click “new” option. This will display
the new document.
 Enter the heading, change the font size. Click the “B” button on the
formatting tool bar so that the heading appears bold.
 To change the font color click A button on the drawing tool bar and
select the required colors.
 Click “Autoshapes” option from the drawing tool bar, then click
“flowchart” and all the shapes will appear on the screen.
 Select the needed shapes one by one and place it on the screen. To
connect all the boxes use flow lines from the drawing tool bar.
 To add text inside the shape, select the particular shape and right click the
mouse button. Then a menu appears on the screen, select “add text” from
the menu. Now the cursor appears inside the shape and allows us to enter
the text.
 Now the flowchart has been created successfully.

17
 FLOWCHART

ADDITION OF TWO NUMBERS

START

READ A,B

SUM=A+B

PRINT SUM

STOP

18
RESULT:

Thus the flowchart for addition of two numbers has been created
successfully.

19
MICROSOFT EXCEL

20
Ex No:5 CHART-LINE,XY,BAR AND PIE
Date:

AIM:
To create a chart for the given data in Spread Sheet.

PROCEDURE:

 To enter Microsoft Excel, Click “start” button then click “program”

from “programs” menu then click “Microsoft Excel”
 For opening a word document do the following. Click “file” menu
from the menu bar. From this file menu click “new” option. This will
display the new work sheet.
 Enter the data by placing the mouse pointer in a cell and a double
click on it. Use the tab key to switch from one cell to another.
 To insert charts select the data to which the chart should be created.
Now click insert chart icon. A window will appear and select the
appropriate chart from it. Click next and enter the title, category(x)
axis, category(y) axis etc. Click finish button.
 Then the appropriate chart is placed in the worksheet.

21
 STUDENT DATA BASE
S.No Name Maths physics Chemistry Foc EG English
1 Ganesh 80 89 90 90 80 70
2 Ram 81 90 91 91 81 71
3 Raji 82 91 92 92 82 72
4 Priya 83 92 93 93 83 73
5 kavin 84 93 94 94 84 74
6 Manoj 85 94 95 95 85 75

22
23
RESULT:
Thus the Line chart ,Bar Chart and Pie Chart has been created
successfully for the student data base in Spread sheet.

24
Ex No: 6 FORMULA EDITOR
Date:

AIM:
To calculate HRA, DA, TA, PF, GPF, LIC, Gross salary, Deductions, Net
salary from the given data in a worksheet.

ENO Name Basic HRA TA DA LIC PF GPF GS DED NET

1 AAA 80000
2 BBB 17000
3 CCC 18000
4 DDD 7820
5 EEE 4569
Where
HRA is 18% of basic
DA is 15% of basic
TA is 12% of basic
PF is 10% of basic
GPF is 5% of basic
LIC is 7% of basic
GS (Gross salary) =Basis+HRA+DA+TA
DED (Deduction) =PF+GPF+LIC
NET (Net salary) =GS-DED

PROCEDURE:

25
 To enter Microsoft Excel, Click “start” button then click “program”
from “programs” menu then click “Microsoft Excel”
 For opening a word document do the following. Click “file” menu
from the menu bar. From this file menu click “new” option. This will
display the new work sheet.
 Enter the data by placing the mouse pointer in a cell and a double
click on it. Use the tab key to switch from one cell to another.
 For putting formulas, for eg,place the cursor on a cell which you have
to calculate the value of HRA, then type
 =cell position of basic*18% and press enter.
 Now the value of HRA is calculated. Similarly do for all others.
 Calculate the same for other columns and drag them to all the cells.
 Now the entire table is ready in spreadsheet.

26
s.No Name Basic HRA TA DA LIC PF GPF GS DED N

1 AAA 80000 14400 12000 9600 8000 4000 5600 116000 17600 9

2 BBB 17000 3060 2550 2040 1700 850 1190 24650 3740 2

3 CCC 18000 3240 2700 2160 1800 900 1260 26100 3960 2

4 DDD 7820 1407.6 1173 938.4 782 391 547.4 11339 1720.4 9

5 EEE 4569 822.42 685.35 548.28 456.9 228.45 319.83 6625.1 1005.2 5

27
RESULT:

Thus the given formulas were calculated successfully by using formula

editor in spread sheet.

28
Ex No:7 SPREAD SHEET-INCLUSION OF OBJECT, PICTURE &
Date: GRAPHICS, PROTECTING THE DOCUMENT

AIM:
1. Insert object in the worksheet
2. Picture in the worksheet
3. Protect a sheet

PROCEDURE:
 To enter Microsoft Excel, Click “start” button then click “program” from
“programs” menu then click “Microsoft Excel”
 For opening a word document do the following. Click “file” menu from
the menu bar. From this file menu click “new” option. This will display
the new work sheet.
 For inserting object in the worksheet, choose objects option in the insert
menu
 For inserting picture in the worksheet, choose Picture option in the insert
menu
 For protecting your worksheet, choose Protection option from Tools
menu, then choose Protect Sheet option, Protect sheet dialog box appears.
Type a password and press enter.
 Now your worksheet is protected and can be entered only with the
password.

29
 Inserting Bit map object

images[1] (2).jpg
Inserting pictures

30
RESULT:

Thus the object, picture and graphics were included successfully and the
sheet has been protected by giving password.

31
Ex No:8 SORTING AND IMPORT/EXPORT FEATURES
Date:

AIM:
i. Sort the given data in the worksheet
ii. Include Import/export features

PROCEDURE:
 To enter Microsoft Excel, Click “start” button then click “program” from
“programs” menu then click “Microsoft Excel”
 For opening a word document do the following. Click “file” menu from
the menu bar. From this file menu click “new” option. This will display
the new work sheet.
 Select the data to be sorted and select data from the menu and click sort
 Specify the order in which the data are to be sorted (ascending or
descending) and click OK. Then the sorted data appears in the sheet.
 To import a file select Insert->object->create from file
 To export a file while saving the file save it as webpage so that it can be
viewed by internet explorer

32
 Data before sorting

physic
S.No Name Maths s Chemistry Foc EG English
1 Ganesh 80 89 90 90 80 70
2 Ram 81 90 91 91 81 71
3 Raji 82 91 92 92 82 72
4 Priya 83 92 93 93 83 73
5 kavin 84 93 94 94 84 74
6 Manoj 85 94 95 95 85 75

Sort the table by name

physic
S.No Name Maths s Chemistry Foc EG English
1 Ganesh 80 89 90 90 80 70
5 kavin 84 93 94 94 84 74
6 Manoj 85 94 95 95 85 75
4 Priya 83 92 93 93 83 73
3 Raji 82 91 92 92 82 72
2 Ram 81 90 91 91 81 71

Importing external data

www.Gigapedia.com- to get IT related information.

www.torrentz.com -todownload books.

www.actionfx.com or
http://www.adobe.com/products/tips/photoshop.html.

33
RESULT:
Thus the sorting of data and import /export features has been successfully
performed in Spread Sheet.

34
C PROGRAMMING

35
Ex No: 9(a) DATA TYPES
Date:

AIM:

To write a c program to display different data types values.

Format specifier:
Int-%d
Float-%f
Char-%c

ALGORITHM:

Step 1: Start the program.

Step 2: Declare rollno,mark,grade.

Step 3: Enter the values for rollno,mark,grade.

Step 5: Print the value.

Step 6:Stop the program.

36
 /* Display of different data types*/

#include<stdio.h>
#include<conio.h>
void main()
{
int rollno;
float mark;
char grade;
clrscr();
printf(" Enter the rollno Value : ");
scanf("%d",&rollno);
printf(“Enter the mark”);
scan(“%f”,&mark);
printf(“Enter grade”);
scanf(“%c”,&grade);
printf(“The values are %d%f%c”,rollno,mark,grade);
getch();
}

OUTPUT

Enter the rollno Value :12

Enter the mark:90

Enter grade:A

The values are 12 90 A

37
RESULT:

Thus the c program for displaying all datatypes has been executed
successfully and output is verified.

38
Ex No: 9(b) EXPRESSION EVALUATION
SIMPLE INTEREST CALCULATION
Date:

AIM:

To write a c program to calculate the simple interest.

Formula:
Simple Interest = (P*N*R)/100

ALGORITHM:

Step 1:Start the program

Step 2:Declare P,R,N

Step 3: Read the principal amount P, interest rate R and period N.

Step 4: Calculate Simple Interest by multiplying principal amount P, interest

Rate R, period N and dividing by 100.

Step 5: Print the value of Simple Interest.

Step 6:Stop the Program.

39
 /* Simple Interest Calculation */

#include<stdio.h>
#include<conio.h>
void main()
{
int amount,year;
float rate,interest;
clrscr();
printf("\n\n Enter the Amount : ");
scanf("%d",&amount);
printf("\n Enter the Year : ");
scanf("%d",&year);
printf("\n Enter the Rate : ");
scanf("%f",&rate);
interest=(amount*year*rate)/100;
printf("\n\n Simple Interest : %f",interest);
getch();
}

OUTPUT

Enter the Amount : 5000

Enter the Year : 4

Enter the Rate : 8

Simple Interest : 1600.000000

40
RESULT:

Thus the c program for simple interest calculation has been executed
successfully and output is verified.

41
Ex No:9(c) SWAP USING TWO VARIABLES
Date:

AIM:

To write a c program to perform swapping of two variables.

ALGORITHM:

Step 1: Start the program

Step 2:Read the two numbers a & b

Step 3: Perform
2.1 a = a + b;

2.2 b = a - b;

2.3 a = a - b;

Step 4: Print the numbers a and b

Step 5:Stop the program.

42
 /* Swapping two numbers */

#include<stdio.h>
#include<conio.h>
void main()
{
int a,b;
clrscr();
printf("\n\n Enter the a and b values : ");
scanf("%d %d",&a,&b);
a=a+b;
b=a-b;
a=a-b;
printf("\n\n Swapping two values : %d %d",a,b);
getch();
}

OUTPUT FOR SWAPPING TWO NUMBERS

Enter the a and b values: 45 98

Swapping two values: 98 45

43
RESULT:
Thus the c program for swapping of two numbers has been executed
successfully and output is verified.
44
Ex No :9(d) CONDITIONAL STATEMENTS
Date: BIGGEST OF THREE NUMBERS

AIM:
To write a c program to find the biggest of three numbers.

ALGORITHM:

Step 1:Start the program.

Step 2:Declare a,b,c

Step 3:Read the value of a,b,c

Step 4:check a>b,if condition is true check a>c.

Step 5:If condition fails check b>c.

Step 6:Display the biggest value.

Step 7:Stop the program.

45
/*Biggets of three numbers*/
#include<stdio.h>
#include<conio.h>
void main()
{
int a,b,c;
printf(“Enter the value of a,b,c:”);
scanf(“%d%d%d”,&a,&b,&c);
if(a>b)
{
if(a>c)
{
Printf(“A is biggest number”);
}
else
{
Printf(“C is biggest number”);
}
}
else
{
if(b>c)
{
Printf(“B is biggest number”);
}
else
{
Printf(“C is biggest number”);
}
}
getch();
}

46
Output:

Enter the value of a,b,c: 3 1 7

C is biggest number

RESULT:
Thus the c program for biggest of three umbers has been executed
successfully and output is verified.

47
Ex No :9(e) ROOTS OF A QUADRATIC EQUATION
Date:

AIM:

To write a c program to find the roots of the Quadratic Equation.

Formula:
D=B2-4AC
Condition 1: D= =0
ROOT1=ROOT2= (-B+ √D)/ (2*A)
Condition 2: D>0
ROOT1= (-B+√D)/ (2*A)
ROOT2= (-B-√D)/ (2*A)
Condition 3: D<0
X = (-B) / (2 * A)
Y=√-D/ (2*A)
Print them in the format of (X + iY), (X – iY)

ALGORITHM:

Step 1: Enter the value of A, B, C

Step 2: Find the value of D by using the formula D = (B*B) – (4*A*C)

Step 3: If D is equal to zero then

3.1 Print Roots are real and equal
3:2 Find the two roots as ROOT1 = (-B + SQRT ((D)) / (2*A)
3.3 Print the ROOT1 two times.
48
Step 4: If D is greater than zero then
4.1 Print Roots are real and unequal
4.2 Find the two roots as
ROOT1 = (-B + SQRT ((D)) / (2 * A)
ROOT2 = (-B – SQRT ((D)) / (2 * A)
4.3 Print ROOT1 and ROOT2
Step 5: If D is less than zero then
5.1 Print the Roots are imaginary
5.2 Find the two roots as
X = (-B) / (2 * A)
Y=√-D/ (2*A)
5.3 Print them in the format of (X + iY), (X – iY)

49
 /* Root of a Quadratic Equation */

#include<stdio.h>
#include<conio.h>
#include<math.h>

void main()
{
float a,b,c,d,r,r1,r2;
clrscr();
printf("\n\n Enter the a,b and c values : ");
scanf("%f %f %f",&a,&b,&c);

d=(b*b)-(4*a*c);
r=sqrt(d);

if(d==0)
{
printf("\n\n Roots are Equal");
r1=(-b+r)/(2*a);
printf("\n\n Both Roots Values : %f",r1);
}

else if(d>0)
{
printf("\n\n Roots are Unequal");
r1=(-b+r)/(2*a);
r2=(-b-r)/(2*a);
printf("\n\n Root1 and Root2 Values are : %f , %f",r1,r2);
}
else
{
printf("\n\n Roots are Imaginary");
r1=-b/(2*a);
r2=r/(2*a);
printf("\n\n Root1 and Roots are : (%f + i%f) , (%f - i%f)",r1,r2,r1,r2);
}
getch();

50
OUTPUT FOR ROOTS OF QUADRATIC EQUATION

Enter the a,b and c values : 10 5 6

Roots are Imaginary

Root1 and Roots are : (– 0.250000 + i0.000000) , (– 0.250000 – i0.000000)

Enter the a,b and c values : 5 20 10

Roots are Unequal

Root1 and Root2 Values are : – 0.585786 , – 3.414214

Enter the a,b and c values : 10 20 10

Roots are Equal

Both Roots Values : – 1.000000

RESULT:
Thus the c program for roots of a quadratic equation has been
executed successfully and output is verified.

51