3 Replies Latest reply on Apr 13, 2017 7:00 AM by Jim Dehner

    Grades A-C Course Completion Calculation

    Francesca Gilkey

      Hi all,

      I have a file of students, their courses, and final grades by term and year. I am trying to calculate the course completion rate for those records with grades A-C. For this purpose, the course completion rate is total grades A-C divided by all grades. I want to pull it into various tables as a calculated field, so I can see the course completion rate by course, course section, term, year, etc. I have tried making a count of grades A-C and then count of all grades and the CCR calculated field = count of grades A-C/count of all grades, but I keep getting errors and miscalculations no matter how I have tried it. Please help!

       

      Thank you!