Ealge/Aeries - Helpful Queries
Student Information/Demographic Queries
List of students who entered after a certain date
LIST STU TCH STU.NM TCH.TE STU.GR STU.ED IF STU.ED > 09/08/2003
(Change date as needed)
List a total number of students by Ethnic Code and Sex
TOTAL STU EC SX BY SX EC
Find parents who have a different last name than the student
LIST STU NM GR PG IF PG ; LN
Find students with missing Ethnic Code
LIST STU SN LN FN EC IF EC = NULL
Find students with missing health immunizations
LIST STU IMM STU.SN STU.LN STU.FN STU.GR IF IMM.P1 = NULL
(where IMM.P1 = Polio 1)
Display student ID, name, birthdate and teacher, by teacher
LIST STU TCH STU.LN STU.FN STU.ID STU.BD TCH.TE BY TCH.TE
(Click the Report button to print individual pages by teacher)
Mailing Labels: "To the Parents of:"
LIST STU "To the Parents of" NM AD CY ST ZC
(Click Run then click on the Labels button)
Students on Permit: Display student name, grade, address and permit code
LIST STU SUP STU.SN STU.ID STU.LN STU.FN STU.GR STU.AD STU.CY SUP.CO BY STU.GR IF STU.TG = " " AND SUP.CO # " "
Special Program Queries
Display a list of students with the programs in which they are currently participating in
LIST STU TCH SUP STU.ID STU.LN STU.FN STU.GR STU.LF STU.U8? CSE CSE.PL? CSE.XD SUP.CH SUP.GT? SUP.MG TCH.TE BY TCH.TE
Display an alphabetical list of all GATE students with grade level
LIST STU SUP STU.LN STU.FN STU.GR SUP.GT IF SUP.GT = 1
Display student no. last name, first name, and grade of 6th grade LEP students
LIST STU SN NM GR LF IF GR = 6 AND LF = L
(Change grade level (GR) and/or LEP level (LF) as needed)
Display student name and LEP level for specific teacher
LIST STU TCH STU.LN STU.FN STU.LF TCH.TE IF TCH.TE =
(Enter teacher name for TCH.TE = )
Achievement Queries
Display student name, grade, test, test date, test title, and Performance Level scored on CST taken 4/03
LIST STU TST TCH CTL STU.NM STU.GR TST.ID TST.DT CTL.NM TST.PL TCH.TE BY TCH.TE IF TST.ID = CST AND TST.TA = SPRG03 AND TST.PT = 1
(Change TST.PT as needed: 1= ELA and 21 = Math)
List 7th grade students with a GPA of 3.5 or greater
LIST STU NM GR TPN IF GR = 7 AND TPN > 3.49
(Change grade level (GR) and/or GPA (TPN) as needed)
Display student name, Test ID, Test Part, and Percentile if they scored below the 50%ile on Part 1 (ELA) of CAT6 taken Spring 03
LIST STU TST CTL STU.LN STU.FN TST.ID CTL.NM TST.PC IF TST.TA = SPRG03 AND TST.ID = "CAT-6" AND TST.PT = 1 AND TST.PC < 50
(Change Test ID, Test Part and score as needed)
Attendance Queries
Lists all students with their all day code if absent on a specific date.
LIST STU ATT STU.LN STU.FN STU.GR ATT.DT ATT.AL BY STU.GR IF ATT.DT = 02/03/2004
(Change date as needed)
Lists all students in a particular grade level with their all day code if the All Day Code is not blank for a specific day.
LIST STU ATT STU.LN STU.FN STU.GR ATT.DT ATT.AL BY STU.GR IF ATT.DT = 02/03/2004 AND ATT.AL > "" AND STU.GR = 10
(Change date and grade level as needed)
Lists total number of students absent on a particular day if All Day Code is not blank.
TOTAL ATT IF AL > "" AND DT = 02/03/2004
(Change date as needed)
Total number of students in a specific grade level absent if All Day Code is not blank on either of two days.
TOTAL STU ATT IF AL > "" AND STU.GR = 10 AND ( DT = 02/03/2004 OR DT = 02/04/2004 )
(Change date and/or grade level as needed)
Other
List students name, ID, and medical problems for a specific grade level
LIST STU MHS STU.LN STU.FN STU.ID STU.GR MHS.CO IF STU.GR =
(Enter grade level desired for STU.GR = )