Disjointed Datasets
Lee.M.415
Posts: 12 Analytics Builder Transition
I'm trying to create a user access report that shows the date and time spent in courses. It would basically look something like this:
StudentID | StudentName | CourseName | Date Accessed | StartTime | EndTime | Total Time
Getting this is a bit difficult because I cannot find a dataset that contain this info nor ones that can be connected to combine this info.
I have three questions regarding data on user access to courses.
- Why aren't the CourseAccess and CourseAccessLog datasets connected with an id field?
- Why are these two not connected to UserLogins and SessionHistory with the sessionid? A student could visit multiple courses in one session.
- Why aren't ContentUserCompletion and ContentUserProgress connected to UserLogin and SessionHistory via SessionID? I could really ask this about all logs (quizattemptlog, assignmentsubmissiondetails, etc.).