Alagappa University 2007 B.Sc Computer Science LAB III — APPLICATION PROGRAMS - Question Paper

DISTANCE EDUCATION
B.Sc. (Computer Science) DEGREE EXAMINATION,
MAY 2008.
LAB III — APPLICATION PROGRAMS
(2007 onwards)
Time : 3 hours Maximum : 100 marks
Students has to ans 2 questions, by selecting 1 ques. from every part by lot.
part A — (50 marks)
Create a table of learner data that contains REGNO, NAME , ENGLISH, TAMIL and MATHS marks. Add a new column named TOTAL and obtain the row total for every learner.
Add 2 rows named TOTAL, avg.. obtain the total and avg. values for every subject mark. Convert the table to text.

Create the subsequent Inventory worksheet in
MS-EXCEL.

Item No Name Price Quantity purchased Issued Stock
208 Bolts 5.00 500 200 300
(a) Enter all the data items other than stock for 10 items.
(b) Find stock using the formula
Stock = volume Purchased -Issued
Find total stock value in inventory as a product of stock and price. Display all the items in red color whose stock is beneath 200.
Draw Line, Bar, PIE charts for the data provided beneath :

ABC COMPANY LIMITED
YEAR SALES COST PROFIT
1991 1000 400 600
Add data for 10 years from 1991 to 2000. give titles, legends, grids and data tags.
part B — (50 marks)
Create employee table with the fields, Empno, Name, Age, sex, street , city, pincode salary.
(a) Add data for 20 employees.
(b) Write a query to display all the male employees whose salary is ranging from 1000 and 5000 and residing in city ‘‘CHENNAI’’.
(c) Write a query to display all the female employees whose ages are in the range 50-60.
(d) Show all the records in the table for the city ‘‘TRICHY’’ by filtering.

Create students table with the subsequent fields Regno, Name, marks of maths, physics, chemistry. Create address table with fields Regno, street, city and pincode.
(a) Write a query to display Regno, name and total of the 3 subject marks.
(b) Write a query to display Regno, name ,street city, pincode and total of all the 3 subject marks.
Create 2 tables sales 1, sales two and join them to produce a 3rd table sales 3.

Earning:   Approval pending.