Creating Class Folders in Google Drive

Another quick tools post. I came across this great script from Bjorn Behrendt that automatically creates folders in Google Drive from a Google Spreadsheet with a list of student names and gmails and the classes they're in. In the teacher's Drive it creates a folder for each class (separated by period if you have multiple sections of the same prep) with three types of folders.

1. There's an "edit" folder that all the students in that class and the teacher have edit rights to.
   
2. There's a "view" folders that the teacher has edit rights to but the students just have view rights to.
   
3. There's individual "dropbox" folders that each individual student and the teacher have edit rights to (the teacher sees all the dropbox folders, each student just sees their own).

In each students' Drive they'll see three folders - the edit folder, the view folder, and their individual dropbox folder.

While you can do this manually, it's really nice for teachers with several hundred students to automatically create and organize these folders from a spreadsheet that can be easily populated by exporting from your student information system (Infinite Campus for us). Here are the instructions I shared with my teachers in case any of you find it helpful.