This Paper has 51 answerable questions with 0 answered.
| Roll No……… | |
| Total No. of Questions—7] | [Total No. of Printed Pages—4 |
| 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: | 5x1=5 | |
| | | (i) | (101101.011)2 = ()10 | | (0) |
| | | (ii) | (99.8125)2 = ()2 | | (0) |
| | | (iii) | (B2C)16 = ()10 | | (0) |
| | | (iv) | (2E7)16 = ()8 | | (0) |
| | | (v) | (2508)10 = ()8 | | (0) |
| | (b) | Describe briefly, the following terms with reference to Information Technology: | 5x1=5 | |
| | | (i) | Asynchronous Transmission | | (0) |
| | | (ii) | Secure System | | (0) |
| | | (iii) | Stored Program Concept | | (0) |
| | | (iv) | Bandwidth | | (0) |
| | | (v) | Web Browser. | | (0) |
| | (c) | Give one or two reasons for each of the following: | 5x1=5 | |
| | | (i) | Use of Firewall in the system. | | (0) |
| | | (ii) | Need for Boot record. | | (0) |
| | | (iii) | Need for Macro in spreadsheet. | | (0) |
| | | (iv) | Use of RS–232C port. | | (0) |
| | | (v) | Importance of Firmware. | | (0) |
| | (d) | Write True or False for each of the following: | 5x1=5 | |
| | | (i) | Thermal printer is an impact printer. | | (0) |
| | | (ii) | Time required to position the movable read/write head over the desired track is termed as seek time. | | (0) |
| | | (iii) | In worksheet the cell 65231 to 256th column will be referred as IV 65231. | | (0) |
| | | (iv) | In word processing package, Header and Footer can be selected from the VIEW menu. | | (0) |
| | | (v) | In MS–POWER POINT, changes can be made on the individual slide without making changes in the slide master. | | (0) |
| 2. | Distinguish between the following: | 5x4=20 | |
| | (i) | Data Bus and Address Bus. RAM | | (0) |
| | (ii) | Transaction File and Master File. | | (0) |
| | (iii) | Work Station and Micro–computer. | | (0) |
| | (iv) | Centralized Processing and Distributed Processing. | | (0) |
| | (v) | PROM and EPROM. | | (0) |
| 3. | (a) | Define an Operating System and discuss its various functions. | 5 | (0) |
| | (b) | Describe the main functions performed by the Database Administrator. | 5 | (0) |
| | (c) | A bank accepts fixed deposit for a year or more and the policy on interest rate is as follows: | (i) | If a deposit is less than Rs. 10,000 and for two or more years, the interest rate is 5% compounded annually. | | (ii) | If a deposit is Rs. 10,000 or more, but less than Rs. 50,000 and for two or more years, the interest rate is 7% compound annually. | | (iii) | If the deposit is Rs. 50,000 or more and is for one year or more the interest rate is 8% compounded annually. | | (iv) | On all deposits for five years or more interest rate is 10% compounded annually. | | (v) | On all other deposits not covered by the above conditions, the interest rate is 3%. | | (vi) | If the customer is holder of any type of account for last five years, an additional 1% interest is allowed. |
Draw a flow chart to obtain the money in customer’s account and interest credited at the time of withdrawal. | 10 | (0) |
| 4. | (a) | Explain various features offered by e–mail software. | 5 | (0) |
| | (b) | Describe the various factors which have contributed to the growth of Local Area Network (LAN). | 5 | (0) |
| | (c) | Discuss the several integrity controls that DBMS package supports. | 10 | (0) |
|
| 5. | (a) | Communication software is an essential requirement of Data Communication system. Explain the various functions of this Data Communication Software. | 5 | (0) |
| | (b) | Describe any five formatting features available in MS–WORD. | 5 | (0) |
| | (c) | Define the following terms related to office productivity tools: | 5x1=5 | |
| | | (i) | PV | | (0) |
| | | (ii) | LEN | | (0) |
| | | (iii) | SQRT | | (0) |
| | | (iv) | Goal Seek | | (0) |
| | | (v) | Thesaurus | | (0) |
| | (d) | Define the following functions with respect to spreadsheet package: | 5x1=5 | |
| | | (i) | COUNT (range) | | (0) |
| | | (ii) | STD (range) | | (0) |
| | | (iii) | MOD (x/y) | | (0) |
| | | (iv) | INT (x) | | (0) |
| | | (v) | ROUND (x, n) | | (0) |
| 6. | (a) | Explain Electronic Data Interchange (EDI) and its advantages. | 5 | (0) |
| | (b) | Explain the concept of communication protocols. | 5 | (0) |
| | (c) | What is General Audit Package (GAP)? Describe the various facilities to be provided by the GAP? | 5 | (0) |
| | (d) | Describe the scope of Information Technology Act, 2000 | 5 | (0) |
| 7. | Write short notes on the following: | 4x5=20 | |
| | (i) | Bar Code Reader | | (0) |
| | (ii) | Digital Signature | | (0) |
| | (iii) | Voice Messaging. | | (0) |
| | (iv) | White Box Approach for Audit | | (0) |
