Queries for High School SMS Building

Queries for High School SMS Building:

Keep statement for 8th graders

KEEP STU IF GR = 8 (make sure you click “Include Inactive Students.”)

Keep statement for 8th graders in Int Math 1 (change course number for different math classes)

KEEP STU HIS IF HIS.CN = 096014

List of 8th graders grades in English (change the year)

LIST STU HIS CRS STU.LS STU.ID STU.LN STU.FN STU.GR STU.U1 STU.LF STU.U2 STU.TG HIS.CN CRS.CO HIS.MK HIS.CR HIS.CC HIS.TE HIS.YR IF HIS.TE = 1 AND HIS.YR = 17 AND ( STU.TG = * AND STU.GR = 8 ) AND CRS.DC = E

Keep statement for next school (Insert next school code) – I run this query while logged into the middle school

KEEP STU BY NS IF NS = 418

Keep student by course# and grade (change course number and grade as needed)

KEEP STU SEC MST IF MST.CN = 1032 AND STU.GR = 9

Keep student by (MST) last year’s course number (update Course# as needed)

KEEP STU HIS IF HIS.CN = 4102

Skip statement for a certain class in the SMS (allows you to see if a kid is missing a core subject –change course code)

SKIP STU SSS CRS IF SSS.CN = 1232 OR SSS.CN =1540

SMS Listof students who have NO course selections

SKIP STU SSS IF SSS.CN > 0

AERIES Information Queries

Keep students by specific section number (update section number)

KEEP STU SEC MST IF SEC.SE = 164

Keep students by a specific period to include teacher, class and room number (change period and semester code)

LIST STU SEC MST TCH STU.ID STU.NM MST.PD CRS.CO TCH.TE MST.RM MST.SM IF MST.PD = 1 AND MST.SM # "S"

List students who have a D or F at a certain marking period (change marking period)

LIST STU GRD CRS TCH STU.ID STU.NM STU.GR CRS.CO TCH.TE GRD.M1 IF GRD.M1 > " " AND ( GRD.M1 : D OR GRD.M1 : F )

List students in their English class (you can change dept code to get ANY core class OR erase the grade to get ALL students)

LIST STU SEC MST CRS TCH STU.ID STU.NM STU.GR CRS.CO MST.PD TCH.TE IF CRS.DC = E AND GR = 9

Student Grades Math and English (All marking periods)

LIST STU GRD CRS TCH STU.ID STU.NM STU.GR STU.U1 STU.U2 STU.LF TCH.TE GRD.PD CRS.CO STU.GT GRD.M1 GRD.M2 GRD.M3 GRD.M4 GRD.M5 GRD.M6 IF CRS.DC = M OR CRS.DC = E

List students in a certain teacher’s class (insert the teacher number)

LIST STU SEC MST CRS TCH STU.ID STU.NM STU.GR MST.CN CRS.CO MST.PD TCH.TE BY MST.PD MST.CN IF MST.TN = 88

SAT Subject Test scores for students (I use this for the LOTEstudents)

LIST STU CTS STU.ID STU.LN STU.FN STU.GR CTS.DT CTS.NM CTS.SC1 CTS.SC2 CTS.SC3 CTS.SC3 CTS.SC4 CTS.SC5 IF CTS.NM = "SAT II"

Keep students by a specific class (change course number as needed)

KEEP STU SEC MST CRS IF CRS.CN = 8627