Name    T1  T2  T3  P1  P2  H1  H2  H3  H4
Ann     89  78  100 88  92  100 95  78  88
Bill    68  87  72  60  80  65  100 50  42
Carol   98  87  100 78  99  80  100 88  95
Doug    78  68  92  88  76  95  99  88  72

Carol’s T1 grade is 98.

Carol’s average grade is 85.

Carol   98
Gloria  98