CARA MEMBUAT GOOGLE FORMULIR LEWAT HP ANDROID | Google Form
Summary
TLDRThis video tutorial from Calon Ilmuwan ID provides a step-by-step guide on how to create a Google Form for student attendance using an Android device. The tutorial covers accessing Google Drive via a browser, switching to desktop mode, creating form fields for student names, class selections, and attendance status, and previewing the form. It also explains how to share the form link through WhatsApp and download responses in a CSV format, which can be converted to an Excel file. The video concludes with a reminder to like, subscribe, and enable notifications for future tutorials.
Takeaways
- đ The video is a tutorial on creating a Google Form for a student attendance list using an Android phone.
- đ It recommends using the Chrome browser for this process.
- đ The first step is to search for Google Drive in the browser and select the top result.
- đ It shows how to access previously created Google Forms and switch to a desktop view for easier editing.
- â The tutorial explains how to add a new Google Form by selecting the plus sign and choosing 'Google Form'.
- đ It details the process of filling in the form title and setting a time limit for the form's availability.
- đ€ The form includes fields for the student's name, class, and attendance status, with options for short answers and dropdown menus.
- đ The form also includes checkboxes for attendance status options like 'Present', 'Permission', and 'Sick'.
- đ The video demonstrates how to preview and share the Google Form via a link.
- đČ It explains how to fill out the form as a sample and send it to check if the submission is received.
- đ The tutorial concludes with instructions on how to download the form responses in a CSV format and convert it to an Excel file for easier analysis.
Q & A
What is the main topic of the video tutorial?
-The main topic of the video tutorial is how to create a Google Form on an Android phone to make a student attendance list.
Which browser application is recommended to use for this tutorial?
-The tutorial recommends using the Chrome browser application for creating the Google Form.
What should the user type in the search bar to access Google Drive?
-The user should type 'Google Drive' in the search bar to access it.
How does one access the desktop version of a website on a mobile device?
-The user can access the desktop version by clicking on the three dots in the top right corner and selecting 'Desktop site'.
What is the initial step to create a new Google Form?
-The initial step is to click the plus sign and select 'Google Form' to start creating a new form.
What title does the tutorial suggest for the Google Form?
-The tutorial suggests using 'Student Attendance List' as the title for the Google Form.
What type of question is used for the 'Name of the Student' field in the form?
-A short answer question type is used for the 'Name of the Student' field.
How can the user add a new question or field to the form?
-The user can add a new question or field by pressing the plus sign at the bottom left corner.
What options are provided for the 'Class' field in the form?
-The options provided for the 'Class' field are 'Class 10A', 'Class 10B', 'Class 10C', and so on.
How does the tutorial suggest organizing the 'Status' field in the form?
-The tutorial suggests using checkboxes for the 'Status' field with options like 'Present', 'Permission', and 'Sick'.
How can the user preview the Google Form before sharing it?
-The user can preview the Google Form by clicking the three dots in the top right corner and selecting 'Preview'.
What is the process for sharing the Google Form?
-The process for sharing involves clicking the airplane icon, then the chain link icon next to the envelope, and finally copying the shortened URL.
How can the user check if the responses have been submitted?
-The user can check the responses by opening the Google Form and looking for the number of respondents who have filled it out.
What format is the form's result initially saved in, and how can it be changed?
-The form's result is initially saved in CSV format. It can be changed to an Excel file by selecting 'Save as' and choosing 'xls'.
Outlines
đ Tutorial on Creating Google Forms on Android
This paragraph provides a step-by-step tutorial on how to create a Google Form using an Android device. The purpose is to make a student attendance list. The user is instructed to open the Chrome browser, search for Google Drive, and select the most relevant result. They are then guided to access a previously created Google Form, convert the desktop view to a mobile view for convenience, and start creating a new form by adding a title and setting a time limit. The tutorial continues with instructions on how to add various types of questions, such as short answer, dropdown menus, and checkboxes, and emphasizes the importance of marking questions as required. Finally, it explains how to preview, share, and send the form, as well as how to check responses and download the form results in a CSV format, which can be opened in Microsoft Excel.
đ Closing Remarks and Call to Action
The second paragraph concludes the video tutorial on creating Google Forms via Android. The speaker reminds viewers to like the video, subscribe to the channel, and enable notifications to stay updated with upcoming content. The closing is accompanied by a friendly sign-off, indicating the end of the tutorial and setting expectations for future videos.
Mindmap
Keywords
đĄGoogle Form
đĄAndroid
đĄAttendance List
đĄChrome
đĄGoogle Drive
đĄDropdown
đĄCheckbox
đĄPreview
đĄShare
đĄCSV
đĄExcel
Highlights
Introduction to creating a Google Form for student attendance via Android mobile phone.
Recommendation to use the Chrome browser for the process.
Instructions to search for Google Drive in the browser's search bar.
Selection of the top Google Drive result to access the service.
Accessing previously created Google Forms via the three-dot menu.
Switching the site to a desktop view for easier form creation.
Initiating a new Google Form by selecting the plus sign.
Filling in the form title as 'Student Attendance List'.
Setting a time limit for the form from 8 to 9 o'clock.
Adding a 'Name of Student' field with a short answer option.
Making the 'Name of Student' field mandatory to fill out.
Creating a new 'Class' dropdown field with predefined class options.
Including options like 'Present', 'Permission', and 'Sick' in a checkbox field for attendance status.
Mandatory status activation for the attendance status field.
Reviewing the Google Form before finalizing it.
Previewing the form to ensure it meets the requirements.
Sharing the Google Form link through a messaging app like WhatsApp.
Demonstration of filling out the form to show the submission process.
Checking the form responses to verify if they have been submitted.
Downloading the form responses in a CSV format for organization.
Converting the CSV file to an Excel format for easier data handling.
Encouragement to like, subscribe, and enable notifications for future videos.
Transcripts
Halo temen-temen kembali lagi di
channelnya calon ilmuwan ID pada
kesempatan video kali ini Mimin bakalan
berbagi video tutorial mengenai cara
membuat Google formulir melalui HP
Android Nah jadi melalui Google form ini
Kita akan membuat daftar hadir siswa ya
Sob untuk yang pertama kita bisa masuk
ke aplikasi browser yang ada pada HP
kalian di sini saya sarankan menggunakan
aplikasi Chrome ya Sob
Kemudian pada Kolom pencarian kalian
ketik Google Drive
untuk bagian ini kita pilih yang paling
atas sendiri ya Sob
Nah maka di sini akan muncul dokumen
Google form yang pernah kita buat
berikutnya kalian pilih titik tiga di
pojok kanan atas dan pada situs desktop
ini bisa kita klik sob
Nah setelah menjadi situs desktop
silahkan kalian perbesar dulu layarnya
dan kemudian kita pilih Tanda plus
oke lalu kita pilih Google formulir ya
Sob
[Musik]
Nah maka kita akan diarahkan ke halaman
awal pembuatan Google form untuk
mempermudah kita bisa mengembalikan
situs desktopnya menjadi tampilan mobile
ya Sob langkah selanjutnya kita bisa
mulai dengan mengisi judulnya terlebih
dahulu untuk judul akan saya tulis
dengan daftar hadir siswa
Oke Kemudian untuk kolom di bawahnya
bisa kita isi dengan batas waktu pukul 8
sampai 9
Nah selanjutnya kalian bisa mengklik
pada bagian pertanyaan tanpa judul
kemudian di sini kalian bisa mengetikkan
dengan nama siswa
lalu untuk opsi pilihannya kita Biarkan
saja dengan jawaban singkat berikutnya
jangan lupa pada kolom wajib diisi ini
bisa kalian aktifkan ya Sob selanjutnya
untuk membuat kolom baru kita bisa
menekan Tanda plus di pojok kiri bawah
nah untuk kolom yang kedua kita isikan
dengan kelas ya Sob
Kemudian untuk opsi pilihannya kita
pilih yang dropdown
berikutnya pada opsi 1 kita bisa isi
dengan kelas 10A kemudian opsi 2 kita
isi dengan 10 B
opsi 3 isi dengan 10 c dan seterusnya ya
Sob
jika sudah pada kolom wajib diisi kita
aktifkan juga ya Sob
Oke berikutnya kita buat lagi kolom baru
dengan menekan Tanda plus
Nah untuk kolom yang ini bisa kita tulis
dengan keterangan
lalu untuk opsi pilihannya kita bisa
memakai yang kotak centang ini ya Sob
kemudian di bagian opsi pertama kita isi
dengan hadir lalu untuk opsi kedua kita
isi dengan izin dan opsi yang ketiga
bisa kita isi dengan sakit
Oke pada bagian wajib diisi kita
aktifkan ya
nah jika sudah sekarang kita tinjau dulu
Google formnya
silahkan kalian tekan titik tiga di
pojok kanan atas kemudian pilih
pratinjau
Nah jadi kira-kira nanti bakalan seperti
ini ya Sob hasil Google formnya
jika dirasa sudah sesuai sekarang kita
tekan tombol kembali
berikutnya akan kita bagikan untuk link
Google formnya ini Sob Caranya tinggal
kalian tekan tanda bergambar pesawat
kertas kemudian kalian pilih tombol
rantai di sebelah gambar amplop ini ya
Sob dan bisa kalian tekan persingkat url
Nah baru setelah itu bisa langsung
kalian tekan Salin ya Sob berikutnya
akan saya bagikan link Google formnya
melalui WhatsApp
Oke kita buka linknya ya Sob
Nah sekarang akan coba saya isi font
daftar hadir siswa ini sob
Oke selanjutnya kita tekan kirim
dan ini berarti tandanya sudah terkirim
ya Sob oke lalu kita cek Apakah
tanggapannya sudah masuk atau belum
dan di sini satu responden telah mengisi
Google formulir kita ya Sob berikutnya
apabila ingin mengunduh hasil formnya
kalian bisa menekan tombol titik tiga
Lalu pilih download jawaban kemudian
kita buka
Nah jadi untuk hasil formnya ini
langsung tersusun rapi di dalam dokumen
akan tetapi dokumen ini masih dalam
bentuk format csv csv ini merupakan
salah satu format dalam Microsoft Excel
jadi di sini kamu bisa mengubah
formatnya dengan menekan tombol save as
lalu pilih xls agar menjadi file Excel
yang standar ya Sob
Oke Mungkin itu saja video tutorial
mengenai cara membuat Google formulir
melalui Android jika berkenan jangan
lupa untuk like video ini dan subscribe
serta Nyalakan loncengnya agar tidak
ketinggalan video-video berikutnya Oke
see you on the next video
[Musik]
Voir Plus de Vidéos Connexes
5.0 / 5 (0 votes)