Dropped Courses With Grades Query

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