As a teacher at a one-to-one school who uses G Suite and Canvas as an Learning Management System (LMS), few things are more annoying than the "You must request permission" screen.
This happens a lot for my teachers and I. You give an assignment description on Canvas, the student creates their work in a Google Doc or Slides presentation, they turn it in on Canvas, but they only share the local version from their computer, which is really just a fancy link.
Or, the student just gives you a share link, so you can see it, but only by loading the link in a new tab and not in the Spred Grader window. Annoying!
Google Classroom gets around this issue by creating a new folder for the assignment and putting all the created Docs there. It's great because you can see the work in progress, letter-by-letter as the student works. This isn't perfect either though, because Google Classroom is very limited in functionality compared to a full-featured LMS.
Often over the last few years I have said that eventually Google will spin-off that shared folder ability from Classroom so that you can use it elsewhere. Then, a few weeks ago, I got impatient and decided to stop waiting for Google and just make it myself.
And, Class Folder Creator was created as a Google Sheets Add-On. Now, simply by creating a by period list of student names and email addresses, you can create a folder for each of your students that they will create all their work in, and you will have access to all of it.
Here's how it works
- Click here to install Class Folder Creator (free).
- Click Setup Sheet from the Class Folder Creator Menu.
- Put your class name and largest class size.
- Input the list of student names and email addresses into the associated columns.
- Click "Create Folders" in the Class Folder Creator Menu .
Now, each of your students had a folder shared with them on Google Drive with Their Name - Class Name - Period #. You will have a folder for each period, and within that, each of that period's student folders.
When Johnny raises his hand in class and says they need help, you can go straight to his folder and pull up the document he is working on to start providing feedback and support.
When Johnny finishes his work, you will have access to it no matter which way he turns it in.
This was a labor of love, and like all Google Add-Ons is completely free. It is my first Google Add-On, so if you have any thoughts for improvement or comments, let me know!
You can find more details about the add-on at the add-on site.