So I have several tables with test/quiz results from students (names & grades), one table for one test (quiz 1, quiz 2, etc). I also have a table listing student names and their test/quiz submission record (checkboxes and list of tests/quizzes columns).
Question: how can I link test/quiz result tables with submission records so that students that already have grades for certain tests will automatically checked on the submission record?
For example: Student A has grades for quiz 1, 2, 4, and 6. Student B has grades for quiz 2,3, and 5. etc.
I want to be able to quickly see who has done which test/quiz so I can follow up with the ones that haven’t done the test/quiz.
I hope my question is clear enough. Thanks.