DISTANCE EDUCATION
M.C.A. DEGREE EXAMINATION, DECEMBER 2017.
First Semester
Lab II MS OFFICE AND INTERNET
(2005-2010 Calendar Year)
Time Three hours Maximum 100 marks
Breakup Marks
Record Note Book 5
Algorithm/Flow chart 15
Program 35
Debugging and Execution 35
Result 10
Total 100
Answer any TWO questions choosing ONE from
Section A and another from Section B.
Each question carries 50 marks.
SECTION A
1. Draw Line, Bar, Pie charts for the data given
below
ABC Company Ltd.
Year Sales Cost Profit
1991 1000 400 600
Add data for 10 years from 1991 to 2000. Provide
titles, legends, grids and data labels.
Sub. Code
16
DE-9831
2
Ws9
2. Create STUDENT table with the following fields
REG NO, NAME, MARK MARK MARK 3. Create
Address table with fields REG NO, STREET, CITY and
PIN.
Write a query to display REG NO, NAME and
TOTAL of all the 3 subject marks.
Write a query to display REG NO, NAME, STREET,
CITY, PIN and total of all the 3 subject marks.
3. Create Inventory table with fields ITEM NO, NAME,
QTY ON HAND, 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.
4. Prepare your resume with your photograph inserted. Use
table, bullets and different color features.
5. Prepare a news report using two columns, insert a picture
in the first column and make the text flow around it.
6. Prepare an invitation for a function to be conducted in
your institution. Use different text orientation and
pictures to make it attractive.
DE-9831
3
Ws9
8. Create a work sheet in EXCEL with the following
columns.
Employer no, Name, Designation, Basicpay, HRA, DA,
LIC, PF, Grosspay, Net pay
Type data for Emp no, Name, Designation,
Basicpay, LIC and PF.
Calculate HRA 20% of Basic
DA 30% of Basic
Grosspay Basic HRA DA
Netpay Grosspay (LIC PF)
Draw the bar chart between Emp name and Netpay.
Sort the designation column and employee name
column at a time.
SECTION B
9. Create HTML page that plays video and audio files.
DE-9831
4
Ws9
10. Create HTML page to display the pictures of Elephant
and Monkey. Link to another page when user clicks over
the picture. The linked page should display features of
the animal clicked.
11. Create HTML page that divides the screen space into
3 frames (one vertical and two horizontal of equal size).
Display 3 different files in then with scrolling titles
relevant to their contents.
————————