YzQ0ZmZkY2VhMWY3ZDhkMjIyN2IwY2M4NjY2ZjBmZGU5OTc5MDE4NmVjYWM1ODg0M2M2Yjc2ZjBiYzU0ZmE4NQ.msff69ns.eyJ1cmwiOiIvcGwvYWRtaW5pc3RyYXRvci9xdWVyeS9jb3Vyc2VfaW5zdGFuY2VzX3VzYWdlIiwiYXV0aG5fdXNlcl9pZCI6IjEifQ
Skip to main content
Accessibility guide
PrairieLearn
Go home
Home
→
Global Admin
Load from disk
Dev User
Turn off administrator access
Course Requests
Settings
Log out
Administrators
Institutions
Courses
Requests
Queries
Workspaces
Features
Batched migrations
Settings
Query:
course_instances_usage
—
Course instances usage data.
institution_short_name
The short name of the institution (blank means all institutions).
total_start
Start of the total time period (should be at least 6 months before the term start).
term_start
Start of the term.
active_start
Start of the active date range (the drop deadline in the term).
term_end
End of the term.
total_end
End of the total time period (should be at least 6 months past the term end, even if that's in the future).
minimum_term_ratio
Minimum ratio of in-term to total submissions for a course instance to count as active.
minimum_student_count
Minimum number of students for a course instance to count as active.
Run query
Recent query runs
No recent runs found