1
ST. JOSEPH’S COLLEGE OF COMMERCE (AUTONOMOUS)
END SEMESTER EXAMINATION – OCTOBER 2013
M.I.B. – III SEMESTER
ADVANCED COMPUTER APPLICATIONS FOR BUSINESS
Duration: 3 Hours Max. Marks: 100
SECTION – A
I) Answer any SEVEN questions Out of TEN. (7×5=35)
1. Explain data processing cycle with relevant example?
2. What is real time data processing? Specify any two advantages of real time data
processing?
3. What are the main objectives of information systems audit?
4. Explain the factors to be considered while planning an information systems audit in
an IT organization?
5. Discuss the stages in security life cycle with relevant example?
6. How is Information Technology impacting the changes in the 21st century workplace?
7. What is ITES? Discuss the application of ITES in various areas of business?
8. What are the business advantages of Ms-Excel application?
9. “One of the main advantages of MIS is to facilitate effective managerial decision
making” Discuss?
10. What are the components of a computer system? Explain the utility of the computer
components?
SECTION – B
II) Answer any THREE out of FIVE. (3×15=45)
11.
a. Explain the framework for conducting information systems audit? (10 marks)
b. Discuss the relationship between capability maturity model Levels and IS audit with
an example? ( 5 Marks)
12. “The 21st century business is built on highly sensitive information” Discuss the
statement from the perspective of an Information technology organization?
13. What is BPO? Explain the conceptual framework of BPO implementation in any
service sector?
2
14. a) What are advantages of computer applications in various areas of business?
(10 marks)
b) What are the computer related jobs available in the market for a commerce
graduate? (5 marks)
15.
a) Explain in detail the phases of system development life cycle with relevant
examples? (12 marks)
b) Is SDLC part of Information Technology project management method? ( 3 marks)
SECTION – C
II) Case Study – Compulsory question (No Choice) (1×20=20)
16.
Noida Public Library is the biggest library in Noida. Currently it has about 300 members.
A person who is 18 or above can become a member. There is a membership fee of Rs 400
for a year. There is a form to be filled in which person fills personal details. These forms
are kept in store for maintaining members’ records and knowing the membership period.
A member can issue a maximum of three books. He/she has three cards to issue books.
Against each card a member can issue one book from library. Whenever a member
wishes to issue a book and there are spare cards, then the book is issued. Otherwise that
request is not entertained. Each book is to be returned on the specified due date. If a
member fails to return a book on the specified date, a fine of Rs 2 per day after the due
return date is charged. If in case a card gets lost then a duplicate card is issued. Accounts
are maintained for the membership fees and money collected from the fines. There are
two librarians for books return and issue transaction. Approximately 100 members come
to library daily to issue and return books.
There are 5000 books available out of which 1000 books are for reference and cannot be
issued.
Records for the books in the library are maintained. These records contain details about
the publisher, author, subject, language, etc. There are suppliers that supply books to the
library. Library maintains records of these suppliers. Many reports are also produced.
These reports are for details of the books available in the library, financial details,
members’ details, and supplier’s details.
Currently all functions of the library are done manually. Even the records are maintained
on papers.
Now day by day members are increasing. Maintaining manual records is becoming
difficult task.
3
There are other problems also that the library staff is facing. Like in case of issue of
duplicate cards to a member when member or library staff loses the card. It is very difficult
to check the genuinely of the problem. Sometimes the library staff needs to know about the
status of a book as to whether it is issued or not. So to perform this kind of search is very
difficult in a manual system. Also management requires reports for books issued, books in
the library, members, and accounts. Manually producing the reports is a cumbersome job
when there are hundreds and thousands of records.
Management plans to expand the library, in terms of books, number of members and
finally the revenue generated. It is observed that every month there are at least 50-100
requests for membership. For the last two months the library has not entertained requests
for the new membership as it was difficult to manage the existing 250 members manually.
With the expansion plans, the management of the library aims to increase its members at
the rate of 75 per month. It also plans to increase the membership fees from 400 to 1000
for yearly and 500 for half year, in order to provide its members better services, which
includes increase in number of books from 3 to 4.
Due to the problems faced by the library staff and its expansion plans, the management is
planning to have a system that would first eradicate the needs of cards. A system to
automate the functions of record keeping and report generation. And which could help in
executing the different searches in a faster manner.
Questions:
1. What is System analysis and Design? What is the role of Systems analyst in
performing SAD? (5 marks)
2. As a systems analyst, perform the system analysis and design (SAD) and identifying
the problems of the current system study the feasibility of a new automated system
and provide solution to the management of the library?- (15 marks)
Latest Govt Job & Exam Updates: