The Scan to Web (and Scan to Spreadsheet) app has come in very handy for me this year. No need for a small school district to spend lots of money on fancy barcode readers when a few dollars spent on an app will do. Here is a quick video showing what I’ve been doing today as I get our new Chromeboxes set up for our computer labs.
Powtoon has a great way to honor our fallen heroes and veterans this Memorial Day by reaching out to those who continue to serve and protect our country!
They are calling on teachers, students, military family, friends, and anyone else who would like to salute our men and women in uniform (past & present) to create and send a personal video message to a veteran or soldier stationed abroad.
This takes less than 5 minutes.
Here is one I made in just a couple of minutes.
Also, if you know someone in the military who could help Powtoon spread this to more soldiers they would love to hear from you. You can email Ari at support@powtoon.com and they will follow up with you asap!
Fun new addition!
I struggle with perfectionism. It causes me an incredible amount of self-induced stress. Maybe these will help. Maybe not.
Have you ever wanted to trigger a script on a Google Sheet of Google Form responses that would create a Google Slide containing the submitted information? Try this.
I recently shared a hack that made Google Slides act as a pseudo Google Doc so YouTube videos could be embedded. This post gives Google Docs the chance to fill a need not available in Google Slides – the creation of a new “slide” using autoCrat after a Google Form submission is received.
Let’s say I have a Google Form (inspired by Tom Barrett’s Interesting Ways series) that I ask my PLN use to crowdsource interesting ways to use Google Docs in the classroom. That form currently looks something like this (feel free to make a submission):
I would love to be able to trigger a script on the Google Sheet of form responses that would create a Google Slide containing the submitted information. Ideally, it would be a slide appended to an already existing Google Slide presentation. Unfortunately, that is not currently possible.
Yes, I know I could follow the same process Tom did by just making the actual Google Slides file freely editable by anyone but I’d rather have a bit more control and avoid digital vandalism.
Here is my hacked workflow.
When someone submits the Google Form above, the information is sent to a Google Sheet. I could have chosen to have autoCrat run on submission but, dreading spammy submissions, I am going to run the script manually after I review submissions. When I do run the merge script, autoCrat uses this Google Doc (see screenshot below) as the template for the merge. It has been formatted to look like a Google Slide (explained later in this post).
The resulting autoCrat merge looks like this:
If a URL to an image is provided in the submitted data, I will probably grab that image and slip it into the document but, for now, that’s the only way an image will get in.
Here is a comparison of what a similar Google Slide would like.
It’s not perfect but it helps.
FYI: The Google Doc is set to a landscape orientation with all four margins decreased to 0.3 inches. I chose the Executive setting for paper size as it most closely resembled the slide size.
If you are interested, here is an embedded Google Drive folder containing any of the merged documents I have reviewed and published.
I expect that, after reviewing, adding images, I will be converting these Docs to PDF so I can combine the PDFs into one document.
What ideas do you have for making this hack more efficient? I would love to hear them! Share in the comments below.
Ok, so I know this is not REALLY a Google Doc but you sure can make it look like a Google Doc.
Learn some about a great Google Chrome extension called Read&Write by viewing this Google Slide. See below how to do this yourself!
I am awful about keeping up with what becomes deprecated by Google (DocsList is now gone and DriveApp must be used instead). Today, some of our district workflow threw errors because we are still using AutoCrat v4.5.5 (4/12/14). I will update over the summer, but for right now, I just wanted to get this installation of the script working. I headed over to the Google Group for Apps Script Issues and found the answer. I am sharing here in hopes it may save you all some searching.
First, make a copy of your sheet (just in case).
If you need help finding out if you are using the same version of AutoCrat as we are, here is how to find that AND how to get to the Script Editor.
Click image to view larger version in a new window.In order to fix the script, you are going to be making changes to the code. PROCEED AT YOUR OWN RISK!
Click on the link to AutoCrat in your Script Editor window. It will look like this. Note: the left sidebar lists all the files it takes for AutoCrat to work its magic.
The Script Editor has a Find & Replace feature which can be found under the Edit menu. NOTE: I get a little nervous doing mass Find & Replace so I used the Find and then made the changes manually.
Here are all the things you need to fix:
Save the changes in the Script Editor and try running your AutoCrat merge again.
This worked for me. I hope it works for you as well.
Look at your audience when talking into your webcam. This can help you do that.
I put this module together for one of my graduate school classes and am sharing it here in case it can be helpful for anyone else. I intend to share with the teachers at my school as a flipped element for a PD session on creating screencasts. Not only does it have helpful info about screencasting but it also includes some Visible Thinking routines AND shows how you can push Google Sites a bit.
GO TO:
I decided to check out one of the sample courses on teach for Google and thought I would share something that I’ve used before but some of you may not have thought about. A simple formatting adjustment can make a world of difference.
