KARPAGAM ACADEMY OF HIGHER EDUCATION
(Deemed to be University)
(Established Under section 3 of UGC act 1956)
Accredited with A+ Grade by NAAC in the Second Cycle
Coimbatore-641021.
DEPARTMENT OF COMPUTER APPLICATIONS
I B.Sc. Computer Science (AI&DS)
Office Automation – Practical (24SEC111)
SEMESTER: I
(2024-2027 Batch)
NAME: ___________________
REG.NO: ___________________
KARPAGAM ACADEMY OF HIGHER EDUCATION
(Deemed to be University)
(Established Under section 3 of UGC act 1956)
Accredited with A+ Grade by NAAC in the Second Cycle
Coimbatore-641021.
DEPARTMENT OF COMPUTER APPLICATIONS
BONAFIDE CERTIFICATE
REGISTER NUMBER:
This is to certify that this is a Bonafide record work done by
of I B. Sc Computer Science (AI&DS) during the academic year
July 2024 to November – 2024 and submitted for the practical examination in Office
Automation – Practical (24SEC111) held on ___________
Staff-in-charge Head of the Department
Internal Examiner External Examiner
INDEX
PAGE STAFF
S.NO DATE TITLE
NO SIGNATURE
TEXT MANIPULATION
1
BIODATA
2
FIND AND REPLACE
3
TABLES AND MANIPULATIONS
4
MAIL MERGE
5
DATA SORTING
6
MARKLIST
7
PAY BILL
8
INVOICE REPORT
9
EXCEL CHART
10
SEMINAR PRESENTATION
11
ORGANIZATION CHART
12
DISPLAY A PERCENTAGE OF
13 SEMESTER MARKS
EX.NO: 1
TEXT MANIPULATION
Date:
OUTPUT:
TEXT MANIPULATION
EX.NO: 2
BIO DATA
Date:
OUTPUT:
BIODATA
EX.NO: 3
FIND AND REPLACE
DATE:
OUTPUT:
FIND AND REPLACE
EX.NO: 4
TABLES AND MANIPULATIONS
DATE:
OUTPUT:
TABLES AND MANIPULATION
N.S. MARIC HR SEC.SCHOOL TERM
1 EXAMINATION MARKLIST
STUDENT NAME: SANJEEV B REGNO: 234543
CLASS: XII STD SECTION: A
SNO SUBJECTS MARKS
1 LANGUAGE I - TAMIL 89
2 LANGUAGE II - ENGLISH 90
3 MATHEMATICS 86
4 PHYSICS 85
5 CHEMISTRY 84
6 COMPUTER SCIENCE 89
EX.NO: 5
MAIL MERGE
DATE:
OUTPUT:
MAIL MARGE
EX.NO: 6
DATA SORTING
DATE:
OUTPUT:
DATA SORTING
ASCENDING ORDER BY NAME
S.NO NAME GENDER OCCUPATION AGE
7 AASHIQA FEMALE OFFICE ASSISTANT 27
10 ABI FEMALE PROGRAMMER 30
9 JOHN MALE PROGRAMMER 31
6 KALA FEMALE PROGRAMMER 29
3 KAVIARASU MALE OFFICE ASSISTANT 25
2 RAVI MALE HR 40
8 ROHITH MALE OFFICE ASSISTANT 28
1 SARVESH MALE PROGRAMMER 35
5 SRI FEMALE SOFTWARE ENGINEER 42
4 THARA FEMALE PROGRAMMER 30
DESCENDING ORDER BY AGE
EX.NO: 7
MARKLIST
DATE:
OUTPUT:
MARKLIST
K.P.R MATRIC.HR.SEC.SCHOOL
TERM I EXAMINATION MARKLIST
CLASS:X STD
S.NO REGNO NAME TAMIL ENGLISH MATHS SCIENCE SOCIAL TOTAL AVERAGE RESULT GRADE
1 2345 ABI 50 60 70 80 90 350 70 Pass FIRST CLASS
2 2346 BANU 45 67 78 89 89 368 74 Pass FIRST CLASS
3 2347 GEETHA 56 20 25 20 33 154 31 Fail FAIL
4 2348 RAVI 78 89 70 70 60 367 73 Pass FIRST CLASS
5 2349 SAI 90 99 89 89 86 453 91 Pass DISTINCTION
6 2350 SRI 78 98 87 87 89 439 88 Pass DISTINCTION
7 2351 SRUTHI 45 84 86 78 81 374 75 Pass FIRST CLASS
8 2352 SWATHI 56 45 81 75 59 316 63 Pass SECOND CLASS
9 2353 SWETHA 52 47 82 74 65 320 64 Pass SECOND CLASS
10 2354 THARA 58 58 60 65 78 319 64 Pass SECOND CLASS
EX.NO: 8
PAY BILL
DATE:
OUTPUT:
PAY BILL
EX.NO: 9
INVOICE REPORT
DATE:
OUTPUT:
INVOICE REPORT
EX.NO: 10
EXCEL CHART
DATE:
OUTPUT:
EXCEL CHART
EX.NO: 11
SEMINAR PRESENTATION
DATE:
OUTPUT:
SEMINAR PRESENTATION
EX.NO: 12
ORGANIZATION CHART
DATE:
OUTPUT:
ORGANIZATION CHART
EX.NO: 13
DISPLAY A PERCENTAGE OF SEMESTER MARKS
DATE:
OUTPUT:
PERCENTAGE OF SEMESTER MARKS
