Cara Membuat Surat Keterangan Kelulusan Online dengan Google Form

How to Make a Certificate of Graduation Online To make an online graduation announcement, we can use Google Form to distribute the Certificate of Graduation to each student. Later, students only need to fill out a form that only asks for NIS, NISN and E-Mail. After that, the SKL will automatically be sent to the student concerned via the registered email account. In general, the steps to make a Certificate of Graduation (SKL) online are as follows: 1. Open Google Drive, then Login, and create a Folder, for example "SKL Online". 2. Prepare the SKL Format in Word (docx), then upload it to Google Drive, then save it as a Google Document 3. Prepare Student Graduation Data in Excel (xlsx) 4. Create a Form in Google Form, then display the Response/Answer table 5. Copy Data from the Student Graduation Data table to the Google Form Response Table (created on a New Sheet) 6. Create a formula for the data that will be displayed on the SKL (created on the Response Sheet) 7. Use the AutoCrat Add-On to connect the SKL Format with the Google Form Response Table For practice materials, please download the completeness at the following link Example of SKL Format: http://bit.ly/F-SKL Example of Graduation Data (consists of only 10 data) http://bit.ly/D-Kelulusan Formula for Creating a Database (don't forget to adjust the sheet name and number of data) http://bit.ly/RumusDatabase Hopefully useful. Don't forget to subscribe to the Pusat Cara Cara channel Facebook Fans Page:   / pusatcaracara   Suggestions & criticisms please contact: [email protected] Thank you. #computertutorial #computerlearning #pusatcaracara