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.

Questions

100

Marks

Back to All Chapters

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

Given Data:

S.n	Name	Address	Post	Salary
1	Ram	Kim	Manager	12000
2	Sham	Pokhara	Accountant	11500
3	Hari	Pokhara	Engineer	10000
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)

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

HardTHEORY10 marks2019(TU FOHSS Final)

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)

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

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)

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

MediumTHEORY5 marks2021(TU FOHSS Final)

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

MediumTHEORY5 marks2021(TU FOHSS Final)

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)

What is a geographic information system? Describe its elements.

MediumTHEORY5 marks2023(TU FOHSS Final)

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)

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

EasyTHEORY5 marks2024(TU FOHSS Final)

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