How to List Students who are missing a Marking Column Grade

This process can be used to identify Students who have not been given a grade for a specific Marking Column.
This can be accomplished by merging queries or running a Grade Entry Sheet Report:

Steps for the Grade Entry Sheet Report:

https://kb.blackbaud.com/articles/Article/38911 


Steps to create a merge queries:

Query 1: All Current Students
1.) New Student Query > Dynamic
2.) Expand Student > Expand Bio 1 > Select Current Status = Current Student (and any other applicable statuses)
3.) Expand Student > Student Progression Entry > Select Academic Year = 2015-2016
4.) Check Results for correct number of Students
5.) Save and Close

Query 2: All Students with a Grade for a specific Marking Column.
1.) New Student Query > Dynamic
2.) Expand Student > Student Progression Entry > Select Academic Year = 2015-2016
3.) Expand Grades > Expand Grades/SKills Select Academic Year = 2015-2016
4.) Expand Grades > Expand Grades/Skills > Expand Grades > Select Marking Column = Marking Period 3

Merge Query:
1.) File > Merge Query
2.) Select Query 1 (Current Students)
3.) Select Query 2 (Query for Marking Column
4.) Select to Include Records in Query 1 but exclude records included in both
5.) This will show all Current Students without a grade in that Marking Column

Environment

 Education Edge

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.