DISTANCE EDUCATION
B.Sc. (CS)/B.Sc. (Lateral) (Computer Science) DEGREE
EXAMINATION, MAY 2016.
LAB III APPLICATION PROGRAMS
(2007 onwards)
Time Three hours Maximum 100 marks
Examiner has to select TWO questions ONE from
Section A and another ONE from Section B.
SECTION A (50 marks)
1. Prepare a news report using two columns, insert a picture
in the first column and make the text flow around it.
2. Create a table of student data that contains REGNO,
NAME, ENGLISH, TAMIL, and MATHS marks. Add a
new column named TOTAL and find the row total for
each student.
Add two rows named TOTAL, AVERAGE. Find the total
and average values for each subject mark. Convert the
table to text.
3. Create a form letter that informs the customer about the
date of maturity of a deposit amount in a commercial
bank and request the customer for renewal. Mailmerge it
with an Access Database containing all the customer
data. Prepare letters for customers whose due date falls
in a specific range of dates.
Cut here
Cut here
Sub. Code
27
DE-9170
2
ws
4. Create a Worksheet in MS-EXCEL with the following
columns:
Employee number, Employee Name, designation, Basic
pay, Hra, Da, Lic, Pf, Grosspay, and Netpay.
Type data for empno, empname, designation,
Basicpay, lic and pf.
Calculate
hra 20% of basic
da 30% of Basic
Grosspay basic+hra+da
Netpay Grosspay — (lic pf)
Draw the bar chart between emp name and Netpay
Sort the designation column and employee column
name at a time.
5. Create Internal Marks assessment worksheet with the
following columns:
REGNO, NAME, SEX, TEST1, TEST2, TEST3, TEST,
AVERAGE, ATTENDED DAYS, ATTENDANCE
BONUS MARK, INTERNAL MARK.
Add data for 20 students (Tests marks are out of 30)
Compute TEST AVERAGE as average mark of best
two of three tests.
Maximum number of working days is 50. Each
student should secure at least 80% attendance.
Provide 1 bonus mark for each attendance above
eligibility limit 80%
Compute Internal mark as TEST AVERAGE
Bonus Mark
Sort the data in alphabetical order of name.
Filter data for male and female students alone, who
have attendance below 80.
Cut here
DE-9170
3
ws
SECTION B (50 marks)
6. Create Inventory table with fields ITEMNO, NAME,
QUANTITY ON HAND and REORDER LEVEL.
Create a form in custom format.
Create a query REORDER to show all the items
Create a macro that executes REORDER query
automatically.
7. Create employee table with the fields EMPNO, NAME,
AGE, SEX, STREET, CITY, PIN and SALARY.
Add data for 20 employees
Write a query to display all the male employees
whose salary is between 1000 and 5000 and living
in city "CHENNAI".
Write a query to display all the female employees
whose ages are in the range 50-60
Show all the record in the table for all the city
'TRICHY' by filtering.
Cut here
DE-9170
4
ws
8. Create STUDENT table with fields REGNO,I1, E1, I2,
E2, I3, E3, I4, E4, I5, E5 (internal and external marks in
five subjects) and table SUBJECT with fields SCODE1,
SNAME1, SCODE2, SNAME2, SCODE3, SNAME3,
SCODE4, SNAME4,SCODE5 (Subject code and subject
names for five subjects). Create a report to print
marksheets for the entire student in the following format.
ALAGAPPA UNIVERSITY, KARAIKUDI
STATEMENT OF MARKS
REGNO: 05315001 NAME: RAMANA S
SUBCODE SUBNAME INTERNALEXTERNALTOTALRESULT
101 SYSTEM
ANALYSIS
20 40 60 PASS
102 DBMS 22 50 72 PASS
103 VISUAL
PROGRAMMING
20 38 58 PASS
104 INTERNET
PROGRAMMING
21 27 48 FAIL
105 COMPILER
DESIGN
28 30 58 PASS
TOTAL 248
Condition for passing a subject: A minimum of 35
marks in external and 50 marks in total.
Grand total should not include total in failed
subjects.
Display FAILS in red color.