Computer Fundamental and Application-Questions(2020,2019,2018)

Tribhuvan University
Faculty of Humanities & Social Sciences

OFFICE OF THE DEAN 2021

Bachelor in Computer Applications                                                         

Course Title: Computer Fundamental and Applications                      

Code No: CACS 101                                                                                     

Semester: 1 ^st

Candidates are required to answer the questions in their own words as far as possible.

Group "B"

Attempt any SIX questions.

2. Explain the diligence and versatility features of computer.
3. How do you define the term computer software. Explain types of computer software.
4. "Operating system works as user interface". Justify this statement with suitable example.
5. What is data warehouse ? Explain advantages and disadvantages of data warehouse.
6. Define computer network. Why organizations need computer network ?
7. What is computer protocol? Explain two different e-mail protocols.
8. What is hypermedia? Write down the applications of augmented reality.

Group "C"

9.(a) Consider following Excel Sheet and write down the correct formula based on conditions.

Conditions:

1. Service tax will be 5% for employees who has got Salary more than 1,50,000, otherwise 1%. [2]
2. Income tax will be :0% for employee who has got yearly salary upto 1,00,000,10% for employee who has got yearly salary less than 2,00,000 otherwise 15%. [2]
3. Total is calculated as sum of service and income tax and net salary is calculated as difference of salary and income tax. [1]

b) Explain following DOS Command with suitable example: [5]

ATTRIB, XCOPY, MKDIR, MOVE, DEL

10.(a) Explain the major functions available in the Layout tab of word document. [5]

(b) What is the use of layer in photoshop? How you organizing layers in Adobe Photoshop. [1+4]

11. What is hardcopy devices? Explain the working mechanism of dot-matrix, laser and ink-jet printer.

Tribhuvan University
Faculty of Humanities & Social Sciences

OFFICE OF THE DEAN 2020

Bachelor in Computer Applications                                                         

Course Title: Computer Fundamental and Applications                      

Code No: CACS 101                                                                                     

Semester: 1 ^st

Candidates are required to answer the questions in their own words as far as possible.

Group B

Attempt any SIX questions. [6*5 = 30]

2. What 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 computers on the basis of size and power. [5]
6. What is DBMS? Explain Relational database model with suitable diagram. [1+4]
7. Prepare a specification of personal computer which you want to purchase. [5]
8. Explain any five DOS command with suitable example.[5]
   
   

Group C

Attempt any TWO questions. [2*10 = 20]

9. (a) From the following spreadsheet:

Conditions:

1. Write appropriate formula to find the total marks of each student. [1]
2. Write appropriate formula to find the percentage of each student. [1]
3. Result is passed if student score at least 40% marks in each subject. [2]
4. Write the formula to find grade of students 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 the following conditions. [2]

(“Excellence” for A grade, “Good” for B grade, “Fair” for C grade, “Moderate” for D grade, “Satisfactory” for E grade)

10. (a) What is mail merge? Explain the major function available in the review tab of word documents. [1+4]

(b) What is photoshop? Write the steps to create MRP sized photograph in JEPG format. [1+4]

11. Define computer network? Explain OSI model in detail. [2+8]

Tribhuvan University
Faculty of Humanities & Social Sciences

OFFICE OF THE DEAN 2019

Bachelor in Computer Applications                                                         

Course Title: Computer Fundamental and Applications                      

Code No: CACS 101                                                                                     

Semester: 1 ^st

Candidates are required to answer the questions in their own words as far as possible.

Group B

Attempt any SIX questions. [6*5 = 30]

2. What is Operating system? Explain the major functions of Operating System. [1+4]
3. Differentiate between primary and secondary memory. [5]
4. What is computer virus? Explain symptoms of computer virus. [1+4]
5. Define database? Explain the advantages of database over file-based system. [1+4]
6. What is proxy server? Write down the benefit of using proxy server in the organization. [1+4]
7. Define e-commerce? Mention the benefits of using it in the context of customer? [1+4]
8. Consider the following structure and answer the questions. (E:/> is current prompt)
   
   
   
   1. Write down DOS command to create above files and directories. [2]
   2. Write down DOS command to move all text file into dir_3 directory. [1]
   3. Write DOS command to delete dir_1 directory. [1]
   4. Hide the root directory from E drive. [1]

Group C

Attempt any TWO questions. [2*10 = 20]

9. (a) From the following spreadsheet, write the formula to address the following conditions:

Conditions:

1. Bonus will give 15% of salary If his/ her salary is less than and equal to 6000. [1]
2. Tax will pay 10% of salary if his/ her post is manager [1]
3. HA will get 5% of salary, if he/she is not from Ktm. [1]
4. Total is equal to the sum of (Salary, Bonus and HA) by deducting the Tax [1]
5. Write a formula to find the maximum salary above the excel sheet. [1]

(b) What is Photoshop? Explain five major tools of Photoshop. [1+4]

10. (a) What is word processor? Explain the major functions available in the home tab of word document. [5]

(b) Define Network Topology? Write down the advantages of Network. [1+4]

11. (a) What is animation? What are the advantages of using slide master in PowerPoint? [1+4]

(b) Explain block diagram of computer and its various components. [5]

Tribhuvan University
Faculty of Humanities & Social Sciences

OFFICE OF THE DEAN 2018

Bachelor in Computer Applications                                                         

Course Title: Computer Fundamental and Applications                      

Code No: CACS 101                                                                                     

Semester: 1 ^st

Candidates are required to answer the questions in their own words as far as possible.

Group B

Attempt any SIX questions. [6*5 = 30]

2. What do you mean by Computer Architecture? Describe the functional components of computer architecture with block diagram. [1+4]
3. Define Operating System. Explain the types of operating system with their examples. [5]
4. Define DBMS. Explain the different database models with their merits and demerits. [1+4]
5. Define computer network. Explain the different types of LAN topologies with their advantages and disadvantages. [1+4]
6. What is WWW? Differentiate between intranet, extranet and internet. [5]
7. What is e-commerce? Explain its role to enhance the country’s economy. [1+4]
8. Write the DOS commands to complete following tasks:
   1. Create sub directory BCA, BIM, BSC inside d:\TU
   2. Create the file name bcainfo.txt inside BCA having the content, “BCA is professional degree”.
   3. Rename the file name bcainfo.txt with myinfo.txt
   4. Make hidden the file myinfo.txt
   5. Format the pen drive which is installed as g:\ in your computer

Group C

Attempt any TWO questions. [2*10 = 20]

9. (i) You are provided following data:

Churiya Mai Secondary School

Hetauda

Mark-ledger

Write the formula in spread sheet package to solve the following problems:

1. Calculate Total marks. [1]
2. Calculate Percentage marks. [1]
3. Mark the student with either “pass” or “fail” (Pass mark 35) [1.5]
4. Calculate the division (if percentage>=60 the First, if percentage >=45 and percentage <60 then Second, if percentage >=35 and percentage <45 then Third otherwise “xxx”) [1.5]

(ii) Explain the features of font control dialog box in word. [5]

10. (i) What is memory hierarchy? Explain the types of memory. [5]

(ii) What do you mean by presentation package? Write the basic elements of Power Point Window. [5]

11. Define RGB color model. Explain the basic tools and transforms available in Adobe Photoshop. [2+5+3]

For objective questions: https://khullanote.com/bca-fundamental-objective 

For notes and solutions: https://khullanote.com