Univeristy lecturers sometimes need to create a Google doc for every student in a unit containing information or sections for the student to complete, and share each document with a specific student. A hyperlinked list of the documents is then added to the LMS, and each student can access only their own document and add to it during the semester.
It can be a slow process to create these documents one by one, especially for units with lots of students.
I made a Google sheet that automates the process. Give it a list of names and email addresses, and it produces an individually named and shared Google doc for each student, populated with a template of your design, and outputs a list of hyperlinks with the link text as the student’s name. This list can be copied and pasted straight into your LMS.
It can create hundreds of bespoke Google docs in one click. I hope this can save you some time!
Instructions and link to the GSheet are in the video below:
