I have a MS Excel spreadsheet that I'm helping develop for someone who is using it as a grading sheet. I'm using someone else's version as a template.
There is room for 20 pieces of work from each student in the class (plus additional exams, etc.) What he wants to do is be able to distinguish between the columns which assignments were coursework and which was homework, so that they may be weighted differently in the final grade.
If that explanation was confusing, consider this...
I have 20 columns, each with percentage marks in them. The teach won't know until the school year begins where the homework will fall in the schedule and where the classwork will fall. I want for him to be able to highlight the columns that were homework and 'mark' it somehow, so that a formula that I will provide will weight the HW differently than the classwork.
I hope that helps. Please let me know if you need any further clarification.