Some people are more comfortable using YouTube videos for this tutorial, but if you are like me, I prefer reading instructions. So, this post is A Tutorial on How to Generate E-Certificates after Accomplishing the Google Form.
Honestly, I am always amazed that after accomplishing evaluation sheets using Google Forms, I can instantly get my e-certificates for the webinars I attended.
And, when we were holding our webinars, I tried learning how to do it, and let me share with you the easy steps I followed on How to Generate E-Certificates.
Step 1. Create your E-Certificate Layout
You may use Canva to create the layout of your certificate. You should finalize your design and proceed to Step 2.
Step 2. Upload your E-Certificate design to Google Slides.
Make sure to fix the size of your layout to the size of the slide. This will be the final e-certificate layout, so consider that in adjusting the borders.
Step 3. Put the << TAGS >>
Here is an example of how I did it:
Add TEXT BOX and stretch the length of the box up to the end of the line below the tags. These tags generate the name, and there are participants with long names.
Previously, I experienced requests from the participants to re-generating their e-certs because their names have overlapping characters or the fonts are too small. These << >> in the image above are examples of how the text for the names will be written and how the textbox will determine the length it can accommodate. Just do the estimates.
Step 4. Create your Google Form
* Make sure you use the same Google Account for your Google Slides and Forms. If you’re not, merging cannot happen.
In your Google Form, set a Short Answer Box where they will type in their names (the texts appearing in the e-certificate). Moreover, if you want an automated sending of e-certs to their emails, ensure that the Google Form will be COLLECTING email addresses in the settings.
STEP 5. Set up Autocrat for merging of forms.
In your Google Form, click the RESPONSES and then generate the EXCEL SHEET for the RESPONSES.
Click on EXTENSIONS, and in the Drop down; you’ll see AUTOCRAT; hover your mouse and click LAUNCH. Name your MERGE JOB:
Drag DOWN.
By the way, this blue arrow on the left is where you can copy the tags representing the columns in the RESPONSES sheet. So, when they accomplish the Google Form with their email address, this << email address >> column is generated.
In continuation…
Click NEXT.
Step 6. Perform a TEST.
If it’s successfully done, then CONGRATULATIONS, you now know How to Generate E-Certificates after Accomplishing the Google Form.
Leave a Reply