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.

Get effective EdTech strategies from Alice Keeler to build a more student centered classroom. Includes unique resources and templates.

Recent Teacher Tech Blog Posts

💥 FREE OTIS WORKSHOP

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

Join Alice Keeler for this session for teaching with AI

Imagine having a team of teaching assistants who already know your syllabus and exactly how you like to give feedback. Join Google Certified Innovator Alice Keeler to learn how to use Google Gems to build a powerful collection of custom AI tools. We will explore how to engineer specific instructions so you can create a Grading Assistant or a Classroom Policy Manager that works for you. You will also learn how to leverage Gems shared by other educators to instantly expand your toolkit. This session is about super-powering your teaching by automating the routine tasks so you can focus on the students.

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