A clever Excel spreadsheet to track or measure your students' progress across the year. This is geared towards A-Level teachers but would work well for FE, HE and secondary teachers too. Using this will assist you in demonstrating 'Progress over Time' for any looming Ofsted inspection.<br /> The sheet caters for up to 25 students per class and tracks their progress in relation to their minimum target grade (MTG). Average grades update as you complete assessments.<br /> <br /> Using it is really easy! <br /> <br /> All light blue cells are for data/text entry, all dark blue cells are drop down boxes and everything else is protected from accidental clicks. At the bottom of the table is a box where you can amend the raw marks available for each type of assessment - just use 'quiz' (deep blue drop-down for assessment type) if you would prefer to see everything as a percentage of 100.<br /> <br /> The formulae are protected but I've included the unlock code (1234) for those of you who feel confident enough to personalise it further.

<p>WHAT IS IT?<br /> A mock election activity ideal for teaching how different electoral systems produce different results. This particular package allows your students to explore:</p> <ul> <li>First-Past-The-Post</li> <li>Supplementary Vote</li> <li>Alternative Vote</li> </ul> <p>All formulas on the Excel workbook are left unlocked for you to edit and develop as you see fit.</p> <p>HOW TO USE:</p> <ul> <li>Recommended to use 30+ ballot papers for each election</li> <li>Encourage learners to buy into the fiction of ‘Gourmet North’ scenario when casting their ballots</li> <li>Task learners with both conducting the vote and counting the results</li> <li>Record data on Excel sheet</li> <li>Learners should then be able to identify problems of complexity for AV voting and comparatively wasted votes for FPTP.</li> <li>Depending on complexity of count - activity should take between 60-90 minutes.</li> </ul>