I am tying to use a data base of student info (name, grade, student id., and there are 3 tests that each have a raw score field, a scaled score, percentile, and a stanine score. And a totals section with an average of these previous scores
- what I am trying to do is manually enter the raw score and have the other scores (the scaled score, percentile, and a stanine scores) auto populate from the referenced scoring chart saved as an excel file.
- this is very time consuming because each test has different scoring bell curves and there are 675 students to evaluate)