Overview
The Midterm Grade Achievement identifies students who have achieved a midterm grade between the specified minimum and maximum thresholds.
- Midterm Grade Achievements will only run once per Transcript Course, eg. student/course/term enrollment record.
The midterm grade achievement will look at the midpoint of the course section based on course section start and end dates and trigger a midterm achievement alert the first time a valid grade is synced for each course enrollment after the calculated mid-point.
The midterm grade achievement will trigger only once after a valid grade is synced in either one of the following two cases:
- The "current grade" synced from the LMS is greater than the configured percentage
- The "midterm grade" imported from the SIS is greater than the configured percentage
- The SIS midterm grade is a letter grade, not a percentage.
- In order to compare the midterm grade percentage, the system finds a matching grade and then finds the percentage that it corresponds to.
- The percentage is determined by looking up the "Maximum Percent" value in Grade mapping (https://institution.avisoapp.com/aviso/grade/list) for that letter grade if found.
- Then, if either the current grade (%) from the LMS or this maximum percentage is over the minimum achievement threshold, and the current grade is less than the maximum threshold, we create the alert.
If the student's current grade is greater than the maximum percent attributed to the midterm letter grade, the achievement will be stored with the student's current grade (which is a percentage) rather than the letter grade stored in the midterm grade.
For example, if a student earns a mid-term grade achievement for having a B in a course, and the maximum percentage associated with a B is 90%, and the student's current grade in the course is 92%, 92% will be used as the grade stored in the achievement.
Fields
Name
Name of the achievement.
Description
Description of the achievement for administrative purposes.
Active
Whether this achievement alert is active Yes or No.
- When active, SS&E will run the achievement to look for students who have a midterm grade that is between the minimum and maximum thresholds. and display results in the student Activity Feed.
Number of Days Until Expiration
The number of days the achievement will remain on the student's profile.
Staff Roles
The roles that can view and opt into being notified of the achievement. This is done in a user's Settings area.
Staff UI Text
The template text will be used on the news feed, in the daily digest email, and on the student's profile. This text is copied from the default text setup for the institution.
Notify Students
Whether to notify the student, by email, when the achievement is awarded.
Email Sent As System
Whether the email sent to the student is from the SS&E system (checkbox checked) or the Coach/Advisor (not checked).
Email Subject Template Text
The subject text for the email to be sent to the student.
Email Body Template Text
The body text for the email to be sent to the student. The following variables may be used in the body of the email text:
- ${advisorFullName} - Advisor Full Name
- ${advisorTitle} - Advisor Title
- ${coachFullName} - Coach Full Name
- ${coachTitle} - Coach Title
- ${studentFirstName} - Student First Name
- ${studentFullName} - Student Full Name
- ${courseCode} - Course Code
- ${midtermGrade} - Midterm Grade
To access a courses code or grade, you will need to iterate through a list of the courses associated with the alert.
#@joinList($courses) ${item.grade} in ${item.code}#end
You may also use if statements within the body of the template text to hide/show specific content. For example, often the achievement will need to be from the Advisor or Success Coach. In this case, if we want to show the Success Coach if a student has one, but not the advisor. Or if want to show the Advisor if the student does not have a Success Coach, then create the following if statement:
#if(${coachFullName})
${coachFullName}
#elseif(${advisorFullName})
${advisorFullName}
#end
Any variable listed above can be utilized in an if statement. For more information on how to create if-else type conditional statements please see this article: http://velocity.apache.org/engine/1.7/user-guide.html#if-elseif-else
You may also need to use for loops in order to list certain items in the email. For example, if you would like to let the student know his or her midterm grade, you will need to loop through all the courses that meet the criteria. Then you must access the grade property on a course to display it. If you would like to create a bullet pointed list of course grades then use the following code:
- #foreach($item in $courses)
- ${item.code}: ${item.grade}
- #end
This will display the title of the course with the resulting grade next to it.
Minimum Threshold %
The minimum grade percentage for which to generate the achievement.
Maximum Threshold %
The maximum grade percentage for which to generate the achievement.
Included Tags
The tags this achievement will run for. If this is empty, no filtering on tags will occur.
Excluded Tags
The tags to exclude from this achievement.
Included Course Sections
The course sections this achievement will run for. If this is empty, no filtering on the course section will occur.
Excluded Course Sections
The course sections to exclude from this achievement.
Included Programs
The programs this achievement will run for. If this is empty, no filtering by the program will occur and all programs are eligible.
Excluded Programs
The programs to be excluded from this achievement.