This is a collection of queries related to Grade Reporting that have been obtained from various sources. These queries are being provided here for the convenience of our customers. The results of each query should be verified for accuracy and carefully considered before using.


List Queries

CRS:  List of Courses Designated as Meets Algebra 1 Requirement

Provides a list of courses that have been identified as Meets Algebra 1 Requirement and Credit Values


LIST CRS CN CO ALC ALR CCG BY CCG IF ALC > 0 OR ALR = 1 OR CCG > " "


SBG: List of Student Grades from Standards Based Grades for the First Marking Period

Provides student Grade information from Standards Based Grades for the first marking period


LIST STU SBG STN SBG.SC STU.ID STU.NM SBG.SD STN.TI SBG.GR SBG.MT SBG.M1 IF SBG.MT # A


SBG:  List of Students Marks from any Marking Period

The following query will display Student Grade Information from Standards Based Grades from any marking period


LIST STU SBG STN SBG.SC STU.ID STU.NM SBG.SD STN.TI SBG.GR SBG.MT SBG.M1 SBG.M2 SBG.M3 IF SBG.MT # ' ' AND SBG.MT # A


GRD:  List of all Grades by a Specific Teachers

List of students with all grades given by specific teachers sorted by Teacher and Course


LIST STU GRD CRS TCH STU.ID STU.NM GRD.CN CRS.CO GRD.M1 GRD.M2 GRD.M3 GRD.M4 TCH.TE BY TCH.TE GRD.CN IF GRD.TN = ### OR GRD.TN = ### OR GRD.TN = ###

(Use the correct marking periods from the grade table.)


GRD:  List of D, F, or I Grades for Specific Courses and Marking Period

List of students with a D, F, or I grades for selected Courses from a specific Marking Period in the Grading Table


LIST STU GRD STU.ID STU.NM STU.GR GRD.PD GRD.CN GRD.TN GRD.M1 BY GRD.CN IF ( GRD.CN = #### OR GRD.CN = #### OR GRD.CN = #### OR GRD.CN = #### ) AND ( GRD.M1 : D OR GRD.M1 : F OR GRD.M1 : I )

(Change the marking period if needed.)


GRD:  List of M2 Grades and Course Number if M2 is Not Blank

List of all students and Course Number with a grade value from M2 


LIST STU GRD STU.ID STU.NM GRD.CN GRD.M2 IF GRD.M2 # " "

(Change the marking period if needed.)


GRD:  List of Missing Grade,Citizenship, Work Habits or Comment 1 for a Specific Grading Period

List of students who have missing marks in either Grade (M2), Citizenship, Work Habits or Comment 1 sorted by Teacher and Student


LIST STU GRD TCH STU.NM STU.GR TCH.TE GRD.PD GRD.M2 GRD.CI GRD.WH GRD.C1 BY TCH.TE IF GRD.M2 = " " OR GRD.CI = " " OR GRD.WH = " " OR GRD.C1 = " " AND STU.TG = " "

(Change the marking period if needed.)


GRD:  List of Students with and 'O' in Citizenship from Grade Table - Excluding Zero Period

List of students who have an 'O'in Citizenship from the grade table excluding Homeroom, which is period Zero


LIST STU GRD CRS STU.LN STU.FN STU.GR GRD.PD CRS.CO GRD.CI IF GRD.PD > 0  AND GRD.CI = O


HIS:  List of Student GPAs Descending for a Specific Grade

List of students in a specific Grade with GPAs sorted by GPA Descending


LIST STU SEC MST CRS STU.NM STU.GR STU.GP MST.PD CRS.CO BY STU.GP ^ IF STU.GR = ##


HIS:  List of Various GPA's

List of student's various GPA's, from Transcript data and the current marking period including:  Class Rank and Credit Standing sorted by Grade and Class Rank


LIST STU ID NM GR TP CR CS GP CP UR CA CC GG GT GK GS BY GR CR


HIS:  List of Students with Credits Attempted, Credits Completed, GPA, Class Rank, etc.

List of students with their Credits Attempted, Credits Completed, Total Non-Weighted GPA (cumulative from HIS), Class Rank, 10-12 Academic Non-Weighted GPA (from HIS), UC Rank, and Class Size, sorted by Grade and Class Rank


LIST STU ID NM SX GR CA CC TPN CR CPN UR CS BY GR CR


HIS:  List of Students with credits attempted, completed, GPA, rank, etc.

DESCRIPTION: List of students with their credits attempted, completed, total non-weighted GPA (cumulative from HIS), class rank, 10-12 academic non-weighted GPA (from HIS), UC rank, and class size, sorted by grade and class rank

LIST STU ID NM SX GR CA CC TPN CR CPN UR CS BY GR CR


HIS:  Grades for All Courses in Transcript Data for a Specific Term and Year

List of student grades for all courses from a specific Term and Year


LIST STU HIS CRS STU.ID STU.NM STU.GR HIS.CN CRS.CO HIS.TE HIS.YR HIS.MK IF HIS.TE = # AND HIS.YR = ##


HIS:  List of Students Without a Specific Course in Transcript or Class Schedule

List of students who have not taken nor are scheduled in a specific course


1.  Skip students who have the specific course listed in Transcripts

     SKIP STU HIS IF HIS.CN = XXXX

2.  Skip students who are enrolled or scheduled in the specific course

     SKIP STU SEC MST IF MST.CN = XXXX

3.  List the Student Name and Grade

     LIST STU ID NM GR


HIS:  List of Transcript Data in a Specific Subject Area Grade

List of students with Transcript data in a specific subject area sorted by Grade which can be used to identify students deficient in a given subject area


LIST STU HIS CRS STU.NM STU.GR HIS.CN CRS.CO CRS.S1 HIS.MK HIS.CR HIS.CC BY STU.GR IF CRS.S1 = "E"

(Change subject area code.)


HIS:  List of Transcript Data for 9th and 10th Grade Students with an 'F' in Transcript Data

List of current 9th and 10th graders who have received an 'F' in a course with Course and Grade information


LIST STU HIS CRS STU.ID STU.NM STU.GR HIS.CN CRS.CO HIS.MK IF STU.GR < 11 AND HIS.MK : F


HIS:  List of Grade, Mark, Term, Year if Mark is Higher than 'C 'for Both Terms

List of students with Grade, Mark, Term and Year from Transcript data if a mark higher than a 'C' for both 1st and 2nd terms for a specific Course Number sorted by Student Name


LIST STU HIS STU.NM STU.GR HIS.YR HIS.TE HIS.CN HIS.MK BY STU.NM IF HIS.CN = #### AND HIS.MK < "C" AND HIS.YR = XX AND ( HIS.TE = 1 OR HIS.TE = 2 )


Total Queries

GRD:  Total Marks given for Specific Courses During a Specific Grade Period by Course Number

Total of each grade mark given for specific courses sorted by Course Number and mark


TOTAL GRD CN M1 BY CN M1 IF CN = #### OR CN = ####

(Change the marking period if needed.)


GRD:  Total Number of Comment 1 Entries by Code Value in Grading Table

Total Number of Comment 1 entries sorted by comment code in the Grading Table.


TOTAL GRD C1 BY C1


Label Queries

Labels for Specific Colleges

Labels for specific Colleges addressed to the Director of Admissions


LIST COL NM \ "Director of Admissions" \ AD \ CY ST ZC IF ID = ####

(Replace the #'s with the Aeries College ID number. Run the query. Click on the Labels button on the right side of the Query page.)


Change Queries

HIS:  Change Credits Completed to Match the Credits Attempted in Transcripts (HIS) for Students with a Specific Passing Mark

Change the Credits Completed to match the Credits Attempted if a student received a specific passing mark


CHANGE HIS CC TO CR IF MK : A OR MK : B OR MK : C OR MK : D OR MK : P