Yallalinga Shivareddy

JNANA TUNGA PG CENTER RAICHUR
(YARAGERA)
DEPARTMENT OF COMMERCE
ACADEMIC YEAR 2020-21
Reg.No:- P2077965 Date. / /
CERTIFICATE
This is to certify that Mr/Ms. YALLALINGA SHIVAREDDY
has satisfactorily completed the lab assignment of
“Computer Application in Business” of M.com third
Semester Course in the Department of Commerce,
Gulbarga University. Jnana Tunga PG Centre Raichur
(Yargera), for the year 2020-21.
Staff in charge:
Examiners:
1.
2.
1
INDEX
SL NO. PARTICULARS PAGE REMARKS
NO.
HTML
01 PROGRAM USING HEADING 04-05
TAGS
02 PROGRAM FOR TEXT 06-07
FORMATING TAGS
03 PROGRAM FOR UNDERLINIG 08-09
THE TEXT
04 PROGRAM USING MARQUEE 10-11
TAGS
05 PROGRAM BACKGROUND 12-13
COLOR
06 PROGRAM UNORDERED LIST 14 -15
07 PROGRAM ORDERED LIST 16 -17
08 TABLE INSERTION 18 -19
09 IMAGE INSERTION 20 -21
MS – WORD
10 CREATE A LETTER IN MS – 23-24
WORD
11 CREATE A MAIL MERGE IN MS 25-26
WORD
12 CREATE A RESUME 27-28
13 CREATION OF PROJECT 29-30
REPORT COVER PAGE
14 HEADER AND FOOTER 31-32
MS – EXCEL
15 CREATE A TABLE OF EXAM 34-35
MARKS
DEATAILS OF STUDENTS
16 CREATE EXAM MARKS DETAILS 36-37
OF
STUDENTS & CHART
17 CREATE EMPLOYEES DETAILS 38-39
OF SALARY
18 BANK PASS BOOK 40-41
19 DAY BOOK ENTRY 42-43
20 CREATE A SIMPLE BAR CHART 44-45
TO HIGHLIGHT THE SALES OF A
COMPANY FOR 3 DIFFERENT
PERIODS
21 INTEREST CALCULATION 46-47
MS POWER POINT
22 CREATE TEXT AND IMAGES 48-49
WITH EFFECTS
23 CREATE ANIMATION AND 50-51
SOUND EFFECTS IN
POWER POINT
2
MS – ACCESS
24 PERSONAL DEATILS 53-54
25 CREATE ANIMATION AND 57-58
SOUND
EFFECTS IN POWER POINT
26 CREATE A FORM (1 to 4) 59-63
27 RELATIONSHIP OF PERSONAL 64-65
DETAILS and STUDENT MARKS
CARD
3
4
HTML
01. PROGRAM USING HEADING
TAGS
AIM: CREATE A HEADING TAG USING HTML
PROCEDURE :
< HTML>
<head>
<title> www computer </title>
</head>
<body>
<h1> Example of h1 heading </h1>
</body>
</HTML>
5
OUTPUT
HTML Program using heading tag
6
02. PROGRAM FOR TEXT FORMATING TAGS
AIM: CREATE TEXT FORMATING TAG

PROCEDURE :
<HTML>
<head>
<title>Text formating tags</title>
</head>
<body>
<b> this is bold text </b>,<br/>
<i> this is italic text </i>,<br/>
<u> this is underline text </u>,<br/>
<big> this is big text ,/big>,<br/>
<s> Rs 500 </s> new price is Rs 400 <br/>
</body>
</HTML>
7
OUTPUT
HTML Program for text
formatting tags
8
03. PROGRAM FOR UNDERLINIG THE TEXT
AIM: CREATE UNDERLINING TEXT USING HTML
PROCEDURE :
<html>
<head>
<style>
H3 Text –decoration: underline;{
</style>
</head>
<body>
<h3> this header will be underlined
</h3>
</body>
</html>
9
OUTPUT
10
04. PROGRAM USING MARQUEE TAGS
AIM: create marquee tags using html
PROCEDUR
E:
<HTML>
<head
<title> This is my site </title>
>
</head>
<body>
<marquee width = "40%.">
this is my text! </marquee>
</body>
</html
>
11
OUTPUT
Marquee tag
12
05. PROGRAM BACKGROUND COLOR
AIM: CREATING BACKGROUND COLOR
PROCEDURE :
<html>
<head>
<title>background color formating</title>
</head>
<body bgcolor="blue">
<h1>background color is blue</h1>
</body>
</html>
13
OUTPUT
HTML Program using background
color
14
06. PROGRAM UNORDERED LIST
AIM: create unordered list using html
PROCEDURE :
<HTML>
<head>
<title> unordered list</title>
</head>
<body> <font size = "5px">
<ul> my syllabus is. ,
="circle" <li> maths</li>
<li> physics</li>
<li> chemistry</li>
<li> English</li>
</ul>
</body>
</HTML
>
15
OUTPUT
Program un order list
Instead of UL write of for order list
16
07. PROGRAM ORDERED LIST
AIM: creating program ordered list using html
PROCEDURE :
<HTML>
<HEAD>
<META CHARSET=”UTF=8”/>
<TITLE> </TITLE>
</HEAD>
<BODY>
<OL TYPE “A”>
<LI>LIST ITEM1</LI>
<LI>LIST ITEM2</LI>
</OL>
</BODY>
</HTML>
17
OUTPUT
18
08. TABLE INSERTION
AIM : Creating table insertion

PROCEDURE:
<html>
<head>
<title> table insertion </title>
</head>
<body>
<table border = "/" width = "400" , height "150">
<tr><th> Name </th> Address </th> </th>
<tr><td> Riya </td> jaipur </td> </tr>
</table>
19
OUTPUT
20
09. IMAGE INSERTION
TITLE: TO CREAT A HTML PAGE WITH INSERTED IMAGE.
AIM: TO INSERT A JPG? IMAGE FILE INTO A HTML

FILE USING MS-NOTEPAD.
PROCEDURE:
<HTML>
<HEAD>
<TITLE>
IMAGE INSERTION IN HTML PAGE
</TITLE>
</HEAD>
<BODY>
<H1>
<IMG.SCR=”EXAMPLE.JPG”/>
DEPARTMENT OF COMMERCE
</H1>
</BODY>
</HTML>
21
OUTPUT
22
23
MS – WORD
10. CREATE A LETTER IN MS - WORD
TITLE: CREATE A LETTER TO THE BANK

MANAGER
AIM: To ask the previous year account statement by

using MS word
PROCEDURE:
1. Open MS Office
2. MS Word
3. File – New
4. Type letter to the SBI Manager
5. Fill all required fields, A/C Number, Name, and Mail

ID.
6. Save and Finish and Print it.
24
OUTPUT
25
11. CREATE A MAIL MERGE IN MS
WORD
AIM: To use feature of Mail merge to create invitation letter using

MS-Word
PROCEDURE:
1. Open MS Office – MS Word – File – New
2. Type the letter which has to be sent to multiple addresses.

3. Go to Tool – Letters and Mailings – Mail Merge – click
next:
4. Starting Document- Next: Select Recipients-
5. Click Type a new list-
6. Click Create – enter the address – to enter one more
7. Click New Entry.
8. To Change the field names click Customize – Select the
Field – Rename – click Ok.
9. The in Mail Merge tool bar clicks Insert Merge fields where
ever needed.
10. Then finally in the mail Merge tool bar
11. Click Merge to New document All – Ok – Save the file.
26
OUTPUT
27
12. CREATE A RESUME
TITLE: CREATE A RESUME BY USING MS – WORD
AIM: To Create Resume in MS word
PROCEDURE:
1. Open MS Office
2. MS Word
3. File – New
4. Type Resume text centre alignment
5. Fill all required fields, bio data, qualification and

Experience.
6. Save and Finish it.
28
OUTPUT
29
13. CREATION OF PROJECT REPORT COVER
PAGE
TITLE: CREATION OF PROJECT REPORT COVER

PAGE
AIM: To create a project report cover page using MS-word
PROCEDURE:
1. Open MS Office – MS Word – File – New
2. Type university name, project title, guide name etc. by line.
3. Select the text and click align centre on the standard tool
bar. Keep the cursor where needed to insert the institution
logo
4. Go to Insert – Picture – From file – and browse for the

required picture/file – then click insert.
5. Format the title of project by selecting and applying the

Wordart.
6. For that go to insert – Picture – Wordart – then chose the

style needed and click Ok.
7. To change the colour of the wordart text, right click on the

text and go to Format Wordart- chose the colour – click ok
30
OUTPUT
31
14. HEADER AND FOOTER
TITLE: CREATION OF HEADER AND FOOTER
AIM: To create a HEADER AND FOOTER

using MS-word
PROCEDURE:
1. OPEN MS OFFICE-MS
WORD-FILE- NEW
2. TYPE A TEXT
3. CLICK ON INSERT
AND SELECT HEADER AND
FOOTER OPTION
4. ADJUSTMENT
5. THEN SAVE THE FILE
32
OUTPUT
33
34
MS - EXCEL
15. CREATE A TABLE OF EXAM MARKS
DEATAILS
OF STUDENTS
TITLE: CREATE STUDENT RESULT SHEET:
AIM: To Create a Student result sheet using MS-Excel
PROCEDURE:
1. Open MS Office – MS Excel – File – New
2. Select few column and few rows at the centre of the beginning –
right click – Format cell – Click select the alignment tab – tick Merge
cells option – ok – Type the Heading.
3. Enter the column Headings. Enter the data of following columns

manually SI No, Reg. No, Name, Science, Maths, English and BCS.
4. Enter the following formula to calculate the respective values.

Total =SUM (D5:G5)
Percentage =H5/4
Result =IF (AND (D5>=35,
E5>=35,F5>=35,G5>=35),”PASS”,”FAIL”)
Class =IF (J5=“PASS”)
IF (J5>=75,”DISTINCTION”),
IF (J5>=60,”FIRST CLASS”),
IF (J5>=50,”SECOND CLASS”),
IF (J5>=35,”PASS”)))),”FAIL”)
5. Writing each formula, the cell is selected to apply the formula to

entire column
35
OUTPUT
36
16. CREATE EXAM MARKS DETAILS OF
STUDENTS
& CHART
TITLE: CREATE EXAM MARKS DETAILS OF STUDENTS
&CHART
AIM: To Create a exam marks sheet with the chart using MS-Excel
PROCEDURE:
2. Select few column and few rows at the centre of the beginning – right click –
Format cell – Click select the alignment tab – tick Merge cells option – ok –
Type the Heading.
3. Enter the column Headings. Enter the data of following columns manually SI
No, Reg. No, Name, Science, Maths, English and BCS.
4. Enter the following formula to calculate the respective values.
Total =SUM (D5:G5)

Percentage =H5/4
Result =IF (AND (D5>=35, E5>=35,F5>=35,G5>=35),”PASS”,”FAIL”)
Class =IF (J5=“PASS”)
IF (J5>=75,”DISTINCTION”),
IF (J5>=60,”FIRST CLASS”),
IF (J5>=50,”SECOND CLASS”),
IF (J5>=35,”PASS”)))),”FAIL”)
5. Writing each formula, the cell is selected to apply the formula to entire
column
6. After selecting insert choice in charts table.
7. which one you want select in the charts,ex:column,line,pie,bar etc.
8.It will be shown the chart table

37
OUTPUT
38
17. CREATE EMPLOYEES DETAILS OF
SALARY
TITLE: CREATE EMPLOYEES SALARY SLIP USING MS – EXCELL
AIM: To create employees salary statement to know their

monthly disbursement.
PROCEDURE:
1. Start – Programs – MS office
2. MS – Excel
3. File
4. New
5. Select few rows and columns
6. Right click – Form cells click Select the alignment tab
7. Tick marge cells option ok – type the heading.
8. Fill all the required fields
9. Salary sheet formulas for calculating net salary
TA 25% : =D7*25%
DA 12% : =D7*12%
HRA 15% : =D7*15%
PF 5% : = D7*5%
LOAN 10% : = D7*10%
NET SALARY =BASIC PAY+TA+DA+HRA-(PF+LOAN)

39
OUTPUT
40
18. BANK PASS BOOK
TITLE: CREATE BANK PASS BOOK ENTRY USING MS-EXCEL
AIM: To record bank transactions
PROCEDURE:
1. Start – Programs – MS Office – MS Excel
2. File
3. New
4. Select few columns and rows and the centre of the

beginning right click from the cells, click select –
Alignment tab – Tick merge cells – ok – Type the
heading
41
OUTPUT
42
19. DAY BOOK ENTRY
TITLE: CREATE A DAY BOOK IN MS EXCEL
AIM: To show the daily transactions
PROCEDURE:
1. Open MS office
2. MS Excel
3. File – New
4. Type daily income and expense transactions
5. Fill all required fields,
6. Calculate income and expenses
7. Save, Finish and Print it.
43
OUTPUT
44
20. CREATE A SIMPLE BAR CHART TO
HIGHLIGHT THE SALES OF A COMPANY FOR
3 DIFFERENT PERIODS
AIM: To create a bar Graph of a company sales sheet using

MS-Excel
PROCEDURE:
2. Select few column and few rows at the centre of the

beginning – right click – Format Cells – click Select the
alignment tab
3. Tick Merge cells option – ok – Type the Heading.
4. Select the complete row and column data including the

header.
5. Go to Insert- Chart – Bars – Select the Chart Type –

Custom type
6. Select the type – Next – Select Column – next – under Title

give the Heading at Chart title
7. Under Axes chose the Primary axis
8. Under Legends chose the Placement
9. Under data labels chose value
10. Next select the place chart Finish.
45
OUTPUT
46
21. INTEREST CALCULATION
AIM: To create a interest calculation using in MS EXCEL
PROCEDURE:
1. Open MS office-MS excel-file-new
2. select few columns and few rows at the
centre of beginning- right click format cell-
click select the alignment tab
3. Tick merge cell option-ok-type the heading
4. Enter the column heading. enter the data
of the following columns manually SL No.,
PRINCPAL,
RATE,TIME(MONTH),INTREST,TOTAL AND
INSTALMENT
5. Enter the following formula to calculate
the respective values.
INTEREST :-
=(B2*C2*D2)
TOTAL :=(B2+E2)
INSTALMENT:=(F2/
D2)
6. Enter the data in each
column 7.Then,save the
document.
47
OUTPUT
48
49
MS – POWER POINT
22. CREATE TEXT AND IMAGES WITH
EFFECTS
TITLE: TO CREAT TEXT AND IMAGES WITH EFFECTS.
AIM: TO CREAT A PRESENTATION TEXT AND IMAGES WITH

EFFECTS USING
MS-POWER POINT.
PROCEDURE:
1. Start Programs MS-Office Ms-Power point.
2. Using fields background design click background to right

Four option select apply and to
Apply any one all ok next click.
3.Go to insert Textbox click.
4. Using Text effect.
5. Go to Animation custom open effect the use Add four

method effects available.
6. Using effect select to any text go to add effect click any one
effect click apply.
7. Play to effect two method.
8. Go to click to F5 play key to affect and. click play.

9. Save the document and Exit from the MS-Power point.
50
OUTPUT
51
23. CREATE ANIMATION AND SOUND
EFFECTS IN
POWER POINT
AIM: TO CREATE A PRESENTATION HAVING ANIMATION AND
SOUND EFFECTS
USINING MS-POWER POINT.
PROCEDURE:
1. Start programs MS-Power point.
2. Using slides background design click to Background options Four

select to one next
Click.
3. Go to insert click Text box.
4. Using Animation.
5. Go to Animation Custom open effect the add use four method

effect available
.
6. Using Effect select to any image Add effect click any one effect
next click apply.
7. Go to insert click to sound Select music next click Insert.
8. Play to effect two method.
9. Go to click to button F5 play key to effect. Or click pal.
10. Save the document and Exit from the MS-Power point.
52
OUTPUT
53
54
MS - ACCESS
24. PERSONAL DEATILS
AIM: To create personal details with using ms-access
PROCESS :
Start button
go to
programs
click ms
access
select blank database
create a file name "start"
home button in that
view view design-ok
table name- personal details
finally save
55
OUTPUT
56
25. CREATE A FORM OF EXAM MARKS
DEATILS
OF STUDENTS IN MS- ACCESS
AIM: To create student details with using ms-access
PROCEDURE:
STEP 1- start --- program ms office

2007-ms access
STEP 2- go to office button –new
STEP 3- create a student details
table
STEP 4- go to create tab click form
button STEP 5- go to office button
STEP 6- select save button and click .
57
OUTPUT
58
26. CREATE A FORM
AIM: CRERATING FORM USING IN MS
ACCESS PROCEDURE:
1. Click on create in MS ACCESS
2. Select a FORM
3. Select a split form
4. Select a multiple
form 5.Select a report
wizard
6. After that show the final result of create form.
59
OUTPUT
1. Create a form
60
OUTPUT
2. Create a split form
61
OUTPUT
3. Create a multiple form
62
OUTPUT
4. Create a report wizard
63
27. RELATIONSHIP OF PERSONAL DETAILS
and
STUDENT MARKS CARD
AIM: To create personal details student details
with using ms-access
PROCEDURE:
STEP 1- start --- program ms office 2007-ms

access STEP 2- go to office button –new
STEP 3- create a student details table
STEP 4- go to create tab click form
button STEP 5- go to office button
STEP 6- go to database tools in that
click on relationship
STEP 7- select save button and click .
64
OUTPUT
65

Yallalinga Shivareddy

Uploaded by

Copyright:

Available Formats

Yallalinga Shivareddy

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Yallalinga Shivareddy

Uploaded by

Copyright:

Available Formats

JNANA TUNGA PG CENTER RAICHUR

HTML Program using heading tag

AIM: CREATE TEXT FORMATING TAG

AIM: CREATE UNDERLINING TEXT USING HTML

AIM: create marquee tags using html

AIM: CREATING BACKGROUND COLOR

<title>background color formating</title>

<h1>background color is blue</h1>

AIM: create unordered list using html

AIM : Creating table insertion

AIM: TO INSERT A JPG? IMAGE FILE INTO A HTML

IMAGE INSERTION IN HTML PAGE

10. CREATE A LETTER IN MS - WORD

TITLE: CREATE A LETTER TO THE BANK

AIM: To ask the previous year account statement by

4. Type letter to the SBI Manager

5. Fill all required fields, A/C Number, Name, and Mail

6. Save and Finish and Print it.

AIM: To use feature of Mail merge to create invitation letter using

2. Type the letter which has to be sent to multiple addresses.

TITLE: CREATE A RESUME BY USING MS – WORD

AIM: To Create Resume in MS word

4. Type Resume text centre alignment

5. Fill all required fields, bio data, qualification and

6. Save and Finish it.

TITLE: CREATION OF PROJECT REPORT COVER

AIM: To create a project report cover page using MS-word

1. Open MS Office – MS Word – File – New

2. Type university name, project title, guide name etc. by line.

4. Go to Insert – Picture – From file – and browse for the

5. Format the title of project by selecting and applying the

6. For that go to insert – Picture – Wordart – then chose the

7. To change the colour of the wordart text, right click on the

TITLE: CREATION OF HEADER AND FOOTER

AIM: To create a HEADER AND FOOTER

TITLE: CREATE STUDENT RESULT SHEET:

AIM: To Create a Student result sheet using MS-Excel

3. Enter the column Headings. Enter the data of following columns

4. Enter the following formula to calculate the respective values.

5. Writing each formula, the cell is selected to apply the formula to

4. Enter the following formula to calculate the respective values.

Total =SUM (D5:G5)

6. After selecting insert choice in charts table.

7. which one you want select in the charts,ex:column,line,pie,bar etc.

8.It will be shown the chart table

TITLE: CREATE EMPLOYEES SALARY SLIP USING MS – EXCELL

AIM: To create employees salary statement to know their

5. Select few rows and columns

6. Right click – Form cells click Select the alignment tab

7. Tick marge cells option ok – type the heading.

8. Fill all the required fields

9. Salary sheet formulas for calculating net salary

NET SALARY =BASIC PAY+TA+DA+HRA-(PF+LOAN)

TITLE: CREATE BANK PASS BOOK ENTRY USING MS-EXCEL

AIM: To record bank transactions

1. Start – Programs – MS Office – MS Excel

4. Select few columns and rows and the centre of the

TITLE: CREATE A DAY BOOK IN MS EXCEL

AIM: To show the daily transactions