As a system administrator for a government agency, I have a problem providing support to a large number of courses which users must take on a recurring basis. Many are tied to annual certifications but some just need to be taken as refreshers. The scenario is this: three assessments exist in a course, test_2016, test_2017 and test_2018. If the proposed calculated column includes all three assessment columns, the proposed column would return the score of the most recently completed assessment. If the assessments are worth differing points, then the value of the column would vary according to each student. I am currently in the process of providing an SOP for doing this, and the work arounds available are very unsatisfactory.
|Product Version (if applicable):||0|