I have a system that allows stakeholders all over our district view our students’ performance while in that school’s labs. The challenge I am facing is how to remove the students that have withdrawn from a course. It is very easy to remove the completers because their percent completion will be 100.
Is there a way I can figure out what records are NOT updated in my daily updates so I can then delete those records as they are no longer in the source data. I appreciate any and all suggestions! Thanks and have a great day!
Hard to comment conclusively without knowing the structure of your data but a question arises: if you are going to infer course withdrawal based on no daily update, how will a short absence due to illness be handled? Won’t that look like a course withdrawal?
Maybe have an automated “last updated” date field for each student record, and once that is NN days in the past, change status to “absent” using a nightly task, then exclude all absent students from reports.
Agree with @LeighBerre96926 here - perhaps consider a status field that sets a flag automatically for ‘Missing Update’ for records that can then be reviewed?
I actually came up with a plan. Each import I add a today’s date column. Because of how our enrollments work, when a student is no longer on the report, it IS because they have either completed the course or dropped it. I thin set up filters for the views so that any record that does not haver today’s date is hidden. Thank you for your ideas!
