CARA MEMBUAT GOOGLE FORMULIR LEWAT HP ANDROID | Google Form

CALON ILMUWAN ID

21 Sept 202305:30

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

00:00

📝 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.

05:04

👋 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

Google Form is an online survey and form creation tool provided by Google. It allows users to create forms, surveys, and questionnaires that can be filled out by others. In the video, the main theme revolves around teaching viewers how to create a Google Form on an Android device to make a student attendance list, highlighting its utility in organizing and collecting data.

💡Android

Android refers to the operating system used by most mobile devices. In the context of the video, the presenter is guiding the audience on how to use an Android device to access and create a Google Form, indicating the platform's versatility and accessibility for such tasks.

💡Attendance List

An attendance list is a document or record that contains the names of individuals who are present at an event or meeting. The video's tutorial focuses on creating an attendance list using Google Form, which is a practical application for educational or organizational purposes to keep track of participants.

💡Chrome

Chrome is a web browser developed by Google. The script suggests using the Chrome app for accessing Google Drive and creating the form, emphasizing the compatibility and convenience of using Google's ecosystem for this task.

💡Google Drive

Google Drive is a file storage and synchronization service developed by Google. It is mentioned in the script as the initial step to access previously created Google Forms, indicating its role as a central hub for Google's suite of productivity tools.

💡Dropdown

A dropdown, in the context of forms, is a user interface element that allows the user to click on it to view a list of options, from which they can select one. The video explains how to use a dropdown menu in the form to select a class, demonstrating a common feature for categorizing responses.

💡Checkbox

A checkbox is a type of UI element that allows users to select multiple options. In the script, checkboxes are used for the 'Remarks' section of the attendance list, where students can indicate if they are present, have permission to be absent, or are sick, showcasing the form's adaptability for various response types.

💡Preview

Preview refers to the act of viewing something before it is finalized or published. The video instructs viewers to preview the Google Form to ensure it appears as intended, which is an important step in the form creation process to check for errors or layout issues.

💡Share

Sharing, in a digital context, involves making something accessible to others, often through links or permissions. The script describes how to share the Google Form by generating a shareable link, which is essential for distributing the form to the intended audience.

💡CSV

CSV stands for Comma-Separated Values, a file format used to store tabular data, such as a spreadsheet or database. The video mentions downloading the form responses in CSV format, which is then convertible to an Excel file, highlighting the ease of data manipulation and analysis post-collection.

💡Excel

Excel is a spreadsheet program by Microsoft that is widely used for data organization and analysis. The video script includes a step to convert the CSV file to an Excel file, demonstrating the compatibility between different data formats and the ease of transitioning data for further use.

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.