It allows you to easily combine the raw marks for up to 3 papers and instantly converts to UMS marks complete with grade achieved. The results can be copied and pasted into word or another spreadsheet.
The tab can be copied and renamed so you can keep the results for different classes on different tabs in a single excel file.
Simply input the maximum mark for each paper, the weighting of the paper, adjust the grade boundaries if necessary and then input the names and marks of each student and the UMS marks and the grade magically appear.
If necessary the names of the grades and the UMS marks awarded for each grade can be changed.
Only the areas in green need to be filled in, the areas in grey can be adjusted if absolutely necessary. If there are less than 3 papers set then the weighting should be set at zero for the unused one. The weighting can be in any ratio 1:4:3 works out exactly the same as 20:80:60.
There is a possibility that the G/U grades are not automatically completed for this version, but hopefully you won't need them!
MagicUMS v0.75(3) ODS
No comments:
Post a Comment