Milestone automatic

Question

I have students data and their marks, details, etc. I want to add 5% marks set for each class greater than their previous exam avg marks. So i want to set the marks for each student for the teacher to evaluate students. how to do this?

Answer 1

Hi Karthick,

For example, you can add 0.5 avg for the next exam overall grade of students.

1. Create a calculated field to get the current avg for all students.

current avg = AVG([Grade])

2. Create another calculative field as

target avg = [current avg] + 0.05*[current avg].

3. Calculative field to compare whether the reached the milestone/target.

IF [Current avg] >= [target avg] THEN "Reached"

ELSE "Not Reached"

END

The above field can help you see whether the class has reached the target.

Hope it helps you.