Real time Applications of Excel

Real time applications of excel contains student assessment evaluation, student grading system, payroll calculation and income tax formulations. If you do not read the sixth post , I recommend you to read I recommend you to read the following posts related to Microsoft excel.

You can get the Microsoft excel application from Get into PC.

Real time Applications of Excel (Students Assessment Mark)

The excel file will have the following columns.

Student ID
Student full name
Student gender
Mark of all courses for each student out of 100 %
Total mark of each student out of multiple of 100 in number of courses

Average mark of each student out of 100 %

Real time Applications of Excel (Grading system)

The excel file will have the following columns

Student ID
Student full name
Student gender
Section
Mark of a course for each student out of 5%,10% 15%,20% and 50%
Mark of a course for each student out of 100 %

Grades of each student for a single course.

Payroll management system

The excel sheet may incorporate the following record fields (columns).

Employee name
Employee id
designation
Basic salary (BS)
Gross salary (GS)
Allowances. E.g., Home allowance (HA), position alliance (PA)
Taxable income (TI)
Income tax (IT)
Pension tax (PT)
Deduction e.g., life insurance, repay tax, donation contribution and other.
Over time (OT)

Basic formula of payroll

Use the following formula to get gross salary

= BS + PA + HA +OT

Use the following for formula to calculate taxable income.

= BS+ IF (HA>=800, HA-800,0) + IF (PA>=800, PA-800,0) + OT

Use the following table and formula to calculate the income tax.

= GS * tax rate – deduction

= IF (BS<=600,0, IF (BS<=1650, BS*10%-60, IF (BS<=3200, BS*15%-142.5, IF (BS<=5250, BS*20%-302.5, IF (BS<=7800, BS*25%-565, IF (BS<=10900, BS*30%-955, IF (BS>10900, BS*35%-1500)))))))