Search This Blog

Monday, September 2, 2019


Over the years I've spent tons of time making seating charts.  I believing in changing seats very frequently and rotating students around the section so no one is ever always in the back.  Every 2 weeks I make brand new charts for each of my classes.  As my program has grown, making new charts is taking more and more time.  I still want to frequently change seating, but I need it to be easier and faster.


I just created a color coded seating chart for each class.  I colored seats in each section a different color, then numbered the seats.

To easily change the seating, I created an Excel spreadsheet with the names of the students in each section.

I then created a formula to randomly assign a number to each student.  =RAND()

I then sort the sheet by columns - and instantly have a randomized seating.  Students just have to look at the chart and sit in the seat that corresponds to their number.

It's super fast and easy to create a new order...just drag the formula column downwards and it will replace all the numbers.  Instead of re-writing seating charts, I can use excel to get a new order instantly.  I project the list on my screen and students quickly find their new seats.  I might just change seating more often!

No comments:

Post a Comment