I'm a teacher who has to keep track of students progress. Students need to complete 3 modules in any order; i have students who complete modules at different semester. Eg: student A completes module 1 in semester 1, module 2 in semester 2 etc. There are also student who passed or fail the modules. My tracking data is organised by semester, which means that a student's name will appear multiple times when they are doing different modules at different semester.
I need to filter out which student has passed module 1 and 2 but not 3. Is there a way? Thanks for your suggestions!
I need to filter out which student has passed module 1 and 2 but not 3. Is there a way? Thanks for your suggestions!