Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Forms: Collect First Name and Last Name

Google Forms: Collect First Name and Last Name

Google Forms collect last name and first name

I have been on a roll lately writing blog posts about Google Forms. If you’re new to Google Forms my blog post on using Forms to make formative assessment quizzes should be helpful. If you are a Google Classroom user my blog post on how to insert Google Forms into an assignment or announcement may be helpful. Here is a tip that Forms users may find helpful.

Collect Last Name and First Name

When creating a Google Form I always ask for last name as a different question than first name. This solves several problems. 1) I can sort the spreadsheet of data by last name, which is really handy when I want to put grades and comments in the gradebook based on the quiz. 2) When I ask for “name” I will have students who only tell me “Bob.” Possibly I have more than one Bob in my classes so I struggle with knowing which Bob it is. It is also difficult to align to my gradebook when students only give me their first name.
Google Form First and Last Name separate

When I do a mail merge based on the data from the Google Form I like to greet the student by name. “Hello Bob, you did a fantastic job on this assignment. For question 1 you answered cat. My feedback to you on this is that cats are a type of mammal.” If I had asked for name I would have to always address the student in the mail merge message by their full name, which is fine, but I like the option to use first and last name separately.

If you choose to automatically collect the students login information, the Form collects the email address of the student. This is not helpful for inserting into the gradebook or for using a mail merge. Asking for first and last name separately solves this.

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

1 thought on “Google Forms: Collect First Name and Last Name

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.