I led a session on Google Sheets for the Classroom today at #edcamp918. These are the notes from that session. Where most of the information does not translate well into notes, I have included links to resources we discussed. Hope this is helpful to those who are looking for new tools and uses for Google Sheets.
Find More Tutorial Videos on http://www.techycoach.com
Conditional Formatting & Data Validation –
- Learn how to create Drop Down menus and color coding to Cells in Google Sheets- https://www.youtube.com/watch?v=m2FuBlS26X8
AddOns –
- PowerTools – includes many formulas and tools that you may be used to in Excel, in a quick and easy format for use.- https://chrome.google.com/webstore/detail/power-tools/dofhceeoedodcaheeoacmadcpegkjobi?utm_source=permalink
- Site Maestro – This AddOn for Sheets allows users to set up Google Sites for students to use for a blogging project. You can then manage all the student sites from one Google Sheet. Watch this video as it explains more and shows the setup process. You need to be familiar with Google Sites to use this- https://www.youtube.com/watch?v=EuSwkxn231o – Hereis the link to this add on – https://chrome.google.com/webstore/detail/sitemaestro/fglgeojebndnpgifmeblakabibdceenb?utm_source=permalink
- Lab Scheduler – This AddOn for Sheets allows users to create a schedule for a resource such as a computer lab or Chromebook Cart using a Google Sheet https://chrome.google.com/webstore/detail/lab-scheduler/cemjoabjlomdmkfllikpdjlobefbpmod?utm_source=permalink
The Techy Coach 