Google Sheets and Forms (Joey Lehrman)

	A	B	C	D	E
1	Thanks for attending the COABE Webinar on Google Forms and Sheets!		www.teachjoey.com
2	See below for responses to questions from the call. If any replies aren't clear, just add a comment and we can continue talking in this document!		www.teachjoey.com
3	#	Question	Asker Name	Link for more information	Answer

4	1	How do you access paragraph in forms / quiz, add your notes, and get response back to the students?	Lissa klein	here	Select the question and then choose the question type drop down menu.
5	6	Repeat the shortcut, please?	Christine Case	here	docs.new, slides.new, sheets.new, forms.new
6	37	how did you just split that screen?	Nicole Worley	here	Google it - the process varies depending on PC, Mac, or Chromebook
7	38	How did you split screens inside Zoom?	Lissa klein	here	Same as above - Google it as the process varies depending on device type
8	41	What does Drive for desktop mean?	Anonymous Attendee	here	It allows you to sync your Google files from the cloud to your local device so you can work without an internet connection if needed.
9	42	We aren't using hi-test materials	Cheryl Voss	here	That's okay - you could adapt a GED practice test into Google Forms as well!
10	44	Can Google Forms be made translatable to any language through Google Translate?	Janelle Hertzler	here	I'm not sure - you could use Google Translate's website and then copy/paste to Google Forms
11	45	Once we get the links for the presentation, for how long do we have access to them? Thank you.	Esther Talamantes	here	Unlimited!
12	46	Does Google Sheets do formulas as well as EXCEL?	Deborah Launey	here	Similar but fewer options (which is a good thing, I think - easier to learn and use)
13	47	We use GED. How do we get the questions on the GED Ready (online only) in order to create the survey and sheet you just showed.	Janice Walpole	here	Find a free GED practice test and send it to your students as a PDF - then use the Quiz form in Google Sheets to indicate the correct answers.
14	49	WHat is the name of this spreadsheet on the main form we're all in?	Michelle Leduke	here	Not sure what the question is here - please contact me anytime at teachjoey.com!
15	52	what was the command for split screen again?	Sheila Butler	here	Google it - the process varies depending on PC, Mac, or Chromebook
16	59	Autocrat?	June Brittingham	here	Free add-on that allows you to automatically send emails based on Google Form responses.
17	60	I don't know how to access the survey.	Anonymous Attendee	here	Not sure what the question is here - please contact me anytime at teachjoey.com!
18	68	So do you put the WHOLE practice quiz into the form? Or are you just doing problem number and answer? Does this need to be confirmed with your state D.E.?	Elizabeth LaHaise	here	Just the problem number and answer. The test is a separate PDF file. We don't use this as an official practice test, so no state approval needed. It's more of a self-evaluation and confidence-buiding activity.
19	70	Do scores populate automatically?	Maria Roman	here	They populate in the spreadsheet and can also be immediately shown to students on screen if preferred. See the "Change how you release grades" section in the link.
20	71	Can you show us ways to share our screens showing content for students to see and allowing us to see students at the same time?	Carrie Paredes	here	Use gallery mode in Zoom and split your screen (or use a 2nd monitor)
21	75	What do you click to look at form?	Deborah Launey	here	Preview mode (the eye icon in the top right corner)
22	78	Any tips on how to make math quizzes more easily in Google Forms? I've had a hard time getting math symbols on there.	Erin Moses	here	It's easiest with a Forms add-on (free) like Equatio or Quizziz
23	79	He said click on the i to see what it looks like...where is that? Then he goes back...how do you do that?	Joy Gaine	here	Preview mode (the eye icon in the top right corner)
24	81	where is that button again for the preview?	Delia Wenz	here	Preview mode (the eye icon in the top right corner)
25	92	Can these be put into Google Classroom - what you created with the questions and videos?	Anne VonGunten	here	Yes! Just assign the Google Form as an assigment in Classroom
26	95	When you selected the direction the selections woud go to a section, was that a right or left mouse click?	David Clark	here	Left-click
27	97	Can you make the branch dependant on an answer to a question? IE Get % question wrong go to % but get Fraction question right go to Fractions?	Deborah Launey	here	Yes! But only based on answers to multiple choice or drop down questions.
28	98	How is this placed in Google classroom for students to find?	Georgette McGovern	here	You can assign the Google Form as an assigment in Classroom
29	101	Is there a good way to format text in the question place? A bulleted list, for example? When we view the form as a submitter, what we type is all mixed up.	Michelle Leduke	here	Depenends what you mean. You could add an image to the question like this. Contact me if you are trying to do something else (teachjoey.com)
30	102	Can you show short poll in Form?	Deborah Launey	here	In a way: Open the Google Forms Responses tab to see real-time results.
31	111	I don’t know where my forms are stored once I create them. I created one, gave students the link, and then got an email saying a few had completed the form, but I couldn’t find it! I also didn’t know how to send students feedback if they did not use gmail and had clicked a link on whatsapp to get to the form.	Janet Kaplan-Bucciarelli	here	Go to forms.google.com (while signed into your google account) to find all your forms; Make the form a "quiz" to easily offer feedback.
32	113	How do you make it into sections with a next button, versus one long page?	Abbie Martin	here	Find the 'add section' option near the 'add question' option.
33	114	How can you protect social security numbers in docs like these	Tammy Brown		I'd (unfortunately) suggest not collecting SSN via Google Form as it's not secure.
34	115	What if we do need this to be our official intake? Any suggestions for signatures?	Gwen Matuszewski	here	There are a few ways, either with an add-on or just create a question type with a text field "Enter your nam here to sign"
35	116	is that intake form availble for other programs to use?	Georgette McGovern	here	You can make a copy of our template if you'd like - or create your own!
36	117	Can the data in this form automatically fill in fields in our NRS forms?	Deborah Launey		It's possible with a custom script (you'd need to work with a programmer)
37	122	Is there a translate option on forms?	Lynn Leslie	here	I'm not sure - you could use Google Translate's website and then copy/paste to Google Forms
38	123	The survey form feeds into a sheet to aggregate data?	Deborah Launey	here	Yes - You can choose where the data goes in the Google Forms Responses tab.
39	124	How can I save these sample forms to my drive?	Janelle Hertzler	here	Forms automatically save to Drive (as do ALL Google Drive files).
40	128	Some of our students are not literate but we still want thier feedback and participation. Could we add audio to the questions or just video?	Janet Kaplan-Bucciarelli	here	There are a couple ways to add audio. Record a YouTube video with audio only and add that video, or link to an audio file.
41	129	Does the data retrieved present in a bar graph or circle graph automatically? or do you get to choose	vanessa sanchez	here	If you view responses in Forms, it's automatic. If you view in Sheets, you can customize the graph.
42	130	If I can use Google Forms as a registration form, can I program the registration process to come to a close at the required number of participants, so that the training event is not overbooked?	Desire Grogan	here	Yes - use the Form Limiter add-on. We use it for exactly that purpose too. You can also schedule it close open and close at specific times.
43	131	Does Google forms require a gmail address to allow students to respond?	Nicole Kennell	here	No - you can set it up so anyone with the link can access without logging in. Turn off the setting that requires email login
44	132	Do you offer a more basic Google training? This is way over my head.	Connie Colman	here	Happy to schedule a call!
45	138	In Forms, is there a way to add a section where students can actually sign their names?	Brandi Woods	here	There are a few ways, either with an add-on or just create a question type with a text field "Enter your nam here to sign"
46	139	Show the freeze title in sheets again, please	Mary Popp	here	Check out the link!
47	142	What if student has two types of attendance like tutoring session and online. How can I set up the cells for that?	Ellen Malone	here	Lots of options here - message me and we can find time to chat!
48	144	Can you attach to Google voice that would allow for texting student?	Ellen Malone	here	Ooh that's a COOL idea. This might work but I'd suggest Googling around for other solutions.
49	146	Can we bring data from other systems into forms?	Sheila Butler	here	Depends what you mean. You can import questions to Forms!
50	147	Is there a more basic training? This is too advanced!	Connie Colman	here	Hope it wasn't too fast. Happy to chat by phone anytime if you'd like to go slower!
51	158	How did he do the split screen again?	sharrilyn smith	here	Google it - the process varies depending on PC, Mac, or Chromebook
52	159	This was marketed as 101?	Cecilia Veiga	here	Hope it wasn't too fast. Happy to chat by phone anytime if you'd like to go slower!
53	160	Can you use Google forms with Canvas?	Melissa Perry	here	Yes you could link to or embed a Form in Canvas.
54	172	Is there a way to share the results with the students and allow them to select a link without editing the sheet?	Lori Collins	here	Yes! You can use Form Notifications to allow students to download their responses.
55	173	can form answers be imported into sheets, say a class survey	Liz Otterness	here	Yes! All responses from a Form can be viewed in Forms or Sheets.
56	176	Can you discuss the part more about the intake form and sending an automated response	Melissa Perry	here	Add the questions you want (name, phone, email, etc.) and then use Autocrat to send responses.