The CAASPP Interim Assessment Reporting System allows CAASPP administrators with the proper permissions the ability to create groups of students to easily view a collection of student assessment results. They also have a method to upload a Student Group file. 


Customers have requested that an export routine be available in Aeries Web to create this Student Groups file. Since the Student Group file could be any collection of students (students with English teacher, students with a certain counselor, students in a course, students by period, EL students, special ed students, etc.) we believe it would be more effective for customers to use Query to create the simple file.


Below are example queries for creating groups of students by section (secondary) or by teacher (elementary). The queries are designed to run at the School level. A unique group_name was created using the school number, teacher name, and period/course information. The group name can be altered to meet the needs of the district. The teacher's email address was used as the group_user_login. This field can be altered to meet the needs of the district. The highlighted values will need to be reviewed/updated to the district's specific information. NOTE: "2020" is for the 2019-2020 school year:


Secondary school ELA classes

LIST STU SUP LOC SEC MST CRS TCH  (( CAST(STU.SC AS VARCHAR(3)) + CAST(TCH.TE AS VARCHAR(10)) + CAST(MST.PD AS VARCHAR(1))  + CAST(CRS.CO AS VARCHAR(30))  )) (( CAST(LOC.CC AS VARCHAR(2)) + CAST(LOC.DC AS VARCHAR(5)) + CAST(LOC.SC AS VARCHAR(7)) )) "2020" "ELA" STU.CID TCH.EM BY STU.SC TCH.TE MST.PD MST.CN STU.CID  IF MST.CN = CRS.CN AND CRS.S1 = "A"  



Secondary school Math classes

LIST STU SUP LOC SEC MST CRS TCH  (( CAST(STU.SC AS VARCHAR(3)) + CAST(TCH.TE AS VARCHAR(10)) + CAST(MST.PD AS VARCHAR(1))  + CAST(CRS.CO AS VARCHAR(30))  )) (( CAST(LOC.CC AS VARCHAR(2)) + CAST(LOC.DC AS VARCHAR(5)) + CAST(LOC.SC AS VARCHAR(7)) )) "2020" "MATH" STU.CID TCH.EM BY STU.SC TCH.TE MST.PD MST.CN STU.CID  IF MST.CN = CRS.CN AND ( CRS.S1 = "D" ) 



Elementary school ELA for 5th grade students

LIST STU SUP LOC TCH  (( CAST(STU.SC AS VARCHAR(3)) + CAST(TCH.TE AS VARCHAR(10)) + CAST("ELA" AS VARCHAR(3))  )) (( CAST(LOC.CC AS VARCHAR(2)) + CAST(LOC.DC AS VARCHAR(5)) + CAST(LOC.SC AS VARCHAR(7)) )) "2020" "ELA" STU.CID TCH.EM BY STU.SC TCH.TE STU.CID  IF STU.SC = 990 AND STU.GR = 5 



Elementary school Math for 5th grade students

LIST STU SUP LOC TCH  (( CAST(STU.SC AS VARCHAR(3)) + CAST(TCH.TE AS VARCHAR(10)) + CAST("MATH" AS VARCHAR(4))  )) (( CAST(LOC.CC AS VARCHAR(2)) + CAST(LOC.DC AS VARCHAR(5)) + CAST(LOC.SC AS VARCHAR(7)) )) "2020" "MATH" STU.CID TCH.EM BY STU.SC TCH.TE STU.CID  IF STU.SC = 990 AND STU.GR = 5 



Elementary school All (ELA and Math) for 5th grade students

LIST STU SUP LOC TCH  (( CAST(STU.SC AS VARCHAR(3)) + CAST(TCH.TE AS VARCHAR(10)) + CAST("ALL" AS VARCHAR(3))  )) (( CAST(LOC.CC AS VARCHAR(2)) + CAST(LOC.DC AS VARCHAR(5)) + CAST(LOC.SC AS VARCHAR(7)) )) "2020" "ALL" STU.CID TCH.EM BY STU.SC TCH.TE STU.CID  IF STU.SC = 990 AND STU.GR = 5  



After the query is run it can be exported to Excel and then copied and pasted into the CAASPP Interim Assessment student group template.


Please refer to the CAASPP Reporting System User Guide  on the  CAASPP Interim Assessment Administration Resources page for more information on how to manage and upload the Student Groups file.