Computer Science)/B.Sc. (Lateral) DEGREE
EXAMINATION, MAY 2017.
LAB III — APPLICATION PROGRAMS LAB
(2007 onwards)
Time Three hours Maximum 100 marks
Examiner has to select and give one question to the
candidate by lot system.
1. Prepare your resume with your photograph. Use
table, Bullets and different color features.
Draw line, bar and pie charts for the data given
below
XYZ Ltd
Year Sales Cost Profit

Add data for 10 years from 2001 to 2010 provide
titles, legends, grids and data labels.
2. Prepare the first page of B.Sc. practical record note
book with picture insertion and alignment.
Create employee table with the fields
Empno, name, age, sex, street, city, pin, salary.
Add data for 5 employees.
Write a query to display all the male
employees whose salary is below 10,000.
Write a query to display all female employees
whose ages are in the range 20 to 25.
Show all the records in the table for the city
"TRICHY" by filtering.
Cut here
Sub. Code
27
DE-9517
2
wk7
3. Prepare a news report using two columns, insert a
picture in the first column and make the text flow
around it.
Create two worksheets containing day to day house
hold expenses for the months April and May 2015,
with the following columns
Item Amount


Add 10 different items for two months in two
different worksheets.
Consolidate both the months data and find
the total expenses on each item.
4. Type lecture notes and provide audio explanation
with the help of sound files.
Create STUDENT table with the following fields
regno, name, m1, m2, m3.
Create ADDRESS table with the fields
regno, street, city, pin.
Write a query to display regno, name and total
of all three subject marks.
Write a query to display regno, name, street,
city, pin and total of all three subject marks.
Cut here
DE-9517
3
wk7
5. Prepare an invitation for a function to be conducted
in your institution. Use different text orientation
and pictures to make it attractive.
The following were the observations made in certain
experiments for the values y and given the value of
x .
x 1 2 3 4 5 6 7 8 9 10
y 10 30 45 25 15 28 40 32 15 35
Compute the following
Mean, median and standard deviation.
Correlation coefficient between x and y .
Draw the bar chart and shading cells.
6. Create a table student data that contains regno,
name, English, Tamil, Maths marks.
Add a new column named total and find the row
total for each student.
Create two tables SALES 1 and SALES 2. Join
them to produce a third table SALES 3.