I typically use the posted_at field in the submissions table to determine if a grade has been posted. If the field is null, it means the grade hasn't been posted yet. If there's a timestamp va...

The Web_logs table contains all data, but you can only retrieve up to 30 days of data in a single run. To access historical data, you must use the "since" and "until" parameters, ensur...

  I’ve created a query that retrieves course ID, user ID, and the number of sessions (logins) for students within a specific time range. This helps track student engagement at the course, term, or sub...

The last_activity_at field in the enrollments table is only useful if the query is run on the 14th day after the class starts. If the query is run a month later, this field becomes less helpful becaus...

Problem statement: Idea Summary Allow staff members to upload bulk feedback for student submissions (online and offline) using a user-friendly Graphical User Interface (GUI) in Canvas. This functiona...

The Web_logs table contains all data, but you can only retrieve up to 30 days of data in a single run. To access historical data, you must use the "since" and "until" parameters, ensur...

  I’ve created a query that retrieves course ID, user ID, and the number of sessions (logins) for students within a specific time range. This helps track student engagement at the course, term, or sub...

The last_activity_at field in the enrollments table is only useful if the query is run on the 14th day after the class starts. If the query is run a month later, this field becomes less helpful becaus...

I typically use the posted_at field in the submissions table to determine if a grade has been posted. If the field is null, it means the grade hasn't been posted yet. If there's a timestamp va...

Problem statement: Idea Summary Allow staff members to upload bulk feedback for student submissions (online and offline) using a user-friendly Graphical User Interface (GUI) in Canvas. This functiona...