List of students by course with grades and course absences.

The Course Lists with Guardian Email Addresses Query will give you the Email Addresses for Guardians of students in a specified Course. When...

The query includes course title, course name, course section, terms, periods, period title, school cycle day title and teacher print name. *...

This query will provide a report includes Course ID, Course Name, Course Section, Term, Day, Period, and up to 4 Teacher Names for each course...

List of Enrolled students who have requested courses listed by Gender.Course Title, course Section, Student ID, Last Name, First Name, Gender, Grade...

Detention Letters query includes student ID, Last, First, grade, offense date, consequence, hours assigned, hours served, parent name, street number...

Student Detention List Sample output

List of iPASS Parent users. Last Name, First Name, User ID, Active, Student ID, Student First Name, Student Last Name, School Name. Sorted by User...

Query for all students with a discipline record. Student ID, Last, First, Homeroom, grade level, offense date, SASID, DOB, punishment description,...

This query can be used to find "Dropped" courses with Final Grades. This can be helpful to find these courses so that grades can be removed...

This query lists the Enrolled Student's ID, Last Name, First Name and Earned Credits for a chosen year. Sample Output:

This is one of two queries that iPass Support has created to help extract data from iPass for reporting staff data in the EEO-5 Survey. This...

This is one of two queries that iPass Support has created to help extract data from iPass for reporting staff data in the EEO-5 Survey. This...

List of ELL students who are enrolled. ELL State Code does not equal 00. Student ID, Last Name, First Name, Grade Level, Homeroom, ELL Code.Sorted...

A list of students whose primary language equals the language entered on the Execute screen.Student ID, last Name, First Name, Grade Level,...

List of Enrolled students whose low income state code field equals the code entered on the execute screen.Student ID, Last Name, First Name, Grade...

This query lists any student that is a migrant, by school. Student ID,Last Name, First Name, Grade Level,Homeroom, School Name, Migrant Status...

Connecticut query lists students who are in grade level PK by school. Student ID, Last Name, First Name, Grade Level, Homeroom, School Name, Program...

Query to find enrolled students set to Report to DOE = NO

List of Enrolled students and their Shop Week designation.Student ID, Last Name, First Name, Grade Level, Homeroom, Shop Week.Sorted by Last Name,...