OFFICE AUTOMATION LAB PROGRAMS

1 Using MS-Word with suitable examples, write the steps and execute the following with
respect to table handling
i. Creating a table (At least 4 columns and 6 rows).
ii. Entering appropriate data into the table.
iii. Sort the table.
iv. Apply the formulas on table numeric values.

2 Using MS-Word write the steps and execute for creating “Mail Merge” document for
“FORM LETTERS”.

3 Using MS-Excel spread sheet, with suitable example, write steps and create worksheet
called “Employee” and calculate the following using formulas
i. Enter Employee Code, Name and Basic Salary.
ii. Calculate DA (20% of Basic Salary).
iii. Calculate HRA (10% of Basic Salary).
iv. Calculate CCA (8.5% of Basic Salary).
v. Calculate Total Salary (Basic Salary + DA + HRA + CCA).
vi. Calculate Deductions (10% of Total Salary).
vii. Calculate Net Salary (Total Salary - Deductions).

4 Using MS-Excel draw X-Y Line Chart and Bar Charts based on the following
worksheet data and write the steps.
ITEM MONTHLY SALES
(in Thousands)
Cotton 2,750
Wool 3,100
Yarn 2,975
Jute 2,100
Fiber 3,010

5 Using MS-Excel spreadsheet write the steps and execute the following:
 Roll Student Marks1 Marks2 Marks3 Total Percentage Result
No. Name

i. Create appropriate records.

ii. Calculate total and marks using formula.
iii. Update result column using IF function.
(Result: Distinction, First Class, Second Class, Pass, Fail).

6 Using MS-Access with suitable examples write steps and execute the following.
i. Create STUDENT database table.
ii. Create appropriate records.
iii. Add two more records to the table.
iv. Delete second record to the table.
v. View the records.

7 Using MS-Access with suitable examples write steps and execute the following.
i. Create EMPLOYEE database table.
ii. Create appropriate records.
iii. Sort the records in ascending order of name.
iv. Sort the records in descending order of salary.
v. View the records.

8 Using MS-PowerPoint with suitable examples write steps and execute the following:
i. Create presentation slides with Titles, Sub Titles and Charts choosing different
slide layouts.
ii. Use design templates for background.
iii. Format the slides design.

9 Using MS-PowerPoint with suitable examples write steps and execute the following:
i. Create Presentation table slides using an organization chart.
ii. Use different views such as slide view, slide sorter view and slide.
1. Using MS-Word with suitable examples, write the steps and execute the following with
respect to the table handling.
i. Creating a table ( At least 4 Column and 6 Rows)
ii. Entering appropriate data into the table.
iii. Sort the table.
iv. Apply the formulas on table numeric values.

To open the MS-Word:

Go to start

Select Programs

Select MS-Office

Click on MS-Word

To Create a Table:

Select Insert Menu

Then Click on Table

Select 6 Rows and 4 Columns

Enter the Data in the Table

Reg. number Name Subject 1 Subject 2 Total Average

01 Namratha 45 82
02 Sonika 65 67
03 Aisha 67 54
04 Suma 87 78
05 Vani 98 78

To Sort the Table:

Select the Layout menu

Click on Sort option

Select the Column which you want to sort

Select the Data type

Select Ascending or Descending

Click on OK button. Table is sorted.

Reg. number Name Subject 1 Subject 2 Total Average

01 Aisha 45 82
01 Namratha 65 67
03 Sonika 67 54
04 Suma 87 78
05 Vani 98 78
 To Apply the Formula:

Select the Layout Menu

Select the Formula Option

Formula Window appears

For addition Sum (above)

=Sum (c2:d2) or c2+d2

For average

=Average (e2:2) or e2/2

Then Click OK. Formula Applied.

Reg. number Name Subject 1 Subject 2 Total Average

01 Aisha 45 82 127 63.5
01 Namratha 65 67 132 66
03 Sonika 67 54 121 60.5
04 Suma 87 78 165 82.5
05 Vani 98 78 176 88

2. Using MS- Word write the steps and execute for creating “Mail Merge” document for
FORM LETTERS”.

Type a letter:

Go to Mailings Menu

Select Start Mail Merge

Click on Step By Step Mail Merge Wizard

Select Letters

Click on Staring Document

Click on Use the Correct Document

Select Recipients

Select Type a New list

Click on create

New Address list Window Appears

Type recipient information in the table

To add more entries Click New Entry option

 Click OK

Save the file and Click OK

Write your letter

Insert the merge fields (Address block, Greeting line)

Click Preview your letter /complete the Mail merge.

3. Using Ms-Excel spread sheet, with suitable example, write steps and create worksheet
“Employee” and calculate the following using formulas

i. Enter Employee Code, Name and Basic Salary.

ii. Calculate DA(20% of Basic Salary).

iii. Calculate HRA (10% of Basic Salary).

iv. Calculate CCA (8.5% of Basic Salary).

v. Calculate Total Salary ( Basic Salary +DA+HRA+CCA).

vi. Calculate deductions (10% of Total Salary).

vii. Calculate Next Salary (Total Salary –Deductions).

To open the MS-Excel:

Go to start

Select Programs

Select MS-Office

Click on MS-Excel

To create worksheet called “Employee”:

Select a sheet

Right click on Sheet

Select Rename

Replace the “Sheet” name with “Employee” name

To Enter Employee Code:

Type “Employee Code” in the Cell A1

To Enter Employee Name:

Type Employee “Name” in the Cell B1

To Enter Employee Basic Salary:

Type Employee “Basic Salary” in the Cell C1

To Calculate DA (20% of Basic Salary):

Type “DA” in the Cell D1

To Calculate DA . Apply the formula =c2*(20/100)in cell D2

To insert the formula for all records drag the D2 cell.

To Calculate HRA (10% of Basic Salary):

Type “HRA” in the Cell E1

Apply the formula=c2*(10/100) in cell E2

To insert the formula for all records Drag the E2 Cell

To Calculate CCA(8.5% OF Basic Salary):

Type”CCA” in the cell f1

Apply the formula=c2*0.085 in cell f2

To insert the formula for all records drag the f2 cell

TO CALCULATE THE TOTAL SALARY (Basic salary + DA + HRA + CCA):

Type ”total salary” in the cell G1

Apply the formula=sum (C2:F2)

OR

=C2+D2+E2+F2 in cell G2 and press enter key

To insert the formula for all records drag the G2 cell

TO CALCULATE DEDUCTION (10% OF TOTAL SALARY):

Type “Deduction” in the cell H1

Apply the formula=G2*(10/100) in cell H2

To insert the formula for all records drag the H2 cell

TO CALCULATE NET SALARY (Total salary-Deduction):

Type ”Net salary” in the cell 11

Apply the formula=G2-H2 in cell H2

To insert the formula for all records drag the I2 cell

A B C D E F G H I
1 Emp ID NAME BS DA HRA CCA TOTAL DEDUCTION NET
SALARY
2 P1001 Ajay 10000 2000 1000 850 13850 1385 12465
3 P1002 Bharath 15000 3000 1500 1275 20775 2077.5 18697.5
4 P1003 Chandan 20000 4000 2000 1700 27700 2770 24930
5 P1004 Darshan 25000 5000 2500 2125 34625 3462.5 31162.5
6 P1005 Eshwar 30000 6000 3000 2550 41550 4155 37395
7 P1006 Farahan 35000 7000 3500 2975 48475 4847.5 43627.5
8 P1007 Goutham 40000 8000 4000 3400 55400 5540 49860
4. Using MS-Excel draw X-Y Line Chart and Bar Charts based on the following worksheet data
and write the steps.

ITEM MONTHLY SALES

(in Thousands)
Cotton 2,750
Wool 3,100
Yarn 2,975
Jute 2,100
Fiber 3,010

To insert a X-Y chart for above table:

Select columns

Go to insert option

Select X-Y chart

Click OK

monthly sales(in thousands)

3500

3000

2500

2000
monthly sales(in
1500 thousands)
1000

500

0
cotton wool yarn jute fiber
To insert a bar chart for above table:

Select columns

Go to insert option

Select bar chart

Click ok

monthly sales (in thousands)

fibre

jute

yarn
monthly sales (in thousands)

wool

cotton

0 500 1,000 1,500 2,000 2,500 3,000 3,500

5. USING Ms-EXCEL SPREAD SHEET WRITE THE STEPS AND EXECUTE YHE
FOLLOWING

ROLL STUDENT MARKS MARKS2 MARKS3 TOTAL PERCENTAGE RESULT

NO NAME 1

i. Create appropriate records

ii. Calculate total and percentage using formula.
iii. Update result column using IF function.
(Result: Distinction, first-class, second class, pass, fails).

Create student marks sheet as shown in above tables:

Enter the data for each record.

To calculate total using formula:

Enter the following marks in total cell

=average (marks1:marks2) or= marks1+marks2+marks3

To calculate percentage using formula:

Enter the following formula in percentage cell

=average (marks1:marks2) or = total/number of subjects

To find the result using IF function:

Enter the following formula in result in result cell

=IF(OR(Marks1<35, Marks2<35, Marks3<35), ”FAIL”, IF(percentage>=75,

”DISTINCTION”, IF(percentage>=60, ”FIRST CLASS”,
IF(percentage>=50, ”SECOND CLASS”, ”pass”))))

6. Using MS-Access with suitable example write steps and execute the following

i. Create STUDENT database table.

ii. Create appropriate records.
iii. Add two more records to the table.
iv. Delete 2nd record on the table.
v. View the records.

To open the ms-access:

Go to start

Select programs

Select MS-Office

Click on MS-Access

To create student database Table:

Click on new

Select blank data base

Enter the file name

Click on create

Right click on table

 Select design view

Enter field names and select corresponding data types as shown below

Enter the data in appropriate records as shown in below

Adding two more records to the table:

Deleting 2nd records on the table

Select the 2nd row

Right click on the row

Select Delete records as shown below

Select view option

Click on data sheet view

7. Using Ms-Access with suitable examples write steps and execute the following.

i. Create EMPLOYEE database table.

ii. Create appropriate records.
iii. Sort the records in ascending order of name.
iv. Sort the records in ascending order of name.
v. View the records.

i. Create Employee data base :

Open Ms- Access

Select office button click on new

Select blank database

Enter data base name as employee

Click on create
To create a table
 Table creation
Name Data types
Employee number Number
Employee name Text
Designation Text
BS Number
DA Number
HRA Number
CCA Number
GS Number
LIC Number
NS Number

ii. Create appropriate records

Employee Employee designation BS DA HRA CCA GS LIC NS

number name
1 AAA SDA 10000 5000 2000 1000 18000 2000 16000
2 CCC FDA 15000 7500 3000 1500 27000 2000 25000
3 BBB Manager 20000 10000 4000 2000 36000 3000 33000
4 EEE FDA 15000 7500 3000 1500 27000 2000 25000
5 SDA SDA 10000 5000 2000 1000 18000 2000 16000

iii. To sort the records in Ascending orders of name.

Select the field Employee name

Ascending

In home menu select ascending option

iv. To sort the records in descending orders of salary
Select the field NS

In home menu select descending option as shown below

Descending
 v. To view the records:
Go to view option

Select data sheet view

8. Using Ms-power point with suitable examples write steps and execute the following:

i. Create presentation slides with titles, Sub Titles Charts choosing different slide layout.
ii. Use design templates for background.

iii. Format the slide design.

i. To create presentation slides

Open ms-power point

 Select new

Select blank presentation

Click on create

Click on new slide (as you’re required)

ii. Create presentation slides with titles, Sub Titles and Charts choosing different slide
layout:

To create different slide layout

Select layout

Select slides with Titles, Sub titles and Chart

iii. Use design templates for background

Go to design menu

Select different design templates

 iv. Format the slide design

Select the slide

Go to format menu

Select insert shapes

Select shape styles

Select word style

Select arrange

Select size

9. Using Ms-PowerPoint with suitable examples write steps and execute the following:

i. 1. Create presentation table slide using an organization chart.

ii. 2. Use different views such as slide view, slide sorter view and slide show view.

1. Create presentation table slide using an organization chart.

Go to Slide layout

Select the slide layout with Chart

Select the chart

Excel sheet appears

Enter the appropriate Data in Excel sheet

II. Use different views such as slide view, slide sorter view and slide show view

Go to View menu

In presentation views

Click on normal

Click on slide sorter

Click on slide show