Updated Note: This script works with old Google Sheets. Click Here to make a copy of a blank Google Sheet that is the old version. You will want to connect your Google Form to the old style spreadsheet. In the new Google Sheets there is an Autocrat add-on, however it will not merge the document upon form submission. This means… Read More »Take the Hassle Out of Students Turning in Assignments
Copying and pasting from one location to another does not always work out. The screenshot above is a copy and paste from a table in Moodle into a Google Doc. To fix this you will want to right click on the table and choose table properties. Under table properties you are able to change the border color, border width, cell… Read More »Table Properties in a Google Doc
When using Web 2.0 tools such as a wiki, survey monkey or other places where I want to create resources for my students to use in class I frequently want to add images. Some places only allow me to upload my images via URL. This means I have to host them somewhere such as flickr or photobucket. I recently retried… Read More »PhotoBucket – Quickly Add Pictures to Your Student Resources
How do you call on students in class? I use a spreadsheet and the =rand() formula. Create spreadsheet with student names In the column next to their name write the formula =rand() Sort the sheet by the random number and a random student will float to the top. Since each time you sort the sheet it reassigns a NEW random… Read More »Random Student Chooser
In Google Docs and Google Sites there is an option to see the revision history. Use this to… See who has been working on the document. Revert back to an old revision if you are unhappy with the changes. Revert back to an old version if a collaborator makes changes that were not welcome. Grade group work, as the instructor… Read More »Revision History in a Google Document
In a previous blog post I explained how in 5 easy steps you can learn how to pre-populate a Google Form. I would like to show you how you can use spreadsheets to take this one step further. In my quest to go paperless I created a form for students to turn work into. This is one form that they… Read More »Creating Custom Student Forms
I like to use a Presentation tool to create posters. For the upcoming Central Valley Computer Using Educators Tech Expo I was using Google Presentation to make door signs. The logo for the event had a light yellow color along the bottom. I wanted to extend the bottom of the logo to create a solid line across the slide. I… Read More »Color Picker in Google Presentation
My preferred method of presenting is to maintain a Google Site and to embed a Google Presentation into the site. For teaching I run my class off of the Google Site page I created (announcement style page). What is nice about this is when I use the insert menu in my Google Site, I can simply choose Insert->Presentation and a… Read More »Add someone else’s Google Presentation into your Google Site
This post has been UPDATED Please check out my blog post on Mergo. The Mergo Add-on is a high quality mail merge that is created by a personal friend of mine (in other words, it is trustworthy!) I enjoy using mail merge to communicate with students. One popular tool is flubaroo. When students use a Google form if the teacher… Read More »Mail Merge Script in Google Spreadsheet
At today’s CUE Rock Star teacher camp session I had the priviledge to lead a session in Yosemite valley on spreadsheets. We made a Bingo sheet using vlookup and random numbers. Here is the template for anyone who would like to have a quick and easy Bingo board for their classroom.
One of the features I love about Gmail is the ability to search my emails. While I will occasionally use labels to organize some emails, mostly this is unnecessary since I can use the search bar at the top. While creating a presentation for using Gmail I thought it might be handy for the participants to have a one page… Read More »Gmail Search
This will work in any spreadsheet, but I am going to use Google Spreadsheet. Click on the corner of your Google spreadsheet where the rows and columns come together Hold cursor between any two columns (between letters) and resize. Hold cursor between any two rows (between numbers) and resize. You want to make square boxes out of the cells. Usually… Read More »Make a multiplication table in less than 35 seconds
Last school year I had all my students turn in their work to a Google Form. This allowed me to go paperless. They posted all of their work to a WordPress blog, which gave them a student portfolio, but would turn in the link to the Google Form. What I loved about this system is I did not have to… Read More »Google Spreadsheet: Reference an External Spreadsheet
Note: Google Forms has undergone a MASSIVE update. Please see newer blog posts on Google Forms. My sister is having her wedding reception soon and I helped her to create a Google Form to collect RSVP’s. She noticed a grammatical typo and was baffled on how to edit the form once it had already been made. It is a little… Read More »How to Edit a Google Form
One way to get your images onto the internet is to use a site such as flickr or photobucket. Both are fine, but I want a faster way to upload images. My trick is to use a Google Site that I have. Google Sites allows me to upload images. Either I will insert the image into a page, attach the… Read More »Uploading Images to the Internet