SUGUNA COLLEGE OF ARTS AND SCIENCE

(Affiliated to Bharathiar University)

Coimbatore - 641014

DEPARTMENT OF COMMERCE

PRACTICAL RECORD

COMPUTER APPLICATION PRACTICAL - I

SUBJECT : MS-WORD,MS-POWERPOINT,MS-EXCEL,MS-ACCESS
AND INTERNET

NAME

REGISTER NO

CLASS I MCOM

BATCH 2024-2026
 SUGUNA COLLEGE OF ARTS AND SCIENCE

(Affiliated to Bharathiar University)

Coimbatore - 641014

Certified that this is the Bonafide record of work done by

Mr/Ms.

of I M.Com during the year 2024-2026

Staff In-Charge Head of the Department

Submitted for the Practical Examination held on at

Suguna College of Arts and Science, Coimbatore – 641014.

Internal Examiner External Examiner

 COMPUTER APPLICATION PRACTICALS 1
MS OFFICE & INTERNET
CONTENTS

S.No DATE EXERCISE PAGE SIGNATU RE

NO

MS WORD
1 Cost Audit Report
2 Questionnaire
3 Sample Research Report
4 Horizontal Balance Sheet
5 Organisation Chart
6 Employees Performance
Appraisal
7 Three Column Format
8 Elements of Cost
9 Advertisement
10 Mail Merge
11 Curriculum Vitae

MS POWERPOINT
1 Packing Lables
2 Sample Research Report
3 Product Advertisement

MS EXCEL
1 Customer Details of a Bank
2 Employee Details
3 Payroll for Employees
4 Balance Sheet
5 Product Life Cycle
6 Trend Analysis
7 Break Even Chart
8 Price Earning Ratio
9 Correlation
10 Payback Period
11 Final Accounts of a Banking
Company
12 Bincard

MS ACCESS
1 Student Database
2 Policy Holders Datebase
3 Student Mark Details
4 Product Strategy
5 General Ledger

INTERNET
1 Connecting Internet Through
Browser
2 Creation of Email Id
3 Send and Check Email Id
4 Search Engine
5 Stock Exchange Website
6 Reserve Bank of India Website
7 Ministry of Commerce and
Industry
8 Online Marketing
9 E-Grouping
10 Economics Survey and Union
Budget
MS-WORD
EX:NO:
DATE:

COST AUDIT REPORT

AIM:
To prepare a cost audit report and perform the programme by using Ms-word.
ALGORITHM:
STEP 1: To start Ms-word select all programmes Ms-office Ms-word.
STEP 2: Open a new document. Type above three paragraphs above cost audit
report.
STEP 3: Select the first paragraph, change the alignment to right by selecting
formatting toolbar=>alignment right or click.
STEP 4: Select the important words change into bold by selecting font=> font
style => bold or Ctrl +B or B.
STEP 5: Select the paragraph=>alignment=> Center or Ctrl +E or select the
important words, click into italic by selecting font =>font style=>italic or I.
STEP 6: Select the third paragraph and change into two column paragraph by
selecting page layout=>column and then select into two column format.
STEP 7: Insert date, time and page of number by selecting insert=>Header and
toolbar=>insert date and time in the top of the page. Insert page number in the
bottom of the page.
STEP 8: Change the character spacing for heading by selecting
format=>font=>character spacing=>spacing=>expanded.
STEP 9: Save and close the document.

RESULT:
Thus, the required cost audit report is performed by using Ms-word.
EX.NO:
DATE:

QUESTIONNAIRE
AIM:
To create a questionnaire about marketing by using Ms word.
ALGORITHM:
STEP 1: To start Ms-word select start => all programs Ms-office => Ms
word.
STEP 2: Open a new document type the questionnaires about
marketing.
STEP 3: Select the questionnaire link home menu -bullets and
numbering
STEP 4: Checking spelling and grammar by selecting review- spelling and
grammar.
STEP 5: To prepare the word using these sources selecting
review=>proofing=>thesaurus.
STEP 6:For selected words we drop caps by selecting
insert=>text=>drops caps.
STEP 7: save and close the document.

RESULT: Thus the questionnaires is prepared by using Ms Word.

EX.NO:
DATE:

SAMPLE RESEARCH REPORT

AIM:

Inserting symbols, caption, indenting a text and re- arranging paragraph

using ms-word.

ALGORITHM:

STEP 1: To start ms-word, select start -> programme -> ms-office

->Ms-word

STEP 2: Open a new document of file by selecting file menu -> new -> blank
document -> create.

STEP 3: Type the required text in one or two paragraph.

STEP 4: Insert the symbols by selecting insert -> symbols.

STEP 5: Insert caption at the required place by selecting Reference -> caption
-> Insert caption.

STEP 6: Justify the selected text by clicking paragraph -> Alignment Justify or
click ctrl+J.

STEP 7: Insert the selected text by selecting paragraph -> Indent -> Increase
or decrease Indent.

STEP 8: Insert the page break by selecting Insert -> pages -> pages break.

STEP 9: Save and close the document.

RESULT:

Thus a sample research report is prepared by using MS- word.

EX.NO:

DATE :
BALANCE SHEET

AIM:

To type a published horizontal form of a balance sheet of a company.

ALGORITHM:

STEP: 1 To start MS-word select start -> all programmes -> MS- office -> MS-
word.

STEP: 2 Open a new document or file by selecting file menu -> new -> blank
-> document -> create.

STEP: 3 Create a table by selecting Insert -> table.

STEP: 4 Enter the number of rows and columns required in the table dialog
box and click ok.

STEP: 5 Type the balance sheet information of the company in the created
table.

STEP: 6 Insert or delete rows and columns by selecting Insert -> Table Tools
-> Layout -> Rows and columns delete or insert.

STEP: 7 Change the border of the table at the top and bottom of by selecting
table -> table tools -> design -> border and shading.

STEP: 8 Do also formatting of tables by selecting table tools -> layout.

STEP: 9 Change the background of the heading color.

STEP:10 Save and close the file.

RESULT:

Thus, the balance sheet is prepared with the required changes using MS-
WORD.
EX.NO:

DATE :
ORGANIZATIONAL CHART

AIM:

To Prepare An Organizational Chart By Using Ms-Word.

ALGORITHM:

STEP 1: To Start Ms Word And Select Start -> Program -> Ms Word

STEP 2: Open A New Document Or File By Selecting File Menu -> New -.
Blank Document -> Create.

STEP 3: Select The Organization Chart From The Insert Menu.

STEP 4: Type The Text Inside The Boxes.

STEP 5: Change The Font Style And Font Size By Selecting Appropriate
Words and Then Selecting Words And Then Selecting Font -> Font Style And
Size.

STEP 6: Save And Close The Document.

RESULT:

Thus, The Organization Chart Is Prepared By Ms Wor

EX.NO:

DATE :

EMPLOYEES PERFORMANCE APPRAISAL

AIM:

To Prepare A Table Showing The Employee Performance Appraisal

System.

ALGORITHM:

STEP 1: To Start The Ms Word Select Start -> Programme -> Ms Office -> Ms
Word.

STEP 2: Open A New Document Or File By Selecting File Menu-> New->

Blank Document -> Create.

STEP 3: Create A Table Showing Employees Performance Appraisal System

By Selecting Insert -> Table.

STEP 4: Select Table-> Design To Change The Text Color Of The Heading
By Selecting Font-> Font Color Or Pen Color.

STEP 5: Sort The Employees In Alphabetical Order By Selecting Table ->

Layout -> Data -> A Sort By Choosing.

STEP 6: Use The Hyperlink By Selecting Insert -> Line -> Hyperlink.

STEP 7: Merge The Cells By Selecting Tables -> Table Tools -> Layout ->
Merge -> Merge Cell.

STEP 8: Save And Close The Document.

RESULT:

Thus, The Employees Performance Appraisal System Is Prepared

By Using Ms-Word.
EX.NO:

DATE :
THREE COLUMNS FORMAT

AIM:

To create a three column format by using Ms-word.

ALGORITHM:

STEP1: To start Ms –word select start programmeMs- office Ms-word.

STEP2: Open a new document or file by selecting file menu new blank create.

STEP3: Create three column format by selecting page layout columns three
columns.

STEP4: Type any five differences between Financial,cost and Management

Accounting.

STEP5: Save and close the document.

RESULT:

Thus , three column format is prepared by Ms-word.

EX:NO:
DATE:
ELEMENT OF COST

AIM:

To prepare a diagrammatic representation showing the elements of

cost using Ms-word.

ALGORITHM;

STEP 1: To start Ms word select start programme=>Ms-office =>Ms word.

STEP 2:Open a new document or file by selecting file menu => new =>
blank document=> create.

STEP 3:Select the required shapes by using insert=>shapes.

STEP 4:To enter text in shapes, select insert shapes and type to text.

STEP 5:Save and close the document.

RESULT:
Thus, a diagrammatic representation of the element of cost is prepared by using
Ms Word.
EX:NO:
DATE:

ADVERTISEMENT

AIM:
To prepare an attractive advertisement to create demand for a particular
accounting package using 3D effects.

ALGORITHM:

STEP 1: To start Ms-word select start=>programmes=>Ms-office=>Ms-word.

STEP 2:Open a new document or file selecting file

menu=>new=>blank documents=> create.

STEP 3:Type the advertisement information regarding accounting packages.

STEP 4:To have 3D effects insert a picture and click on insert shapes=>3D
effects.

STEP 5:To clip on click on the insert clip art.

STEP 6:Insert shapes and Banners by selecting it from insert=>shapes=>

start and Banners.

STEP 7:Save and close the document.

RESULT:
Thus, an attractive advertisement is prepared by using Ms-word.
EX:NO:
DATE:

MAIL MERGE

AIM:
To perform mail merge operation for sending notice to shareholders for
annual general meeting using Ms-word.
ALGORITHM:
STEP 1: To start Ms-word select start=>programmes=>Ms
office=>Ms-word.
STEP 2:Open a new document or file by selecting file
menu=>new=>blank document created.
STEP 3: Type the letter sending notice to shareholders for annual general
meeting in the prescribed format learning “To address” blank.
STEP 4:For performing mail merge select mail merge=>start=>mail merge
step by step mail merge wizard.
STEP 5:Select the document type as letter and in step two select we the
current document.
STEP 6:For selecting the recipients click type a new list in step 3 and create
and save the recipients list in my document.
STEP 7:In the letter insert the address block in the appropriate place,
preview that and make change if needed.
STEP 8; Complete the mail merge by clicking and merge.

STEP 9: Save and close the document.

.
RESULT:
Thus, the mail merge operation is performed by using Ms-word.
EX:NO:
DATE:
CURRICULUM VITAE

AIM: TO type a curriculum vitae and perform template and inducting

the text.
ALGORITHM:
STEP:1 To start the Ms-word select start=>programmes=>Ms
office=>Ms-word.
STEP:2 Open a new document or file by selecting file
menu=>new=>blank document=>create.
STEP:3 Click on the new installed template you can get a list of already create
templates on the screen.
STEP:4 Select the curriculum vitae template and give create=>new
template.
STEP:5 Type your name, date of birth, address and other details.
STEP:6 Select the items which you went to have from the standard
heading and type the required information.
STEP:7 To invert the text click on paragraph=>indenting and spacing.
STEP:8 Save and close the document.

RESULT:
Thus, the curriculum vitae is prepared by using Ms word.
MS-POWERPOINT
Ex: No:

Date:

PACKAGING LABEL

AIM:

To Show Diagram Of Different Packaging Label In PowerPoint.

ALGORITHM:

STEP 1: To Start PowerPoint Go To Start > Programs > Ms Office >Ms-

PowerPoint.

STEP 2: Select Blank Presentation > Create.

STEP 3: Select Blank Slide from Home Layout> Blank.

STEP 4: To Create Packing Label Go TO Input Clipart and To change The

Style go to Picture Tools > Format> Picture Style.

STEP 5: To Enter Text in the Slide Go to Insert > Text Box and Type The
Mather In The Box.

STEP 6: To Give The Background Themes Go To Design > Themes and Select
Themes.

STEP 7: Create Four Slides For Packing Labels.

STEP 8: To Give Animation Effects For The Slide Go to Animation > Custom
Animation and Give The Effects Select The Slide Transition Style

STEP 9: To View The Presentation Go To Style Show From The Beginning .

STEP 10: Save and Exit The Presentation.

RESULT:

Thus The Diagrams of Diagram Packing Labels are drawn or

displayed by Using Ms- Powerpoint.
EX:NO:

DATE:

SAMPLE RESEARCH REPORT

AIM:

TO Create Contents of a Research Report in Ms-PowerPoint.

ALGORITHM:

STEP 1: To Start PowerPoint go to Start > Ms-Office > Ms-PowerPoint.

STEP 2: Select Blank Presentation > create.

STEP 3: To Enter The Title of the Presentation Select Title Slide From
Layout Type the Title.

STEP 4: To Insert a Slide go to Home > New Slide change the layout > title
and Content type the title as introduction and add the text.

STEP 5: Repeat the above step to enter objectives, findings, suggestions and
Conclusion.

STEP 6: Give animation effect and slide transition effect.

STEP 7: Save and Exit.

RESULT:

Thus a PowerPoint Presentation for a Sample Research Report is

Prepared by Using Ms-PowerPoint.
EX: NO: 3

DATE:

ADVERTISEMENT

AIM:

To Create PowerPoint Presentation for Product advertisement and

advertisement.

ALGORITHM:

STEP 1: To Start PowerPoint go to Start > Program > Ms-office >

Ms-PowerPoint.

STEP 2: Select the Blank Presentation > Create.

STEP 3: Select the appropriate Slide and Create Advertisement for Slide a
Product and for a company.

STEP 4: To give different animation effect for text and pictures go to

animation >Animate.

STEP 5: To fix the time for slide transaction go to animation > transaction to
the Slide > advance Slide Select automatically after two minutes.

STEP 6: To Use Hyper Link Click Insert > Hyper link and Select the Picture or
Document to the Hyper Link.

STEP 7: Save and Exit the presentation.

RESULT:

Thus PowerPoint Presentation is prepared for

a) Product Advertisement
b) Company Advertise
MS EXCEL
EX: NO:

DATE:

CUSTOMERS DETAILS OF BANK

AIM:

To Prepare a Table Showing The Customer Details of a Bank using.

ALGORITHM:

STEP1: To Start Ms-Excel Select Start > Program > Ms-Office > Ms-Excel.

STEP2: Open a New Worksheet By Selecting File > New Blank Worksheet.

STEP3: Activate The Cell To Type The Customer Name, Nature, of Account,
Account Number, Address, E-mail Id, Deposits, Withdrawals and Balance
Enter The Details for the Customer.

STEP4: Enter The Details of Deposits and Withdrawals Made by the Customer
To Find Out The Balance Name the Next Column as Balance and enter “=” in
the Formula. bar and Click enter. To get the result For other Customers Drag
the Mouse.

STEP5: Delete the Customer Who Had Closed The Account By Right Clicking
The Mouse Than choose Delete Or click Home > Delete > Delete SheetRows

STEP6: Insert a Row Between the First and Second Row By Activating the
Second Row and click Home =>Insert=>=>Insert Sheet Column.

STEP7: To Hide The Address Column Select the Column and Click Formal
=>Visibility=>Hide Columns.

STEP8: Save and Close the documents.

RESULT:

Thus the customers Details of a Bank Is prepared Using Ms-Excel.

EX: NO: 2

DATE:

EMPLOYEE DETAILS OF A COMPANY

AIM:

To Create a Table Consisting of Employee Details of a Company Using

Ms-Excel.

ALGORITHM:

STEP1: To Start Ms-Excel Select Start=> Programs=>Ms-Office=>Ms-Excel.

STEP2: Open a New Blank sheet By Selecting File=> New=> Blank

WorkSheet.

STEP3: Activate the Cells and Type the name of the employee, Department,
Net pay and City. Enter Record, often Employee.

STEP4: To Copy the Details of Production Department Employees in Sheet the

Column, Department and Click Data=> Filter=>Production, Select the Data and
to Copy It Click Home=> Copy or Press Ctrl + c .Then go to Sheet No.1 and
Parts the data By Choosing Parte or Ctrl+v.

STEP5: Similarity Copy The Details by Employees Staying In Coimbatore

City.

STEP6: To Find out the person Who Is Getting Maximum Salary Select
Formula =>Recently Wed=> Max. In the Range Box Enter The Range in The
Net Pay Column and Click Ok.

STEP7: Save and Close the Document.

RESULT:

Thus Employee Details of a Company is Prepared By using Ms-Excel.

 PAYROLL EMPLOYEES

AIM:

To Prepare PayRoll and for Employees Using Ms-excel.

ALGORITHM

STEP1: To Start Ms-Excel. Select Start=> Programs=>Ms-Excel.

STEP2: Open a New Worksheet by Selecting File=>New=>blank Worksheet.

STEP3: Select a cell to activate it and Type name of the Employees basic pay.

STEP4: Type the Column Heading as DA and Enter Value Type “=” and
Select The First Cell in pay multiply by 30 and Divide by 100. In The Same
Meaning do HRA, CCA, EDF and LIC.

STEP5: To find out the gross pay insert a Column after CCA and Name it as
Gross pay Select the Column Basic pay DA, HRA, CCA and Click Autosum
orZ.

STEP6: To Find out The Net pay insert a Column After ITC and Name it as net
pay From The Gross pay Column minus the EPF and LIC to get the Net pay.

STEP7: To Find out the Sum of Gross Pay and net pay of all the employees
Select the respective Column and Click Sum or E.

STEP8: Save and Close the Document.

RESULT:

Thus, the payroll for employees is prepare by using Ms-excel.

EX.NO:

DATE:
BALANCE SHEET OF A COMPANY

AIM:

To prepare Balance Sheet by Using Ms-Excel.

ALGORITHM:

STEP1: To Start Ms-Excel Select Start=>Programs=>Ms-office=>Excel.

STEP2: Open a new Work Sheet by Selecting file=>new=>Blank Work Sheet.

STEP3: Select the Cell to activate and type the assets and liabilities
alongwithAmount.

STEP4: To Change The Number Format to Rupees and paise,Select Home=>

Numbers => Increase Decimal or Click

STEP5: To change a Particular range of Cells or Bold Select Home=>Font=>

Font Size=> Bond on Ctrl + B.

STEP6: To Hide a Particulars row Select the row and click Home =>Formate
=> Fusibility=>Hide.

STEP7: Shortcut Key to go to Select No.3 Press Ctrl Page Down or ClickSheet
3 displayed in the Bottom of the Worksheet.

STEP8: Save and Close the Worksheet.

RESULT:

Thus ,The Work Sheet is Prepared With The Required Change by

using Ms-Excel.
EX:NO:5

DATE:
PRODUCT LIFE CYCLE OF A PRODUCT

AIM:

To Prepare a Demand Forecasting for a New product Life Cycle of a given

Product using Ms-Excel.

ALGORITHM:

STEP1: To Start Ms-Excel Start=>Program=>Ms-Excel.

STEP2: Open a New Worksheet by Selecting File=>New=>Blank Work Sheet.

STEP3: Select a cell to Make It active and Type the Year sales and Profit.

STEP4: To Insert Chart Select Sales and Profit Column Insert=>Chart=>Line

Chart.

STEP5: To Change The “X” Axis as Year, Right click The Chart. Select Data =
Select Data Source => Edit=>axis Table range=>Select Your Column=>Click
Ok.

STEP6: To change the “X” axis go to Chart Tools=>layout=>axis go to Chart

Tools=>Layout=>axis Title=>Horizontal Axis Title or vertical axis Title.

STEP7: To name The Chart Tools=>Layout=>Chart Title=>above chart.

STEP8: save and Close the Worksheet.

RESULT:

Thus, The Product Life Cycle is Prepared by using Ms-Excel.

EX:NO:6

DATE:
TREND ANALYSIS OF A PRODUCT

AIM:

To prepare a trend Analysis of a product using MS-Excel.

ALGORITHM:

STEP 1: To start MS-Excel, select start=> Program=> MS-Office =>

MS-Excel.

STEP 2: Open a New worksheet by selecting File=> New=> Worksheet.

STEP 3: Activate the cells and type year and sales of a product.

STEP 4: To Insert a chart showing trend Analysis select Insert=> Chart=>Line

chart.

STEP 5: To change the X axis as year go to chart=>tools=>Layout=> Access

Title and select title below access and type as year.

STEP 6: Right click in the chart area and click select data=> Exit=> Select
access Range=> year 2003 to 2014 give ok.

STEP 7: To change “Y” axis as sales go to chart tools=> Layout=> Access

titles=> Primary verticle Access title and type as trend Analysis.

STEP 8: To Insert chart title go to chart tools=> Layout=> Chart title=> above
Chart and type as trend Analysis.

STEP 9: Save and close the Worksheet.

RESULT:

Thus the trend Analysis for the product is prepared by using

MS-Excel.
EX.NO:7

DATE:
BREAK EVEN CHART

AIM:

To prepare a Break Even Chart using chart Wizard.

ALGORITHM:

STEP1: To start MS-Excel select start=> Program=> MS-Office=>MS-Excel.

STEP2: Open a new work sheet By Selecting File=> new=>blank worksheet.

STEP3: Activate the cells and type in the columns output units, variable cost
Per unit, selling price per unit and fixed cost.

STEP4: Find out total variable cost by the multiplying output units and
variable Cost and total fixed cost. Find out total revenue by multiplying output
Units and selling price per unit.

STEP5: Select total cost, fixed cost and total revenue to insert=>Chart=>line
Chart.

STEP6: Change “X” Axis as output units “Y” axis as rupees and chart title
break Even chart.

STEP7: To find out the break even print insert data by clicking chart
tools=>Layout=>data labels=>above. The point where total cost and total
Revenue insert is the Breakeven point.

STEP8: Save and close the Worksheet.

RESULT:

Thus, the Break even chart is prepared by using Ms Excel.

EX.NO:

DATE:
PRICE EARNINGS PER SHARE

AIM:

To start program for calculate the price earning per share for Different

Companies by Using Ms-Excel.

ALGORITHM:

STEP1: To start Ms-Excel Select Start=>Program=>Ms-Office=>Ms.Excel.

STEP2: Open a new Work Sheet by selecting File=>New=>Blank Work Sheet.

STEP3: Activate the cells and enter the name of the company number of equity
Shares Debit and Interest.

STEP4: To Calculate Earnings before Tax given Formula =EBITX 10/100

interest.

STEP5: Name of next column as tax and given formula =EBITX 10/100.

STEP6: Earning After Tax=EBT-tax.

STEP7: To Calculate Earnings per share decide earnings after Tax dividend
By number of equity shares.

STEP8: In the next Column Enter the market Price Per Share.

STEP9: To Calculate the Price Earnings ratio given the formula= Market price
per share * 100 Earnings per share

STEP10: To find out the average price earnings ratio select the column and
Click Formulas=> Auto sum=>Average in summary find out Minimum And
maximum.

STEP11: To find out the number of Companies having Price earning ratio
above 100 go to formulas=> more Functions=> Starts cal => COONT/E.

STEP12: Save and close the Work Sheet.

RESULT:

Thus, price Earnings per Share is prepare by using Ms-Excel.

EX.NO:

DATE:
CORRELATION

AIM:

To Calculate the correlation Between Demand and price of Product.

ALGORITHM:

STEP1: To start Ms-Excel Sheet Start => Program=> Ms-Excel.

STEP2: Open a new Work Sheet By Selecting File=> New=>Blank work

Sheet.

STEP3: Activate the cells and Type Demand And price Of Product.

STEP4: To Calculate the Correlation Between Demand and Price go to

Formulas =>More Functions=> Statistical=>CORREL.

STEP5: In array one select Demand that Is A2 to A10 Array 2 select Price B2
to B10 and then Click Ok.

STEP6: Correlation Between Demand And Price Is Calculated.

STEP7: Correlation and Close The Work sheet.

RESULT:

Thus, the Correlation between Demand and price is calculate by Using

Ms-Excel.
EX.NO:

DATE:
PAYBACK PERIOD

AIM:

To Calculate Payback Period For The Project.

ALGORITHM:

STEP 1: To Start Ms-Excel Select Start > Program > Ms Office > Ms
Excel.

STEP 2: Open A New Worksheet By Selecting File > New> Blank

Worksheet.

STEP 3: Activate The Cell And Type The Year And Profit.

STEP 4: Type Third Column as Depreciation and Give Value as 15000 For

all the years.

STEP 5: To Calculate Profit after Depreciation from the Profit Minus the
Depreciation Amount.

STEP 6: To Calculate Tax Give the Formula As = Profit after Dep * 10/100

STEP 7: To Calculate Tax Profit after Tax Give Formula As = Profit After

Dep -Tax.

STEP 8: Cash Inflows Is = To Profit After Tax Plus Dep In The Next Column.

Find Out the Cumulative Cash Inflows.

STEP 9: Calculate The Payable Period By Using The Formula.

STEP 10: Save And Close The Worksheet.

RESULT:

Thus, the Payback Period For Project Prepared By Ms-Excel.

EX.NO:

DATE:

FINAL ACCOUNTS OF A BANKING COMPANY

AIM:

To prepare final accounts of a Banking Company in the new format using

MS-Excel.

ALGORITHM:

STEP 1: To start MS.Excel select start Program Ms-Office Ms.Excel.

STEP 2: Open a new worksheet by selecting File New Blank worksheet.

STEP 3: Select the cels to activated and type first coloumn as particular second
coloumn as schedule no and third of amount.

STEP 4: Fill the details of the assets and liabilities along with their schedule No
and Amount.

STEP 5: Save and close the Worksheet .

RESULT:

Thus,the final Accounts of banking company is prepared by using

Ms-Excel.
EX.NO:
DATE:
PREPARATION OF A BIN CARD

AIM:To prepare a Bin Card for the issues and Purchase made during a
particular Month.

ALGORITHM:

STEP 1: To start Ms.Excel start Program Ms- Office Ms.Excel.

STEP 2: Open a New Worksheet by selecting File Blank Worksheet.

STEP 3: Activate the cells and type data GRN Number issues, MRS Numbers
and Balance.
STEP 4: Fill the field data, receipts, isues and opening balance.
STEP 5: To findout the balance click the cel and give the formula as opening
balance + receipts – Issue press enter and drag for renaming cells.
STEP 6: To make all contents visible with in cells select Home Alignment
rap Text.
STEP 7: To Merge the cells select the cells and click Home lignment Merge
and Center.
STEP 8: Save and Close the Worksheet.

RESULT:

Thus, the Bin Card is Prepared by using Ms- Excel.

EX.NO:

DATE:

STUDENTS DATABASE USING TABLES + QUERY

AIM:

To create a student database ans retrive the students according to the

highest Marks.

ALGORITHM:

STEP 1: To open access go to start Programs Ms office Ms. Access.

STEP 2: Select new Blank database give as student, database and click
create.

STEP 3: To Create a table go to create Table create and give the field name
as Tamil, English, Maths, Science, Total, and Average save label as student
database.

STEP 4: Doule click the table students database and enter 10 records.

STEP 5: To calculate total go to create Other Query Design. Add the fields
from Table students database. Select Query tools Design Update right click.
In the row update to the expression buildess give [Tamil + English + Maths
+ Scince + Social ] and give ok. Then select every tools Design Run. It will
ask to update rewards give yes.

STEP 6: To calculate average repeate th above step and in expression

buildes give [ = Total 15 ].

STEP 7: To sort the name in alphabetical order go to create Query Design.

STEP 8: To list the students where total is greater than 350 go to create
Query design and select all the field, the table. In the field total given
criteria as 7350 and run the Query.

STEP 9: To create a report go to create report wizard. Select all the fields
click next, next and finish report is generated.
STEP 10: Save and exit the database.
RESULT:

Thus, the student Database is prepared by using Ms.Access.

EX.NO:
DATE:

POLICY HOLDER DETAILS OF AN INSURANCE COMPANY

AIM:

To create a database for maintaining the address of the

policyholder of an Insurance.

ALGORITHM:

STEP 1: To open Access go to start Program Ms-Office Ms.Access.

STEP 2: Select NewBlank databse give name as policy holder database

and click create.

STEP 3: To Create the table go to create Table Table Design and give the
fields as policy numbers, names, sex, age, address, city and district. Save
the table as policy holder database.Fix policy holder primary key.

STEP 4: Double click the table as policyholder and enter to records to

retrive the address of the female policy holders whose residence is at,
Coimbatore go to create Others Query Design Select , all the field from
table = in the field give criteria as female and Coimbatore district

STEP 5: Save and exit the database.

RESULT:

Thus, the policyholder database is prepared by using Ms- Access.

EX.NO:

DATE:

STUDENTS DATABASE USING TABLES

AIM:

To create a student database and retrive the students according to the

highest Marks.

ALGORITHM:

STEP 1: To open access go to start Programs Ms-Office.

STEP 2: Select New Blank Database give as students database and click
create.
STEP 3: To create a table go to create Table create and give the field name as
Tamil, English , Maths ,Social, Science,Total and Average save labels as
students database.
STEP 4: Double click the table students database and enter the 10 records.
STEP 5: To calculate total go to create Other Query Design. Add the fields
from Table students Database. Select Query tools Design Update right click.
In the row up date to row and select Built functions in the expression
buildess. Give [ Tamil + English + Maths + Science + Social ] an give ok.
Then select every Tools Design Run. It will ask to update records give Yes.
STEP 6: To calculate Average repeate the above step and in expression
builder give [= Total 15]

STEP 7 : To sort the name in alphabetical order go to create Query Design.

Select all the factors from the table. In the field name give sort ascending and
run the Query.

STEP 8: To list the students where total is greater than 350 go to create query
Design and select all the fields from the table. In the field total given criteria as
>350 and run the Query.
STEP 9: To display list wheremarks are greater than 90 and total greater than
400. 40 to create Query Design select all the fields from the table in the fields
from the table in the fields Tamil, English, Maths, Science, Social give the
criteria as > 90 as in the field total give the criteria as > 400 and run the Query.

STEP 10: To create a report go to create Report Report Wizard. Select all the
fields click. Next an finish report is generated.

STEP 11: Save and exit the database.

RESULT:

Thus, the students database is prepared by using Ms. Access.

EX.NO:

DATE:

PRODUCT STRATEGY
Aim:
To create product strategy in Ms.Access
.Algorithm:
Step 1 : To open access select Start -◻ Program -◻ Ms Office --◻ Ms Access .
Step 2 : Select New Blank Database give name as product.
Step 3 : To create a table go to create -◻ Tables -◻ Design and give the field as
product ID , product Name , Manufacture product strategy , Period.
Step 4 : Enter the product strategies for the products.
Step 5 : Save and exit the database.

Result:
Thus, the product strategy for various product is prepared by using
MS – Access.

EX.NO:
DATE:
GENERAL LEDGER
Aim:
To create general ledger and perform the program by using MS – Access.

Algorithm :
Step 1 : To open access select Start -◻ Program -◻ Ms Office --◻ Ms Access
Step 2 : Select new blank database give as student database and click create.
Step 3 : To create a table go to create --◻ Table create and give the field name
as entry No, Account name (Dr), JF , Amount , Account Name (Cr) ,
Particulars.
Step 4 : Select Create --◻ More forms --◻ Form -◻ Wizard -◻ Select fields
--◻ Clict Next .
Step 5 : Select Column as -◻ Next --◻ Click Access 2003 --◻ Next -◻ Modify
the forms design select.
Step 6 : Type the details in the table 2
Step 7 : The ledger A/C is created in table 1
Step 8 : Save and close the Program

Result :
Thus, General ledger is prepared by using MS. Access.

EX.NO:
DATE:
CONNECTING INTERNET THROUGH BROWSER
AIM:
To Connect the internet through browser.
Algorithm :
Step 1 : To open the internet explorer double click the Icon on the desktop or go
to start ◻ Program-◻ Internet explorer / Google Chrome / Mozilla Firefox .
Step 2 : Enter the website address in the browser and work with it.
Step 3 : Close the internet explorer .
Step 4 : Stop the Process.

Result :
Using google browser the internet has been connected.

EX.NO:
DATE:
CREATION OF EMAIL ID
Aim
To Create on Email id.
Algorithm :
Step 1 : Open the internet explorer, double click on E icon on the desktop
Step 2 : enter the name of the website as www.google.in
Step 3 : Click signup to create an email id .
Step 4 : Fill the Application form with Necessary details.
Step 5 : To register the email id click on submit this form and enter the
verification code .
Step 6 : The email id is created .
Step 7 : close the internet explorer and stop the process.

\
Result :
Using google search engine on email id has been created

Aim :
EX.NO:
DATE:
SEND AND CHECK EMAIL ID
AIM:
To send and email and check the mail index.
Algorithm :
Step 1 : open the internet explorer , double click on the E icon on the desktop
Step 2 : Enter the name of the website www.google.in
Step 3 : Click the mail option and then type your email id and password. Then
click signup or Signin
Step 4 : Select the compose option and into address type the email id the
receive then type the message
Step 5 : To attach files to the message click attachment and then select the files
that is to be attached.
Step 6 : Click send option then email is send.
Step 7 : to check the mail inbox click the inbox option and view the emails
which you have received.
Step 8 : Signout and close the internet Explorer.

Result :
Email has been send inbox has been checked.
EX.NO:
DATE:
SEARCH ENGINE

AIM;

To use the search engine and list solve of the search result

ALGORITHM:

STEP:1 Open the internet explorer, double click on the E icon on the desktop.

STEP:2 Enter the of the website on the www.google .in.

STEP:3 The text box along with the search tap will be available.

STEP:4 Type the text as cost audit report in the text box and then click
Search

STEP:5 A web page will be displayed with the required web address for the
Given text select the particular web address to view its content.

STEP: 6 Close the internet explores and stop the process.

RESULT:

Using Google search engine and search result has been listed
for Cost .

EX.NO:
DATE:

STOCK EXCHANGE

AIM:

To visit any of the stock exchange website and collect information

regarding share price.

ALGORITHM:

STEP:1 Open the internet explorer, double click on the E icon on the screen.
STEP:2 Enter the Mumbai stock exchange website.

STEP:3 Collect the necessary information regarding the share price of a

Particular company and download it.

STEP:4 Close the internet explorer and stop the process.

RESULT:

Using internet information about the share price of the BSE has been
gathered.
EX.NO:
DATE:
RESERVE BANK OF INDIA
AIM:
To visit WWW. RBI. Com and download same information.
ALGORITHM:
STEP1: Open the internet explorer , double click on the E-icon on the
desktop.
STEP2: Enter the website address of RBI that is WWW. RBI. Com .
STEP3: Collect the information regarding RBI and download it.
STEP4: Close internet explorer and stop the process.

RESULT:
BY USING WWW. RBI . Com the information has been
downloaded.

EX.NO:
DATE:
MINISTRY OF COMMERCE AND INDUSTRY
AIM:
To Visit The Website Of Commerce And Industries Ministry Collect
Some Information About The Trade Policy.

ALGORITHM:
STEP 1: Open The Internet Explorer, Double Click On The E Icon On The
Desktop.
STEP 2: Enter The Website Address Of The Ministry Of The Commerce And
Industry.
STEP 3: Collect The Information Regarding The Trade Policy.
STEP 4: Close The Internet Explorer And Stop The Process.

RESULT:
Using The Website Of Commerce And Industry And Ministry The
Information Has Been Collected About Trade Policy.
EX.NO:
DATE:

ONLINE MARKETING

AIM:

To visit a website for online marketing and find out the procedure to
place on order.

ALGORITHM:

STEP: 1 Open the internet explores, double click on the E icon on desktop.

STEP: 2 Enter the website address as WWW.The chennaisilks.com.

STEP: 3 Right the procedure to place on order online. Enter the details
regarding the product shipping details and payment details.

STEP: 4 Click ok button and order is placed.

STEP: 5 Close the Internet explores and stop the process.

RESULT:

Visited the Chennai silks online marketing website and placed on order
to know the procedure of online marketing.
 EX.NO:

DATE:

E-GROUPING

AIM :

TO Participate in discussion forms and e-groups.

ALGORITHM :

STEP :1 Open the internet explorer, Double click on the E icon on the
desktop .

STEP:2 Enter the website address as www.yahoo.com and click sign in click
groups and select the particular group as you wish.

STEP:3 Join the group and participate in it.

STEP :4 Enter the website address as www.google.com enter the text as

discussion forms and e groups give search .

STEP:5 A List of available discussion forms and E groups give search..

STEP:6 Select a forms and participate it .

STEP:7 Close the internet explorer and stop the process.

RESULT:

E- Grouping has been joined by using yahoo.

 EX.NO:

DATE:

ECONOMICS SURVEY AND UNION BUDGET

AIM:

To visit the website of the national information center ministry of

financial and collect information regarding economic survey and union
budget.

ALGORITHM:

STEP:1 Open the internet explorer double click on the E icon on desktop.
STEP:2 Go to Google search engine and type the text as national information
Enter and give search.

STEP:3 Go to NIC website and collect the require information.

STEP:4 Go to website of ministry of finance and collect information regarding

economics survey and union.

STEP:5 Close the internet explorer and stop the process.

RESULT:

Using Google search engine visited the websites of NIC and ministry
of finance and collected information about the economics survey of union
budget.