Harris School Solutions iPass Resource Center
Search:     Advanced search

Dropped Courses With Grades Query

Article ID: 1006
Last updated: 18 Sep, 2017
Views: 0

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 or transferred because dropped courses with final grades will appear on Report Cards and Transcripts. 

When executing this file:

  • Calendar Year = Year you want to search in (ie. 2016-2017)
  • Create Date = First Day of School (ie. 09/01/2016)
  • Action = Dropped
  • Grade Heading Abbreviation = Abbreviation for "Final Grade" Grade Heading (ie. FGr) ** 

** The Final Grade Grade Heading Abbreviation may vary so check the Grading System > Maintenance Grading > Grade Headings for the Abbreviation used on your site.

Report will look like this:

Student ID First Name Last Name Create Date Create Time User Id Action Title Name Course Sec Abbreviation Grade Code
1614 11/16/16 31022 Dropped SH1203 Carpentry Shop 01 FGR 82
1614 11/16/16 31036 Dropped RE1203 Carpentry Theory 01 FGR 85

Attached files
file Dropped_Courses_with_Grades.d (3 kb)

Prev   Next
DOE Student Discipline Record Query     Earned Credits Query