Query basics training The Registrar’s Office has created several queries to aid Academic Departments in their course planning that are outlined below: Query: CU_ACAD_UNUSED_SEATS_25 This query will return sections of a class that had 25% or more vacant seats in a classroom. It will include the number and percentage of empty seats in the classroom. This can aid your department in determining if you should request a smaller room for a course, or if the course did not have high demand in the past. The term that should be entered is the past fall or spring term, the query also prompts for your academic org number. Query: CU_ACAD_CLOSE_TO_CAPACITY This query will return sections of a class that were close to capacity to aid departments in determining if they should request a larger room for the upcoming term or consider opening a second section of a course. The term that should be entered is the past fall or spring term, the query also prompts for your academic org number. Query: CU_ACAD_ENROLL_ROOM_CAP This query will return all sections of classes within an academic org and show the number and percentage of unused seats. It includes a column for combined enrollment sections. This query should aid departments in making course offering decisions based on past enrollment. The term that should be entered is the past fall or spring term, the query also prompts for your academic org number. Please let me know if you have any questions regarding these queries, or if you have any suggestions for data you might find helpful in addition to these. |