The following steps are for exporting information to be used with Academic Enrollment Scheme 1. Fields on the Output tab may change when using different schemes.
  1. In Registrar’s Office, select Query
  2. Click New
  3. Select Student for the type and Dynamic for the format
  4. Click Ok
  5. On the Criteria tab, select the following:
    • Student > Bio 1 > Current Status – Equals Current Student (or whichever status designates students currently enrolled)
    • Schedule > Academic Year – Equals 2016-2017
    • Schedule > Class > First Meeting – Equals Yes
    • Schedule > Class > Class Start Term – Equals Fall
Academic Enrollment Scheme 1 Criteria tab
  1. Select the Output tab
  2. Under Available Fields, remove any fields present then select the following:
    • Student > Bio 1 > First name
    • Student > Bio 1 > Last name
    • Enrollments > Class of
    • Schedule > Academic Year
    • Schedule > Class > Start Term
    • Schedule > School
    • Schedule > Course > Course > Course ID
    • Schedule > Class > Section
    • Schedule > Class term enrolled
      • The Class term enrolled field is included for sorting purposes and can be removed after the data has been exported and modified.
Academic Enrollment Scheme 1 Output tab
  1. Select the Sort tab
  2. Enter the following items to sort by (in this order):
    1. Schedule > Class term enrolled
    2. Schedule > Class > Class start term
    3. Schedule > School
    4. Student > Bio 1 > Current Grade
    5. Student > Bio 1 > Last name
    6. Student > Bio 1 > First name
Academic Enrollment Scheme 1 Sort tab
  1. Click Run
  2. Save the Query
  3. Click Export to Excel
  4. Open the new Export
  5. Locate and remove all Spring term courses with a Fall Start Term
  6. Save the modified export file as a .csv