G'day everyone,

My 'Search-Fu' must be on the blink as I can't seem to find an answer to my question anywhere on the Internet so if anyone can help it would be greatly appreciated.

I'm a teacher and am trying to create a simple chart where I enter my class results each week into a spreadsheet for simple formative tests and then the next day I can display a chart showing an anonymous chart of improvement in class average. Class terms are 9-11 weeks long and the formative tests vary between basic 5 question spelling tests to 'speed' calculations up to 25 questions.

Making a spreadsheet that updates each week when I update it has me bamboozled (and the stupid thing is that I'm the bloke that is usually helping OTHER people with the IT questions... )

Any help, pointers?

B