馃攳
How to generate certificate from google forms||How to create e-certificate for webinar in Hindi - YouTube
Channel: Sheetomatic
[0]
[Music]
[5]
Hello Friends, My name is Shyam Kumar
[7]
And welcome you to my channel 'G-Suite Lab'
[9]
Today we are going to talk about how you can create E-Certificate through the google form
[15]
How to generate
[17]
And how can you send it to your participants or students through email automatically
[24]
So in today's video, we will understand how to set up it
[27]
And how you can create and use a template
[31]
We'll discuss all these in this video
[34]
As well, I'll tell you about the add-ons through which you can create it
[40]
So watch the video from start to end without fast-forwarding
[43]
And if you are new to my channel then please subscribe to my channel
[46]
And press the bell icon
[47]
Which will provide you real-time notification
[49]
And you'll be able to watch the video first
[51]
So let's start the video
[57]
First of all, let's talk about google form
[59]
You already know how to create a google form
[61]
If you don't know
[63]
So you can watch my google form tutorial by visiting my channel
[68]
And can learn about google form
[71]
From beginning to expert level
[73]
And today we are understanding how to generate the certificate through the google form by using one add-one
[80]
So, first of all, let's create a google form
[83]
There are different ways to create a google form
[86]
If you are a G-Suite user so you get an app launcher here
[91]
When you scroll down you will get google form
[94]
You can create from here
[96]
2nd way to create google form...Just type Form.new here
[101]
As soon as you will enter
[103]
A new form will get create here
[106]
Now you can start editing your form
[110]
Which has been created
[113]
So here we are taking 'Certificate form'
[118]
Okay, click here
[120]
As soon as you will click here
[122]
Its name will get automatically copy here
[126]
So our tittle is ready
[128]
After that decide who will fill this form that you are creating
[134]
Maybe your student
[136]
Or maybe your participants are going to fill it
[143]
so you will design the form accordingly
[146]
Or maybe you are going to fill the form by yourself
[149]
so that when participants will receive the certificate you have to design it again
[155]
But certify add-on only work when you automatically collect email addresses
[164]
so first of all what you have to do
[168]
Write full name
[175]
We have written 'Full Name' in the first question
[177]
So that the users fill the form, enter their full name and collect email address automatically
[184]
How
[185]
First of all, change the full name
[187]
Tick on 'short-answer' and 'required'
[190]
Click on settings
[191]
And tick 'Collect Email addresses'
[194]
Save
[195]
You can tick 'Limit to one response' if you want
[200]
so that one student can't able to fill it again
[204]
You can tick it here
[206]
Let's save
[210]
After that
[213]
Put at least any 1 question in 2nd place
[217]
Consider If you wanna create multiple questions
[222]
If you wanna issue a certificate on the basis of the same quiz
[228]
So you have to design questions accordingly
[230]
so here I am only adding 1 question
[234]
I am designing this form from the perspective
[237]
So that the participants who attend the webinar
[242]
They have to write their full name
[244]
It will collect the email address automatic
[245]
and have to submit only the details
[249]
Like 'Did you attend the webinar on this topic'
[258]
You can write whatever your topic is
[261]
'G-Suite product'
[264]
so this way you can write any question
[267]
Let me put yes and no
[270]
Because as soon as the participant will click yes the email will trigger on its basis
[274]
and the certificate will issue to the participant
[278]
Let also do it 'Required question'
[281]
After that
[282]
click again in settings
[284]
Go in 'quizzes'
[285]
And tap on 'Make Quiz'
[287]
After that
[288]
Save it
[291]
Here you have to select the answer key
[294]
And you have to decide the point as much as you want
[297]
Like here I am giving only 5 points
[299]
So here I write 5 points
[301]
and click on 'yes'
[303]
So that the participant will get 5 marks if he chooses 'yes'
[306]
5 points mean score will be 100% because there is only one question
[310]
so we can set it to 80% so that whenever the participant scores 80% he/she will get the certificate
[318]
click on done
[321]
Let's preview
[324]
So here you have to write the full name and select one question
[330]
Nothing much to write in it
[336]
so till now, we have created the google form
[340]
Let's move ahead and install the add-on
[343]
If you have already installed the add-on
[346]
So it is very good
[347]
Otherwise, click on this 3 dot
[350]
Select 'Add-ons'
[353]
Here you have to write 'Certify Em'
[357]
Select it
[359]
Click on it
[360]
And install it
[362]
I have already installed
[363]
So I don't have to do much
[365]
Let's close it
[367]
As soon as it gets installed
[369]
Reload once
[371]
So that your add-on will work well
[373]
Now click on this add-on icon
[376]
Select certify Em
[378]
And enable this add-on for this quiz
[383]
Click on get started
[385]
after taking some time a sidebar will open here
[389]
So the sidebar has been opened
[391]
First of all click on this 'Turn On'
[394]
So that It will start
[398]
You can see
[400]
'Please wait', after taking some time it will turn On
[405]
We will setup passing masks here
[408]
By default, it is at 80% if you wanna change it
[412]
So you can do
[414]
So I am keeping it at 80%
[416]
and 2nd is the template
[417]
If you have already created a template
[420]
Or you wanna pick its own default template
[424]
So you can do, different types of templates are available here
[428]
Let me show how templates look like
[435]
So default templates will look like this
[438]
If you think these are better
[442]
If you think you can move further with it
[444]
So you can choose anyone
[446]
And after selecting it
[450]
Here you'll choose it
[451]
So I wanna select my own custom template which I have created
[456]
So you can choose that too
[458]
Like I am clicking on 'Custom template'
[462]
If you have already created then you will select
[465]
Otherwise, go to slides
[469]
Open google slides
[471]
Open it from the apps launcher
[475]
Here you'll get to see different types of templates
[480]
You can use them
[481]
First of all take a blank
[483]
And select the theme you wanna use
[487]
Like this
[489]
I can use this we can change its layout
[491]
If you think you can make it like this
[496]
Now here you can do all the beautification, write up, changes
[505]
So this is a template
[507]
I have already made a design
[510]
Let's open it
[514]
And let me show you how it look like
[516]
Like this
[518]
I have already designed it
[520]
I have applied a little background shape on this frame
[525]
after that I put a logo
[527]
And written text, that's it
[530]
So you can also do same things
[532]
Now the next thing you have to do
[534]
First of all you have to see 'tag'
[536]
As soon as your template get ready
[541]
So here you have to use a tag
[545]
You can start the tag with Curly bracket
[548]
you'll write
[549]
'FULL NAME'
[552]
Okay
[555]
And close the curly bracket
[558]
If you wanna auto pick the date
[562]
So here you get different types of tags
[567]
You can use those tags here
[570]
Let me show you
[571]
These are some tags
[573]
Which you can use
[575]
Like 'Full Name' as I have used
[577]
'Tittle'
[578]
'Other Identifier'
[581]
'Other Identifier' means the next question except these 2 questions
[584]
Where email address pick automatically
[586]
After that, first you put 'First Name'
[589]
Next you have kept the tittle
[591]
except all these it will show 1,2,3,4,5,6
[595]
You can automatically pick the date
[599]
If you only wanna keep one date
[603]
So you can fix the date here as I have done
[607]
Or either you can see date's tag
[612]
Now we can use this template
[616]
click on 'Select a new file'
[623]
Let's select it
[625]
click on select
[626]
click on save changes
[629]
After that It will get save
[632]
The template we have just clicked has been selected here
[638]
Next you have to click on 'Advanced'
[641]
If you wanna see the sample before going to 'advanced'
[646]
So here you can click and see the sample
[649]
How the certificate will going to look
[653]
So first let's talk about 'Advanced' after that we will see sample and demo
[661]
If you wanna give a customize message
[664]
That whenever the participant submit the form he/she will get to see a message
[668]
So you can change it
[669]
Otherwise by default this messgae will go to the participants
[671]
Whenever the participant submit the form
[675]
After that, name of sender
[678]
By which name you wanna send the email
[680]
Like I wanna by the name 'G-Suite Lab'
[683]
And its subject line will be 'Ceritificate for participation
[693]
If you want you can write like this
[697]
After that, Content of the body
[700]
Any written note you wanna send on email so you can write here
[704]
LIke Congrats
[708]
You have been issued certificate of participation
[716]
so you can write this way if you want
[718]
You will write 'Regards' below it
[720]
So that your mail format look proper
[724]
G-Suite Lab
[727]
So this way you can properly draft your email
[732]
Okay
[733]
It has done
[735]
Let's save it
[737]
Now let receive an email for sample
[741]
And let's see how it look
[743]
Click on 'Email Sample'
[745]
After taking some time
[747]
One email will be send from here
[749]
And we will check on our email
[750]
As it is showing send notification
[755]
After that we will check the email
[756]
So one sample email has come
[758]
Now lets check
[761]
Go to gmail
[764]
It will send to that email address which you have setup
[770]
So it has send the sample
[773]
You can see it is looking proper
[775]
Everything is done
[777]
Okay
[778]
now lets move to form
[781]
Now lets see a demo will it send a certificate or not
[788]
if you wanna see its record
[789]
That how many responses has submitted till now
[793]
So you will click here
[794]
On 'Certificate Records'
[796]
And can check the number of submission
[800]
every submission will have a separate ID
[804]
You can find it later if you want
[807]
If any problem comes
[809]
So you can do its settings
[811]
we will see ahead
[814]
So now lets do a preview
[817]
Writer full name here
[818]
My name is Shyam Kumar
[821]
And tap on yes
[822]
It has automatically picked the email
[823]
Now lets submit
[825]
click on view score and you can see
[829]
5 out of 5 means you have scored 100%
[833]
Done
[834]
Now let see
[836]
It has received or not
[838]
Till now no data has come
[840]
So now data has come here
[842]
And email must also have been received
[845]
Let see
[848]
Refresh it so see
[851]
Open it
[853]
One email has come
[854]
Message is same 'Congrats you have been certificate of participation'
[860]
Open it and see
[862]
How good it is looking, everything is okay
[864]
No need to do anything
[866]
It is already in pdf format
[867]
If you wanna change its format in image
[870]
So the advanced function which I had told you
[873]
You can change it again
[875]
Click on advance
[877]
And select 'Image'
[880]
Or PDF
[885]
In the last you can see 'Send as PDF or Image'
[889]
Choose whatever you want
[892]
If you wanna send the image directly to google drive
[897]
So you can do here
[898]
It will automatically select their email
[901]
And will share this file
[905]
So that the participants can see whenever they want
[908]
1 response has received
[910]
we have seen its detail
[912]
So this your data has been completed
[915]
You can see ID, email address, full name is present
[918]
If you wanna do some changes later so you can do
[923]
So our work to send the certificate automatic has been done
[929]
And today we have understood how to setup it
[932]
So friends in today's video we have understood how to automate E-certificate
[938]
And can send automatically to your participants and students
[943]
As soon as your criteria match then
[950]
So how did you like the video definitely tell me
[953]
And if you have any suggestion related to it
[956]
That I could make this video more better so tell me
[960]
And if you have any problem
[962]
And you think it can be someone else problem so tell me in the comment section
[968]
I'll make a video and help you
[971]
Subscribe to my channel for upcoming videos and notifications
[977]
And press the bell icon
[978]
Which will provide you real time videos notifications
[980]
And you'll be able to watch the video first
[982]
So that's all in this video
[984]
See you in the next video with something new
[985]
till then bye-bye
Most Recent Videos:
You can go back to the homepage right here: Homepage