| 1. | (a) | Convert the following from one number system to another number system along with the working notes: | 5x1=5 | |
| | | (i) | (334.625)10 = ()2 | | (0) |
| | | (ii) | (1101101.0101)2 = ()10 | | (0) |
| | | (iii) | (7523)8 = ()16 | | (0) |
| | | (iv) | (15AE)16 = ()10 | | (0) |
| | | (v) | (238.5)10 = ()8 | | (0) |
| | (b) | Describe briefly, the following terms with reference to Information Technology: | 5x1=5 | |
| | | (i) | The data bus | | (0) |
| | | (ii) | Intelligent terminal | | (0) |
| | | (iii) | Overlay | | (0) |
| | | (iv) | Packet switching | | (0) |
| | | (v) | FTP | | (0) |
| | (c) | Give one or two reasons for each of the following: | 5x1=5 | |
| | | (i) | The presence of parity bit in the Coding system. | | (0) |
| | | (ii) | Integrated circuits are used for primary memory and not for secondary storage. | | (0) |
| | | (iii) | Use of Multiplexer in data communication | | (0) |
| | | (iv) | Disk formatting | | (0) |
| | | (v) | Preference of relational database model with comparison to hierarchical database model. | | (0) |
| | (d) | Write True or False for each of the following: | 5x1=5 | |
| | | (i) | In CD ROM drive, the read/write head touches the surface of the disk. | | (0) |
| | | (ii) | Formatting of numbers in Excel 2000 in similar to formatting in WORD 2000 | | (0) |
| | | (iii) | In MS–WORD, if the font size is 10 points and the line spacing is set to 1.5, then line spacing will be approximately 15 points. | | (0) |
| | | (iv) | DOS based software cannot be executed on WINDOWS 95/98 | | (0) |
| | | (v) | A graph created in Excel can be copied and linked to a power point presentation slide. | | (0) |
| 2. | Distinguish between the following: | 5x4=20 | |
| | (i) | Dynamic RAM and Static RAM | | (0) |
| | (ii) | Local area network and Wide area network | | (0) |
| | (iii) | Voice synthesizer system and Voice recognition system | | (0) |
| | (iv) | Audit around computer and Audit through the computer | | (0) |
| | (v) | The Internet and the Intranet | | (0) |
| 3. | (a) | Explain Database Management Systems (DBMS).Why does it being preferred with comparison to Traditional File Processing Systems. | 6 | (0) |
| | (b) | A moving arm disk – storage device has the following specifications: | No. of tracks per recording surface | = 200 | | Track storage capacity | = 62,500 bits | | Disk rotation speed | = 2,400 rev./minute |
Estimate the average latency and the data transfer rate of this device. | 4 | (0) |
| | (c) | An insurance company follow the following rules: | (i) | If a person's health is goods and age in between 20 and 40 years and lives in a city and sex is male, then the premium is Rs. 20 per thousand and he will be insured for maximum amount of Rs. 10.0 lakhs | | (ii) | If a person satisfies all the above conditions, except that sex is female, then the premium is Rs. 15 per thousand and maximum insured sum will be Rs. 15.0 lakhs | | (iii) | If a person’s health is poor and age is between 20 and 40 years, but lives in a village. For a male sex, premium is Rs. 50 per thousand and maximum insured sum is Rs. 1.0 lakh only. | | (iv) | In all other cases, the person is not to be insured. |
Draw a flow chart to find the eligibility of a person to be insured, premium rate and maximum amount of Insurance. | 10 | (0) |
| 4. | (a) | Discuss the role of Internet in the development of e–commerce. Describe the benefits of e–commerce. | 10 | (0) |
| | (b) | A wholesaler has three commodities to sell and has three types of customers. The discount is given as per following rules: | (i) | For Govt. orders, 15% discount is given irrespective of the value of the order | | (ii) | For orders of more than Rs. 20,000, an agent gets a discount of 20% and the retailer 15% respectively. | | (iii) | For orders of value between Rs.10,000 and Rs. 20,000, agent gets discount 15% and the retailer gets 10% | | (iv) | For order of value less than Rs. 10,000 the agent and retailer get discount 10% and 5% respectively. |
The above rules do not apply to furniture items. However, in case of furniture items, a flat rate of 10% discount is admissible to all type of customers.
Prepare a limited entry decision table. | 10 | (0) |
|
| 5. | (a) | Briefly describe the procedure of document imaging. Write the advantages of Image Processing System. | 5 | (0) |
| | (b) | Briefly explain the concept of Mail merge. | 5 | (0) |
| | (c) | Define the following financial functions used in MS–Excel | 5x1=5 | |
| | | (i) | DB | | (0) |
| | | (ii) | FV | | (0) |
| | | (iii) | NPV | | (0) |
| | | (iv) | PMT | | (0) |
| | | (v) | IRR | | (0) |
| | (d) | Define the following terms related to MS – WORD | 5x1=5 | |
| | | (i) | Fonts | | (0) |
| | | (ii) | Drop Cap | | (0) |
| | | (iii) | Header | | (0) |
| | | (iv) | Section | | (0) |
| | | (v) | Text Wrapping | | (0) |
| 6. | (a) | What is a Computer network? Describe the various networking architectures | 5 | (0) |
| | (b) | What tools are available to protect the information in network against intrusion or misuse? Discuss. | 5 | (0) |
| | (c) | Describe the procedure to perform Computer Assisted Auditing using generalised audit package. | 5 | (0) |
| | (d) | Describe the various facilities to be provided by the user friendly accounting software package. | 5 | (0) |
| 7. | Write short notes on the following: | 4x5=20 | |
| | (i) | Program Library Management System | | (0) |
| | (ii) | Expert Systems | | (0) |
| | (iii) | Storage Area Network (SAN) | | (0) |
| | (iv) | Computer Crimes and Penalty in IT Act, 2000 | | (0) |
