Aim

To create a letter document and manipulate text using MS-Word.

Procedure

1. To enter Microsoft word, Click “start” button then click “program” then click “Microsoft

word”

2. Open a new document using File->New option and type text.

3. To add Header and footer click “view” menu, from this click “header and footer” option.

4. Then enter the heading in the header portion and change the “font size” to big size and

then click “B” button on formatting tool bar so that the header appears bold.

5. Then type the letter. Use Justify alignment from home menu to align letter.

6. Then save the document.

Result:

Thus the letter document is created successfully using MS-Word.

OutPut

From: Nagercoil

S.Neha, 12/08/15

I Sem BE, C Section,

University College of Engineering, Nagercoil,

Konam

To:

The Dean,

University College of Engineering, Nagercoil,

Konam

Respected Sir,

Sub : Applying for Leave

As I am going to attend my uncle’s marriage on 15-08-15 in Trichy , I kindly request you to

grant me leave for one day.

Thanking you,

Yours Sincerely,

S.Neha

EX.NO : 01 (a) CREATING A WORD DOCUMENT AND TEXT

MANIPULATION DATE :

Aim:

To create an advertisement using various drawing tools in MS-Word.

Procedure:

1. Open a new document using File->New option and type text.

2. Place the different sized boxes in the document from the drawing toolbar.

3. Type the text in the boxes.

4. Fill the box with black color using Fill Color option from drawing toolbar.

5. Place the appropriate logo from the Insert-> Picture -> From File option.

6. Choose the appropriate WordArt gallery to place the text in boxes.

7. Choose the Bullets for the text from formatting toolbar.

8. Use all these options to create an advertisement as specified in exercise.

Result:

Thus the advertisement is created in MS-Word using various drawing tools.

EX.NO : 01 (b) CREATION OF AN ADVERTISEMENT IN MS-WORD

DATE :

Output:

ASSET VERFICATION

PRE & POST MATRIMONIAL VERFICATION

PRE & POST EMPLOYMENT SCREENING

SHADOWING OF PERSONS

UNDER COVER SERVICE

HANDWRITING AND DOCUMENT ANALYSIS

FINGER PRINT COMPARSION

FORENSIC LAB ATTACHED

DETECTIVE COURSES OFFERED

15 sastry 3rd cross street,

Saidapet,

Chennai-15.

Cell: 9884404567.

15 YEARS

OF EXP. 100%

SECURITY

ASSURED

Aim

To Create a MS-word document with the given formulas and scientific notations

Procedure

1. To create formulae and equations select “Insert” option from the menu bar.

2. From insert menu choose “Equations” option and select “Insert New Equation”

3. Enter the equation in the document.

4. From design menu choose the structure what we want to use in equation

5. Save the document

Output

Formulas and Equations

A) Ca (HCO3)2CaCO3+CO2+H2O B) (A+B)2=A2+B2+2AB

C) x=abc

abax

2

104 D) Pr

m

j

j Tx0

E)

m

j

j TX0

3

2

1

X

X

X

Result:

Thus a MS-word document is created with the given formulas and specifications

EX.NO : 01 (c) MATHEMATICAL FORMULA AND SCIENTIFIC

EQUATION DATE :

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 auto format 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.Reg 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.

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.

Ex.No : 1(d) TABLE CREATION ,TABLE FORMATTING AND

CONVERSION Date:

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.

Result:

Thus the table is created and various table operations performed.

Output

TABLE CREATION AND SORTING FOR STUDENT DETAILS

Before Sorting

NAME REG 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

After Sorting

NAME REG 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

TABLE CONVERTED TO TEXT

NAME REG 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 REG

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

TABLE AUTOFIT CONTENTS

NAME REG 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

TABLE SPLITTING

NAME REG 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

UNIVERSITY COLLEGE OF ENGINEERING, NAGERCOIL

TIME TABLE FOR I SEM BE- C SECTION

HOUR/

ORDER

1

2

3

4

5

6

7

8

I

Chem

Comp practice Lab

Maths

Phy

Foc

EG

II

Maths

Foc

Maths

Lib

EG

Eng

Phy

chem

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

Aim

To demonstrate the concept of mail merging in MS-Word.

Procedure

Creation of Mail Merge

1. Make the main document active, where we want to produce the letter.

2. Choose Start Mail Merge option from the Mailings menu. Now select step by step mail

merge wizard.

3. In that box, click on the create button and choose the option Letters.

4. Click on the Letters because we are merging data source to document in active window.

Creation of Data Source

5. Click on the Get data button and choose Create Data Source option.

6. Select the required fields for the data source ( Eg. Address fields) and then click ok and

then click OK and then save the data source with file name.

7. Now give data to that fields and Click OK, now your Data Source File is created.

8. The Mail Merge toolbar is automatically shown in your word document

Insertion of field names in the main document by using the mail merge toolbar

9. Place the cursor where we want to insert, and then click on the Insert Merge Field

button.

10. Choose First Field from the list box to tell Word 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.

11. Similarly we can insert other fields at the place we want.

12. If we want to merge data source in form letters then click on the Merge button on

Mail Merge helper dialog box. The resultant merged document will be displayed.

EX.NO : 03 MAIL MERGE USING MS-WORD DATE

Sample Input and Output:

From: Google Corporation,

13,Green Avenue,

Devanhalli,Bangalore-56.

To:

<<ADDRESS BLOCK>>

Sir/ Madam,

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 11th

October in Hotel Samrat Ashok at 10

AM.

Regards,

XXXXXXX

,

HR Manager,

Google Corporation.

Result

Thus the mail merger created in MS-Word was successfully.

AIM:To create a flowchart using Microsoft word.

PROCEDURE:

1. To open a word document Click “file” menu then click “new” option.

2. Enter the heading, change the font size. Click the “B” button on the formatting tool

bar so that the heading appears bold.

3. Click “shapes” option from the Insert tool bar, then all the shapes will appear

on the screen.

4. Select the needed shapes one by one and place it on the screen.

5. To connect a l l the boxes use f low lines from the drawing tool bar.

6. To add text inside the shape, select the particular shape and right click the

mouse button. Then select “ add t e x t ” to enter the text.

7. Now the flowchart has been created successfully.

Result:

Thus the flowchart is created successfully in MS-Word.

EX.NO : 04

DRAWING FLOW CHART USING MS-WORD DATE :

OUTPUT

FLOWCHART

START

READ A,B

SUM = A+B

PRINT SUM

STOP

GREATEST OF TWO NUMBERS

START

READ A,B

PRINT B IS

BIG

STOP

IF A > B

PRINT A IS

BIG

AIM:

To create a spread sheet to analyze the marks of the students of a class

Procedure

1. To open Ms-Excel click start->Programs->MS-Office->MS-Excel

2. Enter the Student Name, Marks in three subjects.

3. Place the cursor in E2, type = SUM (B2...D2).

4. Place the cursor in F2, type = AVERAGE (B2….D3).

5. Click on G2, type

=IF(OR(B2<35,C2<35,D2<35),"FAIL",IF(F2>=75,"DISTINCTION",IF(F2>60,"FIR

ST CLASS",IF(F2>50,"SECOND CLASS","THIRD CLASS"))))

6. Copy the formulas to the remaining students

Result:

Thus the Spread sheet to analyze the marks of the students are created

successfully.

Output:

EX.NO : 05 (a) CREATION OF SPREAD SHEET IN MS-EXCEL

DATE :

Aim

To create Bar graph and Pie chart in MS-Excel.

II. The ABC Company shows sales of different products for 5 years. Create Bar Graph, 3D and

Pie Chart for the following.

YEAR PRODUCT1 PRODUCT2 PRODUCT3 PRODUCT4

1989 1000 800 900 1000

1990 800 80 500 900

1991 1200 190 400 800

1992 400 200 300 100

1993 1800 400 400 1200

Procedure

I. Graphs in Excel

1. Enter the data in the Worksheet as shown in question.

2. Choose Chart option from the Insert menu, or choose the Wizard button from the Standard toolbar.

3. Shows the Chart Wizard Step 1 of 4 Chart Type dialog box.

4. Choose the appropriate Chart type from the Chart type list box click Next.

5. Shows the Chart Wizard Step 2 of 4 Chart Source Data dialog then click Next.

6. Shows the Chart you can give the Next. Shows the Chart click Finish. Now the chart is Wizard

Step 3 of 4 Chart Options dialog box, Chart Titles i.e., X and Y Axis Titles etc, then click next.

7. Show the chart Wizard Step 4 of 4 Chart Location dialog box then click finish.

II. Bar Graph

1. Type the data as shown in the Worksheet given in question.

2. Click at cell address Al. 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.

EX.NO : 5(b) CHARTS IN SPREADSHEET

DATE :

OVERS RUNS PER OVER

INDIA PAKISTAN

5 23 20

10 45 32

15 70 64

20 94 82

25 128 112

30 148 130

35 175 155

40 205 190

45 245 220

50 295 252

6. Select Al to E6, then click Next.

7. Click in the Chart Title box, type - ABC Company.

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 the Bar graph and Pie chart is created successfully by using Ms-Excel.

Output

OVERS

RUNS PER OVER

INDIA PAKISTAN

5 23 20

10 45 32

15 70 64

20 94 82

25 128 112

30 148 130

35 175 155

40 205 190

45 245 220

50 295 252

YEAR PRODUCT 1 PRODUCT2 PRODUCT3 PRODUCT4

1989 1000 800 900 1000

1990 800 80 500 900

1991 1200 190 400 800

1992 400 200 300 100

1993 1800 400 400 1200

Aim

1. Calculate HRA, DA, TA, Pf, GPF, LIC, Gross Salary, Deductions, net salary from

given data in a worksheet.

ENO NAME BASIC HRA DA TA LIC PF GPF GS DD NET

5 DAMU 20000

2 LAK 6000

1 MUNI 5000

4 SURI 16000

3 VRB 15000

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) = BASIC + HRA + DA + TA

DD (Deductions) = PF + GPF + LIC

NS (Net Salary) = GS – DD. Sort all Employee names in alphabetical order.

2. Convert

35, 68, 95 to Binary

78,165,225 to Octal

355,375,465 to Hexadecimal

101, 1101, 111011 to Decimal

11111, 10001,110011001,111011111 to Octal and Hexadecimal

Procedure

I for Calculation

Step 1: For HRA put the Cell pointer in D2 and type as =(equal to) for entering the formula.Then

Choose the C2 cell (Basic Salary) and (Multiplication operator) and type 18% that press

Enter. Now the 18% HRA from BASIC is calculated.

Step 2: Then drag that formula for entire records.

Step 3: For TA put the Cell pointer in E2 and press = (equal to) for entering the formula. Then

choose the cell C2 (Basic Salary) and type * (Multiplication operator) and type 15%,

then press enter.

Step 4 : Now the 15% TA from BASIC is calculated. Then drag that formula for entire records.

Step 5: Follow the above steps for calculation of DA, PF, GPF, and LIC.

Step 6: For GS (Gross Salary): Put the Cell pointer in J2 and choose the = (equal to), then click on

C2 cell + Click on D2 + Click on E2 + Click on F2 and press enter.

Step 7: Drag all the cell.

Step 8: Follow the above step for DD and NS calculations.

Step 9: After all calculations, select all the data in worksheet, then Data —> Sort, from the Sort

dialog box, chooses Name for sort order and click OK. It will be displayed on screen.

II. For Conversions

Step 1: Enter the data as given in the question.

Step 2: Click on A2, enter the decimal numbers in rows. Click on B2, type =dec2bin(A2), copy

the formula to the remaining, as it converts the decimal number to binary .

Step 3: Click on C2, type =dec2hex (A2), copy the formula. It converts the decimal

number to hexadecimal.

EX.NO : 5(c) FORMULA EDITOR

DATE :

Result

Thus the calculations and conversions are done according to the given specification in

MS Excel.

Output

EN

O

NAM

E

BASI

C

HR

A DA TA LIC PF

GP

F GS DD NET

5 DAM

U 20000

3600

240

0

300

0

140

0

200

0

100

0

2900

0

440

0

2460

0

2 LAK 6000 1080 720 900 420 600 300 8700

132

0 7380

1 MUNI 5000 900 600 750 350 500 250 7250

110

0 6150

4 SURI 16000 2880

192

0

240

0

112

0

160

0 800

2320

0

352

0

1968

0

3 VRB 15000 2700

180

0

225

0

105

0

150

0 750

2175

0

330

0

1845

0

DECIMAL

DEC 2

BIN

DEC 2

OCT DEC 2 HEX

35 100011

68 1000100

95 1011111

78 116

165 245

225 341

355 163

375 177

465 1D1

BINARY

BIN 2

DEC BIN 2 OCT BIN 2 HEX

101 5

1101 13

111011 59

11111 37

10001 21

110011001 199

111011111 1DF

Aim:

Prepare an electricity bill with consumer number, name, bill month, present and

previous meter readings, consumed number of units and total amount of minimum 5

consumers.

Procedure:

1. To open Ms-Excel click start->Programs->MS-Office->MS-Excel

2. Enter the consumer number, name, bill month, present and previous meter readings.

3. Place the cursor in F2, type =D2-E2.

4. Place the cursor in G2, type=IF((F2<=100),F2*2,F2*3)

5. Copy the formulas to the remaining Consumers

Result:

Thus the electricity bill calculation was successfully creates in Ms-Excel

Output:

EX.NO : 5(d) ELECTRICITY BILL PREPARATION

DATE :

Aim:

To create the presentation for the department using PowerPoint using animation,

design templates and Effective presentation.

Procedure:

1. Open a Blank Presentation by Start->Programs->Ms-Office->Ms-Powerpoint

2. Choose WordArt option from the picture in insert menu or click on WordArt button

from the drawing tool bar.

3. From the WordArt gallery choose the appropriate style then click OK.

4. Edit WordArt Text dialog box appears, type your text here, then click OK.

5. Choose Clipart option from the picture in Insert Menu selection or click on Clipart

button from the Drawing Tool Bar

6. Insert clipart dialog box appears, from there choose required clipart then ok.

7. Follow the above steps to complete remaining slides

Result:

Thus, the presentation for the department using power point using animation,

design templates and Effective presentation is created

Output:

EX.NO : 6 POWERPOINT PRESENTATION

DATE :

Aim:

To write a C program to find whether a year is a Leap Year or not.

Algorithm

Step1: Start the program

Step2: Declare year as int data type

Step3: Read the year

Step4: Check if (ye%4)=0

STEP4.1: Print “It is a leap year”

Step5: Else

Step5.1: Print “It is not a leap year”

Pseudo code

Set initial year.

READ the year.

IF (year % 4 == 0) THEN

WRITE the year is leap year.

ELSE

WRITE the year is not a leap year.

ENDIF

Stop

Flow Chart

No Yes

EX.NO : 4 (a) LEAP YEAR

DATE :

Start

Read year

Is

year%4=0

Print ”not a leap

year”

Print “leap

year”

Stop

Program

#include<stdio.h>

#include<conio.h>

void main()

{

int ye;

clrscr();

printf (“Enter the year \n”);

scanf (“%d”, &ye);

if (ye%4==0)

printf (“It is a leap year: \n”);

else

printf (“It is not a leap year\n”);

getch();

}

Output

Enter the year: 2000

It is a leap year

Result

Thus the program to find whether a year is leap year has been executed successfully.

Aim To write a program to find whether the number is even or odd.

Algorithm

Step-1: Start

Step-2: Read num

Step-3: If the number is divided by 2 , print the given number is even .

Step-4: If the number is not divided by 2, print the given number is odd.

Step-5: Stop

Pseudo code

1. BEGIN the program by entering a number.

2. READ the given number and check the condition.

3. IF it is true , print even ELSE odd.

4. TERMINATE the program.

Flowchart

Yes

No

EX.NO : 4(b) ODD OR EVEN

DATE :

Enter the

number

num%

2

==0

Print

Even

Stop

Stop

Print Odd

Start

Stop

Program

#include<stdio.h>

void main()

{

int num;

printf("Enter the number...");

scanf("%d",&num);

if(num%2==0)

printf("The given number is a Even number");

else

printf("The given number is a Odd number");

}

Output

Enter the number…5

The given number is a Odd number

Result

The program to find whether the number is even or odd is verified.

Aim

To write a c program to swap number with three variable

Algorithm

Step 1: Start the program.

Step 2: Declare the variable

Step 3: swap the number using two variables.

Step 4: Print the Results.

Step 5: Stop the program.

Program

#include< stdio.h>

#include< conio.h>

void main()

{

int i,j;

clrscr();

printf("Enter the i & j value=\n ");

scanf("%d%d",&i&j);

printf(“before swap”);

Printf(“\n%d\n%d\n”,i,j);

printf(“after swap”);

i=i+j;

j=i-j;

i=i-j;

Printf(“\n%d\n%d\n”,i,j); getch();

}

Output

Enter the i & j value=3 4

before swap

i=3;

j=4;

after swap

i=4;

j=3;

Result

The program is executed and the output is verified.

EX.NO : 4 (b) SWAP NUMBER WITHOUT TEMPROARY VARIABLE

DATE :

Aim:

To compute area and circumference of a circle using value of ʌ(constant).

Algorithm:

Step 1 : Start

Step 2 : Define constant pi= 3.14

Step 3 : Read the value of radius

Step 4 : Calculate area using formulae pi*radius2

Step 5 : Calculate circumference using formulae 2*pi*radius

Step 6 : Print area and circumference

Step 7 : Stop

Flowchart:

Program:

/* Area and circumference of a circle */

#include <stdio.h>

#include <conio.h>

#define pi 3.14

main()

EX.NO : 4 (c) AREA AND CIRCUMFERENCE OF CIRCLE

DATE :

{

int radius;

float area, circum;

clrscr();

printf("Enter radius of the circle : ");

scanf("%d", &radius);

area = pi * radius * radius;

circum = 2 * pi * radius;

printf("Area is %.2f and circumference is %.2f",area,circum);

getch();

}

Output:

Enter radius of the circle : 8

Area is 200.96 and circumference is 50.24

Result:

Thus area and circumference of a circle is computed.

Aim:

To determine roots of a real type quadratic equation ax2+ bx + c= 0.

Algorithm:

Step 1 : Start

Step 2 : Read co-efficient values of a,band c

Step 3: Compte roots r1= −𝑏+√𝑏2−4𝑎𝑐

2𝑎 𝑎𝑛𝑑

−𝑏−√𝑏2−4𝑎𝑐

2𝑎

Step 4 : Print r1, r2

Step 5 : Stop

FLOWCHART:

Program:

#include <stdio.h>

#include <conio.h>

#include <math.h>

void main()

{

int a, b, c, d;

float r1, r2;

EX.NO : 4 (d) QUADRATIC EQUATION

DATE :

clrscr();

printf("Enter co-efficient for x^2 : ");

scanf("%d", &a);

printf("Enter co-efficient for x : ");

scanf("%d", &b);

printf("Enter const co-efficient : ");

scanf("%d", &c);

d = b*b - 4*a*c;

r1 = (-b + sqrt(d)) / (2.0 * a);

r2 = (-b - sqrt(d)) / (2.0 * a);

printf("Real roots are %.2f and %.2f", r1, r2);

getch();

}

Output:

Enter co-efficient for x^2 : 2

Enter co-efficient for x : 8

Enter const co-efficient : 6

Real roots are -1.00 and -3.00

Result:

Thus roots of a quadratic equation were obtained using math library functions.

Aim:

To find the square root of the given numbers

Algorithm:

Step 1 : Start

Step 2 : Read the input value of X

Step 3:Compute and print the value of sqrt(X)

Step 4 : Stop

FLOWCHART:

Program:

#include <stdio.h>

#include <conio.h>

#include <math.h>

void main()

{

float x;

clrscr();

printf("Enter the value of x : ");

scanf("%f", &x);

printf("square root of %6.2f is %6.2f”,x,sqrt(x));

getch();

}

EX.NO : 4 (f) SQUARE ROOT OF GIVEN NUMBERS

DATE :

start

Read X

X

Print sqrt(X)

stop

Output:

Enter the value of X: 81

Square root of 81.00 is 9.0

Result:

Thus the square of given number root were obtained using math library functions.

Aim:

To find the biggest of two numbers using ternary operator.

Algorithm:

Step 1 : Start

Step 2 : Read the input value of X,Y

Step 3:Compute biggest among two numbers X,Y and print it

Step 4 : Stop

FLOWCHART:

Program:

#include <stdio.h>

#include <conio.h>

void main()

{

int x,y,big;

clrscr();

printf("Enter the value of x,y : ");

scanf("%d%d", &x &y);

printf("big is ….%d”,big);

getch();

}

EX.NO : 4 (g) BIGGEST OF TWO NUMBERS USING TERNARY OPERATOR

DATE :

start

Read X,Y

X

Print Big

stop

Big=X>Y?X:Y;

Output:

Enter the value of x,y: 5 7

Big is …..7

Result:

Thus the biggest of two numbers using ternary operator is completed.