DEPARTMENT OF B.COM.

(COMPUTER APPLICATION)
I YEAR [2020-2023 Batch]

19UCCP01- Computer Practical - I

(MS-Office)

PRACTICAL RECORD

Name : _______________
Register Number: _______________

ACADEMIC YEAR: 2020 – 2021

1
This is to Certify that the Practical Record “19UCCP01 - Computer

Practical – I (MS-Office)” is a bona-fide work done by

_____________________________ Reg.No. ______________ submitted to the

Department of Computer Applications, during the academic year

2020 - 2021.

SUBJECT IN-CHARGE HEAD OF THE DEPARTMENT

Submitted for University Practical Examination held on

INTERNAL EXAMINER EXTERNAL EXAMINER

2
 INDEX

Page Marks
S.No. Date Title Signature
No. Awarded

STARTINGMS-WORD,CREATING,
1. 04.03.2021 SAVING, PRINTING (WITH 6
OPTIONS),CLOSING ANDEXITING

2. 04.03.2021 STUDY OF WORD –MENU / TOOLBARS 9

CREATING,SAVING AND EDITING THE

3. 09.03.2021 10
DOCUMENT

4. 11.03.2021 FORMATTING A DOCUMENT 14

USING TAP SETTINGS ENHANCING THE

5. 16.03.2021 21
DOCUMENTS

6. 18.03.2021 CREATING TABLES IN A DOCUMENT 27

7. 08.04.2021 CREATING MAILING 30

CREATING AND FORMATTING THE

8. 10.04.2021 35
WORKSHEET IN MS -EXCEL

DATABASE CONCEPT (SORTING) - MS -

9. 15.04.2021 37
EXCEL

DATA FILTERING USING AUTO FILTER,

10. 20.04.2021 39
ADVANCED FILTER

CREATING SUBTOTALS AND GRAD

11. 04.05.2021 TOTALS- USING DATABASE 41
FUNCTIONS

12. 06.05.2021 CREATING CHARTS IN MS EXCEL 43

13. 11.05.2021 FUNCTIONS IN MS EXCEL 45

14. 20.05.2021 MACROS 49

CREATING A PRESENTATION USING

15. 25.05.2021 51
AUTO CONTENT WIZARD

3
 Page Marks
S.No. Date Title Signature
No. Awarded

DIFFERENT VIEWS IN POWERPOINT

16. 27.05.2021 55
PRESENTATION

SETTING ANIMATION EFFECTS/

17. 08.06.2021 GROUPING / UNGROUPING / CROPPING 59
POWER/ POINT OBJECTS

PRINTING A PRESENTATION /
18. 10.06.2021 63
IMPORTING – EXPORTING FILES

CREATING AN ORGANISATION CHART

19. 15.06.2021 65
IN POWER POINT

CREATE AN EMPLOYEE DATABSE

20. 17.06.2021 69
USING MS-ACCESS

CREATE MAILING LABELS USING MS-

21. 22.06.2021 71
ACCESS

CREATE A FORMS FOR THE STUDENT

22. 29.06.2021 73
DATABASE

CREATE A REPORT FOR THE

23. 01.07.2021 75
EMPLOYEE DATABASE

4
MS-WROD

5
 EX:NO:01 (a) STARTINGMS-WORD,CREATING, SAVING, PRINTING
(WITH OPTIONS),CLOSING ANDEXITING
DATE: 04.03.2021

Aim:

Creating, saving, printing, closing and existing a new word document using ms-word.

Procedure:

Creating document:

 Select the new option from menu from menu bar

 Select the general tab in the New Dialog box
 Select the Blank Document icon
 Click ok.

Save a document:

 Select the save option from the file menu.

 Type the file name by which you wish to Save your file.
 Click ok.

Printing the document:

 Select the print option from the file menu.

 Choose no. of copies and page number.
 Click ok.

Closing and Existing document:

 Select the close option from the file menu to close the active document.
 Select the exit from the file menu to end your MS Word session.

6
Output:

Result:
Thus the above MS-Word document created successfully.

7
 EX:NO:01 (b) STUDY OF WORD –MENU / TOOLBARS
DATE: 04.03.2021

Aim:

To study about the Menus/Toolbars in MS-Word document.

Procedure:

 Select the file menu and choose .

 File Menu - File-related commands to open, save, close, print, and create new
files
 Edit Menu - Commands to copy, cut, paste, find, and replace text in a document
 View Menu - Commands to change how the document is displayed on the screen
 Insert Menu - Lists items that you can insert into a document
 Format Menu - Commands to format text, paragraphs
 Tools Menu - Lists tools such as the Thesaurus and Word Count
 Table Menu - Table-related commands
 Window Menu - Commands to display multiple windows
 Help Menu - Get help on using Microsoft Word

Output:

8
Result:
Thus Menus/Toolbars in MS-Word document has been successfully analysed.
9
 EX:NO: 02 (a) CREATING,SAVING AND EDITING THE DOCUMENT
DATE: 09.03.2021

Aim:

Creating, saving , editing a new word document using ms-word.

Procedure:

Creating document:

 Select the new option from menu from menu bar

 Select the general tab in the New Dialog box
 Select the Blank Document icon
 Click ok.

Save a document:

 Select the save option from the file menu.

 Type the file name by which you wish to Save your file.
 Click ok.

Editing the document:

 Create a document and edit the document.

 Find and replace option.
 Cut, copy and paste option.
 Undo and Redo option.

1.(i). a .Cut:

Cut the section to the clip board the step to cut the text are

 Select the text you want to copy

 Select the cut command from the edit menu or press the ctrl+x key
 The selected text is cut to the clipboard and original will be erased

Copy:

Copies the selection to the dipborad the steps to copy the text are

 Select the text you want to copy

 Select the copy copy command from the edit menu or press the
ctrl+c key

10
  The selected text is copied to the clipboard

Paste:
Paste the selected portion from the clipborad to the desired location
 Place the cursor where you want to paste tee copied text.
 Select the paste command from the edit menu or ctrl+v key
 The selected text is paste in the desired lacation.

b. Find and replace:

Searches for specified text, formatting symbols and commands in the active a
document

Steps:

 Select find option from the edit menu or press ctrl+f keys.
 Find and replace box is displayed.
 Type search word I the find what dialog box.
 Click find next button in the find dialog box
And the next word is pointed by cursor.
Repeat step4 until search completes

c. undo text:
The undo option is used to reverse the last performed action on the document the steps to
undo to the last performed action is.
 Select the undo option from the standard toolbar or press ctrl+z key to undo

Redo text:
The redo option is used to reverse last action select the redo option from the edit menu or
click redo button from standard toolbar or press ctrl +y key to redo

11
Output:

TEXT

Pradeep ram am the same Gandhi as I was in 1920.Ihave not changed in any
fundamental respect .I attach the same importance to non-violence that I did then. if at
all, my emphasis on it has grown stronger.

FIND THE TEXT:

Find the word –Pradeep ram

REPLACE THE TEXT:

Replace the word –I

I am the same Gandhi as I was in 1920.

12
SAMPLE TEXT:

Pradeep ram am the same Gandhi as I was in 1920.Ihave not changed in any
fundamental respect .I attach the same importance to non-violence that I did then. if at
all, my emphasis on it has grown stronger.

CUT, COPY, PASTE TEXT:

Pradeep ram am the same Gandhi as I was in 1920.I have not changed in any
fundamental respect

UNDO, REDO TEXT

Undo – same line to Bold

Redo – change the word (same) Bold in to Normal

Pradeep ram am the same Gandhi as I was in 1920.Ihave not

changed in any fundamental respect

Closing a document:

 Select exit option from file menu.

Result:
Thus the above ms-word document edited successfully.
13
 EX:NO: 02 (b) FORMATTING A DOCUMENT
DATE: 11.03.2021

Aim:
Write a procedure to format a document using bold, italic and underline.

Procedure:
a. Bold,Italic,Underline:

Bold:
 Select the text to format.
 Click bold icon button From the formatting toolbar or press ctr+B.

Italic:

 Select the text to format.

 Click Italic icon from the Formatting toolbar or press ctrl+I.

Under line:

 Select the text format.

 Click underline icon from the Formatting toolbar or Press ctrl+U.
 To change the character size using Font Dialog Box are.
 Select the Font option from the Format menu the font Dialog Box is displayed.
 Select the required Font size from the size full down list box.
 Click ok to apply the format.

b. Changing character size in the font dialog box:

 To change the font style, click the arrow next to the font style in the ribbon at the top
of your document.
 Choose your font style from the drop-down list given.
 Click on the ‘Font’ arrow just above the main screen.
 A dialogue box will pop up. In this, choose your font size and style from the options.

c. FORMATTING PARAGRAPH:

Aligning Text:

Alignment is a way of organizing the text. It refers to the margins word enables to left,
right, center alignments.

14
Left Align:

Alignment is a way of organizing the text It refers to the position the text of the margins
word enables to Left, right, center alignments.

 Select the paragraph which you want to apply Left align.

 Click align Left button formatting tool bar or press ctrl+L.

Right Align:

A text is said to be right aligned with the margin of the page the step are.

 Select the paragraph which you want to apply right align.

 Click align Right button from the formatting toolbar or press ctrl+R.

Center Align:

A text is said to be center aligned if it is aligned with the center margin of the page.

 Select the paragraph which you want to apply align.

 Click align center button from the formatting toolbar or press ctrl+E.

Justify:

A text is said to be justified, if the text has straight edges on both sides of the paragraph

 Select the paragraph which you want to apply align.

 Click justify button from the formatting toolbar or press ctrl+J

d. Paragraph and Line Spacing:

Changing paragraph and line spacing:

 Select the text you want to format. Selecting text to format.

 On the Home tab, click the Line and Paragraph Spacing command. A drop-down
menu will appear.
 Select size from the various options.
 The line spacing will change in the document.

Bullets and numbering:

 High light the text.

 Choose bullets and numbering command from format menu.

15
Bullets and numbering:

Bullets numbering outline numbered list style.

Re start numbering continue ok cancel.

 Choose the numbered tab from the bullets and number Dialog box.
 Choose the pattern you which to apply by clicking anywhere inside the pattern
box.
 Click ok.

Bullets:

 High light the text.

 Choose the Bullets and numbering command form format menu.
 Choose the Bullets tab from the bullets and number Dialog box.
 Choose the pattern you which to apply by clicking any where inside the pattern
Box.
 Click ok.

Paragraph indent and line spacing:

Open the Paragraph dialog box and click the Indents and Spacing tab.

 Select one paragraph or a group of paragraphs that you want to adjust.

 Click the Paragraph dialog box launcher on the Page Layout or Layout tab.
 If necessary, choose the Indents and Spacing tab.
 Choose your settings, and then choose OK.

e. Hanging Paragraphs:

Creating hanging paragraphs:

 Place your cursor at the beginning of your second line, before any text.
 Right click your mouse.
 Select Paragraph from the resulting popup menu.
 Under Indentation, use the Special pull-down menu to select hanging.

Format painter and auto format:

 Highlight the text that has the format you want to copy.
 Click the Format Painter button in the Clipboard Group on the Home tab on the
Ribbon.
o It’s the button that looks like a paintbrush.
 Click and drag the cursor over the text you want to copy the format to.
o Word formats the new text to look just like the already formatted text.
16
Auto format:

Word does things like changing your quotes to Smart Quotes, automatically creating bulleted
and numbered lists, and changing the indentation of paragraphs.

 Load the document you want to format.

 Choose AutoFormat from the Format menu. Word displays the AutoFormat dialog
box.
 Use the radio buttons to indicate if you want AutoFormat to work without stopping
for your input, or not.
 Click on OK.

Output:

SAMPLE TEXT:

Gandhi most intensive reading was done during his student days in London and
his “barrister” days in South Africa. Gandhi’s reading, for the most part, had been
confined to character buildings writings, religious, philosophical, and literary .The
Bhagavad-Gita and the Sermon on the Mount he had read in London.

a. BOLD,ITALIC,UNDERLINE STYLE

BOLD STYLE

Gandhi most intensive reading was done during his student days in
London and his “barrister” days in South Africa

ITALIC STYLE

Gandhi most intensive reading was done during his student days in
London and his “barrister” days in South Africa

UNDERLINE STYLE

Gandhi most intensive reading was done during his student days in
London and his “barrister” days in South Africa

17
 b. CHANGE CHARACTER SIZE

Text

Gandhi most intensive reading was done during his student days in London and
his “barrister” days in South Africa.

USING FONT DAILOG BOX

Gandhi most intensive reading was done during his student days in
London and his “barrister” days in South Africa.
c. FORMATTING PARAGRAPH

TEXT

Gandhi most intensive reading was done during his student days in London and his
“barrister” days in South Africa. Gandhi’s reading, for the most part, had been
confined to character buildings writings, religious, philosophical, and literary .The
Bhagavad Gita and the Sermon on the Mount he had read in London.

CENTRE ALIGNMENT

Gandhi most intensive reading was done during his student days in London and his
“barrister” days in South Africa. Gandhi’s reading, for the most part, had been
confined to character buildings writings, religious, philosophical, and literary .The
Bhagavad Gita and the Sermon on the Mount he had read in London.

RIGHT ALIGNMENT

Gandhi most intensive reading was done during his student days in London and his
“barrister” days in South Africa. Gandhi’s reading, for the most part, had been
confined to character buildings writings, religious, philosophical, and literary .The
Bhagavad Gita and the Sermon on the Mount he had read in London.

LEFT ALIGNMENT

Gandhi most intensive reading was done during his student days in London and
his “barrister” days in South Africa. Gandhi’s reading, for the most part, had been
confined to character buildings writings, religious, philosophical, and literary .The
Bhagavad Gita and the Sermon on the Mount he had read in London.

18
CHANGING PARAGRAPH MARGINS

Gandhi most intensive reading was done during his student days
in London and his “barrister” days in South Africa. Gandhi’s reading,
for the most part, had been confined to character buildings writings,
religious, philosophical, and literary .The Bhagavad Gita and the
Sermon on the Mount he had read in London.

CHANGING SPACE BEFORE AND AFTER PARAGRAPH

Gandhi most intensive reading was done during his student days in London and
his “barrister” days in South Africa. Gandhi’s reading, for the most part, had been
confined to character buildings writings, religious, philosophical, and literary .The
Bhagavad Gita and the Sermon on the Mount he had read in London.
d. CHANGING LINE SPACING IN A PARAGRAPH

Gandhi most intensive reading was done during his student days in London and his

“barrister” days in South Africa. Gandhi’s reading, for the most part, had been

confined to character buildings writings, religious, philosophical, and literary .The

Bhagavad Gita and the Sermon on the Mount he had read in London.

BULLETS IN PRAGRAPH

 Gandhi most intensive reading was done during his student days in London and
his “barrister” days in South Africa. Gandhi’s reading, for the most part, had
been confined to character buildings writings, religious, philosophical, and
literary.

 The Bhagavad Gita and the Sermon on the Mount he had read in London.

(or)

 Gandhi most intensive reading was done during his student days in London and
his “barrister” days in South Africa. Gandhi’s reading, for the most part, had
been confined to character buildings writings, religious, philosophical, and
literary.

 The Bhagavad Gita and the Sermon on the Mount he had read in London.
19
NUMBERING IN PARAGRAPH:

i. Gandhi most intensive reading was done during his student days in London and
his “barrister” days in South Africa. Gandhi’s reading, for the most part, had
been confined to character buildings writings, religious, philosophical, and
literary.

ii. The Bhagavad Gita and the Sermon on the Mount he had read in London.

(or)

A. Gandhi most intensive reading was done during his student days in London and
his “barrister” days in South Africa. Gandhi’s reading, for the most part, had
been confined to character buildings writings, religious, philosophical, and
literary.

B. The Bhagavad Gita and the Sermon on the Mount he had read in London.

e. CREATING HANGING PARAGRAPH:

Gandhi most intensive reading was done during his student days in

London and his “barrister” days in South Africa. Gandhi’s

reading, for the most part, had been confined to character

buildings writings, religious, philosophical, and literary .The

Bhagavad Gita and the Sermon on the Mount he had read in

London.

Result:

Thus the above Ms-word Document formatted successfully.

20
 EX:NO: 03 USING TAP SETTINGS ENHANCING THE DOCUMENTS
DATE: 16.03.2021

Aim:

To enhance the document using ms-word using of header and footer, page setup, borders,
orientation, print preview.

Procedure:

 Press word to create a new document

 Type specified word to the next tap key to move cursor to the next tab position
then type the remaining text.
 Press the text word in the same order
 These are the ways to use tap settings.
 Left aligned tab.
 Right aligned tab.
 Centre aligned tab.
 Decimal tab.
 Select the required tab in the ruler box.
 Click the mouse pointer all required the position in ruler bar.
 Select the desired tab alignment.
 Then click the set button.
 Press the ok button to close the tabs they dialog box word align the text to their
corresponding position.

Header and footer in the document:

 Type the required text.

 It contains a required border.
 Select the header and footer command from the view menu.
 Word display the header and footer toolbar.
 Click the current page no, date, time and the header and footer toolbar.
 Word in sets the current page number date time on the header and footer toolbar.

Page Setup:

 Type the text

 Select the page setup command from the file menu word display the page setup
the command from the tab dialog box.
 If contains, left, right, button tab, text box.
21
  Click the drop down arrow on the special dialog box.
 Word changes alignment.
 Select the toolbar command from the view menu. Word display the border to the
select text word closes the toolbar dialog box and opens the border toolbar

Border

 Type the required text.

 Click on the Page Layout menu.
 Select the Page Background tab.
 Click on the Page Borders option then it displays Borders and Shading dialog box.
 Click on Borders tab in dialog box and choose the border type which want to apply to
the document.
 Close the dialog box.

Page Number

 Type the required text.

 Select the pages to insert the page number.
 Choose Page Number option from Insert Menu.
 Select the type of page number from the drop down arrow in which you want to
display either at the top of the page or bottom of the page.

Orientation

 Type the required text.

 Choose the page which you want to apply orientation.
 Click on Page Layout menu.
 Selectorientation option from Page Setup tab.
 Choose Portrait or Landscape option as you want from the drop down arrow.
 Apply the selected orientation option to the selected document.

Print preview:

 Type the required text.

 Click the print preview button on the standard toolbar.
 Select the print preview command from the file menu.
 Click the multiple page button touch button on the toolbar.
 Word display the window and then close the number of page.

22
OUTPUT:

Header and Footer:

Page Setup:

23
Page Number:

Page Border:

24
Orientation:

25
Print Preview:

Result:

Thus the document is enhanced using of header and footer, page setup, borders,
orientation, watermarking, print preview.

26
 EX:NO: 04 CREATING TABLES IN A DOCUMENT
DATE: 18.03.2021

Aim:

To Create tables in a document, Selecting Rows, Column and sorting the record in the word
document.

Procedure:

Creation of Tables:

 Click the Insert tab on the Ribbon

 Click the Table button
 Select Insert Table
 Click the arrows to select the desired number of columns
 Click the arrows to select the desired number of rows
 Click OK
 Save a document.

To Insert a Row, Column:

 Position the cursor in the table where you would like to insert a row
 Select the Layout tab on the Ribbon
 Click either the Insert Row Above or the Insert Row Below button in the Rows &
Columns group
 Position the cursor in the table where you would like to insert a column
 Select the Layout tab on the Ribbon
 Click either the Insert Columns to Left button or the Insert Columns to Right button in
the Rows & Columns group
To Delete a Row, Column:
 Position your cursor in the row that you would like to delete
 Select the Layout tab on the Ribbon
 Click the Delete button in the Rows & Column group
 Select Delete Rows
 Position your cursor in the column that you would like to delete
 Select the Layout tab on the Ribbon
 Click the Delete button in the Rows & Column group
 Select Delete Columns

27
To Sort Data in a Table:
 Select the list you want to sort.
 Go to Home > Sort.
 Set Sort by to Paragraphs and Text.
 Choose Ascending (A to Z) or Descending (Z to A).
 Select OK.

OUTPUT:

CREATION OF TABLES WITH ROWS AND COLUMNS:

BCA STUDENT DETAILS:

REG.NO NAMES AGE

1001 ABI 19
1002 SARAN 21
1003 RAMYA 18
1005 CHARAN 20

BCA STUDENT DETAILS: (BEFORE SORTING)

REG.NO NAMES AGE

1001 ABI 19
1002 SARAN 21
1003 RAMYA 18
1005 CHARAN 20

BCA STUDENT DETAILS: (AFTER SORTING - ASCENDING)

REG.NO NAMES AGE

1001 ABI 19
1005 CHARAN 20
1003 RAMYA 18
1002 SARAN 21

28
BCA STUDENT DETAILS: (AFTER SORTING - DESCENDING)

REG.NO NAMES AGE

1002 SARAN 21
1003 RAMYA 18
1005 CHARAN 20
1001 ABI 19

Result:

Thus the Tables has been created with Rows, Column and record has been sorted in
the word document.

29
 EX:NO: 05 CREATING MAILING
DATE: 08.04.2021

Aim:

Drawing flow chart using (creating main document, data source, inserting merge
fields and viewing merge data, viewing and printing merged letter, using mail merge to print
envelope creating mailing labels).

Procedure:

1. Creating the Main Document

 Open a new file in Word and enter text that will comprise the letter.
 Add any special formatting to the letter. For example, change the font and size or
make some text Bold or Italicized.
 Click the Save button on the Standard toolbar to open the Save As dialog box,
give the form letter a name, and then click Save.

2. Creating Data Source

 Select Mail Merge from Tools menu.

 This opens the Mail Merge Helper dialog box
 Click the Create button under the Main Document heading
 Click the Get Data button under the Data source heading
 Choose a Create data source option from the drop-down list
 To add records click the Edit Data Source button
 A Data Form opens and enters the text for each first field
 Use the Tab key to move from field to field
 Click the Add New button to continue adding records to your database
 Add, Delete, Restore, Find and View options are available
 Click OK when you are finished entering all the records

3. Merge Fields

 Click in the form letter where you want a field inserted.

 Click the Insert Merge Field drop-down list on the Mail-Merge toolbar.
 Choose fields one at a time to add to the form letter.
 Open the Mail Merge Help by going to Tools/Mail Merge…
 Click Merge

30
 Word merges the form letter with the fields and creates an individual letter for
each record in the data source.
 Print the letters now or save the merge, open the File menu and select Save As.

31
Output

1. Creating the Main Document

To:
«FirstName» «Lastname»
«Address»
«City»
«postal»

Dear «FirstName»:

Re: Temporary Appointment, «EmplClass» «Dept»

You can work here for a little while in a temporary position.

I am pleased to advise you can start on 18.04.2021. Your appointment will be established as a
«EmplClass», at the salary of «CompRate».

Yours truly,

2. Creating Data Source

Firsname Lastname Address City Postal EmplClass Dept CompRate

23/3, Anna Sr.
John Peter Nagar, Chennai 600001 Accountant Accounts 35000
87, Avenue
Anitha C Apartment, Salem 636004 Manager HR 35000

3. Merge Fields
To:
John Peter
23/3, Anna Nagar,
Chennai,
600001

Dear John:

Re: Temporary Appointment, Sr. Accountant, Accounts

You can work here for a little while in a temporary position.

I am pleased to advise you can start on 18.04.2021. Your appointment will be established as a
, Sr. Accountant , at the salary of 35000.

Yours truly,

32
To:
Anitha C
87, Avenue Apartment,
Salem,
636004.

Dear Anitha:

Re: Temporary Appointment, Manager, HR

You can work here for a little while in a temporary position.

I am pleased to advise you can start on 18.04.2021. Your appointment will be established as a
Manager, at the salary of 35000.

Yours truly,

Result

Thus the above mail merge is created successfully

33
MS-EXCEL

34
 EX:NO: 01 CREATING AND FORMATTING THE WORKSHEET IN
MS -EXCEL
DATE: 10.04.2021

Aim:

Create a worksheet and apply various formatting options like bold, italic, border etc.

Procedure:

Click Excel Icon from the MS Office Toolbar.

 Click File-> New

 Change the Column Width
 To select the entire column
 Choose AutoFit Selection from Column command from Format Menu.
 Specify the desired column width and Click OK

Series Fill

 Choose Series from Fill command from Edit menu.

 Choose the series type, step value, stop value.
 Click once on OK button.

Formatting Cells

 Choose Cells command from Format menu

 Choose Number Folio
 Choose Number from Category list and Specify 2 decimal places
 Choose Font Folio and choose the desired font.
 Choose the font style, bold, italic underline etc and click OK.

Print

 Choose File -> print

 Choose print preview command and click here to print portrait or landscape.
 Click on margins folio and specify the top, bottom, left, right, header and footer
margin.
 Click Ok.

35
Output (convert into excel format)

Result

Thus the above worksheet is created and formatted.

36
 EX:NO: 02
(a) DATABASE CONCEPT (SORTING) - MS -EXCEL
DATE: 15.04.2021

Aim:

To create a database, record field, filed name, sort a data base and maintaining a
database (data form).

Procedure:

 Select Form option from Data menu

 Data Form has automatically converted the first row of table into a database
structure and the next row into the first record.
 Travel up and down in the database using this scroll bar.
 Click to Add a new record
 Click to Delete the current record
 Click restore the previously deleted record
 Click to go to previous and next record
 Click to Close Data Form window

Data Sorting

 Highlight the range of data

 Choose sort command from data menu
 Choose the specify column and choose the Ascending/Descending Order radio
button
 To quick sort in ascending order, click (Sort A to Z)
 To quick sort in descending order, click (Sort Z to A)
 Click on OK to execute the data sort command

37
Output

Result

Thus the above database is created and sorted.

38
 EX:NO: 02 (b) DATA FILTERING USING AUTO FILTER, ADVANCED
FILTER
DATE: 20.04.2021

Aim:

To apply the data filtering using auto filter and advanced filter.

Procedure:

Auto Filtering

 Click File -> New to open new worksheet

 Select Sort & Filter from the Data tab
 Click the Filter command
 Drop-down arrows will appear in the header of each column.
 Click the drop-down arrow for the column you want to filter.
 The Filter menu appears.
 Check the boxes next to the data you do want to view.
 Click OK. All other data will be filtered, or temporarily hidden.
 To clear a filter Choose Clear Filter From.

Advanced filtering

 Click File -> New to open new worksheet

 From the Data tab, click the Filter command.
 Click the drop-down arrow in the column you want to filter.
 Enter the data you want to view in the Search box.
 Check the boxes next to the data you want to display.
 Choose Text Filters to open the advanced filtering menu.
 The Custom AutoFilter dialog box appears.
 Enter your text to the right of your filter.
 Click OK. The data will be filtered according to the search term or the text you
specified.

39
Output:

Before Filtering

After Filtering (to filter Carrot Product Data)

Result:
Thus the database is filtered using auto filter and advanced filter.

40
 EX:NO: 02 (c) CREATING SUBTOTALS AND GRAD TOTALS- USING
DATABASE FUNCTIONS
DATE: 04.05.2021

Aim:

To calculate the subtotals and grad totals using database functions.

Procedure:

Auto Filtering

 Click File -> New to open new worksheet

 Before applying subtotals, the data must be sorted by the columns.
 Select a cell in the list, and on the Excel Ribbon, click the Data tab, then click
Subtotals.
 In the "At each change in" box, select the first column that you want to base the
subtotals on -- Category in this example.
 Select the function that you want to use when totaling the columns.
 Select all the columns in which you want a subtotal.
 Remove the check mark from "Replace current subtotals" (unless there are
existing subtotals that you want to remove).
 Check or uncheck the page break and summary below data options, based on your
preferences.
 Click OK, to apply the Subtotals.
 At the top left, grouping buttons are added, so you can view specific parts of the
data:
1. Grand Total only
2. Grand Total and Subtotals
3. All data and totals
 Click the + and - buttons in the grouping bar, to show or hide sections of the data.

41
Output:

Input Data

The subtotal and grand total of the data

Result:
Thus the subtotal and grand total has been computed using database function.

42
EX:NO: 03
3. CREATING CHARTS IN MS EXCEL
DATE: 06.05.2021

Aim:

 To create a different types of chart in MS Excel.

Procedure:

 Click File -> New to open new worksheet

 Click on the Chart Wizard icon to start the Chart Wizard
 Choose the desired chart type.
 Click on 'Next' tab to continue.
 The range of cells, which you have highlighted earlier, would be selected
automatically.
 Choose the Legend folio.
 Click here once to specify the data legends to appear on any side of graph desire.
 Choose Format Chart Area and change the font style, font size, and formatted
the graph
 Click on the 'Finish' tab to see the graph.
 Click save command from file menu and save the worksheet
 Click print command from file menu to print the chart.

Output:

Input Data

Purchased Items

2012 2013 2014 2015

Desktop Computers 20 12 13 12

Laptops 34 45 40 39
Monitors 12 10 17 15
Printers 78 13 90 14

43
Pie Chart

Bar Chart

Result:

Thus the chart has been created.

44
 EX:NO: 04
3. FUNCTIONS IN MS EXCEL
DATE: 11.05.2021

Aim:

 To evaluate different types of functions such as Date, Time, Maths, Financial and
Logical functions in MS Excel.
Procedure:

 Click File -> New to open new worksheet

 Choose Function from the Insert Menu
 Choose theh category of the function such as Maths & Trig, Date & Time, Logical
etc., from the Function Category.
 Choose function Name such as SUM, ROUND, AND, FV etc.
 Click Ok button
 Either type the cell address or point to the cell (with the mouse)
 Click OK

Output:

Maths Functions

45
Logical Functions

Date and Time Functions

Financial Function

Future Value (FV): calculate the Future Value of an investment for fixed, repeated payments
where the interest rate remains the same.

Formula =FV(rate, nper, pmt, [pv], [type])

46
Net Present Value (NPV): Calculates the NPV of an investment using a discount rate and a
series of cash flows that occur at irregular intervals.

RATE: Compute the interest rate needed to pay off the loan in full for a given period of time.

=RATE(n_period, PMT, present_value, [future_value], [type], [guess_rate])

47
EFFECT: To find the effective annual interest rate when you're given the nominal interest rate

and when the interest compounds each year.

=EFFECT(Rate, N_COMP_YEAR)

Result:

Thus the various functions have been created.

48
 EX:NO: 05 MACROS
DATE: 20.05.2021

Aim:
To create, assigning a button , editing and running macros.
Procedure:
i). Creating and running a macro:
 Creating and running a macro.
 Press ctrl + N to create a new document.
 Enter a data in cell.
 Select the macro command from the tool menu. Excel displays two option.
 Click the record new macro option.
 Excel displays the macros dialog box.
 Enter the new shortcut key in the ctrl + text box.
 Click the ok button.
 Then the format the data.
 Select the macro command from tools menu.
 Excel displays 2 options.
 Click the stop, recording button.

ii). Assigning a button to defined a macro

 Enter the data in another cell.
 Press the ctrl + assigned shortcut key to format the data.
 Excel changes the data to find previous formatted type.

49
iii). Editing a macro:
 Select the macro commands from the tools menu.
 Excel displays two options.
 Click the micro button.
 Excel display the macro dialog box.
 Click the option button in the dialog box.
 Excel displays the macro options dialog box.
 Delete the per assigned the shortcut key.
 Then type the new shortcut key in the macro dialog box in ctrl + text box.
 Then click ok button.
 And then click the run button in the macro dialog box.
 Then enter the data in a cell.
 Press the new shortcut keys to format the data.

Result:
Thus the macro has been created, assigned a button and edited successfully.

50
MS-POWERPOINT

51
 EX:NO: 01 CREATING A PRESENTATION USING AUTO CONTENT
WIZARD
DATE: 25.05.2021

Aim:
To Creating a presentation using auto content wizard.

Procedure:

 Click the File menu, and then click New.

 Click From AutoContent Wizard on the task pane.
 Read the first Wizard dialog box, and then click Next to continue.
 Click the presentation type you want to use. If you want to focus on one set of
presentations, such as sales presentations, click the appropriate category button,
and then click the presentation type you want.
 Click Next to continue.
 Click the presentation output option you want to use.
 Click Next to continue.
 Enter a presentation title and any items you want to include on each slide.
 If you want, enter presentation footer.
 Select or clear the Date Last Updated check box.
 Select or clear the Slide Number check box.
 Click Next to continue.
 Read the last Wizard dialog box, and then click Finish.

52
Output:

53
Results:
Thus the Power point presentation is created using auto content wizard.

54
 EX:NO: 02
DIFFERENT VIEWS IN POWERPOINT PRESENTATION
DATE: 27.05.2021

Aim:
To create Different views in PowerPoint presentation.

Procedure:
 Start → Program → MS-Office2000→ MS-Powerpoint
 Create a new presentation
 Clicking the four small buttons towards the right side of the Status Bar
 To Navigate to Normal View: Click the Normal View button that contains the Outline
pane, Slide pane, and Notes pane.
 To Navigate to Slide view: Click the Slide View button that shows One side appears on
the screen
 To navigate to Outline view. Click the Outline View button and this view is ideal for
working only with the text of a presentation.
 To Navigate to Slide Sorter View: Click the Slide Sorter View button and this view
lets you see all of the slides you have created in a miniature view.
 To Navigate to Slide Show View: Click the Slide Show View button and this view lets
you see your presentation electronically as it will appear to an audience.
 To Exit the Slide Show: Press the ESC key on the keyboard
 Save the document and Exit from the MS-Power point

Output
 Create a new Presentation
 Clicking the four small buttons towards the right side of the Status Bar

55
Normal View:

Outline View:

Slide View:

56
Slide Sorter View:

57
Slide Show View:

Result:

Thus the different views of PowerPoint presentation are created.

58
 EX:NO: 03 SETTING ANIMATION EFFECTS/ GROUPING / UNGROUPING /
CROPPING POWER/ POINT OBJECTS
DATE: 08.06.2021

Aim:
To create a presentation with setting animation effects/ grouping / ungrouping / cropping
power/ point objects.

Procedure:
 Start → Program → MS-Office2000→ MS-Power point
 Using slides background design → click to right →Formatting background →Four
option select to any one → apply and apply all → next → click to ok
 Go to insert → click Text box
 Using Text effect , Go to Animation→ Custom animation → open Add effect the use
four method effect available
 Using effect select to any text goto add effect click any one effect select click apply
 Play to effect two method. Go to →click to F5 key and click play button play to effect
 Save the document and Exit from the MS-Power point
 Go to Animation → Custom animation →open Add effect the use four method effect
available
 Using Effect select to any image Add effect click any one effect next click apply
 Go to→ insert → click to Sound → Select Sound from file → Select one music next
click Insert
 Save the document and Exit from the MS-Power point

59
Output:

60
61
Result:

Thus the Powerpoint presentation is created using animations and sound effects.

62
 EX:NO: 04
PRINTING A PRESENTATION / IMPORTING – EXPORTING
DATE: 10.06.2021 FILES

Aim:

To Printing a presentation / Importing – Exporting files in MS Powerpoint.

Procedure:

Printing a presentation:

 Choose File Print (Ctrl+P).

 Print Dialog box will apprear
 Choose the number of slides, the number of copies, and slide range.
 Choose more options like Grayscale, Pure black and white, scale to fit paper, or Frame
Slides.
 Click OK.

Importing – Exporting files

 File > Export helps you change your presentation into a different format, such as PDF,
video, or Word-based handouts. Or choose File > Save As (or Save a Copy) to save to
that new location.
 In the Save As window, click on the Save as type: menu and select any format like,
PDF, JPEG File etc.
 click on the Save button.

63
Output:
Printing a presentation:

Importing – Exporting files

Result:

Thus Printing a presentation / Importing – Exporting files has been performed in

PowerPoint.

64
 EX:NO: 05
CREATING AN ORGANISATION CHART IN POWER POINT
DATE: 15.06.2021

Aim:

To Create an organizational structure using organization chart, Entering names and Titles,
Adding Members, Formatting the Boxes, Text and Lines, Rearranging the Org Chart, Finishing
the Chart in PowerPoint.

Procedure:

 On the Insert tab, in the Illustrations group, click SmartArt.

 In the Choose a SmartArt Graphic gallery, click Hierarchy, click an organization chart
layout (such as Organization Chart), and then click OK. then enter your text, do one of
the following:
 Click in a box in the SmartArt graphic, and then type your text.
 Click [Text] in the Text pane, and then type your text.
 Copy text from another location or program, click [Text] in the Text pane, and then paste
your text.
 Click the existing box that is located closest to where you want to add the new box.
 Under SmartArt Tools, on the Design tab, in the Create Graphic group, click the arrow
next to Add Shape, and then do one of the following:
 To insert a box at the same level as the selected box but following it, click Add Shape
After.
 To insert a box at the same level as the selected box but before it, click Add Shape
Before.
 To insert a box one level above the selected box, click Add Shape Above.
 The new box takes the position of the selected box, and the selected box and all the boxes
directly below it are each demoted one level.
 To insert a box one level below the selected box, click Add Shape Below.
 To add an assistant box, click Add Assistant.
 Click the SmartArt graphic whose line you want to change.
 Right-click the line, and then click Format Shape on the shortcut menu.
 Click Line or Line Style, and then click the Dash type that you want.

65
OUTPUT:

66
Result:

Thus the organizational structure has been created using organizational chart
in PowerPoint.

67
MS-ACCESS

68
EX:NO: 01 CREATE AN EMPLOYEE DATABSE USING MS-ACCESS
DATE: 17.06.2021

Aim:

Prepare a payroll for employee database of an organization with the following details:
Employee id, Employee name, Date of Birth, Department and Designation, Date of
appointment, Basic Pay, Dearness Allowance, House Rent Allowance and other deductions
if any. Perform queries for different categories.

Procedure:

 Click File > New, and then select Blank desktop database
 Choose New
Access displays a variety of database templates you can use
 Click an icon, such as Blank Database, or any database template
 Click in the File Name text box and type a descriptive name for your database
 Click the Create
 Click the Click to Add heading
 Choose Long Text
 Type a name for your field (such as First Name or Salary)
 Press Enter
 When you have finished adding fields, press Esc on the keyboard
 go to the Create tab -> Table ->Datasheet View
 Enter the data and Click Save.

69
Output

Create a Fields and Datatypes

Enter the Data

Result:

Thus the employee database has been created in MS-Access.

70
EX:NO: 02 CREATE MAILING LABELS USING MS-ACCESS
DATE: 22.06.2021

Aim:

Create mailing labels for student database which include atleast three tables must have
atleast two fields with the following details: Roll Number, Name, Course, Year College
Name, University Address, Phone Number.

Procedure:

 Click File > New, and then select Blank desktop database
 Choose New. Click an icon, such as Blank Database, or any database template
 Click the Create
 Double click the table and enter the students data.
 Click Create tab, in the Reports group and click Labels.
 Click Customize and then click New.
 Click Show custom label sizes, and then click the custom label.
 Select Sheet feed or Continuous under Label Type and then click Next.
 Select the font name, size, weight and text color you want on your label, and click Next.
 Choose the fields of labels from the Available fields list, and double-click them to add to
the Prototype label box.
 To add space between the fields in the Prototype label box, press SPACEBAR.
 To create a new line, press ENTER. click Next.
 Choose fields on which to sort your labels.
 On the last page, enter a name for your labels, and click Finish.

71
 Output

Create students Database

Create a Mailing Label

Result:

Thus the mailing label has been created for students database in MS-Access.

72
EX:NO: 03 CREATE A FORMS FOR THE STUDENT DATABASE
DATE: 29.06.2021

Aim:

Create a forms for the Student database using MS-Access.

Procedure:

 On the Create tab, click Blank Form.

 Access opens a blank form in Layout view, and displays the Field List pane.
 In the Field List pane, click the plus sign (+) next to the table or tables that contain the
fields that you want to see on the form.
 To add a field to the form, double-click it or drag it onto the form.
 Use the tools in the Controls group on the Form Layout Tools tab to add a logo, title,
page numbers, or the date and time to the form.
 Click Design and use the tools in the Controls group.
 When you have finished adding the records, save the form as “Student Form”.

73
 Output

Result:

Thus the form has been created for the student database in MS-Access.

74
EX:NO: 04 CREATE A REPORT FOR THE EMPLOYEE DATABASE
DATE: 01.07.2021

Aim:

Create a report for the employee database using MS-Access.

Procedure:

 Open the Navigation pane.

 Click the table or query on which you want to base your report.
 Activate the Create tab.
 Click the Report button in the Reports group.
 Click a field you want to group by.
 Click Next. The Report Wizard moves to the next page.
 Click the down-arrow and then select the field you want to sort by.
 Click the button to choose ascending or descending order.
 Click the Summary Options button to summary the data and calculate the percent to the
total for sums.
 Click Next. The Report Wizard moves to the next page.
 Click the Save button on the Quick Access toolbar.
 Type the name you want to give your report and Click OK. Access saves the report.
 Click Next. The Report Wizard moves to the next page.

75
 Output

Result:

Thus the report has been created for the employee database in MS-Access.

76