TU BCA 1st Semester Computer Fundamentals Old Question Papers (2019–2025)
TU BCA 1st Semester – Computer Fundamentals and Applications
Old Question Papers (Year-wise)
Course: Computer Fundamentals and Applications | Code: CACS 101 | Full Marks: 60 | Pass Marks: 24 | Time: 3 hrs
2025
Group B — Attempt any SIX 2. Explain the fundamental components of a computer system and their functions. 3. Define computer memory. Explain memory hierarchy. 4. What is computer software? Differentiate between a program and software. 5. What is an Operating System (OS)? Explain different types of OS and give examples. 6. What is a Database? Explain its main functions and types with examples. 7. What is browsing? What is meant by the home page of a website? Explain any three Internet protocols. 8. Write short notes on (any two): a) Multimedia vs Hypermedia b) GUI vs CUI c) Text Formatting vs Paragraph Formatting
Group C — Attempt any TWO 9. Why do computer networks play a vital role in the 21st century? Explain the role of different transmission media in network design. Describe the functionalities of various network devices. 10. a) Prepare a table (Places / Target / Production / Achievement / Grade) and calculate achievement % and grade using functions. b) Explain DOS commands: protecting files, difference between RD and DEL, copying a file between directories, use of TREE and LABEL, displaying file contents without opening it. 11. a) Difference between Adobe ImageReady and Photoshop; selection tools in Photoshop. b) What is PowerPoint and its purpose? Differentiate Slide Sorter view and Slide Show view.
2024
Group B — Attempt any SIX 2. Utility software helps maintain proper and smooth functioning of a computer system. Justify with examples. 3. What is primary memory? Differentiate between static and dynamic RAM. 4. Define CLI and GUI based operating systems. Explain types of operating systems. 5. What is Internet Protocol? Explain two different protocols. 6. Why do we need to use DBMS? How does the relational model represent data and relationships? Explain. 7. What is DNS? Differentiate between intranet and extranet.
Group C — Attempt any TWO 9. a) List and explain the major controls in the Layout tab of a word processor. b) Write DOS commands for: creating two folders; creating files in each folder; copying content between files; renaming a file; locating your network's IP address. 10. a) What is a computer virus? List symptoms and prevention techniques. b) What is the use of a mask in Photoshop? Explain its editing controls. 11. Why do we need protocols for data transmission? Is it secure to transfer data over a network? Explain the OSI model in detail.
2021
Group B — Attempt any SIX [6×5=30] 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 a suitable example. 5. What is a data warehouse? Explain advantages and disadvantages of a data warehouse. 6. Define computer network. Why do organizations need a 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 — Attempt any TWO [2×10=20] 9. a) Consider the following Excel Sheet and write down the correct formula based on conditions:
XYZ Company Kathmandu — Tax
| SN | Name | Salary | Service Tax | Income Tax | Total | Net Salary |
|---|---|---|---|---|---|---|
| 1 | Bishnu KC | 10,000 | ? | ? | ? | ? |
| 2 | Ram Gurung | 20,000 | ? | ? | ? | ? |
| 3 | Nikita Nepal | 35,000 | ? | ? | ? | ? |
| 4 | Gita Karki | 40,000 | ? | ? | ? | ? |
Conditions:
- Service tax will be 5% for employees with a yearly salary greater than 1,50,000; otherwise, 1%.
- Income tax will be: 0% for yearly salary up to 1,00,000; 10% for yearly salary less than 2,00,000; 15% otherwise.
- Total = Service Tax + Income Tax
- Net Salary = Salary − Total Tax
b) Explain the following DOS commands with suitable examples: ATTRIB, XCOPY, MKDIR, MOVE, DEL
-
a) Explain the major functions available in the Layout tab of a Word document. b) What is the use of a layer in Photoshop? How do you organize layers in Adobe Photoshop?
-
What are hardcopy devices? Explain the working mechanism of dot-matrix, laser, and ink-jet printers.
2020
Group B — Attempt any SIX 2. Who is a database administrator? Explain the major roles and responsibilities of DBA. 3. Define operating system. Explain the open-source operating system. 4. What is an ergonomic keyboard? Explain the working mechanism of a keyboard. 5. Explain different types of computers on the basis of size and power. 6. What is DBMS? Explain the Relational database model with a suitable diagram. 7. Prepare a specification of a personal computer which you want to purchase. 8. Explain any five DOS commands with suitable examples.
Group C — Attempt any TWO questions [2×10=20] 9. Prepare the following spreadsheet:
Student Marks Record
| SN | Name | CFA | Logic | Math | So Tech | English | Total | Per | Result | Grade | Rank | Remarks |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Ram | 45 | 56 | 54 | 44 | 45 | ? | ? | ? | ? | ? | ? |
| 2 | Sham | 50 | 45 | 53 | 45 | 45 | ? | ? | ? | ? | ? | ? |
| 3 | Hari | 46 | 44 | 45 | 46 | 45 | ? | ? | ? | ? | ? | ? |
Conditions:
- a) Write an appropriate formula to find the total marks of each student.
- b) Write a formula to find out the percentage of each student.
- c) Result is "Passed" if the student scores at least 40% marks in each subject.
- d) Write a formula to calculate the grade based on percentage: A for ≥90%, B for ≥80%, C for ≥70%, D for ≥60%, E for ≥40%
- e) Write a formula to find the rank of individual students who have passed.
- f) Write remarks based on grade: "Excellent" for A, "Good" for B, "Fair" for C, "Moderate" for D, "Satisfactory" for E
-
a) What is mail merge? Explain the major functions available in the Review tab of a Word document. b) What is Photoshop? Write the steps to create an MRP-sized photograph in JPEG format.
-
Define Computer Network. Explain the OSI model in detail.
2019
Group B — Attempt any SIX 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 file 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 directory structure and answer the questions: