Quickly generate a mailing list of students in a certain grade range from a D2L grades export. I designed this tool so I can quickly build a mailing list of my students failing or near failing so that I can send email them to let them know where they stand and offer support.
Although this tool was designed for instructors who use the Brightspace D2L LMS, it will really work with any CSV file that contains two columns:
- One column named
Email - One column named
Calculated Final Grade Scheme Symbol
The first column must contain student email addresses and the second column must contain the respective grade for each student email address. The grades can be written in whole number or decimal form and may optionally be written with a percent sign (%). My program treats the grades in the second column as each student's overall grade.
* The CSV file may contain any additional columns as they have no bearing on my program's calculations.
View my example file.
Download the instructions (docx file) here.