Utility software helps to maintain proper and smooth functioning of a computer system. Justify it with proper examples.
Describe the criteria for evaluation when purchasing a new laptop.
What is Open Source operating System? Explain major functions of Operating System.
What is a geographic information system? Describe its elements.
Write DOS commands with example to perform following tasks.
a) Retrieve the IP address of a specific website.
b) Move the files from one location to another.
c) Delete existing non-empty directory.
d) Search for a specific file or directory.
e) Check the available disk space on a driver.
What is DBMS? Explain the advantages of DBMS over flat-file system.
Compare and contrast between peer to peer and Client/Server network architecture.
Attempt any TWO questions
[2x10=20]Draw a block diagram of a digital computer and explain each unit in detail.
a) Explain memory hierarchy.
b) What is layer in Photoshop? What are the main features and tools available in Photoshop?
Consider the following spreadsheet and write appropriate formulas:
| ID | Customer Name | Previous Reading | Current Reading | Consumption | Price | Discount | Total Amount |
|---|---|---|---|---|---|---|---|
| 1 | Ram Rai | 256 | 406 | ? | ? | ? | ? |
| 2 | Mohan Baskota | 425 | 525 | ? | ? | ? | ? |
| 3 | Sita Subba | 420 | 670 | ? | ? | ? | ? |
| 4 | Hari Rajbansi | 920 | 1457 | ? | ? | ? | ? |
| 5 | Binod KC | 650 | 1245 | ? | ? | ? | ? |
| 6 | Ajay Tandukar | 456 | 1245 | ? | ? | ? | ? |
| 7 | Hom Joshi | 478 | 1657 | ? | ? | ? | ? |
| 8 | Binshnu Acharya | 654 | 4578 | ? | ? | ? | ? |
| 9 | Krishna Khanal | 478 | 1245 | ? | ? | ? | ? |
| 10 | Nirjal Dhamal | 654 | 879 | ? | ? | ? | ? |
Maximum Consumption: ?
Minimum Consumption: ?
b) To calculate the Price, add the Rs. 75 monthly meter costs to the following rates: Rs. 5 per unit for the first 100 units as minimum charge, Rs. 10 per unit for the next additional 150 units, and Rs. 20 per unit for additional units exceeding 250.
c) XYZ Water Supply intends to offer its customers a festive discount based on their consumption and price. If consume unit equal or more than 250 units, calculate 5% discount on Price, similarly if consume unit equal or more than 150, calculate 2% discount otherwise calculate 1%.
d) Total Amount = Price minus Discount.
e) Find maximum and Minimum consumption unit. [1]