COMPUTER FUNDAMENTALS AND OFFICE

AUTOMATION LAB MANUAL

 MS-WORD
Practical -1
1. AIM OF THE ACTIVITY
This activity is to create a newspaper document with heading along
with set of margins.
2. PRE-REQUISITE KNOWLEDGE
Operation of computer with ms-word basic knowledge.
3. MATERIALS REQUIRED
A computer system installed with MS-OFFICE software along with
power supply
4. PROCEDURE
a. First set the margin as given there.
b. Type heading Gandhi jayanti with its font size. Then type contents
of it.
c. Use drop command.
d. Select the picture of Gandhi and paste it.
e. Then set the size of the picture.
f. Then drag the picture to the right portion of parahraph.
g. By right click at picture option go to text wrapping & then click at
square option.
h. Now type computer basics at the center of next line & paste its
content below it.
i. BY using page layout option now you can make three columns.
5. OBSERVATIONS
A newspaper document is created along with paragraph & column.
6. WHAT WE HAVE LEARNT ?/CONCLUSION
From this activity we learnt about to create newspaper document as
we see various newspapers in our daily life.
 Practical -2

1. AIM OF THE ACTIVITY

Creating a flowchart using shapes like ellipse, arrows,rectangle &
parallelogram & grouping them and inserting table.
2. PRE-REQUISITE KNOWLEDGE
Operation of computer with MS-word basic knowledge
3. MATERIALS REQUIRED
A computer system installed with MS-OFFICE software along with
power supply
4. PROCEDURE
a. Insert various shapes as given above one below another using
insert tab
b. Then use arrow shape to connect various shapes.
c. Now we can group various shapes by selecting them into one
single object
5. OBSERVATIONS
Flowcharts of various shapes & making all shapes into a single object
6. WHAT WE HAVE LEARNT/CONCLUSION
From this activity we learnt about various shapes, drawing flowcharts
as per our requirement.
 Practical -3
1. AIM OF THE ACTIVITY
To create front page of a practical file.
2. PRE-REQUISITE KNOWLEDGE
Operation of computer with MS-word basic knowledge
3. MATERIALS REQUIRED
A computer system installed with MS-OFFICE software along with
power supply
4. PROCEDURE
a. Insert logos and write content.
b. Use formatting option.

c. Insert border.
 Practical-4

1. AIM OF THE ACTIVITY

Writing a letter using mail merge wizard.
2. PRE-REQUISITE KNOWLEDGE
Operation of computer with MS-word basic knowledge as well as
topic to write.
2. MATERIALS REQUIRED
A computer system installed with MS-OFFICE software along with
power supply
3. PROCEDURE
a.Go to mailing
b.Step by Step mail merge wizard
c.Go letters
d.Start from a template, select template
e.Go to letters
b.Select proper template, Create new document then click OK
4. OBSERVATIONS
Letter document is created using mail-merge.
5. WHAT WE HAVE LEARNT/CONCLUSION
From the above, we have learnt to design letter mail-merge.
 Practical -5

1. AIM OF THE ACTIVITY

This activity to create a power-point presentation with 5 slides with the given
data.
2. PRE-REQUISITE KNOWLEDGE
Operation of computer with ms-powerpoint basic knowledge.
3. MATERIALS REQUIRED
A computer system installed with MS-OFFICE software along with power supply
4. PROCEDURE
a.First set the titles and subtitles based the topics with the suitable font style, size,
and color in first slide.
b. As given you must choose a topic of your own which must cover up 5 slides.
c. Write and design all your slides perfectly and make it ready to show.
d. At last place a ‘thank you’ slide so as to end your presentation.
5. OBSERVATIONS
A Presentation with 5 slides is created using power-point
6. WHAT WE HAVE LEARNT/CONCLUSION
From the above we have learnt how to create a power-point
presentation of 5 slides.
 Practical -6

1. AIM OF THE ACTIVITY

This activity to create a table “Student Result” with some conditions
2. PRE-REQUISITE KNOWLEDGE
Operation of computer with ms-excel basic knowledge.
3. MATERIALS REQUIRED
A computer system installed with MS-OFFICE software along with power supply
4. PROCEDURE
a. First insert a table in the Excel Sheet by the insert tab so that you can
write the student’s information.
b.Now, give the headings – SL NO, Name, Mark 1, Mark 2, Mark 3, Total
etc.
c. Fill up the data in the columns you have to enter.
d.Calculate the sum of the marks of each student via ‘Auto sum’ option.
e.Highlight the highest total mark in green color and lowest one in red
color.
f.Find the average of the marks of each student in an individual cell.

5. OBSERVATIONS
A table is created using excel with some conditions
6. WHAT WE HAVE LEARNT/CONCLUSION
From the above we have learnt how to create table using excel.
 Practical -7

1. AIM OF THE ACTIVITY

This activity to create a table “Sales” with some data provided
2. PRE-REQUISITE KNOWLEDGE
Operation of computer with ms-excel basic knowledge.
3. MATERIALS REQUIRED
A computer system installed with MS-OFFICE software along with power supply
4. PROCEDURE
a. Create a table using five columns & four rows.
b. Enter the data given as provided
c. Go to insert tab, in charts groups, you just have to select the specified
charts as given in no. a, b, and c.
d. Set a new rule for highlighting the sales which are greater than or
equal to 1000
e.To do so, go to conditional tab. There, click more rules option. There

you can change all the necessary options.

5. OBSERVATIONS
A table is created using excel with given data.
6. WHAT WE HAVE LEARNT/CONCLUSION
From the above we have learnt how to create sales table.
 Practical-8

1. AIM OF THE ACTIVITY

This activity to apply various functions on data.
2. PRE-REQUISITE KNOWLEDGE

Operation of computer with ms-excel basic knowledge.

3. MATERIALS REQUIRED

A computer system installed with MS-OFFICE software along with power supply
4. PROCEDURE

=AVERAGE Calculates the average (arithmetic mean)

=AVERAGEIF Calculates the average of a range based on a TRUE or FALSE condition

=AVERAGEIFS Calculates the average of a range based on one or more TRUE/FALSE conditio

COUNT Counts cells with numbers in a range

=COUNTA Counts all cells in a range that has values, both numbers and letters

=COUNTBLANK Counts blank cells in a range

=COUNTIF Counts cells as specified

=COUNTIFS Counts cells in a range based on one or more TRUE or FALSE condition

=IF Returns values based on a TRUE or FALSE condition

 =IFS Returns values based on one or more TRUE or FALSE conditions

=MAX Returns the highest value in a range

=MEDIAN Returns the middle value in the data

=MIN Returns the lowest value in a range

=SUM Adds together numbers in a range

=SUMIF Calculates the sum of values in a range based on a TRUE or FALSE condition

=SUMIFS Calculates the sum of a range based on one or more TRUE or FALSE condition

=TRIM Removes irregular spacing, leaving one space between each value

=VLOOKUP Allows vertical searches for values in a table

=LOWER Reformats content to lowercase

=CONCAT Links together the content of multiple cells

 Practical-9
 ls --- lists your files
mv filename1 filename2 --- moves a file (i.e. gives
it a different name, or moves it into a different
directory (see below)
 cp filename1 filename2 --- copies a file
 rm filename --- removes a file. It is wise to use the option rm -i, which will ask you for
confirmation before actually deleting anything. You can make this your default by making
an alias in your .cshrc file.
 diff filename1 filename2 --- compares files, and shows where they differ
 wc filename --- tells you how many lines, words, and characters there are in a file
 chmod options filename --- lets you change the read, write, and execute permissions on
your files. The default is that only you can look at them and change them, but you may
sometimes want to change these permissions. For example, chmod o+r filename will make
the file readable for everyone, and chmod o-r filename will make it unreadable for others
again.
 mkdir dirname --- make a new directory
 cd dirname --- change directory. You basically 'go' to another directory, and you will see the
files in that directory when you do 'ls'. You always start out in your 'home directory', and
you can get back there by typing 'cd' without arguments. 'cd ..' will get you one level up
from your current position. You don't have to walk along step by step - you can make big
leaps or avoid walking around by specifying pathnames.
 pwd --- tells you where you currently are.
 date --- shows the current date and time.
 cal --- shows a calendar of the current month.
 cat