Table of Contents
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.
Flex Queries: If a query needs a conversion for Flex Scheduling, it is displayed below the original query in blue.
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 All Grades for Students with Teacher information for Marking Period 1
LIST STU GRD MST SSE STF CRS FTF STU.ID STU.NM STU.GR GRD.CN CRS.CO FTF.STI GRD.M1 STF.LN STF.FN BY STU.GR STU.NM FTF.STI IF GRD.SE = MST.SE AND SSE.PR = 1
(Add or edit the marking period - GRD.M1, GRD.M2, etc.)
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
REQ: List of School Grade Requirements
Provides a list of Subjects,Credit requirements and Graduation Track
LIST REQ CD SA C1 C2 C3 C4 GRT
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 Built-in GPA's
List of student's various Built-in 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 Various Custom District GPA's
List of student's various custom District GPA's, from Transcript data and the current marking period including: Class Rank and Credit Standing sorted by Grade and Class Rank
LIST STU IDN GPA DGP STU.ID STU.NM STU.GR STU.CHT DGP.SNM DGP.LNM GPA.GPW GPA.GPN GPA.CR GPA.CS BY STU.CHT STU.GR GPA.CR ^
HIS: List of Students with Credits Attempted, Credits Completed, Built-in GPAs, 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: 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 )
COL: List of College Information
Provides a list of colleges including: ID, Name, Address, Telephone
LIST COL ID NM AD CY ST ZA TL CD ZX AT
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 D's or F's for GRD Mark 1 by Student
Total of D's and F's for a student for a specific mark (GRD.M1)
TOTAL STU GRD GRD.M1 BY GRD.M1 IF GRD.M1 : "D" OR GRD.M1 : "F"
(Change the GRD.M1 field to the specific mark number 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