comparing test scores over a few years
 

Hello everyone:

I have been asked to help work on a project involving achievement test
results. I would need to find a relatively painless way of inserting the
data and then comparing results over a period of eight years. Each section
of the achievement test has a raw score, a scaled score, a graded equivalent
and a percentile based on the section of the population taking the test.
There are five sections in total, one of which will only be taken by the
first level. How would I go about doing this? How could I then look at
specific characteristics of each student and see how that affects the data?
This is a little beyond my ability with excel but I said that I would give it
a shot.