1
ST. JOSEPH’S COLLEGE OF COMMERCE (AUTONOMOUS)
END SEMESTER EXMAINATION – OCTOBER 2013
B.B.M – III SEMESTER
COMPUTER APPLICATIONS & MANAGEMENT INFORMATION SYSTEM
TIME: 3 HOURS Max. Marks: 100
SECTION – A
I) Answer the following questions briefly in two or three sentence (10×2=20)
1. What are the advantages of using Pivot table in MS-Excel?
2. Why MS-Excel is known as a general purpose language?
3. What do you mean by slide transition in MS-PowerPoint?
4. How to prepare a simple HTML document?
5. What is DBMS? Point out any two advantages of using this.
6. What do you mean by structured system design?
7. What are the differences between Decision Support System and Management
Information system?
8. What do you mean by Data Warehouse?
9. How will you apply spell check in MS word?
10. What do you mean by Forms in MS Access?
SECTION -B
II) Answer ANY FOUR questions from the following: (4×5=20)
11. Explain sumif() and countif() with an example?
12. Explain Transaction Processing System?
13. How to insert an image in a web page. What are the attributes of image tag?
Explain with an example.
14. Why the database is important in Management Information System. Explain.
15. What do you mean by Macro in MS word? How to set Macro in MS Word.
16. Write commands for the operations based on the spreadsheet.
2
A B C D E F G H
NAME BASIC HRA DA PF DEDUCTIONS GROSS NET
1 AJAY 6500 0
2 AMIR 6800 500
3 ANIL 5800 0
4 AMIT 9000 0
Allocate the cell location address according to the table and compute the
following:
1. Calculate the HRA 13% of BASIC for all employees in the table.
2. Calculate DA 25% of BASIC+HRA for all employees in the table.
3. Calculate PF as 10% of the Basic for all employees in the table.
4. Calculate GROSS salary(BASIC+HRA+DA+PF).
5. Calculate NET =GROSS deduct PF and all DEDUCTIONS for all employees in
the table.
SECTION – C
III) Answer ANY THREE questions from the following: (3×15=45)
17. Explain any six financial functions and statistical functions in MS-Excel?
18. How the internet technologies be involved in improving any one of the
functions of business. Explain.
19. Explain Decision Support System.
20. Explain the body tag of HTML with all attributes. Give an example program
with all body attributes.
21. Explain data manipulation tools in MS-Excel with example.
3
SECTION – D
IV) Compulsory Question. (1×15=15)
Egghead Software, a Washington based company, enjoyed great success as the
nationwide chain of stores that sold only software. The chain grew to comprise
more than 200 stores, employing thousands of workers and earning millions of
dollars in revenues. Egghead’s success attracts competitors, including mass
merchandisers such as Wall-Mart and CompUSA, who began selling software
at discounted prices. As software prices fell, Egghead was unable to compete
successfully and began suffering operating losses.
Needing a change in direction, Egghead board of directors turned to
George Orban, a longtime Egghead investor with a track record for turning
around failing businesses. Orban, who joined Egghead as chairman and CEO,
believed that the only way to save Egghead was to simplify the business by
closing stores, cutting cost, and better identifying the company’s target market.
He began Egghead’s turnaround with massive cost cutting program that
involved closing more than 70 stores and a distribution center, selling real
estate holdings, and laying off hundreds of employees. The merchandise at
some of the remaining stores was switched to a more profitable product mix
that included computer systems and accessories.
Questions:
1. Would these changes be enough to save Egghead?
2. Whether to close the brick-and-mortar stores and go for another option? If
so, How they can achieve online sales?