Hopefully a lot of what I post on here can help to give a creative edge to colleagues' lessons.Yet we all know that, however many hoops we jump through to make lessons more meaningful and interesting, sometimes you have to wield that stick!
I made this Excel sheet for anyone who can use it. I have used French but you can change the column headings as you wish.
It's a basic traffic light system for classroom management. You copy/paste your list of pupils in the first column, and by default everyone begins the lesson on green. I have included a couple of macros (keyboard shortcuts) to enable you to quickly change the colour of the boxes in the second column to amber, warning. (ctrl a) and in the third column to red, trouble (!) (ctrl r). You can delete any colour assigned to a box by using ctrl e (effacer)
You will have to allow the macros when you first open the sheet.
If you want to copy this sheet to add other classes press ctrl and j. You should see another identical sheet added onto the tabs at the bottom. Rename these by right clicking the tab and selecting 'Rename'.
Download PUPIL CHECK CHART Excel
I have also created a similar idea in a smart notebook file
Type in the pupil names in the columns. The amber and red boxes at the top are on infinite cloner so that you can simply pull them down into the boxes to copy them when at the whiteboard. The numbers at the top are links to the other pages in the workbook.
Each of these pages has an arrow at the top left linked back to the pupil checklist on the front page.
Download Pupil Check Chart Notebook
Hope this helps!
