OGIyMjhjYzBlZTAwYjQ1ZDRmM2EyM2ViNjViZDNlNDc2ZTM0YmIxNDQ1M2QwMjI3OTY5MTg4MzhjNDU0ZjAxNg.mu8ak25u.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