Assessing Creative Writing in terms of a Percentage

After many years of thinking of ways to assess creative writing, I finally came up with, and used successfully, this template.

Ever wondered why you got a creative writing assessment back with 64%, for example. Why was this not 65%, 70% etc. How did they get these random numbers?

This spreadsheet aims to eradicate this guesswork and uses a more logical approach to obtain a percentage, based on the key creative writing areas, for example, Purpose/Organisation & Structure, Vocabulary, Grammar, Punctuation, Spelling and Handwriting. Just think of each area as a number from 1 to 5 (1=low; 5 = high). Then, each of the previously areas are weighted in terms of their importance. Enter your numbers for each category and the spreadsheet will generate the percentage.

This could be adapted to link to National Curriculum criterion, and even be used for KS3.