<p>Mailmerge document linked to spreadsheet with bespoke ‘close the gap’ work for OCR A biology PAGs.</p>
<p>Massively speeds up, simplifies and enhances getting quality feedback and CTG work to students</p>
<p>‘Auto CTG’ feedback sheets for all yr12 OCR A Biology units.</p>
<p>Students fill in their scores for tests , input the grade boundaries of your choosing.<br />
The sheet will automatically generate ‘close the gap’ CTG work for scores less than 60% for a particular question.</p>
<p>Sheets are protected to prevent tampering (psswd ‘biology’ )<br />
Biomolecules is such a large section, split into ‘Biomolecules’, ‘Proteins and Enzymes’ and ‘Nucleic Acids’ for assessment</p>
<p>Tests these sheets correspond to are available separately on my Author area</p>
<p>Students enter score for questions and grade boundaries of your choice. The sheet will generate bespoke ‘close the gap’ tasks (CTG) for any questions in which attainment is below 60%.</p>
<p>If the CTG tasks are not to your liking they can be altered (unhide appropriate sheet and unlock with password ‘biology’ )</p>
<p>spreadsheet for managing KS5 assessment analysis for mocks and End of Topic Test data</p>
<p>setup for OCR Biology A - but easily modified for other subjects/exam boards</p>
<ul>
<li>supports up to 50 students</li>
<li>allows data entry for up to 4 classes</li>
<li>dynamically updates, as you add data, analysis and progress updates</li>
<li>end of topic test grade and progress analysis for all OCR biology A units</li>
<li>mock examination analysis</li>
<li>ability to include resit data for year 12 and year 13 mock examination</li>
<li>league tables for cohort and class analysis</li>
<li>enquiry page for specific student analysis</li>
<li>generates support group lists based on student progress</li>
<li>provides Cohort analysis for individual classes to compare %A*–>B,%A*–>C,%A*–E plus target analysis for individual classes and cohort</li>
<li>Cohort analysis can be switched between 3 modes: EOTT only, mock only or EOTT/mock combination</li>
<li>mail merge document included for bespoke reporting to individual students</li>
</ul>
This activity is designed to help deliver OCR A Biology section 6.1.1 (year 13). It simulates Eukaryotic and prokaryotic gene regulation using a simplified transcription and translation model. It can also be used to review transcription and translation and to study the effect of mutation. A structured deep marking task is included.
