BCA First Semester Old Question Paper All Subjects TU – GenZNotes

Subject: Computer Fundamentals and Applications

BCA First Semester Old Question Paper With Complete Answer and Solutions . All Subjects Computer Fundamentals and Applications, TU 2018, 2019, 2020, 2021, 2022 – BCA Old Question TU – GenZNotes

TU BCA Old Question with Solution
Computer Fundamentals and Applications – Year 2018

Group B

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

2. Define Computer. Explain the anatomy of digital computer with block diagram.

3. Define Operating System. Explain the functions of Operating System.

4. Define DBMS. Explain the different database models with their merits and demerits.

5. Explain the different types of LAN topologies with their advantages and disadvantages.

6. What is WWW? Differentiate between intranet, extranet and internet with example.

7.What are contemporary technologies? Explain any two contemporary technologies with roles.

8. Write the DOS commands to complete following tasks.

  1. Create sub directory theory and practical inside d:\exam\
  2. Create the file name marks.txt inside theory writing the content, “Theory marks in CFA”.
  3. Rename the file name marks.txt with CFAmarks.txt.
  4. Make hidden the file CFAmarks.txt.
  5. Search the all files with .pdf extension.

Group C

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

9. i) You are provided following data:

Bageswori Secondary School

Surkhet

Mark – Ledger

DEFGHIJKLM
11NameEng.Nep.Eco.Sociology.ComputerTotalPercentageResultDivision
12Gautam5656767568
13Saru6754646476
14Binod8765545966
15Ritu4567567285
16Rabindra8934635952

Write the formula in spread sheet package to calculate following on basis on given conditions:

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

10. i) Define computer peripherals. Differentiate between impact and non-impact printers. [1+4]
ii) Define Presentation. Write the features of good presentation package. [5]

11. Define CMYK color model. Explain the basic tools and transforms available in Photoshop. [10]


TU BCA Old Question with Solution
Computer Fundamentals and Applications – Year 2019

Group B

Attempt any Six question

2. What is Operating system? Explain the major functions of Operating System.

3. Differentiate between primary and secondary memory.

4. What is computer virus? Explain symptoms of computer virus.

5. Define database? Explain the advantages of database over tile based system.

6. What is proxy server? Write down the benefit of using proxy server in the organization.

7. Define e-commerce? Mention the benefits of using it in the context of customer?

8. Consider the following structure and answer the questions.

E:\ ROOT |—dir_1 | | file_1.txt | | file_2.txt | |____dir_3 |—dir_2 file_2.txt

a) Write down DOS command to create above files and directories. [2]

b) Write down DOS command to move all text file into dir_3 directory. [1]

c) Write DOS command to delete dir_1 directory.

d) Hide the root directory from E drive.

Group C

Attempt any Two question

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

ABC Company
Kathmandu

ABCDEFGHI
1SNNameAddrPostSalaryBonusTaxHATotal
21RamKtmManager12000
32ShamPokharaAccountant11500
43HariPokharaEngineer10000
Maximum Salary10000

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.

b) What is Photoshop? Explain five major tools of Photoshop.

10. a) What is word processor? Explain the major function avaliable in the home tab of word document.

b) Define Network Topology? Write down the advantage of Network

11. a) What is animation? What are the advantages of using slide master in Powerpoint?

b) Explain block diagram of computer and its various components.


TU BCA Old Question with Solution
Computer Fundamentals and Applications – Year 2020

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

ABCDEFGHIJKLM
1SNNameCFALogicMathSo TechEnglishTotalPerResultGradeRankRemark
21Ram4556544445??????
32Sham5045534545??????
43Hari4644454645??????

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]

4.8 4 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments