Home » Google » Page 112

Google

Take the Hassle Out of Students Turning in Assignments

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

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 it reassigns a NEW random… Read More »Random Student Chooser

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 simply choose Insert->Presentation and a… Read More »Add someone else’s Google Presentation into your Google Site

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 to have a one page… Read More »Gmail Search

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 out of the cells. Usually… Read More »Make a multiplication table in less than 35 seconds

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 made.  It is a little… Read More »How to Edit a Google Form