Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Forms: Paste a LOT of Student Names

Google Forms: Paste a LOT of Student Names

YouTube video

Tip for using Google Forms: Try to use Multiple Choice and Drop Down options as often as possible. When you let students or others fill in the Form with open response answers it is difficult to sort and filter by that response. If possible, add a drop-down list of the student names for them to choose on the Form.

Want More Help with This? Become a Premium Member

Multiple Choice, Checkboxes, Dropdown

Any of the question types in Google Forms that let you present the responder with a list of options you can PASTE the list. No need to tediously type (or copy paste) each option one at a time.

Paste All At Once

You do NOT need to copy and paste each name one by one. On the multiple choice question choose “Option 1.” While Option 1 is highlighted use Control V to paste the list of names.

Separate Options

If you have question options in a Word Document, Google Doc, or a spreadsheet you can copy and paste into options lists, the entire list at once, into Google Forms. The trick is, each option needs to be on it’s own line. In Word or a Google Doc this means your options are on different lines. You have pressed Enter between each option choice. In Google Sheets this means each option is in it’s own cell, vertically.

Paste Special

If your options are NOT pasting correctly try pasting them into a Google Sheets spreadsheet but hold down the SHIFT key when pasting. Control Shift V is paste special and sometimes this will fix some of your copy paste woes.

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 »

Leave a Reply

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