Administrators can perform grade search queries across all teacher gradebooks and marking periods to search for specific average and progress information. With this feature, you can quickly identify how well students are doing across any courses or subjects. You can perform search queries on grades, scores, skill grades, averages, comments, and narratives. Teachers have a similar feature, restricted to the classes they teach
The following are a few examples of the many types of queries you can perform:
- Find all students who have more than 3 absences in a single class, or less than 10 absences in all classes
- Find all students failing a particular subject or just the courses taught by a particular teacher for any marking period.
- Find any students meeting a specific average criteria for any marking period or gradebook.
- Search for all students with missing work for a particular marking period.
- Search for all students with a specific conduct comment for any marking period.
Only the default TeacherPlus Management Site manager account has automatic access to the Custom Report Library, where search query reports can be generated. To give access to this area to other admin or special accounts, select the check box Management Reports when first adding the user in the User Account dialog box. To give access to accounts already created, click to edit the account from the Create User Accounts page (View Gradebooks > Create User Accounts), and select the check box Management Reports at the bottom of the dialog box. (Remember to click Done.)
To generate a grade search query report, do the following:
- Click Reports, and then click Custom Report Library, and then click Add Report.
Enter a Report Name, and then click a query type from the Query On drop-down list.
- Select the check box corresponding to each marking period(s) or semester(s) to be included in the search.
- If your search query is based on comments, select the check box for the desired comment column.
- If you're generating a narrative report, select to include Blank or Not blank narrative in the Include students having narratives that are area.
In the Include student having grades/scores/skill grades/comments area, specify the grade or comment requirement for the search as well as the minimum or maximum number of students who meet the criteria.
If you're searching for students with missing work or no scores, select Equal to from the Score(s) drop-down list, and leave the value blank.
Do any of the following:
Select the Section Filter check box, and then select the section(s) and teacher(s) relevant to the report.
Select the Course Filter check box, and then select to include all courses or specific courses on the report. In addition, select one of the Course Priority and Which Course Levels? options (for example, all major AP courses only).
- If you selected to query on Scores in step 2, select the Column: Category Filter check box, and specify the assignment score column types to be included. You can also select the Column: Data Range Filter check box, and specify a data range for the score columns.
- Optional: Scroll down, and select the demographic fields to be included in the report by clicking the field(s) in the Available Fields area and clicking to transfer the fields(s) to the Selected Fields area.
Click Save and Run to run the query and generate the report.
When the report is generated, you can include students who have withdrawn from courses by selecting the Include Withdrawn check box.
After you save a search query report, it's stored in the Custom Report Library, where you can see a list of all the reports you've created and saved. Use the icons beside a report to edit, delete, or run the report.
The following figures illustrate query settings based on the specified report goal:
- Find any students with missing homework for the second marking period in November.
- Find all students with good effort and good conduct comments.