IT Help Desk > Use of PC

Microsoft Excel: Learning Tutorial

<< < (4/12) > >>

ashiqbest012:



Click here for soft copy

ashiqbest012:
First of all type the quiz 1, quiz 2 and quiz 3 field. This sheet will automatically updated. After that type the attendance , Assignment , Presentation etc number. You will get your desire number.

Finally, Total grade point indicates the total grade point (TGP) and Total grade indicates the Total Grade. 

ashiqbest012:

ashiqbest012:
G.P.A   =IF(D10>=80,"4",IF(AND(D10<80,D10>=75),"3.75",IF(AND(D10<75,D10>=70),"3.50",IF(AND(D10<70,D10>=65),"3.25",IF(AND(D10<65,D10>=60),"3.00",IF(AND(D10<60,D10>=55),"2.75",IF(AND(D10<55,D10>=50),"2.50","0.00")))))))

Grade
=IF(D10>=80,"A+",IF(AND(D10<80,D10>=75),"A",IF(AND(D10<75,D10>=70),"A-",IF(AND(D10<70,D10>=65),"B+",IF(AND(D10<65,D10>=60),"B",IF(AND(D10<60,D10>=55),"B-",IF(AND(D10<55,D10>=50),"C+","F")))))))

Total Point
=SUM(E10+E11+E12+E13+E14+E15+E16+E17+E18+E19+E20+E21+E22+E23+E24+E25+E26+E27+E28+E29+E30+E31+E32+E33+E34+E35+E40+E41+E42+E43+E44+E45+E46+E47+E48+E54+E55+E56+E57+E58)/COUNT(D10:D58)

Grade
=IF(D10>=80,"A+",IF(AND(D10<80,D10>=75),"A",IF(AND(D10<75,D10>=70),"A-",IF(AND(D10<70,D10>=65),"B+",IF(AND(D10<65,D10>=60),"B",IF(AND(D10<60,D10>=55),"B-",IF(AND(D10<55,D10>=50),"C+","F")))))))

Aarif:
thanks for ur valuable posting. i am looking forward more and more.
i will be very grateful to u if u  pls provide the details about power point.

Navigation

[0] Message Index

[#] Next page

[*] Previous page