DISTANCE EDUCATION
B.C.A./B.C.A (Lateral) DEGREE EXAMINATION, MAY 2018.
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 display the given set of
numbers in ascending order.
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.
2. 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.
Sub. Code
26
DE-7013
2
Ws3
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.
3. Write a program to read and display the
students particulars such as Regno, name, age, sex
using class and objects.
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.
4. Write a program to read salesman's name,
products sold and find the commission based on the
following conditions:
SALES COMMISSION
Below Rs. No commission
10,001-15,000 of sales above 10,000
15,001-20,000 250 7.5% of sales above
Above 20,000 625 10% of sales above
20,000
The output should contain name of the salesman,
products sold and the commission amount.
DE-7013
3
Ws3
Create table SALES with the following fields:
NAME, SEX, SALESCODE and SALE AMOUNT
and perform the following:
Display the records for SALE AMOUNT
5,000 and SEX
Display the record for SALE AMOUNT
between 5,000 and 6,000.
SORT the table in the descending order of
SALE AMOUNT.
5. Write a program to create a class of objects e1,
e2. The contents of object e1 are added to the object
e2 using operator overloading function.
Create table LIBRARY with the following fields:
BOOK NO, TITLE, AUTHOR, PRICE, PUBLISHER
and BRANCH. Perform the following in MSACCESS.
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.
6. Write a program to find the square of a given
number with different arguments using function
overloading.
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
DE-7013
4
Ws3
Sort the table in the descending order of
PERCENTAGE.
Display the records for DEGREE and
NAME
7. 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 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.
8. Write a program to find the sum and average of
given set of marks.
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.
————————