DISTANCE EDUCATION
B.Sc. (IT)/B.Sc. (Lateral) DEGREE EXAMINATION,
DECEMBER 2017.
Lab III — APPLICATION PROGRAMS
(2007 Onwards)
Time Three hours Maximum 100 marks
One question should be given to each candidate by LOT
system.
1. Using mailmerge send a letter to all customers
about the date of maturity of a deposit amount in a
commercial bank.
Create the following inventory worksheet in
MS-Excel.
ITEMNO, NAME, PRICE, STOCK, PURCHASED,
ISSUED, QUANTITY ON HAND
Enter all the data items except QUANTITY
ON HAND for 10 items.
Find QUANTITY ON HAND using the
formula
QUANTITY ON HAND STOCK
PURCHASED ISSUED
Create STUDENT table with the following fields
REGNO, NAME, M1, M2 and M3
Create ADDRESS table with fields
REGNO, STREET, CITY and PIN
Write a query to display REGNO, NAME and
total marks.
Write a query to display REGNO, NAME,
STREET, CITY and PIN.
Sub. Code
27
DE-9821
2
sp3
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.
Create a worksheet for EB bill
CONSNO TYPE NAME PMR CMR UNITS AMT
... ... ... ... ... ... ...
Add data for 10 consumers with type D for
domestic user and type I for industrial user.
Calculate the EB bill for each customer by
assuming your own slab rate.
All the consumers should be charged a
minimum of Rs. 100 even if their bill amount
is below Rs. 100.
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 female
employees whose ages are in the range 30 to
40.
Show all the records in the table for the city
"TRICHY" by filtering.
DE-9821
3
sp3
3. Type lecture notes and provide audio explanation
with the help of sound files.
Create a worksheet with following columns
Employee number, Name, Designation, Basic pay,
HRA, DA, LIC, PF, Gross pay and Net pay.
Type data for employee number, Name,
Designation, Basic pay, LIC and PF.
Calculate HRA 20% of Basic pay
DA 30% of Basic pay
Gross pay Basic pay HRA DA
Net pay Gross pay (LIC PF)
Draw the bar chart between employee name
and net pay.
Create two tables SALES1, SALES2 and joint them
to produce a third table SALES3.
4. Prepare an invitation for a function to be conducted
in your institution.
Create a worksheet with the following columns.
Salesman number, Salesman name, City, Product
name, Sales Amount.
Add 5 records for five different salesmen who have
carried out sales of different products in different
cities. Find the following
City total sales
Salesmen wise total sales
Product wise total sales.
Create inventory table with fields ITEMNO, NAME,
QTY, 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.