Food for thought...

I've used my own Excel based 'Grades Manager' addin for some years now
and I find when students change classes it's easier to keep their marks
intact for any specific class curriculum, given that different classes
may follow different course outlines. That precludes, then, that a
'summary' sheet for all classes would contain a unique list of student
names/IDs (rows with no duplicate IDs), and a complete (columnar) list
of all items students receive scores for. This serves systems that need
to track one student's progress while that student attends several
classes.

If you're only tracking a single subject (maths) then the task is more
simplified, but nonetheless still complex in that the summary sheet
formulas have to ref many sheets. To make this easier, I suggest
dividing the columnar score items into sections for each sheet so that
each section uses the same ref for the source values. To the right of
the last sect you can collect totals and show final
marks/grades/gpa/percent values. The template you end up with will
probably work better if you implement heavy use of local scope defined
name ranges for use by the formulas on the summary sheet. The formulas
on the summary sheet should take into account the student name & ID in
case, for example, there's 2 students named "John Smith" whether
they're in separate classes or the same class.

Another way to go is to use one sheet per class that tracks scores and
reports final marks/grades/gpa/percent values for the class list, then
just have your summary sheet grab the finals from each class and make
its calcs based on those values. For example, Student1 is in Class1 &
Class2, and so this will have 2 entries on 'Summary'. Students in 1
class only will have 1 entry, students in 3 classes will have 3
entries. The overall 'Final' mark/grade/gpa/percent values will be the
average of total entries per student.

I suggest the template has a minimum number of class sheets that are
designed to allow some flexibility for the number of score
items/sections on each sheet. The summary sheet will be pre-designed to
service the minimum number of class sheets, but have a utility that
allows you to add more class sheets and inserts new summary sections
when more class sheets are added.

Sounds to me like you need to engage the services of a professional
Excel developer if you can't find anything ready-made to run with.
There are lots of student grades templates floating around that you can
download and test drive. Here's some links...

http://www.spreadsheetzone.com/default.aspx

http://office.microsoft.com/en-us/te...61.aspx?CTT=97

This next one (MarksXPress Student Grades Manager for Excel) is an
addin that you can have modified to fit your school's grades
tracking/reporting criteria...
http://www.solutionsxpress.com/products/mxp.htm

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc