About ten years ago, my school had grade book software that would state what percentage each assignment was worth towards a report card’s mark. I could see that assignment X was worth 21.9% of the first report card, and at the end of the year it was worth 8.9% of the final mark. Our newer grade book software doesn’t have this feature, which is a shame because I find it valuable to know that information so that I don’t accidentally overweigh or under-weigh something, so I made a spreadsheet to calculate this information for me. (link)
This sheet works only with the type of grading software that uses the assignment’s weighting NOT the assignment’s “out of” score to calculate the report card’s mark. For instance, if your grading software takes one assignment that is marked out of 30 and weighted at 1, and another assignment that is marked out of 5 and weighted at 1, and calculates them as being worth the same amount (because they are each weighted at 1) towards the report card, then this spreadsheet will work for you. If your grading software calculates the assignment that is marked out of 30 as being worth six times the assignment that is marked out of 5, then this spreadsheet will not work for you.
Feel free to make a copy of this template if you find it useful, but please keep my name and site at the top-left.
Doors Marked Pull 