GCSE Separate Science Past Paper Tracker Spreadsheet

I’ve been using the ‘past paper’ method for years with my students.
Students complete a past paper, mark and analyse their results using MARCKS and then write SMART targets to plan targeted revision sessions. If they don’t comfortably acheive their target grade in the first attempt, they are encouraged to repeat the past paper 2-3 days later (after having completed targeted revision).

I’ve found that giving students access to this editable spreadsheet has massively increased motivation to actually use the method properly and stick with it.

Students can select from drop down boxes to input their current grade for Biology, Chemistry & Physics. Then they input their target grade. Everytime they complete a past paper, they can input their mark, percentage & grade. The spreadsheet has space for 3 attempts at each paper. Finally at the end of each row, students can select whether they have achieved their target grade for that past paper or not.

This is designed for students studying separate sciences, a spreadsheet for trilogy students will be made available ASAP.

• If you need to clear the text from a cell with a drop down box - DO NOT DELETE IT as this will delete the formatting for the cell. Just select ‘none’ from the drop down box.
• Available as .numbers or .xlsx download.
• This spreadsheet does NOT seem to work on iPads I’m afraid, but I have tested it on an iMac, macbook & a laptop running excel and the formatting appears to work properly.