DISTANCE EDUCATION
B.C.A./B.C.A. (Lateral) DEGREE EXAMINATION,
DECEMBER 2017.
Lab II — AND MS OFFICE
(2003 Onwards)
Time Three hours Maximum 100 marks
One question is given to each candidate by lot system.
Each question has two subdivisions.
1. Write a program to illustrate addition,
subtraction, multiplication and division using a
member function which are defined out of the scope
of a class definitions.
Using MS-WORD type a CIRCULAR LETTER to be
posted to PGDCA candidates to attend Personal
Contact Programme (PCP). Format the circular
letter as it is and apply the suitable Font type and
Font size.
2. Write a program to convert the given
temperature in Celsius/ Fahrenheit to Fahrenheit/
Celsius using the formula with options for C to F
and F to C.
C
Create a table STUDENT with the following fields
REGNO, NAME, SEX, AGE, DEGREE and
PERCENTAGE. Perform the following
Display the records for SEX and
DEGREE
Sort the table in the descending order of
PERCENTAGE.
Display the records for DEGREE and
NAME
Sub. Code
26
DE-9812
2
sp3
3. Write a program to find the sum and average of
given set of marks.
Create table SALES with the following fields:
NAME, SEX, SALESCODE and SALE AMOUNT
and perform the following
Display the records for SALE AMOUNT
5000 and SEX
Display the record for SALE AMOUNT
between 5000 and 6000.
SORT the table in the descending order of
SALE AMOUNT.
4. Write a program to find the square of a given
number with different arguments using function
overloading.
Create table LIBRARY with the following fields:
BOOK NO, TITLE, AUTHOR, PRICE, PUBLISHER
and BRANCH. Perform the following in
MS-ACCESS.
Display the records TITLE='OFFICE
AUTOMATION' and AUTHOR like
Display all records for BOOK NUMBER
555101 and BRANCH
SORT the table in the ascending order of
BOOK NO.
DE-9812
3
sp3
5. Write a program to find the square of a given
number with different arguments using function
overloading.
Using MS-WORD type a CIRCULAR LETTER to be
posted to PGDCA candidates to attend Personal
Contact Programme (PCP). Format the circular
letter as it is and apply the suitable Font type and
Font size.
6. Write a program to read salesman's name,
products sold and find the commission based on the
following conditions
SALES COMMISSION
Below Rs. 10000/- No commission
10001-15000 of sales above 10000
15001-20000 250+7.5% of sales above
Above 20000 625+10% of sales above 20000
The output should contain name of the salesman,
products sold and the commission amount.
Using MS-WORD type out the Title page of your
OFFICE AUTOMATION book. Format the Title
page by the following formatting features
Centre each line, Choose appropriate font size
in each line, Choose font type where needed
for a letter display.
Draw border lines.
Use color options as appropriate.
DE-9812
4
sp3
7. Write a program to display the given set of
numbers in ascending order.
Create table ADDRESS using MS-ACCESS with the
following fields: NAME, AGE, SEX, STREET, CITY
and PIN. Perform the following
Display the fields NAME, STREET alone on
the screen.
Display all records for AGE 20.
Display the records for AGE 20 and CITY
'KARAIKUDI'.
8. Write a program to find the sum and average of
given set of marks.
Create a worksheet in MS-Excel with following
fields: REGNO, NAME, MATHS, ENGLISH,
SCIENCE and TOTAL. Perform the following
Fill the TOTAL column
Filter the candidate whose NAME
Filter the candidate whose ENGLISH 60
and TAMIL 70.