Add A Slide per Student in Google Slides
One of my favorite activities is collaborative Google Slides. That is all students in the class on the SAME Google Slides. I usually recommend to keep it simple. Create BLANK Google Slides and share it with edit access with the class. Students add their own slide and put their name in the speaker notes. If students are adding more than one slide it can be helpful to set up the Slides in advance with each student’s name on a slide. Each student’s slides comes after their name slide. I coded a template to make this easier.
- Make a copy of the spreadsheet template.
- Use the Add-on menu to choose “Roster to Slides.”
- Choose setup.
- Authorize the script.
Click on Advanced and then below that choose “Proceed to Roster to Slides (unsafe).”
Note: It is safe, I personally coded the Add-on. It collects no data and authorizes yourself access to your Slides.
- Paste your class roster into column A.
- Use the Add-on menu to choose “Roster to Slides” and choosing “Create Slides.”
- Open the Slides.
From the Add-on menu choose “Roster to Slides” and select “Setup.” This will add column headers to the spreadsheet. This is not required but can be helpful.
Google has NOT reviewed the script I coded. They want to make sure you know that they have no responsibility for my code. You will get a screen telling you the app is not safe. However, this only means that Google cannot verify the safety. I personally coded this script. I do not collect any data, I do not have any access to any of your files. The authorization is to yourself to give yourself access to your own files.View screenshots of authorization
Do not click on “Back to safety” but rather click on the word “Advanced.”
Then more warning will expand out to let you know that Google has not reviewed this Apps Script. At the bottom click on “Go to Roster to Slides (unsafe).”
The app authorization is for YOURSELF to allow you to use SlidesApp and SpreadsheetApp to access the two files in this project.
Paste Your Roster
Technically you only need names in column A. If when you copy and paste your roster it puts first and last name in separate columns my script automatically concatenates (puts together) the names when creating slides. Currently, Email Address does nothing. I have this there in case you copied and pasted from the Google Classroom roster so that everything matches up.
Go back to the Add-on menu and choose to “Create Slides.”
A pop up will let you know the link to the Google Slides that were created. The Slides can also be located in Google Drive. Make sure you click OK. The slides are not created until you click OK.
A green slide is created per student. Additionally, a blank slide follows each student’s slide to provide a space for their work. Students can add additional slides after the name as needed.
13 thoughts on “Google Slides: Add Your Roster”
After I copy the template, I don’t see Roster to Slides under the Add-ons menu.
Wait a minute. It can take a few seconds for the code to load.
We waited quite a bit of time and do not see the drop down “Roster to Slides” on Add-on menu
It is definitely there. You may need to do it again. It’s rare but sometimes it doesn’t load. Internet speed seems to be part of the reason.
Awesome Add-on. Thank you for being so generous.
This is a super cool way to prep a slide for students to input their thoughts!!
Nice coding skills as well!
THIS is AWESOME!
Oh darn it; I thought you worked out a script that would only allow each student to only work on THOSE slides, not mess with other student’s slides…
Do the collaborative slides a lot and get past the kids editing each others slides.
Hi Alice, I love your scripts! So helpful to streamline teaching.
Are you able to help with this? I have logged out of all my Google Accounts then logged back into gmail with my teacher account. It shows that account as the default. But when I click on your template link, it opens in my personal account. Any thoughts on how I can make it default to my teacher account?
Do NOT let multiple accounts show when you click on your picture for exactly this reason. Instead manage through Chrome.
You must log in to post a comment.