I saw someone post a question about how to upload a list of say, 100, names to a Google form for a drop down list. I am not aware of a way to do this, but this was my suggested work around. The other day I posted a blog post on 5 easy steps to…
Category: Docs
Grading with a Pivot Table
I have decided this year I do not want paper. Nothing is worse than carrying that giant stack of papers home… only to not touch them and haul them right back to school. Just looking at that giant stack to grade is depressing. Instead, I am having students turn in their work digitally to a…
Creating Graphics
I like to use www.quia.com for my mastery learning. I have hesitated wanting to teach Geometry because I like to do all my stuff digitally and the thought of making all those graphics was overwhelming…. Well, I am teaching Geometry this year. And creating all of those graphics IS overwhelming. But I’ve figured out a way…
Mail Merge from a Google Spreadsheet
I know you’re thinking why in the world would I want to do this… Have you ever wanted to email each student in your class individual feedback? But then realized how overwhelming that task is. You’re 20 emails into it and you don’t have the strength to message the other 180… Here is what…
Making an Email List from a spreadsheet list
I love it when I see people getting excited about Excel commands. mrmadden77Robert Madden The answer to life’s problems (at least for today): =CONCATENATE(B2, LEFT(A2,2), RIGHT(F2,4)) 19 minutes ago One of my favorite things to teach in an advanced Excel class is the concept of Concatenate, but who can remember that word or how…
Step One: Title your Google Doc
When you start a document in Google Docs it is defaulted with the name “Untitled document.” Before you start anything on your document you want to CLICK on the words “Untitled document” and name it something meaningful. Several times I have received notification that someone has shared with me “Untitled document” which gives me…
Table of Contents in a Google Doc
A feature in Google docs is the ability to create a table of contents. Start a google doc From the insert menu create a table of contents. This will insert at the top where the table of contents will go. You will have to update each time you have new parts to your TOC. The…
Inserting Images into a Google Spreadsheet
If you want to insert an image into your Google Spreadsheet you will want to use the formula: =image(“url”) Type the formula right into the cell in the spreadsheet. Make sure you start with an equals sign. You will also need quotations around your URL. My favorite trick is to use www.tinygrab.com and take a…
Math Symbols in Google
If you want to put math symbols into your Google Presentations it can be a little tricky. In Google Docs there is an equation editor that will allow you to directly insert equations. (Note: If you know LaTeX you can use the LaTeX notation instead of using the toolbar to save yourself time). However, in…
Google Docs in the Classroom
The information on how to go Google in your classroom was better than I could do, I am copying what was listed: https://docs.google.com/View?docid=dcdn7mjg_72nh25vq Using Google Docs in the classroom: Simple as ABC What is Google Docs? Google Docs is a free, Web-based word processing, presentations and spreadsheets program. Unlike desktop software, Google Docs lets people…
Switch to Google Docs
I am becoming more and more convinced that most people do not need Microsoft Office. There are a few people who need advanced features in Office, but most people do not need it. Here is a link to a list I made in response to someone asking me a question about changing the lame defaults…
Collaborating with Google Docs
I am a fan of collaboration, and I’m always trying to spread the google docs love, but today was just the ultimate for me. I run the neighborhood association and was tardy on making the agenda for the meeting. I duplicated the last months agenda and within a couple of minutes my communications officer, Barb,…
Google Docs – Text to Columns in a spreadsheet
If you are an avid excel user like me then you probably like the text to columns feature which will take one cell and split it into multiple cells based on a delimiter. I use this a lot when I have a spreadsheet that has peoples names in it. Oftentimes the first and last name…
Sharing a Google Doc
One of the powerful tools about Google Doc’s is the ability to share. This enables collaboration and also to keep others in the loop on your project. To share directly with another person click on the “SHARE” button in the upper right hand corner of your google doc. If students put in your email you…
Google Forms Notifications
When using google docs you can create forms to allow parents/students or colleagues to send you information. One thing you want to make sure you do is Go to docs.google.com Make your form Open your spreadsheet that is created when you make a form. Go to tools Choose notification rules Select for it to email…
You must be logged in to post a comment.