GoogleTips_Tricks. Merge info from Google Forms to PDF Document and Send via Email. Today we needed a way to easily take information submitted from Google Form and create a form letter so administrators can sign and send it home with a student. I went through several mail merge scripts but nothing fit exactly what I needed so I took some of the best ideas from all of them (especially the employee of the month script) and created a system that works for us. This method of utilizing Google Apps script can be used for certificates for PD sessions, creating awards, or any other documents in which you need to get information that is submitted via a Google form.
Note, this is an advanced walkthrough but if you need help, please just ask! I am more than willing to work through it with you! This is what our final document looks like: Here is our workflow: To get started create your Google form and get all of the information that you need to record. After you create your form its time to create the template for what your end result will look like. Var docTemplate = ; Whole Script: E-Learning Infographics - The No.1 Source for the Best Education Infographics. 50 Education Technology Tools Every Teacher Should Know About. Technology and education are pretty intertwined these days and nearly every teacher has a few favorite tech tools that make doing his or her job and connecting with students a little bit easier and more fun for all involved. Yet as with anything related to technology, new tools are hitting the market constantly and older ones rising to prominence, broadening their scope, or just adding new features that make them better matches for education, which can make it hard to keep up with the newest and most useful tools even for the most tech-savvy teachers.
Here, we’ve compiled a list of some of the tech tools, including some that are becoming increasingly popular and widely used, that should be part of any teacher’s tech tool arsenal this year, whether for their own personal use or as educational aids in the classroom. Social Learning These tools use the power of social media to help students learn and teachers connect. Learning Lesson Planning and Tools Useful Tools. BYOD Resources - HS.