DISTANCE EDUCATION
B.Sc. (Computer Science)/B.Sc. (Computer Science) (Lateral)
DEGREE EXAMINATION, MAY 2018.
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. Prepare a news report using two columns, insert a
picture in the first column and make the text flow
around it in MS-WORD.
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.
2. Type lecture notes and provide audio explanation
with the help of sound files in MS-WORD.
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.
Sub. Code
27
DE-7017
2
wk14
3. 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 sales of
different products in different cities. Find the
following
Citywise Total Sales
Salesmanwise total sales
Productwise total sales
Grand total sales.
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.
4. Prepare your resume in MS-WORD with
photograph inserted. Use table, bullets and
different color features.
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.
DE-7017
3
wk14
5. Create a Worksheet in MS-EXCEL for employee
database with necessary fields.
Include 5 records.
Calculate HRA 20% of Basic pay
Calculate DA 30% of Basic pay
GROSS PAY Basic pay HRA DA.
Draw the bar chart between emp name and
Gross pay.
Prepare your resume in MS-WORD with
photograph inserted. Use table, bullets and
different color features.
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.
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.
DE-7017
4
wk14
7. 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 in MS-Excel.
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.
8. Prepare the First page of M.C.A PRACTICAL
RECORD NOTE BOOK with picture insertion and
alignment.
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.