DISTANCE EDUCATION
M.C.A. DEGREE EXAMINATION, MAY 2017.
First Semester
LAB II — MS OFFICE AND INTERNET
(2005 to 2010 calendar year)
Time Three hours Maximum 100 marks
Examine should select and give ONE question to each
candidate by LOT system.
1. Prepare a news report using two columns, insert a
picture in the first column and make the text flow
around it.
Create a HTML page that receives employee name,
age, street, city, pin code. Receive male/female and
married/unmarried details through option buttons.
Receive hobbies through check boxes.
2. Create a worksheet in Excel for electricity bill
Consumer User Name Previous Current units Bill
Number type Reading Reading
Add data for 10 customers with type D for
domestic user and type I for industrial user.
Find units column for each customer and
calculate bill using different slab rates
(Assume your own slab rates)
All the consumers should be charged a
minimum bill of Rs.50 even if their bill
amount is below Rs. 50.
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.
Sub. Code
16
Cut here
DE-9533
2
wk10
3. Create employee table with the fields; empno, name,
age, sex, street, city, pin, salary.
Add data for 10 employees
Write a query to display all the male
employees whose salary is between 10000 and
50000 and living in city
Show all the records in the table for the city
by filtering.
Create a HTML page that plays video and audio
files.
4. Prepare the first page of MCA practical record not
book with picture insertion and alignment.
Develop a complete set of web pages to describe
your skills in various areas.
5. Create a worksheet with the following columns
Salesman number, salesman name, city,
Product name, sale amount.
Add three records for five different salesman who
have carried out sales of different products in
different cities. Find the following
City wise Total Sales
Salesman wise Total Sales
Product wise Total Sales
Grand Total sales.
Create HTML page that divides the screen space
into three frames (one vertical and two horizontal
of equal size) Display three different files in them
with scrolling titles relevant to their contents.
Cut here
Cut here
DE-9533
3
wk10
6. Create two tables SALES SALES 2 and join them
to produce a third table SALES 3.
Create HTML page to display ten courses and their
highlighted features, conducted by an educational
institution in a colorful format.