averaging from one sheet to another

[Todd]

I am trying to compile library statistics. Whenever I
give an instruction session, I pass out forms for the
students to fill out. They choose a numerical value (1-5)
to describe their proficiency in several different
areas. I need to have a form where I input the data so
that the data is automatically averaged with all the other
data from all the other students. I suppose the average of
all the students would be tallied on a separate page, and
hte original sheet would go blank after each new student's
data was added to the pool of all the students' data.
Does this make sense, and can anyone e-mail me with
suggestions?

Thanks

 

[Guest]

Seems you can have a worksheet with column 'dates' for the course your
teaching and insert the 'ratings under it - the rows could be what they're
being rated in. You could use an 'average for the total and then use another
cell under the spreadsheet area that takes the total averages from each
column and 'averages those cells' . That would give you a running average
PER CLASS as well as a running average of all students. Seems like you could
do it all on one sheet if you wanted - depending on how many students you
teach.

 

[medicenpringles]

well yes, i just like to have mirrored data on separate sheets. it'l
do fine both ways