After struggling to find a flexible seating plan that did what I needed it to do I created this. You can use 9-1 grades for the New GCSE.
Simply copy and paste the 'seat' in the top-left hand corner onto the spreadsheet to create the layout of your classroom.
On the data input sheet copy or type your data - it is currently set up to show name, target, current grade, PP, SEN, HP (health plan), and above, on or below target. All but target, current grade and AOB can be changed to show any other data without messing up the formatting. If you unhide a row on the seating plan you can also type text based information in the info section for example groups, access arrangements etc.
On the seating plan just change the top left number on each seat to match that student on the data sheet e.g. 1 will look up student 1, 2 will look up student 2. The information will be shown on the seating plan with colour coding for on, above, below target, SEN and PP.
It all uses very simple Excel formulas so easy to change to meet your needs.
Simply copy and paste the 'seat' in the top-left hand corner onto the spreadsheet to create the layout of your classroom.
On the data input sheet copy or type your data - it is currently set up to show name, target, current grade, PP, SEN, HP (health plan), and above, on or below target. All but target, current grade and AOB can be changed to show any other data without messing up the formatting. If you unhide a row on the seating plan you can also type text based information in the info section for example groups, access arrangements etc.
On the seating plan just change the top left number on each seat to match that student on the data sheet e.g. 1 will look up student 1, 2 will look up student 2. The information will be shown on the seating plan with colour coding for on, above, below target, SEN and PP.
It all uses very simple Excel formulas so easy to change to meet your needs.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
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.
£2.00