CaldwellSchool District

Skip to main content

Assigning Students to Tabs in Google Sheets

Alice Keeler is a whiz at programming Google Sheets to do magical things!  Here are two different Google Sheet programs that she has written that allow you to type in (or copy & paste from Skyward) a list of your class rosters.  With one touch of a button, her programs will create a Google Sheet that contains one tab assigned to each student in your roster.  One of her programs even allows you to create a template for a graphic organizer or a gallery walk or a peer feedback activity and the magic button will create a copy of that template on a separate tab assigned to each kid on your roster.  You could even use these Google Sheets programs to create a classroom rubric that allowed you to give feedback to students on their own tab in your sheet for grading purposes!
Published