Good afternoon,

Lately I have been truly inspired by teachers and their determination to use digital educational resources.  Having worked with many to overcome the struggle of having elementary school students use websites that have too many options or distractions I discovered that many of the sites use swf files (Shock Wave Small Web Format) that can be opened directly in full page views.  In thinking about their needs my response has been isolate the swf file links and to build to allow teachers to share direct links with their students to these educational resources.

The website is housed on Weebly and uses Google Sheets to store the data and uses Google Forms and some Google Sheets scripts to create a recommendation engine and new site suggestion tool as well. is sortable, searchable and has the ability to Share with Google Classroom.  Please take a look at the current resources, make suggestions, and recommend resources for other teachers.  The site continues to grow and have more links added.  Please take some time to look at this resource and share with others.


L4C site

“Make a copy” and share your Google Form!

Earlier this week I wanted to share a Google Form in a training, but I wanted each person to have their own copy to use in their own classroom.  I have used the trick to share other Google Drive base files by changing the end of the URL from “/edit” to “/copy”.  This works with Google Docs, Sheets & Slides (as long as you also share viewing rights to the document), but not with Forms editor.  In playing around I did discover that “/copy” will work, so here are the steps.

  1.  Create your form and design at will by adding questions and adjusting the theme.
  2. Now you need to adjust the share settings of the form.  Go to File-Add Collaborators and share the form as needed.  I choose “Anyone who has the link can edit” which is a little scary, but their is no “can view” option.  We are not going to really share the editor URL anyways, just make sure this is your template and not a form you are actively using.
  3. The last step is to view your live form (example).  This is the URL you will need, but before you share you will need to change the “/viewform” to “/copy”.  Now when you share the new live form link (updated example) the trainee will be asked if they want to make a copy.

Copy Form

Enjoy sharing your forms,



Google Form for everyday use, and automatically show the students name!

I was working with a teacher on Monday who had created a Google Form that could be used to collect responses for any in-class question (ie. math problem of the day).  There was one problem with the form  and that was that the students usernames are a combination of letters and numbers, making the students for each answer difficult to identify.

Here is a simple way to solve this problem using the vlookup function and the copyDown add-on.  This is a very basic Example Form to show the data entry and an Example Response Sheet which has the instructions to setup the vlookup and copyDown features.

Screen Shot 2016-03-02 at 8.51.46 PM

Enjoy your your everyday Form,