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…
Category: Google
PhotoBucket – Quickly Add Pictures to Your Student Resources
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…
Random Student Chooser
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…
Revision History in a Google Document
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…
Creating Custom Student Forms
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…
Color Picker in Google Presentation
Matching colors in a Google Slides presentation can make all the difference. Use this tool to help create the perfect color themes in Google Slides. google slides color dropper. Color picker in Google Slides
Add someone else’s Google Presentation into your Google Site
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…
Mail Merge Script in Google Spreadsheet
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…
Bingo Template
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.
Gmail Search
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…
Make a multiplication table in less than 35 seconds
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…
Google Spreadsheet: Reference an External Spreadsheet
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…
How to Edit a Google Form
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…
Uploading Images to the Internet
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…
Which group member did all the work?
Announce a group work project to your class and you’re sure to get a few groans. We have all been in a group and usually it is one person who does most of the work. As a teacher, how do you ensure that work is done equally? There is no guarantee, but here are some…
You must be logged in to post a comment.