Algorithm for finding Result & Class in MS-Excel

1. Start
2. Click on Start Button à All Programs à MS Office à MS-Excel
3. Enter the heading for the program at A1 to I2 cells
4. Enter the given data from A4 to E13 cells, which is S.No., Name of the Student, Mathematics, Physics/Statistics and Computer Science with corresponding data
5. Enter F4 to I4 cells : Total, Average, Result and Class headings
6. Calculate Total for F5 cell as =Sum(C5 : E5), Average for G5 cell as =Average(C5 : E5), Result for H5 cell as =(IF(OR(C5<53,D5<35,E5<35),"Fail","Pass")) and the Class for I5 cell as

=IF(H5="Pass",IF(G5>=75,"Distinction",IF(AND(G5>=60,G5<75),"First",IF(AND(G5>=50,G5<60),"Second","Third"))),"Fail")

7. Copy F5, G5, H5 and I5 cells formulae to F^th, G^th, H^th, I^th columns for remaining rows i.e., F6 to F13, G6 to G13, … after placing the mouse pointer at left, bottom of the cell and the mouse pointer changes to small + sign, and drag to those cells, then the other rows are filled with appropriate results
8. Finally find out the Average marks of each subject by entering at some empty cells and by using the formula average(C5 : C13) for the subject at column C, like wise for other subjects also
9. Save the worksheet with proper name and Close the Excel worksheet
10. Stop