DISTANCE EDUCATION
B.C.A./B.C.A. (Lateral) DEGREE EXAMINATION, MAY 2016.
LAB II — AND MS OFFICE
(2003 onwards)
Time Three hours Maximum 100 marks
Examiner has to select and give ONE question to each
candidate by LOT system.
1. Write and run a program to create a class of
objects e1, e2. The contents of object e1 is added to
the object e2 using the operator overloading
technique.
Using the MS-WORD type out the Title Page of
your OFFICE AUTOMATION Book. Format the
Title page by the following formatting features:
Centre each line
Draw border lines
Use color options
Choose appropriate font size in each line
Choose font type where needed for a letter
display
Sub. Code
26
DE-9166
2
wk12
2. Write and run a program to read and display
the students particulars such as Regno. name, age
and sex using class and objects.
Create STUDENT table with the following fields:
Regno, Name, Age, Sex, Degree, Percentage
Display the records for Sex and Degree

Display the records for Sex and
Percentage between 80 and 90
Display the records for Degree and
Name like
Sort the table in descending order of
Percentage.
3. Write and run a program to read the derived
class data members such as name, roll number, sex,
height and weight from the keyboard and display
the contents of the class on the screen. (Single
Inheritance Concept)
Using the MS-WORD type a CIRCULAR LETTER
to be posted to BCA candidates to attend Personal
Contact Programme (PCP).
Format the Circular Letter as it is and apply the
suitable font type and font size.
4. Write and run a program to find the square of
the given number with different arguments using
function overloading.
Create a worksheet in Excel with the following
fields: Year, Sales, Expense, Profit. Draw various
graphs and mention the appropriate headings.
Cut here
Cut here
DE-9166
3
wk12
5. Write and run a program to illustrate such as
addition, subtraction, multiplication and division
using a member function which are defined out of
the scope of a class definition.
Create ADDRESS table with the following fields:
Name, Age, Sex, Street, City, Pincode.
Display the fields Name, Street alone on the
screen
Display the records for Age 20
Display the records for Age 20 and City
'Karaikudi'
Sort the table in ascending order of Name.
6. Write and run a program to display the given
set of numbers in ascending descending order.
Create a worksheet in Excel with the following
fields:
Sno, Regno, Name, Age, Maths, Physics, Chemistry,
Tamil, English, Total, Average, Result.
Fill the total column
Replace the RESULT with PASS for average
50 else fail
Format average column with 2 decimals
Find the maximum mark for each subject
Fine the minimum mark for each subject
Cut here
DE-9166
4
wk12
7. Write and run a program to find the sum and
average of given set of marks.
Create SALES table with the following fields:
Name, Sex, Sale_code, Sale_amount
Display the records for Sale_amount 5000
and Sex
Display the records for Sex and
Sale_amount between 5000 and 10000
Display the records for Sale_amount 5000
Sort the table in descending order of
Sale_amount
8. Write and run a program to convert
given temperature in Celsius/Fahrenheit to
Fahrenheit/Celsius using the formulae with options
for C to F and F to C.
F C 32, C 32)
Create a worksheet in Excel with the following
fields:
Regno, Name, Maths, English, Science, Total
Fill the total column
Fill the candidates whose regno l24
Filter the candidate whose name 'rajesh'
Filter the candidate whose English mark 60.