running calculator for instructors

[uwatch]

I am sure I have seen this in a forum but can't locate it again. We use excel 2003
What I am after is a tool that does the following.
file attached is the current system (a bit basic).
Each week I get instructor feedback, on each section they are marked from 1 to 5. What I want is a system where I can input the info into excel which works out how they are scoring throughout the year.

The maximum number of students is 5 so the maximum score available in each week would be 25 (all five students thought that he was excellent). We have then divided the score by the students taught to give us a average score for each section.

Thus far ok??

This part is fairly straight forward; the problem is when I then have to input new data. What I want is to be able to put what they scored that week rather than having to add the numbers up in my head to get a running total. So I can see what they are averaging throughout the year.

I look forward to not being bamboozled.

[Palmetto]

In the attached sample: (see Sheet2)

Restructured layout to classic database style layout
Applied Data Validation to "score cells" restricting entries to values from 1 to 5
Created list of instructor names and used the list in a data validation dropdown to select the name

Formula for weekly score
=AVERAGE((D6*$J6),(E6*$J6),(F6*$J6),(G6*$J6),(H6*$J6),(I6*$J6))

Formula for running average
{=AVERAGE(IF($C$6:C20=M5,$K$6:K20))}

Note: the formula for the running average is an aray formula and must be committed to the cell using the key combination Ctrl + Shift + Enter (Excel adds the curly brackets)