CA PE II Question Papers Group II

Information Technology  May 2003

This Paper has 47 answerable questions with 0 answered.

Total No. of Questions—7
Time Allowed : 3 Hours

Maximum Marks : 100
Answers to questions are to be given only in English except in the cases of candidates who have opted for Hindi medium. If a candidate who has not opted for Hindi medium, answers in Hindi, his answers in Hindi will not be valued.
Question No.1 is compulsory
Answer any four questions from the rest
Marks
1. (a) Convert the following from one number system to another number system along with the working notes: 5×1=5
(i) (295.5625)10 = ()2 (0)
(ii) (1011.1011)2 = ()10 (0)
(iii) (592F)16 = ()10 (0)
(iv) (436.625)10 = ()8 (0)
(v) (6437)8 = ()16 (0)
(b) Describe briefly, the following terms with reference to Information Technology: 5×1=5
(i) BIOS (0)
(ii) File Allocation Table (0)
(iii) Routers (0)
(iv) Public Key (0)
(v) Uniform Resource Locators (0)
(c) Give one or two reasons for each of the following: 5×1=5
(i) Use of spooling software. (0)
(ii) Cache memory in processor (0)
(iii) Boot strap loader is an essential system software. (0)
(iv) Birth of the Information Technology Act, 2000 (0)
(v) Need of modern in data communication. (0)
(d) Write True or False for each of the following: 5×1=5
(i) The WINDOWS 95/98 is based on 16 bit architecture. (0)
(ii) In MS–EXCEL if a cell pointer points to a cell that contains data, then that data will also be displayed in the formula bar. (0)
(iii) The decision support system is useful for structured problems. (0)
(iv) Two dissimilar devices in a network can communicate with each other using bridges. (0)
(v) Multiprocessing refers to the use of two or more central processing units to perform coordinated work simultaneously. (0)
2. Distinguish between the following: 5×4=20
(i) Virtual memory and main memory. (0)
(ii) Distributed system and computer network. (0)
(iii) Multiprogramming and Multitasking systems. (0)
(iv) Synchronous and Asynchronous data transmission. (0)
(v) DDL and DML. (0)
3. (a) Describe various factors which determine the best file organisation. 5 (0)
(b) Define Graphical User Interface (GUI). Why is it mostly used these days? Explain. 5 (0)
(c) An electricity distribution company has three categories of consumers namely –
(i) Domestic
(ii) Commercial
(iii) Industry
The charges of electricity per unit consumed by these consumers are Rs. 3, Rs. 4 and Rs. 5 respectively. The computer database of the company has following information:
– Consumer’s name
– Category
– Units consumed
– Bill date
– Date of payment.
The company processes bills according to the following criterion.
If the consumer is domestic and pays his bill within 10 days of the bill date, 5% discount is given. If he pays the bill within 15 days, no discount is given. If he makes the payment after 15 days of the bill date, 10% surcharge is levied. For the non-domestic consumers (commercial or industry), corresponding percentages be 10%, 0% and 15% respectively.
Draw a flowchart to calculate the bill amount, discount, surcharge and net amount of the bill for each type of consumer and print it.

10 (0)
4. (a) What is Electronic Data Interchange (EDI) Describe various advantages of the EDI. 5 (0)
(b) Explain in brief, the concept of voice messaging. 5 (0)
(c) Explain the term Network structure, Describe various types of network structures and discuss their suitability. 10 (0)
5. (a) Explain briefly the various language tools available in MS–WORD 5 (0)
(b) Discuss the importance of “data volume” and “usage analysis” in the design ofdatabase. 5 (0)
(c) Explain the concept of MACRO in MS–EXCEL and list the procedure to create it. 5 (0)
(d) Define the following terms related to office productivity tools: 5×1=5
(i) NPER (0)
(ii) ABS (0)
(iii) STDEV (0)
(iv) Tri–Pane view (0)
(v) Bullets (0)
6. (a) Explain the main objectives of IT Act, 2000. 5 (0)
(b) Explain the term World Wide Web. What do you understand by Internet Surfing? Explain? 5 (0)
(c) Describe the various factors which determines the use of Computer Assisted Audit Techniques (CAAT) 5 (0)
(d) Describe the salient features of EX.NGN according package. 5 (0)
7. Write short notes on the following: 4×5=20
(i) Microsoft Windows. (0)
(ii) Data dictionary (0)
(iii) Extranet (0)
(iv) Cyber Regulation Appellate Tribunal, as per IT Act, 2000. (0)