What is Google Forms?

 Google Forms is a free online tool provided by Google. It is used for data collection, surveys, quizzes, feedback, registration forms, and gathering various other types of information. It enables users to create visually appealing and interactive forms without requiring any coding knowledge.

 

 Key Uses of Google Forms:

 1. Surveys:

 To gather customer feedback.

 For market research purposes.

 Quizzes:

 To create quizzes for students.

 To conduct knowledge tests or examinations.

 

 2. Registration Forms:

 To collect registrations for events.

 

For enrollment in classes or workshops.

 3. Feedback Forms:

 To receive feedback from customers regarding a service or product.

 

 4. Order Forms:

 To accept online orders.

 Features of Google Forms:

 

1. Interactive Interface:

 Designing forms is easy with drag-and-drop options.

 2. Various Question Types:

 Multiple Choice

 Dropdown

 Checkboxes

 Short Answer

 Paragraph

 This allows users to ask questions in a variety of formats.

 

 Automatic Data Collection:

All responses are automatically saved in a spreadsheet (as Google Sheets).

The data can be easily exported and analyzed.

 1. Customization: You can change themes, colors, and backgrounds to suit your preferences.

 You can also add your own logo and images.

 2. Sharing and Accessibility: The form link can be shared via email, WhatsApp, social media, etc.

 Anyone can fill out the form using the link, regardless of their location.

 3. Real-time Responses: Responses become available instantly as people fill out the form.

 4. Free Usage: Google Forms is completely free to use; all that is required is a Google Account.

 

 

 

• How to Create a Google Form?

Go to forms.google.com.

•  Create a New Form:

•  Select "Blank" or choose a template.

•  Customize the Form:

 

• Add a Title and Description for the form.

•  Add questions and set answer options.

•  Set Theme and Style:

•  Choose a background color and theme.

 

Customize Settings:

 Adjust the settings if you wish to set a response limit or configure automation.

 

Share the Form:

•  Click the "Send" button to copy the link or send it via email.
•  Benefits of Google Forms:
•  Free and easy to use.
•  No specialized technical knowledge required.

•  An automated and organized method for data collection.
•  Forms can be shared both online and offline.
•  Mobile-friendly interface.

 Use Cases:

•  College admission forms.
• Job applications for new hires at a company.
•  Homework submissions in schools.
•  Event registration.
•  Three Sections of Google Forms:

 - Questions

 - Responses

 - Settings

 

Form Details

 1. Add Question

2. Import Questions: You can import questions from any of your existing forms.

 3. Add Title and Description

 4. Add Image

 5. Add Video

 6. Add Section

 

Important Tips for Forms

 Anil Computers – Student Admission Form

 ? Section 1: Basic Information

 1️⃣ Student Name (Short Answer) – Required

? Enter your full name.

 2️⃣ Father’s / Guardian Name (Short Answer) – Required

 3️⃣ Mobile Number (Short Answer) – Required

? Response Validation: Number → 10 digits

 4️⃣ Email ID (Short Answer)

? Response Validation: Email format

 5️⃣ Date of Birth (Date)

 6️⃣ Gender (Multiple Choice) – Required

 Male

 Female

 Other

 ? Section 2: Course Details

 7️⃣ Select Course (Dropdown) – Required

 DCA

 ADCA

 CCCC

 Tally with GST

 Basic Computer

 Digital Marketing

 8️⃣ Batch Timing (Multiple Choice) – Required

 7:00 AM – 8:00 AM

 10:00 AM – 11:00 AM

 3:00 PM – 4:00 PM

 5:00 PM – 6:00 PM

 9️⃣ Computer Knowledge Level (Linear Scale)

1 (Beginner) – 5 (Advanced)

 ? Section 3: Address Details

 ? Full Address (Paragraph) – Required

 1️⃣1️⃣ City (Short Answer)

 1️⃣2️⃣ State (Dropdown)

 Rajasthan

 Gujarat

 Madhya Pradesh

 Other

 ? Section 4: Documents Upload

 1️⃣3️⃣ Upload Aadhaar Card (File Upload) – Required

 1️⃣4️⃣ Upload Passport Size Photo (File Upload)

 

⚠ Note: Google Login will be required for file upload.

 

? Final Declaration

 

1️⃣5️⃣ Declaration (Checkbox – Required)

☑ I confirm that all information provided is correct.

 

? Submit Message (Write in Confirmation Message)

 

"Thank you for registering at Anil Computers.

We will contact you shortly regarding your admission."

 

Different Types of Question Details

 

Exercise No. 1

 

1️⃣ Short Answer

 

? To get a short one-line answer.

 

Example:

Question: What is your name?

Answer: Ramesh Kumar

 

Use: Name, Mobile Number, Email, Roll No.

 

2️⃣ Paragraph

 

? To get a longer answer.

 

Example:

Question: Why is Digital Marketing important?

Answer: (Student can write in 4–5 lines)

 

Use: Feedback, Suggestions, Description

 

3️⃣ Multiple Choice

 

? Can choose only one option from multiple options.

 

Example:

Question: Which course are you pursuing?

 

DCA

 

Tally

 

ADCA

 

CCC

 

(Select only one option)

 

4️⃣ Checkboxes (Multiple options)

 

? More than one option can be selected.

 

Example:

Question: Which software applications are you proficient in?

☑ MS Word

☑ MS Excel

☑ Photoshop

☑ Tally

 

5️⃣ Dropdown (Dropdown List)

 

? Similar to Multiple Choice, but the list appears in a dropdown menu.

 

Example:

Question: Select your state.

▼ Rajasthan

▼ Gujarat

▼ Delhi

▼ Maharashtra

 

6️⃣ File Upload

 

? Used to request a file from the respondent.

 

Example:

Question: Upload your Aadhaar Card.

 

⚠️ Note: A Google Login is required for this feature.

 

7️⃣ Linear Scale (Rating Scale)

 

? Used to collect ratings ranging from 1 to 5 or 1 to 10.

 

Example:

Question: Rate our class on a scale of 1 to 5.

1 ⭐ (Poor) — 5 ⭐ (Excellent)

 

8️⃣ Multiple Choice Grid (One option per row/column)

 

? Allows you to select one option for each row and column.

 

Example:

 

Subject

 

Good

 

Average

 

Poor

 

MS Word

 

○

 

○

 

○

 

Excel

 

○

 

○

 

○

 

9️⃣ Checkbox Grid (Multiple options per row/column)

 

? Allows you to select more than one option for each row and column.

 

Example:

 

Day

 

Morning

 

Evening

 

Monday

 

☑

 

☑

 

Tuesday

 

☑

 

☑

 

? Date (Select Date)

 

? Used specifically to collect a date.

 

Example:

Question: Select your Date of Birth.

? 12/05/2005

 

1️⃣1️⃣ Time (Select Time)

 

? Used to collect a specific time.

 

Example:

Question: Select a time for the interview.

⏰ 10:30 AM

 

? Extra Important Settings

 

✔ Required

 

If turned ON, answering the question becomes mandatory.

 

✔ Response Validation

 

You can set conditions for inputs such as Mobile Number, Email, Length, etc.

Example: Mobile Number must consist of exactly 10 digits.

 

✔ Section

 

You can divide the form into separate parts or sections.

 

 

 

Exercise No. 2

 

Question:

"What is your favorite color?" Options:

 

Red

Blue

Green

Yellow

Other

4. Checkboxes

 

Question:

"Which hobbies do you enjoy?"

 

Options:

 

Reading

Listening to music

Traveling

Painting

Cooking

5. Drop-down

 

Question:

"Which country are you from?"

 

Options (Drop-down Menu):

 

India

USA

Canada

Australia

Other

6. File upload

 

Question:

"Please upload your ID card."

 

Instructions:

 

 

 

Upload only PDF, JPG, or PNG files.

7. Linear Scale

 

Question:

"How satisfied are you with our service?"

 

Scale:

1 - Not at all satisfied

5 - Completely satisfied

 

8. Rating

 

Question:

"Please rate our website."

 

Rating Options:

⭐⭐⭐⭐⭐ (1 to 5 stars)

 

 

 

Note: Google Forms does not have a direct "Rating" option; however, you can create one using the Multiple Choice Grid or Linear Scale features. For example, you can use a Linear Scale ranging from 1 to 5, or include star emojis (⭐) as options.

 

9. Multiple choice grid

 

Question:

"Please evaluate our services based on the following criteria."

 

Rows:

 

Customer Support

Product Quality

Timely Delivery

Pricing

Columns:

 

Excellent

Good

Average

Poor

Very Poor

10. Tick box grid

 

Question:

"Please select the days you participate in the following activities."

 

Rows:

 

Yoga Class

Dance Class

Painting Workshop

Music Class

Columns:

 

 

 

Monday

Wednesday

Friday

11. Date

 

Question:

"Please enter your date of birth."

 

Format:

 

[Day/Month/Year]

 

12. Time

 

Question:

"Please enter your appointment time." Format:

[Hour:Minute] (AM/PM or 24-hour format)

 

 

 

Response Option

 

"Responses" refers to the total number of people who have submitted a response to your form.

 

To obtain the complete list in a Google Sheet:

 

Click on "Link to Sheets" > Select a destination for the responses.

 

i) Create a new spreadsheet (give it any name).

 

ii) Select an existing spreadsheet.

 

As users fill out the form, the data will be automatically collected and populated in this sheet.

 

To download the Google Sheet file in Excel format:

 

Open the Google Sheet (via Google Drive) > File > Download > Microsoft Excel (.xlsx)

 

 

 

 

 

Google Form Link:

 

Thanks to ChatGPT

Thanks to Gemini Google