BCA Semester 1 – Computer Fundamentals and Applications – Unit 2: Computer Software

How do you define the term computer software? Explain types of computer software.

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

Conditions:

i. Service tax will be 5% for employees with a yearly salary greater than 1,50,000; otherwise, 1%.
ii. Income tax will be:

• 0% for yearly salary up to 1,00,000
• 10% for yearly salary less than 2,00,000
• 15% otherwise
  iii. Total = Service Tax + Income Tax
  iv. 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.

What kinds of programs fall under the utility category? Describe a utility program you have on your computer.

Write down characteristics and applications of laser printer.

a) What is a softcopy device? Explain the working mechanism and applications of the OMR. b) Write DOS Commands to perform the following tasks: i. To create the TU directory at the current prompt. ii. To display the tree view structure of the files and folders included within the TU directory. iii. To remove the BCA and MCA (non-empty folders) from the current prompt. iv. To locate the IP address of your computer in the network. v. To discover the presence of a remote device on the network.

Utility software helps to maintain proper and smooth functioning of a computer system. Justify it with proper examples.