I've noticed a discrepancy between the datasets User Enrollments and Enrollments and...
I've noticed a discrepancy between the datasets User Enrollments and Enrollments and Withdrawals. If a user is not active and an enrollment or unenrollment occurs via the user tool the action shows up in the Enrollments and Withdrawals dataset but not in the User Enrollments dataset.
For example, if you unenroll an inactive user from a course while in the user tool the user tool shows the user as Not Enrolled on the Enrollments tab and the action is logged in the Enrollment Log tab. When the datasets are updated the Enrollments and Withdrawals dataset shows the unenrollment occurred. However, the User Enrollments dataset still shows the user is enrolled.
I had a case where an enrollment occurred but did not show up in the User Enrollments dataset. I do not know what steps were involved for that enrollment.
Is anyone aware of other situations where enrollment changes are not recognized in the User Enrollments dataset?
Comments
-
Thank you for the feedback. When using the dataset do you use all the add/drop info or do you mostly look at the most recent entry for a user to determine the current status?
-
This is what we do also, use Enrollments and Withdrawals, the most recent entry.
-
@Renee Judd How do you filter rows by the latest date in Magic ETL? I'm trying to get the latest Enroll or Unenroll status for each student in a class.
-
Jennifer, although we have performance +, we work in our own data lake we host on an orach ascle server, rather than in the Insights portal. This allows us to bring in other data sources, such as Banner (our SIS), and make our queries in Oracle SQL/PL. Some analysts use R. (Our visualizing and sharing tool is PowerBI.) We were doing this before the current DOMO system was made available in Brightspace, and so far are not tempted to switch. That said, some concepts are universal, though implementations are local. Date/time comparisons can be tricky, so I do a quick cheat with the EnrollmentsWithdrawlas dataset by using the log_id to get the most recent enrollment status regarding a user and a course. I don't know whether this would work in Magic ETL, but I suspect it might. (If a actually need to do logic with actual dates, I beg a snippet from a true analyst, which I am not.)
-
@Renee Judd Thanks Renee! I figured out how to use Rank & Window in ETL and rank the Enrollment date and display the Action so we can tell if a student is currently enrolled or unenrolled.
