CARA MUDAH MEMBUAT ABSEN QR CODE
Summary
TLDRIn this tutorial, viewers learn how to create an attendance list using QR codes that automatically update a Google Spreadsheet. The process begins with setting up a new Google Spreadsheet and naming it. Next, QR codes are generated for each participant's name using QR Explorer. The tutorial then guides through installing the 'Scan' app from the Play Store, configuring it to connect with Google Drive, and setting up a form for scanning. The form collects data such as names, dates, and times, which sync with the spreadsheet upon scanning a QR code. The video demonstrates a practical and efficient method for managing attendance, making it simple and user-friendly.
Takeaways
- 😀 The video provides a tutorial on creating an attendance list using QR codes.
- 📂 It starts by creating a new folder and Google Spreadsheet in Google Drive.
- 📝 The spreadsheet is named and structured with columns for names and other data.
- 🔗 A new set is created for the names that will be used to generate QR codes.
- 👤 Names are copied from the spreadsheet to be used for QR code generation.
- 📱 QR codes are generated using 'QR Explorer' and can be downloaded and printed.
- 📲 The tutorial then moves to a smartphone to install and use a scanning app from the Playstore.
- 🔍 The app 'Scan' is used to scan the QR codes, which are linked to a Google Drive account.
- 📋 A form is created in Google Forms to collect scanned data, including mandatory fields for barcode and time.
- ⏰ The form automatically adjusts the date and time based on the smartphone's settings when scanning.
- 💾 Once scanned, the data is automatically entered into the Google Spreadsheet without needing to open the sheet manually.
Q & A
What is the main purpose of the video?
-The main purpose of the video is to demonstrate how to create an attendance list using QR codes that automatically update a Google Spreadsheet when scanned.
How does the QR code system work for attendance tracking?
-The QR code system works by scanning QR codes with a smartphone application, which then sends the scanned data to a Google Spreadsheet for attendance tracking.
What application is recommended for scanning QR codes in the video?
-The video recommends using an application named 'Scan' from the Playstore for scanning QR codes.
What is the first step in setting up the attendance system as described in the video?
-The first step is to open Google Drive and create a new folder, then add a Google Spreadsheet and name it, for example, 'QR Code Kehadiran'.
How are the names of attendees organized in the Google Spreadsheet?
-The attendees' names are organized in a new sheet within the Google Spreadsheet, where data such as names, QR codes, and other relevant information will be entered.
What tool is used to generate QR codes from the names listed in the spreadsheet?
-QR Explorer is used to generate QR codes from the names listed in the spreadsheet.
How can the generated QR codes be downloaded and printed for scanning purposes?
-After generating the QR codes using QR Explorer, they can be downloaded and printed for scanning purposes during the attendance process.
What settings need to be configured in the 'Scan' application to connect it with Google Drive?
-In the 'Scan' application, you need to log in with the same Google account used to create the Google Spreadsheet, and then connect it to Google Drive.
How is the form created in the video for scanning the QR codes?
-A new form is created in the Google Spreadsheet by selecting 'Form' and adding required fields such as name, date, and time, which are marked as mandatory.
What happens when a QR code is scanned using the 'Scan' application?
-When a QR code is scanned, the data, including the name, date, and time, automatically populates in the Google Spreadsheet without needing to open the spreadsheet manually.
What is the benefit of using this QR code system for attendance tracking?
-The benefit of using this QR code system is that it simplifies the process of tracking attendance, making it more efficient and less time-consuming as the data is automatically recorded in the spreadsheet.
Outlines
📊 Creating a QR Code Attendance System
This paragraph introduces a tutorial on how to create a QR code-based attendance system using Google Drive and Google Sheets. The presenter, Nanang Suryadi, guides viewers through the process of setting up a Google Spreadsheet, naming it 'QR Code Kehadiran', and organizing the data into columns for names and QR codes. The tutorial then proceeds to explain how to generate QR codes for each name using QR Explorer, download them, and print them for scanning. The next step involves installing the 'Scan it' office app from the Play Store on a smartphone, logging in with the same Google account used for the spreadsheet, and setting up the app to scan the QR codes. The tutorial also covers creating a form in Google Forms to collect scanned data, including mandatory fields for barcode scanning and additional questions such as date and time. The presenter demonstrates how to scan a QR code and have the data automatically populate in the Google Spreadsheet, even without opening the sheet.
🙏 Wrapping Up the Tutorial
The second paragraph concludes the tutorial with a thank you message and a closing remark. The presenter expresses gratitude for the viewers' attention and hopes that the tutorial has been helpful. The paragraph ends with a religious blessing, indicating a respectful and warm conclusion to the video.
Mindmap
Keywords
💡QR Code
💡Google Drive
💡Google Spreadsheet
💡Scanning
💡Attendance Tracking
💡QR Explorer
💡Playstore
💡Google Forms
💡Automation
💡Data Entry
💡Real-time Collaboration
Highlights
Introduction to creating an attendance list with QR codes using Google Drive and Google Sheets.
Opening Google Drive and creating a new folder for the project.
Adding a Google Spreadsheet file and naming it 'QR Code Attendance'.
Renaming the default sheet to 'Set 1' for storing attendee names.
Creating a new sheet named 'Si' for entering data to be included in QR codes.
Copying the names from 'Set 1' to use for generating QR codes.
Using QR Explorer to generate QR codes for each name copied.
Downloading and printing the generated QR codes for scanning purposes.
Installing the 'Scan' app from the Playstore for scanning QR codes.
Logging into the 'Scan' app with the same Google account used for Google Sheets.
Selecting 'Google Sheets' as the destination for scanned data.
Choosing the 'QR Code Attendance' sheet for scanning results.
Creating a new form in Google Forms for data entry via QR code scanning.
Adding required fields to the form such as barcode, date, and time.
Customizing the form with additional questions as needed.
Testing the scanning of a QR code and automatically updating the date and time on the smartphone.
Sending scanned data to the Google Spreadsheet without opening it, ensuring data is automatically recorded.
Demonstrating the ease of processing scanned data for attendance records.
Final thoughts and a thank you note from the presenter.
Transcripts
cara membuat daftar hadir dengan QR kode
dengan sistem seperti ini kita scan QR
kode dan kita kirim maka data tersebut
akan otomatis masuk ke dalam Google
spreadsheet
Hai selamat datang di youtube channel
saya Nanang Suryadi jika menyukai
video-video dari channel ini silakan
klik subscribe untuk mendapatkan update
terbaru video-video dari channel ini
hai hai
hai pertama kita buka Google Drive kita
dan kita buat sebuah folder kalau kita
tambahkan file Google spreadsheet
Hai dan kita beri nama file spreadsheet
tersebut
Hai misalnya kita beri nama dia
Hai QR kode kehadiran
Hai selanjutnya kita rubah nama dari
sitenya misalnya Set satu ini kita
berikan untuk
data-data nama siapa saja akan hadir ini
bisa siswa bisa guru atau karyawan saya
seperti ini namanya sudah saya siapkan
selanjutnya kita buat sebuah set baru
tambahkan seat dan kita beri nama si
tersebut Nah disinilah kita akan
memasukkan datanya nanti Nah kita
bernama agar lebih mempermudah misalnya
qr-code
halo halo dari data ini kita pilih
nama-namanya dan kita copy nama-nama ini
akan kita buatkan QR nya kita
menggunakan QR explorer yang kita pilih
yang ini ya burger
Ayo kita pastikan nama-nama tersebut
tadi yang sudah kita copy dalam kotak
ini dan tadi ada 15 ini sudah ada
generated 15 kode maka akan otomatis
menjadi QR Code dari masing-masing nama
tersebut ini bisa kita download dan kita
Hai untuk keperluan scanning nya
Hai as lanjutnya kita buka handphone
kita dan kita buka Playstore kita
install sebuah aplikasi bernama scan itu
office lalu kita buka aplikasi tersebut
Hai dan kita pilih yang Google Sip Yang
drive Karena kita tadi menginginkannya
untuk semuanya drive lalu kita klik
login dengan akun Google kita pilih akun
Google yang sama dengan akun Google yang
kita membuat Google sip tadi Nah ini ya
akunya bersama lalu kita pilih qr-code
kehadiran ini muncul paling atas yang
terakhir digunakan biasanya
dan kita pilih
Hai yang qr-code Nah situ nanti kita
akan memasukkan data hasil scanning nya
Maka akan muncul seperti ini selanjutnya
kita klik menu connectionnya ini sudah
masuk ya data dari spreadsheet nya
selanjutnya kita akan memilih formnya
Nah kita disini akan membuat sebuah form
baru
tetap beri nama misalnya nih kita hapus
dulu
Kyle God hadir misalnya NATO pertanyaan
pertamanya adalah untuk menyelesaikannya
barcode kita klik wajib diisi dan kita
klik ceklis atau kembali dan kita
tambahkan at field Nah di sini kita bisa
menambahkan partai pertanyaan yang
sesuai dengan keinginan kita misalnya
Hai dan kita pilih update dan wajib
diisi kita Tambahkan lagi untuk waktunya
sama kita klik wajib diisi dan
update-nya hadits ini sangat banyak
pertanyaan-pertanyaan yang bisa kita
buat saat kita melakukan scanning Nanti
kalau saya ini saja cukup ya tanggal dan
waktunya yang terpisah ini beberapa
contoh pertanyaan yang bisa kita buat
Hai deh kalau sudah kita klik kembali
saja
saat ini masih bisa diedit pertanyaan
ini Ya dengan klik tanda pensilnya nanti
Oke kita klik kembali lagi dan scanner
nya bentuknya seperti ini sekarang akan
Kita uji coba untuk menscan QR Code yang
sudah kita buat kita klik tanda gear God
kita izinkan untuk menggunakan kamera
dan kita akan mencoba menscan salah satu
data seperti ini dan tanggal dan waktu
Udah otomatis menyesuaikan yang di HP
dan kita kirim Kita lihat di spreadsheet
nya nah data tersebut masuk
Ayo kita coba lagi untuk
cara menscan data yang lainnya Misalnya
ini
Hai kalau kita kirim
ini maka data tersebut akan otomatis
juga masuk ke dalam spreadsheet nya
walaupun gak kita buka speechnya datanya
akan tetap masuk ya Nah untuk
memperjelas satu kali lagi kita scan
sebuah qr-code
Hai dan kita Kirimlah tanggal dan
waktunya Itu otomatis menyesuaikan
tanggal dan waktu di handphone kita
nanti dengan cara seperti nya tinggal
kita mengolahnya seperti seperti apa
gitu ya sangat mudah sekali untuk
mengolahnya ini saja tutorial kali ini
semoga bermanfaat Terima kasih
salamualaikum warahmatullahi wabarakatuh
関連動画をさらに表示
Autofill Google Doc Template from Google Sheets | Google Apps Script
SolisCloud Installer Registration and First Plant Creation
How to Ship on Ebay Without Printing a Label | Shipping without a Printer from Your Phone QR Code
QR Code Makeup on ComfyUI using ControlNet Brightness Method. (MacBook Pro Intel i7/i9 )
Master Google Sheets with Node.js: Read & Write Data Effortlessly!
CARA MEMBUAT GOOGLE FORMULIR LEWAT HP ANDROID | Google Form
5.0 / 5 (0 votes)