This is an old revision of the document!
Queries to Check CTE Accuracy
These queries ALL assume that all the CTE courses are accurately marked with career families in the course atom.
Blank CTE Family Queries
For these two queries, check both the "show inactive records" box and the "show empty records" box. The first query shows what courses are in the students current schedule. The second shows what is in their class history for this year.
DISPLAY ASTU ACLS AMST ACRS AVOC Status Permnum LN FN Course Title IF StateCrs2 <> " " AND CipNo = " " AND Status <> "N"
DISPLAY ASTU ACLH ACRS AVOC Status Permnum LN FN Course Title IF StateCrs2 <> " " AND CipNo = " " AND Status <> "N"
CTE Fam List Queries
These two list the CTE Fam that is currently marked in the vocational atom. It also shows the "Career/Tech", "Technical", "Non-Traditional" and "Single Parents" markings in the vocational atom. You will need to mark "Show inactive records" on these two as well. The first query shows what courses are in the students current schedule. The second shows what is in their class history for this year.
DISPLAY ASTU ACLS AMST ACRS AVOC Status PermNum LN FN Grade Gender Course Title StateCrs2 CarTech Technical CipNo NonTrad SnglParent IF STatus <> "N" AND CipNo <> " " AND StateCrs2 <> " "
DISPLAY ASTU ACLH ACRS AVOC Status PermNum LN FN Grade Gender Course Title StateCrs2 CarTech Technical CipNo NonTrad SnglParent IF Status <> "N" AND CipNo <> " " AND StateCrs2 <> " "
Tips:
- It is helpful to run both queries in each group and extract these to the same Excel spreadsheet. Sometimes someone may be currently taking a class, but also had taken a different class previously this year.
- Anything that is listed in a student's class history should be examined further. It might be a class they never really attended, but dropped the first day of school. As with nearly everything regarding CTE information, these should be looked at on a case by case basis.
Page Tools
