Hi Shawn,
It sounds like you wanted students to use your Google file (budget spreadsheet in this case) as a template file that they would start with to make their own. Here's a little trick I use to make this as seamless as possible.
Teacher Setup
1) Prepare Template File- Make your Google file (view only, anyone with link can view) and change the end of the URL. Remove edit and everything after it and replace it with copy.
For example:
-From: https://docs.google.com/spreadsheets/d/1tO8F3H7wp65DYpKP3k1N6bCfAfY5shygLX0M8KVkFgk/edit#gid=0
-To: https://docs.google.com/spreadsheets/d/1tO8F3H7wp65DYpKP3k1N6bCfAfY5shygLX0M8KVkFgk/copy
2) Post Link to Template File- In your Assignment's description highlight the text that will be a hyperlink for your students, click on the link icon in the toolbar and paste the URL to your Google file (with copy at the end of it) in the text box and click the "Insert Link" button.
3) Select Online Submission Options- I recommend enabling only "Website URL" and NOT using the built-in Google Drive submission option that you would get by selecting "File Uploads". By doing this, it allows me to view the real Google Doc/Sheet/Presentation/Drawing in SpeedGrader and I can use the native Google commenting tools to provide feedback as well as all the Canvas tools like media comments, and rubrics. Please trust me on this, you've gotta try it! Once you do you won't go back. Using the built in Google Doc connect turns the Google Docs into docx files, presentations into pptx files and spreadsheets into .xlsx files. Sometimes students experience a blank screen while Canvas retrieves and converts the Google Docs and students don't know what to do when this happens. I've also noticed it doesn't work so well for spreadsheets. It usually takes a long time for them to load in SpeedGrader and often applies annoying pagination and butchers the formatting. Not to mention, all the collaborative "Googleness" is stripped from the file. 'Nough said :smileymischief:
The Student Experience
1) Read & Get- When students go to the assignment they read the instructions and click on the link to your Google file. When they do, they will be prompted to create a new copy of the file from yours. This file will be theirs to edit and they will not be changing your master sheet/document when they work on their copies.
2) Submit it- The first time I have students do this, I walk them through it. After that they are usually pros at it. I made a slide guide to share with the Canvas Community and you all are welcome to put a link to it in your assignment instructions. See: How to Submit Your Google Drive Files in Canvas (for students)
This discussion post is outdated and has been archived. Please use the Community question forums and official documentation for the most current and accurate information.