Midterm Grade Achievement Administration

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:

  1. The "current grade" synced from the LMS is greater than the configured percentage 
  2. 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.

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

How to Contact Support
There are many ways to reach out! Click here for our support options.
Watermark Academy
Click to access the Watermark Academy for consultation, training, and implementation companion courses.