Justin,
This one just needs more information. How are the scores saved right now?
Electronically somewhere or just on paper? If they are in electronic files,
do you know what type of file?
After figuring out how to get them into Excel we can deal with how to
analyze the data. For a start I would suggest a separate sheet for each
section. You will want some kind of indicator for the 'section of the
population' that took the tests - if that ends up being the division of data
by sheet, that's fine for now. But you also say you want to look at specific
characteristics of each student - where is that information coming from?


"Justin" wrote:

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.