How Do I Upload a Certificate Into an Assignment

In this tutorial you will learn how to auto-generate individualized certificates using Canvas, Google Forms, and Google Sheets.

1. Create a new folder in Google Drive

This new binder will hold everything y'all are most to create besides as the generated certificates.

ii. Create your certificate

You do not demand to "Request edit access" to apply either template, please but re-create the template to your own Google Drive.

You can re-create one of these certificates:

• Public Certificate Template (Open for public utilise)
• HSU Certificate Template (This link will just work if yous sign-in with HSU credentials.)

-OR- Create your own certificate using Google Docs.

Brand sure your new Certificate is in the new folder.

iii. Edit your document

In Google Docs, edit your document to fit your needs. Use the <<tag>> format for areas that volition exist car-completed.

These tags will tell the despot addon where to place the form data in the certificate.

Changes are automatically saved in Google Docs, and so click the three confined in the tiptop left corner to return to your Documents.

4. Create your form

Return to the Google Drive folder you created and create a new Google Form.

ane) Select New

two) Select the More than option from the driblet downwards menu.

3) Select Google Forms

five. Edit your form

Give your form a meaningful name and description and so use the interface to add questions.

You will most probable use the short answer question type.

Make sure to toggle the questions to be Required for any questions that are mandatory or will be used in the creation of the certificate.

6. Modify your grade'south settings

1. Click on Send in the upper correct corner.
2. So cheque Automatically collect respondent'due south Humboldt Country Academy e-mail address.
3. Click X to close.

7. Modify your form's responses settings

1.    Click on the Responses tab.

2.    And then click on the greenish push button to 'Create spreadsheet'.

3.   Select the Create a new spreadsheet option.

4.   Edit the proper name if you'd like, then click Create.

8. Set up your response sheet to utilize the autoCrat addon

The newly created sheet should have automatically opened in a new tab. If not, open it from the Google Bulldoze folder that we created at the outset of the tutorial.

1. Click on Add-ons.

2. Click Get add-ons...

In the search bar, type autocrat and striking the Enter cardinal, and so click on the + FREE button.

i. If necessary, log in with your HSU Google business relationship.

two. Click Let to grant autoCrat necessary privileges.

nine. Create a new merge job in autocrat

After installing autocrat, the following window should be displayed. Click New Task to create a new merge chore.

If y'all don't see the pop-upwards window above, click on 'Add together-ons' > 'autoCrat' > 'Open'.

This is how yous can go to the autocrat menu in the future as well.

1. Proper noun your new job - maybe with the name of the form or class.

2. Click Adjacent.

3. Click on From Bulldoze to select the document template you created earlier.

iv. Cull your certificate template.

v. Click Select.

6. Now click Side by side to continue with the selected template.

You volition now match the tags in your certificate to columns in your spreadsheet.

Utilize the dropdown windows to select the proper column for each tag, then click Next.

1. Make up one's mind how you would like to proper noun the files (certificates) that are generated past this merge job.

Click on the blue bar with an arrow on the left to see a list of available tags, and correct-click them to copy them.

Y'all can paste these tags in the File Name textbox to create individualized certificate names.

e.g. " <<Full Name>> Document - <<Class Proper name>> "

2. And then in the Type dropdown, select PDF.

3. For the Output equally field, select Multiple output mode so each person gets their own document, rather than a single document with many pages that only y'all get.

four. Finally, click Next to continue.

1. Select your folder.

If your folder is not displayed, click the + Choose folder button.

2. Click Next.

No action is required on the side by side ii screens (Steps 6 and 7) so simply click Next twice.

You volition now decide how the certificates volition be sent to recepients.

The following settings are recommended:

• Share doc? - Yes
• Share dr. as - PDF
• Allow collaborators to re-share - No
• Send from generic no-respond address - No

• To: Use the blue bar once again to copy the e-mail tag and paste it here
• Cc: None
• Bcc: None
• Reply To: Your email (or alternating desired electronic mail) address
• Type in Subject: Yous tin can employ tags here if you would like to include individualized information in the electronic mail subject field line
• Blazon a message: You can employ tags hither if you would like to include individualized information in the email body

When yous are finished, click Side by side.

1. Select Yes for Run on form trigger if you would like certificates to exist generated automatically on course submission.

2. Select Yes for Run on time trigger if you would similar certificates to be generated every:

one hour, 2 hours, iii hours, iv hours, six hours, twelve hours, or 20-four hours

In either case you will be asked to enable triggers, click Aye to confirm these changes.

iii. And so click SAVE to finish creating your merge job.

10. Add your Course to Canvass

At this indicate, you lot have finished setting upwardly the automation process and just demand to add your Google Class to a Sheet page.

Kickoff, allow'due south get the embed link for your Form.

Get back to your folder and open up your Form.

i.  Click SEND.

2. Click on the embed tab denoted past the '< >' symbol.

3. Click Copy to copy the embed link to your clipboard.

4. Click X.

Now, let's embed this course in Canvass.

Navigate to your Canvas course folio and decide where you lot would like students to access this form.

For example, you could add a certificate at the end of each module or at the terminate of the course.

In any instance, you will be embedding the Google Form in a Sail content folio.

1. Inside the page edit screen, click on HTML Editor.

ii. Paste the embed link you copied before.

3. Then Relieve or Salve and publish your page.

Your Form should now be embedded in your page!

11. Test your Grade

You can make full out the form and submit it to test your automation procedure.

Immediately after submitting the form, you should come across a new row in the Responses spreadsheet.

Yous should receive an email containing a PDF document shortly subsequently submitting the form.

If you lot chose to trigger the merge chore on a timed schedule, this will dictate when the certificate volition be emailed.

12. Example Document

christoffersocort1957.blogspot.com

Source: https://atguides.humboldt.edu/m/google/l/792830-how-do-i-use-google-forms-and-sheets-to-automatically-generate-custom-certificates

Share this post