BSC.CSIT-1 Semeater(Fundamental of Computer and IT)
1. What are the technologies used in generation of computer? Explain.
2. Classify the computer? Explain about the types of computer according to size.
3. Explain about the block diagram of computer?
4. What is software? Explain about the types of software.
5. Classify the memory? Explain about the primary memory used in computer?
6. Explain about the bus architecture with diagram.
7. What are the components of information technology? Explain.
8. What are the modes of data transmission? Explain.
9. Explain about the types of computer network.
10. What is network topology? Explain about the types of network topology.
11. What are the protocols used in internet? Explain.
12. What is operating system? What are the functions of operating system? Explain.
13. What are the types of operating system? Explain about the types of operating system
according to user interface.
14. What is RAM? Explain about the different variations of ROM.
15. What are the differences between Primary and Secondary memory?
16. What are the differences between RAM and ROM?
17.
From the following spreadsheet, write the formula to address the following conditions:
ABC Company
Kathmandu
A B C D E F G H I
1 SN Name Addr Post Salary Bonus Tax HA Total
2 1 Ram Ktm Manager 12000
3 2 Sham Pokhara Accountant 11500
4 3 Hari Pokhara Engineer 10000
Maximum Salary 10000
.
Condition
1. Bonus will give 15% of salary. If his/her salary is less than equal to 6000
2. Tax will pay 10% of salary if his/her post is manager
3. HA will get 5% of salary, if he/she is not from ktm
4. Total is equal to the sum of (salary, bonus and HA) by deducting the Tax
5. Write a formula to find the maximum salary above the excel sheet.
18. Explain different types of computer on the basis of size and power.
19. Prepare following spreadsheet:
ABC Campus
Kathmandu
A B C D E F G H I J K L M
1 SN Name CFA Logic Math So Tech English Total Per Result Grade Rank Remark
2 1 Ram 45 56 54 44 45 ? ? ? ? ? ?
3 2 Sham 50 45 53 45 45 ? ? ? ? ? ?
4 3 Hari 46 44 45 46 45 ? ? ? ? ? ?
Er.Binay Yadav Page 1
1. What are the technologies used in generation of computer? Explain.
2. Classify the computer? Explain about the types of computer according to size.
3. Explain about the block diagram of computer?
4. What is software? Explain about the types of software.
5. Classify the memory? Explain about the primary memory used in computer?
6. Explain about the bus architecture with diagram.
7. What are the components of information technology? Explain.
8. What are the modes of data transmission? Explain.
9. Explain about the types of computer network.
10. What is network topology? Explain about the types of network topology.
11. What are the protocols used in internet? Explain.
12. What is operating system? What are the functions of operating system? Explain.
13. What are the types of operating system? Explain about the types of operating system
according to user interface.
14. What is RAM? Explain about the different variations of ROM.
15. What are the differences between Primary and Secondary memory?
16. What are the differences between RAM and ROM?
17.
From the following spreadsheet, write the formula to address the following conditions:
ABC Company
Kathmandu
A B C D E F G H I
1 SN Name Addr Post Salary Bonus Tax HA Total
2 1 Ram Ktm Manager 12000
3 2 Sham Pokhara Accountant 11500
4 3 Hari Pokhara Engineer 10000
Maximum Salary 10000
.
Condition
1. Bonus will give 15% of salary. If his/her salary is less than equal to 6000
2. Tax will pay 10% of salary if his/her post is manager
3. HA will get 5% of salary, if he/she is not from ktm
4. Total is equal to the sum of (salary, bonus and HA) by deducting the Tax
5. Write a formula to find the maximum salary above the excel sheet.
18. Explain different types of computer on the basis of size and power.
19. Prepare following spreadsheet:
ABC Campus
Kathmandu
A B C D E F G H I J K L M
1 SN Name CFA Logic Math So Tech English Total Per Result Grade Rank Remark
2 1 Ram 45 56 54 44 45 ? ? ? ? ? ?
3 2 Sham 50 45 53 45 45 ? ? ? ? ? ?
4 3 Hari 46 44 45 46 45 ? ? ? ? ? ?
Er.Binay Yadav Page 1
