OFFICE AUTOMATION TOOL

B.SC COMPUTER SCIENCE

1. CREATE A TELEPHONE DIRECTORY.

• The heading should be 16-point Arial Font in bold

• The rest of the document should use 10-point font size
• Other headings should use 10-point Courier New Font.
• The footer should show the page number as well as the date last updated.
AIM:-

To create a telephone directory using MS-word.

PROCEDURE:-

Step 1: Start → Program → MS-Office 2007 → MS-word.

Step 2: Go to office button → New file open.
Step 3: Go to insert → Table and shapes tool box.
Step 4: Type the following letter use the tables.
Step 5: Save the document.
Step 6 : Exit from the MS-word.
 SAMPLE OUTPUT:-

TELEPHONE DIRECTORY

BUSINESS NAME ADDRESS TELEPHONE

Padmanathan T A Agraharam, Salem 0427-2250729

Sathish Orchestra Sanniyasigundu, Salem 0427-2261972

Agoram S Agraharam, Salem 0427-2254256

Padmanathan Agraharam, Salem 0427-2250729

Padmanathan T A Agraharam, Salem 0427-2250729

Sathish Orchestra Sanniyasigundu, Salem 0427-2261972

Page No : 1
Last Update : 08.02.2024

Result:-

Thus the above document is created using text formatting and table.
 2. DESIGN A TIME-TABLE FORM FOR YOUR COLLEGE
Design a time-table form for your college.
• The first line should mention the name of the college in 16-point Arial Font and should be
bold.
• The second line should give the course name/teacher’s name and the department in 14point
Arial.
• Leave a gap of 12-points.
• The rest of the document should use 10-point Times New Roman font.
• The footer should contain your specifications as the designer and date of creation.

AIM:- To create a time table document for Semester-II using MS-word.

PROCEDURE:-

Step 1: Start → Program → MS-Office 2007 → MS-word.

Step 2: Go to office button → New file open.

Step 3: Go to insert → Text box.

Step 4: Go to insert → Table and shapes tool box.

Step 5: Type the following letter use the tables.

Step 6: Save the document & Exit from the MS-word.

SAMPLE OUTPUT:-

VMKV ARTS AND SCIENCE COLLEGE, SALEM

B.Sc – Computer Science (I Year - II SEM)
TIME TABLE - (2021-22)

12.00 III 01.15 IV

I II V
DAY – 12.15 – – 02.00 –
10.00 – 11.00 11.00 – 12.00 12.15 02.00 03.00 – 04.00
01.15 03.00

Digital
MONDAY
Desktop
Publishing
Tamil - III I English - II L Library Electronic and
Microprocessor
N
TUESDAY
Computer
Digital
Electronic and T English - II
U Tamil - III Sports
Network
Microprocessor
E
Digital N Computer Network
WEDNESDAY
Desktop
Publishing
Electronic and R Tamil - III
Microprocessor (Tutorial)

Digital
V C
Computer
THURSDAY Electronic and
Desktop
Publishing A English - II
Network
Library
Microprocessor
L H
Computer Desktop Computer Digital Electronic and
FRIDAY
Network Publishing Network Microprocessor Lab

1. Desktop Publishing(716203L2) – Mr. M. Devaraj -(Class

In charge)
2. Computer Network(71620302) – Dr. M. Prakash
3. Digital Electronic and Microprocessor & Lab(71620301 & 716203L1 – Mrs. M.Suguna
4. Tamil – III (70920311) – Ms. G. Mahalakshmi
5. English – II (71120311) – Ms. S. Priyadarshini

Class In-Charge HOD Principal

Result:-

Thus the above document is created using text formatting and table.
 3. CREATE THE FOLLOWING DOCUMENT: A NEWSLETTER WITH A
HEADLINE AND 3 COLUMNS IN PORTRAIT ORIENTATION, INCLUDING AT
LEAST ONE IMAGE SURROUNDED BY TEXT.

AIM:

Create Newspaper which include Main Heading-Sub Heading, Pictures, Graph and news in double

column format in MS Word.

PROCEDURE:

1. Header & Footer

We can give title, page Number, Date, Path Name, etc.

Steps:

1. On the Insert tab, in the Header & Footer group, click Header or Footer.

2.Type the content in the header & footer part.

2.Insert Picture

1.Place the cursor where you want the graphic in your document.

2.Go to the Insert menu and select Picture.

3.Select Clip Art if you want to insert clip art from the Microsoft Gallery; select From File if you want to
insert a photo or drawing you've scanned or created in another application.

4.For Microsoft clip art, choose an image from the gallery, then right-click it and choose Insert (the first icon
in the menu).
 5.For other pictures, locate the file on your hard disk, select it and click Insert.

6.After the picture appears in the document, resize it by dragging one of the handles (small boxes) located
around the outside edges of the graphic's frame.

3. Insert Graph

1.Click "Insert" in the Word ribbon.

2.Click "Chart" in the Illustrations tab to open the Insert Chart dialog box.

3.Click "Line" in the box's left pane. Click one of the available line charts. For example, click the first
option, which Word simply calls "Line."

4.Click "OK" to insert the chart and open an Excel spreadsheet. Both the chart and the spreadsheet contain
random, sample data.

5.Press "Ctrl-A" in the Excel window to select all the cells.

6.Right-click to open a pop-up menu. Click "Clear contents" to erase all the cells' data and strip the line chart
of its markers.

7.Close the Excel window.

4. Columns

1.Columns are a creature of sections, like headers and footers. The command to set them up is found under the Page
Layout tab.
More Columns... gives you a dialog box which gives you even more control.
RESULT:

Thus the news paper can be generated using the above commands.
4. CREATE A DOCUMENT USING SAVE TO BACK UP FILE WATERMARKING IN

MS-WORD

AIM:-

To create a document using save to back up file watermarking in MS-Word.

PROCEDURE:-

1. PICTURE WATER MARK:-

Step 1: Start →program → MS-office2007 →MS-Word.

Step 2: Go to office button → open the any one text file.

Step 3: Go to Page layout → watermark → Customer watermark →picture watermark

Any one picture Select→ click apply and ok.

Step 4: Save the document.

2. TEXT WATER MARK:

Step 1: start →program →MS-office2007 →MS-word. Step

2: Go to office button → open the any one Text file.

Step 3: Go to Page layout → Watermark →Customer water mark select →

Text watermark select → click apply and ok

Step 4: Save the document.

 SAMPLE OUTPUTS:-

RESULT:-

Thus the above document is created using watermarking and verified.

 5. PREPARE THE RESUME USING MS-WORD

AIM:

To prepare the resume using MS-Word.

PROCEDURE:

1. Start Word 2010.

2. Click New on the File menu.

3. In the New Document task pane at the right of the window, you'll find a Templates

area.

4. Click On my computer.

5. When the Templates dialog box opens, click the Other Documents tab.

6. Select one of the three available resume templates - Contemporary Resume,

Elegant Resume, or Professional Resume - and then click the OK button.

7. A new document, based on the selected template, will open in Microsoft Word.

8. To save the new document to your computer, click Save As on the File menu

9. Name the document with a descriptive file name that includes your name and

keywords, such the company and position (for example, SmithResume).

10. Using a descriptive file name makes it easier for the Human Resources Manager at a

company to find your resume in a list of electronic resume files.

RESULT:

Thus we created resume using MS-Word

 6. STUDENT MARK LIST CREATION USING MS-EXCEL

AIM:

To create a excel sheet with student mark list and display result analysis using MS-Excel 2010.

PROCEDURE:

1. In Excel 2007, the formulas are available in the Formulas Tab. If you click on
the Formulas tab, you can see the corresponding ribbon display with available
formulas, as shown below.

Formula

Bar

Following are a few examples of formulas:

 2. In the above example, in the cell F3, just type = B3+C3+D3+E3. It will return sum of
the marks in physics, chemistry, maths and English.

3. Copying a formula

In above exaple just drag the handle and bring down to cover the remaining cells in the
column total. This will automatically copy the fo rmul a a nd calculat e the correspondin g
s um of the respective rows of the other students.
 4. Auto sum feature:

The sum of cell values can also be done with the help of AutoSum feature also.

Following steps explains how to do that.

 Click on the cell F3.

 Select the Formulas tab
 Click AutoSum from the function library group.
 Select Sum
 Press Enter

Alternatively, you can write = SUM(B3:E3) in the Cell F3 to get the sum of the Physics,
Chemistry, Maths and English marks.

5. Sum ( ) : Adds all the numbers in a range of cells.

Syntax SUM(number1,number2, ...)

 6.Average function ( ) : It helps you to get the average of the numbers. It returns the
average (arithmetic mean) of the arguments.

Syntax : AVERAGE(number, number2,...)

Result:

us the student mark list created successfully using excel.

 7. IMPORT EXTERNAL DATA, SORT & FILTER

AIM:
To Import External Data, Sort and Filter using MS-Excel.

PROCEDURE:

Step 1 : Start →program → MS-Office2007→MS-Excel.

Step 2 : Go to → Offices button → New.

Step 3 : The use for one are more option in available in excel
Step 4 : Use of Import external data , Sorting and filter following.
Step 5 : Go to → Data → Sort & Filter → click select to field

Step6 : Go to → Data → Get external data → open import file select to document
→ import wizard step 1 to 3 → Next three step finish click → import data
click ok.

Step 7 : Now the result will be displayed as external data, sort and filter.
Step 8 : Save the document and Exit
7/21/2019 MCA-I SEM - MCA1610-Prog Lab-I-Office Automation Tools-Lab Manual.pdf

SIMPLE OUTPUT:-

http://slidepdf.com/reader/full/mca-i-sem-mca1610-prog-lab-i-office-automation-tools-lab-manualpdf 34/52
7/21/2019 MCA-I SEM - MCA1610-Prog Lab-I-Office Automation Tools-Lab Manual.pdf

http://slidepdf.com/reader/full/mca-i-sem-mca1610-prog-lab-i-office-automation-tools-lab-manualpdf 35/52
36/52
 PROCEDURE:-

Step 1: start → program→MS-

Office2007 → MS-Word.

Step 2: Go to office button →

New.

Step 3: Type the name of the

equation.
S
t
e
p
4
:

G
o
t
o
i
n
s
e
r
t
→
Result:- E
Thus the external data are imported, sorted & q
filtered. u
a
t
i
8. TO CREATE A DOCUMENT FOR TYPE THE o
MATHEMATICAL EQUATION IN MS-WORD.
n
→
i
AIM:-
n
To create a document for type the mathematical s
equation in MS-Word.
ert new
equation. Step
5: Go to insert
→ object .

Step 6: From object submenu, select Microsoft

equation 3.0 and click ok.

Step 7: Then by using the equation tool, type the

following mathematical equations.
Step 8: Save the document.
 SAMPLE OUTPUT:-

RESULT:-

Thus the above document is created using mathematical equation editor and
verified.
 9. SLIDE SHOW PRESENTATION

AIM:

To create a presentation in different ways.

PROCEDURE:

a. Auto Content Wizard

The wizard asks a simple question and helps you to determine the organization
of your chart.

b. Pick a Look Wizard

It helps you to choose the look and feel of your presentation. For example we
can select,

if you want to create the presentation for black and white transparencies, color
transparencies, 35mm slides or on screen presentations. You also select the slide
background and other options, such as speaker notes, audience handouts etc. that you want
to include in your presentation.

c. Templates
It creates a presentation based on existing template that determines the color
scheme

fonts and other design feature of the presentation.

d. Blank Presentation
It starts with a blank presentation with all values of the color scheme fonts and
other design feature set to the default values.
SAMPLE OUTPUT:

RESULT:

Thus we know how to create a presentation in different ways.

 10. POWER POINT WITH DIFFERENT CHART

Aim:

To Create a chart or graph in a presentation using ms-PowerPoint.

Procedure:

1. Create a new presentation in PowerPoint, or open an existing presentation.

2. When you insert a new slide in PowerPoint, it uses the default Title Slide layout.

3. Click the Layout button/option in the Home tab of the Ribbon to bring up the Layout
gallery as shown in Figure 1.

Select any of the layouts that include a content placeholder (the small palette like collection of
multicolored buttons visible on some of the slide layouts).

Figure 1: Layout gallery

 If your slide layout has a content placeholder (see Figure 2), click the Chart button among
the six buttons.

Figure 2: Content Placeholder

4. Alternatively, if you want to insert a chart in an existing slide that has no content
placeholder, just select the Insert tab of the Ribbon, and click the Chart button, as shown in
Figure 3.

Figure 3: Insert Chart

5. Either of these options opens the Insert Chart dialog box that you can see in Figure 4.
Figure 4: Insert Chart dialog box

The left column lists the types of charts that you can create in PowerPoint -- and the area
towards the right shows several chart possibilities using a selected chart type.

Select a particular chart variant -- if you can't find the chart variant you want, just choose
something similar to the one you want (editing it later is easy). Click OK.

6. This will place a chart on the slide that is based on dummy data. At the same time, this
launches Microsoft Excel in a separate window as shown in Figure 5, containing the dummy
data of the chart.

Figure 5: Chart and Excel with default values

Note: If you don't have Excel 2010 installed on the same system as PowerPoint 2010, then
you'll see Microsoft Graph instead of Microsoft Excel -- this works exactly the same way as
in versions 2002 and 2003 of PowerPoint -- look here...

1. You now need to replace the dummy data in the Excel sheet with your own data. Follow
these guidelines:

a. Select a cell in the Excel sheet, and enter the new value.

b. You can move to the cell towards the right in the Excel sheet by pressing the tab
button. Or move to cell down by pressing the Enter (Return) key.

c. To insert a new column in the Excel sheet, right-click the header of the next column
and choose the Insert option.

d. To insert a new row in the Excel sheet, right-click the header of the next row and
choose the Insert option. Remember, column or row content inserted this way ends
up as a new series value in your chart.

e. You can also delete columns and rows -- just select the row or column header, right-
click, and choose the Delete option.

2. Refer to Figure 5 above which has default chart values; the changed values can be seen
in Figure 6.

If you can't see the values in Figure 5 because they are so small in size, just trust me
when I say the values were different from what you see in Figure 6!

Figure 6: Changed values

3. Any changes you make in the Excel sheet (refer to Figure 6 above) will reflect as
changes on the chart within PowerPoint, as shown in Figure 7.
 Figure 7: Updated chart in PowerPoint

10. Close Microsoft Excel to apply those changes on the chart (see Figure 8).

Figure 8: Inserted Chart

11. To make more changes, select the chart so that the Ribbon area shows the Chart Tools
Design tab as shown in Figure 9. Now click the Edit Data button -- this opens the Excel
sheet again, where further changes in the values can be made.
 Figure 9: Edit data

Tip: You can also right-click the chart, and choose the Edit Data option to achieve the same
result.

Result

Thus the PowerPoint presentation has been successfully created with different charts.