Teaching students to be good citizens and makers requires the knowledge of copyright and of the ability to create your own content. Drawing characters for comics, cartoons, Scratch, etc. can be difficult. Students want their work to look good, and when they can’t draw items that look good, they get discouraged. This past week I…
Power Tools is an addon for Google Sheets that automates a ton of workflows. Instead of writing and troubleshooting functions, Power Tools can do it for you. Some of its features include splitting cells based on any delimiter or position (were you handed a spreadsheet with full name in column A but you need the…
I use conditional formatting for individual cells quite a bit. What’s nice is that conditional formatting can also highlight rows in Google Sheets, which is very possible! Some ways this is useful is when you are analyzing student scores. You can mark rows where the student is proficient in green, where the student is borderline…
New Visions for Public Schools has published some great addons in the past (such as Doctopus and autoCrat) and they have another winner with FormRedirector. This addon allows you to redirect Google Form responses to different spreadsheets. There are two modes, Multi Destination Mode and Single Destination Mode. Multi Destination Mode Multi Destination Mode allows you to collect responses to additional…
There are times when you are using a Google Sheet, such as collecting information in a form, where you would like highlight the minimum and maximum cell in a column. Google Sheets offers conditional formatting, which gives you the ability to change the formatting of a cell based on the contents of the cell. For…
Yesterday’s post was all about launching Chrome apps from the toolbar. But what if you want to start a new document in Google Drive from the toolbar? Sure, you can use AppJump to launch Docs, Slides, or Sheets, but then you’re still stuck hitting the + in the lower right to create the document. There are two…
Having copies of a list of students in your classroom can come in very handy, so I played around with Google Sheets and came up with Classroom Student Check List. The sheet gives you four separate lists that you can cut apart and use. New students To add students to the list, you don’t have…
There are a couple of different ways to schedule equipment when you’re a Google Apps for Education school. One is to have the GAFE administrator create Google Calendar Resources that can then be scheduled with Google Calendar. This method works really well, but its biggest issue is that staff have to schedule by time, not…