DISTANCE EDUCATION
B.Sc. (Information Technology)/B.Sc. (Lateral) DEGREE
EXAMINATION, MAY 2017.
LAB III — APPLICATION PROGRAMS
(2007 onwards)
Time Three hours Maximum 100 marks
ONE question is given to each candidate by lot system.
Each question has two subdivisions.
1. Create a Worksheet in MS-EXCEL for employee
database with necessary fields.
Include 5 records.
Calculate HRA 20% of Basicpay
Calculate DA 30% of Basicpay,
GROSSPAY Basicpay HRA DA.
Draw the bar chart between emp name and
Grosspay.
Prepare a news report using two columns, insert a
picture in the first column and make the text flow
around it in MS-WORD.
2. Prepare the First page of M.C.A PRACTICAL
RECORD NOTE BOOK with picture insertion and
alignment.
The following were the observations made in certain
experiments for the values and given the values
of
Cut here
Sub. Code
27
DE-9522
Ws 8
2
X 1 2 3 4 5 6 7 8 9 10
Y 10 20 45 25 16 36 27 15 30 40
Compute the following
Find the mean, median and standard
deviation.
Correlation coefficient between X and Y.
Draw the bar chart and shading cells.
3. Prepare an invitation for a function to be conducted
in your Institution. Use different text orientation
and pictures to make it attractive in MS-WORD.
Create a STUDENT database with necessary tables
and fields in MS-ACCESS and prepare a statement
of MARKSHEET for students.
4. Prepare a news report using two columns, insert a
picture in the first column and make the text flow
around it in MS-WORD.
The following were the observations made in certain
experiments for the values and given the values
of
X 1 2 3 4 5 6 7 8 9 10
Y 10 20 45 25 16 36 27 15 30 40
Compute the following
Find the mean, median and standard
deviation.
Correlation coefficient between X and Y.
Draw the bar chart and shading cells.
Cut here
Cut here
DE-9522
Ws 8
3
5. Create two worksheets containing day to day house
hold expenses for the months January and
February 2015 with the following columns
ITEM AMOUNT
Stationery 25.00
Add 10 different items as shown above, for two
months in two different worksheets.
Consolidate both the months data and find the
total expenses.
Find total expenses for two months.
Create Inventory table with fields like ITEMNO,
NAME, QUANTITY ON HAND, REORDER
LEVEL. Perform the following in MS-ACCESS.
Create a form in custom format.
Create a query REORDER to show all the
items.
Create a macro that executes REORDER
query automatically.
6. Create a form letter that informs the customer
about the date of maturity of a deposit amount in
commercial bank and request the customer for
renewal. Mailmerge it with an Access. Prepare
letters for customers whose due date falls in a
specific range of dates.
Prepare your resume in MS-WORD with
photograph inserted. Use table, bullets and
different color features.
Cut here
DE-9522
Ws 8
4
7. Create a Worksheet with the following fields.
Salesman number, Salesman Name, City, Product
name, Sale Amount. Add three records for
5 different salesmen who have carried out sates of
different products in different cities. Find the
following
Citywise Total Sales
Salesmanwise total sales
Productwise total sales
Grand total sales.
Type lecture notes and provide audio explanation
with the help of sound files in MS-WORD.
8. Create employee table with the fields EMPNO,
NAME, AGE, SEX, STREET, CITY, PIN and
SALARY. Perform the following in MS-ACCESS
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".
Show all the records in the table for city
"TRICHY" by filtering.
Create the Inventory worksheet in MS-EXCEL with
necessary fields and perform the following
Enter all data items except QUANTITY ON
HAND for 10 items.
Find total stock value in inventory as a
product of total quantity on hand and total
price. Display all items in red color whose
quantity on hand is below recorder level.