We are stumped about how to create an Intelligent Agent for the following use case. An instructor has set up her gradebook with a category for homework assignments, and wants to identify students who are missing a significant proportion of HW assignments (say, there are 10 HW assignments and she wants to identify people who have submitted 4 or fewer so far). She has a formula column in the gradebook whose total represents the # points eared on HW assignments completed so far. Release conditions for grades only allow for selecting individual HW assignment columns, not the formula column.
The instructor also considered simply setting up an Intelligent Agent for students with overall low grades in the course (as grades so far are accumulated by may small assignments). But we can't identify a release condition for the IA that would identify students with overall low grades (only those with low grades on a particular assignment).
Any ideas?