Hi everyone,
I’m a teacher who recently started using Google Classroom. I’ve been scanning my students’ assignments and making corrections. For each student, I end up with a PDF and a video of the corrections.
I’ve managed to organize all these files on Google Drive, named after each student. Now I want to share these files with the students individually.
I’ve looked online for a solution, but haven’t found anything that fits my needs. I know about AutoCrat, but it doesn’t quite work for what I’m trying to do.
I think I could create a Google Sheet with file addresses and student emails, then run a script to share the right documents with each student. I know some Python, but I’m not familiar with Google Scripts.
Can anyone help me figure out how to do this? I’d really appreciate any advice or guidance. Thanks!
As someone who’s worked extensively with Google Drive for document distribution, I can offer a solution that might work for you. Consider using Google Drive’s built-in ‘Share’ function combined with a simple Google Sheet.
Create a sheet with columns for student names, email addresses, and the corresponding file IDs from Drive. You can easily get file IDs from the URL when you open each document. Then, use Google Sheets’ IMPORTRANGE function to pull this data into a master sheet.
From there, you can use a simple Google Apps Script to loop through the rows and share each file with the corresponding student email. This method doesn’t require advanced coding skills and can be set up relatively quickly.
If you’re interested, I can provide more detailed steps on setting this up. It’s been a game-changer for my document distribution workflow.
As a fellow educator, I can relate to your situation. One approach that’s worked well for me is utilizing Google Drive’s folder structure in combination with Google Classroom. Here’s what I do:
- Create a main folder for the class
- Inside, make individual folders for each student
- Place their specific documents in their respective folders
- Use Google Classroom to create an assignment
- Attach the student’s folder to their individual assignment
This way, each student only sees their own documents when they open the assignment. It’s a bit time-consuming to set up initially, but it streamlines the process for future assignments and keeps everything organized. Plus, it integrates seamlessly with Google Classroom, which students are already familiar with.
Have you considered this method? It might be a good alternative to scripting if you’re not comfortable with Google Scripts yet.
hey there! i’ve faced similar issues. have u considered using the ‘share’ feature in drive? u can select multiple files, click ‘share’, and enter student emails individually. it takes a bit of time, but works for smaller classes. hope this helps!