A level biology assessment tracker OCR

spreadsheet for managing KS5 assessment analysis for mocks and End of Topic Test data

setup for OCR Biology A - but easily modified for other subjects/exam boards

• supports up to 50 students
• allows data entry for up to 4 classes
• dynamically updates, as you add data, analysis and progress updates
• end of topic test grade and progress analysis for all OCR biology A units
• mock examination analysis
• ability to include resit data for year 12 and year 13 mock examination
• league tables for cohort and class analysis
• enquiry page for specific student analysis
• generates support group lists based on student progress
• provides Cohort analysis for individual classes to compare %A*–>B,%A*–>C,%A*–E plus target analysis for individual classes and cohort
• Cohort analysis can be switched between 3 modes: EOTT only, mock only or EOTT/mock combination
• mail merge document included for bespoke reporting to individual students