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.-
Bookmarks