CA PE II Question Papers Group II

Information Technology May 2008

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 from the rest
Marks
1. (a) Convert the following from one number system to another system along with the Working Notes: 1×5=5
(i) (65.65)10 = (…………)2 (0)
(ii) (12AE)16 = (…………)10 (0)
(iii) (39.B6)16 = (…………)8 (0)
(iv) (245)8 = (…………)16 (0)
(v) (1011.1101)2 = (…………)10 (0)
(b) Describe briefly, the following terms with reference to Information Technology: 1×5=5
(i) Flash Memory (0)
(ii) Clock Speed (0)
(iii) URL (0)
(iv) File volatility (0)
(v) Seek time. (0)
(c) Give one or more reasons of use for each of the following: 1×5=5
(i) MICR (0)
(ii) SQL (0)
(iii) Boot Record (0)
(iv) GUI (0)
(v) Disk formatting program. (0)
(d) Write True or False for each of the following: 1×5=5
(i) Computer system may function a bit faster if certain of program’s window are closed on the system running too many applications simultaneously. (0)
(ii) Binary equivalent of a terminating decimal fraction need not be terminating. (0)
(iii) Protocol is geometric arrangement of computer resources. (0)
(iv) The largest number a computer can store depend on its ‘WORD LENGTH’. (0)
(v) Formula is an equation that performs operation on worksheet. (0)
2. Distinguish between the following: 4×5=20
(i) CD–ROM and ROM–BIOS. (0)
(ii) Internet and World Wide Web. (0)
(iii) Multi–Programming and Multi–Tasking. (0)
(iv) Control Unit and ALU. (0)
(v) MODEM and Multiplexer. (0)
3. (a) Mention the advantages of DBMS. 5 (0)
(b) Discuss various issues related to data management. 5 (0)
(c) There are total 6,000 students in a university having four different disciplines. Their discipline code and yearly tuition fee per student, details are as follows:
Discipline of student Code Yearly tuition fee
Medical
Engineering
Science
Arts M
E
S
A 80,000
60,000
40,000
25,000
Draw a flowchart to read the name, discipline code of the student’s from the terminal/file. Find the total yearly revenue earned and the number of students discipline wise. Also find the percentage of contribution to the total revenue from each discipline of students.

Print the total revenue collected and the number of students, the percentage of their contribution discipline wise to the total revenue earned by the university.

10 (0)
4. (a) Describe ‘Ring Network’ as a network topology. Also mention its advantages and disadvantages. 5 (0)
(b) Define an Operating System and discuss its various functions. 5 (0)
(c) Write various steps involved to perform Mail–Merge. 5 (0)
(d) Write the steps for creating a new macro on MS–EXCEL. 5 (0)
5. (a) Describe the language tools offered in MS–WORD to aid writing. 5 (0)
(b) Define the following functions used in MS–EXCEL: 5
(i) DB( ) (0)
(ii) COUNTIF( ) (0)
(iii) INT( ) (0)
(iv) CLEAN( ) (0)
(v) NPV( ) (0)
(c) Give an account of the benefits of ‘Electronic Commerce’ application and implementation. 10 (0)
6. (a) What are the objectives of introducing IT Act, 2000? 5 (0)
(b) How is digital signature created? Describe it. 5 (0)
(c) *Mention uses of CAATs. What factors should be considered in determining whether to use CAATs? 10 (0)
7. Write short notes on any four of the following: 5×4=20
(i) Voice Recognition (0)
(ii) Touch Screen (0)
(iii) Data File Interrogation (0)
(iv) Clip Gallery (0)
(v) Enhanced features of ‘Power Point’. (0)