A variation on the original scaling spreadsheet, this spreadsheet has standard deviation, average (mean) as well as grade scaling.
This is a scaling spreadsheet which can be used by teachers to assist with grades – including calculations involving means and standard deviation.
Free downloads are offered without warranty, and while I have scanned these prior to uploading, you should scan yourself after you have downloaded the file, to reassure yourself and prevent any virus infection.
I was recently requested by a teacher to set up a spreadsheet to assist in scaling an examination result. The spreadsheet allows the user to enter in student numbers, student names, the original marks, the original scale (total marks for the assessment). There are then a number of columns with different scaling ratios applied, and the teacher just needs to choose the most appropriate (based on their own criteria). Hope you find it useful, and if you need more information on the scaling algorithm I used, please go here.
My name is Stephanie Krishnan and I'm passionate about the way that open source software and its community can help small businesses and individuals with their productivity and lives. One of the biggest arguments I get from business owners, however, is lack of support options. I decided to put together my own support blog to help people be productive at various levels with one of my favourite open source alternatives: OpenOffice! I do this through tutorials, downloadable templates and answers to questions from readers!
