Note: As of July 9, 2018, Blackbaud's School Management solutions (which include Core, onBoard, onCampus, onMessage, and onRecord) are utilizing a new top level navigation. This primarily affects users performing administrative tasks-constituent navigation for most parents, students, faculty, and alumni will remain the same. We appreciate your patience as we work to update our documentation. If you are seeing this message, the content of this solution is still being vetted for possible updates. Please refer to this mapping document if you need assistance finding a task in the new navigation.
We need to export students' grades for a certain course section and assignment type.
You could build a list like this using the following parameters:
Objects: Assignment -+Course Group ---+Course Term -----+School Year ---+Course base -+Gradebook Assignment Grade ---+Gradebook Assignment -+Assignment Type
Filters: Where - School Year.Current Year - is True And - Assignment Type.Assignment Type - is - (select the appropriate assignment type) Display Fields: Note: Make Sure that "Enable grouping options" is turned OFF (otherwise students who scores the same will be lumped together and throw off the average) Course Base.Course Title Course Group.Group Identifier Gradebook Assignment Grade.Grade Gradebook Assignment.Max Points
This will give you every course, and every section with every final exam grade and the max points. The database can't calculate the percentage, so you would need to make an Excel column for Grade/Max Points, and then Average those by Section to get percentage averages.