This is an excel document that calculates a student's final grade based on their scores in composition, performance and listening & appraising.
All you have to do is enter the student's scores a final 9-1 mark will be provided. Information has been sourced directly from OCR Music specialists and through CPD events, but all formulas and rules within the excel document have been added by myself.
Student targets change colour based on if they are on, below or above target. All grade boundaries are provided on an alternative tab. Formulas have been added for up to 20 students. If you would like me to add for more than this amount you can contact me and I can send a bespoke document following purchase.
All you have to do is enter the student's scores a final 9-1 mark will be provided. Information has been sourced directly from OCR Music specialists and through CPD events, but all formulas and rules within the excel document have been added by myself.
Student targets change colour based on if they are on, below or above target. All grade boundaries are provided on an alternative tab. Formulas have been added for up to 20 students. If you would like me to add for more than this amount you can contact me and I can send a bespoke document following purchase.
Something went wrong, please try again later.
Very useful resource thank you! I'd be keen to know how the data tables were arrived at.
Hi, Just purchased. Please could you send me information relating to the Excel document - 9-1 grade boundaries for each component you have used to compile the spreadsheet. Thanks, Helen
I cannot tell you how much this will help me. Thank you so much!
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£4.00