Hello all.

Reseach with EduSci dept. @ University of Minnesota. Data entry: streamlining and automatization.

Kids take proficiency tests, we enter and sort the data, double-check it, then send it to teachers to help sort the kids into appropriate reading levels and programs.

Five main fields.

1 Grade
2 Raw Score
3 Percentile
4 Index Number
5 Rating

Percent, Index, and Rating are normed against Grade level. Percent, Index, and Rating follow deterministically from a child's Raw, given their Grade.

Since 3-5 follow from 2 (and 1) in a set way, I want to automatize their entry to reduce keystrokes, time, and eliminate the need to double-check those fields because it ties up resources.

We have a paper data sheet that specifies what each particular Raw renders which Percentile/Index/Rating values. I want to write that table into Excel, and then have the fields auto-filled whenever a Raw field is manually filled.

I know this is possible, and have done it before on a smaller scale for grading papers, but cannot remember how.

Assuming that the paper data sheet has already been digitized, which I will propose to my super once this question is answered, how may I accomplish this goal?

Livelaughlove,
~Haven.-