Computer Fundamentals and Applications 2020 - BCA (TU) Old Questions

Group B

2. Who is database administrator? Explain the major roles and responsibilities of DBA. [1 + 4]

3. Define operating system? Explain the open-source operating system.[1 + 4]

4. What is ergonomic keyboard? Explain working mechanism of keyboard.[1+4]

5. Explain different types of computer on the basis of size and power.[5]

6. What is DBMS? Explain Relational database model with suitable diagram.[5]

7. Prepare a specification of personal computer which you want to purchase.[1+4]

8. Explain any five DOS command with suitable example.[5]

Group B

9. 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 ? ? ? ? ? ?

Conditions:

  1. Write appropriate formula to find the total marks of each students.[1]
  2. Write formula to find out the percentage of each student.[1]
  3. Result is passed if student score at least 40% marks in each subject.[2]
  4. Write a formula to calculate grade of student based on percentage. (A for >=90, B for >=80, C for >=70, D for>=60, E for>=40)[3]
  5. Write a formula to find rank of individual student who has passed result.[1]
  6. Write a remarks base on following conditions:[2] ("Excellent" for A grade,"Good" for B, "Fair" for C, "Moderate" for D and "Satisfactory" for E)

10. a) What is mail merge? Explain the major functions available in the Review tab of word document.[1 + 4]

10. b)What is Photoshop? Write the steps to create MRP sized photograph in JPEG format.[1+4]

11. Define Computer Network? Explain OSI model in detail.[2 + 8]