Class Context Analysis Sheets in EXCEL
There are 6 EXCEL sheets that provide a quick summary breakdown of a class. One is for KS3 classes, one for KS4 GCSE classes, one for KS4 BTEC Classes and three for performance management summary data sheets.
Simply:
• Export the data from a SIMS marksheet.
• Paste the data into the Data Dump sheet
• Your class analysis is displayed ready for printing / copy and pasting.
This is useful for lesson observations when you want to provide a context for the person observing but don’t want to spend an hour making your summary data sheet ‘just so’!
The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4.
You will need to enable the macros for the resource to work properly.
There are 6 EXCEL sheets that provide a quick summary breakdown of a class. One is for KS3 classes, one for KS4 GCSE classes, one for KS4 BTEC Classes and three for performance management summary data sheets.
Simply:
• Export the data from a SIMS marksheet.
• Paste the data into the Data Dump sheet
• Your class analysis is displayed ready for printing / copy and pasting.
This is useful for lesson observations when you want to provide a context for the person observing but don’t want to spend an hour making your summary data sheet ‘just so’!
The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4.
You will need to enable the macros for the resource to work properly.
Something went wrong, please try again later.
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.
£5.00