In one of our courses the course total is calculated normally with weighted averages of activities done through the Term. However, if the student does not get a passing grade in the Final Exam (an activity done outside of Moodle), the course total needs to revert to zero. Otherwise, it is the calculated weighted average, as explained before.
As we get the grades for the final Exam from another platform in a CSV spreadsheet, we import them in the column for Final Exam.
We would like to import the zeroes too for people who failed in the column Course Total.
But there is no way to map to Course Total.
Any idea how to import grades to Course Total that will override the calculated grades?