| 1. | (a) | Convert the following from one number system to another number system along with the working notes: | 5x1=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: | 5x1=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: | 5x1=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: | 5x1=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: | 5x4=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 of database. | 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: | 5x1=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: | 4x5=20 | |
| | (i) | Microsoft Windows. | | (0) |
| | (ii) | Data dictionary | | (0) |
| | (iii) | Extranet | | (0) |
| | (iv) | Cyber Regulation Appellate Tribunal, as per IT Act, 2000. | | (0) |
