Google Sheets: Managing Students Names for Group Work

Google Sheets: Managing Students Names for Group Work

group spreadsheets

I use spreadsheets to organize group projects. I have created a step by step tutorial for how take a list of students and put them into groups. Go through each tab for each step. Double click on cells to view the formulas.

The Tutorial

Click Here to create a copy of the tutorial.

Start with a List of Names

Screen Shot 2015-03-06 at 3.38.21 PM

 

Joined List of Names

Screen Shot 2015-03-06 at 3.38.30 PM

Leave a Comment

© 2026 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday April 15th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for teaching with AI

Unlock a smarter way to manage your curriculum by turning your own teaching materials into a personalized AI assistant with NotebookLM. This session explores how to transform static documents into interactive study guides and audio overviews that are tailored strictly to your specific content. You will discover how this versatile note-taking tool can streamline your prep time and help you organize complex resources with ease. Join us to see how NotebookLM can act as a powerful, free partner in your K-12 classroom.

Exit this pop up by pressing escape or clicking anywhere off the pop up.