HamiIT
Sign inGet started
Home
ADD CONTENT

Sign in Required

Please sign in to add content

Sign In
ProgramsBCASemester 1Computer Fundamentals and ApplicationsUnit 7: Contemporary Technologies
Chapter Study

BCA Semester 1 – Computer Fundamentals and Applications – Unit 7: Contemporary Technologies

Comprehensive questions and detailed answers for Unit 7: Contemporary Technologies. Perfect for exam preparation and concept clarity.

12
Questions
100
Marks
Back to All Chapters
1

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

Given Data:

S.nNameAddressPostSalaryBonusTaxHATotal
1RamKimManager12000
2ShamPokharaAccountant11500
3HariPokharaEngineer10000
Maximum Salary?

Conditions:

  • Bonus = 15% of Salary
  • Tax = 10% of Salary if Post is "Manager"
  • HA = 5% of Salary if Address is not "Kim"
  • Total = (Salary + Bonus + HA) - Tax b) What is Photoshop? Explain five major tools of Photoshop.
HardTHEORY10 marks2019(TU FOHSS Final)
2

What is a word processor? Explain the major functions available in the Home tab of a Word document.

HardTHEORY10 marks2019(TU FOHSS Final)
3

a) What is animation? What are the advantages of using Slide Master in PowerPoint? b) Explain the block diagram of a computer and its various components.

HardTHEORY10 marks2019(TU FOHSS Final)
4

Prepare the following spreadsheet:

Student Marks Record

ABCDEFGHIJHGH
SNNameCFALogicMathSo TechEnglishTotalPerResultGradeRankRemarks
1Ram4556544445??????
2Sham5045534545??????
3Hari4644454645??????

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 of the student 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 the following conditions:
  • "Excellent" for Grade A
  • "Good" for Grade B
  • "Fair" for Grade C
  • "Moderate" for Grade D
  • "Satisfactory" for Grade E
HardTHEORY10 marks2020(TU FOHSS Final)
5

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.

--

HardTHEORY10 marks2020(TU FOHSS Final)
6

What is a data warehouse? Explain advantages and disadvantages of a data warehouse.

MediumTHEORY5 marks2021(TU FOHSS Final)
7

What is hypermedia? Write down the applications of augmented reality.

MediumTHEORY5 marks2021(TU FOHSS Final)
8

a) What is ambient reality? How does it differ from augmented reality? b) Why is the Healing Brush Tool useful? Describe how to use Photoshop to create your ID-Card.

MediumTHEORY10 marks2022(TU FOHSS Final)
9

What is a geographic information system? Describe its elements.

MediumTHEORY5 marks2023(TU FOHSS Final)
10

a) Explain memory hierarchy. b) What is layer in Photoshop? What are the main features and tools available in Photoshop?

HardTHEORY10 marks2023(TU FOHSS Final)
11

What is e-commerce? Explain the benefits of e-commerce.

EasyTHEORY5 marks2024(TU FOHSS Final)
12

a) What is computer virus? List the symptoms of a computer virus in a computer system. Also explain the prevention techniques. b) What is the use of mask in Photoshop? Explain different controls available in Photoshop for editing an image.

MediumTHEORY10 marks2024(TU FOHSS Final)
Showing 12 questions

Exam Years

Past question papers

2024
TU FOHSS Final•2 questions
2023
TU FOHSS Final•2 questions
2022
TU FOHSS Final•1 questions
2021
TU FOHSS Final•2 questions
2020
TU FOHSS Final•2 questions
2019
TU FOHSS Final•3 questions

Questions in Unit 7: Contemporary Technologies

a) From the following spreadsheet, write the formula to address the following conditions: Given Data: | S.n | Name | Address | Post | Salary | Bonus | Tax | HA | Total | |-----|------|---------|------

Marks: 10

Year: 2019 Final TU FOHSS

Answer a: For Row 2 (Ram): - Bonus (F2): =E215% or =E20.15 - Tax (G2): =IF(D2="Manager",E210%,0) or =IF(D2="Manager",E20.1,0) - HA (H2): =IF(C2<>"Kim",E25%,0) or =IF(C2<>"Kim",E20.05,0) - Total (I2):

What is a word processor? Explain the major functions available in the Home tab of a Word document.

Marks: 10

Year: 2019 Final TU FOHSS

Word Processor: A word processor is application software used for creating, editing, formatting, storing, and printing text documents. Examples include Microsoft Word, Google Docs, and LibreOffice Wri

a) What is animation? What are the advantages of using Slide Master in PowerPoint? b) Explain the block diagram of a computer and its various components.

Marks: 10

Year: 2019 Final TU FOHSS

Answer a: Animation: Animation is the technique of creating the illusion of motion by displaying a series of images or frames in rapid succession. In presentation software, animation refers to visual

Prepare the following spreadsheet: Student Marks Record | A | B | C | D | E | F | G | H | I | J | H | G | H | |---|---|---|---|---|---|---|---|---|---|---|---|---| | SN | Name | CFA | Logic | Math | S

Marks: 10

Year: 2020 Final TU FOHSS

Formulas for Row 2 (Ram): a) Total Marks (Column H, Cell H2): = C2+D2+E2+F2+G2 or = SUM(C2:G2) -- b) Percentage (Column I, Cell I2): = H2/500100 or =(H2/5) (Since total marks = 5 subjects × 100 = 500

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

Marks: 10

Year: 2020 Final TU FOHSS

Answer a: Mail Merge: Mail merge is a feature in word processing applications that allows users to create multiple documents from a single template merged with a data source. It is commonly used for c

What is a data warehouse? Explain advantages and disadvantages of a data warehouse.

Marks: 5

Year: 2021 Final TU FOHSS

1. What is a Data Warehouse? A Data Warehouse is a large collection of data that is collected from different sources, processed, and stored in a central place for reporting, analysis, and decision mak

What is hypermedia? Write down the applications of augmented reality.

Marks: 5

Year: 2021 Final TU FOHSS

1. Hypermedia (Definition) Hypermedia is an advanced form of hypertext in which text, images, audio, video, and animations are connected through links so that users can move from one piece of informat

a) What is ambient reality? How does it differ from augmented reality? b) Why is the Healing Brush Tool useful? Describe how to use Photoshop to create your ID-Card.

Marks: 10

Year: 2022 Final TU FOHSS

Topic: Ambient Reality & Photoshop Tools --- a) Ambient Reality vs Augmented Reality 1. Ambient Reality (AmR): - Refers to a digital environment that is seamlessly integrated into the physical worl

What is a geographic information system? Describe its elements.

Marks: 5

Year: 2023 Final TU FOHSS

1. Definition of GIS A Geographic Information System (GIS) is a computer-based system used to capture, store, manipulate, analyze, and display geographic or spatial data. - It helps in decision-maki

a) Explain memory hierarchy. b) What is layer in Photoshop? What are the main features and tools available in Photoshop?

Marks: 10

Year: 2023 Final TU FOHSS

a) Memory Hierarchy Definition: Memory hierarchy is the arrangement of different types of memory in a computer system based on speed, cost, and capacity. It ensures efficient processing by storing f

What is e-commerce? Explain the benefits of e-commerce.

Marks: 5

Year: 2024 Final TU FOHSS

1. What is E-Commerce? Definition: - E-commerce (Electronic Commerce) is the buying and selling of goods and services over the Internet. - It also includes online transactions, electronic payments

a) What is computer virus? List the symptoms of a computer virus in a computer system. Also explain the prevention techniques. b) What is the use of mask in Photoshop? Explain different controls avail

Marks: 10

Year: 2024 Final TU FOHSS

a) Computer Virus Definition: A computer virus is a malicious program that can replicate itself and spread from one computer to another, often causing damage or unauthorized access to data. Symptoms

About Unit 7: Contemporary Technologies Questions

This page contains comprehensive questions from the Unit 7: Contemporary Technologies chapter of Computer Fundamentals and Applications, part of the BCA Semester 1 curriculum. All questions include detailed model answers from past TU exam papers.

Study Tips

  • Review concepts before attempting questions
  • Practice writing complete answers
  • Compare your answers with model solutions
  • Focus on questions from recent years
  • Use direct links (#question-ID) to bookmark and share specific questions

Related Resources

← Back to Computer Fundamentals and Applications Chapters

Unit 7: Contemporary Technologies chapter questions with answers for Computer Fundamentals and Applications (BCA Semester 1). Prepare for TU exams with our comprehensive question bank and model answers.

H
Hami IT

Empowering IT students with quality education resources and comprehensive exam preparation materials.

Programs

  • Flutter
  • Java
  • DevOps

Company

  • About Us
  • Contact

Contact

  • 📧hamiit.dev@gmail.com
  • 📞+977 9813706443
  • 📍Kathmandu, Nepal

© 2026 Hami IT. All rights reserved.