I have a question similar to at least two other previous questions posted by others but more critical.
Previous posts are
My actual solution.
A Students-Athletes table is made for testing students/athletes on performing specific tasks.
The performance is calculated in time (minutes:seconds), lower time = higher performance
Every time the same task is completed an unstored field calculates the actual performance compared to previous trials.
The students may repeat the same task multiple times until they reach the expected performance.
The relationship graphic is very easy
STUDENTS TASK TASK.NAME
Name_pk <-> Name_fk <-> Name_fk
The Performance_Score field is calculated as follows:
Time = “”; “”;
Date = Min (Task.name::Date) and Time > Expected_Time; "Baseline";
Time ≤ Expected_Time; "Task Completed";
Time = Min (Task.name::Time); "Best Score";
Time = Max (Task.name::Time); "Worst Score";
Time < Average (Task.name::Time); "Above Average";
Time > Average (Task.name::Time); "Below Average"; "")
For students's feedback, an other unstored field calculates average Time as: Average (Task.name::Time)
This method is useful for a number of reasons:
- it permits counting how many trials the student has made before reaching expected performance
. the overall student’s average performance
- the student can compare each trial with previous trials
- the unstored Performance field updates every trial based on all trials
Now the question:
How can I have an other stored Performance field that would save time for statistics calculations.
I tried a stored field with auto-enter calculation using the same formula above but it does dot update every record (as it does the unstored field)
Maybe my fault ?
Many Thanks for your advices,