DISTANCE EDUCATION
B.Sc.(IT)/B.Sc.(IT) (Lateral) DEGREE EXAMINATION,
MAY 2016.
Lab III APPLICATION PROGRAMS
(2007 onwards)
Time Three hours Maximum 100 marks
Students has to do totally THREE questions, selecting ONE
question from each unit by lot system.
Break up marks
MS-Word 25
Excel 35
Access 40
Total 100
UNIT I
(MS Word)
1. Prepare your resume with required details using table,
bullets and different color features.
2. Prepare an invitation for a function to be conducted in
your institution. Use different text orientation and
pictures to make it attractive.
Cut here
Sub. Code
27
DE-9175
2
Ws7
3. Prepare the first page of B.Sc.(IT), PRACTICAL
RECORD NOTE book with picture insertion and
alignment.
4. Create a table of student's data that contains reg.no,
name, subject subject subject 3 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 marks. Convert the
table to text.
UNIT II
(MS Excel)
5. Create a worksheet with the following columns
Salesman. no, Salesman. name, city, Product. name,
Sales. Amount.
Add the records for 4 different salesman who have carried
out sales of different products in different cities. Find the
following
Citywise total sales
Salesmanwise total sales
Productwise total sales
Grand total sales.
Cut here
Cut here
DE-9175
3
Ws7
6. Create a worksheet with the following columns.
Salesman
number
Salesman
name
City Product
name
Sale
1105 KUMAR KARAIKUDI Soap 2,000
Create record for five salesman with soap, paste, powder
as products and Karaikudi, Trichy, Madurai as cities.
Find also the total sales.
7. Draw line, bar, pie charts for the data given below.
XYZ company Ltd.
Year Sales Cost Profit
2001 10,000 5,000 5,00,00,000
Add data for 10 years from 2001 to 2010. Provide titles,
legends, grids and data label.
8. The following were the observations in certain
experiments.
1 2 3 4 5 6 7 8 9 10
10 30 45 25 15 28 40 32 15 35
Draw the bar chart and shading cells.
UNIT III
(MS Access)
9. Create employee table with the fields emp.no, emp.name,
age, sex, designation, salary and write a query to display
all the male employee whose salary is between 10,000
and 50,000 and living in 'TRICHY'.
Cut here
Cut here
Cut here
DE-9175
4
Ws7
10. Create employee table with the fields Emp. No., Name,
age, sex, street, city, salary. Create datas for 10
employees and write a query to display all the male
employees.
11. Create inventory table with the fields items. no, item.
Name, qty, Reorder Level
Create a form in custom format
Create a macro that executes reorder level query
automatically.
12. Create two tables sales1, sales2 and join them to produce
a third table sales 3.