It appears that it is not possible to create a calculated column using formula builder, e.g. for a term grade, that uses weightings that ignores empty cells (e.g. if a student missed an assessment). "Unfortunately AVERAGEIF function is not availab...