Hi, thank you very much in advance for the help.
I have a list containing student exam results. The following categories of data are available:
- Course
- Mapping
- Course Type
- Grade
- Units
- Student ID
I need to determine the final overall grade of each student. This is calculated by summing all the "Grades" that a student has received, divided by the total number of "Units". However, here's the catch: before I calculate each student's final grade, I need to first remove the two lowest grades for each student (e.g. 1, 2, 3, 4, 4, 4, 4 --> remove 1 and 2). An additional rule: the removed grade must not be a course that is mapped to "GE" - only "Non-GE" grades may be removed. Effectively, I need to remove the two lowest Non-GE grades for each student.
May I seek advice on how best I can generate the outcomes I want? (i.e. final overall grade for each student, after removing lowest two Non-GE grades).
In the sample file, I included the actual data (anonymised) for 6 students - the actual document has about 3000 students.
Thank you very much!!
Bookmarks